Which mysql plugin should I use? - 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: Which mysql plugin should I use? (/showthread.php?tid=489814)
+- 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: Which mysql plugin should I use? (/showthread.php?tid=489814)
Which mysql plugin should I use? Edit: Mysql won't load - Mystique - 24.01.2014
Hello there.
I'm a experienced scripter who would like to try something new and that is mysql. As I've never used it before I would like to know which plugin you would recommend to start out with. I only know two famous ones which are StrickenKids and Blueg's plugin. Should I choose between them or choose something else?
Re: Which mysql plugin should I use? - iZN - 24.01.2014
StrickenKid's MySQL is outdated and the speed improvement is quite slow.
Use BlueG's plugin (now developed by maddinat0r) R34 or R35b3 (pre-release), can be found at Github. The speed improvement of this plugin is good, also, use threaded queries not unthreaded queries if you want to see the result between them, check AndreT's tutorial (https://sampforum.blast.hk/showthread.php?tid=337810)
Re: Which mysql plugin should I use? - M3HR4N - 24.01.2014
StrickenKids is outdated and too slow, start using BlueG 's plugin.
Re: Which mysql plugin should I use? - Mystique - 24.01.2014
Thanks guys, well now I'm facing a problem with this. I tried installing a wamp server and installing the mysql plugin and include to my server directory. I also inserted some code into the script from a tutorial but when I try to compile it, it just returns the classic
Код:
Run time error 19: "File or function not found"
Re: Which mysql plugin should I use? - iZN - 24.01.2014
You are possibly running wrong plugin version, load nativechecker plugin and check those natives if they are available in your plugin version.
Re: Which mysql plugin should I use? - Mystique - 24.01.2014
I should have the correct plugin, but it won't work. I tried to insert the R6 files into the plugin folder and that worked like a charm, except for that some functions that is used in the script doesn't exist in that plugin.
This is what my server outputs when I start it with R34 with both crashchecker and nativechecker enabled..
Код:
SA-MP Dedicated Server ---------------------- v0.3x-R2, ©2005-2013 SA-MP Team [14:20:18] filterscripts = "" (string) [14:20:18] [14:20:18] Server Plugins [14:20:18] -------------- [14:20:18] Loading plugin: mysql.dll [14:20:18] Failed. [14:20:18] Loading plugin: crashdetect.dll [14:20:18] CrashDetect v4.13 is OK. [14:20:18] Loaded. [14:20:18] Loading plugin: nativechecker.dll [14:20:18] Loaded. [14:20:18] Loaded 2 plugins. [14:20:18] [14:20:18] Filterscripts [14:20:18] --------------- [14:20:18] Loaded 0 filterscripts. [14:20:18] Error: Function not registered: 'mysql_connect' [14:20:18] Error: Function not registered: 'mysql_errno' [14:20:18] Error: Function not registered: 'mysql_tquery' [14:20:18] Error: Function not registered: 'mysql_format' [14:20:18] Error: Function not registered: 'cache_get_data' [14:20:18] Error: Function not registered: 'cache_get_row' [14:20:18] Error: Function not registered: 'cache_get_row_int' [14:20:18] [debug] Run time error 19: "File or function is not found" [14:20:18] [debug] mysql_connect [14:20:18] [debug] mysql_errno [14:20:18] [debug] mysql_tquery [14:20:18] [debug] mysql_format [14:20:18] [debug] cache_get_data [14:20:18] [debug] cache_get_row [14:20:18] [debug] cache_get_row_int [14:20:18] [debug] Run time error 19: "File or function is not found" [14:20:18] [debug] mysql_connect [14:20:18] [debug] mysql_errno [14:20:18] [debug] mysql_tquery [14:20:18] [debug] mysql_format [14:20:18] [debug] cache_get_data [14:20:18] [debug] cache_get_row [14:20:18] [debug] cache_get_row_int [14:20:18] Script[gamemodes/roleplay.amx]: Run time error 19: "File or function is not found" [14:20:18] Number of vehicle models: 0
Re: Which mysql plugin should I use? - iZN - 24.01.2014
This isn't R34, re-download, and put them again. cache functions were added from R7+.