DBI User Tracker
 

This plugin is a non specific user tracker. It was requested and I thought it best to post it for all interested parties who wish to track people on their servers.

If you have any problems give me a shout in this thread!

Cheers!

I have been using this plugin for almost 2 months now and testing it for god knows how long now. I have to tell you that it is a wonderful tool when used in conjuction with Zor's chat logger as well as plugins like amxbans when you want to get more detailed info on who is really who in your server or catching problem players when they aren't on the server any more and you weren't on when they caused a problem.

I have to add though that I use this with my DB.

I recommend this plugin to any admin with large and popular servers.

Been out of the loop a while guys. Thanks for that Zor.

everytime i tried making something like this the sql database would wig out when it tries to update a name with a - or a ' in it :evil:

I am just a bit too new to SQL though AMXX to understand the setup. The docs say:

"enable one of the SQL modules - mysql_amxx, pgsql_amxx, or mssql_amxx"

Which one would we use for this plugin..or does it matter?

Next:

"Once you have configured this, enable the admin_sql plugin and disable the admin plugin. "

If I enable SQL, is it essential that I disable the admin plugin? I would hate to create chaos for myself if AMXX no longer used the users.ini for all my admin info and not be real clear how to set it all up in SQL.

If you sue MYSQL, enable the MYSQL mdoules. If you use PostgreSQL, then enable that module, and if you use Microsoft SQL, enable that one. yuo'll be using MYSQL most likely..

See if the second part works without admin_sql.amxx enabled, if not, then you'll need too. Linuxmonster or whatever his name is might be master =\ made a little post about adding admins in AMXX to a database. It's just a simple insert query such as:

INSERT INTO admins ('auth', 'password', 'access', 'flags') VALUES ('STEAMID', 'PASSWORD', 'abcdefghijklmnopqrstu', 'ce')

Something similar to that, but you must be in the database.

The easiest way to add admins is to get phpmyadmin, in which you have a graphical interface to look at, but the query should still work.

Thanks f1del1ty. All that seems simple now that I found out my webserver host doesn't allow me to add additional databases. All I have is my primary, so that means I can't create an AMXX database.

Can any of this work if I make an AMXX table under my primary? Or does it have to be a database or its own?

Wher can you find that chatlogger plugin for sql ??

Thankful for answers

You can have as many tables as you want. Just keep track of the names of the tables. I use 1 of my DB's specifically for the Plugins for amxmodx, that way I only need to setup once my sql settings in the amxmodx sql.cfg

Cheers!

As for the Chat Tracker, that can be found at www.dodplugins.net

CHeers!

So this logs names and steam idS?