MySQL - Whitelist 1.3

MySQL - Whitelist is a simple plugin that allows you to use a mysql database as whitelist

  1. steffansk1997
    MySQL Whitelist
    This plugin allows you to have your whitelist in a mysql database
    And it works with the new UUID's so it won't break once the players can chance their names


    Commands & permissions
    • /mywl add {player} - Add a player to the whitelist - MySQLWhitelist.add
    • /mywl del {player} - Remove a player from the whitelist - MySQLWhitelist.del
    • /mywl on - Turns the MySQL whitelist on - MySQLWhitelist.on
    • /mywl off - Turns the MySQL whitelist off - MySQLWhitelist.off

    Config

    Code (Text):

    #Mysql Settings
    host: localhost
    user: root
    password: example
    database: minecraft
    port: 3306

    #status of the whitelist
    enabled: true
     
    frea, _Le0_ and Dominik2912 like this.

Recent Updates

  1. Bug fixes, yay Jan 23, 2016

Recent Reviews

  1. lightningmoon97
    lightningmoon97
    5/5,
    Version: 1.3
    Some people here are saying this does not work, or are down voting for simple stuff that is not the plugins fault...

    First time using this plugin and got it to link first try, amazing and simple, while it might be super basic, it gets the job done. I use this for having a hub that has no whitelist, but then other servers in the network need their own whitelist, but linked together.
    Keep it up!

    PS: Used on 1.16.5
    Feb 8, 2021
  2. DrikaGamer
    DrikaGamer
    3/5,
    Version: 1.3
    If player account is not original, it doesn't work like default whitelist system. I would like to let non originals play in my server too! :(
    Jul 16, 2018
  3. reysal
    reysal
    3/5,
    Version: 1.3
    how do i set table on mysql? please help me.
    how do i set it up? can u message me ?
    Apr 18, 2018
  4. josetto10
    josetto10
    5/5,
    Version: 1.3
    Esto es impresionante!!! muy buen plugin, una a lista global de mi servidor, ip: play.latinwar.net
    AWESOME
    Nov 3, 2016
  5. Sorgrum
    Sorgrum
    5/5,
    Version: 1.3
    Working really well, thanks. Although I'd appreciate if you'd be able to customize the structure of the database.
    Apr 10, 2016
  6. monsune
    monsune
    1/5,
    Version: 1.3
    I appreciate your prompt response and several improvements. I'm also really sorry again but you broke it one more time. Your code puts nothing into UUID column and it puts the UUID in the user column actually so there is never a match on auth. Also, the table isn't properly defined and missing some basic stuff. I spent alot of time breaking my head why it wouldn't work again, while you should at least do a basic test before puting the update online. It's obvious that you didn't, which means that you simply don't care much about people. That's why i give 1 star again.
    Jan 23, 2016
    1. steffansk1997
      Author's Response
      Wrong, the plugin puts nothing in the UUID column when the defined player is offline
      As soon as the player joins the server for the first time the UUID field gets filled and from that point the uuid will be used for auth
  7. monsune
    monsune
    1/5,
    Version: 1.2
    I'm sorry but this doesn't work anymore. With whitelist on and particular UUIDs added, people still can't connect. I suspect that the default table name is not acceptable by some MySQL builds as i can't even select anything from MySQL-Whitelist as it throws an error instantly. Why the "-" instead of "_" or just simpler, safe name or even allow user to define the table name himself just like database name? It is causing lots of frustration now, time wasted and i need to find another plugin which isn't easy :/
    Jan 22, 2016
    1. steffansk1997
      Author's Response
      I fixed the stuff you were having issues with
  8. jerimu
    jerimu
    4/5,
    Version: 1.2
    Does what it says 4/5
    Maybe a way to set a Prefix so you can seperate it from servers.
    So you have Survival_ for your survival servers and creative_ for your Creative servers. So prefix: example and it saves as example_tablename.
    Apr 3, 2015