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

​

​

OKB3 - Bulletin Board Bridge​

by Kalman Olah​

​

CHECK OUT OKB3 ON BUKKITDEV​

 

Just started my own testing server. Will see if the same happens to me. Update your Java. Make sure your MySQL user doesn't have a limit on the amount of queries they can perform. Make sure your MySQL timeout is disabled in your MySQL configuration.

EDIT: Restart your MySQL server after you've changed any MySQL options.

 

ok my webhost / sql has a 30seconds inactivity timwer can u add to plugin somway to attempt to reconnect and not spam my console pls

 

Sure, give me a moment(more like 5 minutes).

 

your on the clock :O

 

Code:

23:37:02 [INFO] [OKB3] Attempting to disable OKB3 v2.1.1 by Kalman Olah...
>#
# A fatal error has been detected by the Java Runtime Environment:
#
#  SIGSEGV (0xb) at pc=0x00002b25d282cdeb, pid=1575, tid=47441691686672

^was shutting down to update.

 

Why are you using v2.1.1?

 

I hadn't updated yet =)
Just did. Also whats the variable for ban reasons?

 

You just do /fban <name> <reason>.... They will be kicked with your reason when they are banned. Once they try to log in after that, the config.yml value "ban-message" will be displayed instead. It's at the bottom.

Try this.

Version 2.1.6

• Temporary fix that tries to reconnect to the MySQL database on timeout.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

is it the download link up above in main article?

 

What about WordPress/BuddyPress? Will it differ?

 

Yup. http://kalmanolah.net/files/dl.php?id=OKB3&ver=latest

Or you can use the auto-updater in my plugin .

 

Oh. What if they aren't online =o.

 

I'm only adding support for forums, not blogs or social networking stuff.

If they aren't online they are banned and demoted. They obviously aren't kicked though, since they aren't online. When they next try to log in, they will see the ban-message set in config.yml...
...Ah fuck it, I'll add ban-message saving....hang on.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

Isn't updating ranks for users. This one was promoted to Mod on the forums (ForumrankID:4)
Earlier it was doing the same thing with another member. When I updated OKB3, restarted server, his rank updated.

Code:

00:12:38 [INFO] [OKB3] laser100's ranks successfully updated.
00:12:42 [INFO] [SemiMod] laser100: test

Code:

mode: old-school
mysql-connection-info:
    mysql-host: localhost
    mysql-user: *********
    mysql-password: **********
    mysql-database-name: phpbb
old-school-mode:
    usertable: phpbb_users
    minecraftname-field: pf_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:
            '19': Griefer
            '2': Citizen
            '17': Helper
            '16': SemiMod
            '4': Mod
            '15': SemiAdmin
            '14': Admin
            '5': SuperAdmin
            '18': VIP
            '21': Op
            #Helper-VIP
            '22': Helper
            #SemiMod-VIP
            '23': SemiMod
            #Mod-VIP
            '24': Mod
            #SemiAdmin-VIP
            '25': SemiAdmin
            #Admin-VIP
            '26': Admin
            #SuperAdmin-VIP
            '27': SuperAdmin
#            '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: '19'
    unbanned-forum-user-rank-id: '2'
    ban-message: This is the message a player will see if they get banned.

 

Dunno, probably phpBB not updating instantly or your mod not setting his group as his new default group(for the rank).

Updated to v2.1.7
Version 2.1.7

• Bans are now saved to BanFile.yml instead of bbbbans.txt.
• Banned users will see the 'ban-message' value from config.yml if they try to log in, if they were banned without a specific reason.
• If a specific reason is provided when a user is banned(/fban <name> <reason>), that user will see his ban reason upon trying to log in instead.

There you go. I'm heading to bed. 2:40 am and such .

 

he was in the database as mod (forum group id:4) I set it to default when I rank them on forum.
userID Type Group-ID IP ________ Reg-date ______ Name ______ Name-clean

Code:

97     0     4     ***.***.***.**     1308668693     laser100     laser100

 

I'll look into it once I finish the other updates for my plugin....
A couple of things, though
- Other players are having their ranks updated just fine, indicating that this is an issue with your forum/setup, not my plugin
- Minecraft usernames in the profile fields are case sensitive

...Really heading to bed now

 

Is there a particular reason for that?

 

I have multiple permissions for my worlds set up and working properly as well.

Heres my config.yml

Code:

mode: old-school
'###The mode the plugin will run in, options are ''normal'' or ''old-school''###': ''
? '###In old-school mode, the server does NOT check a username/password! It just gets
    a rank from your forum DB and sets it as your group###'
