Hi everybody,

I am having a problem integrating with a Phpbb board modded with Categories Hierarchy.

Basically everything works apart that by inserting a new user through the Joomla/CB registration procedure with Phpbbconnector plugin the cache that stores the "newest registered user" and "number of registsred users" stats is not updated and it stays at the last registered user through the normal phpbb registration procedure (which is to be disactivated once the bridge is completed).

I have found where CH modifies the registration process

In usercp_register.php around line 528
[code:1]//-- mod : categories hierarchy

---

//-- add
// if name changed, update some data
if ( !empty($username_sql) )
{
$fields = array(
'forum_last_username' => stripslashes($username),
);
$db->sql_statement($fields);

// update forums last poster
$sql = 'UPDATE ' . FORUMS_TABLE . '
SET ' . $db->sql_update . '
WHERE forum_last_poster = ' . intval($user_id);
$db->sql_query($sql, false, __LINE__, __FILE__);

// update last user
if ( ($user_id == $config->data) || empty($config->data) )
{
$config->set('stat_last_user', $user_id);
$config->set('stat_last_username', stripslashes($username));
}

// recache moderators
include_once($config->url('includes/class_forums'));
$moderators = new moderators();
$moderators->set_users_status();
$moderators->read(true);
}
//-- fin mod : categories hierarchy

---

[/code:1]

And again around line 611:
[code:1]//-- mod : categories hierarchy

---

//-- add
// update last user
$config->set('stat_last_user', $user_id);
$config->set('stat_last_username', stripslashes($username));
$sql = 'SELECT COUNT(user_id) AS total_users
FROM ' . USERS_TABLE . '
WHERE user_id <> ' . ANONYMOUS;
$result = $db->sql_query($sql, false, __LINE__, __FILE__);
$row = $db->sql_fetchrow($result);
$config->set('stat_total_users', intval($row) + 1);
//-- fin mod : categories hierarchy

---

[/code:1]

Does anyone know what should I add to phpbbconnector.php in order to have it perform this cache update in phpbb everytime I register a new user to the forum through teh Joomla CB registraton? (comprofiler.php).

If you could make it work it would be of enourmous importance for me and for all those people that use this popoular (essential I would say) Phpbb modification.

I attach the whole usercpd_register.php file so you can check it all.

Thanx!

Post edited by: Yossarian, at: 2006/04/16 15:40

Post edited by: Yossarian, at: 2006/04/16 15:41

finally had a chance to turn on a computer...

Will try to take a peek tomorrow...

Greg

Hey Greg,

Got any news about this isssue?

Ciao

No news yet... I have been pretty tied up the last 2 weeks... hopefully I can get a chance to peek at this weekend...

I willing PM me some info about your site and I will attempt to look around and customize it to work (assuming not live site)... if live site then I could peek around to determine what fix needs to be done then let you know about a patch, etc.

Otherwise my issue is that I will have to develop off of the problem you describe without verifying it... (i.e. I don't have that MOD installed on my server)

Part of me still wonders about your 'cache' comment... I am guessing that if I dig into those functions that the would write data out to phpbb_config or some other table... have trouble understanding how it could store something in cache that other users would see... (i.e. wouldn't each user have their own cache or is it a server cache somehow)

Greg

Ciao Greg,

I can tell you with this mod in the cache directory a few files are created, which contain information related to latest posters, registered users, guests etc etc.

Try to install a premodded version of phpbb with CH to see it yourself.

ptifo.clanmckeen.com/

If you could you could easily see what I am talking about, there's een a new admin panel in phpbb to administer cache stored information.

Thanx for your help.

Has their been any updates to this issue? This is something I am about to deal with as well. I have several boards that use the Categories Hierarchy Mod and I was hoping to use the connector to sync with Joomla.

Thanks,
Chad