[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

    darkcloud784

    For some reason mine comes back with an "internal error has occured" When I check the console it says [WARNING] [OKB3] Error at SQL Query: Unknown column 'ppbb_profile_fields_data.pf_mine_name' in 'where clause'
    Am I doing something wrong? I mean I had it set to normal, and it says successful BUT it did not actually pass any of the promotions/demotions or really anything to the game nor the forums....
    Here's my config -


    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: 74.63.220.106
        mysql-user: *****
        mysql-password: *****
        mysql-database-name: ****
    old-school-mode:
        usertable: phpbb_users
        minecraftname-field: pf_mine_name
        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: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
        type2:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php: ***
        type3:
            usertable: phpbb_users
            rank-field: group_id
            username-field: username
            password-field: user_password
            secondtable: phpbb_profile_fields_data
            useridfield-in-usertable: user_id
            useridfield-in-secondtable: user_id
        type4:
            usertable: php_users
            username-field: username
            password-field: mine_user
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php: ****
    world-groups:
        enable-multiworld-groups: 'true'
        default:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
        world:
            groups:
                '1': Builder
                '2': Moderator
                '3': Admins
                '0': Default
        world_nether:
            groups:
                '1': Builder
                '2': Moderator
                '3': Admins
                '0': Default
    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:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: Your banned from the forums, what makes you think we wouldn't do the same on the server?
    promotion-tracks:
        '1': '3'
        '2': '5'
        '3': '16'
    forum-ranks: ''
    forum-rank:
        Admin: '3'
        Registered: '1'
        Moderator: '2'
    
     
  3. Offline

    Kalman Olah

    Try using the /bbb command. Does this give you the "incorrect command usage" error too?
     
  4. Offline

    Donny

    There was an error in my config. let me try now

    =l both /sync and /bb sync work, but do not update rank. <-- without xauth running.
     
  5. Offline

    Kalman Olah

    I'll need the server log with the error to help you.

    Just to confirm...It works now?
    EDIT: Oh.

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

    Donny

    No errors or anything.
     
  7. Offline

    darkcloud784

    This is the error I recieve.

    Code:
    2011-07-15 05:49:30 [WARNING] [OKB3] Error at SQL Query: Unknown column 'phpbb_profile_fields_data.pf_mine_name' in 'where clause'
    2011-07-15 05:49:30 [SEVERE] Could not pass event PLAYER_TELEPORT to OKB3
    java.lang.NullPointerException
        at me.kalmanolah.okb3.OKPlayerListener.onPlayerTeleport(OKPlayerListener.java:47)
        at org.bukkit.plugin.java.JavaPluginLoader$8.execute(JavaPluginLoader.java:293)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:321)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:373)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:342)
        at net.minecraft.server.Packet10Flying.a(SourceFile:126)
        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)
     
  8. Offline

    Kalman Olah

    Just tested my plugin using your config, everything works fine. [WARNING] [OKB3] Error at SQL Query: Unknown column 'ppbb_profile_fields_data.pf_mine_name' in 'where clause'...Look closely at the column name. phpbb was missing an 'h'.
    If the commands return the success message, and there are NO errors in the console, my plugin is doing its job. I just thoroughly tested all features of my plugin using your remote phpBB old-school setup, and every single feature worked. Since you've said before that sometimes my plugin works, and sometimes it doesn't, this issue is more than likely being caused by: a - An incorrect Permissions setup(groups.yml, users.yml, globalusers.yml, globalgroups.yml...), b - A global rank overriding world-specific ranks(Again, Permissions related), c - another plugin. Since I myself can't recreate the issue though, I can't help you with this any further. I'd like to, but I can't, since nothing's broken(Atleast for me...).

    I did uncover a minor config.yml bug that caused both the 'forum-rank' and 'forum-ranks' values to be written to the config.yml. This has been fixed in v2.3.2.

    Version 2.3.2
    • Minor config.yml bug fixed. You'll probably want to remake your config.yml.

    Well, I guess there is no column named "pf_mine_name" in the table "phpbb_profile_fields_data". Either that, or your MySQL user doesn't have access to it. Make sure your MySQL user has the ability to UPDATE/SELECT data from the entire database.

    EDIT: If neither of these are the case, try manually checking if the user causing this error actually has an entry in phpbb_profile_fields_data with his user ID. If you don't set the minecraft name profile fields as a field REQUIRED FOR REGISTRATION, some people will be missing from the table.

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

    darkcloud784

    Ok, I got it to successfully sync, I removed global permissions and my permissions setup is correct on the permissions plugin side, not sure about my config with BBB though. Effectively what I would like to happen is promote someone to the "builder" group when they register on the forums (become a registered member). The minecraft field is required for registration and being entered in. I made sure of that on the last test.

    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host: *******
        mysql-user: ********
        mysql-password: ***********
        mysql-database-name: ******
    old-school-mode:
        usertable: phpbb_users
        minecraftname-field: pf_mine_name
        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: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
        type2:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php: Mudracker1
        type3:
            usertable: phpbb_users
            rank-field: group_id
            username-field: username
            password-field: user_password
            secondtable: phpbb_profile_fields_data
            useridfield-in-usertable: user_id
            useridfield-in-secondtable: user_id
        type4:
            usertable: php_users
            username-field: username
            password-field: mine_user
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php: Mudracker1
    world-groups:
        enable-multiworld-groups: 'true'
        default:
            groups:
                '1': ExampleGroup1
                '2': ExampleGroup2
        world:
            groups:
                '1': Builder
                '2': Moderator
                '3': Admins
                '0': Default
        world_nether:
            groups:
                '1': Builder
                '2': Moderator
                '3': Admins
                '0': Default
    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:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: Your banned from the forums, what makes you think we wouldn't do the same on the server?
    promotion-tracks:
        '1': '3'
        '2': '5'
        '3': '16'
    forum-ranks: ''
    forum-rank:
        Admin: '3'
        Registered: '1'
        Moderator: '2'
    
     
  10. Offline

    Donny

    Okay. I went through and disabled all plugins but permissions, permissionssql, OKB3, Herochat, iConomy, ChestShop. Still no success. - its not option c

    I have no global ranks - not option b

    As for option a. I use permissions SQL. I went and changed from SQL to yml, success (storageconfig.yml). OKB3 isn't changing my players ranks under PermissionsSQL.
     
  11. Offline

    Kalman Olah

    First of all, you don't need to turn on multiworld groups if they're going to be the same, just turn the option off. It'll still work across worlds.
    Second, to promote registered users to the Builder group automatically, edit your config.yml world-groups to this:
    Code:
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '2': Builder
                '7': Builder
                'FORUM MOD RANK ID': Moderator
                'FORUM ADMIN RANK ID': Admins
    
    Replace FORUM MOD RANK ID with your moderator's group ID. This can be found in phpbb_groups.
    Replace FORUM ADMIN RANK ID with your admin's group ID. This can be found in phpbb_groups.
    I'm pretty sure the IDs 2 and 7 map to Registered users and Newly Registered users. This way, any registered users will be given the Builder rank.
    You don't have to specifically mention the Default Permissions rank, as this is given to anyone by default.

    EDIT: You could also switch your rank-field to 'user_rank'. This means OKB3 will check the rank field instead of the group field. Any registered normal user should have a rank of 0 by default. Personal preference, really.

    So hang on. If you switch to flatfile, OKB3 works?

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

    Donny

    Yep. Just double checked to make sure.

    - Last time when you had me do this, if you remember. It got errors and I had to restart server and planned to test permissions yml later, but right after the restart all the users ranks were updated (this may be why it seemed to have "worked"). But now when I switch back to sql it reverts their ranks, doesn't keep them.
     
  13. Offline

    Kalman Olah

    Alright. I'll post my group changing function in the Permissions thread, and wait for a response. Let's hope I can fix this soon :p.
     
  14. Offline

    Donny

    Support in the Permissions thread? How do you get that? ;)

    lol alright, gl and thanx
     
  15. Offline

    transient

    Here's what I have in my config, it says rank successfully updated but nothing changes in vbulletin or in game:

    Code:
    forum-ranks:
        'Belvedere': '37'
        'Diverus': '16'
        'Lusitania': '9'
        'ReavethSep': '20'
        'Svell': '29'
        'Tamriel': '24'
    
    Does the /frank config options just go into the bottom of the config file, like right underneath promotion tracks? What DB privileges does the account need on the DB as I gave it select, insert, update, and delete? Also, can the ranks be named anything? For example Belvedere is not actually a permission group or a forum rank. I was thinking it could just be a friendly name as the 37 is what is really needed.
     
  16. Offline

    Kalman Olah

    http://forums.bukkit.org/threads/ad...in-of-tomorrow-935.18430/page-173#post-474820
    Posted it. Heading to bed now :p.

    The forum-ranks values are there to map rank names to IDs for usage with the /frank command. They're not there to give players ranks. You're doing it wrong, bro. The MySQL user needs Update/Select priveleges.

    If these are actually rank names, not players, you should know that any rank mapped in forum-ranks has to be mapped in world-groups. As in, if you want to be able to use the /frank command with a rank, that rank has to be set up to work with regular /sync.

    EDIT: I'm heading to bed now, but if you still have issues, post your config.yml and I'll check it out later.
     
  17. Offline

    transient

    @Kalman Olah Sorry error on my part. phpmyadmin told me it gave the account UPDATE but for some reason it didn't take and it was throwing the error up on the server console but not in game.

    It's working now, thanks!
     
  18. Offline

    darkcloud784

    Ok so I have it "working" lol. It does change ranks but it demotes moderators to Builders and for admins it just says Error: unable to update - No errors are passed through the console though.

    Code:
    mode: old-school
    mysql-connection-info:
        mysql-host:
        mysql-user:
        mysql-password:
        mysql-database-name: thehissi_forums
    old-school-mode:
        usertable: phpbb_users
        minecraftname-field: pf_minecraft_name
        rank-field: user_rank
        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: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
        type2:
            usertable: phpbb_users
            username-field: username
            userpassword-field: user_password
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php:
        type3:
            usertable: phpbb_users
            rank-field: group_id
            username-field: username
            password-field: user_password
            secondtable: phpbb_profile_fields_data
            useridfield-in-usertable: user_id
            useridfield-in-secondtable: user_id
        type4:
            usertable: php_users
            username-field: username
            password-field: mine_user
            rank-field: group_id
            location-of-passgenphp: http://thehissingcreeper.com/forum/webfiles/passgen.php
            password-set-in-config-inc-php:
    world-groups:
        enable-multiworld-groups: 'false'
        default:
            groups:
                '2': Builder
                '7': Builder
                '4': Moderator
                '5': Admins
    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:
        is-server-ban-too: 'true'
        banned-forum-user-rank-id: '0'
        unbanned-forum-user-rank-id: '10'
        ban-message: Your banned from the forums, what makes you think we wouldn't do the same on the server?
    promotion-tracks:
        '1': '3'
        '2': '5'
        '3': '16'
    forum-ranks: ''
    forum-rank:
        Admin: '5'
        Registered: '2'
        Moderator: '4'
    

     
  19. Offline

    Kalman Olah

    Edit this:
    Code:
            groups:
                '0': Builder
                'MOD RANK ID': Moderator
                'ADMIN RANK ID': Admins
    Check those IDs in the phpbb_ranks table, not phpbb_groups, since you're using user_rank as your rank field now.
    Also,
    change this:
    Code:
    forum-ranks:
        Admins: '5'
        Registered: '2'
        Moderator: '4'
    Should it be Admin or Admins? What's the name of the Permissions group?

    So in general...Check the rank IDs in the rank table, fix those. Make sure the names match the names of the groups in Permissions' groups.yml.
    Oh, and remove your password from the post -.-
    EDIT: You may or may not want to switch back to group_id from user_rank. group_id is a bit easier. Just remember to match groups to the groups in phpbb_groups if you're using group_id, and to match groups to the ranks in phpbb_ranks if you're using user_rank
    Nice :).


    Seriously heading to bed now.
     
  20. Offline

    darkcloud784

    I got it working thanx =P

    Definitely cool that you helped, some developers aren't as generous with their time.... Especially to someone like me which is quite new to SQL data-basing and forum group handling. Anywho thank you alot!!!!!

     
  21. Offline

    Bios Element

    So is there any chance this could be made compatable with PermissionsEx? I realize it's a bit out-of-scope but it'd be really useful to have.
     
  22. Offline

    Kalman Olah

    Version 2.3.3

    • Added support for PermissionsEx. :)
     
    Bios Element likes this.
  23. Offline

    ryguy222

    Tried using it with permissionsEX and I'm getting this error message, same error for /fysncall or /sync

    Code:
    2011-07-15 17:23:12 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'fsyncall' in plugin OKB3 v2.3.3
        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.getUserObject(Ljava/lang/String;Ljava/lang/String;)Lcom/nijiko/permissions/User;
        at me.kalmanolah.okb3.OKmain.CheckPermission(OKmain.java:347)
        at me.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:160)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:35)
        ... 12 more
    No errors during startup.
     
  24. Offline

    Kalman Olah

    OKB3 only works with the PermissionsEx jar. As far I know, there's 2 .jars. One called "Permissions" which pretends to be Permissions, and one called PermissionsEx. Can you confirm/deny this?
     
  25. Offline

    Donny

    !!!!!!!!
    Discovery
    !!!!!!!!
    Users rank permissions update but not title.
    So say my player gets promoted from 'Citizen' to 'Helper'
    Their title will still show 'Citizen' but they will have 'Helper' permissions. (prefixes are defined by the group they are in. So no idea how this can happen)
    **I tested this, but it may have only been with a few users**
    ______________
    Quite possibly a problem with permissionsSQL.
    ______________

    This problem is a POS, it keeps changing. I deleted a user from permissions and had him rejoin to see if his rank/title fixed, it did and so did everyone elses on rejoin after that....
    Seriously makes no sense =(
    Edit: scratch that, only some users that are promoted(via forums) after I deleted that user have their titles/ranks updated on "/sync" or rejoin. The users that were promoted before need as stated below.
    ______
    A sure way to get it to work is to delete the user "/pr username delete" from permissions and have the user rejoin.
     
  26. Offline

    Bios Element

    Yay. Thanks a ton dude, I look forward to using it.
     
  27. Offline

    Kalman Olah

    I current have 2 posts up in two different threads, and I'm waiting for a reply from anyone who knows stuff about Permissions. As far as I can tell, my plugin SHOULD work flawlessly with PermissionsSQL. Obviously, I've missed something. I can't just go around deleting users before changing groups because that would cause them to lose their custom prefixes/permissions and stuff.

    You're welcome. I tested it myself with the PermissionsEx .jar. If it doesn't work for you, please remember to post an error log, your current version of PermissionsEx, the name of the .jar, etc.

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

    bocaj812

    hey, one BIG thing! Can you add like customizable permission nodes, because like, we have like watchmen, moderators, admins, and owners, who all have the frank fdemote and fpromote permissions, but we want to diable them from ranking themselves up without permission. because a watchmen, can promote himself to the owner. IDK if theres anything you can do to help us, customizable permission nodes or maybe in the config, specify a certain rank you need to be to say you need to be admin to promote to admin, or you need to be a mod to promote someone to mod, but if there is any way you could do that, it would be greatly appreciated, thank you.
     
  29. Offline

    iBstoneyDave

    I regened the config and its identical to the other one, also I changed my passwords lol. The error is still persisting:
    http://pastebin.com/H2R55beA
     
  30. Offline

    Kalman Olah

    I'll see if I can add it. Admins can only promote to below admin, etc. Don't expect it this weekend though, I'm not home :p.

    GroupManager support was removed in favor of Permissions 3.x.x support. If you really want to keep GroupManager, I'll add support back on monday. :)

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

    dscm

    Uhm, I'm new to Bukkit and I think I need some help :rolleyes:

    Im trying to integrate my server with my IPB 3.1 Forum... From what I understand here, user Ranks refers to the User Groups in IPB, correct? So Admin Group ID there is 4, but when I tried to login on my server it just wont let me have Admin rights... but I can use the command /sync and it does sync well.

    Also I am trying to make it work as an authentication like when a User is not registered on the forum but he entered the server, he should be kicked out. I played with the Whitelist settings and I have no idea how to make it work like that.

    Here is my config.yml settings:
    http://pastebin.com/AT4svdgr
     

Share This Page