Sync Roster with a phpBB group

by **robweeks** » Wed Jan 31, 2007 4:46 pm

Well, your in luck, i have just updated the mod so it will use your phpBB config file and the wow Roster config file. You no longer need to define the login setting for either, just the root to phpBB.

I have also implemented rank based assignments. You can can specify that members who are 'Officers' are placed into an 'Officer' phpBB group. Go on, tell me you love me!

Il submit the update now!

by **Niryk** » Wed Jan 31, 2007 6:32 pm

The only thing I could ask for, (and actually, I can't really ask for it 'cause I've a very unique situation) would be the ability to have some method of specifying alts or more than one char (in more than one roster) for a forum name... I got twelve guilds and one forum, some people from the forums have characters in more than one guild, and thus need to be in more than one usergroup.

by **robweeks** » Wed Jan 31, 2007 6:45 pm

if you have 12 guilds, you would prob need 12 guild roster installs and a single phpBB... i presume. Just install the mod on each roster and edit config file to reflect that.

What your asking is very unique haha, dont think i would implement that.

The mod can only access the roster install its within

by **Niryk** » Wed Jan 31, 2007 7:01 pm

robweeks wrote:if you have 12 guilds, you would prob need 12 guild roster installs and a single phpBB... i presume.

That is the setup I have, forums at forums.pa-guilds.com and each guild has a roster at roster.pa-guilds.com, 'course having looked at the code a bit more now, I think it shouldn't be too hard to just have people list their character names in a phpBB profile field and have each roster mod search for a match... at least the rosters use a shared codebase so I can make the changes in one dir and test/implement it on all of them at once.

by **robweeks** » Wed Jan 31, 2007 7:20 pm

as long as there is a consistant place the names are stored, you can parse them.

Good luck with it mate

by **cynthetiq** » Wed Jan 31, 2007 11:10 pm

thanks for the update... i didn't get the database items copied over yet.

I downloaded the new update. Still no luck though. i don't get any errors saying it cannot locate the phpbb directory, passwords work right and if i use wrong one I get an error. Bottom of the screen reads:

This page was created in 0.17 seconds with 4 queries executed

otherwise I don't have any other SQL information to give you.

i can't fathom what's going wrong.

by **robweeks** » Thu Feb 01, 2007 5:33 am

hummm... i dont know then. hard for me to test as all my tables are in same DB....

Il think bout it

by **Fazerleon** » Thu Feb 01, 2007 6:24 am

Hi,

Thank you very much for this great addon !

I've just a question, is it possible to not use the default group members ?
I'd like to put members in spécifed groups following their guild rank but not to have members in 2 differents groups (default group and ranked group), it's to be sure to not have problem with right's conflict on forum.

Thanks

by **robweeks** » Thu Feb 01, 2007 7:32 am

Yeh you could do, but i wouldnt advise it. the reason is that if you dont specify one of your ranks in the config file. Guild members in those forgotten ranks wont have access.

What i have done on my forum is give basic rights to a Hidden group called "Guild Members" then do my specific access controls for each rank.

I could add a boolean setting to the config, that way you atleast have a choice on whether to use the default group or not. But i wont remove the function from the application totally

by **cynthetiq** » Thu Feb 01, 2007 11:54 am

database is now consolidated....

now that's hawt! It was awesome to see the names come up and change... I love it!!!

by **robweeks** » Thu Feb 01, 2007 12:24 pm

glad you like it

by **cynthetiq** » Thu Feb 01, 2007 12:56 pm

Next thing for me to try is to see if I can't make it a cron job to kick it off automatically so that the uniuploader guildprofiler keeps it up to date automatically.

any ideas how to get it to submit the password in the cron job?

by **Niryk** » Thu Feb 01, 2007 1:41 pm

Why not just have it trigger off the guild update upload?

by **robweeks** » Thu Feb 01, 2007 6:22 pm

Because the trigger is executed for each character, not once for the update (i think; thats what was happening with me anyway). So it would be difficult to clear the groups before processing.

I didnt look that hard into it to be honest

EDIT:

Just noticed this in the SDK:

Available variables
- $wowdb = roster's db layer
- $member_id = character id from the database ( ex. 24 )
- $member_name = character's name ( ex. 'Jonny Grey' )
- $roster_conf = The entire roster config array
- $mode = when you want to run the trigger
= 'char_pre' - before character updates
= 'char' - during a character update
= 'char_post' - after character updates
= 'guild_pre' - before guild updates
= 'guild' - during a guild update
= 'guild_post' - after guild updates

I will code the trigger with a guild_post.... monday maybe, busy this weekend

by **cynthetiq** » Fri Feb 02, 2007 6:17 pm

that will be totally awesome! I'm glad that helped spawn the idea. What will become of the phpbb sync button??? maybe just load a little graphic? or a CP to do autouploads vs. push the button?