mysql problem - Printable Version

mysql problem - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: mysql problem (/showthread.php?tid=657660)

mysql problem - S3DOx - 13.08.2018

Where is the problem here please

Quote:

[02:354] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'togglepm = 0' at line 1

Re: mysql problem - IdonTmiss - 13.08.2018

As somebody said "It really is 2018, but telepathy isn't here" show us your line, where u set togglepm = 0;

Re: mysql problem - KinderClans - 13.08.2018

Quote:

Originally Posted by IdonTmiss

As somebody said "It really is 2018, but telepathy isn't here" show us your line, where u set togglepm = 0;

http://forum.sa-mp.com/showthread.ph...08#post4044108

Re: mysql problem - Heress - 13.08.2018

Quote:

Originally Posted by KinderClans

http://forum.sa-mp.com/showthread.ph...08#post4044108

Yes it you said

But can you help me in my tread? :/

Re: mysql problem - S3DOx - 13.08.2018

Quote:

mysql_format(connectionID, queryBuffer, sizeof(queryBuffer), "UPDATE users SET toggleradio = %i, togglemusic = %i, togglefaction = %i, togglenews = %i, toggleglobal = %i, togglecam = %i, togglehud = %i, weedtime = %i, weedgrams = %i, showturfs = %i, showlands = %i, watchon = %i, gpson = %i, couriercooldown = %i, pizzacooldown = %i, detectivecooldown = %i, thiefcooldown = %i, crackcooldown = %i, duty = %i, bandana = %i WHERE uid = %i togglepm = %i", PlayerInfo[playerid][pToggleRadio],
PlayerInfo[playerid][pToggleMusic], PlayerInfo[playerid][pToggleFaction], PlayerInfo[playerid][pToggleNews], PlayerInfo[playerid][pToggleGlobal], PlayerInfo[playerid][pToggleCam], PlayerInfo[playerid][pToggleHUD], PlayerInfo[playerid][pWeedTime], PlayerInfo[playerid][pWeedGrams], PlayerInfo[playerid][pShowTurfs], PlayerInfo[playerid][pShowLands], PlayerInfo[playerid][pWatchOn], PlayerInfo[playerid][pGPSOn], PlayerInfo[playerid][pCourierCooldown], PlayerInfo[playerid][pPizzaCooldown],
PlayerInfo[playerid][pDetectiveCooldown], PlayerInfo[playerid][pThiefCooldown], PlayerInfo[playerid][pCocaineCooldown], PlayerInfo[playerid][pDuty], PlayerInfo[playerid][pBandana], PlayerInfo[playerid][pID],PlayerInfo[playerid][pTogglePM]);
mysql_tquery(connectionID, queryBuffer);

soo ?

Re: mysql problem - UFF - 13.08.2018

You're missing a comma (,) after

PHP код:



bandana = %i WHERE uid = %i