[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

    cyberjacob

    Pure epicness in a jar Kalman.
    Would you be able to take a look at expanding multi-table support, so I can have the ability to have 3 different tables for the different options, and a separate field for user banning?
    thanks!

    Oh, and PM me if you want a thanks sign on our server

    all-right, scratch my last post. it doesn't work

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

    Raveinacave

    Im running on normal mode not secure so no passwords and it does have full remote access i checked
     
  4. Offline

    cyberjacob

    I think I'm doing something wrong here. I have this config:
    Code:
    modes:
      normal:
        user-table: ocp_f_member_custom_fields
        minecraft-login-name-field: field_3
        rank-id-field: m_primary_group
        multitable:
          enable-multiple-tables: 'true'
          second-table: ocp_f_members
          user-id-field-in-user-table: mf_member_id
          user-id-field-in-second-table: id
    
    but I'm getting an error from one of the SQL querys:
    Error at SQL Query: Unknown column 'ocp_f_members.field_3' in 'where clause
     
  5. Offline

    DragonSupremacy

    Fixed that portion, thanks :)
     
  6. Offline

    Kalman Olah

    Change it to
    Code:
    modes:
      normal:
        user-table: ocp_f_members
        minecraft-login-name-field: field_3
        rank-id-field: m_primary_group
        multitable:
          enable-multiple-tables: 'true'
          second-table: ocp_f_member_custom_fields
          user-id-field-in-user-table: id
          user-id-field-in-second-table: mf_member_id
    
    Not sure about the id fields at the bottom, but you get the point.
     
  7. Offline

    cyberjacob

    you appear to have left out the syntax for the worship command in the documentation Kalman.
    I'm assuming it's /worship <UserName> am I right?
    also, what do you think about my other question/suggestions?
    thanks
     
  8. Offline

    Kalman Olah

    Code:
    Pure epicness in a jar Kalman.
    Would you be able to take a look at expanding multi-table support, so I can have the ability to have 3 different tables for the different options, and a separate field for user banning?
    thanks!
    Most forums can be configured to have a designated rank be the "banned" rank, and 99% of forums handle everything in 1-2 tables.
    The core feature of OKB3 is assigning a permissions group based on a forum rank, and as long as that works for everyone I am fine with an optional feature not catering to the 1% of users using a strange forum setup.
    Right now all extra features work for most forums. If I were to add forum-specific support to all of these features, I'd be looking at setting up about 13 forums to see how nicknames, banning, post counts, etc... work with them. As long as the OKB3 core works for these forums, I don't see the need to do any of that.
     
  9. Offline

    SS94

    Alright, but one other thing, what is the "minecraft-login-name-field" usually as in the sql?
     
  10. Offline

    Kalman Olah

    You could make it a forum profile field, or just the username field. If the latter, people have to register on the forums with their exact minecraft usernames to get their ingame ranks.
     
  11. Offline

    SS94

    Okay put It as the username field which in this case in my mysql is "username" It seems to update the ranks but I get these in the log:

    Code:
    25.10 21:01:36 [Server] SEVERE     at java.lang.Thread.run(Thread.java:662)
    25.10 21:01:36 [Server] SEVERE     at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:127)
    25.10 21:01:36 [Server] SEVERE     at me.kalmanolah.okb3.OKFunctions.updatePosts(OKFunctions.java:535)
    25.10 21:01:36 [Server] SEVERE     at me.kalmanolah.okb3.OKFunctions.GetMySQLPosts(OKFunctions.java:514)
    25.10 21:01:36 [Server] SEVERE java.lang.NullPointerException
    25.10 21:01:36 [Exception] Exception in thread "Thread-424"
    25.10 21:01:36 [Exception] Server exception, restarting if server doesn't respond
    25.10 21:01:36 [Server] WARNING [OKB3] Error at SQL Query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table FROM xf_user WHERE username = 'SS94_'' at line 1
    25.10 21:01:36 [Server] INFO [OKB3] [SYNC] SS94_'s ranks successfully updated.
    25.10 21:01:36 [Server] INFO [bPermissions] Group:Server Owner removed from player:SS94_ in world:worldsurvival
    25.10 21:01:36 [Server] INFO [bPermissions] Group:Survival could not be added to player:SS94_ in world:worldsurvival as the player already has this group
    25.10 21:01:36 [Multicraft] SS94_ ran command Message of the Day
     
  12. Offline

    Kalman Olah

    Post your full config again.
     
  13. Offline

    SS94

    here:

    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: 'true'
      enable-anonymous-stat-tracking: 'true'
    modes:
      normal:
        user-table: xf_user
        minecraft-login-name-field: username
        rank-id-field: user_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
      secure:
        forum: xenforo
        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: 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
        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: ***********.db.********.************.com
      mysql-user: **********
      mysql-password: *********
      mysql-database-name: *********
    group-mapping:
      default:
        '1': ExampleGroup1
        '2': ExampleGroup2
      worlds:
        world:
          '1': Guest
          '2': Guest
          '5': VIP
          '6': VIP+
          '7': Premium
        world_nether:
          '1': Guest
          '2': Guest
          '5': VIP
          '6': VIP+
          '7': Premium
        worldsurvival:
          '1': Survival Guest
          '2': Survival
          '5': VIP
          '6': VIP+
          '7': Premium
        worldfreebuild:
          '1': Free-Build Guest
          '2': Free-Build
          '5': VIP
          '6': VIP+
          '7': Premium
    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: '2'
    
     
  14. Offline

    Matt G

    I am still getting this error.

    Is there any way to fix it.

    Sorry

    Code:
    [WARNING] [OKB3] Error at SQL Query: No operations allowed after connection closed.Connection was implicitly closed by the driver.
    21:22:47 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'sync' in plugin OKB3 v3.0.3
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:41)
    at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:163)
    at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:353)
    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 org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:500)
    at net.minecraft.server.NetworkListenThread.a(SourceFile:108)
    at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:464)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
    Caused by: java.lang.NullPointerException
    at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFunctions.java:194)
    at me.kalmanolah.okb3.OKFunctions.updateNormal(OKFunctions.java:238)
    at me.kalmanolah.okb3.OKCmd.onCommand(OKCmd.java:114)
    at org.bukkit.command.PluginCommand.execute(PluginCommand.java:39)
    ... 13 more
     
  15. Offline

    McEvan

    Hello, Where could I find the info on these fields ? I'am using vBulletin. Thank you.

    modes:
    normal:
    user-table: mybb_users
    minecraft-login-name-field: field5
    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
     
  16. Offline

    ScarHunter

    Hey, Hope you can help me...
    Code:
    19:24:42 [WARNING] [OKB3] Error at SQL Query: Unknown column 'phpbb_profile_fiel
    ds_data.username' in 'where clause'
    19:24:42 [SEVERE] Exception in thread "Thread-402"
    19:24:42 [SEVERE] java.lang.NullPointerException
    19:24:42 [SEVERE]       at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFuncti
    ons.java:194)
    19:24:42 [SEVERE]       at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:48)
    
    19:24:42 [SEVERE]       at java.lang.Thread.run(Unknown Source)
    19:24:45 [INFO] Connection reset
    19:24:45 [SEVERE] java.net.SocketException: Socket closed
    19:24:45 [INFO] sexualgrapefruit lost connection: disconnect.overflow
    19:24:45 [SEVERE]       at java.net.SocketOutputStream.socketWrite(Unknown Sourc
    e)
    19:24:45 [SEVERE]       at java.net.SocketOutputStream.write(Unknown Source)
    19:24:45 [SEVERE]       at java.io.BufferedOutputStream.flushBuffer(Unknown Sour
    ce)
    19:24:45 [SEVERE]       at java.io.BufferedOutputStream.flush(Unknown Source)
    19:24:45 [SEVERE]       at java.io.DataOutputStream.flush(Unknown Source)
    19:24:45 [SEVERE]       at net.minecraft.server.NetworkWriterThread.run(SourceFi
    le:104)
    19:24:45 [WARNING] Can't keep up! Did the system time change, or is the server o
    verloaded?
    19:24:47 [INFO] [PLAYER_COMMAND] ScarHunter: /tpall
    19:24:59 [INFO] sexualgrapefruit [/24.63.192.166:60800] logged in with entity id
     1984 at ([world_nether] 1.9653423062016504, 83.0, 13.280676744962548)
    19:24:59 [INFO] sexualgrapefruit joined with mod_BuildCraftCore 2.2.1, mod_Build
    CraftBuilders 2.2.1, mod_BuildCraftEnergy 2.2.1, mod_BuildCraftFactory 2.2.1, mo
    d_BuildCraftTransport 2.2.1
    19:24:59 [INFO] sexualgrapefruit joined with mod_BuildCraftCore 2.2.1, mod_Build
    CraftBuilders 2.2.1, mod_BuildCraftEnergy 2.2.1, mod_BuildCraftFactory 2.2.1, mo
    d_BuildCraftTransport 2.2.1
    19:25:00 [WARNING] [OKB3] Error at SQL Query: Unknown column 'phpbb_profile_fiel
    ds_data.username' in 'where clause'
    19:25:00 [SEVERE] Exception in thread "Thread-442"
    19:25:00 [SEVERE] java.lang.NullPointerException
    19:25:00 [SEVERE]       at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFuncti
    ons.java:194)
    19:25:00 [SEVERE]       at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:48)
    
    19:25:00 [SEVERE]       at java.lang.Thread.run(Unknown Source)
    19:25:08 [INFO] ScarHunter lost connection: disconnect.quitting
    19:25:08 [INFO] Connection reset
    >restart
    19:28:05 [INFO] Unknown command. Type "help" for help.
    19:28:19 [WARNING] [OKB3] Error at SQL Query: Unknown column 'phpbb_profile_fiel
    ds_data.username' in 'where clause'
    19:28:19 [SEVERE] Exception in thread "Thread-842"
    19:28:19 [SEVERE] java.lang.NullPointerException
    19:28:19 [SEVERE]       at me.kalmanolah.okb3.OKFunctions.getRankNormal(OKFuncti
    ons.java:194)
    19:28:19 [SEVERE]       at me.kalmanolah.okb3.OKRunnable.run(OKRunnable.java:139
    )
    19:28:19 [SEVERE]       at java.lang.Thread.run(Unknown Source)
    >
    I keep getting this error while trying to use mutiable tables. This is my config.
    Code:
    modes:
      normal:
        user-table: phpbb_users
        minecraft-login-name-field: username
        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
    Hope you can help
     
  17. Offline

    chaseoes

  18. Offline

    microskies

    http://pastie.org/2763497

    I get that whenever a user tries to sync (obviously - it says in the log) it also says the the player "an Internal error occurred.." or something along those lines

    /fsync ing myself says that i have no saved details.

    bukkit 1337
    OKB3 3.2.3

    I cant give more info atm, but for now im a lil busy, ill be back later :D
     
  19. Offline

    Kalman Olah

    You don't have your passgen.php config file set up correctly. Either that, or you didn't fill in the correct location in the config file. Post both config files.

    Got another plugin out. Feel free to check it out and give feedback :).
    http://dev.bukkit.org/server-mods/kalmanolah-oklogintiers/

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

    microskies

    Some reaosn it was just a one time thing, resolved after a server reload. Thanks anyway :D
     
  21. Offline

    Unforted

    I think I'm getting the same problem as microskies

    Whenever I try to sync players, it comes up with:

    Error: Player '*****' has no saved login details.
    Or: an internal error occured.
    Help would be much appreciated.
     
  22. Offline

    microskies

    Okay, this is good that someone else is getting the same problem, as the problem has just reappeared :(

    Give me a moment to get both my configs up :)

    EDIT: Oh you know what, I got rid of my "forum.wincraftmc.net" subdomain, so it wasn't the correct link - passed over that assuming it was correct :/ Sorry, I keep causing you problems XD
     
  23. Offline

    Kalman Olah

    post your configuration file and passgen config.
     
  24. Offline

    Unforted

  25. Offline

    Kalman Olah

  26. Offline

    Unforted

  27. Offline

    Kalman Olah

    Your MySQL host, both in your config.inc.php and config.yml should be the IP Address or hostname of your MySQL server, with or without a port.
     
  28. Offline

    Bobsqeezeorg

    Is there anyway you could setup a node for the /sync command because I dont want my donators to type /sync because they followed the instructions on my website and then get demoted because of it.
     
  29. Offline

    McEvan

    Hello, Where could I find the user table for vbulletin ?

    Eg. user-table: mybb_users

    Thank you.
     
  30. Offline

    Kalman Olah

    Can't you just map their forum rank to the donor permissions rank?
     
  31. Offline

    robxu9

    Hm, having a problem.
    So for linking to SMF I have them request membership to additional membergroups.
    But if they're a member of multiple ones I end up getting this:


    In MySQL. Can OKB3 parse those to be two seperate numbers (and therefore, the member gets two permission groups?)
     

Share This Page