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

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

 

Okay my connection to my MySQL server isnt working again :/

 

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!

 

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

 

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

 

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

 

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'

 

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.

 

From what I have just read, CPanel does not support Ubuntu servers because of a lack of a GUI
http://cpanel.net/cpanel-whm/system-requirements/

 

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

 

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

 

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:

 

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

 

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.

 

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) Server Log (close)

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?

 

Thank you
Can you help me with the custom fields for tracking?
Where and how to add this one?

 

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.

 

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

 

Got this to work, but the results are odd
...
Shouldn't this be more.... Readable?

 

NoRC
is it possible to get the source code?

 

"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.

 

i got field_14 erroers

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

 

How do I format anything?

 

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.

 

I have XenForo 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?

 

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)

 

Does this work with enjin?

 

http://dev.bukkit.org/server-mods/enjin-forum-link-link-your-enjin/

 

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

 

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.