pbpBB2 and osC shared account creation

[Optimalkiller]

phpBB2.0.22 Integration v1.3 update released

• 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 not be able 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 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.
  

 

 

 

Wow fantastic Job your the best!!!!!! keep up the great work.

[Guest]

The phpBB-osCommerce Bridge forces username as firstname + last initial, phpBB2 integration allows any username chosen.

 

phpBB-osCommerce Bridge requires phpBB to be installed under osCommerce catalog folder, and share osCommerce sessions. However, if you login from phpBB, you are not login to osCommerce. phpBB2 integration recommends to install phpBB in a folder aside, and no matter where you login from, you're login to both side.

 

I looked at both and the above is what swung it for me.

 

However :)

 

Would it be possible for the username not to be mandatory, and if left blank to create a dummy user name of firstname + lastnames initial just for people who don't want a forum name?

[AlexStudio]

I looked at both and the above is what swung it for me.

 

However :)

 

Would it be possible for the username not to be mandatory, and if left blank to create a dummy user name of firstname + lastnames initial just for people who don't want a forum name?

I didn't do that for some reason. Since the code forced customers to sign up on both side, they have the right to pick a decent username they like. I just don't like the idea to expose the customer's first name + last initial to the public without they knowing it.

[JakSmit]

Thanks for the info.

So does the username have to be the same for both oscommerce and the forum? If they differ, will they still be logged in on both. Also, does this change osc so that they have to log in with a username on osc instead of an email? I am just thinking how that might affect installation of other contributions some how.

 

Thanks

[AlexStudio]

Thanks for the info.

So does the username have to be the same for both oscommerce and the forum? If they differ, will they still be logged in on both. Also, does this change osc so that they have to log in with a username on osc instead of an email? I am just thinking how that might affect installation of other contributions some how.

 

Thanks

Login from either side will be redirected to the store login form, which is using email address not username.

[jrolson]

Is it possible that when you click the forum link it will open in the middle of the index page?

[AlexStudio]

Is it possible that when you click the forum link it will open in the middle of the index page?

No. But you can customize your phpBB pages looked exact the same as your osCommerce. Only that it would be a lot of works to do.

Edited February 9, 2007 by AlexStudio

[lexsus]

Hi

The login to my forum sends a user to

https://mydomain.org/login.php?redirect=index.php

and not

http://mydomain.org/login.php?redirect=index.php

 

can I change that?

[AlexStudio]

Hi

The login to my forum sends a user to

https://mydomain.org/login.php?redirect=index.php

and not

http://mydomain.org/login.php?redirect=index.php

 

can I change that?

Yes. Actually if you don't have a dedicated SSL certificate, you should use http only.

[lexsus]

Yes. Actually if you don't have a dedicated SSL certificate, you should use http only.

 

I don't have a SSL certificate, but where do i change so it become http?

[AlexStudio]

I don't have a SSL certificate, but where do i change so it become http?

It's in the file phpbb2/includes/trans_osc.php, change:

define('HTTPS_SERVER', 'https://yourdomain.com');

to:

define('HTTPS_SERVER', 'http://yourdomain.com');

[lexsus]

It's in the file phpbb2/includes/trans_osc.php, change:

define('HTTPS_SERVER', 'https://yourdomain.com');

to:

define('HTTPS_SERVER', 'http://yourdomain.com');

i have changed the http but can't login to the forurm i have a test site here http://www.lexsus.eu.org

[AlexStudio]

i have changed the http but can't login to the forurm i have a test site here http://www.lexsus.eu.org

You have installed osCommerce under your http root and phpbb2 under your osCommerce. In this case you need to setup cookie domain and cookie path for both your osCommerce and phpbb2 correctly for this contribution to work.

 

cookie domain for your osCommerce should be '.lexsus.eu.org' (3 dots) with cookie path set to '/'

cookie domain for your phpbb2 should be '.lexsus.eu.org' (3 dots) with cookie path set to '/phpbb2/'

 

Let me know if it still doesn't work.

[candleman]

Thanks for a great contrib. I installed this contrib in a folder called "forum" outside my store folder. I have a live store running out of a folder "shop" I was redoing the store and adding the forum so as not to do it on my live site, I created a folder "store" and basically redid the whole site out of that folder. The forums worked fine at that time.

 

