[Mystique]

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?

[iZN]

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)

[M3HR4N]

StrickenKids is outdated and too slow, start using BlueG 's plugin.

[Mystique]

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"

I know it should e because something it outdated, but the server directory is new, I just downloaded the plugin, inserted all the files correctly but still it returns that error for me.

[iZN]

You are possibly running wrong plugin version, load nativechecker plugin and check those natives if they are available in your plugin version.

[Mystique]

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

[iZN]

This isn't R34, re-download, and put them again. cache functions were added from R7+.