SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Plugin Development

Reply
 
Thread Tools Display Modes
Old 24/01/2010, 08:41 AM   #1
StrickenKid
Gangsta
 
Join Date: Feb 2009
Posts: 778
Reputation: 39
Default [REL] SA:MP MySQL Plugin 2.1.1 - Released (1/25/2011


SA:MP MySQL Plugin
Version: 2.1.1

Now Linux Stable!

Latest Release: 2.1.1 Build-165


ChangeLog:
  • 1/25/2011 - v2.1.1
    Fixed bug that caused the server to crash when mysql_close was called with multiple connections.
    Fixed bug with mysql_query_array that caused strings to randomly override each other.
    Fixed bug that caused the server to crash when a null string was passed through a parameter.
    Changed a few error strings.

  • 11/24/2010 - v2.1:
    Thanks to Blacklite properly debugging the plugin, all reported crashes have been fixed.
    The following functions which were unstable have been fixed: mysql_fetch_field, mysql_fetch_field_num, mysql_fetch_int, mysql_fetch_float and mysql_fetch_string.
    I have also found a proper way to fix libmysqlclient_r.so.X missing errors. See below.
    Fixed mysql_query's return value; returns 0 on successful query, returns error id on failed query,

  • 8/7/2010 - v2.0:
    Biggest update since initial release.
    Entire plugin has been re-designed using classes, and all functions have been re-coded.
    Full linux multi-threaded compatibility, compiled with thread-safe mysql build. Tested on linux (debian 5) server, sever executed a total of 3,542 queries and was online for about a half hour, no crashes. I will also be testing it further for longer periods of time.
    Added mysql_init: initializes mysql connection and returns connection handle, (instead of initializing mysql inside mysql_connect).
    Removed mysql_reload function and added mysql_refresh, added mysql_reload define macro.
    Added mysql_get_character_set: gets the current character set in use.
    Added wiki page to the SA:MP Wiki.

  • 3/26/2010 - v1.2.1:
    Fixed various bugs that caused the server to crash with various functions.
    Added more error checking to prevent crashes even if pawn coded badly.
    Cleaned up the code more.
    Optimized the code a lot.
    Changed some small things with the thread (for testing).
    Added list functionality for the AMX variable, it should work fully with filterscripts now. (Thanks to Incognito for the technique)

  • 2/7/2010 - v1.2:
    Added new parameter to mysql_query to push a spare id of any kind to the threaded callback. (suggested by Wicko)
    Added mysql_query_array, which is the same as mysql_query, but lets you push an array of integers, floats, booleans, etc, or a string to OnMysqlQueryArray.
    Added callback OnMysqlQueryArray which works with mysql_query_array.
    Fixed some more small coding errors.
    Here is another small example by Wicko on how the new callback and function is used.

  • 2/3/2010 - v1.1.2:
    Fixed small bug with mysql_fetch_field.
    Added mysql_fetch_row_data to work in conjunction with mysql_fetch_field. Here is an example on how to use this function.
    Added mysql_fetch_string.

  • 2/2/2010 - v1.1.1:
    Added ProcessTick functionality to the plugin to prevent random crashes when calling OnMysqlQuery from query thread.
    Updated mysql_query to prevent allocated memory from not being free'd on error. (Thanks to Wicko)
    Changed max connections to 4. If you need to be connected to more than 4 databases at a time you can change MAX_CONNECTIONS in the source and compile.

  • 1/31/2010 - v1.1:
    Added multi-connection support! You can connect up to a max of 20 databases at a time!
    Added threaded query callback! You've all been asking for it! And here it is!
    Added error handling callback! You can now have full control of error handling!
    Added mysql_result_stored function to check if a result was successfully stored after mysql_store_result.
    Added 1 more param to mysql_log to toggle errors printed to the server window. And changed the first param to take log types (info below).
    Fixed many small script errors and optimized most of the functions!

  • 1/26/10 - v1.0.2:
    Fixed a couple more small problems.
    Added functions: mysql_fetch_field_num, mysql_fetch_int, and mysql_fetch_float.
    Cleaned up the code a bit.

  • 1/24/10 - v1.0.1:
    Fixed small memory leak and bug that crashed the server if mysql_fetch_row was called with a result ~256 cells big and when mysql_log was on.

About:

This is a MySQL Plugin that enables you to connect to any MySQL database to make any query, and retrieve the results. This is pretty much the fastest and most stable MySQL plugin in SA:MP. This plugin is setup so it will send you an error message on what you've done wrong instead of just crashing, making it very stable. For example, if you execute a SELECT query and forget to store the result and try to retrieve it with mysql_fetch_row, the mysql_fetch_row function will send: "MySQL Error: 'mysql_fetch_row' called when no result stored." to the console window. This plugin is also equipped with a whopping 28 native functions, all useful for your SA:MP server.

How To Install:
  • Windows:
    1. Download the plugin.
    2. Place the mysql.dll in your plugins folder, and move libmysql.dll to the same directory the server exe is.
    3. Open your server.cfg and add "mysql" to "plugins", if there is no "plugins" line, add one.
    4. Add mysql.inc to your /pawno/includes/ and add "#include <mysql>" to the top of your script.
  • Linux:
    1. Download the plugin to your linux server.
    2. Place the mysql.so in your plugins folder.
    3. Open your server.cfg and add "mysql.so" to "plugins", if there is no "plugins" line, add one.
    4. On the PC that you compile your script on, add mysql.inc to your /pawno/includes/ and add "#include <mysql>" to the top of your script.

Functions:
  • native MySQL:mysql_init(logtype = LOG_ONLY_ERRORS, printerrors = 1);
  • native mysql_connect(const host[], const user[], const pass[], const db[], MySQL:handle = (MySQL:0), auto_reconnect = 0);
  • native mysql_close(MySQL:handle = MySQL:0);
  • native mysql_refresh(options, MySQL:handle = MySQL:0);
  • native mysql_select_db(const db[], MySQL:handle = MySQL:0);
  • native mysql_query(const query[], resultid = (-1), spareid = (0), MySQL:handle = MySQL:0);
  • native mysql_query_array(const query[], resultid = (-1), {Float,_}:extravars[], MySQL:handle = (MySQL:0));
  • native mysql_store_result(MySQL:handle = MySQL:0);
  • native mysql_free_result(MySQL:handle = MySQL:0);
  • native mysql_result_stored(MySQL:handle = MySQL:0);
  • native mysql_fetch_field(const fieldname[], dest[], MySQL:handle = MySQL:0);
  • native mysql_fetch_field_num(fieldnum, dest[], MySQL:handle = MySQL:0);
  • native mysql_fetch_row(dest[], const splitter[] = "|", MySQL:handle = MySQL:0);
  • native mysql_fetch_row_data(MySQL:handle = MySQL:0);
  • native mysql_real_escape_string(const string[], dest[], MySQL:handle = MySQL:0);
  • native mysql_num_rows(MySQL:handle = MySQL:0);
  • native mysql_num_fields(MySQL:handle = MySQL:0);
  • native mysql_affected_rows(MySQL:handle = MySQL:0);
  • native mysql_insert_id(MySQL:handle = MySQL:0);
  • native mysql_ping(MySQL:handle = MySQL:0);
  • native mysql_error(dest[], MySQL:handle = MySQL:0);
  • native mysql_errno(MySQL:handle = MySQL:0);
  • native mysql_warning_count(MySQL:handle = MySQL:0();
  • native mysql_info(dest[], MySQL:handle = MySQL:0);
  • native mysql_stat(dest[], MySQL:handle = MySQL:0);
  • native mysql_get_server_info(dest[], MySQL:handle = MySQL:0);
  • native mysql_get_host_info(dest[], MySQL:handle = MySQL:0);
  • native mysql_data_seek(rownum, MySQL:handle = MySQL:0);
  • native mysql_set_character_set(const csname[], MySQL:handle = MySQL:0);
  • native mysql_get_character_set(csname[], MySQL:handle = MySQL:0);
  • native mysql_fetch_int(MySQL:handle = MySQL:0);
  • native mysql_fetch_float(MySQL:handle = MySQL:0);
  • native mysql_fetch_string(dest[], MySQL:handle = MySQL:0);

Wiki Page (Detailed Function List):

Can be found here.

Feel free to contribute to the wiki page.

Callbacks:
  • forward OnMysqlQuery(resultid, spareid, MySQL:handle)
    • You use this callback if you want to have your query executed in a separate thread. Avoiding any lagging of the server itself, it basically separates the query from the server so if it takes the query 5 seconds to run, the server wont lag at all. You can now use spareid to pass a playerid or any other id.
    • Example below on use.
  • forward OnMysqlQueryArray(resultid, extravars[], MySQL:handle)
    • You use this callback for the same reason as OnMysqlQuery, but if you want to pass more than 1 extra variable, and/or if you want to pass something other then an integer. Because it uses the {Float,_}: tag, you can pass any tag, you can also pass a string to the callback.
    • Example below on use.
  • forward OnMysqlError(error[], errorid, MySQL:handle)
    • You use this callback to have 100% control on handling errors from mysql queries and functions. With the raw data being passed through you can do anything you want with it. You can also print the errors from your script and disable errors being printed from the plugin with mysql_log params (explained below). Also, for the advanced users, HERE is a list of error codes.
    • Example below on use.

See the wiki page for callback examples.

Downloads (2.1.1 - Build 165):


IMPORTANT: If you cannot compile your own mysql build (on a hosted server e.g. ServerFFS), use the static build.

Running on Linux?

Having problems with libmysqlclient_r.so.X?

If you cannot do this, use the static build.
  1. First of all, you must locate where your mysql libraries are located.
    Mine are located at: /usr/local/mysql/lib/mysql
  2. Now, open libc.conf located in /etc/ld.so.conf.d
  3. Add the mysql libraries' path to the end of this file, on a new line.
  4. Save the file, and execute: ldconfig

Want To Compile It Yourself?
  • Windows:
    • Visual Studio 2008 Required
    • Open the project file and click Build>Build Solution or press F7
  • Linux:
    • make, gcc, g++, mysql-client, and libmysqlclient15-dev required
    • A thread-safe mysql build needs to also be installed. See here, and here for more info on how to do this.
    • cd to the directory the plugin files are in and simply type "make"

Thanks To:
  • Kye - Plugin SDK and param count define
  • Incognito - AMX list / queue techniques
  • Wicko - Helping me with understanding threading / coding support / bug catching
  • Blacklite - Linux compiling / Testing / Bug fixing / Split function (in mysql.inc)
  • Popz - Linux compiling help

Post Comments And Questions!
[/list][/list]

Last edited by StrickenKid; 16/03/2011 at 08:52 PM. Reason: Version 2.1.1
StrickenKid is offline   Reply With Quote
Old 24/01/2010, 08:46 AM   #2
Blacklite
Huge Clucker
 
Join Date: Mar 2009
Location: am kiwi
Posts: 410
Reputation: 40
Default Re: [REL] SA:MP MySQL Plugin 1.0

Good to see it finally here. Nice job, StrickenKid!
__________________


Blacklite is offline   Reply With Quote
Old 24/01/2010, 08:54 AM   #3
[NoV]LaZ
High-roller
 
Join Date: May 2008
Posts: 1,448
Reputation: 54
Default [REL] SA:MP MySQL Plugin 1.0

Looks very interesting, but you forgot to add the source code.
________
Infant Zoloft

Last edited by [NoV]LaZ; 24/04/2011 at 11:36 AM.
[NoV]LaZ is offline   Reply With Quote
Old 24/01/2010, 08:58 AM   #4
StrickenKid
Gangsta
 
Join Date: Feb 2009
Posts: 778
Reputation: 39
Default Re: [REL] SA:MP MySQL Plugin 1.0

Quote:
Originally Posted by [NoVt
LaZ ]
Looks very interesting, but you forgot to add the source code.
Sorry, fixed, and I didn't forget, I just got the links mixed up.
__________________
StrickenKid is offline   Reply With Quote
Old 24/01/2010, 09:50 AM   #5
MX_Master
Huge Clucker
 
Join Date: Jul 2007
Posts: 395
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Great! it's exactly what I need (:
MX_Master is offline   Reply With Quote
Old 24/01/2010, 10:28 AM   #6
Toney
Big Clucker
 
Join Date: Oct 2009
Posts: 123
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Hm nice done i think it will most stable and full mysql version for SA-MP client. Thanks.
Toney is offline   Reply With Quote
Old 24/01/2010, 10:53 AM   #7
potato
Big Clucker
 
Join Date: Sep 2007
Posts: 108
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Nice work!
But can you give in few words why should I (or someone else for that matter) use this plugin instead of those other plugins?
I do see some extra functions, that I actually needed before, but is this all?
potato is offline   Reply With Quote
Old 24/01/2010, 11:50 AM   #8
Jay_
Beta Tester
 
Jay_'s Avatar
 
Join Date: Jul 2009
Posts: 605
Reputation: 122
Default Re: [REL] SA:MP MySQL Plugin 1.0

Nice work. Just a question though, what makes this plugin better than this one? It may have some extra natives, but it lacks something performance wise which makes G-sTyLeZzZ's version outrank yours: a threaded callback.
Jay_ is offline   Reply With Quote
Old 24/01/2010, 11:56 AM   #9
MenaceX^
High-roller
 
Join Date: Aug 2008
Posts: 3,819
Reputation: 13
Default Re: [REL] SA:MP MySQL Plugin 1.0

Wow, I've been waiting so long for a new plugin.

I'll talk to you in MSN
MenaceX^ is offline   Reply With Quote
Old 24/01/2010, 02:27 PM   #10
Dreftas
Gangsta
 
Join Date: May 2008
Posts: 643
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Cool. I will try this plugin instead of G-Stylezz Really good work.
Dreftas is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[Plugin] [REL] MySQL Plugin (Now on github!) BlueG Plugin Development 4808 21/04/2014 08:26 PM
Best MySQL Plugin? Antonio [G-RP] Help Archive 3 10/01/2011 02:31 AM
Best MySQL plugin? DRIFT_HUNTER Help Archive 2 07/12/2010 04:43 PM
Which MySQL plugin? Whois. Help Archive 0 07/04/2010 11:55 AM
Mysql Plugin Help Jbosh123 Help Archive 0 04/09/2009 11:35 AM


All times are GMT. The time now is 12:31 AM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.