: ''
? '###If you''re using old-school mode, fill in the section labeled ''old-school-mode''
    If not, fill in the section labeled ''normal-mode'''
: ''
mysql-connection-info:
    mysql-host: 173.193.4.135
    mysql-user: myuser
    mysql-password: mypass
    mysql-database-name: rubikscr_forum
old-school-mode:
    usertable: mybb_users
    minecraftname-field: username
    rank-field: usergroup
    enable-multiple-tables: false
    '###If enable-multiple-tables is true, fill in the multitable section': ''
    multitable:
        minecraftname-table: phpbb_profile_fields_data
        useridfield-in-minecraftname-table: user_id
        useridfield-in-usertable: user_id
normal-mode:
    type-of-forum: mybb
    ? '###Current supported forum types md5 for MD5 encryption-based forums,phpbb
        for phpBB3, smf for SMF, vbulletin for vBulletin, mybb for myBB, xenforo for
        XenForo, ipb for IPB, wbb for WBB, kunena for Kunena###'
    : ''
    '###Fill in the fields for the forum type that matches your type-of-forum value': ''
    location-of-passgenphp: http://rubikscraft.com/passgen.php
    password-set-in-config-inc-php: mypass
    md5:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    phpbb:
        usertable: phpbb_users
        username-field: username
        userpassword-field: user_password
        rank-field: user_rank
    smf:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    vbulletin:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    mybb:
        usertable: mybb_users
        username-field: username
        userpassword-field: password
        rank-field: usergroup
    xenforo:
        usertable: xf_user
        rank-field: user_group_id
        username-field: username
        password-table: xf_user_authenticate
        password-field: data
        useridfield-in-usertable: user_id
        useridfield-in-passtable: user_id
    ipb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    wbb:
        usertable: user_table
        username-field: username_field
        userpassword-field: user_pass_field
        rank-field: rank_field
    kunena:
        usertable: user_table
        rank-table: rank_table
        rank-field: rank_field
        username-field: username_field
        password-field: pass_field
        useridfield-in-usertable: user_id_field
        useridfield-in-rank-table: user_id_field
groups:
    '###''RANKID IN RANKTABLE''=GROUPMANAGER GROUP###': ''
    '4': Admin
    '8': TeamAqua
    '9': TeamMagma
    '6': Moderator
    '10': Donater
whitelist:
    enable-whitelist: 'true'
    use-as-blacklist: 'false'
    kick-message: This is the message a user will see if their group isn't whitelisted.
    whitelist-groups:
        '###''''RANKID IN RANKTABLE'': true'' TO ALLOW A RANK TO JOIN###': ''
        '###''''RANKID IN RANKTABLE'': false'' TO NOT ALLOW A RANK TO JOIN###': ''
        '8': 'true'
        '9': 'true'
        '4': 'true'
        '6': 'true'
        '10': 'true'
        '7': 'false'
'###If use-as-blacklist is enabled, groups that aren''t specified on the whitelist will count as blacklisted###': ''
nickname-sync:
    enable-nickname-syncing: 'false'
    nickname-field-in-usertable: 'username_clean'

 

Would you mind making this open-source through Github? If not, would you mind me decompiling it?

 

I think they more or less had their rank updated when it was working properly. This is only effecting users I recently promoted.

 

I need some more help setting this up with Xenforo.
Can somebody help me?
I already have a working mysql server connected to the mc server.

 

It's a forum bridge.
+ Only forums generally have ranks systems.

Fill in 'xenforo' as 'forum' in config.yml.
Fill in 'type3' like this:

Code:

    type3:
        usertable: xf_user
        rank-field: user_group_id
        username-field: username
        password-field: data
        secondtable: xf_user_authenticate
        useridfield-in-usertable: user_id
        useridfield-in-secondtable: user_id

Go ahead.

Do all of your worlds have a groups.yml? Are multiworld groups turned off/configured properly?

Code:

old-school-mode:
    usertable: phpbb_users
    minecraftname-field: pf_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

Change the rank-field like this:

Code:

rank-field: user_rank

You are using a really, really old config.yml Delete your config.yml and have my plugin generate a new one for you .

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

And the groupID part?

Code:

world-groups:
    enable-multiworld-groups: 'true'
    world:
        groups:
            '3': Admins
            '5': Builders

I am not sure if the #'s are good.
oh and permissions, do i have to run it in mysql mode?

 

Turn off multiworld groups, change 'groups' to 'default'.

Code:

world-groups:
    enable-multiworld-groups: 'false'
    world:
        default:
            '3': Admins
            '5': Builders

As for the IDs, only you can know what ranks have what IDs.
I personally prefer running permissions in flatfile mode...But I think both would work, really.

 

I have to connect to the xenforo mysql right? Not the bukkit one?

 

Yup

 

ok still not working
config.yml PlayerList.yml is emty

this is from phpmyadmin.
I dont get any errors in the server console.

 

If you want help, post a full server log and your current config.yml please.

Version 2.2.0

• /fban now notifies you if the player you're trying to ban is already banned.
• /funban now notifies you if the player you're trying to unban isn't banned.
• Fixed a bug that was causing the "essentialschat hook" message to be displayed, even though EssentialsChat wasn't present.
• Added an option to cause /fban bans and /funban unbans to only affect the forum, and not the server. (is-server-ban-too in config.yml)
• Added linked promotion/demotion tracks. These will only work if multiworld groups are OFF.
• Added /fpromote command. This command promotes a player on the server and the forums. Permissions node: bbb.promote
• Added /fdemote command. This command demotes a player on the server and the forums. Permissions node: bbb.demote

Due to the way promotion/demotion tracks work, I've had to give up on multigroups again. Sorry.

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

log config