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

Forge_User_80075269
- Join Date: 2/9/2012
- Posts: 433
- Member Details
#247 Forge_User_80075269

View User Profile

Send Message

Posted Jul 5, 2015
Hi !

Seems be have a leaks of memory in 1.8.7. Could you up to date with MC 1.8.7 to fix any problem please ? :)

Rollback Post to Revision RollBack
_ForgeUser11941889
- Join Date: 7/29/2013
- Posts: 249
- Member Details
#246 _ForgeUser11941889

View User Profile

Send Message

Posted Dec 31, 2014
Mate are you still active here? I hope you are. Great job

Rollback Post to Revision RollBack
_ForgeUser7745776
- Join Date: 10/22/2011
- Posts: 120
- Member Details
#245 _ForgeUser7745776

View User Profile

Send Message

Posted Dec 3, 2014
Hey, nice Work! @ray73864 Are you still active here? I have a two suggestions:

1. Please support this plugin too http://dev.bukkit.org/bukkit-plugins/vanish/

2. For the upcoming name changing feature, may its better when the table has a primary key. I think its not hard to add or?

Thanks!

Last edited by _ForgeUser7745776: Dec 3, 2014

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

View User Profile

Send Message

Posted Jul 13, 2014
@Locercus

Location as in? what block they are currently standing on?

That'll mean updating the DB every time they move just one block, could get extremely laggy with all those SQL updates happening especially if the server is a busy one.

Or do you only care about the location they were last at when they logged off?

Last edited by RayHerring: Jul 13, 2014

Rollback Post to Revision RollBack
_ForgeUser6862612
- Join Date: 5/21/2011
- Posts: 2
- Member Details
#243 _ForgeUser6862612

View User Profile

Send Message

Posted Jul 9, 2014
Could you possibly add a column for player location? I need this for my server! :)

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

View User Profile

Send Message

Posted Jun 14, 2014
Still compiled against 1.7.2, I'm going to ignore 1.7.9 and wait for 1.7.10 version of bukkit.

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

View User Profile

Send Message

Posted Jun 14, 2014
New version posted, just waiting on approval.

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

View User Profile

Send Message

Posted Jun 14, 2014
Will look at this tomorrow. It's interesting because it should be using the new sql stuff which auto quotes.

Rollback Post to Revision RollBack
_ForgeUser15799327
- Join Date: 6/7/2014
- Posts: 2
- Member Details
#239 _ForgeUser15799327

View User Profile

Send Message

Posted Jun 6, 2014
Using McMyAdmin apparently the names of permission groups aren't exported. Because of this, I'm getting errors when OnlinePlayerSQL wants to perform the following query:

UPDATE online_players SET permission_group = ** NOT SPECIFIED ** WHERE player = 'playername'

I suggest you either quote the value for permission_group or skip this query when no permission group was found.

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

View User Profile

Send Message

Posted Apr 9, 2014
@KrustyLv

I don't currently store the nickname, i store the actual playername.

When Mojang brings out the ability to change your minecraft name, i'll probably add a second table or something so that you can keep track of all the names that UUID has had, not sure yet.

Either way, i will definitely have it set up so that the current name they have is stored along with their UUID.

Rollback Post to Revision RollBack
_ForgeUser11941889
- Join Date: 7/29/2013
- Posts: 249
- Member Details
#237 _ForgeUser11941889

View User Profile

Send Message

Posted Apr 9, 2014
@ray73864

But in database still will be stored player nickname, right?

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

View User Profile

Send Message

Posted Apr 6, 2014
When 1.7.6 comes out, all the stats will be broken due to Mojang switching from storing things by player name to storing them by UUID, i'm hoping the Bukkit team implements a way to convert from the old to the new so that all i have to do is a simple SQL code change to fix it.

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

View User Profile

Send Message

Posted Apr 5, 2014
@Jacold

Please check using the latest version. Hopefully i have fixed this issue once and for all.

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

View User Profile

Send Message

Posted Apr 5, 2014
Long time coming, but here it is, a fix for all the SQL issues people have been reporting.

http://dev.bukkit.org/media/files/783/14/OnlinePlayersSQL.v1.9.4.jar

I've switched from the old style SQL syntax to using PreparedStatements, that way the SQL driver itself handles the escaping of strings, etc...

I have tested this on my local dev set up and logging into the server successfully creates an entry in the table if one didn't exist before, world changing is recorded, player deaths is recorded, not sure about player kills as it is hard to kill another player when it is a server of 1.

If you want to watch as the server runs the PreparedStatements, simply turn logging on in the config.yml, restart your server and you will see things like:

