Dynamic Effect Whitelist

Table of Contents

Dynamic Effect Whitelist

This is a simple whitelist mod using MySQL/HTTP/File. To add users ingame to the whitelist permissionsBukkit is required (included in bukkit), you also need to use the File or MySQL mode. The plugin can run without any changes to the config, if you want it simple or you can edit the config to personalize the disconnect message etc.

The whitelist uses PluginMetrics which means it will send server info (plugin version, number of players on the server, server version, server location (country)), to PluginMetrics server (http://mcstats.org/plugin/DynamicEffectWhitelist) so I can get plugin usage. It can be turned off in PluginMetrics config (plugins/PluginMetrics/config.yml), but it's recommended to let it be on, so I can see the usage.

If a new minecraft version has recently been released then try the plugin instead of asking if it works. Before reporting a bug, check so you have the latest version and check the changelog

Features

Whitelist using MySQL/HTTP/File
Updates the whitelist at an interval and not just at server start
Add users to the whitelist ingame or integrate with your forum/website
The file data source uses the same format as Minecraft´s built-in whitelist system.
Custom disconnect message (if not on whitelist)
Notification for OP' s and players with the right permission, when someone joins and is not on the whitelist (Needs to be enabled in the config (General.PrintConnectFails))
Support for custom SQL queries & custom database structure
Built-in importer/exporter allows importing/exporting from/to file, sql & url to file, world & sql. (1)
Reload plugin on the run (without restarting the server)
Refresh the whitelist on the run (without waiting for the automated refresh or restarting the server)
Whitelist can be turned on/off while the server is running

(Allowed sources: sql, file, url, world Allowed destinations: sql, file)

Todo

Nothing

Dependencies

MySQL JDBC (If you are going to use sql as data source) - Download the mysql connector and place mysql-connector-java-5.1.15-bin.jar in C:\Program Files\Java\jre6\lib\ext or /java/packages/lib/ext on linux (http://docs.oracle.com/javase/tutorial/ext/basics/install.html)

Permissions

Permission	Description
dewhitelist.add	permission to add users to the whitelist
dewhitelist.remove	permission to remove users from the whitelist
dewhitelist.displayfails	permission to see all failed joins (shown in the chat if activated in config)
dewhitelist.reload	permission to reload the plugin
dewhitelist.refresh	permission to refresh the whitelist (check for new players in the whitelist)
dewhitelist.import	permission to import from a source to another (Can be used to backup the whitelist)
dewhitelist.mode	permission to turn on/off the whitelist

Chat commands

Command	Description
/whitelist add [player]	adds the entered player to the whitelist.
/whitelist remove [player]	removes the entered player to the whitelist.
/whitelist reload	Reloads the plugin
/whitelist import [source] [destination]	imports whitelist from source to destination (1) (2)
/whitelist refresh	Refreshes the whitelist (checks for new players in the whitelist)
/whitelist <on/off>	Turns on/off the whitelist

(Allowed sources: sql, file, url, world Allowed destinations: sql, file)
(Uses a third argument when using world as source, the last world is the name of the world's name. Example "/whitelist import world file world")

Source

The source is hosted on Github: https://github.com/BlackVoid/DynamicEffectWhitelist

Download

JAR Only (Version 1.5.2)
Full package (Version 1.5.2) - Includes JAR, SQL-file (database), php-file (if you use url as data source)

Changelog

Version 1.5.2

All debug messages are now shown with the prefix [DEWhitelist-debug]
No longer prints entire whitelist in debug mode, instead it prints the number of players in the whitelist.
Checks if other plugin has already disallowed the player and if so it lets the other plugin handle the event.
In debug mode it now prints if another plugin has handled the join event.

Version 1.5.1

Quick fix for the refresh timer which didn't work.

Version 1.5.0

/whitelist <on/off> added - Can turn on/off the whitelist on the run
Print connection fails should be fixed and should no longer print in console nor to players multiple times.
debug option moved from General.debug to Other.debug
Option in the config to set which mode the whitelist should be at startup (on or off)
PluginMetrics added, sends anonymous stats (player count, bukkit version, plugin version), can be turned off in the pluginMetrics config (plugins/PluginMetrics/config.yml)

If you use my plugin on your server(s) please consider donating :)

Comments

_ForgeUser6850404
- Join Date: 5/20/2011
- Posts: 29
- Member Details
#178 _ForgeUser6850404

View User Profile

Send Message

Posted Dec 8, 2013
GrimList is a project built from Dynamic Effect Whitelist.

It has more customization available, is updated frequently, and compatible with 1.7.2.

http://dev.bukkit.org/bukkit-plugins/grimlist/

@Iwitrag @BlazeMF @Nussi1986 @BlackVoidRules

Last edited by _ForgeUser6850404: Apr 29, 2014

Rollback Post to Revision RollBack
_ForgeUser8284873
- Join Date: 1/19/2012
- Posts: 299
- Member Details
#177 _ForgeUser8284873

View User Profile

Send Message

Posted Oct 16, 2013
Can somebody take this plugin and keep it updating? It's simply awesome !

Rollback Post to Revision RollBack
_ForgeUser9428516
- Join Date: 8/18/2012
- Posts: 100
- Member Details
#176 _ForgeUser9428516

View User Profile

Send Message

Posted Jul 5, 2013
@BlazeMF

What kind of Help do you need!

Rollback Post to Revision RollBack
_ForgeUser9606458
- Join Date: 9/11/2012
- Posts: 19
- Member Details
#175 _ForgeUser9606458

View User Profile

Send Message

Posted May 6, 2013
Can you PLIZ make a tutorial? Im realy not god on these things so can you help me? Greate plugin! Thx

Rollback Post to Revision RollBack
_ForgeUser7443197
- Join Date: 8/25/2011
- Posts: 66
- Member Details
#174 _ForgeUser7443197

View User Profile

Send Message

Posted Apr 19, 2013
I have now abandoned the project due to lack of time, the plugin is still working, but I won't be updating it. If anyone want's to continue the project contact me.

Rollback Post to Revision RollBack
_ForgeUser6850404
- Join Date: 5/20/2011
- Posts: 29
- Member Details
#173 _ForgeUser6850404

View User Profile

Send Message

Posted Apr 17, 2013
Same issue here:

+ Settings.getString("sql.table") + " WHERE name = ?");

should be

+ Settings.getString("sql.table") + "WHERE " + Settings.getString("sql.UserField") + " = ?");

