04.04.2013, 19:00
As i notice on this part of code there is no commas
also ' ' only use it when it is a string not an integer (most people said)
and try increasing string because 256 is not enough. i would say increase it to 500+
Try this code
pawn Код:
`Rank` = '%d' \
`Class1Weapon1` = '%d' \
`Class1Weapon2` = '%d' \
`Class1Weapon3` = '%d' \
`Class2Weapon1` = '%d' \
`Class2Weapon2` = '%d' \
`Class2Weapon3` = '%d' \
`Class3Weapon1` = '%d' \
`Class3Weapon2` = '%d' \
`Class3Weapon3` = '%d' \
and try increasing string because 256 is not enough. i would say increase it to 500+
Try this code
pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
if(pInfo[playerid][pLoggedIn] == 1)
{
new Query[556];
format(Query, sizeof(Query),"UPDATE `Users` SET `IP` = '%s', `Admin` = %d, `PWL` = %d, `SWL` = %d, `TWL` = %d, `XP` = %d, `Kills` = %d, `Deaths` = %d, `Money` = %d, `Score` = %d, `Rank` = %d,\
`Class1Weapon1` = %d, `Class1Weapon2` = %d, `Class1Weapon3` = %d, `Class2Weapon1` = %d, `Class2Weapon2` = %d, `Class2Weapon3` = %d, `Class3Weapon1` = %d, `Class3Weapon2` = %d, `Class3Weapon3` = %d\
WHERE `UserName` = '%s'",
pIP[playerid],pInfo[playerid][pAdmin],PrimaryWeaponLevel[playerid], SecondaryWeaponLevel[playerid],ThirdaryWeaponLevel[playerid],pInfo[playerid][pXP],pInfo[playerid][pKills],pInfo[playerid][pDeaths],
pInfo[playerid][pMoney], pInfo[playerid][pScore],pInfo[playerid][pRank],ClassInfo[playerid][0][Weapon1], ClassInfo[playerid][0][Weapon2],ClassInfo[playerid][0][Weapon3],ClassInfo[playerid][1][Weapon1],
ClassInfo[playerid][1][Weapon2],ClassInfo[playerid][1][Weapon3],ClassInfo[playerid][2][Weapon1],ClassInfo[playerid][2][Weapon2],ClassInfo[playerid][2][Weapon3],
pName[playerid]);
mysql_query(Query);
}
return 1;
}
