17.08.2018, 10:34
For some reason my MYSQL is not saving player stats properly. Instead of saving what I'm actually trying to output, it only saves "0"'s.
PHP код:
stock SavePlayerStats(playerid)
{
new query[1000], query2[1000];
format(query, sizeof(query), "UPDATE `accounts` SET `playerCash` = '%d', `playerAdmin` = '%d', `playerMod` = '%d', `playerHelper` = '%d', `playerLevel` = '%d' WHERE `playerName` = '%s'", GetPlayerMoney(playerid), playerInfo[playerid][playerAdmin],playerInfo[playerid][playerMod],playerInfo[playerid][playerHelper],GetPlayerScore(playerid), playerInfo[playerid][playerName]);
mysql_tquery(Database, query);
format(query, sizeof(query2), "UPDATE `accounts` SET `playerAge` = '%d', `playerGend` = '%d', `playerSkin` = '%d'", playerInfo[playerid][playerAge],playerInfo[playerid][playerGend], playerInfo[playerid][playerSkin], playerInfo[playerid][playerName]);
mysql_tquery(Database, query2);
printf("Player saved.");
}