Mysql not save score and money - 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)
+--- Thread: Mysql not save score and money (/showthread.php?tid=542799)
+- 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)
+--- Thread: Mysql not save score and money (/showthread.php?tid=542799)
Mysql not save score and money - Ryz - 22.10.2014
i am using mysql saving system but
Money and score not saving
pawn Код:
stock MySQL_Login(playerid)
{
new Query[1000];
mysql_real_escape_string(PlayerInfo[playerid][Nick], PlayerInfo[playerid][Nick]);
format(Query, sizeof(Query), "SELECT * FROM `playerdata` WHERE `nick` COLLATE latin1_general_cs = '%s' LIMIT 1", PlayerInfo[playerid][Nick]);
mysql_query(Query);
mysql_store_result();
while(mysql_fetch_row(Query))
{
mysql_fetch_int("id", PlayerInfo[playerid][ID]);
mysql_fetch_int("admin", PlayerInfo[playerid][Level]);
mysql_fetch_int("score", PlayerInfo[playerid][pScore]);
SetPlayerScore(playerid, PlayerInfo[playerid][pScore]);
mysql_fetch_int("money", PlayerInfo[playerid][Money]);
GivePlayerMoney(playerid, PlayerInfo[playerid][Money]);
mysql_fetch_int("kills", PlayerInfo[playerid][Kills]);
mysql_fetch_int("deaths", PlayerInfo[playerid][Deaths]);
mysql_fetch_int("banned", PlayerInfo[playerid][banned]);
mysql_fetch_int("Donor", PlayerInfo[playerid][dRank]);
mysql_fetch_int("Pilot", PlayerInfo[playerid][pPilot]);
mysql_fetch_int("NavyPilot", PlayerInfo[playerid][jPilot]);
mysql_fetch_int("Helper", PlayerInfo[playerid][Helper]);
}
mysql_free_result();
PlayerInfo[playerid][LoggedIn] = 1;
return 1;
}
Re: Mysql not save score and money - UnknownGamer - 22.10.2014
Mate, this is not MYSQL Saving. This is MYSQL Loading... Look at the query line...
"SELECT * FROM BLALALALALAL WHERE id = dbID" for example.
MySQL saving is: "UPDATE samp_users SET name='lol', hp='0' WHERE id = pdbID"
Re: Mysql not save score and money - Ryz - 22.10.2014
Opps my bad
I have stock save player, here is he
pawn Код:
SavePlayer(playerid)
{
if(PlayerInfo[playerid][LoggedIn] == 1)
{
new Query[1000];
format(Query, 1000, "UPDATE `playerdata` SET `admin` = '%d', `score` = '%d', `money` = '%d', `kills` = '%d', `deaths` = '%d', `banned` = '%d', `Donor` = '%d', `Pilot` = '%d', `NavyPilot` = '%d', `Helper` = '%d' WHERE `id` = '%d' LIMIT 1",
PlayerInfo[playerid][Level],
PlayerInfo[playerid][pScore],
PlayerInfo[playerid][Money],
PlayerInfo[playerid][Kills],
PlayerInfo[playerid][Deaths],
PlayerInfo[playerid][banned],
PlayerInfo[playerid][dRank],
PlayerInfo[playerid][pPilot],
PlayerInfo[playerid][jPilot],
PlayerInfo[playerid][Helper],
PlayerInfo[playerid][ID]);
mysql_query(Query);
}
}
Re: Mysql not save score and money - UnknownGamer - 22.10.2014
Quote:
|
Originally Posted by Ryz
 Opps my bad
I have stock save player, here is he pawn Код:
|
Re: Mysql not save score and money - Ryz - 22.10.2014
Quote:
|
Do you have a MySQL Log? |