![]() |
#1 |
Beta Tester
![]() ![]() ![]() ![]() ![]() Join Date: Sep 2007
Location: Los Angeles, CA
Posts: 232
Reputation: 294
|
![]() MySQL Plugin The best and most famous MySQL plugin for SA:MP out there! Code:
10/12/2013: The project has been moved from ******code to github This plugin allows you to use MySQL in PAWN. It's currently being developed by Pain123/maddinat0r; you'll find all older versions, including source codes and sample scripts, from R5 to R7 at the bottom of this post and the latest release here. How to install: Move mysql.dll (windows) or mysql.so (linux) to your 'plugins/' directory. On windows you'll have to download the mysql library (libmysql.dll, see downloads) and move it to your main server directory. The server configuration (server.cfg) has to be edited aswell.
PAWN Scripting R5-R7: (a_mysql.inc)
Compiling Notes:
Downloads: (for newer updates, use the github project site above!) NOTE: DON'T USE VERSION R7 OR ABOVE IF YOU HAVE NO IDEA WHAT THREADING MEANS OR HOW IT WORKS. YOU MIGHT HARM YOUR SERVER WHEN USING IT NOT PROPERLY.
Thanks to:
If you have any questions, post them here!
Last edited by BlueG; 10/12/2013 at 08:33 PM. |
![]() |
![]() |
![]() |
#2 |
High-roller
![]() ![]() ![]() ![]() ![]() Join Date: Apr 2007
Location: Republic of Ireland
Posts: 4,253
Reputation: 363
|
![]()
Good job GStylezzz
![]() |
![]() |
![]() |
![]() |
#3 |
Little Clucker
![]() Join Date: May 2006
Posts: 41
Reputation: 2
|
![]()
Need something better to get values. It would be great to have mysql_get_field() or c_strtok() like in [RAZ]ADreNaLiNe-DJ plugin are.
|
![]() |
![]() |
![]() |
#4 | |
Beta Tester
![]() ![]() ![]() ![]() ![]() Join Date: Sep 2007
Location: Los Angeles, CA
Posts: 232
Reputation: 294
|
![]() Quote:
row1 row2 row3 Now you can just use strtok to split it in tokens.Also 'mysql_get_field' is probably a good idea for the next version. |
|
![]() |
![]() |
![]() |
#5 |
Little Clucker
![]() Join Date: May 2006
Posts: 41
Reputation: 2
|
![]()
I know strtok function in PAWN, but in C i think it will be faster?
|
![]() |
![]() |
![]() |
#6 |
Little Clucker
![]() Join Date: Jan 2008
Posts: 34
Reputation: 2
|
![]()
hey
does the memory deallocation work here correctly? |
![]() |
![]() |
![]() |
#7 |
Big Clucker
![]() ![]() Join Date: Oct 2007
Posts: 171
Reputation: 2
|
![]()
I think so. The code is much cleaner here and I hadn't any problems with this plugin on Debian 4.0 ETCH.
|
![]() |
![]() |
![]() |
#8 |
Gangsta
![]() ![]() ![]() ![]() Join Date: Jul 2008
Posts: 977
Reputation: 90
|
![]()
Somebody is finally adding some more stuff to mysql, great job!
|
![]() |
![]() |
![]() |
#9 |
High-roller
![]() ![]() ![]() ![]() ![]() Join Date: Feb 2008
Posts: 1,053
Reputation: 8
|
![]()
Do I have to know PHP to make a page that shows user stats online?
|
![]() |
![]() |
![]() |
#10 | |
High-roller
![]() ![]() ![]() ![]() ![]() Join Date: Apr 2007
Location: Republic of Ireland
Posts: 4,253
Reputation: 363
|
![]() Quote:
Last edited by JaTochNietDan; 23/07/2011 at 04:27 AM. |
|
![]() |
![]() |
![]() |
Thread Tools | |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
****** Project: Glass | int3s0 | Everything and Nothing | 99 | 26/02/2013 04:22 PM |
MySQL Plugin R5 plugin problem | dud | Scripting Help | 12 | 05/12/2011 06:28 PM |
Strikens Mysql vs BlueG's Mysql plugin | PrawkC | Scripting Help | 4 | 30/09/2011 10:30 AM |
[help][plugin] Can't load mysql plugin | mariomako | Help Archive | 8 | 16/07/2011 02:37 PM |
mysql plugin. loading plugin failed | ikkentim | Help Archive | 2 | 10/02/2011 02:32 PM |