Jump to content
Sign in to follow this  
adrian##

fixes to PhpBB contribution

Recommended Posts

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?

Share this post


Link to post
Share on other sites
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


Best Regards

Share this post


Link to post
Share on other sites

The upmysql.php isn't working with me.

Is there a translations of the text on that page?


Building great webshops for customers with opensource backoffice application for a robotic accounting solution including POS
Migrating osC 2.x webshops to 2.3.4.x
osCommerce dedicated hosting/colocation + turnkey solutions + building addons per request

Share this post


Link to post
Share on other sites

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.


Best Regards

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?


Building great webshops for customers with opensource backoffice application for a robotic accounting solution including POS
Migrating osC 2.x webshops to 2.3.4.x
osCommerce dedicated hosting/colocation + turnkey solutions + building addons per request

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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();

?>

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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?


Best Regards

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.


Best Regards

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.


Building great webshops for customers with opensource backoffice application for a robotic accounting solution including POS
Migrating osC 2.x webshops to 2.3.4.x
osCommerce dedicated hosting/colocation + turnkey solutions + building addons per request

Share this post


Link to post
Share on other sites

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 by markdc

Share this post


Link to post
Share on other sites
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.


Best Regards

Share this post


Link to post
Share on other sites
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.


Best Regards

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by oldpa

Share this post


Link to post
Share on other sites

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 by Frederick

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×