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

​

​

OKB3 - Bulletin Board Bridge​

by Kalman Olah​

​

CHECK OUT OKB3 ON BUKKITDEV​

 

vbulletin not working with own prefixes?

Code:

22:18:59 [WARNING] [OKB3] Error at SQL Query: [B]Table 'vbulletin.user_table' doesn[/B]
[B]'t exist[/B]
22:18:59 [SEVERE] null
org.bukkit.command.CommandException: Unhandled exception executing command 'sync
' in plugin OKB3 v2.1.2

RTPONG++

my vbulletin prefix is vb_ but when i change the usertabe to "vb_user" the console error shows

Table 'vbulletin.vb_user' doesn't exist

this vbulletin.*** sucks

Need help pls.!

Code:

mode: normal
mysql-connection-info:
    mysql-host: pi*el-*lite.*et
    mysql-user: ***
    mysql-password: ****
    mysql-database-name: ***
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: vbulletin
    type1:
        usertable: vb_user
        username-field: username
        userpassword-field: password
        rank-field: usergroupid
    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:
            '6': Admins
            '2': default
    exampleworld1:
        groups:
            '1': ExampleGroup1
            '2': ExampleGroup2
    exampleworld2:
        groups:
            '1': ExampleGroup1
            '2': ExampleGroup2
whitelist:
    enable-whitelist: 'false'
    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'
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.

 

I'd say your

Code:

mysql-database-name: ***

isn't correct. Make sure it's actually the name of the database, and post a full server log please. From when you start the server until you get the error.

EDIT: Are you sure your table isn't called 'vbuser' or 'vb_vbuser' or something?

 

can u give me an working config for this table?
databasename: vbulletin
usertable: vb_user
...

 

Give me 10 minutes. I'll fix your issue.

It's working fine for me. I have a question though. Is your forum hosted on another server? Are you using two different MySQL users? One for the forum itself, one for my plugin? If so, your second MySQL user could not have permissions to select from vbulletin. You can choose what databases they have access to when you create them. Double check that, please.

EDIT: I'm 60% sure your MySQL user doesn't have access to the database.

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

 

hey soulreafer, try putting ':3306' after ' mysql-host: pi*el-*lite.*et' so its like 'mysql-host: pi*el-*lite.*et:3306'
see if that works

 

He already fixed it. We worked it out in PMs. He was using Permissions 2.x.x.
I should probably edit the OP to reflect that my plugin only works with 3.x.x

 

Got this on server start
Plugin works fine, just the error.

Code:

16:12:15 [INFO] [OKB3] Attempting to enable OKB3 v2.1.1 by Kalman Olah...
16:12:15 [INFO] [OKB3] Initiating auto-update...
16:12:16 [SEVERE] Error occurred while enabling OKB3 v2.1.1 (Is it up to date?): For inp
ut string: "2&OKB3"
java.lang.NumberFormatException: For input string: "2&OKB3"
        at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
        at java.lang.Integer.parseInt(Integer.java:481)
        at java.lang.Integer.parseInt(Integer.java:514)
        at me.kalmanolah.extras.OKUpdater.update(OKUpdater.java:39)
        at me.kalmanolah.okb3.OKmain.onEnable(OKmain.java:93)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:85
7)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:2
64)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:151)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:136)
        at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:284)
        at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:271)
        at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:148)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:335)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:422)
16:12:16 [INFO] [xAuth] 'Permission' support enabled

 

I'm updating the auto-updater for the last time right now. Hang on for a minute .

Updated to v2.1.3.
This will be your final manual update .

Version 2.1.3

• Made final changes to the auto-updater.

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

 

good, glad you got it working, he has i nice server too! and a rollercoaster!

Hey if your not busy, could you add the /promote [username] [rank] and /demote [username] [rank] to the next update? My server would greatly appreciate it Please and thank you

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

 

I would like to suggest BuddyPress (with bbPress if it matters) and/or WordPress. I am using all three and would love this plugin. This is exactly the feature that I am looking for.

Otherwise, very good job except that well, I can't use it with my setup I will be setting up a compatible software just to try this plugin out though!

 

im using ipb how do i find these
usertable: user_table username-field: username_field userpassword-field: user_pass_field rank-field: rank_field

 

Open up the forum database in PHPMyAdmin, SQLYog, Navicat or whatever, and look for the table in which usernames/passwords are stored. This generally has something to do with "member" or "user". This is your 'usertable'. Look for the field in that table that usernames are stored in. This is your 'username-field'. Look for the field that's called 'password' or something like that. This is your 'userpassword-field'. Your 'rank-field' is a field generally containing numbers from 1-10 named along the lines of 'user_rank', 'rank', 'usergroup', etc...

 

