mysql problem
#1

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

Reply
#2

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

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
Reply
#4

Quote:
Originally Posted by KinderClans
Посмотреть сообщение
Yes it you said

But can you help me in my tread? :/
Reply
#5

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 ?
Reply
#6

You're missing a comma (,) after
PHP код:
bandana = %i WHERE uid = %
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)