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 must login to post a comment. Don't have an account? Register to get one!

  • Avatar of raton023 raton023 Aug 03, 2014 at 17:48 UTC - 0 likes

    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....

    I just hope that we never loose sigh of one thing, that it all started with a mouse.

  • Avatar of LordKainzo LordKainzo Jun 20, 2014 at 07:58 UTC - 0 likes

    @charries96: Go

    Incorrect.

  • Avatar of Ferocious_Ben Ferocious_Ben Jun 12, 2014 at 11:57 UTC - 0 likes

    @charries96: Go

    You can have max health though. I think that represents having multiple rows of hearts.

  • Avatar of charries96 charries96 Jun 10, 2014 at 16:04 UTC - 0 likes

    @mrdeadlock: Go

    I believe that Bukkit itself doesn't support the health being higher than 20, if that's right then not possible :P

    If you want me to reply then tag me in your post, otherwise the chances are I won't see it.

    BFAK:90941193,5c2634f80c346661414bbdfafbcf28973cda2fe48533f77b864fdb84fa9a5e59

  • Avatar of mrdeadlock mrdeadlock May 31, 2014 at 16:12 UTC - 0 likes

    Can you update this so that you can allow for health higher than 20?

  • Avatar of LordKainzo LordKainzo May 28, 2014 at 17:30 UTC - 0 likes

    Would be cool to see multiple servers stuff :)

  • Avatar of ghostyboy5 ghostyboy5 Nov 17, 2013 at 16:15 UTC - 0 likes

    @bartsmienk: Go

    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?

    Flintlock Gaming

  • Avatar of bartsmienk bartsmienk Nov 15, 2013 at 14:38 UTC - 0 likes

    @ghostyboy5: Go

    This is deffently possible, you could get the players and do simple questions like if (in_array("ghostyboy5",$mysqlResult,TRUE) { echo "Online"; }

  • Avatar of ghostyboy5 ghostyboy5 Nov 12, 2013 at 22:45 UTC - 0 likes

    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?

  • Avatar of bartsmienk bartsmienk Sep 12, 2013 at 18:49 UTC - 0 likes

    @FrozenYuri: Go

    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.

    Last edited Sep 12, 2013 by bartsmienk

Facts

Date created
Jul 16, 2013
Categories
Last update
Jul 16, 2013
Development stage
Beta
Language
  • enUS
License
CC BY-NC-SA 3.0
Curse link
PlayerSQL
Downloads
425
Recent file

Authors