Dar vienas klausimas su saugojimu

[HJones]

Sveiki, turbūt jus visus įkyrėjau, bet vėl atsitiko bėda Atrodau kvailai, bet ką padarysi, su registracijom niekada nedraugavau.

Taigi dabar viskas ok, saugo/krauna, bet krauna kažkaip keistai... Skaitykim prieš atsijungdamas turiu skin ID 299, o kaip prisijungiu turiu skinid 50 xD

 

šiek tiek logų:

[22:49:03] >> mysql_query( Connection handle: 1 )

[22:49:03] CMySQLHandler::Query(UPDATE zaidejai SET skin = '299', pinigai = '20000', patirtis = '1000' WHERE vardas = 'Harry_Jones') - Successfully executed.

[22:49:31] >> mysql_query( Connection handle: 1 )

[22:49:31] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Harry_Jones') - Successfully executed.

[22:49:31] >> mysql_store_result( Connection handle: 1 )

[22:49:31] CMySQLHandler::StoreResult() - Result was stored.

[22:49:31] >> mysql_num_rows( Connection handle: 1 )

[22:49:31] CMySQLHandler::NumRows() - Returned 1 row(s)

[22:49:31] >> mysql_free_result( Connection handle: 1 )

[22:49:31] CMySQLHandler::FreeResult() - Result was successfully free'd.

[22:49:33] >> mysql_real_escape_string( Connection handle: 1 )

[22:49:33] CMySQLHandler::EscapeString(labas); - Escaped 5 characters to labas.

[22:49:33] >> mysql_query( Connection handle: 1 )

[22:49:33] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Harry_Jones' AND slaptazodis = 'labas') - Successfully executed.

[22:49:33] >> mysql_store_result( Connection handle: 1 )

[22:49:33] CMySQLHandler::StoreResult() - Result was stored.

[22:49:33] >> mysql_num_rows( Connection handle: 1 )

[22:49:33] CMySQLHandler::NumRows() - Returned 0 row(s)

[22:49:33] >> mysql_free_result( Connection handle: 1 )

[22:49:33] CMySQLHandler::FreeResult() - Result was successfully free'd.

[22:49:34] >> mysql_real_escape_string( Connection handle: 1 )

[22:49:34] CMySQLHandler::EscapeString(hjones); - Escaped 6 characters to hjones.

[22:49:34] >> mysql_query( Connection handle: 1 )

[22:49:34] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Harry_Jones' AND slaptazodis = 'hjones') - Successfully executed.

[22:49:34] >> mysql_store_result( Connection handle: 1 )

[22:49:34] CMySQLHandler::StoreResult() - Result was stored.

[22:49:34] >> mysql_num_rows( Connection handle: 1 )

[22:49:34] CMySQLHandler::NumRows() - Returned 1 row(s)

[22:49:35] >> mysql_query( Connection handle: 1 )

[22:49:35] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE vardas = 'Harry_Jones') - Successfully executed.

[22:49:35] >> mysql_store_result( Connection handle: 1 )

[22:49:35] CMySQLHandler::StoreResult() - Result was stored.

[22:49:35] >> mysql_fetch_row_format( Connection handle: 1 )

[22:49:35] CMySQLHandler::FetchRow() - Return: 8|Harry_Jones|hjones|299|20000|1000|0|0|0

[22:49:35] >> mysql_fetch_field_row( Connection handle: 1 )

[22:49:35] CMySQLHandler::FetchField("skin") - 299

[22:49:35] >> mysql_fetch_field_row( Connection handle: 1 )

[22:49:35] CMySQLHandler::FetchField("patirtis") - 1000

[22:49:35] >> mysql_fetch_field_row( Connection handle: 1 )

[22:49:35] CMySQLHandler::FetchField("pinigai") - 20000

[22:49:35] >> mysql_fetch_row_format( Connection handle: 1 )

[22:52:55] >> mysql_query( Connection handle: 1 )

[22:52:55] CMySQLHandler::Query(UPDATE zaidejai SET skin = '50', pinigai = '50', patirtis = '48' WHERE vardas = 'Harry_Jones') - Successfully executed.

jei reikės saugojimo/krovimo rašykit.

kas padės išspręsti bėdą gaus +rep xd

Redaguota Balandžio 22, 2015, nario .lukonic`
Neinformatyvus temos pavadinimas

[Brightukas]

[22:52:55] CMySQLHandler::Query(UPDATE zaidejai SET skin = '50', pinigai = '50', patirtis = '48' WHERE vardas = 'Harry_Jones') - Successfully executed.

 

tvarkykis cia

[HJones]

[22:52:55] CMySQLHandler::Query(UPDATE zaidejai SET skin = '50', pinigai = '50', patirtis = '48' WHERE vardas = 'Harry_Jones') - Successfully executed.

 

tvarkykis cia

hm, niekaip galva nebeišneša kaip.

bandžiau įvairius būdus, bet huj.

[Justac]

Parodyk patį kodą.

[HJones]

Saugojimas:

stock SaugotiZaideja(playerid)
{
new Uzklausa[128], zVardas[MAX_PLAYER_NAME], ip[16];
GetPlayerName(playerid, zVardas, sizeof(zVardas));
GetPlayerIp(playerid, ip, sizeof(ip));

format(Uzklausa, sizeof(Uzklausa), "UPDATE `zaidejai` SET `skin` = '%d', `patirtis` = '%d', `pinigai` = '%d' WHERE `vardas` = '%s'", playerData[playerid][pSkin], playerData[playerid][pPatirtis], playerData[playerid][pPinigai], zVardas);
mysql_query(Uzklausa);
printf("[gRPG.pwn]: Žaidėjas %s (IP: %s) sėkmingai išsaugotas!", zVardas, ip);
return 1;
}

Krovimas:

stock KrautiZaideja(playerid)
{
	new Uzklausa[128], zVardas[MAX_PLAYER_NAME], ip[16];
	GetPlayerName(playerid, zVardas, sizeof(zVardas));
	GetPlayerIp(playerid, ip, sizeof(ip));
	
	format(Uzklausa, sizeof(Uzklausa), "SELECT * FROM zaidejai WHERE vardas = '%s'", zVardas);
	mysql_query(Uzklausa);
	mysql_store_result();
	
	while(mysql_fetch_row_format(Uzklausa, "|"))
	{
 	mysql_fetch_field_row(playerData[playerid][pSkin], "skin");
	mysql_fetch_field_row(playerData[playerid][pPatirtis], "patirtis");
 	mysql_fetch_field_row(playerData[playerid][pPinigai], "pinigai");
	}
 	SetPlayerSkin(playerid, playerData[playerid][pSkin]);
 	SetPlayerScore(playerid, playerData[playerid][pPatirtis]);
 	SetPlayerMoney(playerid, playerData[playerid][pPinigai]);
	printf("[gRPG.pwn]: Žaidėjas %s (IP: %s) sėkmingai užkrautas!", zVardas, ip);
	return 1;
}

[mindux9]

o tu bent nuresetini visus tuos playerData[playerid][...] kai atsijunge?

[HJones]

Viską susitvarkiau, čiki piki.

Rakinkit.