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

Discussion in 'Inactive/Unsupported Plugins' started by blackvoid, Mar 26, 2011.

  1. Offline

    blackvoid

    Rockmaclu likes this.
  2. Offline

    blackvoid

  3. Offline

    Mercury

    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
     
  4. Offline

    blackvoid

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

    Mercury

    I want connect whitelist with mysql (database)
     
  6. Offline

    blackvoid

    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>
     
  7. Offline

    Mercury

    In config.php or in config.properties ?
     
  8. Offline

    blackvoid

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

    Mercury

    What about webpage where user can enter username and captcha?
     
  10. Offline

    blackvoid

    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
     
  11. Offline

    Justino

    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!
     
  12. Offline

    blackvoid

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

    Justino

    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
     
  14. Offline

    Rockmaclu

    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.
     
  15. Offline

    blackvoid

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

    Rockmaclu

    Mmm... I see. Thanks anyway.

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

    Greetings.
     
  17. Offline

    blackvoid

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

    Rockmaclu

    Occurrs after a while of time.
     
  19. Offline

    blackvoid

    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.
     
    Last edited by a moderator: May 13, 2016
  20. Offline

    Justino

    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
     
  21. Offline

    blackvoid

    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.
     
  22. Offline

    Rockmaclu

    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.
     
  23. Offline

    blackvoid

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

    joasiee

    YEAAAAAAHHH :D :D :D, Got it to work with mysql and SMF :D
     
    blackvoid likes this.
  25. Offline

    XepherLink

    would i have to iframe this for enjin website
     
  26. Offline

    blackvoid

    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.
     
  27. Offline

    FunCraft

    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?
     
  28. Offline

    blackvoid

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

    FunCraft

    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
     
  30. Offline

    blackvoid

    Isn't there a option to only add them if they don't get a non-default rank?
     
  31. 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
     

Share This Page