MySQL Console errors
#1

Ok, so If I join my gamemode and quit, I get this console 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 ' = '0', Interior = 0, Skin = 147 WHERE ID = 6' at line 1 | Query: UPDATE players SET Health = '100.000000', Armour = '0.000000', Gamemaster = '0', Score = '0', Cash, = '0', Interior = 0, Skin = 147 WHERE ID = 6
Here is the lines:
Код:
	format(szQuery, sizeof(szQuery), "UPDATE players SET Health = '%f', Armour = '%f', Gamemaster = '%d', Score = '%d', Cash, = '%d'", playerVariables[playerid][pHealth], playerVariables[playerid][pArmour], playerVariables[playerid][pGamemaster], playerVariables[playerid][pScore], playerVariables[playerid][pCash]);
	format(szQuery, sizeof(szQuery), "%s, Interior = %d, Skin = %d WHERE ID = %d", szQuery, playerVariables[playerid][pInterior], playerVariables[playerid][pSkin], playerVariables[playerid][pDBID]);
Reply
#2

You have a "," on Cash

, Cash, = '%d


See?
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)