Inactive [GEN/ADMN] Dynamic Effect Whitelist V1.3.0 - Using MySQL [2116+]

Dynamic Effect Whitelist - Using MySQL:
Version: v1.3.0

Plugin has moved to dev.bukkit.org

 

Thats not the plugin zip.
You should download the file which is under minecraft not PHP.
http://blackvoid.eu/downloads/minecraft/dynamiceffectwhitelist-0_9-plugin.zip

 

And where do I put that whitelist.php file?

http://blackvoid.eu/downloads/minecraft/dynamiceffectwhitelist-web-1_0.zip
I downloaded this and put under my web host.
Now changed files inside on config.php
Also under phpmyadmin run whitelist.sql and made table. What Do I Do with whitelist.php ??

Downloaded mysql-connector-java-bin.jar and moved to Java .. ext folder. Like usual.

Now I change files inside of config.properties.

and this what I get.

http://pastie.org/3148946

 

Are you going to get the whitelist by connecting to the database or by connecting to whitelist.php

 

I want connect whitelist with mysql (database)

 

Then you just need to set the details to the database.
These details:

• mysql-user - MySQL user
• mysql-password - MySQL user password
• mysql-table - The whitelist table
• mysql-database - jdbc\:mysql\://<host>\:<port default: 3306>/<database>

 

In config.php or in config.properties ?

 

config.properties
You dont even need the php files if you should use a direct connection to mysql.

 

What about webpage where user can enter username and captcha?

 

Then you need the php script, but you also need to know how to edit a php file. If you dont know how to do that i suggest you start reading about php. http://www.w3schools.com/php/php_variables.asp

 

Hey,

Love this plugin, but i only want the Custom Whitelist Message.
Can you make one?

Found PreKick, but it isn't working due outdated source.

Thanks!

 

So you want it to store the whitelist in a text file?

 

Well what i want is that the plugin only has the Custom Whitelist Message, so when someone joins on my server and is not whitelisted it says: Please visit [linkofwebsite] or whatever you fill in.

So it will read your white-list.txt

[Read your white-list in your Root folder, and a config file to fill in the information etc]

Hope you can help me and many others by creating this plugin

 

Hi, i have a problem with your plugin.

Code:

[SEVERE] Unable to retreive connection
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2239)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2168)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
    at sun.reflect.GeneratedConstructorAccessor22.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.dynamiceffect.whitelist.SQLConnection.getSQLConnection(SQLConnection.java:12)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist$UpdateWhitelist.run(DynamicEffectWhitelist.java:290)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:273)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist$1.run(DynamicEffectWhitelist.java:84)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection,  message from server: "Too many connections"
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
    at com.mysql.jdbc.Util.getInstance(Util.java:382)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1013)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1116)
    at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338)
    at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2186)
    ... 17 more
[SEVERE] [DEWhitelist] Could not establish SQL connection. Disabling DEWhitelist

I know it's problem of my MYSQL server but, how I can do to make plugin be reloaded automatically?

Here is my config.

Code:

mysql-updateinterval=5
name=x
debug=false
usemysql=true
mysql-database=jdbc\:mysql\://x.x.x\:3306/x
http-url=http\://mydomain.com/whitelist.php
mysql-user=x
mysql-string=SELECT {name} FROM `{table}` WHERE activada\=1;
dismsg=x
mysql-table=x
whitelist-url=none
mysql-password=x

Thank you and sorry for my bad english.

 

You cant reload it automaticly. You need to restart the server to reload it.

 

Mmm... I see. Thanks anyway.

I will try to put the MySQL server in local, that maybe work.

Greetings.

 

Is it a problem that's occurring after a while or do you just have a problem with the mysql details?

 

Occurrs after a while of time.

 

ok, Ill make it so the plugin does'nt disable itself if it gets a error.

