[ADMN/WEB] OKB3 - Bulletin Board Bridge - Now on BukkitDev! [1337]

Discussion in 'Inactive/Unsupported Plugins' started by Kalman Olah, Jun 2, 2011.

  1. Offline

    Kalman Olah

  2. Offline

    Kalman Olah

    No problem
    You're welcome :)
     
  3. Offline

    apeh

    Reupload the zip please, the download link does not work, mucho gracias.
    The plugin looks very promising to use and I've been waiting for a proper forum/minecraft MYSQL based link :)
     
  4. Offline

    Kalman Olah

    The download link works for me.
    http://kalmanolah.net/files/OKB3/latest/OKB3.zip
     
  5. Offline

    plumblum

    Not sure you are aware of this so ill post it:

    Code:
    23:29:08 [SEVERE] Could not pass event PLAYER_JOIN to OKB3
    java.lang.NullPointerException
            at com.alta189.sqlLibrary.MySQL.DatabaseHandler.sqlQuery(DatabaseHandler.java:75)
            at com.alta189.sqlLibrary.MySQL.mysqlCore.sqlQuery(mysqlCore.java:52)
            at net.genericgaming.kalmanolah.okb3.OKPlayerListener.onPlayerJoin(OKPlayerListener.java:300)
            at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
            at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:124)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:33)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    The Plugin works fine just wondering why it wants to keep track of player_join and such :)

    Oh it happens for player_teleport also, just hought u should know

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

    Kalman Olah

    As I have told people a ton of times...Please post your full config.yml
    My plugin tracks PLAYER_JOIN to update a player's rank after they join the server, PLAYER_TELEPORT and PLAYER_PORTAL to check the multiworld whitelist/to update a player's rank after they switch worlds, and PLAYER_PRELOGIN to check the global whitelist.
     
  7. Offline

    Terry Tibbs

    Can you please add support for the open-source forum software Vanilla?
     
  8. Offline

    bocaj812

    If you look above, I had the same issue, I updated to the most recent version of the plugin, regenerated the config.yml, and filled everything in. make sure you did not remove the default, or global worlds, under world groups and whitelist. make sure if you are running multiworld, (this includes nether), that you have it configured correctly, also, check your permissions. Make sure your permissions match up to what you put in the okb3 config.yml
     
  9. Offline

    Kalman Olah

    Updated to v2.0.5
    Version 2.0.5
    • Added support for Vanilla forums to normal mode. This requires the passgen.php, and requires you to fill in 'vanilla' as 'forum' in config.yml, as well as to fill in type2 in config.yml.

    Show me your config.yml >:

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

    bocaj812

    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: db4free.net:3306
        mysql-user: ********
        mysql-password: *******
        mysql-database-name: jmcserver
    old-school-mode:
        usertable: users
        minecraftname-field: username
        rank-field: rank
        enable-multiple-tables: 'false'
        multitable:
            secondtable: mine_table
            useridfield-in-secondtable: user_id_field
            useridfield-in-usertable: user_id_field
    normal-mode:
        forum: custom
        type1:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
        type2:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
        type3:
            usertable: user_table
            rank-field: rank_field
            username-field: username_field
            password-field: pass_field
            secondtable: second_table
            useridfield-in-usertable: user_id_field
            useridfield-in-secondtable: user_id_field
        type4:
            usertable: users
            username-field: username
            password-field: password
            rank-field: rank
            location-of-passgenphp: http://jmcs.tk/minecraft/passgen.php
            password-set-in-config-inc-php: ********
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '1': High_King
                '2': Kings
                '3': Dukes
                '4': Knights
                '5': Architects
                '6': Nobles
                '7': Commoners
                '8': Fugitives
                '9': Foreigners
                '10': Banished
    whitelist:
        enable-whitelist: 'true'
        enable-multiworld-whitelist: 'false'
        main-world-name: JMCS
        global:
            use-as-blacklist: 'false'
            kick-message: Please visit http://jmcs.tk/ to play on this server.
            groups:
                '1': 'true'
                '2': 'true'
                '3': 'true'
                '4': 'true'
                '5': 'true'
                '6': 'true'
                '7': 'true'
                '8': 'true'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        banned-forum-user-rank-id: '10'
        unbanned-forum-user-rank-id: '8'
        ban-message: You have been banished! Go to the forum to plead your case!
    
    It's working great,

    I have the default world, nether, and skylands. Using the latest permissions release
     
  11. Offline

    Kalman Olah

    Do you still get the error? If so, post an updated server log.
     
  12. Offline

    bocaj812

    No not at all, as I said, It's running great, When I was getting the error, It was because I had messed up in configuring multiworlds. I was just explaining to the guy, what I did to fix it, and what to check for
     
  13. Offline

    Kalman Olah

    Oh :p. I thought you were quoting me. Glad to know it's working for you :).
     
  14. Offline

    WNxRev

    Please reupload version 1.3.1's webfiles. I tried updating to 2.0.5 to no avail and failed to back up the webfiles so I'm getting incorrect username or password error. For the record, I get unable to pass event blah blah blah. It's 3 AM, I'll be more detailed tomorrow.
     
  15. Offline

    Terry Tibbs

    Thank you. It is very much appreciated.
     
  16. Offline

    Kalman Olah

    http://kalmanolah.net/files/OKB3/1.3.1/OKB3.zip

    Post your config.yml, so I may help you fix this. Also post a server log, and make sure you are using OKB3 2.0.5.

    You're welcome, bro. If you need help configuring the plugin, give it your best shot, post your config.yml, server log, and some info on the error :p.

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

    WNxRev

    Thanks. I'll get to posting something, but just not on my production server.

    EDIT:

    Error,
    Code:
    2011-07-05 10:27:51 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'sync' in plugin OKB3 v2.0.5
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:37)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:129)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:298)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:711)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:676)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:669)
        at net.minecraft.server.Packet3Chat.a(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:84)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:105)
        at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Caused by: java.lang.NoSuchMethodError: com.nijiko.permissions.PermissionHandler.getGroupObject(Ljava/lang/String;Ljava/lang/String;)Lcom/nijiko/permissions/Group;
        at me.kalmanolah.okb3.OKmain.changeGroup(OKmain.java:169)
        at me.kalmanolah.okb3.OKmain.UpdateNormal(OKmain.java:256)
        at me.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:80)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    Config,
    Code:
    mode: normal
    mysql-connection-info:
        mysql-host: localhost
        mysql-user: root
        mysql-password: **********
        mysql-database-name: phpbb
    old-school-mode:
        usertable: user_table
        minecraftname-field: mine_user
        rank-field: rank_field
        enable-multiple-tables: 'false'
        multitable:
            secondtable: mine_table
            useridfield-in-secondtable: user_id_field
            useridfield-in-usertable: user_id_field
    normal-mode:
        forum: phpbb
        type1:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
        type2:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: user_rank
            location-of-passgenphp: http://localhost/test/passgen.php
            password-set-in-config-inc-php: **********
        type3:
            usertable: user_table
            rank-field: rank_field
            username-field: username_field
            password-field: pass_field
            secondtable: second_table
            useridfield-in-usertable: user_id_field
            useridfield-in-secondtable: user_id_field
        type4:
            usertable: user_table
            username-field: username
            password-field: mine_user
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '2': Founder
                '7': Donator
                '8': VIP
                '11': User
                '12': VIPDonator
                '16': Police
                '18': Judge
                '17': CP
                '19': PoliceD
                '20': JudgeD
    whitelist:
        enable-whitelist: 'false'
        enable-multiworld-whitelist: 'false'
        main-world-name: world
        global:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
        exampleworld1:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
        exampleworld2:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: This is the message a player will see if they get banned.
     
  18. Offline

    Kalman Olah

    I'm trying to fix the bug right now :).

    Updated to v2.0.6: Bugfixes!
    @xREVOLUT1ONZx

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

    WNxRev

    I'll give it a shot and come back to with the results.
     
  20. Offline

    Kalman Olah

    Alright.
     
  21. Offline

    WNxRev

    Looks good, working well. Nice job, sir. I particularly like the updating on teleport. A very smart idea for keeping things up to date.
     
  22. Offline

    Kalman Olah

    Thanks. I had to add it for the multiworld groups, really. You may want to change the bottom of your config.yml to set up linked banning. Fill in the rank ID of a banned user, and the rank ID of a standard user, and you're good to go :).
     
  23. Offline

    jchamb2010

    Shouldn't the line in your OKmain.java that is
    Code:
    query1 = "SELECT " + nickfield + " FROM " + table1 + "," + table2 + " WHERE " + table2 + "." + field1 + " = '" + name + "' AND " + table2 + "." + field4 + " = " + table1 + "." + field3;
    be
    Code:
    query1 = "SELECT " + nickfield + " FROM " + table1 + "," + table2 + " WHERE " + table2 + "." + field1 + " = '" + player.getName() + "' AND " + table2 + "." + field4 + " = " + table1 + "." + field3;
    instead? Right now the query always fails, and by looking through your source it would seem that the variable "name" is never given a value. I may be mistaken (I'm by no means a Java programmer)

    Thanks,
    John
     
  24. Offline

    Kalman Olah

    EDIT: Actually, yeah, it was broken. Thanks. If I may ask, how did you come by my source code? Or did you just decompile it.

    updated to v2.0.7

    Version 2.0.7
    • Fixed some issues with nickname syncing. Thanks to @jchamb2010

    Updated to v2.0.8
    Version 2.0.8
    • Small performance & logging improvements.
    • OKB3 now shuts down if no connection could be made to the database, if the configuration file could not be created/loaded, or if the playerlist file could not be created/loaded.
    • Fix for possible Kunena bug in normal mode.

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

    jchamb2010

    I just decompiled it because I was becoming frustrated with it not working (so i took a peek), also there's an issue with your config file as well

    Under "old-school-mode" -> "multitable" the first setting should be named "minecraftname-table" instead of "secondtable" and the 2nd setting should be named "useridfield-in-minecraftname-table" instead of "useridfield-in-secondtable" These were wrong in the default config which made all queries return errors that were saying null.null cannot be found in the database.

    -John
     
  26. Offline

    walruscode

    Code:
    [SEVERE] Could not pass event PLAYER_JOIN to OKB3
    java.lang.NullPointerException
            at me.kalmanolah.okb3.OKPlayerListener.onPlayerJoin(OKPlayerListener.java:342)
            at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:244)
            at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
            at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
            at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:124)
            at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:97)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:74)
            at net.minecraft.server.Packet1Login.a(SourceFile:43)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:226)
            at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:40)
            at net.minecraft.server.NetworkListenThread.a(SourceFile:91)
            at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:451)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:361)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
    Also happens for PLAYER_TELEPORT and pretty much every other event OKB3 listens for to update ranks.

    config.yml
    Show Spoiler
    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: localhost
        mysql-user: root
        mysql-password: *********
        mysql-database-name: database
    old-school-mode:
        usertable: phpbb_users
        minecraftname-field: mine_user
        rank-field: group_id
        enable-multiple-tables: 'true'
        multitable:
            secondtable: phpbb_profile_fields_data
            useridfield-in-secondtable: user_id
            useridfield-in-usertable: user_id
    normal-mode:
        forum: phpbb
        type1:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
        type2:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
        type3:
            usertable: user_table
            rank-field: rank_field
            username-field: username_field
            password-field: pass_field
            secondtable: second_table
            useridfield-in-usertable: user_id_field
            useridfield-in-secondtable: user_id_field
        type4:
            usertable: user_table
            username-field: username
            password-field: mine_user
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '2': Citizen
                '17': Helper
                '16': SemiMod
                '4': Mod
                '15': SemiAdmin
                '14': Admin
                '5': SuperAdmin
                '18': VIP
                '21': Op
                '22': Helper-VIP
                '23': SemiMod-VIP
                '24': Mod-VIP
                '25': SemiAdmin-VIP
                '26': Admin-VIP
                '27': SuperAdmin-VIP
        exampleworld1:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
        exampleworld2:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
    whitelist:
        enable-whitelist: 'false'
        enable-multiworld-whitelist: 'false'
        main-world-name: exampleworld0
        global:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
        exampleworld1:
            use-as-blacklist: 'true'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
        exampleworld2:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: This is the message a player will see if they get banned.
     
  27. Offline

    jchamb2010

    I was having that issue too:

    Change
    Code:
        multitable:
            secondtable: phpbb_profile_fields_data
            useridfield-in-secondtable: user_id
            useridfield-in-usertable: user_id
    
    To
    Code:
        multitable:
            minecraftname-table: phpbb_profile_fields_data
            useridfield-in-minecraftname-table: user_id
            useridfield-in-usertable: user_id
    
    See if that fixes it.
     
  28. Offline

    walruscode

    That worked, thank you!
     
  29. Offline

    jchamb2010

    @Kalman Olah

    I would love to start learning Java and help out with this project. If you wanna provide me with the source and sorta help me setup NetBeans or Eclipse I'd be more than happy to help you develop this plugin. I'm not new to programming so it shouldn't take me too long to latch on to Java (I'm fluent in PHP, JS, and VB.net as well as learning C++ and C#)

    -John
     
  30. Offline

    Kalman Olah

    Thanks for the bugfix. I generally don't have the time to run the plugin in about 26 different ways, so I don't notice these bugs :p.
    Will PM you in a moment.

    ---

    Reuploaded v2.0.8 with this bugfix.
     
  31. Offline

    sk8freak315

    Code:
    2011-07-05 19:38:06 [INFO] [OKB3] Attempting to enable OKB3 v2.0.8 by Kalman Olah...
    2011-07-05 19:38:06 [INFO] [OKB3] Successfully hooked into Permissions.
    2011-07-05 19:38:06 [INFO] [OKB3] Attempting to load configuration file...
    2011-07-05 19:38:06 [INFO] [OKB3] Configuration file successfully loaded.
    2011-07-05 19:38:06 [INFO] [OKB3] Attempting to load PlayerList file...
    2011-07-05 19:38:06 [INFO] [OKB3] PlayerList file successfully loaded.
    2011-07-05 19:38:06 [INFO] [OKB3] [DB] Initializing MySQL connection...
    2011-07-05 19:38:06 [SEVERE] [OKB3] SQLException! Communications link failure
    
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2011-07-05 19:38:06 [INFO] [OKB3] [DB] MySQL connection failed!
    2011-07-05 19:38:06 [INFO] [OKB3] Error connecting to MySQL DB, OKB3 is being disabled...
    2011-07-05 19:38:06 [INFO] [OKB3] Attempting to disable OKB3 v2.0.8 by Kalman Olah...
    2011-07-05 19:38:06 [INFO] [OKB3] OKB3 disabled successfully.
    Code:
    mode: normal
    mysql-connection-info:
        mysql-host: 'mysql.***.***'
        mysql-user: '***_admin'
        mysql-password: '***'
        mysql-database-name: '***_forum'
    old-school-mode:
        usertable: user_table
        minecraftname-field: mine_user
        rank-field: rank_field
        enable-multiple-tables: 'false'
        multitable:
            secondtable: mine_table
            useridfield-in-secondtable: user_id_field
            useridfield-in-usertable: user_id_field
    normal-mode:
        forum: mybb
        type1:
            usertable: mybb_users
            username-field: username
            userpassword-field: password
            rank-field: usergroup
        type2:
            usertable: user_table
            username-field: username_field
            userpassword-field: user_pass_field
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
        type3:
            usertable: user_table
            rank-field: rank_field
            username-field: username_field
            password-field: pass_field
            secondtable: second_table
            useridfield-in-usertable: user_id_field
            useridfield-in-secondtable: user_id_field
        type4:
            usertable: user_table
            username-field: username
            password-field: mine_user
            rank-field: rank_field
            location-of-passgenphp: http://yoursite.com/passgen.php
            password-set-in-config-inc-php: 12345pass
    world-groups:
        enable-multiworld-groups: 'true'
        default:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
        Survival:
            groups:
                '4': Admin
                '2': Builder
                '6': Moderator
        Survival_Nether:
            groups:
                '4': Admin
                '2': Builder
                '6': Moderator
        Creative:
            groups:
                '4': Admin
                '2': Builder
                '6': Moderator
    whitelist:
        enable-whitelist: 'false'
        enable-multiworld-whitelist: 'false'
        main-world-name: Survival
        global:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
        exampleworld1:
            use-as-blacklist: 'true'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
        exampleworld2:
            use-as-blacklist: 'false'
            kick-message: This is the message a user will see if their group isn't whitelisted.
            groups:
                '1': 'true'
                '2': 'false'
    nickname-sync:
        enable-nickname-syncing: 'false'
        nickname-field-in-usertable: ''
    forum-banning:
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: This is the message a player will see if they get banned.
    
    Everything is filled in correctly, but it is not getting a reply from the mysql database?
    Is there a certain port it listens from and needs to be forwarded?

    Also, please add an option in the config to disable the "Link server bans and forum bans"
    Or provide a way to disable it somehow?
    Thanks for the plugin it looks amazing, hopefully I can get it working.
     

Share This Page