Tracker: Feature Requests

5 adminmod mysql interface - ID: 541952
Last Update: Comment added ( nobody )

I have been programming a few plug-ins from time to
time, and I am now at the point where I cannot get
enough information from the HL/adminmod interface,
like teamkills, teaminjuring, team performance and
stats treatment of any sort. The amount of info you
can get from the HL engine is very limited.

We already have a real-time log parser putting all the
data into tables (the structure is rather elaborate)
in a MySQL database (both parser and database running
on a different maching, of course, to save those
cycles for the CounterStrike server).

So I plan to build an interface between adminmod, and
an external MySQL database. So that adminmod can send
queries to the MySQL database and get recordsets in
return. This way it will be possible to get all kind
of information from inside adminmod plug-ins (yippeee).

The way I plan to do this is to use the linux/unix
feature named pipes, or fifos. As win32 doesn't have
this feature, it will be something that will only work
on linux servers, but as these represent more than
half of all servers out there, it should still be
interesting. A named pipe seems like an ordinary file,
but is in reality a fifo queue. Adminmod already has
an interface towards files, so there is only a matter
of writing a perl script on "the other side" to send
queries to the mysql database.

So, I'd like to know, before starting the project, if
anyone tried the same, if it is worth the work, things
like that.

---jAz---


Asgeir Nesøen ( jazzgeir ) - 2002-04-10 12:05

5

Open

None

Nobody/Anonymous

None

None

Public


Comments ( 3 )




Date: 2007-08-19 16:04
Sender: nobody

Logged In: NO

cum naiba sa le downloadez k nu merge in nici un fel:((:(((:((.......caut
adminmod...si de toate pt erver si nu gasesc nimik.....



Date: 2002-07-28 18:32
Sender: the_wraith

Logged In: YES
user_id=281806

Win32 does have named pipes. I'm not sure about 98 based
versions but NT versions certainly do.


Date: 2002-04-11 12:26
Sender: daropeProject Admin

Logged In: YES
user_id=169860

If I understood you correctly you are planning an external
db interface that can be accessed from plugins via file read
and write functions. To my knowledge nobody has tried that
before.

It sounds like a nice idea since it would work with the
current AM version. We have plans of adding SQL functions to
the set of available plugin functions in the future. That
way you could access the db diretly from the plugins. But it
will still be quite some time before this gets done.

I'm sure there would be some interest in your solution by
Linux admins.


Log in to comment.

Attached File

No Files Currently Attached

Change

No changes have been made to this artifact.