Mehdi's Bridge for Phpbb2 (not 3 yet ...)

[mehdi]

However it is now a blank white page when trying to access the forum.

is gzip compression enabled on joomla or phpbb ? disable them

[Wizza]

ive disabled both of them and it is still the same

[mehdi]

ive disabled both of them and it is still the same

that's boring ... could you restore a "normal access",
i.e no login/password, to see what's happen when accessing to url  you just PM  me.
Also try to disable visual integration.

[Wizza]

I just logged out of my joomla install, and then tried accessing my forum without being logged in to joomla.

It redirected me to my joomla "Login" form. I entered my username and password yet it did nothing. I clicked forum again and it showed "You are currently Logged In to the private area of this site"

Yet when clicking Forum again it still says the same.

*UPDATE*

It shows me logged in now, but still the same as above.

[mehdi]

I clicked forum again and it showed "You are currently Logged In to the private area of this site"

check FAQ, especially the question "I can login in joomla but not in phpbb".

It shows me logged in now, but still the same as above.

unclear

[Wizza]

Ok, I was unclear last time.


I added the www. to every config file now as that was what my forum was using.

Now, the redirection is fine, and goes to my forum.

However, my forum still does not show and is still a blank white page.

(Medhi, please check your PM's for a username and password to access the site and check).

Gzip compression on PHPBB is turned off, and Gzip page compression on Joomla is turned off.

$joomIntegrate is set at false, so thats the visual interegation turned off too..

Still nothing.

[mehdi]

Hi wizza,
sorry I don't see what's wrong ...
did you edit your edit a "clean copy" of your configuration file,
or have you re-edited the problematic one  ?
Is it the only file you edited manuallly ?
Try to enable/disable RG_EMULATION in globals.php.
I don't know why I'm redirected to login page of joomla when I just visit the forum (not the default behavior).
You might look to an alternative forum solution ...

[Wizza]

Maybe its the login.php file of the forum?

I struggled editing that, and this is how it looks:

sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Error in obtaining userdata', '', __LINE__, __FILE__, $sql);
}

if( $row = $db->sql_fetchrow($result) )
{
// begin password protection mod
if ( $row['user_password'] == md5($password) )
{
$sql_a=" UPDATE " . USERS_TABLE . "
SET user_bad_password=0
WHERE user_id=" . $row['user_id'];
if ( !$db->sql_query($sql_a) )
{
message_die(GENERAL_ERROR, 'Error logging in', '', __LINE__, __FILE__, $sql_a);
}
//message_die(GENERAL_ERROR, 'incorrect password');
}
// end password protection mod
if( $row['user_level'] != ADMIN && $board_config['board_disable'] )
{
redirect(append_sid("index.$phpEx", true));
}
else
{
// If the last login is more than x minutes ago, then reset the login tries/time
if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $row['user_last_login_try'] sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);
$row['user_last_login_try'] = $row['user_login_tries'] = 0;
}

// Check to see if user is allowed to login again... if his tries are exceeded
if ($row['user_last_login_try'] && $board_config['login_reset_time'] && $board_config['max_login_attempts'] &&
$row['user_last_login_try'] >= (time() - ($board_config['login_reset_time'] * 60)) && $row['user_login_tries'] >= $board_config['max_login_attempts'] && $userdata['user_level'] != ADMIN)
{
message_die(GENERAL_MESSAGE, sprintf($lang['Login_attempts_exceeded'], $board_config['max_login_attempts'], $board_config['login_reset_time']));
}
//-------------------------------------------
if( ! ($row['user_active']) ) message_die(GENERAL_ERROR,"User account not active");
//is the user trying to access to administration panel ?
//check password only in this case
if(isset($HTTP_POST_VARS['admin']) )
  $checkPasswordTest = md5($password) == $row['user_password'];
else
  $checkPasswordTest = true;
//-------------------------------------------         
                         
