[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

    convictedsaint

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

    JJoHH

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

    bocaj812

    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

    Tommo1590

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

    JavaChips

    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

    Tommo1590

    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

    JavaChips

    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.

    Exmple

    Member:
    option:
    rank: '500'
    Obsidian:
    option:
    rank: '400'
     
  8. Offline

    NoRC

    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

    convictedsaint

  10. Offline

    ApooPL

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

    Tommo1590

    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

    Nolam

    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:

    http://pastebin.com/UtfDezkh

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

    [​IMG]
     
  13. Offline

    Ewraith

    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

    JavaChips

    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

    DonutSeller

    Hello!
    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] [/178.155.216.199:55105] 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
    org.bukkit.event.EventException
    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

    schatty


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

    JonasQ

    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.

    Code:
    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?)
    java.lang.NullPointerException
            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

    RiotShielder

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

    JonasQ

    "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

    Si2100

    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

    RiotShielder

    How do I format anything?
     
  24. Offline

    JonasQ

    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:
    Code:
    if OnMinecraft == 1:
      User is online
    else:
      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

    RiotShielder

    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
    IE
    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

    JonasQ

    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

    King_KYl3

    Does this work with enjin?
     
  28. Offline

    RiotShielder

  29. Offline

    JavaChips

    Alright, this can be done by default, for example I have that set up for donations. Here is how it works:
    First off, terminology:
    Rank:
    A number to determine the priority of a group, for example: '500'
    group:
    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...
    Example:
    Code:
    group:
      Guest
        options:
          rank: '400'
      Member:
        options:
          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.
    Note:
    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.
    Example:
    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:

    Code:
    Users:
      Timmy
        Group:
          - 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.

    Cheers,
    Java
     
  30. Offline

    RiotShielder

    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

    IE

    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