Searching MySQL plugin - Printable Version

Searching MySQL plugin - 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: Searching MySQL plugin (/showthread.php?tid=493383)

Searching MySQL plugin - Riwerry - 08.02.2014

Hello guys, I am searching for MySQL plugin, newest && fastest one. Can someone advise me, which one is best to use?

Re: Searching MySQL plugin - anou1 - 08.02.2014

Take a look : https://sampforum.blast.hk/showthread.php?tid=56564

the newest was released yesterday

https://github.com/pBlueG/SA-MP-MySQL/releases

Re: Searching MySQL plugin - Riwerry - 08.02.2014

Nice, thanks!

Re: Searching MySQL plugin - Riwerry - 08.02.2014

Well I am having troubles, now I tried to download it (latest release). I put .dll to plugins, edited server.cfg, include a_mysql copied to pawno include folder, also added include to gamemode. But I don't understand becouse I am having these errors:

error 017: undefined symbol "mysql_ping"
error 035: argument type mismatch (argument 1)

lines:

pawn Код:

if(mysql_ping() == 1) //this
{
    print("Connection successfull!");
}

mysql_query(string); //mistmatch :O

Re: Searching MySQL plugin - Patrick - 08.02.2014

mysql_ping has been removed for some reason, here's a sample how you check connection etc..
mysql_query its parameter has been changed, so you better check mysql_pquery and mysql_tquery.
- for more information read MySQL wikipedia

pawn Код:

print( ( !mysql_errno() ) ? ("Connection successfull") : ("Connection Failed") );

Re: Searching MySQL plugin - Riwerry - 08.02.2014

pguery and tquery needs callback function to work. I need to create for each query format new callback? Or how it is works?

//EDIT Yeah its optional now i saw

but if you know what is difference beetween pquery and tquery?

Re: Searching MySQL plugin - Patrick - 08.02.2014

Quote:

Originally Posted by SA-MP Wiki

myqsl_pquery sends a query which will be executed in another thread concurrently and calls the callback (if there is one) when the execution is finished.

mysql_tquery sends a query which will be executed in another thread and calls the callback (if there is one) when the execution is finished.

4char.

Re: Searching MySQL plugin - Riwerry - 08.02.2014

What means that it will be executed in another thread?

//i know what it means but dont know in example