fixes to PhpBB contribution

Goanna · December 21, 2003

So, since a modded version of phpBB most likely will not work with this contrib, is there any way for my users to share an account with the phpBB area of my site without actually displaying the forum inside the cart? Like a bridge contribution?

beardeddone · December 21, 2003

So, since a modded version of phpBB most likely will not work with this contrib, is there any way for my users to share an account with the phpBB area of my site without actually displaying the forum inside the cart? Like a bridge contribution?

The modded version or interface version will work, you just need to copy the origional phpbb2 ver 2.0.6 files to their place before you over write them with the modified or interface version version.

See here

cDGo IT Consultancy · December 22, 2003

The upmysql.php isn't working with me.

Is there a translations of the text on that page?

beardeddone · December 22, 2003

I know, the page is almost unreadable, but on the bottom of the upmysql.php you'll see two icons one on top of each other, click on the top one, it'll update the phpbb database, if it does work then you have the phpbb database in the wrong place.

Goanna · December 22, 2003

In the instructions it says to edit a file called create_account_process.php but I dont have that file in my catalog folder. Where is it? Is it a phpBB file?

cDGo IT Consultancy · December 22, 2003

As beardeddone has translated the installation in English, you have to use create_account.php file.

Beardeddone, I ofcourse clicked on that button (I actually rephrased the text to Submit).

Where should the database be?

In the makers installation file stood something about changing the path of the database.

I didn't find out what and where he needs me to do that?

Goanna · December 22, 2003

Damn, I want to get this thing working but it looks like it is going to be a major pain. I thought I was finished and then I relized I had that whole seperate set of instructions to follow from beardedone.

Also, where is the file bb_index.php located? It didnt get uploaded to my site and I dont see it in the original folders from the contrib either.

Edited December 22, 2003 by Goanna

GIZMO-XL · December 22, 2003

The upmysql.php isn't working with me.
Is there a translations of the text on that page?

Here you go

<?php
// ------------------------------------------------------------------------- //
//  GNU General Public License for more details.                             //
//                                                                           //
//  You should have received a copy of the GNU General Public License        //
//  along with this program; if not, write to the Free Software              //
//   author:  Oldpa                                                    //
//  web site:  http://oldpa.adsldns.org  http://www.oldpa.com.tw        //
// ------------------------------------------------------------------------- //
function install_header(){

?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>OSC User Converter to PHPBB</title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET;?>">
<meta name="AUTHOR" content="osCommerce">
<meta name="GENERATOR" content="oldpa-- http://www.oldpa.com.tw/">
</head>
<body>
<div style='text-align:center'><img src='http://www.oldpa.com.tw/images/s_poweredby.gif' /><h3>CONVERT LINE 1</h3><br />
<?php
}

function install_footer(){
?>
<br /><br /><a href='http://www.oldpa.com.tw/' target='_blank'><img src='images/logo1.gif' alt='www.oldpa.com.tw' border='0' /></a></div>
</body>
</html>
<?php
}

if ( !isset($action) || $action == "" ) {
$action = "message";
}

if ( $action == "message" ) {
install_header();
echo "
<table width='90%' border='0'><tr><td colspan='2'>CONVERT LINE 2</td></tr><br>
<tr><td>-</td><td>XXXXX | YYYYY | ZZZZZ</b></td></tr>
<tr><td>-</td><td>CONVERT LINE 4</b></td></tr>
<tr><td>-</td><td><span style='color:#ff0000;font-weight:bold;'>CONVERT LINE 5</span></td></tr>
</table>
";
echo "<p>CONVERT LINE 6</p>";
echo "<form action='".$PHP_SELF."' method='post'><input type='submit' value='submit' /><input type='hidden' value='upgrade' name='action' /></form>";
install_footer();
exit();
}

