NOTE: This version only works with Dragonfly phpBB. Further work required for phpBB3!

This addon syncronises various aspects of your Roster with your phpBB forum. It will do some or all of the following:

-Create groups and move members into those groups.
-Create ranks and change members to those ranks.
-Update members' forum location with their in-game location or hearth.
-Change members' avatar and signature to their SigGen avatar and signature.
-Suspend members who leave the guild.

The addon was originally based on SMFSync by boyo. Currently it only updates everything on a guild update, not a character update. If demand exists I may change some aspects (specifically location and avatar/signature) to update on character update.

Please try it out and tell me what's wrong with it!

Nice work man

Nice one

Getting there but getting this error

1054: Unknown column 'u.name' in 'where clause'
SQL:
update phpbb_users u, roster_members m set u.user_from=m.zone where ucase(u.name)=ucase(m.name)
File: lib/dbal/mysql.php
Line: 235

Getting new error now

1054: Unknown column 'u.name' in 'where clause'

You are using the addon on a phpBB3 forum. As noted elsewhere, the addon only works fully for a DF forum. However, the latest SVN allows group management and user suspension to a suspended group, so give that a try (if you're feeling brave). Make sure you select phpBB3 in the main options.

So I have finally got around to testing this addon with my rosterdf svn install at http://www.secret-order.us/rosterdf.html I currently have only one registered roster member to df being Merllin. When looking at the update log it seems to be saying it is creating the groups, ranks and such but really does not.

Success creating group(s)
Groups updated
Location updated.
Signature updated.
Avatar updated.
User rank(s) created
User rank(s) updated

What it doesn't currently do is check how many it has done - in this case zero. I probably need to make a guide. Is the user's 'Real Name' filled in with his main character name? That's the field the addon checks.

hehe ah i see what you mean

Jaffa I don't know if you've done this or thought of this, but I'd like to make a suggestion that may make the addon more flexible.
For Ranks to Groups you should try to put both from the databases and let the admin dicide which rank goes to which group.
Before i think you told me it creates/places ranks in a group of the same name.
In the result of our guild.. (with 10 military ranks) that's alot of groups! lol

What I'm suggesting is this.
For Rank -> Group a configuration to set what group a rank goes into.
Just pull a list of the rank names from the roster, and in the second column options list of the phpbb(3) group names. Should also include a "do nothing" option for the ranks that will never change group.

-afterthough: I'm not sure if WoWRoster will have all the ranks of a guild if they are not all filled. (ex. in the players info). so maybe extending the config to include a "how many ranks" to list option, and for the empties add text boxes to be filled in manually maybe. (just throwing thoughts out there)

This will allow more control over phpbbsync, and for some a less bulky group configuration on the phpbb(3) side. (like us with 10 ranks and 4 groups)

On a side note.. I wasn't sure if you've done this or not, but phpbb3 has "default" group setting for each member in the table. phpbbsync should make a the group it sets the default, or have an option for it.

BTW Jaffa you're doing a great job and creating a fantastic and very useful tool. I hope my ideas are in some way helpful and if you need anything let me know. I do know database stuff (customise/create DB's and queries all the time), and know enough php to give workable ideas, but I'm cold when it comes to actual heavy php programming lol
That's all you my friend and more power to ya. ha ha

Wowroster contains information about all ranks in the guild, even those nobody is in.

I don't know if this would be possible but it cant hurt to ask

Could you implement something for the multi rank mod

What I was think was maybe an option to set the players
Guild Rank as rank 2
Class as rank 3
Race as rank 4
Leaving Rank 5 blank for Custom Ranks (IE Site Admin)

Also an option so we can choose which field we want to use either Username or Real Name

An All Guilds Option would be nice also as I run 3 off the same forum.

Yeah choosing by user name instead of the real name field would be nice as everyone on my site is required to use there character name or I don't approve it..I'm guessing that is where I am having issues..

jaffa wrote:You are using the addon on a phpBB3 forum. As noted elsewhere, the addon only works fully for a DF forum. However, the latest SVN allows group management and user suspension to a suspended group, so give that a try (if you're feeling brave). Make sure you select phpBB3 in the main options.

I

I dont get the option for PHPBB3 in main I am afraid

Have you downloaded and installed the latest version from the SVN? It should say version 1.1.0.1 on the addon management page.

In response to the other requests:

- Letting an admin decide which rank/group in phpBB corresponds to which guild rank.
This should be possible, but will be quite a big project. I'll get phpBB3 working first before looking at this.

- Multi rank mod.
Can you point me in the direction of this mod so I can see how it works? I guess it means each user has multiple ranks, so there will be a user_ranks join table like there is with groups. This may be possible, but might be quite difficult and is probably a bit of a niche. I'll look into it, it might be pretty easy.

-Field to use for character name
Yep, will do this on the next update. There is no real name field in phpBB3 anyway so I am currently using the AIM field - bit of a kludge, willing to hear any ideas if you have them.

-Multi-Guild support
Actually, it does all guilds at the moment - I am intending to put in the single guild support but it does all of them at the moment, whatever you set that field to.