[ADMN/WEB] CommunityBridge v1.10 BETA - Integrates Players with MySQL + Stat Tracking [1.6.4]

Discussion in 'Inactive/Unsupported Plugins' started by NoRC, Apr 6, 2012.

  1. Offline

    Canadian_KO

    I'm really looking forward to the phpBB sample.. I'm having some trouble. Please post one. :)
     
    Daje likes this.
  2. Offline

    NoMansLand

    I have this working fine, but I am getting this error for IP.Board 3:

    Last Seen: 1335403426
    • Game Time
      549
    Conf File:
     
  3. Offline

    Spadow

    NoRC
    So is it compatible with Burning Board now?
    It was the best software 2011... I dont know why its not here yet :D
     
  4. Offline

    NoRC

    Thats actually correct... I use seconds for gametime, and timestamps for last seen. I posted a link on my original post to my template file for IP3 which basicly detects and formats those fields on output.

    As for the others, sorry been a hectic week with work will get to all your questions this weekend and hopefully an updated release.
     
  5. Offline

    NoMansLand

    Yeah, I'm working on that, would you be able to make it so it doesnt sync permissions? like:


    sync-perms:true because this plugin does everything I want BUT it syncs permissions & throws them out of whack
     
  6. Offline

    Daje

    No worries. Don't let other things get in the way of your personal life, and take care of what you need to. Just let us know when you have something :)
     
  7. Offline

    Infuscu

    My host is down, then I receive the following error which prevents the server from starting.

    Code:
    2012-04-28 22:01:49 [WARNING] [CommunityBridge] SQLException! Communications link failure
     
    The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    2012-04-28 22:01:49 [SEVERE]    at sun.net.www.protocol.http.HttpURLConnection.connect(Unknown Source)
    2012-04-28 22:01:49 [SEVERE] Could not pass event PlayerJoinEvent to CommunityBridge
    org.bukkit.event.EventException
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303)
        at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
        at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:459)
        at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:132)
        at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:129)
        at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:41)
        at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:449)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    Caused by: java.lang.NullPointerException
        at net.netmanagers.api.DatabaseHandler.sqlQuery(DatabaseHandler.java:108)
        at net.netmanagers.api.SQL.sqlQuery(SQL.java:29)
        at net.netmanagers.community.Main.getUserId(Main.java:350)
        at net.netmanagers.community.Main.SyncPlayer(Main.java:511)
        at net.netmanagers.community.EventListener.onPlayerJoin(EventListener.java:16)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301)
        ... 9 more
    2012-04-28 22:01:49 [SEVERE]    at com.blockpark.xenforo.RegisterNameRunnable.run(RegisterNameRunnable.java:26)
    2012-04-28 22:01:49 [SEVERE]    at org.bukkit.craftbukkit.scheduler.CraftWorker.run(CraftWorker.java:34)
    2012-04-28 22:01:49 [SEVERE]    at java.lang.Thread.run(Unknown Source)
    2012-04-28 22:01:50 [INFO] Infuscu lost connection: disconnect.endOfStream
    2012-04-28 22:01:50 [INFO] /94.231.109.47:53153 lost connection
    2012-04-28 22:01:50 [INFO] /86.60.134.101:49899 lost connection
    2012-04-28 22:01:50 [INFO] /87.60.138.93:56656 lost connection
    2012-04-28 22:01:50 [INFO] /50.23.30.168:49612 lost connection
    2012-04-28 22:01:50 [INFO] /87.60.138.93:56680 lost connection
    2012-04-28 22:01:50 [INFO] /50.23.30.168:53021 lost connection
    2012-04-28 22:01:50 [INFO] /87.60.138.93:56719 lost connection
     
  8. Offline

    frankrd3

    Hi, I'm a bit confused. But first I'm getting this error:
    Also i'm lost on what to do on my IP.Board.
     
  9. Offline

    NoMansLand

    Your error is pretty easy to see what's wrong.

    >02:38:55 [WARNING] [CommunityBridge] Error at SQL Query: Table 'web2458.ipbog3pfields_content' doesn't exist

    The item that is in bold is what's wrong, that doesn't exist. You need to edit your config.yml and replace ipbog3pfields_content with your IP.Board 3 pfield_content which could be: pfield_content.

    NoRC Can you add in a config option that doesn't force it to sync up the permission groups? like: "sync-permissions: false" this plugin does what I need but it messes with my permission setup

    Thanks,

    NoMansLand
     
  10. Offline

    imatas

    Code:
     
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Enabling CommunityBridge v1.05
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Auto Sync : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Kick Unregistered : false
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Multi Tables : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Basic Tracking : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Require Avatar : false
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Min Posts : false
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Online Status : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Last Online  : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Game Time    : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Total XP      : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Current XP    : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Level        : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Health        : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Life Ticks    : true
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Tracking Wallet        : false
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Enabled!
    2012-04-30 22:52:49 [WARNING] [CommunityBridge] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'null SET mconlinestatusvar = 'Offline' WHERE mconlinestatusvar = 'Online'' at line 1
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Running Auto Sync
    2012-04-30 22:52:49 [INFO] [CommunityBridge] Auto Sync Every: 1200000
    Help me please... and also

    Code:
    2012-04-30 23:00:31 [WARNING] [CommunityBridge] 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 'null WHERE username = 'iimatas'' at line 1
    2012-04-30 23:00:31 [INFO] [CommunityBridge] Running Auto Sync
    From what I can see it's always adding two ' and I am unsure how to remove it or what causing this...
     
  11. Offline

    NoRC

    Ok, looks like you have left a configuration option empty... care to post your config?

    Yeh I am adding that for next release... 3 day weekend here this weekend so 1.06 will come out :)

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

    imatas


    Code:
    # 
    # Sample Invision Power Board Config
    db-host: XXXXXXXXXXXXXXXX
    db-port: 3306
    db-database: XXXXXXXXXXXXXXXX
    db-username: XXXXXXXXXXXXXXXX
    db-password: XXXXXXXXXXXXXXXX
    show-config: true
    show-primary-group: true
    kick-unregistered: false
    multi-tables: false
    multi-tables-use-key: false
    use-banned-field: false
    secondary-groups: false
    permissions-system: GroupManager
    auto-sync: true
    auto-sync-every: 10000
    enable-basic-tracking: true
    users-table:
      table: IG_users
      user-name-field: username
      user-id-field: id
      groups-id-field: usergroup
      secondary-groups-id-field: additionalgroups
      banned-field: banned
      banned-users-group: 7
      default-group: 1
    multi-table:
      field-user-id-field: id
      field-key-field: key_str
      field-key-value: username
      field-value-field: username
    profile-requirements:
      require-avatar: false
      require-avatar-message: This server requires players to upload an avatar to their profile.
      require-avatar-table: IG_users
      require-avatar-user-id-field: id
      require-avatar-field: avatar
      require-minposts: false
      require-minposts-message: This server requires players to have a minimum of 3 forum posts.
      require-minposts-count: 0
      require-minposts-table: IG_users
      require-minposts-user-id-field: id
      require-minposts-field: postnum
    basic-tracking:
      table: IG_users
      field-onlinestatus-enabled: true
      field-onlinestatus-valueonline: Online
      field-onlinestatus-valueoffline: Offline
      field-onlinestatus-key-value: mconlinestatusint
      field-onlinestatus-field: mconlinestatusvar
      field-lastonline-enabled: true
      field-lastonline-key-value: mclastonlineint
      field-lastonline-field: mclastonlinevar
      field-gametime-enabled: true
      field-gametime-key-value: mcgametimeint
      field-gametime-field: mcgametimevar
      field-totalxp-enabled: true
      field-totalxp-key-value: mctotalxpint
      field-totalxp-field: mctotalxpvar
      field-currentxp-enabled: true
      field-currentxp-key-value: mccurrentxpint
      field-currentxp-field: mccurrentxpvar
      field-level-enabled: true
      field-level-key-value: mclevelint
      field-level-field: mclevelvar
      field-health-enabled: true
      field-health-key-value: mchealthint
      field-health-field: mchealthvar
      field-lifeticks-enabled: true
      field-lifeticks-key-value: mclifeticksint
      field-lifeticks-field: mclifeticksvar
      field-wallet-enabled: false
      field-wallet-key-value: mcwallet
      field-wallet-field: field_23
    groups:
      '2': Member
      '11': VIP
      '12': Builder
      '14': BuilderVIP
      '3': HeadModerator
      '15': HeadModeratorVIP
      '10': Administrator
      '9': SAdministrator
      '6': HAdministrator
      '4': Owner
    
     
  13. Offline

    Daje

    Looking forward to it!
     
  14. Offline

    NoMansLand

    I cant seem to get it to format, This is my Config:

    Code:
    #
    # Sample Invision Power Board Config
    db-host: ##################
    db-port: 3306
    db-database: ####################
    db-username: #####################
    db-password:#####################
    show-config: true
    show-primary-group: false
    registered-message: Registered Account, Linked to Server Forums
    unregistered-message: Unregistered Account - Please Register at http://forums.myfallen.net for full access
    unregistered-messagereminder: Just a reminder to visit http://forums.myfallen.net and register today!
    kick-unregistered: false
    multi-tables: true
    multi-tables-use-key: false
    use-banned-field: false
    secondary-groups: false
    permissions-system: bPermissions
    auto-sync: true
    auto-sync-every: 1200000
    enable-basic-tracking: true
    users-table:
      table: pfields_content
      user-name-field: field_12
      user-id-field: member_id
      groups-id-field: field_1
      secondary-groups-id-field: field_2
      banned-field: member_banned
      banned-users-group: 5
      default-group: 2
    multi-table:
      table: pfields_content
      field-user-id-field: member_id
      field-key-field: key_str
      field-key-value: mcusername
      field-value-field: field_12
    profile-requirements:
      require-avatar: false
      require-avatar-message: This server requires players to upload an avatar to their profile.
      require-avatar-table: profile_portal
      require-avatar-user-id-field: pp_member_id
      require-avatar-field: pp_main_photo
      require-minposts: false
      require-minposts-message: This server requires players to have a minimum of 3 forum posts.
      require-minposts-count: 3
      require-minposts-table: members
      require-minposts-user-id-field: member_id
      require-minposts-field: posts
    basic-tracking:
      table: fields_content
      field-onlinestatus-enabled: true
      field-onlinestatus-valueonline: Online
      field-onlinestatus-valueoffline: Offline
      field-onlinestatus-key-value: mconlinestatus
      field-onlinestatus-field: field_14
      field-lastonline-enabled: true
      field-lastonline-key-value: mclastonline
      field-lastonline-field: field_15
      field-gametime-enabled: true
      field-gametime-key-value: mcgametime
      field-gametime-field: field_16
      field-totalxp-enabled: true
      field-totalxp-key-value: mctotalxp
      field-totalxp-field: field_17
      field-currentxp-enabled: true
      field-currentxp-key-value: mccurrentxp
      field-currentxp-field: field_18
      field-level-enabled: true
      field-level-key-value: mclevel
      field-level-field: field_19
      field-health-enabled: false
      field-health-key-value: mchealth
      field-health-field: field_20
      field-lifeticks-enabled: false
      field-lifeticks-key-value: mclifeticks
      field-lifeticks-field: field_21
      field-wallet-enabled: false
      field-wallet-key-value: mcwallet
      field-wallet-field: field_23
    groups:
      '1': validating
      '2': guest
      '3': builder
      '6': moderator
      '4': admin
      '5': banned
    
    Code:
    <if test="$f->parsed != ''">
                <span class='row_title'>{$f->raw_data['pf_title']}</span>
                <div class='row_data'>
                        <if test="genericIsArray:|:is_array($f->parsed)">
                                {parse expression="implode( '<br />', $f->parsed )"}
                        <else />
                                <if test="mclastonline:|:$f->raw_data['pf_key'] == 'mclastseen'">
                                        {parse date="$f->parsed" format="long" relative="false"}                 
                                <else />
                                        <if test="mcgametime:|:$f->raw_data['pf_key'] == 'mcgametime'">
                                                <php>
                                                $time = (int) $f->parsed;
                                                $seconds = $time%60;
                                                $mins = floor($time/60)%60;
                                                $hours = floor($time/60/60)%24;
                                                $days = floor($time/60/60/24);
                                                $playtime = "";
                                                if($days>0){
                                                        $playtime .= $days . " Days";
                                                }
                                                if($hours >0){
                                                        if($playtime != '')
                                                                $playtime .= ", ";
                                                        $playtime .= $hours . " Hours";
                                                }
                                                if($mins >0){
                                                        if($playtime != '')
                                                                $playtime .= ", ";
                                                        $playtime .= $mins . " Minutes";
                                                }
                                                if($seconds>0){
                                                        if($playtime != '')
                                                                $playtime .= ", ";
                                                        $playtime .= $seconds . " Seconds";
                                                }
                                                </php>
                                                {$playtime}
                                        <else />
                                                <if test="mcxp:|:$f->raw_data['pf_key'] == 'mcxp'">
                                                        {$f->parsed} XP
                                                <else />
                                                        <if test="mclifeticks:|:$f->raw_data['pf_key'] == 'mclifeticks'">
                                                                <php>
                                                                $ticks = (int) $f->parsed;
                                                                $daysold = sprintf("%.1f", $ticks / 24000);
                                                                </php>
                                                                {$daysold} Days Old
                                                        <else />
                                                                {$f->parsed}
                                                        </if>
                                                </if>
                                        </if>
                                </if>
                        </if>
                </div>
        </if>
    
    Any idea on how to fix this IP.Board Support staff don't like modifications.. so they're no help
     
  15. Offline

    D1G1T4L3CH0

    Hey, great plugin. I have it working for the most part on SMF, but it seems the custom_fields are not working. I've done everything I know to do to fix it but I'm still thinking it's something I'm doing wrong.

    I'm getting this on server reload or load.
    Code:
    "Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 'Server Online = 'false' WHERE Minecraft Server Online = 'true'' at line 1"


    or this (depending on how I setup the config file and the field names.
    Code:
    Unknown column 'MC_Online' in 'where clause'
    I'm guessing the spaces are not good in a field name, but it's really a bummer if you want the field to look nice on the user profile on the forum. Note, in those example errors, i changed the name of the fields in the forum/database and the config file, that's why they are different. I also noticed it has an issue with field names with a minus in them.

    On the old plugin (one this one was born from) thread, the dev asked if he should make a tutorial for smf. as I was about to say "yes, please.", I then realized the thread is old and the plugin wasn't updated for 1.2.5 yet. So probably abandoned. Then I found this plugin. An smf tutorial would be nice, or at least some reference to what tables/fields to use and where to put them in the config file...

    Thanks.
     
  16. Offline

    NoRC

    I feel I should post an update, unfortunately the last two weekends have gone astray and work has interfered with my intentions on adding new features & updating how it works along with giving some assistance to those who needed it.

    Its a long weekend here this weekend and currently my weekend is free so I am really hoping that work does not interfer and I can address the long list questions in this thread.

    Again I appologise for not being able to get to all this sooner, but you know how it goes... You gotta do the paying work before you can do the free work or you don't live.
     
  17. Offline

    D1G1T4L3CH0

    No need to apologize. :p Of course I don't expect any plugin dev to have unlimited time and to get right on whatever it is that's requested. It is after all as you said, free work. It's you giving something back to the community.

    Take your time. And don't forget to enjoy your time off. Thanks for the update. :cool:
     
  18. NoRC BUUU FREE WORK ALL THE TIME WE DEMAND! I keeed :p
     
  19. Offline

    rob1222

    Do I need to fill out my site MySQL, or the one of my server?
     
  20. Offline

    D1G1T4L3CH0

    You put in the forum mysql info, because the plugin needs access to the forum login info.
     
  21. Offline

    rob1222

    I did that.
    When i restart my server, this error pops up
    Code:
    05.05 11:28:02 [Server] INFO ... 12 more
    05.05 11:28:02 [Server] INFO at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
    05.05 11:28:02 [Server] INFO at net.netmanagers.community.Cmds.onCommand(Cmds.java:113)
    05.05 11:28:02 [Server] INFO at net.netmanagers.community.Main.SyncPlayer(Main.java:511)
    05.05 11:28:02 [Server] INFO at net.netmanagers.community.Main.getUserId(Main.java:345)
    05.05 11:28:02 [Server] INFO at net.netmanagers.api.SQL.sqlQuery(SQL.java:29)
    05.05 11:28:02 [Server] INFO at net.netmanagers.api.DatabaseHandler.sqlQuery(DatabaseHandler.java:108)
    05.05 11:28:02 [Server] INFO Caused by: java.lang.NullPointerException
    05.05 11:28:02 [Server] INFO at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:449)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:113)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:34)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:764)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:781)
    05.05 11:28:02 [Server] INFO at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:821)
    05.05 11:28:02 [Server] INFO at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:473)
    05.05 11:28:02 [Server] INFO at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:166)
    05.05 11:28:02 [Server] INFO at org.bukkit.command.PluginCommand.execute(PluginCommand.java:42)
    05.05 11:28:02 [Server] INFO org.bukkit.command.CommandException: Unhandled exception executing command 'cbsync' in plugin CommunityBridge v1.05
    05.05 11:28:02 [Server] SEVERE null
    05.05 11:28:02 [Server] INFO The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    05.05 11:28:02 [Server] WARNING [CommunityBridge] SQLException! Communications link failure
    05.05 11:27:52 [Server] INFO ... 9 more
    05.05 11:27:52 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301)
    05.05 11:27:52 [Server] INFO at java.lang.reflect.Method.invoke(Method.java:601)
    05.05 11:27:52 [Server] INFO at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    05.05 11:27:52 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    05.05 11:27:52 [Server] INFO at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    05.05 11:27:52 [Server] INFO at net.netmanagers.community.EventListener.onPlayerJoin(EventListener.java:16)
    05.05 11:27:52 [Server] INFO at net.netmanagers.community.Main.SyncPlayer(Main.java:511)
    05.05 11:27:52 [Server] INFO at net.netmanagers.community.Main.getUserId(Main.java:345)
    05.05 11:27:52 [Server] INFO at net.netmanagers.api.SQL.sqlQuery(SQL.java:29)
    05.05 11:27:52 [Server] INFO at net.netmanagers.api.DatabaseHandler.sqlQuery(DatabaseHandler.java:108)
    05.05 11:27:52 [Server] INFO Caused by: java.lang.NullPointerException
    05.05 11:27:52 [Server] INFO at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    05.05 11:27:52 [Server] INFO at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:449)
    05.05 11:27:52 [Server] INFO at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
    05.05 11:27:52 [Server] INFO at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61)
    05.05 11:27:52 [Server] INFO at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:41)
    05.05 11:27:52 [Server] INFO at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:129)
    05.05 11:27:52 [Server] INFO at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:132)
    05.05 11:27:52 [Server] INFO at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:459)
    05.05 11:27:52 [Server] INFO at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    05.05 11:27:52 [Server] INFO at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:303)
    05.05 11:27:52 [Server] INFO org.bukkit.event.EventException
    05.05 11:27:52 [Server] SEVERE Could not pass event PlayerJoinEvent to CommunityBridge
    05.05 11:27:52 [Server] INFO The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
    05.05 11:27:52 [Server] WARNING [CommunityBridge] SQLException! Communications link failure
     
  22. Offline

    vistilino

    can you add? SMF?
    simplemachines forum, a open source forum system?
    and support bukkit permissions??

    - vistilino
     
  23. Offline

    Daje

    Do you know if your host allows remote MySQL connections?
     
  24. Offline

    rob1222

    How do I see that?
     
  25. Offline

    Daje

    Your best option for finding out, if you're unsure, is to contact your webhost responsible for the space where your forum is located, and ask them if it's a feature that they allow, and if so, how to enable it, or if they could perhaps enable it for you.
     
  26. Offline

    Funstar

    I got this one:
    Code:
    2012-05-06 09:38:48 [SEVERE] null
    org.bukkit.command.CommandException: Unhandled exception executing command 'cbrank' in plugin CommunityBridge v1.05
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:42)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:166)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:479)
            at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:821)
            at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:781)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:764)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:103)
            at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:34)
            at net.minecraft.server.NetworkManager.b(NetworkManager.java:229)
            at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:113)
            at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:169)
            at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
            at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:449)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    Caused by: java.lang.NullPointerException
            at net.netmanagers.community.Cmds.onCommand(Cmds.java:79)
            at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
            ... 14 more
    
    config.yml is
    Code:
    #
    # Sample Invision Power Board Config
    db-host: localhost
    db-port: 3306
    db-database: XXXXXXXX_db
    db-username: XX_combridge
    db-password: XXXXXXXX
    show-config: true
    show-primary-group: false
    registered-message: Registered Account, Linked to Server Forums
    unregistered-message: Unregistered Account - Please Register at YOURFORUMURL for full access
    unregistered-messagereminder: Just a reminder to visit YOURFORUMURL and register today!
    kick-unregistered: false
    multi-tables: false
    multi-tables-use-key: false
    use-banned-field: false
    secondary-groups: false
    permissions-system: PEX
    auto-sync: true
    auto-sync-every: 1200000
    enable-basic-tracking: false
    users-table:
      table: user
      user-name-field: minecraft_user
      user-id-field: id
      groups-id-field: minecraft_pri_group
      secondary-groups-id-field: minecraft_sec_group
      banned-field: minecraft_ban
      banned-users-group: 0
      default-group: 1
    multi-table:
      table: ipbog3pfields_content
      field-user-id-field: member_id
      field-key-field: key_str
      field-key-value: mcusername
      field-value-field: field_11
    profile-requirements:
      require-avatar: false
      require-avatar-message: This server requires players to upload an avatar to their profile.
      require-avatar-table: user
      require-avatar-user-id-field: id
      require-avatar-field: avatar_name
      require-minposts: false
      require-minposts-message: This server requires players to have a minimum of 3 forum posts.
      require-minposts-count: 3
      require-minposts-table: user
      require-minposts-user-id-field: id
      require-minposts-field: stats_postings
    basic-tracking:
      table: ipbog3pfields_content
      field-onlinestatus-enabled: true
      field-onlinestatus-valueonline: 1
      field-onlinestatus-valueoffline: 0
      field-onlinestatus-key-value: mconlinestatus
      field-onlinestatus-field: field_14
      field-lastonline-enabled: true
      field-lastonline-key-value: mclastonline
      field-lastonline-field: field_15
      field-gametime-enabled: true
      field-gametime-key-value: mcgametime
      field-gametime-field: field_16
      field-totalxp-enabled: true
      field-totalxp-key-value: mctotalxp
      field-totalxp-field: field_18
      field-currentxp-enabled: true
      field-currentxp-key-value: mccurrentxp
      field-currentxp-field: field_17
      field-level-enabled: true
      field-level-key-value: mclevel
      field-level-field: field_19
      field-health-enabled: true
      field-health-key-value: mchealth
      field-health-field: field_20
      field-lifeticks-enabled: true
      field-lifeticks-key-value: mclifeticks
      field-lifeticks-field: field_21
      field-wallet-enabled: false
      field-wallet-key-value: mcwallet
      field-wallet-field: field_23
    groups:
      '1': default
      '2': Spieler
      '3': VIP
      '4': Mod
      '5': Admin
    
     
  27. Offline

    toporek

    Can you add there dump of mysql for basic tracking ?
     
  28. Offline

    grybo101

    This plugin sounds great! Before I test it out, I just want to know if the syncing is done automatically, or if the player can sync themselves. If it's done auto, how long does it generally take to sync the ranks up?
     
  29. Offline

    1madmax1

    auto-sync: true
    auto-sync-every: 1200000 (ms)

    you may give your users the perm to do so but ima would not do so
    easier to let them leave then rejoin to sync to the mysql at that moment
     
  30. Offline

    JavaChips

    First off, I loved forum bridge so naturally I love this plugin.

    I for one am using Xenforo and everything works great.

    NoRC
    There is one problem that I am having though with forum promotions. Due to the way xenforo (and I'm guessing other forums work) the group ID increases with the number of added groups. However this causes an issues when using secondary groups. The higher the number the is written to the permissions file (PEX) first and the lower the number the lower in the list they appear. In my example group ID 9 is 'Member' and group ID 5 is 'Donor' This will result in:

    Code:
    groups:
      '3': Admins
      '4': Moderator
      '7': Donor++
      '6': Donor+
      '5': Donor
      '9': Member
      '1': Guest
    Code:
      PlayerOne:
        group:
        - Member
        - null
      PlayerTwo:
        group:
        - Member
        - Admins
        - Donor++
    Using this formula the PEX plugin can only read the first group the player is in, so even though I have donated and have been placed into the donator group, I still only get member permissions.

    My request is you either contact me with a way to toggle the group ID in the project files or update the plugin to include a toggle to list the group ID number highest to lowest and lowest to highest.

    Cheers,
    Java
     

Share This Page