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

    Anoniempje

    Can you add a list based on a URL ?
    So i can make a php list of players that registerd on my forum.
    The webhost that runs the forum does not allow external connections to the mysql db.
     
  3. Offline

    Juze

    Yet another one whitelist plugin. I could see myself using this plugin in future. :)
     
  4. Offline

    blackvoid

    Ill make that possible in next version.

    Update
    Version 0.2
    • Optimizing
    • Now supports getting whitlist via http

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
  5. Offline

    Teffen

    I'm having some difficulties starting the plugin. I receive an error stating "No suitable driver found for jdbc:mysql://localhost:3306..."

    Can you bundle a compatible driver and specify where it needs to be located?
    Thanks,

    Teffen
     
  6. Offline

    Birdie

    Could you make it possible to convert a flatfile whitelist.txt?
     
  7. Offline

    blackvoid

    I added where you download the connector and where you place it.

    I added a small java application for that. Its on the download page.
    Place your white-list.txt in the same folder as the application and run whitelistimporter.bat.
    It will create a whitelist.sql file which you should import to your mysql database using phpmyadmin or other applcation you can run SQL queries from.
     
  8. Offline

    Teffen

    Where would I place it if I'm using Ubuntu 10.04 64 bit?
     
  9. Offline

    blackvoid

    You would place it at the location java is installed, in the ext directory.

    EDIT:

    v0.3 out.
    Now working with 670
     
  10. Offline

    blackvoid

    Just checked and its working for 733
     
  11. Offline

    fragen

    I would like to know if I can the custom whitelist message upon denial on logon as standalone, instead of this full plugin?
     
  12. Offline

    Stabu2Dead

    This might be a very intensive request. Either way I give myself hope it will come true. My idea is that, you make the mysql white-list able to integrate with phpbb3 forum software. For example user group "registered" cannot play on server. Switch user from "registered" to "whitelist" group. Person can now play on server. If this can't be made totally understable.
     
  13. Offline

    blackvoid

    That can be made, im using this on my own server and i will make it possible to use with phpbb since im using it for my community.

    I will make it when i get more sparetime.
     
  14. Offline

    blackvoid

    Version 0.4 is now out.

    • Added the possibility to add/remove users to/from the whitelist ingame, using the chat command "dew add <player>" and "dew remove <player>"
    • Compatible with 740
    • Possibility to use custom SQL query string
      Prefixes:
      {time} = unix time
      {name} = MySQL field the minecraft username is in.
      {table} = Table the users is in.
     
  15. Offline

    Digi

    Well in 0.4, `name` column is still used somewhere since I've modified "name=user" and then I've tried using query "SELECT `user` FROM `users`" and it says that column 'name' doesn't exist :}

    You should edit the thread title and contents with the new changes too :p
     
  16. Offline

    blackvoid

    mysql-string=SELECT {name} FROM `{table}`;
    is the default.
    {name} is the name variable.
    You need to use the name variable and {name} in your query string since the script uses the name variable to know which column the username is in.
    SELECT `user` FROM `users` wont work unless theres a column called user.
     
  17. Offline

    Digi

    No.

    Config:
    (Other settings don't matter in this case)

    And error:
    Now you understand ? :}

    And ofc there's a column named "user" there, but it doesn't use it apparently.
    I also tried using
    but it makes no difference, somewhere in your code you forgot the hardcoded `name` column, that's my point.


    EDIT: you might need the full error log, so here it is:
    errors (open)
    2011-05-01 23:53:10 [SEVERE] [DEWhitelist] Couldn't execute MySQL statement:
    java.sql.SQLException: Column 'name' not found.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    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.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
    at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:253)
    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-01 23:53:10 [SEVERE] [DEWhitelist] Couldn't execute MySQL statement:
    java.sql.SQLException: Column 'name' not found.
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    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.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
    at com.mysql.jdbc.ResultSetImpl.getString(ResultSetImpl.java:5616)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist.RefreshWhitelist(DynamicEffectWhitelist.java:253)
    at com.dynamiceffect.whitelist.DynamicEffectWhitelist$1.run(DynamicEffectWhitelist.java:75)
    at java.util.TimerThread.mainLoop(Unknown Source)
    at java.util.TimerThread.run(Unknown Source)
     
  18. Offline

    blackvoid

    Yeah i understand now :)
    Forgot to change it in one place, it should work now in new version which is only the fix thats new.
     
    Digi likes this.
  19. Offline

    Digi

    Yep, but you might want to fix the link because v0.5 is linking to v0.4 :p

    EDIT: I see that the link is fixed.
     
  20. Offline

    blackvoid

    Sorry for that its fixed now.
     
  21. Offline

    Silent_Samurai

    What are the permission nods, or is it just "op".
     
  22. Offline

    blackvoid

    dewhitelist.remove - permission to add users to the whitelist
    dewhitelist.add - permission to remove users from the whitelist
     
  23. Offline

    Bonkerz

    can someone make an register page ? or say me how to make that ?
     
  24. Offline

    blackvoid

    Do you want them to be accepted right away or so you want to accept them?
     
  25. Offline

    Bonkerz

    directly accepted when the make registering, when they registers, they can join the server.
     
  26. Offline

    blackvoid

    Does this form look good?
    [​IMG]
    Re-captcha can be disabled if you dont want it for some reason.
     
  27. Offline

    Bonkerz

    yes it will be awesome!

    oh my gosh, it's exactly what i want, :O

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: May 13, 2016
  28. Offline

    blackvoid

    Its already made i was just asking if the design was looking good :)
    Its now available in OP
     
  29. Offline

    Bonkerz

    it's so goood ! thks !
     
  30. Offline

    blackvoid

    no problem :)
     

Share This Page