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

    WindedDragon

    I know that this is probably something that I have done wrong, but when I start my server I get the following error:

    Code:
    2011-05-11 21:25:53 [INFO] Dynamic Effect Whitelist version 0.4 is enabled!
    2011-05-11 21:25:53 [SEVERE] [DEWhitelist] Couldn't execute MySQL statement:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.whitelist' doesn't exist
        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:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
        at com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:250)
        at com.dynamiceffect.whitelist.DynamicEffectWhitelist.onEnable(DynamicEffectWhitelist.java:70)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:127)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:632)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:218)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:116)
        at org.bukkit.craftbukkit.CraftServer.loadPlugins(CraftServer.java:94)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:217)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:204)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:144)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:259)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:394)
    2011-05-11 21:25:53 [INFO] [DEWhitelist] Initialized db connection
    2011-05-11 21:25:53 [SEVERE] [DEWhitelist] Couldn't execute MySQL statement:
    com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.whitelist' doesn't exist
        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:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111)
        at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2273)
        at com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:250)
        at com.dynamiceffect.whitelist.DynamicEffectWhitelist$1.run(DynamicEffectWhitelist.java:75)
        at java.util.TimerThread.mainLoop(Unknown Source)
        at java.util.TimerThread.run(Unknown Source)
     
  3. Offline

    blackvoid

    You need to import the whitelist.sql file in an application like phpMyAdmin.


    New version 0.6
    • Now works for bukkit 766
     
  4. Offline

    U_PiGuy_U

    I've got my settings configured to read from the Member_name column in the Smf_members table, yet the whitelist.php only displays a bunch of |'s, and it won't let me log in. What am I doing wrong?
    PHP:
    <?php
        $MySQL 
    = array(
            
    "host" => "localhost",
            
    "username" => "Username? But I barely even know her name!",
            
    "password" => "Password? No way!",
            
    "database" => "smf",
            
    "table" => "smf_members",
        );
        
    mysql_connect($MySQL["host"], $MySQL["username"], $MySQL["password"]);
        
    mysql_select_db($MySQL["database"]);

        
    $query "SELECT * FROM `" $MySQL["table"] . "`;";
        
    $Result mysql_query($query);
        
    $i 0;
        
    $rows mysql_num_rows($Result);

        while( 
    $row mysql_fetch_array($Result) ){
            print((
    $i $rows $row["name"] . "|" $row["name"]));
            
    $i++;
        }
    ?>
    Code:
    #### DEWhitelist configuration ###
    #Sun May 15 23:37:36 EDT 2011
    mysql-updateinterval=60
    name=member_name
    usemysql=false
    mysql-database=jdbc\:mysql\://localhost\:3306/minecraft
    http-url=http\://websiteurl.censored/whitelist.php
    mysql-user=root
    mysql-string=SELECT {name} FROM `{table}`;
    dismsg=Please Register\!
    whitelist-url=none
    mysql-table=whitelist
    mysql-password=root
     
  5. Offline

    blackvoid

    If you use the php script the only thing you need to set is http-url and usemysql.

    This code should work.
    PHP:
    <?php
        $MySQL 
    = array(
            
    "host" => "localhost",
            
    "username" => "Username? But I barely even know her name!",
            
    "password" => "Password? No way!",
            
    "database" => "smf",
            
    "table" => "smf_members",
        );
        
    mysql_connect($MySQL["host"], $MySQL["username"], $MySQL["password"]);
        
    mysql_select_db($MySQL["database"]);

        
    $query "SELECT * FROM `" $MySQL["table"] . "` WHERE `member_name` <> '';";
        
    $Result mysql_query($query);
        
    $i 0;
        
    $rows mysql_num_rows($Result);

        while( 
    $row mysql_fetch_array($Result) ){
            print((
    $i $rows $row["member_name"] . "|" $row["member_name"]));
            
    $i++;
        }
    ?>
     
  6. Offline

    Ghert

    Hello! I added my nick to mysql. Here is .php script - http://mc.ghert.pl/wl.php . When i'm joing my server i see only "You are not in the whitelist!"
    Here is my config:
    Code:
    mysql-updateinterval=60
    name=
    usemysql=false
    mysql-database=
    http-url=http\://mc.ghert.pl/wl.php
    mysql-user=
    mysql-string=
    dismsg=You are not in the whitelist\!
    mysql-table=
    whitelist-url=
    mysql-password=
     
  7. Offline

    blackvoid

    Its cause not all usernames is lowered. In next version i will lower it automatically when retrieving the whitelist.
     
  8. Offline

    Ghert

    @up
    Ok, i'll be waiting ;)
     
  9. Offline

    CrYoSniPe

    When I use this script it only seems to like lower case letters... I'm using the whitelist.php method. I attempt to join after using upper case letters on the form and it does not work. Any ideas?
     
  10. Offline

    blackvoid

    Like i said above it only works with lower case if you use the php script.

    You can change all
    $row["member_name"] to strtolower($row["member_name"])
    Until i release the update.
     
  11. Offline

    CrYoSniPe

    Thank you very much!
     
  12. Offline

    Arnold9995

    hey could you halp me please?
    the plugins does not connect for some reason to the whitelist on my website.. I use the Mysql on the website it says
    that its added on the list. but nothing happends on the server.
     
  13. Offline

    blackvoid

    Any errors?
    If you use a table with different column names add/remove command wont work.
     
  14. Offline

    methos

    can u make force login nick via whitelist - when all slots occupied ?
     
  15. Offline

    Ideal-Hosting

    Will this ever be open-source?
     
  16. Offline

    blackvoid

    I dont understand what you want can you explain more in detail.

    I think Ill release the source when Ive cleaned up the code a bit.
     
  17. Offline

    Ideal-Hosting

  18. Offline

    blackvoid

    Version 0.7 out!
    • If you get your whitelist via HTTP it will now make all usernames lowercased.
    • Whitelist retrival is now threaded.
    • Source is now available
     
  19. Offline

    Ratchet

    thanks for this neat plugin, using it so players need to register on my forum to be whitelisted :)
     
    blackvoid likes this.
  20. Offline

    blackvoid

    I dont know if this is working in 798 since i no longer run this on my server. Can anyone reply if its working, else i will try it on my dev server tomorrow.
     
  21. Offline

    FITZ_NICK

    798 everything works;)
     
  22. Offline

    pudd1nG

    Any chance this plugin could have a reverse mode, to act as a MySQL banlist? Would be amazing.
     
  23. Offline

    blackvoid

    Thanks for telling me
    This is a whitelist not a blacklist. If you want mysql bans download kiwiadmin.

    EDIT: I will update this to the latest bukkit version when bukkit for 1.6 is released.
     
  24. Offline

    Misaka

  25. Offline

    blackvoid

  26. Offline

    Misaka

    A little update on my problem. Somehow, script converted \n sequence into <br>, which was imported into database. Noticed it when tried to edit one of rows. Fixed my script a bit, It's working now. By the way, great plugin. Will use it now.
     
    blackvoid likes this.
  27. Offline

    blackvoid

    Ok, thank you for telling me.
     
  28. Offline

    Misaka

    I've run into yet another problem. Added user into database, but he still can't join. Tried both in-game and through mysql itself
     
  29. Offline

    blackvoid

    Are you using PHP or direct mysql?
    Do you get any errors?
     
  30. Offline

    Misaka

    No Errors, phpmyadmin, direct mysql, using plugin. It just adds a new line and that's all. Old players can join, new ones can't.
     
  31. Offline

    blackvoid

    Version v0.8 out!
    • Added a debuging option which currently only prints all players in the whitelist.
    • chat command is now changed from dew to whitelist
    • few things i cant remember
    Try setting debug to true in this version, see if all players gets printed.
     

Share This Page