[Pawn] How to save player stats in mysql?

[CrypticSin]

stats with coordinate? https://www.youtube.com/watch?v=KNj2O6c9-uo

The only thing i've done so far is creating a stock for saving user stats.?



I don't know what to do from this point after as it's still not storing the data in mysql (phpmyadmin)



When i run the code, im not getting any errors on but im getting two warning stating: "number of arguments does not match definition"

PHP Code:

stock SaveUserStats(playerid)

{



new Float:x,Float:y,Float:z;

GetPlayerPos(playerid,Float:x,Float:y,Float:z);



if(PlayerInfo[playerid][pLoggedIn] == true)

{

PlayerInfo[playerid][pX] = x;

PlayerInfo[playerid][pY] = y;

PlayerInfo[playerid][pZ] = z;

}



new query[256];

? strcat(query, "UPDATE `playerinfo` SET `skin` = '%d', `score` = '%d', `money` = '%d', `murders` = '%d', `zombieskilled` = '%d', `health` = '%d', `armour` = '%d',`deaths` = '%d', `hunger` = '%d', `thirst` = '%d', `pX` = '%i', `pY` = '%i', `pZ` = '%i',? WHERE 'acc_name' = '%e'");

format(query, sizeof(query), query, PlayerInfo[playerid][pSkin],

PlayerInfo[playerid][pScore],

PlayerInfo[playerid][pMoney],

PlayerInfo[playerid][pKills],

PlayerInfo[playerid][pZombiesKilled],

PlayerInfo[playerid][pHealth],

PlayerInfo[playerid][pArmour],

PlayerInfo[playerid][pDeaths],

PlayerInfo[playerid][pHunger],

PlayerInfo[playerid][pX],

PlayerInfo[playerid][pY],

PlayerInfo[playerid][pZ],

GetPlayerName(playerid));

mysql_tquery(handle, query, "", "");

printf("%s", query);

return 1;

}