mysql doesn't save player info - 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 doesn't save player info (
/showthread.php?tid=526329)
mysql doesn't save player info -
magent - 16.07.2014
I gets no error when i compile it. But when i reconnect i have to register again ¤_¤
Here is the Code when the player register:
Код:
stock RegisterPlayer(playerid, regpass[])
{
new query[126], EncryptedPass[130];
WP_Hash(EncryptedPass, sizeof(EncryptedPass), regpass);
format(query, sizeof(query), "INSERT INTO accounts (Name, Password, PosX, PosY, PosZ, Skin) VALUES ('%s', '%s', '1.0 2.0 3.0', '1')", GetName(playerid), EncryptedPass);
mysql_query(query);
LoginPlayer(playerid);
return 1;
}
This is the code where it loads the players information.
Код:
stock LoginPlayer(playerid)
{
new query[126], pName[MAX_PLAYER_NAME];
GetPlayerName(playerid, pName, sizeof(pName));
format(query, sizeof(query), "SELECT * FROM players WHERE Name = '%s'", pName);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(query, "id"); PlayerInfo[playerid][ID] = strval(query);
mysql_fetch_field_row(PlayerInfo[playerid][Name], "Name");
mysql_fetch_field_row(PlayerInfo[playerid][Password], "Password");
mysql_fetch_field_row(query, "AdminLevel"); Player[playerid][AdminLevel] = strval(query);
mysql_fetch_field_row(query, "PlayerPos"); sscanf(query, "fff", Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2]);
mysql_fetch_field_row(query, "Skin"); Player[playerid][Skin] = strval(query);
mysql_fetch_field_row(query, "Money"); Player[playerid][Money] = strval(query);
mysql_fetch_field_row(query, "Deaths"); Player[playerid][pDeaths] = strval(query);
mysql_fetch_field_row(query, "Kills"); Player[playerid][pKills] = strval(query);
mysql_fetch_field_row(query, "Vip"); Player[playerid][vStatus] = strval(query);
}
GivePlayerMoney(playerid, Player[playerid][Money]);
SetSpawnInfo(playerid, 0, 1, Player[playerid][Position][0], Player[playerid][Position][1], Player[playerid][Position][2], 0, 0, 0, 0, 0, 0, 0);
}
Re: mysql doesn't save player info -
Vince - 16.07.2014
Your insert query is wrong. PosX/Y/Z are supposed to be separate parameters. Also don't enclose numbers in quotes.
Next time, enable MySQL logging and read it when something goes wrong.
Re: mysql doesn't save player info -
magent - 16.07.2014
ok thanks m8 =)