[Jony_King]

Hey i get this Error:

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

[Aleks7]

Link don't work.

[kurta999]

Here the R5 windows & linux pack.

[XFlawless]

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

[JaTochNietDan]

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.

[kurta999]

Sorry for this idiot post.

I need any program without .NET Framework ?

[Calgon]

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.

[Alice[WS]]

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.

[kurta999]

Try this:
mysql_field_count() or mysql_num_fields()

[Kaylux]

Use:

pawn Код:

mysql_fetch_field_row(result,"Feild"); 
if(mysql_warning_count()) 
{
     //Error (Probobly dosent exist)
}

[yanir3]

Nvm Works. TY

[ludow12]

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

[[NoV]LaZ]

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

[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.

[JaTochNietDan]

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.

[mick88]

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()

[RFT]

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

[nemesis-]

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.

[Donya]

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

try some tutorials

[Span1ard]

Код:

- the plugin reconnects automatically incase you are using a threaded callback

possible disable it?