185 replies to this topic

[Mibble]

ok so did anyone create a generic version of this thing?  or where should i start?
i know the phpbb side fairly well.  to change the graphics pointers, it is in the tpl files, can change that there, and in the stylesheet you can change the colors of phpbb

[beardeddone]

Goanna, on Dec 20 2003, 05:57 PM, said:

I use phpBB2 plus on my site. It is basically phpbb 2.06 with a whole bunch of contributions already installed. It has a web portal type of interface. Would I still be able to use the phpBB mod with it, or would I need to go back to a plain installation of phpBB?

So far I haven't been able to get any mods working right yet, we'll figure  it out or someone will.

[beardeddone]

Mibble, on Dec 20 2003, 08:12 PM, said:

ok so did anyone create a generic version of this thing?  or where should i start?
i know the phpbb side fairly well.  to change the graphics pointers, it is in the tpl files, can change that there, and in the stylesheet you can change the colors of phpbb

What I did was use the regular phpbb2 to copy the necessary files where it say to in the origional instructions then over rote them with the interface version, not all the necessary files are in the interface version, you'll see when you get an error message that a certain file can't be found where ever.

[beardeddone]

The one thing I haven't figured out how to yet is how to change where the the graphics are looked at, it seems that if it looks in the normal subsilver images subdir is to many subdirs do deep for this interface version, so I made a templates/subsilver under catalog and put the graphic images there, this seems to work ok there.

[beardeddone]

Another thing, if you want to look at my site, delete the sid of the url you get and you won't get the dup user error.

[Goanna]

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]

Goanna, on Dec 20 2003, 11:10 PM, said:

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]

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

[beardeddone]

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]

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]

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]

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 by Goanna, 22 December 2003 - 09:13 PM.

[GIZMO-XL]

cDGo IT Consultancy, on Dec 22 2003, 03:41 PM, said:

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]

Goanna, on Dec 22 2003, 05:12 PM, said:

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]

Goanna, on Dec 22 2003, 12:22 PM, said:

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]

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]

Goanna, on Dec 22 2003, 05:58 PM, said:

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]

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]

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]

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  

Edited by markdc, 21 January 2004 - 09:01 PM.