OnlinePlayersSQL

Description

This plugin will update a MySQL database table with a list of players as the join and disconnect from your game.

Originally created for the MCAddictGallery server, it was created so that we could have a live player listing on our website with minimal of fuss.

Currently the plugin tracks the following information:

• Player Name
• Previous World (used for when a player warps from one world to another)
• Current World (the current world the player is in)
• IP Address
• Logon Time (stored as seconds since epoch)
• Players permission group
• Flag to say whether the player is online or not.

Required Plugins to use this one

• Vault

Optional Plugins that provide extra features

• SimplyVanish - Not required, but if you want the players list to not show vanished players, then you will likely want this.

Configuration

config.yml

MySQLServer: localhost
MySQLPort: '3306'
MySQLUsername: <username for db>
MySQLPassword: <password for db>
MySQLDatabase: <database to use>
MySQLTable: <table to use>
showDebug: true|false
op_only_resync: true|false

eg.

MySQLServer: localhost
MySQLPort: '3306'
MySQLUsername: player_tracker
MySQLPassword: fred123
MySQLDatabase: player_tracker
MySQLTable: online_players
showDebug: false
op_only_resync: false

This plugin will check to see if the necessary table exists in 'MySQLDatabase' and if it doesn't, it will create it.

showDebug will put debug information in the console allowing you to follow along what the plugin does when a player connects/disconnects.

op_only_resync determins if only ops can use '/onl resync' or not.

An example php file can be found here: http://dev.bukkit.org/server-mods/online-players-sql/pages/example-php-file/

It should work just fine, though you will need to change values where necessary for your mysql logon information.

Information about each function used can naturally be found at the php.net website.