[Plugin] [REL] MySQL Plugin (Now on github!)

Hey i get this Error:

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

Link don't work.
Reply

Here the R5 windows & linux pack.
Reply

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

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

Sorry for this idiot post.

I need any program without .NET Framework ?
Reply

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

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

Try this:
mysql_field_count() or mysql_num_fields()
Reply

Use:

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

Nvm Works. TY
Reply

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

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

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

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

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

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
Reply

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

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

try some tutorials
Reply

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


Forum Jump:


Users browsing this thread: 6 Guest(s)