Raised This Month: $59 Target: $400
 14% 

DBI User Tracker


Post New Thread Reply   
 
Thread Tools Display Modes
Plugin Info:     Modification:   ALL        Category:   Server Management        Approver:   Johnny got his gun (102)
Zor
Veteran Member
Join Date: Mar 2004
Location: Toronto, ON
Old 01-20-2005 , 15:22   DBI User Tracker
Reply With Quote #1

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.

Quote:
Versioning:
v0.1
- Be

v0.2
-Updated it to use the new dbi interface
Quote:
CVARS:
sql_user_logger_table "user_logger" (Default)
-This is the table that will be used to hold the data that is to be stored

logger_debug "0" = Off (Default) 1 = On
-This will log alot of crap to the amxx logs so that the developer can better fix any problems
Quote:
Commands:
amx_userinfo < user | steamid >
- No longer does the user have to be on the server, you can use a name to get what you want, or a steam id etx. It will check to see if something like this is in the data base

amx_trim_users
- This will trim away all user names and ips, it will however keep the STEAM ID for future use.
If you have any problems give me a shout in this thread!

Cheers!
Attached Files
File Type: sma Get Plugin or Get Source (amxx_logger.sma - 1566 views - 13.2 KB)
File Type: txt logger.txt (410 Bytes, 499 views)
__________________
Zor is offline
Send a message via AIM to Zor Send a message via MSN to Zor Send a message via Yahoo to Zor
pendragon
Senior Member
Join Date: Mar 2004
Location: In a bubble
Old 01-20-2005 , 17:44  
Reply With Quote #2

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.
__________________
pendragon is offline
Send a message via ICQ to pendragon Send a message via AIM to pendragon Send a message via MSN to pendragon
Trip~Hazard
Senior Member
Join Date: Jun 2004
Location: North Carolina
Old 02-11-2005 , 13:59  
Reply With Quote #3

Been out of the loop a while guys. Thanks for that Zor.
Trip~Hazard is offline
TotalNoobScripter
Senior Member
Join Date: Aug 2004
Old 02-11-2005 , 20:51  
Reply With Quote #4

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
TotalNoobScripter is offline
Send a message via AIM to TotalNoobScripter
Trip~Hazard
Senior Member
Join Date: Jun 2004
Location: North Carolina
Old 02-16-2005 , 16:57  
Reply With Quote #5

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.
Trip~Hazard is offline
f1del1ty.oXi
Veteran Member
Join Date: Nov 2004
Old 02-16-2005 , 17:39  
Reply With Quote #6

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.
__________________
f1del1ty.oXi is offline
Trip~Hazard
Senior Member
Join Date: Jun 2004
Location: North Carolina
Old 02-16-2005 , 18:31  
Reply With Quote #7

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?
Trip~Hazard is offline
lantz69
AMX Mod X Beta Tester
Join Date: Mar 2004
Location: Sweden, Skåne
Old 02-16-2005 , 20:17  
Reply With Quote #8

Wher can you find that chatlogger plugin for sql ??

Thankful for answers
__________________
Using: Amxmodx 1.8.1.xxxx, cstrike
http://www.vanilla.se/
lantz69 is offline
Zor
Veteran Member
Join Date: Mar 2004
Location: Toronto, ON
Old 02-18-2005 , 15:18  
Reply With Quote #9

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!
__________________
Zor is offline
Send a message via AIM to Zor Send a message via MSN to Zor Send a message via Yahoo to Zor
Sharp
Senior Member
Join Date: May 2004
Location: Silent Assassins
Old 03-03-2005 , 17:28  
Reply With Quote #10

So this logs names and steam idS?
__________________

Silent Assasins Clan Server
24.141.240.212:27011
Sharp is offline
Send a message via MSN to Sharp
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 05:46.


Powered by vBulletin®
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Theme made by Freecode