[TwinkiDaBoss]

Okay so I got some issues with this code. Its simply not being saved properly.

pawn Код:

new Float:pos[3];
    GetPlayerPos(playerid, pos[0], pos[1], pos[2]);

    new query[1024] = "UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Reputation`=%d, `posX`=%f, `posY`=%f, `posZ`=%f, `Score`=%d, `Deaths`=%d, `Kills`=%d, `Banned`=%d, `Kicks`=%d";
    strcat(query,", EquipmentM4`=%d,`EquipmentAK47`=%d,`EquipmentDeagle`=%d,`EquipmentKnife`=%d,`Equipment9MM`=%d,`EquipmentShotgun`=%d,`EquipmentUzi`=%d WHERE `ID`=%d");

    format(query, sizeof(query), query,pInfo[playerid][Admin], pInfo[playerid][VIP], pInfo[playerid][Reputation], pos[0], pos[1], pos[2], pInfo[playerid][Score],pInfo[playerid][Deaths],
    pInfo[playerid][Kills],pInfo[playerid][Banned],pInfo[playerid][Kicks],pInfo[playerid][EquipmentM4],pInfo[playerid][EquipmentAK47],
    pInfo[playerid][EquipmentDeagle],pInfo[playerid][EquipmentKnife],pInfo[playerid][Equipment9MM],pInfo[playerid][EquipmentShotgun],pInfo[playerid][EquipmentUzi],pInfo[playerid][ID]);

    mysql_tquery(mysql, query, "", "");
    print(query);

Ive printed it out and this is the result

pawn Код:

[00:59:20] UPDATE `players` SET `Admin`=7, `VIP`=0, `Reputation`=0, `posX`=1319.208740, `posY`=1252.557739, `posZ`=10.820312, `Score`=70, `Deaths`=7, `Kills`=7, `Banned`=0, `Kicks`=7, EquipmentM4`=0,`EquipmentAK47`=0,`EquipmentDeagle`=0,`EquipmentKnife`=0,`Equipment9MM`=0,`EquipmentShotgun`=0,`EquipmentUzi`=0 WHERE `ID`=26

EDIT: Player data inside the database is all set to 0.

[TwinkiDaBoss]

Issue resolved.
The problem was in the

Quote:

EquipmentM4`=%d

it was supposted to be

Quote:

`EquipmentM4`=%d