OK, I identified the reson why it is not updating the "newest registered user" information at the bottom of the board.

It has to do with the categories hierarchy mod I have installed on phpbb to get the subforums feature.

This mod modifies the registration procedure and adds a "update last user" function.

I am puzzled... I don't understand where this information is stored.

I tried to integrate the strings of code in phpbbconncector.php, but failed miserably and still encounter the problem... when I register a new user from joomla it is perfectly added to phpbb's DB but the numer of users and the newest registered are not showed on the board.

I will post here the two phpbb files (one at a time) I believe are involved.

You will easily find the code I am referring to because it is commented, but I will post it here anyways so that everybody can see it.

Hoping that Greg's got some time to look into this mess.

Thanx!



In usercp_register.php

[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]

[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]

Post edited by: Yossarian, at: 2006/04/14 17:53

Post edited by: Yossarian, at: 2006/04/14 17:55

And here's the second file involved:

Ask if you need more elements...

Further to my previous post, I've made a mistake. Users logged into Joomla are seen as guests by phpBB. Still just as confusing to me though.

Yossarian wrote:

It has to do with the categories hierarchy mod I have installed on phpbb to get the subforums feature.

We are very interested in using Joomla with phpBB and the categories hierarchy mod. We are facing similar problems to Yossarian and had to delay production date (for a short time).

Gregg and all, please put some emphasis into this integration. The categories hierarchy mod is probably the most basic and recommended phpbb mod and the cb plugin would benefit immensely by being compatible with it.

We are looking forward to the resolution. Thanks.

Yossarian/Aristotelis,

To make sure I understand the issues... verify this is what needs to be fixed...

1) Make sure newest registered username and ID are logged so the the categories hierarchy mod works correctly.

a) includes username
b) includes userid
c) includes total users

The only part of the code posted that I don't exacly understand is
[code:1]
$fields = array(
'forum_last_username' => stripslashes($username),
);
$db->sql_statement($fields);[/code:1]

Not sure what sql_statement with an array does... will dig into further The other code seems pretty straight forward setting and querying specific tables.

Did I miss anything?

Greg

crimsone,

PM me some info on how to access the admin side and the database tables (MyPhpAdmin preferred). I will peek through the tables and see what is there.

Otherwise verify:
1) Each user has a phpbb_id in jos_comprofiler that matches a valid (and Actuve = '1') id in phpbb_tables

2) Make sure the forum directory is set correctly in the plugin parameters

3) Make sure you are using the CB login versus the joomla login

Greg