[ymboc]

Originally Posted by GIR Aha.... You do realize that this is exactly the same as admin_mysql except the SQL query is a little different. Apart from that it is the same damn plugin provided with amxmod x. Now if this plugin would cause lag, then the regular admin_mysql plugin would cause lag aswell, which would mean that people would start complaining about it. Nobody, except you, is complaining.

<sarcasm>Oh that's constructive. </sarcasm> sigh....

This plugin does a fair bit more than admin_mysql. In addition to granting admin rights it checks every user at every connect to see if they're banned from the server or not... one query per every connect. Do you see the potential for lag?

The actual assigning of admin privs doesn’t cause lag - I will agree to that, because from what I can tell it queries the db only once per map change (vs every time a user connects). However, the bans are a different story altogether - it queries the db on every connect.

So now... putting 2 and 2 together.... On a full server, with a reserved slot, the server maintains an open slot for players to connect to (and check if they have access to reserved slots). Throw in a couple of players who are determined to hammer the server until they get on and you have a recipe for lag.

You can measure the effects of a single such query to the database by executing the amx_find command that is included in the plugin (Did you try this before you proceeded to flame me? - I suspect not). Now maybe your sql server is right next to your cs server and is doing nothing but hosting that one database, then surely the 'issue' is less visible. But you know what, run several successive amx_find's (hold down enter in hlsw if you must ) and you'll see what I mean despite that.

The problem does exist. No, it doesn’t make the game unplayable but it does cause blips in the ping.

Furthermore this issue has been brought up in the amxmod forums (and a request for a threaded version of the plugin - and no, not by me).

Now finally... I am not complaining about this plugin. I like this plugin. It has made my life much easier. It is a good plugin. I will continue to use this plugin. I am just saying this good plugin could use some improvement.