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.
If you have citizens installed, you will get an error.
It should continue to work perfectly for 1.6.2, just like it did for 1.5.
I'll update it to the latest versions of bukkit if it is required, or there is a necessary feature that it is missing, but for the most part, the plugin does quite a lot of handy stuff.
does it work for 1.6.2?
Really love this plugin! Will you keep update it in the future?
@Bogblob
My WorldTimeTracker plugin does exactly that.
Could we add a total time online to this ?
It should indeed work extremely well on 1.5.2. It isn't like some of the bigger plugins.
My plugins generally all use limited features from bukkit to do exactly what they need to do.
Works well on 1.5.2 :-)
@jdcvanderwal
Try before cry.
Works without hassle on CB 1.5.2
Update?
Does it work on 1.5.2?
well creating views then to getting the info from all servers is not that nice, but ur right, its possible ;D will try that :P
@FR34KYN01535
You already can to an extent. Set the plugin up on both servers, set them up to use the same database, but have them both use different tables. such as: server1_players and server2_players.
Can you make it possible to let this plugin put infos from multiple servers into one database? I got the feeling that when a user joins from one to the second server, the second server hits the database first writing a 1 into online, and then the first inserts the 0 for going ofline on that...
Oh, i've test your plugin : you are a genius ! Awesome, very nice plugin !! Good work !
Thanks for your explanation
@JohOply
Entirely up to you.
WorldTimeTracker only keeps track of time spent in a particular world on your server, it does not tell you whether they are online right now or not.
OnlinePlayersSQL tells you whether they are online or not, and it also tells you what world they are currently in and which world they were in previous to that.
each plugin has its purpose, if you want a live player listing, OPSQL it is, if you want to give rewards for amount of time spent in a world (on our server, we have an manual promotion thing on our website (once logged in) that calculates your time spent on the server and allows you to rank yourself from guest to member. For that, we use WTT.
What plugin we should use ? OnlinePlayersSQL or WorldTimeTracker ?
I'm not sure if you can see this before it has been approved, but here is the link to the WorldTimeTracker plugin: http://dev.bukkit.org/server-mods/worldtimetracker/
And the download for it: http://dev.bukkit.org/server-mods/worldtimetracker/files/1-world-time-tracker-v0-1/
Hi,
it would be great to see how long a player was online on the server.
So we can give them a reward!