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

I recieved these errors after switching the 1.02 jar against the 1.04 jar:

Code:

http://forums.bukkit.org/threads/admn-web-communitybridge-v1-04-links-forums-to-permissions-stat-tracking-1-2-5-r1-0.69218/page-2

At join I get theese erros:

Code:

2012-04-15 20:54:11 [SEVERE] Could not pass event PlayerJoinEvent to CommunityBridge
org.bukkit.event.EventException
    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.

 

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

 

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

 

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

 

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.

 

http://pastebin.com/0RPJx0JY

Thanks

 

http://pastebin.com/600P6Jsb


Using IPB, btw.

 

Does it work for Enjin Websites?

 

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

 

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!

 

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.

 

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

Code:

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 [/192.168.1.1:62263] 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.

 

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.

 

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)

Thanks!

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

forum:
# 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
usertable:
# 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?
username-field:
# 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!
banned-field:
# 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!
profiletable:
# 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
grouptable:
name: phpbb_user_group
key-field: user_id
group-field: group_id

# Stick your database info here
database:
host: '****'
port: '3306'
db: '****'
user: '****'
pass: '****'
# Which worlds on your server should Warrant affect the permissions for?
worlds:
- 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
groups:
# Here, normal registered members can go ahead and just join in as normal members
'3':
rank: Citizen
whitelisted: true
# Admins are instantly granted all there rights as found in the Permissions configuration
'2':
rank: Tourist
whitelisted: true
'4':
rank: Admin
whitelisted: true
'30':
rank: Admin
whitelisted: true
'28':
rank: Owner
whitelisted: true
'6':
rank: Moderator
whitelisted: true
'31':
rank: Moderator
whitelisted: true
'24':
rank: Moderator
whitelisted: true
'29':
rank: Founder
whitelisted: true
'32':
rank: Helper
whitelisted: true
'33':
rank: GriefP
whitelisted: true
'35':
rank: MCBlockIT
whitelisted: true
'34':
rank: Gold
whitelisted: true
'1':
rank: Citizen
whitelisted: true
'5':
rank: Banned
whitelisted: false

EDIT by Moderator: merged posts, please use the edit button instead of double posting.

 

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

 

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

Such as where it says

Code:

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

 

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.

 

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

 

so where does the script go in your website

 

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.

 

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

 

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

 

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?

 

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

 

NoRC

Code:

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>

 

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?

 

NoRC

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.

Code:

 
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)?
 

Thanks!

 

NoRC

Please support

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

 

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

 

Please Help

I have e root server

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

Sorry for my English