Contributions

The sql file was incorrect for the latest version of mysql. It should read as follows:
create table trans_phpbb ( osCsid char(32)not null default '', sess_uid int(11)not null default '0', sess_uip char(8)not null default '', sess_logged int(1)not null default '0' , sess_trans char(32)not null default '' , primary key (sess_uid))
TYPE=MyISAM ;
zip file is empty

- v1.3 -

* Bug fixed - catalog/create_account.php didn't log trans_phpbb session data into database after account creation form successfully submitted, which caused the new customer cannot login to forum, nor can he logout from store.
* Bug fixed - Posting new message prior to login would redirect users to the login form in the forum. Fixed phpbb2/login.php to redirect all login attempts to the osCommerce login page.
* Bug fixed - The login code in catalog/login.php came with the original phpbb2.0.8a integration contribution updated the user_session_time and user_lastvisit fields in phpbb_users table incorrectly, which caused the new posts icon not working properly. Fixed catalog/login.php not to use the correct time to update the user_lastvisit field, and not to update user_session_time on login. Now the new posts icon works.
* Bug fixed - catalog/logoff.php skipped to kill session if no data found in trans_phpbb table. Now it kills session no matter if the trans_phpbb session record exists or not.
----------------------------------------------------
Full package

* Added to kill hacking attempts which called up register page directly by spam bots.
* Added to delete phpBB2 user records when deleting customers in osCom admin.
* Commented out deleting user in phpBB admin page. Now can only delete customer and user account at the same time in osCom admin page.
-------------------------------------------------------
Full package

Revised the install guide for better instructions regarding how to prepare before install.
-------------------------------------------------------
A Bug fixed in this update:
-------------------------------------------------------
The IP obtaining method was not working 100%, due to the different methods uses by osCommerce and phpBB2 - fixed.

-------------------------------------------------------
Improvements in this update:
-------------------------------------------------------
Added to eliminate hacking attempts by faking the trid value, and databse injections as well.

Added to check the osCommerce session expiry.

osCommerce session lifetime cut down to 2 hours for security reason.
---------------------------------------------------
Full package.

Amended the Install.html again for typo

Full package

Only changed the Install.html.
--------------------------------
Fixed typos in
STEP 2.5
STEP 2.6

Changed in
STEP 2.7
STEP 2.15

--------------------------------
Full package.

Based on pbpBB2 and osC shared account creation v0.2 by anderskiel
and PHPBB 2.0.8a implementation in oscommerce ms2 by chaveiro
and partially from phpBB-osCommerce Bridge version 1.1 by gabrielk
....
This is for integrating phpBB into osCommerce, including following features:
---------------------------------------------
* Shared database. Only one MySQL database needed for both osCommerce and phpBB. phpBB installation will create its own tables in your existing database.
* Shared account creation. Accounts are all created in osCommerce, and mirrored to phpBB. Users register new accounts in phpBB will be redirected to use the create_account.php form in osCommerce. Existing osCommerce customers' data will be inserted to phpBB automatically when they login next time.
* Shared login/logoff and secured by IP checking. Unified login page, and stay logged in/off when switching from osCommerce to phpBB and vise cersa. Coded to check user IP when switching side. The quick login in phpBB has been standardized to use email address. osCommerce session time lengthened from 24mins to 24hrs, to keep users logged in with osCommerce when accessing phpBB. Auto login option in phpBB removed to prevent logging in users to cart unaware. This is to make your site more user friendly, no need to login again when switching sides, and keep everything seamless as a single website.
* Added Username in account creation. Username field has been added to the create account form in osCommerce. This username is required, and will check existing usernames in database for collision. Old customers will have their usernames generated automatically when they login the next time, with first name + last initial + random 4-digit number.
* Synchronized account info. Users can change their email address and password from either osCommerce or phpBB, and automatically synchronized on the other side.
* phpBB admin secured by using .htaccess password protection, don't need to login phpBB prior to access admin page anymore.
* Compatible with Ultimate SEO URLs in the first place. Don't need to modify seo codes.
------------------------------------------------
This contribution is to fully integrate phpBB into osCommerce. Users will not notice a thing when switching from one side to the other. Extra security check hardcoded to prevent hacking. Minimized file modifications for easier installation.
------------------------------------------------
This contribution was developed with phpBB 2.0.21, and updated to 2.0.22 at the last minute before releasing. If you have phpbb 2.0.21 installed, you can apply this contrib manually by using file comparing tools like WinMerge.
------------------------------------------------
Support Thread :http://forums.oscommerce.com/index.php?showtopic=225900&st=28

1. I have fixed the problems with the login name for the forum, by creating a seperate forum
username field on the create_account.php page.

2. Forum registration is now obtional when registering for the cart. if a user later desides to use
the forum a link to the forum registration page is provided at the top of create_account.php

3. The 'add old users to forum on login to cart' has been removed as forum registration is now obtional

4. Other bits of unnessesary code has been removed.

This is a variation of chaveiro's PHPBB 2.0.8a implementation.

It creates one account for forum and cart. By forcing forum users to register via the cart registrationform. Upon registration, customer can choose to go to forum or cart. Login is needed in the forum. But login name is email and password from the cart registration.

This implementation uses the newest phpbb2.21 and osCommerce 2.2.