[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

    paza

    Hi,

    does this plugin rank players to a group using groupmanager so basicly lets say a new person joins and then they go and register on my xenforo website they will automaticly be ranked up to a defined group. does this plugin do this?

    thanks
     
  2. Offline

    JavaChips

    Yes. Once the database and groups section of the config.yml is set correctly when the autosync is run, the users will be automatically put into that group.
     
  3. Offline

    Pim1234

    how to make this work with IP:B 3.3.1? i cannot find the right files to edit in look and feel... :(
     
  4. Offline

    NoRC

    Posted an update on the first page, I wont be supporting this plugin any more or adding new features. When bukkit updates will be the only time it gets updates from here out. Reasons are given in the first post.

    Pim1234: Go to the Admin CP, then click on "Look & Feel" then go to "Manage Skinsets" and edit your skins. You want to edit the "Profile" -> "customfield_Generic" page.

    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="mclastseen:|:$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>
     
  5. Offline

    Pim1234

    thank you, i didn't see that name in the .txt (been looking for the custom_fields_templates) and just as i saw that i didn't read the guide well enough i saw you had already replied. I am sorry for wasting your time.

    EDIT: -_- i can't figure out what to do again :p
    the config, what are those MySQL databases? do i have to fill in the site's?
     
  6. Offline

    thernztrom

    Oh well, sad to hear that :(
    Any chance you'll upload the source, or upload it to github if we'd like to make som changed ourselves? :)

    Thanks!
     
  7. Offline

    1madmax1

    Why Join Them When You Can Beat Them.....
    Don't Give up!!!!!
     
  8. Offline

    MEC666

    i love this plugin i'd hate to see it die. being forumbridge is gone now as well.
     
  9. Offline

    kamakarzy

    can anyone help
    Code:
    2012-05-14 10:08:29 [INFO] [ForumBridge] Loading ForumBridge v1.3.
    2012-05-14 10:08:29 [SEVERE] Error occurred while enabling ForumBridge v1.3 (Is it up to date?): org.bukkit.Bukkit.getOfflinePlayers()[Lorg/bukkit/OfflinePlayer;
    java.lang.NoSuchMethodError: org.bukkit.Bukkit.getOfflinePlayers()[Lorg/bukkit/OfflinePlayer;
        at net.chillercraft.forum.Main.syncAll(Main.java:243)
        at net.chillercraft.forum.Main.onEnable(Main.java:146)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:230)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:1057)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:380)
        at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:200)
        at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:183)
        at org.bukkit.craftbukkit.CraftServer.reload(CraftServer.java:479)
        at org.bukkit.Bukkit.reload(Bukkit.java:188)
        at org.bukkit.command.defaults.ReloadCommand.execute(ReloadCommand.java:22)
        at org.bukkit.command.SimpleCommandMap.dispatch(SimpleCommandMap.java:168)
        at org.bukkit.craftbukkit.CraftServer.dispatchCommand(CraftServer.java:403)
        at net.minecraft.server.NetServerHandler.handleCommand(NetServerHandler.java:791)
        at net.minecraft.server.NetServerHandler.chat(NetServerHandler.java:751)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:739)
        at net.minecraft.server.Packet3Chat.handle(Packet3Chat.java:33)
        at net.minecraft.server.NetworkManager.b(NetworkManager.java:231)
        at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:101)
        at net.minecraft.server.NetworkListenThread.a(NetworkListenThread.java:78)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:543)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:441)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:465)
    it was working fine then i restarted server and got this
     
  10. Offline

    Sh8kezula

    Damnit.. Why does this happen to everything minecraft related. This is what happens when you release software that everyone needs.. You become very popular and ppl start demanding things.

    I was gonna come here asking if its possible to make this plugin not crash the game server when it cant make a connection to the MySQL database..

    Everyone who hosts a server and website needs this kind of plugin. Maybe you should offer some sort of premium to give your self incentive to put up with all the ass holes...

    PS. I have been doing this for almost 2 years now, and this is literally what happens to every single plugin. Charge some money for gods sake. I would gladly pay someone for a product that I know I will still be able to use one month later.
     
  11. Offline

    schatty

    Perhaps one has a phpbb config? thx ;)
     
  12. Offline

    NoRC

    I am going to be doing an update to address the mysql connection problems tonight stay tuned.

    Sh8kezula its just when people invade my other projects and harras for features that dont belong in this plugin plus the amount of actual work my company has undertaken since I released this plugin. Every weekend when I sit down to do some work on it something else comes up.

    Like i said I will patch it for updates of Bukkit, the only reason I released it was for others who needed something similar.

    I would recommend upgrading to the latest CommunityBridge plugin...

    Those are the MySQL Database of your Website. Ensure you have remote mysql access allowed from the IP of your minecraft server.

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

    katoon12

    Any chance of having a SMF sample config? Would like to use this but it seems the support is mostly on IPB and XenForo.
     
  14. Offline

    NoRC

    Sh8kezula you will be happy to know, Version 1.06 is now available for download... i've done some testing and now when MySQL screws up it disables the plugin to prevent any more problems.

    There are a few other small fixes here and there.

    As for SMF katoon12 ... when time permits I will have a look. However you just need to match the config fields to your database structure pretty much.
     
    Fronix likes this.
  15. Offline

    Sh8kezula

    Awesome. Thank you so much for your work. I had actually been fighting all week with my VPS company because my MySQL connection goes down every day at the same time for about 1o minutes and it should not be. Seems both issues have been fixed around the same time. :)

    Anyway.. Thanks again for your updates, and I totally understand putting the public on Ignore. If you post this plugin on Bukkit dev, they can provide a special forum just for ppl to bitch, whine, moan, and groan. :p
     
  16. Offline

    Fronix

    May I ask what upgrades you have done?
     
  17. Offline

    kamakarzy

    i would but does it still work for bukkit 1.1 r4
     
  18. Offline

    Pim1234

    Code:
    12:22:05 [INFO] [CommunityBridge] Enabling CommunityBridge v1.05
    12:22:05 [INFO] [CommunityBridge] Auto Sync : true
    12:22:05 [INFO] [CommunityBridge] Kick Unregistered : false
    12:22:05 [INFO] [CommunityBridge] Multi Tables : true
    12:22:05 [INFO] [CommunityBridge] Basic Tracking : true
    12:22:05 [INFO] [CommunityBridge] Require Avatar : false
    12:22:05 [INFO] [CommunityBridge] Min Posts : false
    12:22:05 [INFO] [CommunityBridge] Tracking Online Status : true
    12:22:05 [INFO] [CommunityBridge] Tracking Last Online   : true
    12:22:05 [INFO] [CommunityBridge] Tracking Game Time     : true
    12:22:05 [INFO] [CommunityBridge] Tracking Total XP      : true
    12:22:05 [INFO] [CommunityBridge] Tracking Current XP    : true
    12:22:05 [INFO] [CommunityBridge] Tracking Level         : true
    12:22:05 [INFO] [CommunityBridge] Tracking Health        : false
    12:22:05 [INFO] [CommunityBridge] Tracking Life Ticks    : true
    12:22:05 [INFO] [CommunityBridge] Tracking Wallet        : false
    12:22:05 [INFO] [CommunityBridge] Enabled!
    12:22:05 [WARNING] [CommunityBridge] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'pimsserv_IPBOARD.ipbog3pfields_content' doesn't exist
    12:22:06 [INFO] [CommunityBridge] Running Auto Sync
    12:22:06 [WARNING] [CommunityBridge] Error at SQL Query: Table 'pimsserv_IPBOARD.ipbog3pfields_content' doesn't exist
    12:22:06 [SEVERE] Error occurred while enabling CommunityBridge v1.05 (Is it up to date?)
    java.lang.NullPointerException
        at net.netmanagers.community.Main.getUserId(Main.java:347)
        at net.netmanagers.community.Main.SyncPlayer(Main.java:511)
        at net.netmanagers.community.Main.syncAll(Main.java:505)
        at net.netmanagers.community.Main.onEnable(Main.java:266)
        at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:215)
        at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:336)
        at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:381)
        at im.mcft.pluginreloader.PluginReloader.loadPlugin(PluginReloader.java:250)
        at im.mcft.pluginreloader.PluginReloader.onCommand(PluginReloader.java:86)
        at org.bukkit.command.PluginCommand.execute(PluginCommand.java:40)
        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:603)
        at net.minecraft.server.MinecraftServer.w(MinecraftServer.java:572)
        at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:450)
        at net.minecraft.server.ThreadServerApplication.run(SourceFile:492)
    
    errr... would you happen to be able to tell me what i did wrong?
     
  19. Offline

    Kohle

    NoRC, thank you very much for the time you have put into this. I know this is really helping me manage my server.

    Now, here comes the part that makes me feel really stupid. I can't seem to figure it out myself, so here it goes.
    Alright, so this is what I want: When someone signs up on the forums, it checks their ingame rank. If their ingame rank is say Admin or Mod, it also changes their forum rank to that. But, if they were say my Default rank, they should then be promoted to Member.

    I really thought about this, and how I would set it up through the config file and I'm stumped. Help much appreciated, thanks.

    Kohle
     
  20. Offline

    Feaelin


    Hmm. Is this still the case? I re-read your first post and I can't discern an indication of your level of support for this plugin.

    If you no longer wish to support it beyond fixes, would you release the source so that other developers can add features as needed?

    If I understood the comments in the configuration file correctly, I believe that as currently written, the use-banned-filed and secondary-groups features are not compatible with phpBB3. CommunityBridge appears to expect these to be a field on the users table, but phpBB3 doesn't implement these features that way.

    For secondary groups, there's a table to map users to groups, to collect up a list of secondary groups a phpBB user is in, something like: SELECT group_id FROM phpbb_user_group WHERE user_id=<user_id> AND NOT group_id=<default_group_id> (written in browser, accuracy of SQL not guaranteed), would need to be performed to retrieve the list of group ids that the user is a member of that aren't the users default group.

    I'm not as sure about the banning feature. There's a 'phpbb_banlist' table with the following columns: ban_id, ban_userid, ban_ip, ban_email, ban_start, ban_end, ban_exclude, ban_reason, ban_give_reason, none are allowed to be non-null.
    ---------------------------------------------------------------------------------------------------------------------------
    I just configured this for a phpBB 3.0.10 board, so if anyone needs some input on how to make it work with phpBB3, I can probably make some good guesses. Some important notes for phpBB3:

    multi-tables: true
    multi-tables-use-key: false
    phpBB3 has a admin panel to create custom fields for users, and places them as columns in the phpbb_profile_fields_data table (assuming that phpbb_ is your table prefix). Note that if you tell phpBB3 the name of the field is 'minecraft_username' the column name (and thus, what you need to put in CommunityBridge's configuration) will be: pf_minecraft_username.
     
  21. Offline

    JackTheKnife22

    I odnt get it, im not computer smart in this way, I am using xenforo but do i fillin the "users-table:" "multi-table:" sections, im in my mysql but i dont know and such, a video would be great :p
     
  22. Offline

    JavaChips

    @Kohle
    I believe it will depend on the privileges you has set up for the user that is linked to your database, and giving it permissions to exit your forums database. Additionally, From the time I have spent messing around with it for XenForo, the plug-in works one way and is set up as a read only application. It may just be my set up of a security feature on XenForo, but I cannot set groups from within the game and have the changes reflect on the website. The current setup I have will allow me to automatically change user permissions and groups from the website, and show / hide website pages / features depending on your rank. I also use this plugin to manage my donations groups... Very handy and awesome may I add.

    My Website
    Server: mc.anthracitecity.com

    @JackTheKnife22
    There are a few things you need to look for. First is the database(your forum)... The tables(settings) then holds the rows and columns(attributes).

    EXAMPLE IS ONLY FOR XENFORO
    Example:
    Database: xenforo (might be different from your depending how you set up your forum)
    Table: xf_user (This will appear exactly like this and should show up in your config this way as well)

    Table Columns:

    table: xf_user
    user-name-field: username
    user-id-field: user_id
    groups-id-field: user_group_id
    secondary-groups-id-field: secondary_group_ids
    banned-field: is_banned

    Table Rows:
    username = playernamehere (The players name)
    user_id = 3 (the ID number for the player listed above)
    user_group_id = 2 (May be different depending on how your groups are set up)
    secondary_group_ids (optional) = 3 (this is in case your user is in two groups, such as group 2 and group 3 [admins and member]
    is_banned = 0 (This will be a 1 or 0 depending if the user is baned meaning they are (1) banned or they are not (0) banned.


    Example Set up:

    Code:
    multi-tables: false
    multi-tables-use-key: false
    use-banned-field: true
    secondary-groups: true
    permissions-system: PEX
    auto-sync: true
    auto-sync-every: 60000
    enable-basic-tracking: false
    users-table:
      table: xf_user
      user-name-field: username
      user-id-field: user_id
      groups-id-field: user_group_id
      secondary-groups-id-field: secondary_group_ids
      banned-field: is_banned
      banned-users-group: 2
      default-group: 1
     
  23. Offline

    JackTheKnife22

    am i able to copy and paste this?
     
  24. Offline

    Silentshadow

    Has anyone successfully got the basic tracking stuff to work on a MyBB forum? If so would you be willing to share your config file? If not, would someone be willing to dive in and help me set it up for MyBB?
     
  25. Offline

    JackTheKnife22

    could this work on a 1.2.3 server cause im using hack slash and mine

    what would i set my "db-host" to its localhost but this server is not on the same machine as my webhosting, my webhosting does support remote connections

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

    schatty

    I also need the Config for phpbb3
     
  27. Offline

    Inspitron

    I'm having trouble setting this up with SMF. Could someone provide me a sample configuration for SMF?

    Thank you in advance.
     
  28. Offline

    OpMidnight

    Do you think this would work with a www.webs.com forum? Thanks! This looks like an AWESOME plugin!!!

    And if not, what is a easy way to make a compatible website?

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

    NoRC

    Ummm two things... your running v1.05, upgrade to v1.06... second thing, the table you are referencing 'ipbog3pfields_content' does not exist. This works plugin works with Invision Power Board 3.x so you could be using a previous version of IPBoard or a different board in which case your a long way away from where your config needs to be.

    Kohle this plugin only reads from the Forums and does not write back to it. To do what you propose I think i would have to lock this down to one type of forum only.. which I would rather not do at this stage.

    Feaelin hmmm i think im going to have to add more for the phpbb ban table then as its currently designed to look at a banned field in the users table set to 1. I dont really have much spare time at the moment so adding new features isnt on my list of tasks... i will support bugs but time is limited.

    If someone wants to give me FTP and admin access to a phpBB forum I can do up a sample config and some adjustments to support phpBB.

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

    schatty

    I'm writing one right then if I set the PN.

    sorry for the bad english I'm from Germany - Translated by google :)
     

Share This Page