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.
Comments
-
RayHerring Owner
-
View User Profile
-
Send Message
Posted Nov 2, 2013If you have citizens installed, you will get an error.
-
View User Profile
-
Send Message
Posted Aug 6, 2013It 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.
-
View User Profile
-
Send Message
Posted Aug 5, 2013does it work for 1.6.2?
-
View User Profile
-
Send Message
Posted Aug 5, 2013Really love this plugin! Will you keep update it in the future?
-
View User Profile
-
Send Message
Posted Jun 21, 2013@Bogblob
My WorldTimeTracker plugin does exactly that.
-
View User Profile
-
Send Message
Posted Jun 7, 2013Could we add a total time online to this ?
-
View User Profile
-
Send Message
Posted Jun 7, 2013It 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.
-
View User Profile
-
Send Message
Posted Jun 1, 2013Works well on 1.5.2 :-)
-
View User Profile
-
Send Message
Posted May 29, 2013@jdcvanderwal
Try before cry.
Works without hassle on CB 1.5.2
-
View User Profile
-
Send Message
Posted May 29, 2013Update?
-
View User Profile
-
Send Message
Posted May 21, 2013Does it work on 1.5.2?
-
View User Profile
-
Send Message
Posted May 9, 2013well creating views then to getting the info from all servers is not that nice, but ur right, its possible ;D will try that :P
-
View User Profile
-
Send Message
Posted May 9, 2013@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.
-
View User Profile
-
Send Message
Posted May 8, 2013Can 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...
-
View User Profile
-
Send Message
Posted May 1, 2013Oh, i've test your plugin : you are a genius ! Awesome, very nice plugin !! Good work !
-
View User Profile
-
Send Message
Posted Apr 30, 2013Thanks for your explanation
-
View User Profile
-
Send Message
Posted Apr 30, 2013@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.
-
View User Profile
-
Send Message
Posted Apr 29, 2013What plugin we should use ? OnlinePlayersSQL or WorldTimeTracker ?
-
View User Profile
-
Send Message
Posted Apr 19, 2013I'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/
-
View User Profile
-
Send Message
Posted Apr 18, 2013Hi,
it would be great to see how long a player was online on the server.
So we can give them a reward!