if($checkPasswordTest)
{
//-- mod : Loewen Enterprise - PAYPAL IPN REG / SUBSCRIPTION - GROUP -----------------------------------------------------------
//-- add
lw_check_membership($row);
//-- fin mod : Loewen Enterprise - PAYPAL IPN REG / SUBSCRIPTION - GROUP -----------------------------------------------------------

$autologin = ( isset($HTTP_POST_VARS['autologin']) ) ? TRUE : 0;

$admin = (isset($HTTP_POST_VARS['admin'])) ? 1 : 0;
$session_id = session_begin($row['user_id'], $user_ip, PAGE_INDEX, FALSE, $autologin, $admin);

// Reset login tries
$db->sql_query('UPDATE ' . USERS_TABLE . ' SET user_login_tries = 0, user_last_login_try = 0 WHERE user_id = ' . $row['user_id']);

if( $session_id )
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
redirect(append_sid($url, true));
}
else
{
message_die(CRITICAL_ERROR, "Couldn't start session : login", "", __LINE__, __FILE__);
}
}
// Only store a failed login attempt for an active user - inactive users can't login even with a correct password
elseif( $row['user_active'] )
{
// Save login tries and last login
if ($row['user_id'] != ANONYMOUS)
{
$sql = 'UPDATE ' . USERS_TABLE . '
SET user_login_tries = user_login_tries + 1, user_last_login_try = ' . time() . '
WHERE user_id = ' . $row['user_id'];
$db->sql_query($sql);
}
}

