These are the things I'm currently planning to do with this addon:

-Currently manage groups will remove members from all their groups, unless they are protected, or the groups are system ones for phpBB3. What I would prefer is that they are only removed from groups that correspond to ranks in the guild. I could mark them as they are created, but that wouldn't help with groups that already existed before phpBBSync was installed. Could do with some ideas on this one.

-Get it working with phpBB3. Now I've had a better look at it and installed a test forum, it isn't looking quite as nasty as last night. It will mean that each query in the addon has to effectively be written twice as many of the table names are different. Done SVN 385

-Get it working with phpBB2 if the demand exists.

-Make it able to access a forum in a different database - maybe. As I won't be able to use the roster db layer this will mean not conforming to the guidelines, but there appears to be a workaround HERE that amounts to creating views in your Roster database that point to tables in your forum database. Whilst I only have one database to play with, I will post a list of tables that you need to create views of. Done SVN 387

EDIT 15 Apr '08

Additional things:

-Add a count of things updated to the message list on update.
-Enable individual guild support (it will currently update with all guilds info).
-Add option for using username, real name or some other field (probably AIM username - everyone hates AOL, right?) as real name does not exist in phpBB3. Done SVN 385
-Possibly add support for multirank mod. Done SVN 386
-Add ability to set what ranks/groups a user goes to, rather than using ranks/groups with same name as guild ranks.
-Set guild group as default group where the option exists.

EDIT 21 Apr '08

-Refactor code into seperate classes for different CMS implementations
-Add a button to the Roster to update without uploading - for testing and changes to settings that don't require new data to implement

Create a new instance of the Roster DB class, that will let you connect to multiple DBs

Roster creates one for you $roster->db, but you can make another one

I will get on that after I've got phpBB3 working - cheers!

hows it coming on multiple databases? I'm anxiously looking forward to this addon!

I don't think I will be able to do a join over multiple connections, but I may be able to do one over multiple databases on the same connection anyway.

EDIT: Done on the latest SVN. Please try it and tell me if it works as I only have the one database to play with.

ok,

phpbb3 is on community.midnightcartel.com
roster2 is on resources.midnightcartel.com

when i punch this in I get

Code: Select all

Backtrace (most recent call last):
lib/functions.lib.php
Line: 189
Function Called: backtrace
lib/dbal/mysql.php
Line: 235
Function Called: die_quietly
Arguments:
1146: Table 'resources.phpbb_groups' doesn't exist
Database Error
/home/.lamster/shadowmaster2/midnightcartel.com/resources/roster/lib/dbal/mysql.php
235
SELECT * FROM `phpbb_groups` where group_type!=3 order by group_name
addons/phpBBSync/admin/config.func.php
Line: 58
Function Called: query
Arguments:
SELECT * FROM `phpbb_groups` where group_type!=3 order by group_name
lib/config.lib.php
Line: 404
Function Called: getGroups
Arguments:
Array ( [id] => 1302 [name] => guild_suspended_group [config_type] => phpbb_menu_guild [value] => 0 [form_type] => function{getGroups [description] => Select a group to put suspended members in [tooltip] => Create a group in your forum to put suspended members in and set permissions accordingly.

db name: guild_suspended_group )
lib/config.lib.php
Line: 184
Function Called: buildBlock
Arguments:
phpbb_menu_guild
admin/addon_conf.php
Line: 119
Function Called: buildConfigPage
pages/rostercp.php
Line: 105
Function Called: require_once
Arguments:
/home/.lamster/shadowmaster2/midnightcartel.com/resources/roster/admin/addon_conf.php
index.php
Line: 86
Function Called: require
Arguments:
/home/.lamster/shadowmaster2/midnightcartel.com/resources/roster/pages/rostercp.php

i do now have a box to set the database though, but it appears that it isnt grabbing the info though.

hmm, won't let me edit my post for some reason...

anywho... of note, if you make an error in the settings, you always get something similar to the above. to change it, you have to uninstall the add-on, reinstall it, then try again....

jaffa wrote:-Get it working with phpBB2 if the demand exists.

demand exists
would be nice if youll also create an phpbb2option since there are just too many hacks for phpbb2 that ill miss in phpbb3 (and i think many others still use phpbb2 cause of this)

anywho... of note, if you make an error in the settings, you always get something similar to the above. to change it, you have to uninstall the add-on, reinstall it, then try again....

Yep - sorry about that. I need to understand how the config_func works - while the update_hook is pretty much all new the config_func is still mostly from SMFSync. I will address this soon.

would be nice if youll also create an phpbb2option since there are just too many hacks for phpbb2 that ill miss in phpbb3 (and i think many others still use phpbb2 cause of this)

This actually shouldn't be too hard - I am hoping the structure is very similar to DF, so I'm thinking minor tweaks to some of the queries - hopefully just the table names will be slightly different.

Hi Jaffa you have a PM