SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 24/01/2010, 02:28 PM   #11
Eazy_Efolife
High-roller
 
Join Date: Aug 2009
Posts: 1,203
Reputation: 15
Default Re: [REL] SA:MP MySQL Plugin 1.0

Good work.
Eazy_Efolife is offline   Reply With Quote
Old 24/01/2010, 02:55 PM   #12
Dreftas
Gangsta
 
Join Date: May 2008
Posts: 639
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Damn.. crashed
Dreftas is offline   Reply With Quote
Old 24/01/2010, 03:08 PM   #13
Misiek
Big Clucker
 
Join Date: May 2006
Posts: 114
Reputation: 11
Default Re: [REL] SA:MP MySQL Plugin 1.0

I'd use it as soon as possible if it had multithreading capabilities like G-Stylezz's one does.
Otherwise another MySQL plugin is usable only for a tiny group of people here and I advise you to go this way.

Regards.
__________________
net4game
Misiek is offline   Reply With Quote
Old 24/01/2010, 03:32 PM   #14
Toney
Big Clucker
 
Join Date: Oct 2009
Posts: 117
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Dreft maybe do you want post more info about crashed.. I test it , works fine.
Toney is offline   Reply With Quote
Old 24/01/2010, 05:01 PM   #15
Dreftas
Gangsta
 
Join Date: May 2008
Posts: 639
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

It crashes on a long row which is taken with mysql_fetch_field. Row is ~1050 symbols lenght.
Dreftas is offline   Reply With Quote
Old 24/01/2010, 05:05 PM   #16
StrickenKid
Gangsta
 
Join Date: Feb 2009
Posts: 773
Reputation: 41
Default Re: [REL] SA:MP MySQL Plugin 1.0

Quote:
Originally Posted by Dreft
It crashes on a long row which is taken with mysql_fetch_field. Row is ~1050 symbols lenght.
I will check that right now. Thanks.

EDIT:

Ok, I've tested it with 3000 characters and the plugin worked fine, I then tried to print the row and that is what crashed it. So make sure you're not printing a row with ~1500 characters in it.
Also, make sure your buffer string that your saving the row to is ~1500 characters because that would cause a crash.

Quote:
Originally Posted by Jay_
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.
The reason for me creating this plugin is to let SA:MP have the most stable plugin, because the other 2 MySQL plugins that are released indeed have bugs and those bugs haven't been fixed yet. And these bugs were found many months ago....

So no, my plugin doesn't have a threaded callback, but, I wouldn't want to add that because that's unique to G-Stylezzz plugin, and in my opinion that would just cause trouble to be copying features from others.

This was also created for speed, as far as I know, its faster than adrenaline-dj's plugin (haven't tested g-stylezzz plugin yet) but i did some testing on my plugin and it takes arround 1.0 to 1.3 seconds to execute 5,000,000 (5 million) mysql_fetch_row's. I tested the same on adrenaline-dj's plugin, and it crashed.
StrickenKid is offline   Reply With Quote
Old 24/01/2010, 05:48 PM   #17
MenaceX^
High-roller
 
Join Date: Aug 2008
Posts: 3,782
Reputation: 13
Default Re: [REL] SA:MP MySQL Plugin 1.0

I wonder if you'll make a debug mode.
If yes talk to me, I have several suggestions.
MenaceX^ is offline   Reply With Quote
Old 24/01/2010, 05:58 PM   #18
StrickenKid
Gangsta
 
Join Date: Feb 2009
Posts: 773
Reputation: 41
Default Re: [REL] SA:MP MySQL Plugin 1.0

Quote:
Originally Posted by MenaceX^
I wonder if you'll make a debug mode.
If yes talk to me, I have several suggestions.
mysql_log(1); will turn on logging (debugging) The plugin also automatically prints errors you make to the server window.

For example:

Code:
mysql_query("select * from `accounts` where user_id = 5");
new buffer[1024];
mysql_fetch_row(buffer);
mysql_free_result();
In the code above, I never did mysql_store_result, so, you will get the folloing error in the server window:
"MySQL error: 'mysql_fetch_row' called when no result stored."

But yeah, well talk on MSN later.
StrickenKid is offline   Reply With Quote
Old 24/01/2010, 06:19 PM   #19
Dreftas
Gangsta
 
Join Date: May 2008
Posts: 639
Reputation: 0
Default Re: [REL] SA:MP MySQL Plugin 1.0

Ok, i turned off mysql_log() which was printing that all row and crash gone I wish that you fix this problem :P

Thanks for plugin again, it will change old G-Stylezz plugin for sure
Dreftas is offline   Reply With Quote
Old 24/01/2010, 06:45 PM   #20
Blantas
Huge Clucker
 
Blantas's Avatar
 
Join Date: Feb 2009
Posts: 346
Reputation: 16
Default Re: [REL] SA:MP MySQL Plugin 1.0

Looks good. I'll check it out tomorow.
Blantas 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 6129 14/11/2017 10:24 AM
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 12:55 PM
Mysql Plugin Help Jbosh123 Help Archive 0 04/09/2009 12:35 PM


All times are GMT. The time now is 05:28 PM.


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