[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


    I recieved these errors after switching the 1.02 jar against the 1.04 jar:
    At join I get theese erros:
    2012-04-15 20:54:11 [SEVERE] Could not pass event PlayerJoinEvent to CommunityBridge
        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.community.Main.getUserId(Main.java:337)
        at net.netmanagers.community.Main.SyncPlayer(Main.java:496)
        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
    Reverting to 1.02 for so long as it works..
    I am using Vault 1.2.15 and 1.2.5-R1.0.
  2. Offline


    I have posted version 1.05 which should fix those problems and be more explanitive when there is a problem with the database.
  3. Offline


    Keep getting this error, with varying values in place of the member_id.
  4. Offline


    Could anyone make a short guide to use the code for IPB profile fields?
  5. Offline


    Could you provide your config.yml for me to look at?

    Peva : I will post up a zipfile tonight with what you need to do for IPB.
  6. Offline



    Thanks :)
  7. Offline


  8. Offline


    Does it work for Enjin Websites?
  9. Offline


    It should work for any website as i've made the configuration very flexible.
  10. Offline


    Thanks for this great plugin! It is working brilliantly for me.

    Is there anyway to display how many total users are on the server? It would be nice to have this info on the forum index if possible. Thanks for any help!
  11. Offline


    LyfSkills yes you could just do a query on the database, ie: select count(member_id) as online from ipbpfields_content where field12 = 1;

    Then display the result somewhere.
  12. Offline


    Alright, so I'm just trying this out for the fist time, and trying to get thing all setup using PhpBB. Part of the problem is that I may not know all of the proper firleds or tables to use with PhpBB, however I do have my database open and am browsing through tables and fields to pick out the right one.

    So far, I get an error after CommunityBridge loads, telling me "Uknown colum 'field_14'" which sounds right, because there is no field called "field_14" in my phpBB database. I also get a string of severe errors on the server when I try joining to test things out.

    Here's everything the server log shows relating to CommunityBridge

    2012-04-18 17:26:39 [INFO] [CommunityBridge] Enabling CommunityBridge v1.05
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Auto Sync : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Kick Unregistered : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Multi Tables : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Basic Tracking : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Require Avatar : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Min Posts : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Online Status : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Last Online  : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Game Time    : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Total XP      : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Current XP    : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Level        : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Health        : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Life Ticks    : true
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Tracking Wallet        : false
    2012-04-18 17:26:39 [INFO] [CommunityBridge] Enabled
    2012-04-18 17:26:40 [WARNING] [CommunityBridge] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'field_14' in 'where clause'
    2012-04-18 17:26:40 [INFO] [CommunityBridge] Running Auto Sync
    2012-04-18 17:26:40 [INFO] [CommunityBridge] Auto Sync Every: 1200000
    2012-04-18 17:26:52 [INFO] DaJe [/] logged in with entity id 540 at ([world] 76.73089800888647, 58.0, 240.30000001192093)
    2012-04-18 17:26:52 [SEVERE] [CommunityBridge] Broken Sync User ID SQL Query, check your config.yml
    2012-04-18 17:26:53 [SEVERE] java.sql.SQLException: Column 'member_banned' not found.
    2012-04-18 17:26:53 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
    2012-04-18 17:26:53 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
    2012-04-18 17:26:53 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
    2012-04-18 17:26:53 [SEVERE]    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
    2012-04-18 17:26:53 [SEVERE]    at com.mysql.jdbc.ResultSetImpl.findColumn(ResultSetImpl.java:1144)
    2012-04-18 17:26:53 [SEVERE]    at com.mysql.jdbc.ResultSetImpl.getBoolean(ResultSetImpl.java:1761)
    2012-04-18 17:26:53 [SEVERE]    at net.netmanagers.community.Main.SyncPlayer(Main.java:518)
    2012-04-18 17:26:53 [SEVERE]    at net.netmanagers.community.EventListener.onPlayerJoin(EventListener.java:16)
    2012-04-18 17:26:53 [SEVERE]    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    2012-04-18 17:26:53 [SEVERE]    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    2012-04-18 17:26:54 [SEVERE]    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    2012-04-18 17:26:54 [SEVERE]    at java.lang.reflect.Method.invoke(Unknown Source)
    2012-04-18 17:26:54 [SEVERE]    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:301)
    2012-04-18 17:26:54 [SEVERE]    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    2012-04-18 17:26:54 [SEVERE]    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:459)
    2012-04-18 17:26:54 [SEVERE]    at net.minecraft.server.ServerConfigurationManager.c(ServerConfigurationManager.java:132)
    2012-04-18 17:26:54 [SEVERE]    at net.minecraft.server.NetLoginHandler.b(NetLoginHandler.java:129)
    2012-04-18 17:26:54 [SEVERE]    at net.minecraft.server.NetLoginHandler.a(NetLoginHandler.java:41)
    2012-04-18 17:26:54 [SEVERE]    at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:61)
    2012-04-18 17:26:54 [SEVERE]    at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:551)
    2012-04-18 17:26:54 [SEVERE]    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:449)
    2012-04-18 17:26:55 [SEVERE]    at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    2012-04-18 17:26:55 [INFO] [CommunityBridge] Disabling CommunityBridge v1.05
    2012-04-18 17:26:55 [INFO] [CommunityBridge] Disabled...
    I'm not sure where to go from here.
  13. Offline


    The included config is for Invision PowerBoard, Im not familiar with PHPBB however it should be easy to configure so long as you put the right fields in the config.

    I will try post up a sample phpbb config soon.
  14. Offline

    Jamie Tees

    Hey NoRC,

    I have been using Ant59's Warrant for quite some time now, This though will suit me better than warrant does as it has a ton of extra features. Ant59, also is my plugin developer but he has kinda not been around due to college (Just great when you need updates etc...) Anyway. I'm going to switch but can I ask you to add a command?
    A simple /sync command that will sync the user instead of having to relogin as when people register on my server they dont know how to reconnect :s Stupid i know :/

    Anyway, great work and if you want a bit of funding for your plugins im looking for a plugin developer currently (http://jrcraft.net)


    Could you convert this: To your config? (Yes its an Invision power board)

    # Want to use information from a custom profile field instead of the user's forum username?
    multitable: true
    # Want to use a comma seperated list of additional groups to assign your member?
    use-additional-groups: false
    # If we're using phpBB3 or a forum system like it, then it's a pain in the arse to find a user's group! Are we using phpBB3?
    use-group-table: false
    # If you'd like, Warrant can look at if the member's "banned-field" is true or false and keep 'em out if it's true
    use-boolean-ban: false
    # Bung in the info on where to look for the member data
    # Name of the member data table
    name: members
    # Field to find the group id to match those set in the "groups" section of this file
    group-field: member_group_id
    # If we're not using multitable mode, then which field should we look for the member's minecraft username in?
    # And if "use-additional-groups" is enabled... where is the comma seperated list of additional groups?
    additional-groups-field: additional_groups
    # Has a player been banned? If "use-boolean-ban" is true, this field will be used to determine if the user can come in or not. OVERRIDES WHITELIST!
    # If "use-additional-groups" is on, then we're going to need a way to link this user to their extra profile fields
    key-field: member_id
    # This part ONLY counts if you've used 'multitable'. Make sure to match the key-fields up!
    # Name of the custom profile fields table
    name: pfields_content
    # If we're going to match up the custom fields to the user's member data, then we're going to need this to match the "key-field" in the other table for each member
    key-field: member_id
    # Since we're in multitable mode, we can have a look in this table for their minecraft name instead. Clever isn't it?
    minecraft-name-field: field_15
    # This ONLY applies if you want to use a phpBB3 style group table
    name: phpbb_user_group
    key-field: user_id
    group-field: group_id

    # Stick your database info here
    host: '****'
    port: '3306'
    db: '****'
    user: '****'
    pass: '****'
    # Which worlds on your server should Warrant affect the permissions for?
    - Survival
    - Survival_nether
    - Survival_the_end
    - VIP
    - Creative
    - PVP

    # What you gonna tell peeps that aren't whitelisted? (PS, telling them to go and register on the forum would be a good idea. Telling them to #"@! off, would not)
    kick-message: 'Sorry, you are not permitted to login to the server at your current rank'
    # What you gonna tell peeps that are banned by your forum? (Telling these guys to #"@! off may actually be a good idea lol)
    banned-message: 'Sorry, you are not permitted to login to the server as you are banned'
    # Tell players that they've been assigned ranks when they login, or just do it silently in the background?
    notify-group-on-login: true
    # Keep out those who aren't in any group stated below (false), or shall we let them in and assign them to their default permissions group (true)?
    whitelist-default: true
    # Stick all the mappings here for any groups you wish tp be auto-ranked
    # Make sure to surround the number in single quotes (''), else it may just self-destruct and noone wants that
    # If "whitelisted" is false, then you may ommit the rank, as there will be no need to assign a rank to disallowed players
    default-group: Tourist
    # Here, normal registered members can go ahead and just join in as normal members
    rank: Citizen
    whitelisted: true
    # Admins are instantly granted all there rights as found in the Permissions configuration
    rank: Tourist
    whitelisted: true
    rank: Admin
    whitelisted: true
    rank: Admin
    whitelisted: true
    rank: Owner
    whitelisted: true
    rank: Moderator
    whitelisted: true
    rank: Moderator
    whitelisted: true
    rank: Moderator
    whitelisted: true
    rank: Founder
    whitelisted: true
    rank: Helper
    whitelisted: true
    rank: GriefP
    whitelisted: true
    rank: MCBlockIT
    whitelisted: true
    rank: Gold
    whitelisted: true
    rank: Citizen
    whitelisted: true
    rank: Banned
    whitelisted: false

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


    Is there a way for this to work with vBulletin4.1?
  16. Offline


    Well, it's mostly configurable, but it's leaving me stuck at a few places

    Such as where it says
      # The Banned Field should be a 1 or 0 
      banned-field: member_banned
    However, this is under the users table, which in phpBB by default is phpbb_users. However, in phpBB, I do not believe the ban information is actually stored in the same table as user data (or I may be wrong). I simply cannot find a field in that table which seems to properly identify a banned user.
  17. Offline


    Daje I am doing some updates to the plugin this weekend, when I do it I will check phpbb's structure and add what ever is needed for it to work.

    segamarius see comment above, however will check what VBulletin requires.
    Daje likes this.
  18. Offline

    Jamie Tees

    NoRC could you please convert my config or help me as your config somewhat confuses me at: # Forums like XenForo use a table that has rows for each custom field as opposed to columns for each custom field
    multi-tables-use-key: false
  19. Offline


    so where does the script go in your website
  20. Offline


    I entered my hosts CNAME in the db-host field but in the console it reverts back to my local IP for some reason. Not sure why. If I enter 2083 (my host uses for PHPMyAdmin instead of 3306 it goes to the hosts IP not mine). Weird. Neither work as of right now.
  21. Offline


    Can you post a example config for Mybb, as im not sure what it should look like.
  22. Offline

    Jamie Tees

    Right I got it working, but anyway to show the offline and online part better on IPB instead of just a 1 and a 0
  23. Offline


    If i was to change someone's permissions on the Minecraft server & it synced would the user be changed back to the forum's group or does the forum comply? as we run a Premium Member option.

    e.g: User 1 buys Premium (Gets Premium group), on the forums Premium Group is there, but user is still seen as Member, will the user be synced as Member or will it change the forums group for this user?
  24. Offline


    I know the autor could have many requests for suporting diferent scripts and cms types ..but i just can't figure it out ..so anybody that can help me is very welcome.
    My question is - is there a way to link this plugin with phpfusion ? ..I just hate cms systems, usualy i write the code myself, but now i am starting a bigger project and phpfusion just looks the most friendly and lightweight for me, so i would like to stay with that, and i think many users would like to use this cms as well.
    I just don't know ..should i link in the config to the phpfusion db, if yes to with table(s)? ..or a separate db/table?
    I am fairly new to minecraft scripting so forgive me :) ..and i hope i didn't make to much mistakes in my english.

    I would be very gratefull if i get some solution for my isue
  25. NoRC
    2012-04-23 22:28:09 [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:473)
        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.Main.getGroup(Main.java:495)
        at net.netmanagers.community.Cmds.onCommand(Cmds.java:76)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        ... 14 more
    Running CommunityBridge 1.05, Vault 1.2.15 and 1.2.5-R1.0.
    Using XenForo with secondary_groups

    This happens when i try to do /cbrank <player> <rank>
  26. 1. Thank you. I saw this on a server on another sandbox game, and it was my dream to get a mod like this, but I could never find one until now.

    2. Would this work with http://www.webs.com ? Based on the assumption that it does where would I put the code?
  27. Offline



    Can you make xenforo register the other way too? You have to first log in game one time before you can create a forum account? I have seen it on a few xenforo sites.

    Please correct the following errors:
    Username must be your Minecraft username. Have you (MCPvPgh0st) visited our SMP server atleast once? Is the spelling correct (case-sensitive)?

  28. Offline



    Please support

    Is there a way for this to work with Burning Board Lite 2.1
  29. Offline


    I dont think so, I could not see on their website that they offer Remote MySQL Connections which you need to get it to work with this plugin.

    I'm pretty sure it will work, try it yourself. Just make sure your website host supports remote mysql connetions, and then open your mysql database with phpmyadmin or similar and fill in the information required by the CommunityBridge config.

    Yeah, I'm wondering the very same thing NoRC :)
  30. Offline


    Please Help

    I have e root server

    Does anyone have a config for me it does not get out

    Sorry for my English

Share This Page