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?)
you 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....
@charries96
Incorrect.
@charries96
You can have max health though. I think that represents having multiple rows of hearts.
@mrdeadlock
I believe that Bukkit itself doesn't support the health being higher than 20, if that's right then not possible :P
Can you update this so that you can allow for health higher than 20?
Would be cool to see multiple servers stuff :)
@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?
@ghostyboy5
This is deffently possible, you could get the players and do simple questions like if (in_array("ghostyboy5",$mysqlResult,TRUE) { echo "Online"; }
I 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?
@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.
perhaps a prefix: online_ would be nice ;) for multiple servers on one mysql database
@TanveerGT5
Sorry it took so long I kinda rushed it, i hope it works - Pastebin
@bartsmienk
alright im looking forward to it
@TanveerGT5
Yeah, thats possible. Maybe if i have some free time on my hands i'll write an example code for it.
ok 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 ?