PlayerSQL
PlayerSQL
PlayerSQL makes it easy to manage online players by placing them in a SQL database. Your developers are gonna love it!
Features
- Low amount of resources needed
- Easy to configure
- Places all online players in a SQL database
Configuration
debug: false connection: 'connection': jdbc:mysql://localhost:3306/database 'username': smiba 'password': password
debug If this is set to true PlayerSQL will write the queries that are being executed to the console
connection replace localhost & database with your own server and database
username replace this with your own mysql username
password replace this with your own mysql password
Support
If you have any questions please submit a ticket or place your question in the comments.
Source Code
https://github.com/smiba/PlayerSQL
To-Do
- A list of players that should not being placed in the database (Invisible)
- A command to add players to the 'invisible list'
- Multiserver support (Maybe something like a second colum which contains the server port?)
Comments
-
_ForgeUser7542272 Owner
-
View User Profile
-
Send Message
Posted Aug 3, 2014you could make a variable bukkit staff to mysql let say you set 30 variables $var1 = res '/res list' $var2 = money '/money' and you insert the $var1... on the res table and $var 2 on money table and add the returned value of the command used like res list return a list of residences of player so it set on res table for each player....
-
View User Profile
-
Send Message
Posted Jun 20, 2014@charries96
Incorrect.
-
View User Profile
-
Send Message
Posted Jun 12, 2014@charries96
You can have max health though. I think that represents having multiple rows of hearts.
-
View User Profile
-
Send Message
Posted Jun 10, 2014@mrdeadlock
I believe that Bukkit itself doesn't support the health being higher than 20, if that's right then not possible :P
-
View User Profile
-
Send Message
Posted May 31, 2014Can you update this so that you can allow for health higher than 20?
-
View User Profile
-
Send Message
Posted May 28, 2014Would be cool to see multiple servers stuff :)
-
View User Profile
-
Send Message
Posted Nov 17, 2013@bartsmienk
Would it be at all possible for you to set it up for me? As I have very limited knowledge of Java, if I were to give you the names could you set it up so that if they were offline their names would be red, and if they were online the names would be green?
-
View User Profile
-
Send Message
Posted Nov 15, 2013@ghostyboy5
This is deffently possible, you could get the players and do simple questions like if (in_array("ghostyboy5",$mysqlResult,TRUE) { echo "Online"; }
-
View User Profile
-
Send Message
Posted Nov 12, 2013I was wondering if there was a way to make it show only specific players? For example. on my website I have it list my Staff members on a sidebar, would it be possible to show which of those Staff members are offline, and which are online?
-
View User Profile
-
Send Message
Posted Sep 12, 2013@FrozenYuri
Multiply servers on 1 database should be no problem as long there are no cracked players (= Dubble names) and if 1 server reboots the database is emptied so that should not happen either
Added to the To-Do List.
I keep on updating this plugin but its slower then i usual would since i'm currently working on something WAY bigger.
-
View User Profile
-
Send Message
Posted Aug 22, 2013perhaps a prefix: online_ would be nice ;) for multiple servers on one mysql database
-
View User Profile
-
Send Message
Posted Jul 25, 2013@TanveerGT5
Sorry it took so long I kinda rushed it, i hope it works - Pastebin
-
View User Profile
-
Send Message
Posted Jul 18, 2013@bartsmienk
alright im looking forward to it
-
View User Profile
-
Send Message
Posted Jul 17, 2013@TanveerGT5
Yeah, thats possible. Maybe if i have some free time on my hands i'll write an example code for it.
-
View User Profile
-
Send Message
Posted Jul 17, 2013ok so I was thinking, what if the players are stored into a MySQL DB then you can pull that info and display it on your site using PHP? like a web player list ?