SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help

Reply
 
Thread Tools Display Modes
Old 13/08/2018, 01:11 AM   #1
S3DOx
Little Clucker
 
Join Date: Apr 2018
Posts: 26
Reputation: 0
Default mysql problem

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
S3DOx is offline   Reply With Quote
Old 13/08/2018, 01:49 AM   #2
IdonTmiss
Big Clucker
 
Join Date: Dec 2016
Posts: 101
Reputation: 0
Default Re: mysql problem

As somebody said "It really is 2018, but telepathy isn't here" show us your line, where u set togglepm = 0;
IdonTmiss is offline   Reply With Quote
Old 13/08/2018, 10:41 AM   #3
KinderClans
Big Clucker
 
KinderClans's Avatar
 
Join Date: May 2018
Location: Italy
Posts: 171
Reputation: 0
Default Re: mysql problem

Quote:
Originally Posted by IdonTmiss View Post
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
__________________
Against everyone and everything.
KinderClans is online now   Reply With Quote
Old 13/08/2018, 04:39 PM   #4
Heress
Big Clucker
 
Heress's Avatar
 
Join Date: Mar 2018
Location: Lithuania
Posts: 69
Reputation: 0
Default Re: mysql problem

Quote:
Originally Posted by KinderClans View Post
Yes it you said

But can you help me in my tread? :/
__________________
========================================
If I helped you - +rep
Sorry for my bad English
Heress is offline   Reply With Quote
Old 13/08/2018, 05:55 PM   #5
S3DOx
Little Clucker
 
Join Date: Apr 2018
Posts: 26
Reputation: 0
Default Re: mysql problem

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 ?
S3DOx is offline   Reply With Quote
Old 13/08/2018, 06:04 PM   #6
UFF
Big Clucker
 
UFF's Avatar
 
Join Date: Feb 2018
Posts: 141
Reputation: 10
Default Re: mysql problem

You're missing a comma (,) after
PHP Code:
bandana = %i WHERE uid = %
__________________
(¯`ˇ._.ˇUltimate Funky Freeroam._.ˇ´¯)



UFF is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Password Hash Problem & MYSQL Saving Problem Faqahat Scripting Help 3 18/04/2016 11:54 AM
[PLUGIN]: MySQL Problem (MYSQL R39-2) zT KiNgKoNg Scripting Help 11 11/11/2014 06:20 PM
[Mysql problem] Loss of communication with the mysql base SmileyCoder General 0 29/05/2014 03:38 PM
saving system mysql(not mysql problem) martoivanov Scripting Help 0 29/08/2013 03:37 PM
Problem with reading money from MySQL in "Clean, Simple MySQL GM" by L3th4l Dystans Help Archive 1 31/05/2011 09:19 PM


All times are GMT. The time now is 10:21 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.