Mysql klausimas dėl vartotojo :/

[#Karolis]

Žodžiu naudoju localhost'ą ir kai užsiregistruoju serveryje viskas ok atsiranda vartotojas duomenų bazėje. Bet va klausimas kaip redaguoti žaidėją arba jį ištrinti ?

[#Edvinass]

User >> Randi Acc >> Delete

[#Edvinass]

PER GM Jieskok TEN USER TURI BUT

[Micso]

PER GM Jieskok TEN USER TURI BUT

Ne nu tu logiškesnio atsakymo negalėjai parašyti :DD

Redaguota Vasario 8, 2014, nario Micso

[#Karolis]

PER GM Jieskok TEN USER TURI BUT

Žinai kas yra MySQL ? Atrodo jog skaitė bet nesuprato ką skaitė žmogus :/

[#Karolis]

Ir dar va klausimas ar krovimas ar saugojimas nesuveikia nes kažkas ne taip pas mane :/ Saugojimas :

stock SaugotiInfo(playerid)
{
	new query[180], Float:pos[3];
	GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
	format(query,sizeof(query),"UPDATE zaidejai SET Pinigai = %d, Xp = %d, Hp = %f, Pos_X = %f, Pos_Y = %f, Pos_Z = %d WHERE ID = %d",pinfo[playerid][Pinigai], pinfo[playerid][Xp], pinfo[playerid][Hp], pinfo[playerid][ID], pos[0], pos[1], pos[2]);
	mysql_query(query);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
SaugotiInfo(playerid);
return 1;
}

Krovimas :

stock KrautiInfo(playerid)
{
	new query[150];
	format(query,sizeof(query),"SELECT * FROM zaidejai WHERE Vardas = '%s'",PlayerName(playerid));
	mysql_query(query);
	mysql_store_result();
	if(mysql_retrieve_row())
	{
	    new tmp[64];
    	new Float:pos[3];
		GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
	    mysql_fetch_field_row(tmp,"ID"); pinfo[playerid][ID] = strval(tmp);
	    mysql_fetch_field_row(pinfo[playerid][Vardas],"Vardas");
	    mysql_fetch_field_row(tmp,"Pinigai"); pinfo[playerid][Pinigai] = strval(tmp);
	    mysql_fetch_field_row(tmp,"Xp"); pinfo[playerid][Xp] = strval(tmp);
	    mysql_fetch_field_row(tmp,"Hp"); pinfo[playerid][Hp] = floatstr(tmp);
	    mysql_fetch_field_row(tmp,"Pos_X"); pos[0] = floatstr(tmp);
	    mysql_fetch_field_row(tmp,"Pos_Y"); pos[1] = floatstr(tmp);
	    mysql_fetch_field_row(tmp,"Pos_Z"); pos[2] = floatstr(tmp);
	}
	mysql_free_result();
	return 1;
}

public OnPlayerSpawn(playerid)
{
KrautiInfo(playerid);
return 1;
}

MySQL log'as :

[01:44:10] >> mysql_connect( )

[01:44:10] CMySQLHandler::CMySQLHandler() - constructor called.

[01:44:10] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "testui" | Username: "root" ...

[01:44:10] CMySQLHandler::Connect() - Connection was successful.

[01:44:10] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[01:44:10] >> mysql_ping( Connection handle: 1 )

[01:44:10] CMySQLHandler::Ping() - Connection is still alive.

[01:44:50] >> mysql_query( Connection handle: 1 )

[01:44:51] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Jamaika_Solutionas') - Successfully executed.

[01:44:51] >> mysql_store_result( Connection handle: 1 )

[01:44:51] CMySQLHandler::StoreResult() - Result was stored.

[01:44:51] >> mysql_num_rows( Connection handle: 1 )

[01:44:51] CMySQLHandler::NumRows() - Returned 1 row(s)

[01:44:51] >> mysql_free_result( Connection handle: 1 )

[01:44:51] CMySQLHandler::FreeResult() - Result was successfully free'd.

[01:45:05] >> mysql_query( Connection handle: 1 )

[01:45:05] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Jamaika_Solutionas' AND Slaptazodis = 'labukas') - Successfully executed.

[01:45:05] >> mysql_store_result( Connection handle: 1 )

[01:45:05] CMySQLHandler::StoreResult() - Result was stored.

[01:45:05] >> mysql_num_rows( Connection handle: 1 )

[01:45:05] CMySQLHandler::NumRows() - Returned 1 row(s)

[01:45:05] >> mysql_free_result( Connection handle: 1 )

[01:45:05] CMySQLHandler::FreeResult() - Result was successfully free'd.

[01:45:07] >> mysql_query( Connection handle: 1 )

[01:45:07] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Jamaika_Solutionas') - Successfully executed.

[01:45:07] >> mysql_store_result( Connection handle: 1 )

[01:45:07] CMySQLHandler::StoreResult() - Result was stored.

[01:45:07] >> mysql_retrieve_row( Connection handle: 1 )

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("ID") - 0

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Vardas") - Jamaika_Solutionas

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Pinigai") - 0

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Xp") - 0

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Hp") - 0

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Pos_X") - 0

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Pos_Y") - 0

[01:45:07] >> mysql_fetch_field_row( Connection handle: 1 )

[01:45:07] CMySQLHandler::FetchField("Pos_Z") - 0

[01:45:07] >> mysql_free_result( Connection handle: 1 )

[01:45:07] CMySQLHandler::FreeResult() - Result was successfully free'd.

[01:45:24] >> mysql_query( Connection handle: 1 )

[01:45:24] CMySQLHandler::Query(UPDATE zaidejai SET Pinigai = 0, Xp = 0, Hp = 0.000000, Pos_X = 0.000000, Pos_Y = 2045.497802, Pos_Z = 1151417015 WHERE ID = 1093320704) - Successfully executed.

Vardą išsaugo, slaptažodį išsaugo, bet toliau nieko neišsaugo nei pozicijos :/

Redaguota Vasario 8, 2014, nario *Jamaika

[Drye']

Dėl edit tai turi būti užrašas redaguoti arba edit, o jei nėra reikia, kad struktūroje būtų A_I ( automatinis didėjimas ). Juo gali būti pvz:. ID.

[#Karolis]

Nu ką žinau pirmą kartą naudoju MySQL

Nieko čia nėra

Redaguota Vasario 9, 2014, nario *Jamaika

[Drye']

paspausk struktūra, tada edit ID, ir susirandi A_I ir uždedi varnelę.

[bebras]

Negera saugojimo užklausa... Viskas turi eiti nuosekliai.

format(query,sizeof(query),"UPDATE zaidejai SET Pinigai = %d, Xp = %d, Hp = %f, Pos_X = %f, Pos_Y = %f, Pos_Z = %d WHERE ID = %d",
	pinfo[playerid][Pinigai], pinfo[playerid][Xp], pinfo[playerid][Hp], pos[0], pos[1], pos[2],pinfo[playerid][ID]);

Jeigu paskutinis %d yra ID, tai ir paskutinis kintamasis turi būti ID.