Rollback Post to Revision RollBack
_ForgeUser6850404
- Join Date: 5/20/2011
- Posts: 29
- Member Details
#172 _ForgeUser6850404

View User Profile

Send Message

Posted Apr 17, 2013
Hey @BlackVoidRules!

Not sure if you're still with me, but I found the problem in the Java, that was producing the error!

+ Settings.getString("sql.table") + " (name) VALUES(?)");

Should be changed to:

+ Settings.getString("sql.table") + "(" + Settings.getString("sql.UserField") + ") VALUES(?)");

That's why the UserField portion was always ignored in the configuration, because it was automatically being supplanted with the default "name".

Rollback Post to Revision RollBack
_ForgeUser8960599
- Join Date: 5/30/2012
- Posts: 126
- Member Details
#171 _ForgeUser8960599

View User Profile

Send Message

Posted Mar 14, 2013
There is a way to make it disabled by default? When I restart my server the whitelist is on and I want it only during the night. How I can do it?
Thanks and great plugin!
If you want I can send you a modified version of "whitelist.php" where you can check and add players to the whitelist, very useful for forums. They just need to make a super simple form.
Let me know :)

Rollback Post to Revision RollBack
_ForgeUser6834149
- Join Date: 5/19/2011
- Posts: 34
- Member Details
#170 _ForgeUser6834149

View User Profile

Send Message

Posted Mar 10, 2013
Does the XenForo intregration still works until now ? Back in Nov 18, 2011 when you sent me the Guide :P It's been almost 2 years

Rollback Post to Revision RollBack
_ForgeUser7683261
- Join Date: 10/10/2011
- Posts: 22
- Member Details
#169 _ForgeUser7683261

View User Profile

Send Message

Posted Mar 8, 2013
I have installed everything needed for mysql. I players in the database. But only file works. Not url och sql. I can use file and use the /import command to get users from the database but I want to use sql instead of file. When I choose url or sql noone can join the server because they are not on the whitelist.

