Raised This Month: $161 Target: $400

[ANY] Player Analytics

Thread Tools Display Modes
Prev Previous Post   Next Post Next
Dr. McKay
Sir Dr. SourceMod Plugin Approver Esq. Ltd. M.D. PhD
Join Date: Aug 2011
Location: Atlantis
Plugin ID:
Plugin Version:
Plugin Category:
Plugin Game:
Plugin Dependencies:
    Servers with this Plugin:
    Plugin Description:
    Logs detailed statistics for all connecting players
    Old 12-02-2013 , 21:33   [ANY] Player Analytics
    Reply With Quote #1

    [ANY] Player Analytics


    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.

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

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

    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

    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:

            "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.

    • 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.
    Attached Files
    File Type: zip rannmann-player-analytics-preview1.zip (325.4 KB, 2019 views)

    Last edited by Dr. McKay; 05-26-2015 at 18:15.
    Dr. McKay is offline

    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 13:53.

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