[Dr. McKay]

[ANY] Player Analytics

v1.3.1

Description:
This plugin logs detailed statistics of all connecting players to a MySQL table. Stats that are logged include:

• Server IP
• Player name
• Steam ID
• Time of connection (as Unix timestamp)
• Date of connection
• Connection method (on games that support cl_connectmethod)
• Number of players in-game at time of connection
• Current map at time of connection
• Duration of play session
• User admin flags
• User IP
• Player's city, region, 2-letter country code, and 3-letter country code (requires GeoIPCity)
• Player's country
• Player's F2P/Premium status (TF2 only, requires SteamTools)
• Player's HTML MOTD preference (enabled/disabled)
• Player's operating system

There will be a web interface later with which you can view the stats. In the meantime, you'll have to use something like phpMyAdmin to see the raw logs.

Cvars:

• player_analytics_version - plugin version
• player_analytics_auto_update - enables automatic updating (has no effect if Updater is not installed)

Developers:
Player Analytics has an API with which you can get player connection IDs. See the include file.

Requirements:
Both of these extensions are optional dependencies. That is, they are not required for the plugin to operate.

• GeoIPCity - Required to look up players' cities, regions, and country codes
• SteamTools - Required to detect the server's public IP behind a NAT and to look up Premium/F2P status on TF2

Installation:
This plugin requires a MySQL database. It will first look for a configuration named "player_analytics", and will fall back to "default" if one is not found. Example:

    "player_analytics"
    {
        "driver"            "mysql"
        "host"                "example.com"
        "database"            "example_database"
        "user"                "exampleuser"
        "pass"                "examplepassword"
        //"timeout"            "0"
        "port"                "3306"
    }

This should go in databases.cfg.

Install any optional extension dependencies that you want, and then put player_analytics.smx into /addons/sourcemod/plugins and os_detect.games.txt into /addons/sourcemod/gamedata and reboot your server or type "sm plugins load player_analytics" into your console or rcon.

Auto Update:
Install Updater. The plugin will be auto-updated according to your Updater settings. It'll work without Updater.

Changelog:

• v1.3.0 (4/3/15)
  • Plugin now uses utf8 queries
• v1.2.0 (3/31/15)
  • Added plugin API
• v1.1.0 (12/7/13)
  • Updated OS detection
• v1.0.0 (12/2/13)
  • Initial release

Download Plugin (player_analytics.zip)

.zip file includes plugin, gamedata, source, and include file

Requires updater.inc and mckayupdater.sp to compile.
______________________________

I have attached a development preview of the web panel. It's still in development so there are a lot of broken links and placeholder items. Simply set your variables in config_example.php and rename it to config.php

Web panel is by rannmann.

[Dr. McKay]

The development web panel is very limited, and a community member has taken it on themselves to build on it. You may want to use it:

https://forums.alliedmods.net/showpo...8&postcount=69

[ocwoody]

Awesome! Thanks for releasing this!

[Dr. McKay]

I've attached a development preview of the web panel to the main post.

[Mirandor]

hi,
does or will it store multiple player names?

[nomy]

Very useful! Thanks Dr. McKay!

[Impact123]

Is there a reason why you connect non-threaded to the database?
In some countries it's not permitted (or atleast it's a grey area) to store dynamic ip's, you might want to add an option to anonymize it.
Some of the columns are a little bit too big (auth and ip for example), sure it makes no big difference, but it sums up for long-term data like this.

[matrixmark]

This looks awesome.

Will be giving it a try tonight

[Dr. McKay]

Originally Posted by Impact123 Is there a reason why you connect non-threaded to the database? In some countries it's not permitted (or atleast it's a grey area) to store dynamic ip's, you might want to add an option to anonymize it. Some of the columns are a little bit too big (auth and ip for example), sure it makes no big difference, but it sums up for long-term data like this.

SQL_TQuery doesn't support the persistent parameter, and I like to conserve connections. Since it only connects on plugin startup, it won't block the server since realistically plugin startup will only be on server startup.

I find it somewhat questionable that it wouldn't be legal to store the IP address associated with a connection. If that were the case, then SRCDS itself would be in question due to its logs, which are stored indefinitely. If you can provide me a source, I might be able to add an option to not log IPs.

[Impact123]

An threaded connection handle stays valid until you close it, persistant connections are kinda default for it.