MySQL doesn't save player. - Printable Version

MySQL doesn't save player. - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL doesn't save player. (/showthread.php?tid=256158)

MySQL doesn't save player. - Feli97 - 19.05.2011

Hi all, I've a problem..
I can't save Account Data.
Can you help me, plis? ;(
What's wrong with this script code?

Код:

function SavePlayerAccount(playerid) {
	new
		    queryString[1424];
    GetPlayerName(playerid, pname, sizeof(pname));
    GetPlayerHealth(playerid, AccountData[playerid][pHealth]);
    GetPlayerArmour(playerid, AccountData[playerid][pArmour]);
    format(queryString, sizeof(queryString), "UPDATE users SET Money = '%d', CurrentHealth = '%f', Bank = '%d', Level = '%d', HouseKey = '%d', BusinessKey = '%d', Rope = '%d', Cigar = '%d', HasGlasses = '%d', HasMask = '%d' WHERE Name = '%s'",
	GetPlayerMoney(playerid), AccountData[playerid][pHealth], PlayerAccount[playerid][Bank], PlayerAccount[playerid][Level],PlayerAccount[playerid][HouseKey],PlayerAccount[playerid][BizKey],PlayerAccount[playerid][Rope],PlayerAccount[playerid][Cigarettes], PlayerAccount[playerid][HasGlasses], PlayerAccount[playerid][HasMask], pname);
    mysql_query(queryString, SQL_SAVE_ACCOUNT, playerid, RegistrationSystemConnection);
    print(queryString);
}

P.S. Sorry for bad english.

Re: MySQL doesn't save player. - Alby Fire - 19.05.2011

Show us the mysql debug log and tell us wich plugin are you using... strickenkid's or G-Stylezzz's one.

By the way imo 1424 cells for that query are too many.. 500 or 700 should be enaugh.

Re: MySQL doesn't save player. - Feli97 - 19.05.2011

I'm using G-sTyLeZzZ's one..

Re: MySQL doesn't save player. - Feli97 - 19.05.2011

This is one part of the Mysql_log

Код:

[16:57:28] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:57:30] >> mysql_real_escape_string( Connection handle: 1 )

[16:57:30] CMySQLHandler::EscapeString(felixtheking); - Escaped 12 characters to felixtheking.

[16:57:30] >> mysql_query( Connection handle: 1 )

[16:57:30] CMySQLHandler::Query(SELECT * FROM users WHERE Name = 'Felix_Scaglietti' AND password_hash = 546505987) - Successfully executed.

[16:57:30] >> mysql_store_result( Connection handle: 1 )

[16:57:30] CMySQLHandler::StoreResult() - Result was stored.

[16:57:30] >> mysql_num_rows( Connection handle: 1 )

[16:57:30] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:57:30] >> mysql_real_escape_string( Connection handle: 1 )

[16:57:30] CMySQLHandler::EscapeString(Felix_Scaglietti); - Escaped 16 characters to Felix_Scaglietti.

[16:57:30] >> mysql_query( Connection handle: 1 )

[16:57:30] CMySQLHandler::Query(SELECT * FROM `users` WHERE `Name` = 'Felix_Scaglietti') - Successfully executed.

[16:57:30] >> mysql_store_result( Connection handle: 1 )

[16:57:30] CMySQLHandler::StoreResult() - Result was stored.

[16:57:30] >> mysql_fetch_row_format( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchRow() - Return: 106682|Felix_Scaglietti|546505987|17|3|0|46|24|1|1|0|0|0|1612|10|6|9756|1|2|0|0|0|0|0|0|0|72|1|1|1|151.67.41.81|13|34099169|1|2|3|0|0|0|0|0|0|0|0|0|0|161|1|1|0|0|0|0|0|0|0|0|0|0|2|0|999|0,0,3,1,24,40,0,0,29,120,31,130,0,0,0,0,17,1,43,50,0,0,0,0,0,0|1|1|1|1|2092.62|2051.22|10.8203|151.021|0|0|43|0|1|46|2|5|0|0

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("Money") - 9756

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("CurrentHealth") - 43

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("Level") - 17

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("HouseKey") - 0

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("BizKey") - 999

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("Cigar") - 0

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("Rope") - 2

[16:57:30] >> mysql_fetch_field_row( Connection handle: 1 )

[16:57:30] CMySQLHandler::FetchField("HasGlasses") - 1

Re: MySQL doesn't save player. - MadeMan - 19.05.2011

Show the lines with "UPDATE users SET Money..."

Re: MySQL doesn't save player. - Alby Fire - 19.05.2011

Maybe these functions you insert in the mysql_query:

pawn Код:

mysql_query(queryString, SQL_SAVE_ACCOUNT, playerid, RegistrationSystemConnection);

Are wrong... try to execute your query with only the formatted string:

pawn Код:

mysql_query(queryString):

Re: MySQL doesn't save player. - Feli97 - 19.05.2011

I tried but it is still not working..

Re: MySQL doesn't save player. - Feli97 - 19.05.2011

Quote:

Originally Posted by MadeMan

Show the lines with "UPDATE users SET Money..."

What ? This?

Код:

[15:19:26] CMySQLHandler::Query(UPDATE `users` SET `Money` = '9766', `CurrentHealth` = '43.000000', `Bank` = '0', `Level` = '17', `HouseKey` = '0', `BusinessKey` = '999', `Rope` = '2', `Cigar` = '0', `HasGlasses` = '1', `HasMask` = '0' WHERE `Name` = 'Felix_Scaglietti') - An error has occured. (Error ID: 1054, Unknown column 'BusinessKey' in 'field list')

Re: MySQL doesn't save player. - MadeMan - 19.05.2011

Quote:

Originally Posted by Feli97

What ? This?

Код:

[15:19:26] CMySQLHandler::Query(UPDATE `users` SET `Money` = '9766', `CurrentHealth` = '43.000000', `Bank` = '0', `Level` = '17', `HouseKey` = '0', `BusinessKey` = '999', `Rope` = '2', `Cigar` = '0', `HasGlasses` = '1', `HasMask` = '0' WHERE `Name` = 'Felix_Scaglietti') - An error has occured. (Error ID: 1054, Unknown column 'BusinessKey' in 'field list')

Yes, you can see the error in the end.

Re: MySQL doesn't save player. - Feli97 - 19.05.2011

I resolved this problem.. thank you anyway