ok i found it its called members i found all the fields except password field... it only has
members_pass_hash andmembers_pass_salt

 

This would be very nice. Also if possible a type of ban that would demote them to a specified group on the forum. Along with an unban that puts them to a specified group also.

But that might go against the direction you're taking this plugin. It seems to be forum controls the server not vise vera. Either way its great.

PS: I think multi groups would be a nice step

 

members_pass_hash

....
This is literally already in the plugin. Check the bottom of your config.yml

Support has been added for bbPress(standalone edition). Set 'forum' in config.yml to 'bbpress' and fill in 'type2'.

Updated to v2.1.4
Version 2.1.4

• Support has been added for bbPress(standalone edition). Set 'forum' in config.yml to 'bbpress' and fill in 'type2'.

I'm not really "busy", but I've been fucking around with Internet Spaceships, Wookie: Online and a bunch of totally unimportant stuff, so give me a day or two and I'll add it.

OKB3 has a ban feature that bans a player from both the server AND the forum, and can unban them from both. Just for you though, I'll add an option to turn off server banning, so the ban feature only bans/unbans from the forum.

I'll even add the multigroups, delimited by commas. Only commas. I'm not going to dabble in multitable & forum-specific stuff right now. Tomorrow or monday.

@NeatMonster : ^

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

 

In that case, a ban reason variable would be wonderful =)

Much <3. THANX

 

Thinking of making a plugin next week.
If you have a permission node, you can put down a sign saying [CheckPoint]/use a command(possibly costing items or iconomy money) that saves your location.
When you die, you respawn at the sign instead of your normal spawn location, and you may or may not keep your items.
Thoughts?

 

why not use a command instead like /checkpoint
Results: "Spawn Saved" "You do not have enough funds"

cfg: Cost true false how much?

 

I don't know. Some server owners prefer signs to commands. It was just a thought. I could do both...

I'm adding this right now. Just fixing a final bug.

 

Sounds nice as long as the permission nodes/config set the bill (option to choose how much, who can use it, disable/enable inventory keeping)

Judging by your current permissions/config I'm sure it will.

Q: Would the sign be made by admin for predefined locations or could players make them also?

I like this plugin idea because I need more money sinks in my economy server.

 

well with signs unless you can make it vanish after a bit i can see one sign crowded server

 

The sign will be destroyed once you use the checkpoint or make a new one...Atleast, that's what I'm planning for now.

No problem...I'm wondering if I could make it cost items from your inventory, though...Like, an alternative to iconomy money...It could cost 10 iron bars. If I can get it to work...Anyways, almost done with the ban reasons thingy. Just a few more minutes while I figure out what the hell I'm doing.

 

can you seperate permisions into checkpoint.sign and checkpoint.command if u know what im saying

 

Items would be even more wonderful. Players complain too much about the uselessness of gun powder.

 

Updated to v2.1.5
Version 2.1.5

• the /fban command can now be used with or without a reason(/fban <name> or /fban <name> <reason>)

Expect a moderately "large" update monday.
To-do:
- Revamp help menu.
- Add support for multigroups seperated like this: "x, x, x, x, x".
- Add option for /fban and /funban to only alter the forum, and not the server bans.
- Add a forum-and-server linked promote/demote system.

That, and I don't like iConomy... I'm more of a survival player.

I will.

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

 

Whats the variables name and will it auto reconfig the ban part of the config to use it?

 

Hello againnnn haha
I have been using your plugin and it has been working great most of the time.
Recently I have been having quite a few players have some problems though. When they first join, their rank assigns fine, but in my server I have a portal to another world and when they use the portal and are in the new world which the portal leads to, the rank does not assign properly. I asked them to type /bbb sync with no success. I am running in old school mode. I have all tried force sync with no success. My config is obviously fine since the plugin works I just have this slight problem ocassionally.

I've asked them if they have cracked clients and some of them do and some of them don't. So I really dont know what the problem could be. They reconnect and the same problem as well.

Any recommendations?

 

after like... 2 min of being connected to sql it shuts down the connnection and spams my console

 

2 things:
1 - Make sure you have a groups.yml(permissions) for all worlds. I'd suggest this over a globalGroups.yml. Go on, try it.
2 - Config.yml?

 

It has multiworld support. If that is configured wrong I could see it doing this.