[AccountName]

Error:

Код:

Error #1064 - Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Group = 0, Interior = 0, Skin = 147, AdminLevel = 6, Money = 1500, BankMoney = 5' at line 1 | Query: UPDATE players SET Health = '100.000000', Armour = '0.000000', PosX = '1642.069213', PosY = '-2332.604980', PosZ = '13.546875', PosR = '0.000000', Group = 0, Interior = 0, Skin = 147, AdminLevel = 6, Money = 1500, BankMoney = 5500, VIP = 6, VIPExpires = 0, NMute = 0, VMute = 0, CellPhone = 0, Rags = 0, Rope = 0, Age = 0, Gender = 0, HasSeenTutorial = 0, Job = 0, FightStyle = 0, CharacterKey = 96758 WHERE ID = 5

Code:

pawn Код:

format(szQuery, sizeof(szQuery), "UPDATE players SET Health = '%f', Armour = '%f', PosX = '%f', PosY = '%f', PosZ = '%f', PosR = '%f', Group = %d", Player[playerid][pHealth], Player[playerid][pArmour], Player[playerid][pPos][0], Player[playerid][pPos][1], Player[playerid][pPos][2], Player[playerid][pPos][3], Player[playerid][pGroup]);
    format(szQuery, sizeof(szQuery), "%s, Interior = %d, Skin = %d, AdminLevel = %d, Money = %d, BankMoney = %d, VIP = %d, VIPExpires = %d, NMute = %d, VMute = %d, CellPhone = %d, Rags = %d, Rope = %d, Age = %d, Gender = %d, HasSeenTutorial = %d, Job = %d, FightStyle = %d", szQuery,
    Player[playerid][pInterior], Player[playerid][pSkin], Player[playerid][AdminLevel], Player[playerid][Money], Player[playerid][BankMoney], Player[playerid][VIP], Player[playerid][VIPExpires],
    Player[playerid][NMute], Player[playerid][VMute], Player[playerid][CellPhone], Player[playerid][Rags], Player[playerid][Rope], Player[playerid][pAge], Player[playerid][Gender], Player[playerid][HasSeenTutorial], Player[playerid][pJob], Player[playerid][FightStyle]);

    
    format(szQuery, sizeof(szQuery), "%s, CharacterKey = %d WHERE ID = %d", szQuery, Player[playerid][CharacterKey], Player[playerid][pDBID]);

[[HiC]TheKiller]

The issue is that "GROUP" is a MySQL function. Change the collumn name or add `` around Group. So change it to `Group` .

[AccountName]

Thanks didn't know abut that.