SA-MP Forums Archive
MySQL Tutorial help. - 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 Tutorial help. (/showthread.php?tid=449631)



MySQL Tutorial help. - Necip - 09.07.2013

So I am new to MySQL, trying to learn from the forums' tutorials.I have read this tutorial but I have errors.Here are the errors:
Код:
C:\Users\Netzip\Desktop\AAAAAAA necip\Antigrafh!\GTA - San Andreas\SAMP\gamemodes\Server from MySQL.pwn(48) : error 017: undefined symbol "mysql_query"
C:\Users\Netzip\Desktop\AAAAAAA necip\Antigrafh!\GTA - San Andreas\SAMP\gamemodes\Server from MySQL.pwn(70) : error 017: undefined symbol "MoneyGiven"
C:\Users\Netzip\Desktop\AAAAAAA necip\Antigrafh!\GTA - San Andreas\SAMP\gamemodes\Server from MySQL.pwn(70) : warning 215: expression has no effect
C:\Users\Netzip\Desktop\AAAAAAA necip\Antigrafh!\GTA - San Andreas\SAMP\gamemodes\Server from MySQL.pwn(70) : error 001: expected token: ";", but found "]"
C:\Users\Netzip\Desktop\AAAAAAA necip\Antigrafh!\GTA - San Andreas\SAMP\gamemodes\Server from MySQL.pwn(70) : error 029: invalid expression, assumed zero
C:\Users\Netzip\Desktop\AAAAAAA necip\Antigrafh!\GTA - San Andreas\SAMP\gamemodes\Server from MySQL.pwn(70) : fatal error 107: too many error messages on one line

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


5 Errors.
And here is line 48 and 70
pawn Код:
mysql_query("CREATE TABLE IF NOT EXISTS playerdata(user VARCHAR(24), password VARCHAR(41), score INT(20), money INT(20), IP VARCHAR(16) )"); // 48

MoneyGiven[playerid] = -1; // 70



Re: MySQL Tutorial help. - Calabresi - 09.07.2013

You don't have the mysql include, or you have the old version if you are using BlueG's plugin.


Re: MySQL Tutorial help. - Necip - 09.07.2013

I have the R7.

(Naber xD)


Re: MySQL Tutorial help. - Calabresi - 09.07.2013

Quote:
Originally Posted by Necip
Посмотреть сообщение
I have the R7.

(Naber xD)
You should use mysql_function_query() instead of mysql_query then. You must use threaded queries aswell.

(iyidir senden )


Re: MySQL Tutorial help. - Necip - 09.07.2013

Alright NVM fixed it, I got the R6 and the query error gone.I fixed the others too.Thanks anyways..