What do I do?

Rollback Post to Revision RollBack

_ForgeUser9739945

Join Date: 10/4/2012
Posts: 42
Member Details

#168 Posted Mar 2, 2013

Problems created when a non-whitelisted player tried to log in immediately after server restart or dewhitelist reload (was only doing that for testing purposes). Not sure what exactly is going on, but it's reproducible when server restarts or dewhitelist is reloaded. Something up with the db connection? The result is that the server hangs, chunks don't load, and a restart is the only thing that will fix it. No crash report is generated, but our server will restart itself when it loses a heartbeat. This been reproduced three times under testing on the live server on purpose this morning, but has plagued us for a bit longer than that, any ideas?:

http://pastie.org/6365252

2013-03-02 11:37:45 [INFO]  issued server command: /whitelist reload
2013-03-02 11:37:45 [INFO] [DEWhitelist] Whitelist is on
2013-03-02 11:37:45 [INFO] [DEWhitelist] Whitelist retrived successfully!
2013-03-02 11:37:45 [INFO] [DEWhitelist]  reloaded the plugin!
2013-03-02 11:37:56 [INFO] [DEWhitelist] M is not whitelisted! Deny!
2013-03-02 11:37:56 [INFO] Disconnecting : Hi M, you are not on the whitelist!
2013-03-02 11:37:59 [WARNING] [Server] The main thread failed to respond after 10 seconds
2013-03-02 11:37:59 [WARNING] [Server] What follows is the stack trace of the main thread
2013-03-02 11:37:59 [WARNING] [Server]    at java.lang.Thread.sleep(Native Method)
2013-03-02 11:37:59 [WARNING] [Server]    at net.minecraft.server.v1_4_6.MinecraftServer.run(MinecraftServer.java:431)
2013-03-02 11:37:59 [WARNING] [Server]    at net.minecraft.server.v1_4_6.ThreadServerApplication.run(SourceFile:849)
2013-03-02 11:38:08 [INFO] +[P] > bingo
2013-03-02 11:38:11 [WARNING] [Server] The main thread is still stuck, current loop line is:
2013-03-02 11:38:11 [WARNING] [Server]    at net.minecraft.server.v1_4_6.MinecraftServer.run(MinecraftServer.java:431)
2013-03-02 11:38:18 [INFO] +[P] > found it
2013-03-02 11:38:39 [INFO] +> chunks not loading again

CB version: git-Bukkit-1.4.6-R0.3-b2586jnks

DE version 1.5.2

Last edited by _ForgeUser9739945: Mar 2, 2013

_ForgeUser8125419
- Join Date: 12/22/2011
- Posts: 47
- Member Details
#167 _ForgeUser8125419

View User Profile

Send Message

Posted Mar 1, 2013
@BlackVoidRules, do you think you can add the possibility to say that only cracked players have to be on the Whitelist? I mean, that cracked users can't join with a Premisum user name, only with a name which is in the Whitelist??

Rollback Post to Revision RollBack
_ForgeUser10536406
- Join Date: 2/9/2013
- Posts: 2
- Member Details
#166 _ForgeUser10536406

View User Profile

Send Message

Posted Feb 10, 2013
@BlackVoidRules

Thank you, haven't tought about that one

Rollback Post to Revision RollBack
_ForgeUser7443197
- Join Date: 8/25/2011
- Posts: 66
- Member Details
#165 _ForgeUser7443197

View User Profile

Send Message

Posted Feb 10, 2013
@NeoMine

Try deleting the current config and reconfigure it wit the same values.

@NaStezZ

It's using | as seperator

Rollback Post to Revision RollBack
_ForgeUser10536406
- Join Date: 2/9/2013
- Posts: 2
- Member Details
#164 _ForgeUser10536406

View User Profile

Send Message

Posted Feb 9, 2013
How do you sepperate players if you for example use an url: http://localhost/whitelist.php. Only the first name in the list is allowed to join, the others not. I tried with enters and with a ;

NaStezZ

Rollback Post to Revision RollBack

_ForgeUser8272646

Join Date: 1/17/2012
Posts: 11
Member Details

