Planned changes

Synchronizes various aspects of your Roster with your phpBB forum

Moderator: jaffa

Planned changes

Postby jaffa » Wed Apr 09, 2008 3:40 pm

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
Last edited by jaffa on Mon Apr 28, 2008 4:40 pm, edited 6 times in total.
User avatar
jaffa
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 49
Joined: Thu Jan 10, 2008 11:35 pm

Planned changes

Postby zanix » Wed Apr 09, 2008 11:53 pm

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
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Planned changes

Postby jaffa » Thu Apr 10, 2008 3:59 am

I will get on that after I've got phpBB3 working - cheers!
User avatar
jaffa
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 49
Joined: Thu Jan 10, 2008 11:35 pm

Re: Planned changes

Postby Adric » Sat Apr 26, 2008 8:28 pm

hows it coming on multiple databases? I'm anxiously looking forward to this addon!
User avatar
Adric
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 61
Joined: Wed Jul 05, 2006 7:52 am

Re: Planned changes

Postby jaffa » Mon Apr 28, 2008 3:14 pm

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.
Last edited by jaffa on Mon Apr 28, 2008 4:41 pm, edited 1 time in total.
User avatar
jaffa
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 49
Joined: Thu Jan 10, 2008 11:35 pm

Re: Planned changes

Postby Adric » Tue Apr 29, 2008 9:12 pm

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.
User avatar
Adric
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 61
Joined: Wed Jul 05, 2006 7:52 am

Re: Planned changes

Postby Adric » Tue Apr 29, 2008 9:14 pm

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....
User avatar
Adric
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 61
Joined: Wed Jul 05, 2006 7:52 am

Re: Planned changes

Postby mc_k » Wed Apr 30, 2008 12:56 pm

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) ;)
Image
mc_k
WR.net Apprentice
WR.net Apprentice
 
Posts: 14
Joined: Tue Feb 19, 2008 4:59 am

Re: Planned changes

Postby jaffa » Wed Apr 30, 2008 2:29 pm

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.
Last edited by jaffa on Wed Apr 30, 2008 2:30 pm, edited 1 time in total.
User avatar
jaffa
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 49
Joined: Thu Jan 10, 2008 11:35 pm

Planned changes

Postby Subxero » Mon Jun 09, 2008 3:54 pm

Hi Jaffa you have a PM ;)
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US


Return to phpBB Sync

Who is online

Users browsing this forum: No registered users and 0 guests

cron