[Shinja]

PHP код:

SavePlayer(playerid)
{
    CheckMySQL();
    new string[1056];
    format(string, sizeof(string), "UPDATE 'Users' SET Kills = %d, Deaths = %d, Score = %d, Money = %d, Headshots = %d, Admin = %d, Vip = %d, Total Captures = %d, Highest Kill Spree = %d, Highest Cap Spree = %d WHERE Name = '%s'", pKills[playerid], pDeaths[playerid], GetPlayerScore(playerid), GetPlayerMoney(playerid), pHead[playerid], pAdmin[playerid], pVip[playerid], pTCap[playerid], pHSpree[playerid], pHCap[playerid], GetName(playerid));
    mysql_query(string);
    return 1;
} 


Not saving, help

[Stuntff]

mysql log please and witch mysql version you using ?

[Shinja]

Nothing in the logs, When i made it to save only Kills/deaths/score/money it worked

[Konstantinos]

As long as the column's name has space(s), wrap it around with grave accent like:
`Total Captures`
` Highest Kill Spree`
etc..

[Shinja]

Changed to

PHP код:

SavePlayer(playerid)
{
    CheckMySQL();
    new string[1056];
    format(string, sizeof(string), "UPDATE 'Users' SET 'Kills' = %d, 'Deaths' = %d, 'Score' = %d, 'Money' = %d, 'Headshots' = %d, 'Admin' = %d, 'Vip' = %d, 'Total Captures' = %d, 'Highest Kill Spree' = %d, 'Highest Cap Spree' = %d WHERE 'Name' = '%s'", pKills[playerid], pDeaths[playerid], GetPlayerScore(playerid), GetPlayerMoney(playerid), pHead[playerid], pAdmin[playerid], pVip[playerid], pTCap[playerid], pHSpree[playerid], pHCap[playerid], GetName(playerid));
    mysql_query(string);
    return 1;
} 


Still not saving

[Gforcez]

Код:

 `Highest Kill Spree` = %d, `Highest Cap Spree` = %d

You need ` instead of '

[Konstantinos]

That is apostrophe ' that you used which is incorrect, I said grave accent ` character. Just use it to those columns that have more than 1 word in the name, it is not needed to the rest.

[Shinja]

and

PHP код:

WHERE Name = `%s` 


? or..

[Konstantinos]

No, at column's name only. Specifiers (strings only) must have apostrophes such '%s' or '%e' (escaped).

And 'Users' for the table is incorrect. Either `Users` or Users (without anything).

[SyS]

PHP код:

format(string, sizeof(string), "UPDATE Users SET Kills = %d, Deaths = %d, Score = %d, Money = %d, Headshots = %d, Admin = %d, Vip = %d, `Total Captures` = %d, `Highest Kill Spree` = %d, `Highest Cap Spree` = %d WHERE Name = '%s'", pKills[playerid], pDeaths[playerid], GetPlayerScore(playerid), GetPlayerMoney(playerid), pHead[playerid], pAdmin[playerid], pVip[playerid], pTCap[playerid], pHSpree[playerid], pHCap[playerid], GetName(playerid)); 


It should be like that ` on columns and ' on specifiers like '%s' and '%e'