public OnPlayerDisconnect(playerid, reason)
{
new
query[128],
Float:pos[4],
name[24],
score;
GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
GetPlayerFacingAngle(playerid, pos[3]);
GetPlayerName(playerid, name, 24);
GetPlayerScore(playerid, Player[playerid][Score]);
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `Money` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f WHERE `ID` = %d",
GetPlayerMoney(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
mysql_format(mysql, query, sizeof query, "UPDATE 'accounts' SET 'Score' = '%i' WHERE 'Name' = '%s'", score, name);
mysql_tquery(mysql, query, "", "");
return true;
}
GetPlayerScore(playerid, Player[playerid][Score]);
Player[playerid][Score] = GetPlayerScore(playerid);
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'",GetPlayerMoney(playerid),GetPlayerScore(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
I got it working already, I think:
PHP код:
|
Can i know why?
How he did will get it updated and everything fine. |
Player[playerid][Score] = GetPlayerScore(playerid);
Player[playerid][Money] = GetPlayerMoney(playerid);
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET Money='%d',Score='%i',PosX`='%f',PosY='%f',PosZ='%f',PosA='%f' WHERE ID='%d'", Player[playerid][Money], Player[playerid][Score], pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
This would be better:
PHP код:
|