Skip to Content Skip to Menu

phpBB Connector V1.0.2 Beta now available

  • Yossarian
  • Yossarian
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 0
18 years 7 months ago #10297 by Yossarian
Replied by Yossarian on topic Re:phpBB Connector V1.0.2 Beta now available
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!

Attachment usercp_register.php.zip not found



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
Attachments:

Please Log in or Create an account to join the conversation.

  • Yossarian
  • Yossarian
  • OFFLINE
  • Posts: 14
  • Thanks: 0
  • Karma: 0
18 years 7 months ago #10299 by Yossarian
Replied by Yossarian on topic Re:phpBB Connector V1.0.2 Beta now available
And here's the second file involved:

Ask if you need more elements...

Attachment class_stats.php.zip not found

Attachments:

Please Log in or Create an account to join the conversation.

  • crimsone
  • crimsone
  • OFFLINE
  • Posts: 2
  • Thanks: 0
  • Karma: 0
18 years 7 months ago #10314 by crimsone
Replied by crimsone on topic Re:phpBB Connector V1.0.2 Beta now available
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.

Please Log in or Create an account to join the conversation.

18 years 7 months ago #10503 by Aristotelis
Replied by Aristotelis on topic Re:phpBB Connector V1.0.2 Beta now available
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.

Please Log in or Create an account to join the conversation.

  • geeffland
  • geeffland
  • OFFLINE
  • Posts: 199
  • Thanks: 0
  • Karma: 233
18 years 7 months ago #10511 by geeffland
Replied by geeffland on topic Re:phpBB Connector V1.0.2 Beta now available
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

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in or Create an account to join the conversation.

  • geeffland
  • geeffland
  • OFFLINE
  • Posts: 199
  • Thanks: 0
  • Karma: 233
18 years 7 months ago #10512 by geeffland
Replied by geeffland on topic Re:phpBB Connector V1.0.2 Beta now available
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

CB3PD Developer - CB Connector (formerly phpBB Connector) plugin

Please Log in or Create an account to join the conversation.

Moderators: beatnantkrileon
Powered by Kunena Forum