[Sight18]

hello guys,

is there a plugin around that tracks all the players joining the servers and counts them then writes it to a file, so we can keep track of our monthly visitors.

i did a search in both here and google but havent found anything,

any replies would be appreciated.

[Exolent[jNr]]

Installation:
1. Install .amxx file normally.
2. Open connections_logger.cfg and put in your MySQL information.
3. Place connections_logger.cfg in addons/amxmodx/configs folder.

Getting Stats
You can get all connections in a month by doing this query: (example for July 2012 connections)
SELECT COUNT(*) FROM `connections` WHERE `timestamp` >= '2012-07-01 00:00:00' AND `timestamp` < '2012-08-01 00:00:00';

You can get all unique (by steamid) connections in a month by doing this query: (example for July 2012 connections)
SELECT COUNT(*) FROM `connections` WHERE `timestamp` >= '2012-07-01 00:00:00' AND `timestamp` < '2012-08-01 00:00:00' GROUP BY `steamid`;