[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

    OKB3 will only reward posts when there is a CHANGE in post count.
    Think of it like this:
    Player syncs, logs in, OKB3 fetches post count, say 50 -> nothing happens, as OKB3 has no record from before
    Player makes a forum posts, logs in, OKB3 compares posts counts, 51 - 50 -> player is awarded 1 x 10 for posting
     
  3. Offline

    paininflictor

    I am understanding that, what im not understanding is that the post count is changing in the mysql under the specified table, but the essentialseco isn't registering it. for instance. I post 1 or two new posts right now. I log out of the website and out of the game. I then refresh the mysql and it clearly reflects a change in post count, but when i log into minecraft, it simply doesn't add the money.
     
  4. Offline

    Kalman Olah

    Are you getting any errors? Does OKB3's startup log mention hooking into EssentialsECO?
     
  5. Offline

    paininflictor

    Ok i have solved the problem. Issue was that the Register API has to be used for it to work properly. Im thinking that maybe as a recommendation to add that to the bukkit dev page as part of the requirements for usage. I know iconomy uses it by default, but some, like Essentials Eco does not.
     
  6. Offline

    Kalman Olah

    Sorry for the confusion. I never actually tested it with anything but iConomy, so I didn't know.
     
  7. Offline

    paininflictor

    It wasn't hooked because of Register API, just note, that if this problem comes again and they aren't getting errors, its because they need the Register API :p Thanks for your time.

    yeah its hard to test it on everything. I would have used Iconoly 6.0.7 but they are having API problems atm, permissions aren't hooking correctly in PEX

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

    thedjtrollin

    PLEASE HELP :'( :(

    ive tryed and tryed but i keep getting my sql connection failed

    please help :{
     
  9. Offline

    Salax

    Suggestion: Syncing of forum warnings/infractions.
     
  10. Offline

    Kalman Olah

    Nope. Database structure is too different for all forums.
     
  11. Offline

    darkcloud784

    I get this error 20.11 20:20:39 [Server] WARNING [OKB3] Error at SQL Query: Unknown column 'exiut_usergroups.username' in 'where clause'


    I run Joomla 1.7 - (just upgraded from 1.5) User information used to be stored like this ID Username then User Group (all in one table)

    Now it is stored like this, ID Username in one table

    Group ID and another ID in another which link to a 3rd table that is used as a Key_ID linking the two... Anyway you can look into this and possibly give me a config for it?

    My config:

    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: exiut_users
            minecraft-login-name-field: username
            rank-id-field: title
            multitable:
                enable-multiple-tables: 'true'
                second-table: exiut_usergroups
                user-id-field-in-user-table: id
                user-id-field-in-second-table: 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: ***
        mysql-user: ****
        mysql-password: ****
        mysql-database-name: ****
    group-mapping:
        default:
            '2': Members
            '3': VIP
            '4': Moderator
            '5': Moderator
            '6': Admins
            '7': DonorAdmin
            '8': Admins
        worlds:
            exampleworld1:
                '1': world
                '2': new_world
                '3': skylands
                '4': world_nether
    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: user_posts
            currency-reward-per-post: '40'
     
  12. Offline

    ExplosiveBacoN

    Hey Kalman, I seem to be having a strange problem where if I use "frank" on my server, the person is not promoted nor demoted, but when I change their group on the forum, the person's group does change. Is there any possible way to fix this? I can post my config if you want to view it.
     
  13. Offline

    Kalman Olah

    2 things: Are all of the ranks you're trying to give people properly configured?(Meaning they are present in group-mapping and have an identifier)
    Also, does your MySQL user have remote UPDATE permissions?

    Once you've checked these things and it still doesn't work, post your config and any possible errors :).

    Normal mode will not be changed. Sticking to two tables.

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

    darkcloud784


    Then is there a way you can update secured mode for kunena 1.7. It doesnt store users in a separate able anymore. they all get called from the joomla user table. In the same fashion that joomla 1.7 is stored.
     
  15. Offline

    ExplosiveBacoN

    Well, it should, because it has worked prior to 3.0 update. So I'll just post my config.
    Code:
    general:
        mode: normal
        enable-whitelist: 'true'
        enable-nickname-syncing: 'false'
        enable-synced-banning: 'true'
        enable-promotion-track: 'false'
        enable-rank-changing: 'true'
        enable-post-count-rewarding: 'false'
        enable-anonymous-stat-tracking: 'false'
    modes:
        normal:
            user-table: mybb_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
        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: ***.***.***.***
        mysql-user: ******************
        mysql-password: *********************
        mysql-database-name: *************
    group-mapping:
        default:
            '7': Banned
            '2': Non-Whitelisted
            '9': Whitelisted
            '11': Premium
            '12': Donator1
            '13': Donator2
            '14': Donator3
            '16': ProDonator
            '17': ServerSponsor
            '3': Mod
            '8': Admin
            '4': Owner
        worlds:
            exampleworld1:
                '1': default
                '2': Admin
    extras:
        whitelist:
            kick-message: You are currently not whitelisted. Please visit http://www.ybgames.org for more info.
            use-as-blacklist: 'true'
            groups:
                '7': 'false'
                '2': 'true'
                '9': 'true'
                '11': 'true'
                '12': 'true'
                '13': 'true'
                '14': 'true'
                '16': 'true'
                '17': 'true'
                '3': 'true'
                '8': 'true'
                '4': 'true'
        nickname-syncing:
            nickname-field-in-usertable: nickname_field_user_table
        synced-banning:
            banned-user-forum-rank-id: '7'
            unbanned-user-forum-rank-id: '9'
            ban-message: You are banned from the forums/server.
        promotion-track:
            track: 6|4|68|123|10
        rank-changing:
            identifiers:
                '7': Banned
                '2': Non-Whitelisted
                '9': Whitelisted
                '11': Premium
                '12': Donator1
                '13': Donator2
                '14': Donator3
                '16': ProDonator
                '17': ServerSponsor
                '3': Mod
                '8': Admin
                '4': Owner
        post-count-rewarding:
            post-count-field-in-user-table: post-count-field-user-table
            currency-reward-per-post: '40'
     
  16. Offline

    Kalman Olah

    Is the player whose rank you're changing online? Do you get an error message in the console, or does it say it changed the ranks?
     
  17. Offline

    ExplosiveBacoN

    No error in console, the player is online and it does say it changed their ranks and synchronized them. I am also using groupmanager is it makes a difference.
     
  18. Offline

    Kalman Olah

    Well, since your config looks alright I'd say the only thing that could be happening is that the MySQL user doesn't have permission to actually write to the database for some reason. You would've gotten some sort of error if OKB3 was to blame.
     
  19. Offline

    ExplosiveBacoN

    Then again, why would that if the only thing I changed was my permissions system, and version of this plugin.
     
  20. Offline

    Kalman Olah

    Found the issue while browsing the github repo. Will be fixing it in a moment :)

    Version 3.2.7
    Fixed a bug that caused /Frank not to work in normal mode. I don't remember what 3.2.6 was, but I did change something. I think.

    @ExplosiveBacoN Sorry about the negative attitude, I tested it in secure mode and it worked for me. Just goes to show how few people use OKB3 for anything other than on-login-syncing, I suppose.

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

    ExplosiveBacoN

    Well whatever, you're still one of my favorite plugin developers. Thanks for the quick fix.
     
  22. Offline

    mnpeep

    Hey, I'm getting this error on bukkit #1488:
    Code:
    2011-11-22 09:58:59 [SEVERE] Error occurred while enabling OKB3 v3.2.7 (Is it up to date?): null
    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:
    #Will you be running Bulletin Board Bridge in 'normal' mode, or 'secure' mode?
        mode: normal
        enable-whitelist: 'false'
        enable-nickname-syncing: 'false'
        enable-synced-banning: 'true'
        enable-promotion-track: 'false'
        enable-rank-changing: 'false'
        enable-post-count-rewarding: 'false'
        enable-anonymous-stat-tracking: 'true'
    #If you opted for normal mode, fill this in
    modes:
        normal:
            user-table: ipb_members
            minecraft-login-name-field: name
            rank-id-field: member_group_id
            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: ipb
    #fill this in if you are using smf, vbulletin, wbb, ipb, mybb
            type1:
                user-table: mybb_users
                username-field: username
                password-field: password
                rank-id-field: usergroup
    #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: blah
        mysql-user: blah
        mysql-password: more blah
        mysql-database-name: BLAH!
    #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:
            '1': Guest
            '2': Guest
            '3': Member
            '4': Admin
            '5': Banned
            '6': Mod
            '7': Co-Admin
            '8': Head-Mod
            '9': Donator
            '10': Baby-Mod
    extras:
        whitelist:
            kick-message: This is the message a user will see if their group isn't whitelisted.
            use-as-blacklist: 'true'
            groups:
                '1': 'true'
                '2': 'false'
        nickname-syncing:
            nickname-field-in-usertable: salt
        synced-banning:
            banned-user-forum-rank-id: '5'
            unbanned-user-forum-rank-id: '10'
            ban-message: You are banned! Appeal at www.tinymc.tk
        promotion-track:
            track: 2|1|0
        rank-changing:
            identifiers:
                '1': NickNameforRank1
                '7': NickNameforAnotherRank
        post-count-rewarding:
            currency-reward-per-post: '40'
            post-count-field-in-user-table: 'like_count'
    Null pointer, fill in those nasty arraylists! D:
     
  23. Offline

    ExplosiveBacoN

    Try it out with craftbukkit build 1476.
     
  24. Offline

    mnpeep

    Nope, still gives me the same error.

    EDIT:
    Oh and 1 more question:
    What is the point of secure mode, to prompt you for a password so you can login? That would be cool! (Going to research now!)
     
  25. Offline

    Kalman Olah

    Delete your config and let OKB3 remake it. This time DON'T delete the "exampleworld1" part below the default group-mapping entries.

    EDIT: Secure mode requires you to enter your forum username & password once to receive your forum rank, as opposed to normal mode where your rank is fetched using your ingame name as your forum username. This means you don't have to make people register using their ingame names, and it's more secure. The downside is that you can't whitelist JUST registered members, as EVERYONE needs to log in and type /Sync <username> <password> to get their proper rank.

    Normal : faster, easier

    Secure : slightly more secure
     
    mnpeep likes this.
  26. Offline

    mnpeep

    Thanks! It worked!!!

    I'm keeping normal, if there was a /login [password] instead of /sync [username] [password], then I would probably go with secure.
     
  27. Offline

    Kalman Olah

    You only have to do /sync username pass once though. OKB3 saves encrypted login credentials.
    But both modes are fine :)
     
  28. Offline

    mnpeep

    Found a bug:

    When you go to the nether, it does not sync your status
     
  29. Offline

    Kalman Olah

    It does.
     
  30. Offline

    mnpeep

    Not on my server for some reason...

    Let me try something new...
     
  31. Offline

    Zaros_

    It would be great if you could add me in Skype, because i got some Problems with the Plugin...

    Skype: gjahtari19
     

Share This Page