com.mysql.jdbc.JDBC4PreparedStatement@62e14baa: UPDATE online_players SET previous_world='world_nether', current_world='world', permission_group='' WHERE player='ray73864'

Rollback Post to Revision RollBack

_ForgeUser9135155

Join Date: 7/4/2012
Posts: 152
Member Details

#233 Posted Apr 2, 2014

When I install it almost all what I need works fine except setting online status to 1 again. It throws errors:

[15:54:58 INFO]: Jacold[/***.***.***.***:*****] logged in with entity id **** at ([*****] -2617.7487208569733, 64.0, 1084.347873600041)
[15:54:58 WARN]: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Jacold'' at line 1
[15:54:58 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[15:54:58 WARN]:        at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
[15:54:58 WARN]:        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
[15:54:58 WARN]:        at java.lang.reflect.Constructor.newInstance(Unknown Source)
[15:54:58 WARN]:        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
[15:54:58 WARN]:        at com.mysql.jdbc.Util.getInstance(Util.java:382)
[15:54:58 WARN]:        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
[15:54:58 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
[15:54:58 WARN]:        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
[15:54:58 WARN]:        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
[15:54:58 WARN]:        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
[15:54:58 WARN]:        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
[15:54:58 WARN]:        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
[15:54:58 WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407)
[15:54:58 WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325)
[15:54:58 WARN]:        at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310)
[15:54:58 WARN]:        at net.rayherring.OnlinePlayersSQLLib.runUpdateQuery(OnlinePlayersSQLLib.java:76)
[15:54:58 WARN]:        at net.rayherring.OnlinePlayersSQL.updatePlayerRecord(OnlinePlayersSQL.java:100)
[15:54:58 WARN]:        at net.rayherring.MyOnlPlayerListener.onPlayerJoin(MyOnlPlayerListener.java:90)
[15:54:58 WARN]:        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[15:54:58 WARN]:        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
[15:54:58 WARN]:        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
[15:54:58 WARN]:        at java.lang.reflect.Method.invoke(Unknown Source)
[15:54:58 WARN]:        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:318)
[15:54:58 WARN]:        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
[15:54:58 WARN]:        at org.bukkit.plugin.TimedRegisteredListener.callEvent(TimedRegisteredListener.java:30)
[15:54:58 WARN]:        at org.bukkit.plugin.SimplePluginManager.fireEvent(SimplePluginManager.java:487)
[15:54:58 WARN]:        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:472)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.PlayerList.c(PlayerList.java:245)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.PlayerList.a(PlayerList.java:135)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.LoginListener.c(LoginListener.java:87)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.LoginListener.a(LoginListener.java:42)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.NetworkManager.a(NetworkManager.java:150)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.ServerConnection.c(ServerConnection.java:77)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.MinecraftServer.u(MinecraftServer.java:700)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.DedicatedServer.u(DedicatedServer.java:273)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.MinecraftServer.t(MinecraftServer.java:562)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.MinecraftServer.run(MinecraftServer.java:469)
[15:54:58 WARN]:        at net.minecraft.server.v1_7_R1.ThreadServerApplication.run(SourceFile:617)

_ForgeUser9135155
- Join Date: 7/4/2012
- Posts: 152
- Member Details
#232 _ForgeUser9135155

View User Profile

Send Message

Posted Apr 1, 2014
It's update when player joins/disconnects? Can you add server status (plugin sql'd online when server starts and offline when crashes or typing /stop)?
I think I'll install it tomorrow.

Rollback Post to Revision RollBack
_ForgeUser11941889
- Join Date: 7/29/2013
- Posts: 249
- Member Details
#231 _ForgeUser11941889

View User Profile

Send Message

Posted Mar 31, 2014
Can you once fix it?

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

View User Profile

Send Message

Posted Mar 20, 2014
@GlabbichRulz

Yeah, i made some minor changes here and there for the 1.7 version, it's possible it creeped in somehow.

Anyway, once work calms down a bit, i'll release the current version i have, which i am hoping fixes the issue once and for all.

Rollback Post to Revision RollBack
Forge_User_52354827
- Join Date: 12/14/2011
- Posts: 165
- Member Details
#229 Forge_User_52354827

View User Profile

Send Message

Posted Mar 20, 2014
@ray73864

the server is running on a nitrado.net linux server.

I am not sure if its a conflict with other/newer Plugins on my server, but i am sure your great plugin worked in earlyer versions.

Last edited by Forge_User_52354827: Mar 20, 2014

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

View User Profile

Send Message

Posted Mar 16, 2014
@GlabbichRulz

Sorry about not releasing it, have been busy with work.

Is this on a windows computer or a linux box?

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