Latest News: (loading..)
Sign in to follow this  
Followers 0
anderskiel

pbpBB2 and osC shared account creation

214 posts in this topic

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.

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


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

Share this post


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

Share this post


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

Share this post


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

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
Most likely your shop has its own database.

 

 

The forums and shop share the same database.

Share this post


Link to post
Share on other sites

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!

Share this post


Link to post
Share on other sites

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.

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites

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?

Share this post


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

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  
Followers 0