central database for all applications

[dutchblues]

Hello,

 

We are building quite a big website on pets with a forum (phpBB), webshop (OSC), newsletter, photo albums, sub-websites managed by members and a lot of content (1,5 gb!). At the current situation we have seperate sql databases for every application, so users will have to create seperate accounts and will log in for every application.

I would like to add quite some extra applications as a webcalender, wiki and other userfull extra's.

 

Before adding new applications I would like to create a new infrastructure for the site based on 1 central database. So users will only have to register and login once.

 

Is the contribution the best solution for us?

pbpBB2 and osC shared account creation

 

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.

 

Some questions:

- Can we modify this database so we can use it for the other applications as well?

- Does this have other consequences?

- Diffeculties with updates?

- What are the do's?

- What are the don'ts?

- Any further tips?

 

I am not a php-programmer but got quit far till now, thanks to this forum and all the contributors!:D

Edited January 31, 2007 by dutchblues