Version 1.0 alpha is finished.
Im not 100% sure url and sql works cause I cant try it atm.
The file is currently waiting for approval and you should be able to download it with this link. http://dev.bukkit.org/server-mods/dynamic-effect-whitelist/files/3-version-1-0/
If you need any help heres some pages that might help you.
Addons, Config, Permissions & Commands

If php and/or sql works for you then say so in the thread so i know its working.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

What i was suggesting is a stand alone plugin to change the "Your are not whitelisted on this server" to something Custom.
Can you please make that?
If it is possible just .txt

 

It is now using the white-list.txt by default. The only thing you need to set is the permission to add/remove people to/from the whitelist and set the custom message, then it will work exactly like the whitelist commands included.

 

Thank you for the new version.

I will put in my server and tell you if works fine.

Edit:

Code:

[SEVERE] Could not load 'plugins\DynamicEffectWhitelist.jar' in folder 'plugins':
java.lang.UnsupportedClassVersionError: com/dynamiceffect/whitelist/DynamicEffectWhitelist : Unsupported major.minor version 51.0
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClassCond(Unknown Source)
    at java.lang.ClassLoader.defineClass(Unknown Source)
    at java.security.SecureClassLoader.defineClass(Unknown Source)
    at java.net.URLClassLoader.defineClass(Unknown Source)
    at java.net.URLClassLoader.access$000(Unknown Source)
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:41)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:29)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:131)
    at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:285)
    at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:200)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:156)
    at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:132)
    at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:52)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:408)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)

I am using CraftBukkit 1.1 Dev 1841.

 

If its hosted on your server/computer then update Java, else wait for me to recompile the plugin (wont be done today)

 

YEAAAAAAHHH , Got it to work with mysql and SMF

 

would i have to iframe this for enjin website

 

If you want members to just enter their name and click add to get added to the whitelist then yes. If you only want a whitelist there admins can add players to the whitelist then no.

 

Will this cause lag if the MySQL is on another machine?I host my server in Paris and I want to know what will be the lag if the MySQL was hosted in any other country from Europe?

 

No, it wont lag. Its connecting to the mysql server in another thread.

 

Could you make it so that it checks if the user is on the whitelist before bPermissions check for what group does the player have?Cause right now it puts the user in a group and then check if it is in the whitelist.This way,my users.yml file will be full of people that don't have permission to build and that maybe will never join the server again

 

Isn't there a option to only add them if they don't get a non-default rank?

 

Will we see this updated for 1.2, it is giving off this error for me.

Code:

2012-03-04 15:09:55 [SEVERE] Could not load 'plugins/DynamicEffectWhitelist.jar' in folder 'plugins'
org.bukkit.plugin.InvalidPluginException: java.lang.NoClassDefFoundError: org/bukkit/event/player/PlayerListener
    at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:148)
    at org.bukkit.plugin.SimplePluginManager.loadPlugin(SimplePluginManager.java:287)
    at org.bukkit.plugin.SimplePluginManager.loadPlugins(SimplePluginManager.java:211)
    at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:207)
    at org.bukkit.craftbukkit.CraftServer.<init>(CraftServer.java:183)
    at net.minecraft.server.ServerConfigurationManager.<init>(ServerConfigurationManager.java:53)
    at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:156)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:425)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:490)
Caused by: java.lang.NoClassDefFoundError: org/bukkit/event/player/PlayerListener
    at java.lang.ClassLoader.defineClass1(Native Method)
    at java.lang.ClassLoader.defineClass(ClassLoader.java:791)
    at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
    at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
    at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:41)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:29)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist.<init>(DynamicEffectWhitelist.java:49)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:525)
    at org.bukkit.plugin.java.JavaPluginLoader.loadPlugin(JavaPluginLoader.java:144)
    ... 8 more
Caused by: java.lang.ClassNotFoundException: org.bukkit.event.player.PlayerListener
    at java.net.URLClassLoader$1.run(URLClassLoader.java:366)
    at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:41)
    at org.bukkit.plugin.java.PluginClassLoader.findClass(PluginClassLoader.java:29)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:423)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:356)
    ... 27 more