mysql_query eror - Printable Version

mysql_query eror - 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_query eror (/showthread.php?tid=412996)

mysql_query eror - Stefan_Merce - 03.02.2013

Код:

C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(623) : error 017: undefined symbol "mysql_query"
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : error 029: invalid expression, assumed zero
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 215: expression has no effect
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : error 029: invalid expression, assumed zero
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : warning 215: expression has no effect
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : error 029: invalid expression, assumed zero
C:\Users\matthew\Desktop\AFRPLinux\gamemodes\afrp.pwn(2051) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase

this is what i get here is the line

Код:

 line 623 mysql_query("UPDATE playeraccounts SET playerStatus = '0' WHERE playerStatus = '1'");

Код:

line 2051	mysql_query("SELECT * FROM atms", THREAD_LOAD_ATMS);

Re: mysql_query eror - Jstylezzz - 03.02.2013

Not sure, I'm having a hard time with mysql at the moment too, but what i think is this:

pawn Код:

mysql_query("UPDATE playeraccounts SET playerStatus = '0' WHERE playerStatus = '1'");

has to be

pawn Код:

mysql_query("UPDATE `playeraccounts` SET `playerStatus` = '0' WHERE `playerStatus` = '1'");

What I did is add ` before and after a row name.
I guess it's the same for the other line, add ` before and after the row name.

EDIT: I just saw the first error, is about the undefined mysql_query..
now, it's a strange error, and it makes me think you haven't included the mysql include..
not sure though