[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


    How do you check if your un-locally hosted MySQL server allows remove IPs?
  2. Offline


    Okay my connection to my MySQL server isnt working again :/
  3. Offline


    Is there anyway for ranks to update when the player changes worlds? We use Multiverse on my server and we're constantly adding new worlds, and when you first join you must log out and back in to get your rank otherwise you are just default. Sync while teleporting/changing worlds would be a great feat!
  4. Offline


    JavaChips have you found a fix to this problem with PEX?
  5. Offline


    I did... the issue was with ranks... rather the lack of them.

    I learned that a higher priority rank will list it's rank first in the player groups. Not im lurking the minecraft forums helping others with their pex set ups xD
  6. Offline


    Hmm okay, yea my problem is that they get put in the ranks but it will always show them as a member like this;

    [INFO] [CommunityBridge] Added PlayerName to group Obsidian
    [INFO] [CommunityBridge] PlayerName linked to Community User #5, Group: Member

    So when they type in chat for example they will have the member prefix not the Obsidian member one :(
  7. Offline


    The only thing I can think of is your ranks being out of order.

    Rank 1 or 100 should be the owner / admin
    Guest should be the highest number.


    rank: '500'
    rank: '400'
  8. Offline


    Try and establish a connection to it using a MySQL Client program. That will let you know if it allows remote connections or not. Most times you need to actually add the remote IP to the allowed remote hosts. I know CPanel has an option for this.
  9. Offline


  10. Offline


    I have big problem on my server unregistred players are kicked before they join can you fix this ?
  11. Offline


    JavaChips NoRC
    My ranks are layed out like this...

    default - 1000
    Member - 900
    Iron - 800
    Gold - 700
    Diamond - 600
    Obsidian - 500
    Moderator - 400
    Admin - 300
    SuperAdmin - 200
    Owner - 100

    Still only showing people being part of Member, even though their Secondary group in Xenforo is set to ranks higher then Member...
  12. Offline


    Upon a user exiting the game, CommunityBridge will write every single field for the given user in the table xf_user_field_value with a string, for example when I just exited it printed: "1340641559"

    People can get verified just fine, the problem is just with logging out...
    (I have created the custom fields in XenForo)

    Here is my config for XenForo:


    EDIT: Also, it appears XenForo or CB only generated the fields for one user. Take a look:

  13. Offline


    Why do you guys have no tutorials? Im so confused on what to do lol

    I got the plugin in my plugins folder THAT'S IT
    How do i sync it to my forums?
    It'd be nice to go into detail
  14. Offline


    The instructions are in the config file itself. If you do not see it, delete the CommunityBridge folder that has the config in it and restart your server.

    Once the folder and file have been created again open the /plugins/CommunityBridge/config.yml and read it.
  15. Offline


    Installed CommunityBridge today, using it for xenforo. It doesn't seem to work tho, each time a player connects I get this error:

    Server Log (open)

    2012-06-27 21:27:14 [INFO] [PLAYERNAME] [/] logged in with entity id 2040 at ([world1] 110.94469432676779, 42.0, 569.5114408956243)
    2012-06-27 21:27:15 [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 null = 'null' AND null = ' [PLAYERNAME]' order by null desc' at line 1
    2012-06-27 21:27:15 [SEVERE] Could not pass event PlayerJoinEvent to CommunityBridge
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:304)
    at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:62)
    at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:460)
    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:567)
    at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:459)
    at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    Caused by: java.lang.NullPointerException
    at net.netmanagers.community.Main.getUserId(Main.java:389)
    at net.netmanagers.community.Main.SyncPlayer(Main.java:561)
    at net.netmanagers.community.EventListener.onPlayerJoin(EventListener.java:16)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:616)
    at org.bukkit.plugin.java.JavaPluginLoader$1.execute(JavaPluginLoader.java:302)
    ... 9 more

    Any ideas?
  16. Offline


    Thank you :)
    Can you help me with the custom fields for tracking?
    Where and how to add this one?
  17. Offline


    Are there any plans to add support for PermissionsBukkit? From what I can see, there's currently no way to get it done using that system.
  18. Hi I've got some errors.

    00:23:21 [INFO] [CommunityBridge] Enabling CommunityBridge v1.07
    00:23:21 [INFO] [CommunityBridge] Error loading config
    00:23:21 [SEVERE] Error occurred while enabling CommunityBridge v1.07 (Is it up to date?)
            at net.netmanagers.community.Main.onEnable(Main.java:152)
            at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)
            at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:337)
            at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
            at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:256)
            at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:238)
            at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:552)
            at org.bukkit.Bukkit.reload(Bukkit.java:182)
            at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
            at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:166)
            at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:479)
            at org.bukkit.craftbukkit.CraftServer.dispatchServerCommand(CraftServer.java:475)
            at net.minecraft.server.MinecraftServer.b(MinecraftServer.java:612)
            at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:581)
            at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:459)
            at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)

    Can somebody help me?
    I use IP Board
  19. Offline


    Got this to work, but the results are odd
    Shouldn't this be more.... Readable?
  20. NoRC
    is it possible to get the source code?
  21. Offline


    "On Minecraft" is a boolean value, "Last died" is seconds since last death, "Last time online" is the last time they were online in UNIX time (seconds since epoch). Everything else is as-is. It's up to you to format it the way you want.
  22. Offline


    i got field_14 erroers

    Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown column 'field_14' in 'where clause'
  23. Offline


    How do I format anything?
  24. Offline


    For the "last online", there's a -lot- of methods for different languages here: http://www.epochconverter.com/
    For "On Minecraft", in pseudocode, just do somthing like:
    if OnMinecraft == 1:
      User is online
      User is offline
    I only know how to do somthing like that for xenforo; if you don't have XF, you'll need to figure it how to do it on your own individual forums. Last Death is simple enough to do on your own.
  25. Offline


    I have XenForo :p I will look into this, thanks, by the way, is there any way for the plug-in to detect changes in the MySQL database so it will automatically change their rank? And if someone get put into a secondary group will it overwrite thier primary
    User is in primary group 1
    He get a user upgrade to be in secondary group 1
    Will he be in 1+2 or just 2?
  26. Offline


    For the changes, you could look into a CRON (not sure how those work with things like that)
    For the user groups, I believe this plugin only alters PRIMARY groups (which is generally a bad idea, you should always leave primary and modify secondary groups)
  27. Offline


    Does this work with enjin?
  28. Offline


  29. Offline


    Alright, this can be done by default, for example I have that set up for donations. Here is how it works:
    First off, terminology:
    A number to determine the priority of a group, for example: '500'
    A status a player has in the server for example group 'Guest'
    As long as you are using a permissions plugin that supports ranks this should all work. For my examples I will be using PEX, XenForo, MySQL, and CommunityBridge.

    First thing is your ranks, you want to have any priority rank to be listed before lower ranks. Thsi is done automaticlly by PEX...
          rank: '400'
          rank: '300'
    This is made to tell what rank should be listed first and thus used first if more then one rank is listed for a single user (secondary group). In the example above a user with the group Member has a higher rank then Guest.
    Ranks look at the number closest to 1 at the higher rank, think of it as first, second, and third, place. First place is the best and third is the worst. So the lower the number the worse it is, in our case, the lower number shows the lower ranks.

    Second, set up your Secondary groups on XenForo, this can be done any number of ways or by simply viewing a users profile from the admin portal and selecting a secondary group.
    User: Timmy
    Primary Group: Guest (remember this rank is 300)
    Secondary Group: Member (remember this rank is 400)

    Third, Connect the proper secondary group database table in the config.yml of your Community Bridge

    Once community bridge reads the database your permissions file will then look like this:

          - Member
          - Guest
    This happens because member is a higher rank and will get listed first. In turn the permissions for Member will be used then any permissions not covered will travel down to guest, so on and so forth.

    Note: If you allow one permission in one group and not another, the permission with the highest rank will be used first and be ignored in the lower rank.

  30. Offline


    So it would be possible to do this:
    Rank 1
    Donor 1
    Provided I set those ranks in Xenforo

    Also is there any way for it to do ranks the opposite, take ranks from PEX and put them into Xenforo. What I want to do is whitelist the server to where all you do is sign up and you are added, then in-game you can do quests, get a rankup in PEX and have it change on the forums automaticly, but also be able to buy user upgrades on Xenforo and apply them to PEX


    XenForo: Say if user is whitelisted (Whitelisted by registering), sets secondary groups but leaves primary groups alone unless PEX changes it

    PEX: Leave secondary groups alone but defines primary groups for the server and XenForo

    This way people can get whitelisted on the server and buy upgrades (Secondary Groups for PEX and Xenforo) on Xenforo, and get their primary groups through quests on the server.

Share This Page