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!

  • 9 comments
  • 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
  • Avatar of FrozenYuri FrozenYuri Aug 22, 2013 at 20:41 UTC - 0 likes

    perhaps a prefix: online_ would be nice ;) for multiple servers on one mysql database

    BFAK:51939,1aa5da6ba8d7c7cdb5942e5ee6c9c4116ef68465daa3be5ca8f3568723b3a247

  • Avatar of bartsmienk bartsmienk Jul 25, 2013 at 17:10 UTC - 0 likes

    @TanveerGT5: Go

    Sorry it took so long I kinda rushed it, i hope it works - Pastebin

  • Avatar of TanveerGT5 TanveerGT5 Jul 18, 2013 at 21:12 UTC - 0 likes

    @bartsmienk: Go

    alright im looking forward to it

  • Avatar of bartsmienk bartsmienk Jul 18, 2013 at 06:19 UTC - 1 like

    @TanveerGT5: Go

    Yeah, thats possible. Maybe if i have some free time on my hands i'll write an example code for it.

  • Avatar of TanveerGT5 TanveerGT5 Jul 17, 2013 at 22:48 UTC - 0 likes

    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 ?

  • 9 comments

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
259
Recent file

Authors