Problem with mysql plugin - Printable Version

Problem with 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: Problem with mysql plugin (/showthread.php?tid=609701)

Problem with mysql plugin - holahola - 15.06.2016

Hi i have downloaded the r6 windows plugin but when i use mysql_format doesn't work. Why? I have seen when the server start plugin loaded r5 version but i have downlaoded the r6.

i have used this plugin https://sampforum.blast.hk/showthread.php?tid=56564

Re: Problem with mysql plugin - F1N4L - 15.06.2016

mysql_format it works in MySQL versions >= R33
https://github.com/pBlueG/SA-MP-MySQL/releases

Re: Problem with mysql plugin - holahola - 15.06.2016

Quote:

Originally Posted by F1N4L

mysql_format it works in MySQL versions >= R33
https://github.com/pBlueG/SA-MP-MySQL/releases

how to use threads? i don't know how it work. Can you link me a guide? And take me the version for no threads pls. Thank you.

Re: Problem with mysql plugin - F1N4L - 15.06.2016

For Windows
For Linux
For CentOS

Re: Problem with mysql plugin - holahola - 15.06.2016

Quote:

Originally Posted by F1N4L

For Windows
For Linux
For CentOS

Is with threads? I don't want this i want the r6 with no thread.Please.

Re: Problem with mysql plugin - TwinkiDaBoss - 15.06.2016

Well with Tquerries you need callbacks for your stuff.

Meaning for example

PHP Code:



new query[128];

mysql_format(mysql,query,sizeof(query),"UPDATE `something` SET `money`=%d WHERE `player`=%d",GetPlayerMoney(playerid),playerid);

mysql_tquery(mysql,query,"OnPlayerUpdateMoney","i",playerid);



forward OnPlayerUpdateMoney(playerid);

public OnPlayerUpdateMoney(playerid) {

    SendClientMessage(playerid,COLOR_RED,"Your money has been updated");

    return 1;

}

Re: Problem with mysql plugin - holahola - 16.06.2016

Quote:

Originally Posted by TwinkiDaBoss

Well with Tquerries you need callbacks for your stuff.

Meaning for example

PHP Code:



new query[128];

mysql_format(mysql,query,sizeof(query),"UPDATE `something` SET `money`=%d WHERE `player`=%d",GetPlayerMoney(playerid),playerid);

mysql_tquery(mysql,query,"OnPlayerUpdateMoney","i",playerid);



forward OnPlayerUpdateMoney(playerid);

public OnPlayerUpdateMoney(playerid) {

    SendClientMessage(playerid,COLOR_RED,"Your money has been updated");

    return 1;

}

thank you for answer, but i need the plugin and .inc r6-2 for mysql plugin with no threads because i don't know how the threads works. Thank you.

The plugin is this:https://sampforum.blast.hk/showthread.php?tid=56564 but there isn't r6 there all r5 or r7