[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

    Oscarius

    Hi, I am also running SMF2 and would like to achieve the same thing, but I'm rather stuck. Any pointers?
     
  3. Offline

    Kalman Olah

    There are no pointers. My plugin does not support this DB structure. SMF is supported in secure mode. SMF is also supported in normal mode, assuming you let players register with their ingame names as their usernames.
     
  4. Offline

    CaptureCraft

    @Kalman Olah

    Hey, I am using Group Manager with your plugin and everything is working great. Whenever somebody is promoted on the forum, they're promoted on the server. The only thing is, everytime they join the server it says 'You were moved the the group members' (current group). Whenever it syncs when they login it seems to be moving them to the group they're already in therefore displaying this message.

    A fix would be greatly appreciated, thanks.
     
  5. Offline

    Kalman Olah

    Working as intended, since group mapping may change. Pretty sure you can disable that notification through GroupManager though :).
     
  6. Offline

    CaptureCraft

    Oh ok, thanks. Also, can I contact you on Skype or something, I need to make a request. I am more than happy to pay you money.
     
  7. Offline

    Kalman Olah

    Sure, just PM me your skype name or leave it in the thread :).
     
  8. Offline

    Chiller

    I have gotten a Null Pointer, IDK how I got it but its not letting the plugin startup... I will also place my config.
    Error:
    Code:
    java.lang.NullPointerException
            at me.kalmanolah.okb3.OKConfig.readStringList(OKConfig.java:66)
            at me.kalmanolah.okb3.OKConfig.loadkeys(OKConfig.java:214)
            at me.kalmanolah.okb3.OKConfig.configCheck(OKConfig.java:33)
            at me.kalmanolah.okb3.OKConfig.<init>(OKConfig.java:18)
            at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:122)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:957)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:176)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:159)
            at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:337)
            at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:324)
            at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:161)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:388)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    Config:
    Code:
    general:
      mode: secure
      enable-whitelist: 'false'
      enable-nickname-syncing: 'true'
      enable-synced-banning: 'true'
      enable-promotion-track: 'false'
      enable-rank-changing: 'true'
      enable-post-count-rewarding: 'false'
      enable-anonymous-stat-tracking: 'true'
    modes:
      normal:
        user-table: user_table
        minecraft-login-name-field: minecraft_name
        rank-id-field: rank_group_field
        multitable:
          enable-multiple-tables: 'false'
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
      secure:
        forum: ipb
        type1:
          user-table: members
          username-field: name
          password-field: members_pass_hash
          rank-id-field: member_group_id
        type2:
          user-table: user_table
          username-field: username_field
          password-field: password_field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://website.com/passgen.php
          password-set-in-config-inc-php: password
        type3:
          user-table: user_table
          rank-id-field: rank_group_field
          username-field: username_field
          password-field: password_field
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
        type4:
          user-table: user_table
          username-field: username_field
          password-field: password-field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://website.com/passgen.php
          password-set-in-config-inc-php: password
    mysql-connection:
      mysql-host: localhost
      mysql-user: chiller
      mysql-password: *********
      mysql-database-name: ipb
    group-mapping:
      default:
        '1': Guest
        '5': Guest
        '3': Builder
        '7': VIP
        '6': Moderator
        '4': Administrator
    extras:
      whitelist:
        kick-message: You have been Kicked from the Server.
        use-as-blacklist: 'false'
        groups:
          '1': 'true'
          '2': 'false'
      nickname-syncing:
        nickname-field-in-usertable: members_display_name
      synced-banning:
        banned-user-forum-rank-id: '5'
        unbanned-user-forum-rank-id: '3'
        ban-message: You have been Banned from the Server.
      promotion-track:
        track: 6|4|68|123|10
      rank-changing:
        identifiers:
          '1': NickNameforRank1
          '7': NickNameforAnotherRank
      post-count-rewarding:
        post-count-field-in-user-table: posts
        currency-reward-per-post: '40'
    
     
  9. Offline

    Kalman Olah

    Change
    Code:
    group-mapping:
      default:
        '1': Guest
        '5': Guest
        '3': Builder
        '7': VIP
        '6': Moderator
        '4': Administrator
    to
    Code:
    group-mapping:
      default:
        '1': Guest
        '5': Guest
        '3': Builder
        '7': VIP
        '6': Moderator
        '4': Administrator
      worlds:
        exampleworld1:
          '1': ExampleGroup1
          '2': ExampleGroup2
     
  10. Offline

    Chiller

    Thanks!!
     
  11. Offline

    Donny

    Code:
    2011-11-27 02:25:08 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:null/phpbb
    2011-11-27 02:25:08 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "null"'..
    2011-11-27 02:25:08 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'sync' in plugin OKB3 v3.3.0
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:42)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:364)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:756)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:721)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:714)
        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:92)
        at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:516)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:414)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
    Caused by: java.lang.NullPointerException
        at lib.PatPeter.SQLibrary.MySQL.query(MySQL.java:115)
        at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFunctions.java:175)
        at me.kalmanolah.okb3.OKFunctions.updateNormal(OKFunctions.java:214)
        at me.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:113)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        ... 12 more
    CB: 1510
    OKB#: 3.3.0

    New config is required in 3.3.0?

    Code:
    general:
        mode: normal
        enable-whitelist: 'false'
        enable-nickname-syncing: 'false'
        enable-synced-banning: 'false'
        enable-promotion-track: 'false'
        enable-rank-changing: 'false'
        enable-post-count-rewarding: 'false'
        enable-anonymous-stat-tracking: 'true'
    modes:
        normal:
            user-table: phpbb_users
            minecraft-login-name-field: pf_mine_user
            rank-id-field: group_id
            multitable:
                enable-multiple-tables: 'true'
                second-table: phpbb_profile_fields_data
                user-id-field-in-user-table: user_id
                user-id-field-in-second-table: user_id
        secure:
            forum: phpbb
            type1:
                user-table: user_table
                username-field: username_field
                password-field: password_field
                rank-id-field: rank_group_field
            type2:
                user-table: user_table
                username-field: username_field
                password-field: password_field
                rank-id-field: rank_group_field
                location-of-passgen-php: http://yoursite.com/passgen.php
                password-set-in-config-inc-php: 12345pass
            type3:
                user-table: user_table
                rank-id-field: rank_group_field
                username-field: username_field
                password-field: password_field
                second-table: second_table
                user-id-field-in-user-table: user_id_field_user_table
                user-id-field-in-second-table: user_id_field_second_table
            type4:
                user-table: user_table
                username-field: username_field
                password-field: password-field
                rank-id-field: rank_group_field
                location-of-passgen-php: http://yoursite.com/passgen.php
                password-set-in-config-inc-php: 12345pass
    mysql-connection:
        mysql-host: localhost
        mysql-user: *********
        mysql-password: ****************
        mysql-database-name: *********
    group-mapping:
        default:
            '19': Griefer
            '2': Citizen
            '17': Helper
            '16': SemiMod
            '4': Mod
            '15': SemiAdmin
            '14': Admin
            '5': SuperAdmin
            '18': VIP
            '21': God
    #        Helper-VIP
            '22': Helper-VIP
    #        SemiMod-VIP
            '23': SemiMod-VIP
    #        Mod-VIP
            '24': Mod-VIP
    #        SemiAdmin-VIP
            '25': SemiAdmin-VIP
    #        Admin-VIP
            '26': Admin-VIP
    #        SuperAdmin-VIP
            '27': SuperAdmin
    #        '24': #Mod-VIP
    #        '25': #SemiAdmin-VIP
    #        '26': #Admin-VIP
    #        '27': #SuperAdmin-VIP
        worlds:
            exampleworld1:
                '1': ExampleGroup1
                '2': ExampleGroup2
    extras:
        whitelist:
            kick-message: This is the message a user will see if their group isn't whitelisted.
            use-as-blacklist: 'false'
            groups:
                '1': 'true'
                '2': 'false'
        nickname-syncing:
            nickname-field-in-usertable: nickname_field_user_table
        synced-banning:
            banned-user-forum-rank-id: '0'
            unbanned-user-forum-rank-id: '10'
            ban-message: This is the message a user will see if they are banned.
        promotion-track:
            track: 6|4|68|123|10
        rank-changing:
            identifiers:
                '1': NickNameforRank1
                '7': NickNameforAnotherRank
        post-count-rewarding:
            post-count-field-in-user-table: post-count-field-user-table
            currency-reward-per-post: '40'
    
     
  12. Offline

    Kalman Olah

    It's called reading the changelog, come on now =/.
    Code:
    mysql-connection:
        mysql-host: localhost
        mysql-user: *********
        mysql-password: ****************
        mysql-database-name: *********
        mysql-port: '3306'
     
  13. Offline

    Donny

    Oops! didn't catch that!
     
  14. Offline

    Aiqueneldar

    Hello
    I'm trying to setup and run your plugin with SMF. Both is first-time-use for me so I might have gotten something slightly wrong.
    I've tried to follow the instructions for secure setup found in this thread, but for some reason I can't get the plugin to use the correct mysql values from the config.yml file. It looks in the logs like the plguin just ignores anything wirtten in the config file.
    I created the config from the example one provided in this thread, and then edited it for my settings. When I tried to remove the config and rerun minecraft so the plugin would create a new one, the file was empty. First run file was also empty, don't know if this is the expected behaviour.

    My conf file, edited to remove passwords:
    Code:
    general:
    #Will you be running Bulletin Board Bridge in 'normal' mode, or 'secure' mode?
        mode: secure
        enable-whitelist: 'true'
        enable-nickname-syncing: 'true'
        enable-synced-banning: 'true'
        enable-promotion-track: 'true'
        enable-rank-changing: 'true'
        enable-post-count-rewarding: 'false'
        enable-anonymous-stat-tracking: 'true'
    #If you opted for normal mode, fill this in
    modes:
        normal:
            user-table: smf_users
            minecraft-login-name-field: username
            rank-id-field: usergroup
            multitable:
                enable-multiple-tables: 'false'
                second-table: second_table
                user-id-field-in-user-table: user_id_field_user_table
                user-id-field-in-second-table: user_id_field_second_table
    #If you opted for secure mode, fill this in
        secure:
    #forum type: options are phpbb, smf, vbulletin, kunena, xenforo, wbb, ipb, mybb, vanilla, #bbpress, custom
            forum: smf
    #fill this in if you are using smf, vbulletin, wbb, ipb, mybb
            type1:
                user-table: smf_members
                username-field: real_name
                password-field: passwd
                rank-id-field: id_group
    #fill this in if you are using phpbb, bbpress or vanilla
            type2:
                user-table: user_table
                username-field: username_field
                password-field: password_field
                rank-id-field: rank_group_field
                location-of-passgen-php: http://yoursite.com/passgen.php
                password-set-in-config-inc-php: 12345pass
    #fill this in if you are using kunena or xenforo
            type3:
                user-table: xf_user
                rank-id-field: user_group_id
                username-field: username
                password-field: data
                second-table: xf_user_authenticate
                user-id-field-in-user-table: user_id
                user-id-field-in-second-table: user_id
    #fill this in if you are using a custom encryption
            type4:
                user-table: user_table
                username-field: username_field
                password-field: password-field
                rank-id-field: rank_group_field
                location-of-passgen-php: http://yoursite.com/passgen.php
                password-set-in-config-inc-php: 12345pass
    mysql-connection:
        mysql-host: localhost
        mysql-user: minecraft
        mysql-password: *******
        mysql-database-name: minecraft
        mysql-port: '3306'
    #Map your rank IDs to groups here. world-specific overwrites default. You NEED atleast 1
    #entry under worlds, even if the world doesn't exist.
    group-mapping:
        default:
            '1000': default
            '900': Member
            '800': VIP
            '100': Moderator
        Admins:
            '1' : Admins
        worlds:
            PlanetBob:
                '1000': default
                '900': Member
                '800': VIP
                '100': Moderator
    extras:
        whitelist:
            kick-message: Sorry, you are not in a whitelisted group.
            use-as-blacklist: 'true'
            groups:
                '1000': 'true'
                '900': 'true'
                '800': 'true'
                '100': 'true'
                '1' : 'true'
        nickname-syncing:
            nickname-field-in-usertable: member_name
        synced-banning:
            banned-user-forum-rank-id: '1001'
            unbanned-user-forum-rank-id: '1000|900|800|100|0'
            ban-message: You are banned
        promotion-track:
            track: 1000|900|800|100
        rank-changing:
            identifiers:
                '1000': default
                '900': Member
                '800': VIP
                '100': Moderator
                '0': Admins
        post-count-rewarding:
            currency-reward-per-post: '40'
            post-count-field-in-user-table: 'like_coun'
    
    And server log shows:
    Code:
    16:17:44 [INFO] Starting minecraft server version 1.0.0
    16:17:44 [INFO] Loading properties
    16:17:44 [INFO] Starting Minecraft server on *:25565
    16:17:44 [INFO] This server is running Craftbukkit version git-Bukkit-1.8.1-R4-40-gb85b9b2-b1519jnks (MC: 1.0.0) (Implementing API version 1.0.0-R1-SNAPSHOT)
    16:17:45 [INFO] [PermissionsEx] sql backend registered!
    16:17:45 [INFO] [PermissionsEx] file backend registered!
    16:17:45 [INFO] [PermissionsEx] PermissionEx plugin initialized.
    16:17:45 [INFO] [PermissionsEx] p2compat backend registered!
    16:17:45 [INFO] [PermissionsCompat] Compatibility Layer Initalized!
    16:17:45 [INFO] [PermissionsEx] Initializing file backend
    16:17:45 [INFO] Preparing level "PlanetBob"
    16:17:45 [INFO] Default game type: 0
    16:17:45 [INFO] Preparing start region for level 0 (Seed: 1173734141)
    16:17:45 [INFO] Preparing start region for level 1 (Seed: 1173734141)
    16:17:46 [INFO] Preparing start region for level 2 (Seed: 1173734141)
    16:17:46 [INFO] Preparing spawn area: 52%
    16:17:46 [INFO] [OKB3] Attempting to enable OKB3 v3.3.0 by Kalman Olah...
    16:17:46 [INFO] [OKB3] Initiating auto-update...
    16:17:46 [INFO] [OKB3] You already have the latest version of OKB3.
    16:17:46 [INFO] [PermissionsCompat] Compatibility layer enabled.
    16:17:46 [INFO] [PermissionsEx] Superperms support enabled.
    16:17:46 [INFO] [PermissionsEx] v1.16 enabled
    16:17:47 [INFO] [OKB3] Configuration file loaded.
    16:17:47 [INFO] [OKB3] [DB] Initializing MySQL connection...
    16:17:47 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/database
    16:17:47 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'root'@'localhost' (using password: YES).
    16:17:47 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/database
    16:17:47 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'root'@'localhost' (using password: YES).
    16:17:47 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/database
    16:17:47 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'root'@'localhost' (using password: YES).
    16:17:47 [INFO] [OKB3] [DB] Loading database...
    16:17:47 [INFO] [OKB3] OKB3 v3.3.0 enabled successfully.
    
    Might be I'm missing something trivial, been staring at this for too long now. Any help or pointer is appreciated.
     
  15. Offline

    Kalman Olah

    Code:
    20:56:01 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/tempdb4
    20:56:01 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Excepti
    on: Access denied for user 'derpderp'@'localhost' (using password: YES).
    20:56:01 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/tempdb4
    20:56:01 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Excepti
    on: Access denied for user 'derpderp'@'localhost' (using password: YES).
    20:56:01 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/tempdb4
    20:56:01 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Excepti
    on: Access denied for user 'derpderp'@'localhost' (using password: YES).
    Code:
    mysql-connection:
      mysql-host: localhost
      mysql-user: derpderp
      mysql-password: ******
      mysql-database-name: tempdb4
      mysql-port: '3306'
    @Aiqueneldar As you can see, it works for me. Only explanation would be that you didn't overwrite your old config when editing, or placed it in the wrong directory.
     
  16. Offline

    Oscarius

    Code:
    29.11 04:04:55 [Server] SEVERE [OKB3] [MySQL] jdbc:mysql://localhost:null/minecraft\_web
    29.11 04:04:55 [Server] SEVERE [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Cannot load connection class because of underlying exception: 'java.lang.NumberFormatException: For input string: "null"'..
    29.11 04:04:55 [Server] SEVERE Exception in thread "Thread-426" 
    29.11 04:04:55 [Server] SEVERE java.lang.NullPointerException
    29.11 04:04:55 [Server] SEVERE     at lib.PatPeter.SQLibrary.MySQL.query(MySQL.java:115)
    29.11 04:04:55 [Server] SEVERE     at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFunctions.java:175)
    29.11 04:04:55 [Server] SEVERE     at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:48)
    29.11 04:04:55 [Server] SEVERE     at java.lang.Thread.run(Thread.java:662)
    I'm getting this error with 3.3.0. Seems like it doesn't pick up the port even though it's specified in config.yml
     
  17. Offline

    Kalman Olah

    Post your config, please :).

    Did you do a full restart?
     
  18. Offline

    Aiqueneldar

    First, thanks for making time! Greatly appreciated.
    Secondly, I found the error. The autogenerated configfile hade ALOT of newlines in the beginning which I didn't notice at first.
    SO what did I do? I wrote my own config from the beginning of the file. What happends then? all those newlines get pushed down, the plugin reads the config file, first my config, then the config beneth it... DUH.

    Well hopefully if anyone else have this issue they will now see this post, saving you some time.

    Thanx for your help and patience!
     
  19. Offline

    Oscarius

    Yes, I did several full restarts. I figured I'd delete the config.yml that I got from here and let it auto-generate a new one. The error was that in the example configuration, the mysql-port field wasn't surrounded by apostrophes.

    Anyway, it no longer says "jdbc:mysql://localhost:null" but I am having a similar error now. It still can't connect to the database for some reason, which is weird because older versions of OKB have worked just fine for us.

    During startup:
    Code:
    2011-11-29 14:27:39 [INFO] [OKB3] Attempting to enable OKB3 v3.3.0 by Kalman Olah...
    2011-11-29 14:27:39 [INFO] [OKB3] Initiating auto-update...
    2011-11-29 14:27:40 [INFO] [OKB3] You already have the latest version of OKB3.
    2011-11-29 14:27:40 [INFO] [OKB3] Configuration file loaded.
    2011-11-29 14:27:40 [INFO] [OKB3] [DB] Initializing MySQL connection...
    2011-11-29 14:27:40 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/ubercraft\_web
    2011-11-29 14:27:40 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'website'@'localhost' to database 'ubercraft\_web'.
    2011-11-29 14:27:40 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/ubercraft\_web
    2011-11-29 14:27:40 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'website'@'localhost' to database 'ubercraft\_web'.
    2011-11-29 14:27:40 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/ubercraft\_web
    2011-11-29 14:27:40 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'website'@'localhost' to database 'ubercraft\_web'.
    2011-11-29 14:27:40 [INFO] [OKB3] [DB] Loading database...
    2011-11-29 14:27:40 [INFO] [OKB3] [DB] Creating table 'players'...
    2011-11-29 14:27:40 [INFO] [OKB3] [DB] Creating table 'bans'...
    2011-11-29 14:27:40 [INFO] [OKB3] [DB] Creating table 'posts'...
    2011-11-29 14:27:40 [INFO] [OKB3] OKB3 v3.3.0 enabled successfully.
    2011-11-29 14:27:40 [INFO] [OKB3] Hooked into iConomy version: 5...
    When a player connects:
    Code:
    2011-11-29 14:28:06 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/ubercraft\_web
    2011-11-29 14:28:06 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'website'@'localhost' to database 'ubercraft\_web'.
    2011-11-29 14:28:06 [SEVERE] Exception in thread "Thread-96"
    2011-11-29 14:28:06 [SEVERE] java.lang.NullPointerException
    2011-11-29 14:28:06 [SEVERE]     at lib.PatPeter.SQLibrary.MySQL.query(MySQL.java:115)
    2011-11-29 14:28:06 [SEVERE]     at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFunctions.java:175)
    2011-11-29 14:28:06 [SEVERE]     at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:48)
    2011-11-29 14:28:06 [SEVERE]     at java.lang.Thread.run(Thread.java:662)
    config.yml:
    Code:
    general:
      mode: normal
      enable-whitelist: 'false'
      enable-nickname-syncing: 'false'
      enable-synced-banning: 'true'
      enable-promotion-track: 'true'
      enable-rank-changing: 'true'
      enable-post-count-rewarding: 'false'
      enable-anonymous-stat-tracking: 'true'
    modes:
      normal:
        user-table: smf_members
        minecraft-login-name-field: member_name
        rank-id-field: id_group
        multitable:
          enable-multiple-tables: 'false'
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
      secure:
        forum: phpbb
        type1:
          user-table: user_table
          username-field: username_field
          password-field: password_field
          rank-id-field: rank_group_field
        type2:
          user-table: user_table
          username-field: username_field
          password-field: password_field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://yoursite.com/passgen.php
          password-set-in-config-inc-php: 12345pass
        type3:
          user-table: user_table
          rank-id-field: rank_group_field
          username-field: username_field
          password-field: password_field
          second-table: second_table
          user-id-field-in-user-table: user_id_field_user_table
          user-id-field-in-second-table: user_id_field_second_table
        type4:
          user-table: user_table
          username-field: username_field
          password-field: password-field
          rank-id-field: rank_group_field
          location-of-passgen-php: http://yoursite.com/passgen.php
          password-set-in-config-inc-php: 12345pass
    mysql-connection:
      mysql-host: localhost
      mysql-user: website
      mysql-password: password
      mysql-database-name: ubercraft_web
      mysql-port: '3306'
    group-mapping:
      default:
        '4': default
        '11': Builder
        '10': BasicDonor
        '12': AdvancedDonor
        '13': EliteDonor
        '9': Moderator
        '1': Admin
      worlds:
        exampleworld1:
          '1': ExampleGroup1
          '2': ExampleGroup2
    extras:
      whitelist:
        kick-message: This is the message a user will see if their group isn't whitelisted.
        use-as-blacklist: 'false'
        groups:
          '1': 'true'
          '2': 'false'
      nickname-syncing:
        nickname-field-in-usertable: member_name
      synced-banning:
        banned-user-forum-rank-id: '14'
        unbanned-user-forum-rank-id: '11'
        ban-message: You have been banned.
      promotion-track:
        track: 4|11|10|12|13
      rank-changing:
        identifiers:
          '11': Builder
          '10': BasicDonor
          '12': AdvancedDonor
          '13': EliteDonor
      post-count-rewarding:
        post-count-field-in-user-table: posts
        currency-reward-per-post: '40'
    
    CB #1529, OKB 3.3.0
     
  20. Offline

    nitroburn

    Yes, it appears it is passing an incorrect username and database name by adding a \ before the _

    Switch to username root and now it connects, but cannot open database dwmc\_smf now...


    Pre-switching user:
    Code:
    2011-11-29 13:43:57 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/dwmc\_smf
    2011-11-29 13:43:57 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'dwmc\_dwmc'@'localhost' (using password: YES).
    2011-11-29 13:43:57 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/dwmc\_smf
    2011-11-29 13:43:57 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'dwmc\_dwmc'@'localhost' (using password: YES).
    2011-11-29 13:43:57 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/dwmc\_smf
    2011-11-29 13:43:57 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Access denied for user 'dwmc\_dwmc'@'localhost' (using password: YES).
    
    post-switching user:
    Code:
    2011-11-29 13:52:32 [INFO] [OKB3] [DB] Initializing MySQL connection...
    2011-11-29 13:52:32 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/dwmc\_smf
    2011-11-29 13:52:32 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Incorrect database name 'dwmc\_smf'.
    2011-11-29 13:52:32 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/dwmc\_smf
    2011-11-29 13:52:32 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Incorrect database name 'dwmc\_smf'.
    2011-11-29 13:52:32 [SEVERE] [OKB3] [MySQL] jdbc:mysql://localhost:3306/dwmc\_smf
    2011-11-29 13:52:32 [SEVERE] [OKB3] [MySQL] Could not be resolved because of an SQL Exception: Incorrect database name 'dwmc\_smf'.
    Is there any workaround?

    Maybe something was overlooked when kalmanolah:
    Changed MySQL/SQLite library to PatPeter's Library.
     
  21. Offline

    ScottCameron

    That's what is happening to me too, anyone found a work-a-round?
     
  22. Offline

    seriosbrad

    @Kalman Olah

    Feature request:

    Instead of relying on an economy plugin for rewards, how about rewarding custom items like 1 gold per per forum posts or something customizable? But it shouldn't dish out for already existing posts, a user could receive thousands of rewards if they already have a lot of posts :p

    I personally do not like heavily command driven economy plugins with "fake" text based currency.

    When you log in you recieve a message like:

    "You have been awarded xxx gold based on the amount of forum posts since you last logged in"
     
  23. Offline

    Kalman Olah

    Sure, I'll add that option :).

    @nitroburn
    @ScottCameron
    @Oscarius

    Looks like it's escaping "_" by turning it into "\_". I'll look into this now.
    EDIT: Fixed the issues. Please check out the BukkitDev page :).

    EDIT by Moderator: merged posts, please use the edit button instead of double posting.
     
    Last edited by a moderator: Jul 15, 2016
    seriosbrad likes this.
  24. Offline

    microskies

    @Kalman Olah Have you changed anything to do with the permissions bbb.hide? Because after re-enabling your plugin, im not getting ANY join messages
     
  25. Offline

    N00B_Daddy

    Kalman If you could add me on skype I'd like to talk to you about a probably simple problem Im having. My skype is N00B_Daddy Thats N(zero zero)B. Thanks
     
  26. Offline

    seriosbrad

    @Kalman Olah

    I have this strange issue with OKB3 and PEX.

    First, here's my config.
    http://pastebin.com/7zs64S67

    When I ban someone on the forum with that config, the user is still able to join the server but instead of OKB3 kicking them with the ban message, PEX allows them to join and puts them into a group. At first when I had no banned group setup in PEX (because i didn't think i needed one since OKB3 should kick them) it would put them into the "default" group. So out of confusion I created a Banned group in PEX which is how it is currently still setup. OKB3 is still not kicking them, and the user ends up in the Banned group in PEX :confused:. I haven't given them any permissions to do anything, even chat so it's not a huge issue but I would like for banned users to be kicked.

    You can see in my OKB3 config that synced banning is enabled, and the group ID # matches my forum group.
     
  27. Offline

    Deadlystrike

    @Kalman Olah
    How would i make it so if a player has rank ID 3 for example he gets assigned to more then 1 group because you can do that in bpermissions
     
  28. Offline

    Kalman Olah

    The "synced banning" thing is for when you use /fban <player>. It'll set their to group 7 in your case, and ban them. This WILL NOT WORK if you ban them from the forums.
    If you want them to get denied access when their group is set to 7 FROM THE FORUMS, enable the whitelist and configure it like this:
    Code:
    extras:
      whitelist:
        kick-message: You are either banned or not whitelisted, GG.
        use-as-blacklist: 'true'
        groups:
                '7': 'false'
     
    seriosbrad likes this.
  29. Offline

    seriosbrad

    Thanks Kalman.

    I make banning from the forums a priority as I can set an automatic lift date.
     
  30. Offline

    Kalman Olah

    No problem. Sorry it took so long for me to answer :).
    Nope. People without bbb.hide should have join messages. Can anyone confirm?
    I could help you with that. Do you want it to work in normal mode, or secure mode?
     
  31. Offline

    Deadlystrike

    The plugins connection is timeing out from our sql server due to inactivity. in result it is spaming console
    however, as soon as somone logs in it syncs right away and re-establishes connection.... can u add a option to hide the
    "OKB3 SQLException! Communications Link Failure or just revert to your old ping system ?
     

Share This Page