#163 Posted Feb 6, 2013

@BlackVoidRules

 [DEWhitelist] Whitelist is on
2013-02-06 19:20:36 [SEVERE] Unable to retreive connection
java.sql.SQLException: Must specify port after ':' in connection string
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
>.restarat com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:190)
>.restarat com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:672)
>.restarat com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:296)
>.restarat java.sql.DriverManager.getConnection(DriverManager.java:620)
>.restarat java.sql.DriverManager.getConnection(DriverManager.java:222)
>.restarat com.dynamiceffect.whitelist.SQLConnection.getSQLConnection(SQLConnection.java:23)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.GetWhitelist(DynamicEffectWhitelist.java:297)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.access$0(DynamicEffectWhitelist.java:278)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist$UpdateWhitelist.run(DynamicEffectWhitelist.java:716)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:697)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.onEnable(DynamicEffectWhitelist.java:91)
>.restarat org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
>.restarat org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:427)
>.restarat org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugin(CraftServer.java:291)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.enablePlugins(CraftServer.java:273)
>.restarat net.minecraft.server.MinecraftServer.j(MinecraftServer.java:598)
>.restarat net.minecraft.server.MinecraftServer.e(MinecraftServer.java:564)
>.restarat net.minecraft.server.MinecraftServer.a(MinecraftServer.java:444)
>.restarat ho.c(DedicatedServer.java:195)
>.restarat net.minecraft.server.MinecraftServer.run(MinecraftServer.java:720)
>.restarat fy.run(ThreadMinecraftServer.java:16)
2013-02-06 19:20:36 [SEVERE] [DEWhitelist] Could not establish SQL connection.
2013-02-06 19:20:36 [SEVERE] Error occurred while enabling DynamicEffectWhitelist v1.5.2 (Is it up to date?)
java.lang.NullPointerException
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist$UpdateWhitelist.run(DynamicEffectWhitelist.java:717)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:697)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.onEnable(DynamicEffectWhitelist.java:91)
>.restarat org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
>.restarat org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:427)
>.restarat org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugin(CraftServer.java:291)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.enablePlugins(CraftServer.java:273)
>.restarat net.minecraft.server.MinecraftServer.j(MinecraftServer.java:598)
>.restarat net.minecraft.server.MinecraftServer.e(MinecraftServer.java:564)
>.restarat net.minecraft.server.MinecraftServer.a(MinecraftServer.java:444)
>.restarat ho.c(DedicatedServer.java:195)
>.restarat net.minecraft.server.MinecraftServer.run(MinecraftServer.java:720)
>.restarat fy.run(ThreadMinecraftServer.java:16)

and my configure is

General:
  WhitelistOn: true
  ConnectionType: sql
  UpdateInterval: 60
  PrintConnectFails: false
  DisconnectMessage: Hi §1{player}§f, you are not on the whitelist!
  DisallowMessage: Disallowed §2{player}§f from joining
sql:
  type: mysql
  host: neo6633.cafe24.com
  port: 3307
  username: root
  password: ******
  table: xe_member
  database: xe
  query: SELECT {name} FROM `{table}`;
  UserField: nick_name
Other:
  url: http://mywebsite.com/whitelist.php
  file: white-list.txt
  debug: false

Why Error?

_ForgeUser8272646

Join Date: 1/17/2012
Posts: 11
Member Details

#162 Posted Feb 6, 2013

 [DEWhitelist] Whitelist is on