Today I wiped the files from my live shop (in the "shop" folder) and replaced them with the new shop I had done in the "store" folder. I changed the config files to show the new folder name and also changed the trans_osc file to reflect the new folder that the shop was located in. Everything works fine as far as the store goes, but I can't access the forums now from the store when logged in. I get a "Hacking Attempt" warning. This goes for anyone that tries accessing the forums when logged in. I created a new test user and I get the same thing when trying to access the forums from the store. Everything else with the forum seem fine.

 

Have I missed something I need to change? The forum location has not changed only the store.

 

Just to summarize. Everything worked when my shop was in the "store" folder, now the hacking attempt warning after I moved it to "Shop" folder.

 

Thanks for any help.

[AlexStudio]

Most likely your shop has its own database.

[candleman]

Most likely your shop has its own database.

 

 

The forums and shop share the same database.

[candleman]

After reading through the posts in the forums again I figured out what the problem was. When I changed the paths in the Config files from store to shop I used the find and replace, I guess I should have looked a little more carefully at the config file before doing it that way. In the database section I ended up changing

 

define('STORE_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

to this

define('shop_SESSIONS', 'mysql'); // leave empty '' for default handler or set to 'mysql'

 

The sessions were not being stored so the script thought it was a hacking attempt.

 

Lession learned :blush:

 

Thanks again for a great contrib!

[Guest]

Hello Alex,

 

I have tried to install the contribution, I do not have an ssl certificate so I just changed it to http as you have mentioned before.

 

But when I try logging ind, I get a 404 Error with following URL: http://217.195.176.xxx/xxx/login.php?actio...irect=index.php ( NB! I've x'ed out some of the URL )

 

But it does not redirect.

 

What have I done wrong, I really hope you can help me.

[Guest]

Hello Alex,

 

I have tried to install the contribution, I do not have an ssl certificate so I just changed it to http as you have mentioned before.

 

But when I try logging ind, I get a 404 Error with following URL: http://217.195.176.xxx/xxx/login.php?actio...irect=index.php ( NB! I've x'ed out some of the URL )

 

But it does not redirect.

 

What have I done wrong, I really hope you can help me.

 

the file structure is like this:

 

Oscommerce is in root

Forum is also in root in a folder.

 

So there is:

includes

Admin

images

forum

etc

 

I hope it made sense.

[AlexStudio]

The URL is pointing to a wrong path. The target should be your osCommerce login.php.

[Guest]

The URL is pointing to a wrong path. The target should be your osCommerce login.php.

 

Sorry, I did not explain it to well.

 

It is point towards the oscommerce login.

 

If i try to login at oscommerce shop i get the same 404 error as when I try to login at the forum, at it is pointing towards the same URL.

[AlexStudio]

Did this happen before you install this contrib?

[Guest]

Did this happen before you install this contrib?

 

Hey Alex,

 

I think I have solved the problem. It was really stupid. The line in configure.php was a bit wrong.

 

Sorry for taking your time, and thanks for a great contribution.

[Guest]

At the moment i have the forum but it ain't integrated with my store and then i found this contribution. so just need a few things answered first

 

Database should be the same as your osCommerce database. You must not change the phpbb_ database table prefix, otherwise this contrib won't work.

 

My forum and my store have separate db what file do i need to alter in forum files to direct it to the store db?

 

plus at moment my store and forum are in different files one in craftstore one in phbb2

 

so they are like http://mydomain.com/craftstore and http://mydomain.com/phbb2

 

does the forum need to be like http://mydomain.com/craftstore/phbb2 or is it ok as it is?

[AlexStudio]

My forum and my store have separate db what file do i need to alter in forum files to direct it to the store db?

It needs serious re-write to support separated db.

 

plus at moment my store and forum are in different files one in craftstore one in phbb2

 

so they are like http://mydomain.com/craftstore and http://mydomain.com/phbb2

This setup is 100% OK.

 

does the forum need to be like http://mydomain.com/craftstore/phbb2 or is it ok as it is?

This setup is not recommended, but with minor 'fix', it still works.