08.12.2011, 17:24
Try this:
About the error? what line?
Edit: Do you get any error in the MySQL debug log?
pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
new Float:X, Float:Y, Float:Z, string[110];
GetPlayerPos(playerid, Float:X, Float:Y, Float:Z);
format(string, sizeof(string), "UPDATE Users SET X = '%f', Y = '%f', Z = '%f' WHERE Name = '%s'", X, Y, Z, UserStats[playerid][Name]);
mysql_query(string);
SavePlayer(playerid);
UserStats[playerid][Admin] = 0;
UserStats[playerid][Money] = 0;
AccountExists[playerid] = 0;
PlayerLogged[playerid] = 0;
return 1;
}
public OnPlayerSpawn(playerid)
{
new string[65], load[50];
format(string, sizeof(string), "SELECT X, Y, Z FROM Users WHERE Name = '%s'", UserStats[playerid][Name]);
mysql_query(string);
mysql_store_result();
if(mysql_num_rows() != 0 && mysql_fetch_row(load))
{
sscanf(load, "p<|>fff", UserStats[playerid][X], UserStats[playerid][Y], UserStats[playerid][Z]);
SetPlayerPos(playerid, UserStats[playerid][X], UserStats[playerid][Y], UserStats[playerid][Z]);
}
mysql_free_result();
return 1;
}
SavePlayer(playerid)
{
if(!PlayerLogged[playerid]) return 0;
UserStats[playerid][Money] = GetPlayerMoney(playerid);
CheckMySQL();
new string[256];
format(string, sizeof(string), "UPDATE Users SET Password='%s',Admin='%d',Money='%d' WHERE Name='%s'", UserStats[playerid][Password], UserStats[playerid][Admin], UserStats[playerid][Money], UserStats[playerid][Name]);
mysql_query(string);
}
Edit: Do you get any error in the MySQL debug log?