OnlinePlayersSQL

Table of Contents

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.

Comments

_ForgeUser7468594
- Join Date: 8/30/2011
- Posts: 133
- Member Details
#165 _ForgeUser7468594

View User Profile

Send Message

Posted Apr 17, 2013
@ray73864

That's actually along the lines of what I'm planning as well, looking forward to seeing your next plugin which seems to do the job :)

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#164 RayHerring

View User Profile

Send Message

Posted Apr 16, 2013
Didn't get to do much with my other plugin last weekend, had no internet from Friday night till Monday lunchtime due to faults in the line.

Was extremely painful too :(

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#163 RayHerring

View User Profile

Send Message

Posted Apr 16, 2013
@Realwarior

OOoh, nice looking. Never really thought of making a more fancy thing like that.

Rollback Post to Revision RollBack
_ForgeUser9457233
- Join Date: 8/23/2012
- Posts: 6
- Member Details
#162 _ForgeUser9457233

View User Profile

Send Message

Posted Apr 14, 2013
Ye i messed around and tinkered with some code etc... managed to make a small stats page from it. stats.realzserver.com if you are interested to see what I put together.

Last edited by _ForgeUser9457233: Apr 14, 2013

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#161 RayHerring

View User Profile

Send Message

Posted Apr 11, 2013
@iSeven77

Nope, mine isn't even close.

The only things it stores in the database is the playername, the world they were in, and how much time they spent in that world.

Rollback Post to Revision RollBack
iSeven77
- Join Date: 9/14/2011
- Posts: 48
- Member Details
#160 iSeven77

View User Profile

Send Message

Posted Apr 10, 2013
@ray73864

so is it kind of like http://dev.bukkit.org/server-mods/performance-monitor/ ? Performance Monitor

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#159 RayHerring

View User Profile

Send Message

Posted Apr 10, 2013
Will release the WorldTimeTracker plugin this weekend, just have to clean up one remaining issue it has, which doesn't stop it from working, is just an annoying thing that pops up in the logfile when you first start the server up.

The WTT plugin keeps track of players from the moment they first join, it tracks how long they have been in each world, etc...

To get an overall idea of how long a player has played on your server, you would just sum up all the world times to get the overall time.

Rollback Post to Revision RollBack
iSeven77
- Join Date: 9/14/2011
- Posts: 48
- Member Details
#158 iSeven77

View User Profile

Send Message

Posted Apr 7, 2013
@Realwarior

i modified your file a bit http://pastebin.com/AerYP4PE THANKS !! for posting it

Rollback Post to Revision RollBack
_ForgeUser10850747
- Join Date: 3/27/2013
- Posts: 17
- Member Details
#157 _ForgeUser10850747

View User Profile

Send Message

Posted Apr 5, 2013
Eh. A great plugin, but if that "WorldTimeTracker" isn't released, I'll release a plugin of the same function. :P Would be useful if you released as my intention isn't to "steal", but to help others.

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#156 RayHerring

View User Profile

Send Message

Posted Apr 3, 2013
@iSeven77

Yeah, not sure what is up with the first login.

I do have another non-released plugin called 'WorldTimeTracker' which keeps track of the other information though.

Rollback Post to Revision RollBack
iSeven77
- Join Date: 9/14/2011
- Posts: 48
- Member Details
#155 iSeven77

View User Profile

Send Message

Posted Apr 1, 2013
@ray73864

Thanks for this plugin :) any way to get more info ? like time user is been playing and/or the first login is always NULL thanks any ways :)

Rollback Post to Revision RollBack
iSeven77
- Join Date: 9/14/2011
- Posts: 48
- Member Details
#154 iSeven77

View User Profile

Send Message

Posted Apr 1, 2013
@Realwarior

Thanks You file help me a lot :) i moded a little bit but your file help me a lot THANKS again :P

Rollback Post to Revision RollBack
_ForgeUser7467753
- Join Date: 8/30/2011
- Posts: 81
- Member Details
#153 _ForgeUser7467753

View User Profile

Send Message

Posted Apr 1, 2013
Now that simplyvanished has been abandoned, can you add support for Vanishnopacket?

Rollback Post to Revision RollBack
_ForgeUser9457233
- Join Date: 8/23/2012
- Posts: 6
- Member Details
#152 _ForgeUser9457233

View User Profile

Send Message

Posted Feb 26, 2013
I decided to make a php file that will organize people by their rank. I personally made this for a friend liquidiceservers.com/mincraft.php if you would like to see it in action. If you want the code realzserver.com/downloads/online.txt .

Last edited by _ForgeUser9457233: Mar 17, 2013

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#151 RayHerring

View User Profile

Send Message

Posted Feb 25, 2013
@Phyore

I probably could.

It is strange that you would run below 20TPS though. Even when we were on our crappy server it didn't cause any issues like that.

Rollback Post to Revision RollBack
_ForgeUser6941066
- Join Date: 6/1/2011
- Posts: 343
- Member Details
#150 _ForgeUser6941066

View User Profile

Send Message

Posted Feb 13, 2013
@ray73864

Cool tnx!

Rollback Post to Revision RollBack
_ForgeUser7152613
- Join Date: 7/6/2011
- Posts: 55
- Member Details
#149 _ForgeUser7152613

View User Profile

Send Message

Posted Feb 13, 2013
Hmm not sure what's happening maybe the constant posting to the database, but my server was starting to run below 20 TPS. Think you could add a customisable option for how long it syncs the players to the database?

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#148 RayHerring

View User Profile

Send Message

Posted Feb 11, 2013
New version 1.7.0 posted.

With this version, if you set the 'track_only_allowed_players' config option to 'true' then it will only tack players who have the 'onlineplayerssql.allowed' permission set on them.

Last edited by _ForgeUser7840837: Feb 11, 2013

Rollback Post to Revision RollBack
RayHerring
- Join Date: 5/1/2011
- Posts: 409
- Member Details
#147 RayHerring

View User Profile

Send Message

Posted Feb 11, 2013
@pandapipino

It most certainly could, yes.

It'll be a config option, such as: trackOnlyAllowedPlayers: true/false

That way the system will know which way to go.

Rollback Post to Revision RollBack
_ForgeUser6941066
- Join Date: 6/1/2011
- Posts: 343
- Member Details
#146 _ForgeUser6941066

View User Profile

Send Message

Posted Feb 10, 2013
Can this have a permission? for whom groups or players allows this plugin to track? Thanks

ex: onlineplayerssql.allow

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

37787
Created

Mar 21, 2012
Last Released File

Jun 14, 2014
Total Downloads

16,032
License

GNU General Public License ver...

Bukkit

OnlinePlayersSQL

Bukkit Plugins