SA-MP Forums

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

Closed Thread
 
Thread Tools Display Modes
Old 16/07/2007, 04:41 PM   #1
ADreNaLiNe-DJ
Huge Clucker
 
Join Date: Aug 2006
Posts: 221
Reputation: 1
Default [REL]SAMP-MySQL v0.15 - SAMP 0.3 supported!!! corrected version uploaded...

First of all, i just wanna precise some things about MySQL, licenses and this plugin:
- MySQL allows developpers to dev and distribute application freely using their API only if: it not includes the database engine and it's just a connector to the database.
- If you want to dev something like this, you must ask authorization and make your plugin opensource.
- In my case, i have a writen autorization of MySQL to distribute a plugin for SAMP.
- The following plugin is free to use.
- You are free to use it in your gamemodes, filterscripts or plugins.


Official Plugin Page is here


SAMP-MySQL v0.15 PAWN KIT includes PAWN .inc file (to be placed in "include" dir in pawno dir) and .pwn example file.
File size: 1.55kb
Download links:



SAMP-MySQL v0.15 Windows includes sourcecode, .dll file (windows plugin) ans libmysql.dll (place in the folder of the executable of samp server.
File size: 514kb
Download links:
SAMP-MySQL v0.15 Ubuntu includes Linux .so file, libmysqlclient.so for Ubuntu and source.
File size: 895 kb
Download links:
SAMP-MySQL v0.15 CentOS includes Linux .so file, libmysqlclient.so for CentOS and source.
File size: 895 kb
Download links:
[u]Future Development:
  • samp_mysql_next_field(): to access the next field when fetching data.
  • samp_mysql_affected_rows(): to get the number of affected rows by a query.
  • samp_mysql_debug(): to enable/disable debug mode.
  • samp_mysql_get_field_num(): to get the field value with its index => index 0 for the first field and so on.


[u]New Features:
  • SA:MP 0.3 supported
  • Memory deallocation: plugin is optimized to free memory correctly.


[u]Implemented functions:
  • samp_mysql_connect()
  • samp_mysql_select_db()
  • samp_mysql_query()
  • samp_mysql_store_result()
  • samp_mysql_fetch_row()
  • samp_mysql_get_field()
  • samp_mysql_num_rows()
  • samp_mysql_num_fields()
  • samp_mysql_strtok()
  • samp_mysql_ping()
  • samp_mysql_real_escape_string()
  • samp_mysql_free_result() => DON'T USE IT, IT WILL CRASH YOUR SERVER !!!
  • samp_mysql_close()

If you have some other questions about this plugins, you'll find my email on this page.

All your suggestions, about new features or getting better this project, are very pleased...

Last edited by dugi; 04/07/2010 at 01:37 PM.
ADreNaLiNe-DJ is offline  
Old 16/07/2007, 04:51 PM   #2
ADreNaLiNe-DJ
Huge Clucker
 
Join Date: Aug 2006
Posts: 221
Reputation: 1
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

If you don't need development packages, just download "Lite" version...
ADreNaLiNe-DJ is offline  
Old 16/07/2007, 05:16 PM   #3
ADreNaLiNe-DJ
Huge Clucker
 
Join Date: Aug 2006
Posts: 221
Reputation: 1
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

here's the mirror for lite version: http://rapidshare.com/files/43254193...-lite.zip.html
ADreNaLiNe-DJ is offline  
Old 16/07/2007, 05:56 PM   #4
d.wine
Big Clucker
 
Join Date: Sep 2006
Posts: 64
Reputation: 0
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

Shouldn't this topic be merged with this?
d.wine is offline  
Old 16/07/2007, 05:58 PM   #5
ADreNaLiNe-DJ
Huge Clucker
 
Join Date: Aug 2006
Posts: 221
Reputation: 1
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

Quote:
Originally Posted by d.wine
Shouldn't this topic be merged with this?
Nop, it's a new version and old topic was "pollued" with licensing questions.
ADreNaLiNe-DJ is offline  
Old 16/07/2007, 07:30 PM   #6
d.wine
Big Clucker
 
Join Date: Sep 2006
Posts: 64
Reputation: 0
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

Well, that's great!
d.wine is offline  
Old 16/07/2007, 09:21 PM   #7
Mike
Little Clucker
 
Join Date: Jan 1970
Posts: 19
Reputation: 47
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

Could you swing by IRC sometime? (irc://irc.gtanet.com/sa-mp.plugins)
It'd benefit everyone if you hosted this on dev.sa-mp.com, i'm generally around from 3pm onwards (GMT) and can set it up for you.
Mike is offline  
Old 16/07/2007, 09:55 PM   #8
ADreNaLiNe-DJ
Huge Clucker
 
Join Date: Aug 2006
Posts: 221
Reputation: 1
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

Ok no problem, i'll try to remember that, for tomorrow...
ADreNaLiNe-DJ is offline  
Old 17/07/2007, 10:08 AM   #9
Matite
Beta Tester
 
Matite's Avatar
 
Join Date: Dec 2006
Location: Australia
Posts: 151
Reputation: 119
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

Wow... this is going to be very handy indeed.

Cheers.

__________________

GamerX 0.3.7 Server 188.165.219.63:8800
www.gamerxserver.com
Matite is offline  
Old 17/07/2007, 02:57 PM   #10
boylett
Gangsta
 
Join Date: Jul 2006
Posts: 656
Reputation: 0
Default Re: [REL] SAMP-MySQL and SAMP-MYSQL-lite v0.11 (last edit 07-16-2007)

This is great but I have a suggestion. When reading multiple rows, why not return 1 if youve read a row and 0 otherwise, like fread. Then we could use:

Code:
while(samp_mysql_fetch_row(string))
{
  // code
}
boylett is offline  
Closed Thread

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
[FilterScript] [FS]kAdmin - Version 1.0.0 - Re uploaded Victor Filterscripts 20 16/06/2010 03:49 AM
New samp R5 version question.... sean5874 Help Archive 3 26/03/2010 08:06 PM
Samp Version R3 Bugged Eliaaz Client Support 2 19/06/2009 04:46 PM
Next SAMP version? Calgon General 25 06/01/2009 09:21 AM


All times are GMT. The time now is 08:14 AM.


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