2013-02-06 19:20:36 [SEVERE] Unable to retreive connection
java.sql.SQLException: Must specify port after ':' in connection string
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
>.restarat com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
>.restarat com.mysql.jdbc.NonRegisteringDriver.parseHostPortPair(NonRegisteringDriver.java:190)
>.restarat com.mysql.jdbc.NonRegisteringDriver.parseURL(NonRegisteringDriver.java:672)
>.restarat com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:296)
>.restarat java.sql.DriverManager.getConnection(DriverManager.java:620)
>.restarat java.sql.DriverManager.getConnection(DriverManager.java:222)
>.restarat com.dynamiceffect.whitelist.SQLConnection.getSQLConnection(SQLConnection.java:23)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.GetWhitelist(DynamicEffectWhitelist.java:297)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.access$0(DynamicEffectWhitelist.java:278)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist$UpdateWhitelist.run(DynamicEffectWhitelist.java:716)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:697)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.onEnable(DynamicEffectWhitelist.java:91)
>.restarat org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
>.restarat org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:427)
>.restarat org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugin(CraftServer.java:291)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.enablePlugins(CraftServer.java:273)
>.restarat net.minecraft.server.MinecraftServer.j(MinecraftServer.java:598)
>.restarat net.minecraft.server.MinecraftServer.e(MinecraftServer.java:564)
>.restarat net.minecraft.server.MinecraftServer.a(MinecraftServer.java:444)
>.restarat ho.c(DedicatedServer.java:195)
>.restarat net.minecraft.server.MinecraftServer.run(MinecraftServer.java:720)
>.restarat fy.run(ThreadMinecraftServer.java:16)
2013-02-06 19:20:36 [SEVERE] [DEWhitelist] Could not establish SQL connection.
2013-02-06 19:20:36 [SEVERE] Error occurred while enabling DynamicEffectWhitelist v1.5.2 (Is it up to date?)
java.lang.NullPointerException
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist$UpdateWhitelist.run(DynamicEffectWhitelist.java:717)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:697)
>.restarat com.dynamiceffect.whitelist.DynamicEffectWhitelist.onEnable(DynamicEffectWhitelist.java:91)
>.restarat org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:217)
>.restarat org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:427)
>.restarat org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.loadPlugin(CraftServer.java:291)
>.restarat org.bukkit.craftbukkit.v1_4_R1.CraftServer.enablePlugins(CraftServer.java:273)
>.restarat net.minecraft.server.MinecraftServer.j(MinecraftServer.java:598)
>.restarat net.minecraft.server.MinecraftServer.e(MinecraftServer.java:564)
>.restarat net.minecraft.server.MinecraftServer.a(MinecraftServer.java:444)
>.restarat ho.c(DedicatedServer.java:195)
>.restarat net.minecraft.server.MinecraftServer.run(MinecraftServer.java:720)
>.restarat fy.run(ThreadMinecraftServer.java:16)

and my configure is

General:
  WhitelistOn: true
  ConnectionType: sql
  UpdateInterval: 60
  PrintConnectFails: false
  DisconnectMessage: Hi §1{player}§f, you are not on the whitelist!
  DisallowMessage: Disallowed §2{player}§f from joining
sql:
  type: mysql
  host: neo6633.cafe24.com
  port: 3307
  username: root
  password: ******
  table: xe_member
  database: xe
  query: SELECT {name} FROM `{table}`;
  UserField: nick_name
Other:
  url: http://mywebsite.com/whitelist.php
  file: white-list.txt
  debug: false

Why Error?

_ForgeUser7443197
- Join Date: 8/25/2011
- Posts: 66
- Member Details
#161 _ForgeUser7443197

View User Profile

Send Message

Posted Jan 30, 2013
@doglover129

The php script is included in the full zip. If you don't like the one provided you have to create your own.

Rollback Post to Revision RollBack
_ForgeUser9160759
- Join Date: 7/9/2012
- Posts: 17
- Member Details
#160 _ForgeUser9160759

View User Profile

Send Message

Posted Jan 26, 2013
Well I fixed my last error, but can someone send me the proper PhP script? (so that I would just have to set the MySQL settings and go) I am not very good with PhP and I cannot seem to figure out how to wright the website interface.

Rollback Post to Revision RollBack
_ForgeUser9160759
- Join Date: 7/9/2012
- Posts: 17
- Member Details
#159 _ForgeUser9160759

View User Profile

Send Message

Posted Jan 26, 2013
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\index.php on line 15

Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\index.php on line 17

Am I missing something in the php file? And yes, I did intend to switch it to index.php for testing.

Last edited by _ForgeUser9160759: Jan 26, 2013

Rollback Post to Revision RollBack
To post a comment, please login or register a new account.

Project ID

33182
Created

Oct 21, 2011
Last Released File

May 14, 2013
Total Downloads

15,672
License

CC BY-NC-SA 3.0

Bukkit

Dynamic Effect Whitelist

Bukkit Plugins