SQL-Whitelisting 1.0

A plugin to enable SQL based whitelist creation and management.

  1. LesGensMentales
    SQL Whitelist

    SQL Whitelisting is a simple plugin meant to target communities that use a multi-server configuration. I myself own one and have found it to be an un-needed waste of time to modify each servers whitelist each time a new player/staff member needs to be allowed on. So I took a bit of time and created this. SQL Whitelisting allows you to sync and modify a whitelist using any number of servers simultaneously. Completely from in game you can add and remove players from the whitelist, check if a player is on the whitelist, generate a list of all players added to the whitelist and enable or disable whitelisting.

    Upload SQLWhitelist.jar to your plugins directory.
    2. Upload ‘lib’ folder to your plugins directory
    3. Start your server
    4. Navigate to the plugins/SQLWhitelist directory
    5. Open config.yml
    6. Fill in your MySQL server login information
    7. Set ‘Enabled’ to ‘true’ in the configuration file
    8. Start your server
    9. Connect

    After following the above instructions you will only be able to connect if you have your username listed as an OP. Once you are logged in add yourself to the whitelist by typing
    /whitelist add {YOUR_USERNAME}
    Then feel free to proceed as you like in your normal activities!

    /whitelist add {NAME}
    - Adds a user to the whitelist
    /whitelist remove {NAME} - Removes a user from the whitelist
    /whitelist check {NAME} - Checks if a specific name is on the whitelist
    /whitelist listall - Generates a list of all whitelisted users and uploads it into a copy-able list on PasteBin
    /whitelist enable - Enables the whitelist
    /whitelist disable - Disables the whitelist

    Should you have any questions concerning the use or development of this plugin please feel free to contact me through my email [email protected]

    - A MySQL server & database
    - A Minecraft Server
    - Java 1.6 SE+

Recent Reviews

  1. WackyIPC
    Version: 1.0
    Its working but after some time it sends to console this:
    [06:10:58 INFO]: [SQLWhitelist] Wacky is on the whitelist!
    > whitelist check Wacky
    [06:15:00 ERROR]: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

    The last packet successfully received from the server was 241 931 milliseconds ago. The last packet sent successfully to the server was 83 milliseconds ago.
    > whitelist check Wacky
    [06:15:11 ERROR]: org.apache.commons.dbcp.SQLNestedException: Borrow prepareStatement from pool failed
  2. nicolashc96
    Version: 1.0
    Cuando alguien se conecta, se crea un registro en la tabla con el valor “false”, y he creado yo un registro con Dreamweaver, pero el problema es que no reemplaza al que está en false, si no que crea uno en true. Ahora hay dos registros, uno con true y otro con false, al existir el de false, el jugador no puede entrar. Mi pregunta es, ¿Cómo se puede hacer para que el registro true reemplace al registro false? Así el jugador podrá entrar en el servidor.
  3. Diddley4209
    Version: 1.0
    Does not work, I followed the Readme instructions and double checked several times. I have uninstalled and reinstalled, but still does not work. Well technically the plugin is installed, but none of the commands do squat. For example, /whitelist replies to you/the console with nothing, as if you never sent the command. The point being, find another plugin, this one doesn't work. However, if the dev actually bothers to fix this plugin, so it actually works, or for some reason put incorrect stuff in it, I would be greatly pleased and rate this 3-5 stars.
  4. Hexel
    Version: 1.0
    Yeah, is the only one that actually work :D
    Could be nice color the kick message ;)
    Thank you for this plugin :)
  5. Sniper
    Version: 1.0
  6. The_Doctors_Life
    Version: 1.0
    Great plugin, makes whitelisting so much easier.