[dougbrowne]

I'm working on a large script and the weapons save system doesn't seem to work...

pawn Код:

SaveWeaps(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, name, sizeof(name));
    new weap1, ammo1, weap2, ammo2, weap3, ammo3, weap4, ammo4, weap5, ammo5, weap6, ammo6, weap7, ammo7;
     GetPlayerWeaponData(playerid,2,weap1,ammo1);// handgun
    GetPlayerWeaponData(playerid,3,weap2,ammo2);//shotgun
    GetPlayerWeaponData(playerid,4,weap3,ammo3);// SMG
    GetPlayerWeaponData(playerid,5,weap4,ammo4);// AK47 / M4
    GetPlayerWeaponData(playerid,6,weap5,ammo5);// rifle
    GetPlayerWeaponData(playerid,7,weap6,ammo6);// rocket launcher
    GetPlayerWeaponData(playerid,8,weap7,ammo7);// Grenades
    new query[512];
    format(query, sizeof(query), "UPDATE users SET weap1 = '%d' ammo1 = '%d' weap2 = '%d' ammo2 = '%d' weap3 = '%d' ammo3 = '%d' weap4 = '%d' ammo4 = '%d' weap5 = '%d' ammo5 = '%d' weap6 = '%d' ammo6 = '%d' weap7 = '%d' ammo7 = '%d' WHERE username = '%s'", weap1, ammo1, weap2, ammo2, weap3, ammo3, weap4, ammo4, weap5, ammo5, weap6, ammo6, weap7, ammo7, name);
    mysql_query(query);
}

And of course I have SaveWeaps(playerid); under public OnPlayerDisconnect

I give myself an M4, I disconnect, I look at the mysql DB and the values aren't saved in there.. I know I can connect with the db fine because my register/login system works fine and my snippet to save player money also works fine which is..

pawn Код:

GetPlayerName(playerid, pName, sizeof(pName));
format(query,sizeof(query),"UPDATE users SET money = '%d' WHERE username = '%s'",GetPlayerMoney(playerid),pName);
mysql_query(query);

Thats also under OnPlayerDisconnect