// begin password protection mod
if ( $row['user_password'] != md5($password) )
{
// let's store the IP of the bad entry
$sql_a=" INSERT INTO " . BAD_PASS_LOG_TABLE . "
(user_id, ip_address, log_time)
VALUES
(" . $row['user_id'] . ",'" . $user_ip . "'," . time() . ")";
if ( !$db->sql_query($sql_a) )
{
message_die(GENERAL_ERROR, 'Error logging in', '', __LINE__, __FILE__, $sql_a);
}
// how many bad attempts to date?
if ( $row['user_bad_password'] > 1 )
{
//
// Set default email variables
//
$script_name = preg_replace('/^\/?(.*?)\/?$/', '\1', trim($board_config['script_path']));
$script_name = ( $script_name != '' ) ? $script_name . '/profile.'.$phpEx : 'profile.'.$phpEx;
$server_name = trim($board_config['server_name']);
$server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://';
$server_port = ( $board_config['server_port'] 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/';

$server_url = $server_protocol . $server_name . $server_port . $script_name;
//
// page specific function
//
function gen_rand_string($hash)
{
$chars = array( 'a', 'A', 'b', 'B', 'c', 'C', 'd', 'D', 'e', 'E', 'f', 'F', 'g', 'G', 'h', 'H', 'i', 'I', 'j', 'J',  'k', 'K', 'l', 'L', 'm', 'M', 'n', 'N', 'o', 'O', 'p', 'P', 'q', 'Q', 'r', 'R', 's', 'S', 't', 'T',  'u', 'U', 'v', 'V', 'w', 'W', 'x', 'X', 'y', 'Y', 'z', 'Z', '1', '2', '3', '4', '5', '6', '7', '8', '9', '0');

$max_chars = count($chars) - 1;
srand( (double) microtime()*1000000);

$rand_str = '';
for($i = 0; $i sql_query($sql_a) )
{
message_die(GENERAL_ERROR, 'Error logging in', '', __LINE__, __FILE__, $sql_a);
}
$sent_details=1;
$sent_username=$row['username'];
$sent_email=$row['user_email'];
include($phpbb_root_path . 'includes/usercp_sendpasswd.'.$phpEx);
exit;
//message_die(GENERAL_ERROR, 'Account Blocked.' . $blocked_redirect);
}
// update the bad attempt count, only if the account isn't locked
if ( $row['user_bad_password'] > -1 )
{
$sql_a=" UPDATE " . USERS_TABLE . "
SET user_bad_password=user_bad_password+1
WHERE user_id=" . $row['user_id'];
if ( !$db->sql_query($sql_a) )
{
message_die(GENERAL_ERROR, 'Error logging in', '', __LINE__, __FILE__, $sql_a);
}
}
else
{
// inform that account is blocked
$index_redirect = '';
$message = $lang['account_blocked'] . $index_redirect;
message_die(GENERAL_MESSAGE, $message);
}
}
// end password protection mod

$redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : '';
$redirect = str_replace('?', '&', $redirect);

if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
{
message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
}

$template->assign_vars(array(
'META' => "")
);

$message = $lang['Error_login'] . '

' . sprintf($lang['Click_return_login'], "", '') . '

' .  sprintf($lang['Click_return_index'], '', '');

message_die(GENERAL_MESSAGE, $message);
}
}
else
{
$redirect = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "";
$redirect = str_replace("?", "&", $redirect);

if (strstr(urldecode($redirect), "\n") || strstr(urldecode($redirect), "\r"))
{
message_die(GENERAL_ERROR, 'Tried to redirect to potentially insecure url.');
}

$template->assign_vars(array(
'META' => "")
);

$message = $lang['Error_login'] . '

' . sprintf($lang['Click_return_login'], "", '') . '

' .  sprintf($lang['Click_return_index'], '', '');

message_die(GENERAL_MESSAGE, $message);
}
}
else if( ( isset($HTTP_GET_VARS['logout']) || isset($HTTP_POST_VARS['logout']) ) && $userdata['session_logged_in'] )
{
// session id check
if ($sid == '' || $sid != $userdata['session_id'])
{
message_die(GENERAL_ERROR, 'Invalid_session');
}

if( $userdata['session_logged_in'] )
{
session_end($userdata['session_id'], $userdata['user_id']);
}

if (!empty($HTTP_POST_VARS['redirect']) || !empty($HTTP_GET_VARS['redirect']))
{
$url = (!empty($HTTP_POST_VARS['redirect'])) ? htmlspecialchars($HTTP_POST_VARS['redirect']) : htmlspecialchars($HTTP_GET_VARS['redirect']);
$url = str_replace('&', '&', $url);
redirect(append_sid($url, true));
}
else
{
redirect(append_sid("index.$phpEx", true));
}
}
else
{
$url = ( !empty($HTTP_POST_VARS['redirect']) ) ? str_replace('&', '&', htmlspecialchars($HTTP_POST_VARS['redirect'])) : "index.$phpEx";
redirect(append_sid($url, true));
}
}
else
{
//
// Do a full login page dohickey if
// user not already logged in
//
if( !$userdata['session_logged_in'] || (isset($HTTP_GET_VARS['admin']) && $userdata['session_logged_in'] && ($userdata['user_level'] == ADMIN || in_array($userdata['user_level'], explode(',', $board_config['modcp_levels_used'])))))
{
$page_title = $lang['Login'];
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

$template->set_filenames(array(
'body' => 'login_body.tpl')
);

$forward_page = '';

if( isset($HTTP_POST_VARS['redirect']) || isset($HTTP_GET_VARS['redirect']) )
{
$forward_to = $HTTP_SERVER_VARS['QUERY_STRING'];

if( preg_match("/^redirect=([a-z0-9\.#\/\?&=\+\-_]+)/si", $forward_to, $forward_matches) )
{
$forward_to = ( !empty($forward_matches[3]) ) ? $forward_matches[3] : $forward_matches[1];
$forward_match = explode('&', $forward_to);

if(count($forward_match) > 1)
{
for($i = 1; $i ';
$s_hidden_fields .= (isset($HTTP_GET_VARS['admin'])) ? '' : '';

make_jumpbox('viewforum.'.$phpEx);
$template->assign_vars(array(
'USERNAME' => $username,

'L_ENTER_PASSWORD' => (isset($HTTP_GET_VARS['admin'])) ? $lang['Admin_reauthenticate'] : $lang['Enter_password'],
'L_SEND_PASSWORD' => $lang['Forgotten_password'],

'U_SEND_PASSWORD' => append_sid("profile.$phpEx?mode=sendpassword"),

'S_HIDDEN_FIELDS' => $s_hidden_fields)
);

$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);
}
else
{
redirect(append_sid("index.$phpEx", true));
}

}

?>

Please check that the hacks was added correctly.

[Wizza]

I just replaced the login.php with my backup login.php and it worked, then when I put the login.php (one created by the bridge) it stopped working again, so I know something in the login.php has been hacked wrong.

Can anyone spot it?

[Wizza]

It's either my inc_login.php file or the login.php file thats causing it to mess up.. its one of them

[mehdi]

It's either my inc_login.php file or the login.php file thats causing it to mess up.. its one of them

Do you need to apply any particular mod to these files?
If not just overwrite login.php and inc_login.php with the ones provides in the "hacked files" folder ,
of the zip file you downloaded for the bridge.

[Wizza]

Hello,

After trying every file it seems as if it may be a problem linked to the generated files. It seems that the standard "login.php, faq.php, index.php..etc" files are not working or sending you to the inc_login.php, inc_faq.php.. etc etc

I have no idea why either

[mehdi]

hi,
23 April 2007
fix for "external direct links" to topics.
This can be usefull if you a module that show latest posts on your frontpage.
As usual, replace the file joomphpbb_engine.php by the new one.

Yes I admit, it's a bit exasperating to click on one of the "latest topic links" and then be redirected
to the forum homepage. Fixed.

cheers

[leonard_1422]

I already succes to install the bridge and it is working..but now i cant go to the admin control panel.can you help me anyone?

[mehdi]

hi leonard_1422 ,

but now i cant go to the admin control panel.can you help me anyone?

what is exactely the problem ?
If you don't see the admin panel link , use the same username you use for phpbb,
and login with it inside joomla.
Then visit the forum.

good luck

[vansyle]

I am using Joomla 1.0.10, CH forum  and Bridge. For old users can login normal, but new users can login to joomla and can not go to forum. The messages

The page isn't redirecting properly
Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
This problem can sometimes be caused by disabling or refusing to accept cookies.

Please help me to solve this problem. thank you very much.

[mehdi]

hi vansyle,

old users can login normal, but new users can login to joomla and can not go to forum

This looks like an old bug. Do you use a recent version of the  joomphpbb_engine.php file ?
Also try  first if you can manage to let things work properly without CH.

[vansyle]

I used Joomla 1.0.10, phpBB 2.0.21 and your Bridge, it worked perfectly. I've just change into CH forum based on old database (joomla 1.0.10 and CH 2.1.4e), i met that problem.

Please tell me fix that problem. Thank you very much.

[mehdi]

I used Joomla 1.0.10, phpBB 2.0.21 and your Bridge, it worked perfectly. I've just change into CH forum based on old database (joomla 1.0.10 and CH 2.1.4e), i met that problem.

Probably, some phpbb/joomla users entries were removed , hence the appearing bug. Please update the joomphpbb_engine.php file , and run the checkassoc.php script in forum's root.
If problem persist, you can also delete the joomphpbb_bridge table and re-create it (or remove content)

good luck

[vansyle]

I appreciate the help you are providing. I followed your guide but this problem still persists. Although I uses fresh joomla 1.0.10, CH 2.1.4e and your Bridge (newest version from your website). I try my best to do but 

Now i have to change the way , I want to use the register and login function of CH forum and keep the integration of interface as your Bridge . How can I do that (the database of forum and joomla is separation) ?

Thank you very much.

[mehdi]

hi vansyle ,
I just realized I made a confusion between CH (Categories Hierarchy )  and CB (Community Builder).
That's what happen when you are juggling with abreviations.
So concerning CH my answer is different:
* it has been reported by some people that it work with CH, and by other people not.
Some people are enough experimented with CH to make the required changes to let it work properly with the bridge, but frankly I don't know. Anyway, I do not support CH since things are not very clear with it.
Please use a regular phpbb installation, or at least, less heavy mods (that does not affect the way phpbb login).

Now i have to change the way  , I want to use the register and login function of CH forum and keep the integration of interface as your Bridge

I do not plan to implement this (yet)

[Adeptus]

Hi Mehdi,

A few of the users of my forum have reported that the "View Newest Post" link beside a topic title (not the view last post beside the author name) was bringing them back to the main forum index. This was with version 1.4 of your bridge. I just uploaded 1.5, well, the engine file only, and the problem is now worse as it displays the redirect page which just keeps displaying in an endless loop. I'm wondering if anyone else has this same problem.

To try and recreate this, just click on the little icon beside the title of a topic that has a new post.

I'm using Joomla 1.0.12, phpBB 2.0.22

Thanks

[mehdi]

hi Adeptus,

. I just uploaded 1.5, well, the engine file only, and the problem is now worse as it displays the redirect page which just keeps displaying in an endless loop. I'm wondering if anyone else has this same problem.

You mean the "little arrow" that appear next the topic ? tested on a local install , and it just works fine.
I cannot reproduce the problem, sorry.
Here's some ideas:
- the $joomUrl setting is misconfigured
- the cookie setting under phpbb , if you already played with it
-  something installed  is affecting the behavior of jooomla (especially a mambot/plugin)
By the way, do you have the problem for all users ? (you said a "A few of the users")

good luck

[Adeptus]

Hiya,

Yeah, the little icon beside the topic when there's a new post.

If the $joomURL was misconfigured I woul dhave thought a lot more functions would not work. Everything works except this bit. I think every user gets this issue to be honest, it's just that onlt a couple have complained as they would use this function normally.

In terms of mambots and plugins I don't have too many. Again it's strange that it's only this function as "go to last post" works fine! As I said, at 1.4 it would redirect the user to the index, and at 1.5 it goes into a vicious cycle of redirecting non-stop.

I'll double check the config (again) and let you know, but if you have any more ideas of where to look to trace the issue I'd appreciate it.

http://www.irishcraftbrewer.com is the URL by the way

Thanks

[dubstepdotnl]

hello,

I'm running http://www.dubstep.nl - a dubstep music forum - as best as I can, but I want a Joomla portal in front of it.

Now I've understood that there's no conversion tool yet, else I'd fully use Joomla and the new fireboard, but this bridge might be the solution.

The thing is; I have not installed Joomla yet, and I was wondering if I could just install it the normal way, even though I only have one database?

[mehdi]

hi  dubstepdotnl ,

I was wondering if I could just install it the normal way, even though I only have one database?

the ability to use two databases is a convenience, not a requirement.
So just install joomla "the normal way", and then bridge ...

good luck

[dubstepdotnl]

hi  dubstepdotnl ,

I was wondering if I could just install it the normal way, even though I only have one database?

the ability to use two databases is a convenience, not a requirement.
So just install joomla "the normal way", and then bridge ...

good luck

thank you very much.

[dubstepdotnl]

back once more

Learnt alot, like that I do have more than one database, so I'm using 2 seperate databases now.
I've succesfully installed Joomla, so the next step is the bridge.

Now I've read ALOT, and from what I understood is that it won't be possible bridging these two domains:
forums.dubstep.nl (phpbb) & http://www.dubstep.nl (joomla).

Mr. mehdi or someone, please tell me that I understood incorrectly

[mehdi]

hi,

from what I understood is that it won't be possible bridging these two domains:
forums.dubstep.nl (phpbb) & http://www.dubstep.nl (joomla).

true

[Vizion]

I am a novice when it comes to 'hacking' for this plugin but i REALLY need it. I have phpbb already installed - see http://www.hiphopremix.com/messageboard BUT at root http://www.hiphopremix.com/index.php - you can tell there's a lot of items missing.

If someone could help me b/c when it comes to 'hacking'....i get a little 

thanks in advance!