SA-MP Forums Archive
[Plugin] [REL] MySQL Plugin (Now on github!) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)



Re: [REL] MySQL Plugin R5 (04/09/10) - Jony_King - 10.01.2011

Hey i get this Error:

Invalid Connection Handle (handle id 1, max is 0)


Re: [REL] MySQL Plugin R5 (04/09/10) - Aleks7 - 11.01.2011

Link don't work.


Re: [REL] MySQL Plugin R5 (04/09/10) - kurta999 - 11.01.2011

Here the R5 windows & linux pack.


Re: [REL] MySQL Plugin R5 (04/09/10) - XFlawless - 12.01.2011

Most stable MYSQL plugin release, Good Job !
Looking forward for more updates and releases by you.


Re: [REL] MySQL Plugin R5 (04/09/10) - JaTochNietDan - 13.01.2011

Quote:
Originally Posted by Jony_King
Посмотреть сообщение
Hey i get this Error:

Invalid Connection Handle (handle id 1, max is 0)
Are you specifying a connection handle? If so, then don't, there's no reason to specify a connection handle unless you're actually making multiple connections for some reason.


Re: [REL] MySQL Plugin R5 (04/09/10) - kurta999 - 15.01.2011

Sorry for this idiot post.

I need any program without .NET Framework ?


Re: [REL] MySQL Plugin R5 (04/09/10) - Calgon - 15.01.2011

Quote:
Originally Posted by kurta999
Посмотреть сообщение
Sorry for this idiot post.

I need any program without .NET Framework ?
.NET framework is required, you need it to use this, you can't run the plugin without it.


Re: [REL] MySQL Plugin R5 (04/09/10) - Alice[WS] - 19.01.2011

Nice plugin

I wanted to know, since i've threaded some queries my server freezes sometimes. By checking in the logs i can find "Data is getting passed to OnQueryFinish() - (Threadsafe: No)".
What does that "Threadsafe: No" mean ? I think it has something to do with the MySQL server's configuration, the threaded queries cannot execute in the specified thread, but i am not sure.

If it has an importance, how could i activate it ?

Thanks in advance.


Re: [REL] MySQL Plugin R5 (04/09/10) - kurta999 - 21.01.2011

Try this:
mysql_field_count() or mysql_num_fields()


Re: [REL] MySQL Plugin R5 (04/09/10) - Kaylux - 22.01.2011

Use:

pawn Код:
mysql_fetch_field_row(result,"Feild");
if(mysql_warning_count())
{
     //Error (Probobly dosent exist)
}



Re: [REL] MySQL Plugin R5 (04/09/10) - yanir3 - 26.01.2011

Nvm Works. TY


Re: [REL] MySQL Plugin R5 (04/09/10) - ludow12 - 26.01.2011

Hello. mysql_reconnect checks the connexion before reconnect on the database ?


Re: [REL] MySQL Plugin R5 (04/09/10) - [NoV]LaZ - 28.01.2011

Since I'm using two connections, the server is crashing when I shut it down. I'm also using mysql_close for each connection.


Re: [REL] MySQL Plugin R5 (04/09/10) - mick88 - 29.01.2011

I have a question: Do threaded queries create own connection? I assume not, but always when I use threaded queries I get error max_user_connections exceeded.


Re: [REL] MySQL Plugin R5 (04/09/10) - JaTochNietDan - 29.01.2011

Quote:
Originally Posted by mick88
Посмотреть сообщение
I have a question: Do threaded queries create own connection? I assume not, but always when I use threaded queries I get error max_user_connections exceeded.
That's a problem with the MySQL database settings rather than the plugin.


Re: [REL] MySQL Plugin R5 (04/09/10) - mick88 - 29.01.2011

Quote:
Originally Posted by JaTochNietDan
Посмотреть сообщение
That's a problem with the MySQL database settings rather than the plugin.
Which setting do you have in mind? You didn't quite answer my question. I just wanted to make sure the plugin doesn't create new connections. My connection limit is 10 (ServerFFS) and I don't see how I would be exceeding that limit.


EDIT:
This is what I'm getting after starting the server and players connecting:


There is some idling connections that I can kill off manually. They normally don't appear and instead I have 2 processes: gameserver and phpMySQL. mysql_connect() occurs only once in my gamemode in OnGamemodeInit()


Re: [REL] MySQL Plugin R5 (04/09/10) - RFT - 07.02.2011

Hi,

I have a little problem with the plugin.
I have written a function that returns me the registered user.
On Windows it works without problems. But on Linux I get back the value -1.
I tried it with the plugin R4 and R5 but without success.


stock mysql_GetFields()
{
mysql_query("SELECT id FROM Spieler");
mysql_store_result();
new rows = mysql_num_rows();
mysql_free_result();
return rows;
}

Sorry for my bad english


Re: [REL] MySQL Plugin R5 (04/09/10) - nemesis- - 12.02.2011

Quote:
Originally Posted by Tupac
Посмотреть сообщение
is OnQueryFinish better than using a custom callback for threaded queries?
Not really. Though, for UPDATEs, DELETEs, and INSERTs, you have to create a function which just returns 1 and does nothing else as the mysql_callback_query function requires a callback/function to be entered. I didn't do that. I left UPDATE/DELETE/INSERTs inside OnQueryFinish. There was really no point in changing.


Re: [REL] MySQL Plugin R5 (04/09/10) - Donya - 31.03.2011

http://www.freewebmasterhelp.com/tutorials/phpmysql

try some tutorials


Re: [REL] MySQL Plugin R5 (04/09/10) - Span1ard - 04.04.2011

Код:
- the plugin reconnects automatically incase you are using a threaded callback
possible disable it?