if ( $action == "upgrade" ) {
require('includes/application_top.php');
install_header();
echo "<h4>CONVERT LINE 7</h4>\n";
$error = array();

tep_db_query("insert into " . TABLE_PHPBB_USERS . " (user_id , user_active, username, user_password ,user_session_time , user_session_page ,
                                                     user_lastvisit , user_regdate , user_level , user_posts , user_timezone , user_style ,
                                                  user_lang , user_dateformat , user_new_privmsg , user_unread_privmsg , user_last_privmsg ,
              user_emailtime , user_viewemail , user_attachsig , user_allowhtml , user_allowbbcode ,
              user_allowsmile ,user_allowavatar ,user_allow_pm , user_allow_viewonline ,user_notify ,
              user_notify_pm ,user_popup_pm , user_rank , user_avatar ,user_avatar_type ,user_email ,
              user_icq ,user_website ,user_from ,user_sig , user_sig_bbcode_uid , user_aim , user_yim ,
              user_msnm ,user_occ , user_interests , user_actkey , user_newpasswd)
              SELECT customers_id , '1', concat(customers_firstname, ' ' , customers_lastname) , customers_password , '', '',
              'time()', 'time()', '0','0','8.00','1',
              'english','D M d, Y g:i a', '0','0','0',
              '0','1','1','0','1',
              '1','1','1','1','0',
              '1','1','0','','0',customers_email_address,
              '','','','','','','','','','','',''
               FROM ".TABLE_CUSTOMERS." WHERE customers_id");

tep_db_query("insert into " . TABLE_PHPBB_GROUPS . " (group_id , group_type, group_name , group_description  ,group_moderator  , group_single_user)
                                                          SELECT customers_id+1,'1','','Personal User','0','1' FROM ".TABLE_CUSTOMERS." WHERE customers_id <> 1");

tep_db_query("insert into " . TABLE_PHPBB_USER_GROUPS . " (group_id , user_id , user_pending)
                                                                SELECT g.group_id ,u.user_id ,g.group_moderator FROM ".TABLE_PHPBB_GROUPS." AS g , ".TABLE_PHPBB_USERS ." AS u WHERE g.group_id = u.user_id+1");

}
echo "<div style='text-align:center;'><h4>CONVERT LINE 8</h4>\n";
echo "<table width='70%' border='0'><tr><td>";
echo "</td></tr></table><br /><br /><a href='".HTTP_SERVER."/'>HOME</a>";

install_footer();

?>

GIZMO-XL · December 23, 2003

Damn, I want to get this thing working but it looks like it is going to be a major pain. I thought I was finished and then I relized I had that whole seperate set of instructions to follow from beardedone.

Also, where is the file bb_index.php located? It didnt get uploaded to my site and I dont see it in the original folders from the contrib either.

If you downloaded the stuff from OSC it is not complete and you will never get it to work.

you need to go to the following places and look for a complete set of files for this mod

http://oscphpbb2.ecart.com.tw/viewtopic.php?t=36

and after that you will still have many correction to make to get it to work for you.

But after you get everything working it's a nice mod.

beardeddone · December 23, 2003

In the instructions it says to edit a file called create_account_process.php but I dont have that file in my catalog folder. Where is it? Is it a phpBB file?

Have you read my instructions yet?

Goanna · December 23, 2003

yeah, I finished the instructions from the add on itself first and I realized what files where what. Now I have to go over them using your instructions in order to get it working.

beardeddone · December 23, 2003

yeah, I finished the instructions from the add on itself first and I realized what files where what. Now I have to go over them using your instructions in order to get it working.

I like your site, I think I'll bookmark the url.

Goanna · December 23, 2003

:D Why thank you. That isnt even the site I am working on, although I would like to integrate my forum on that site into oscommerce, I am trying it out on a clients site first, as he has more of a need for a forum then I do. I assume you liked the content though, as the site itself isnt much but a standard version of OSC in terms of looks, lol.

cDGo IT Consultancy · December 23, 2003

Ok, got it to work from OSC to PHPBB.

Even using first and last name as username.

But now when I want to make a posting, nothing happens.

I remain on the index page.

markdc · January 21, 2004

Before I even attempt this. Is it possible to migrate an existing phpBB to this without making all my users re-register. Thanks for any info :D

Edited January 21, 2004 by markdc

beardeddone · January 21, 2004

Before I even attempt this. Is it possible to migrate an existing phpBB to this without making all my users re-register. Thanks for any info :D

If your talking about the users in the OSC database, no they won't need to re-register if you run the upmysql.php that was presented above, as a matter of fact new users can't register unless they go thru OSC first, phpbb will take them to the signup for osc anyway.

beardeddone · January 21, 2004

Damn, I want to get this thing working but it looks like it is going to be a major pain. I thought I was finished and then I relized I had that whole seperate set of instructions to follow from beardedone.

Also, where is the file bb_index.php located? It didnt get uploaded to my site and I dont see it in the original folders from the contrib either.

This is also explained on my website how and what to put in the bb_index.php file.

beardeddone · January 21, 2004

Frederick · January 26, 2004

Hi,

Now the PHPBB contribution sets the default language or the language chosen in the user profile. So you get e.g. an English oscommerce with a dutch PHPBB. Wouldn't it be possible to make the language of PHPBB change when you chose a different language of OSC ?

Thanks in advance

Frederick

oldpa · January 28, 2004

Hi,

Integrated by Oldpa ? 2003 Bulletin Board Module for osCommerce .

Powered by Invision Power Board(U) v1.3 Final ? 2003 IPS, Inc.

DEMOhere

Webhere

Edited January 28, 2004 by oldpa

Frederick · January 29, 2004

Does this mean you are suggesting to use invision instead of phpbb? I'm sorry but I can't read anything on your forum, it is all in Chinese.

Isn't it possible to change the language by changing the osc language in your PHPBB contribution? The invision board you are using is also not as integrated into the OSC layout as phpbb.

Great contribution though Oldpa!

Edited January 29, 2004 by Frederick

Frederick · January 29, 2004

How come it does change the language if you change the OSC language on your demosite and on mine it doesn't ?

defender39 · January 30, 2004

I got this working on my MS1 ..took about 2-3 hours but its all good now. One thing would be nice. If during signup you allowed users to create the forums alias. I have set in the config so users can change names if they want so that will do for now but it would be cooler if during signup it just asked for a "forums alias"

I installed this contrib from the 2 parts in the contributions section.

The real trouble I had was that I am using SEF on and it doesnt like the module link at all. I did hard code a link in my header and that worked just fine. I wasted at least an hour on that. Otherwise the install wasnt too bad. Just ignore the chinese text.

tuca · January 31, 2004

My problem is this:

When i try to add a post in the forum i can do this only as a guest also if i'm registered user...

Ihave this error when i run "upmysql"

1062 - duplicate entry '1' for the key 1

insert into phpbb_users (user_id , user_active, username, user_password ,user_session_time , user_session_page , user_lastvisit , user_regdate , user_level , user_posts , user_timezone , user_style , user_lang , user_dateformat , user_new_privmsg , user_unread_privmsg , user_last_privmsg , user_emailtime , user_viewemail , user_attachsig , user_allowhtml , user_allowbbcode , user_allowsmile ,user_allowavatar ,user_allow_pm , user_allow_viewonline ,user_notify , user_notify_pm ,user_popup_pm , user_rank , user_avatar ,user_avatar_type ,user_email , user_icq ,user_website ,user_from ,user_sig , user_sig_bbcode_uid , user_aim , user_yim , user_msnm ,user_occ , user_interests , user_actkey , user_newpasswd) SELECT customers_id , '1', customers_lastname , customers_password , '', '', 'time()', 'time()', '0','0','8.00','1', 'chinese_traditional_taiwan','D M d, Y g:i a', '0','0','0', '0','1','1','0','1', '1','1','1','1','0', '1','1','0','','0',customers_email_address, '','','','','','','','','','','','' FROM customers WHERE customers_id

[TEP STOP]

Can anyone help me please?

oldpa · January 31, 2004

How come it does change the language if you change the OSC language on your demosite and on mine it doesn't ?

open ibf index.php find

if ($ibforums->vars['default_language'] == "")

{

$ibforums->vars['default_language'] = 'en';

}

change to like

if (session_is_registered('language')) {

$ibforums->vars['default_language'] = $language;

}else

if ($ibforums->vars['default_language'] == "")

{

$ibforums->vars['default_language'] = 'english';

}

but you ibf lang folder en need to change name to english just like osc languages

folder name

fixes to PhpBB contribution

Recommended Posts

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in