On my site, (http://www.cynikalsam.com) I have a phpbb forum, a Wordpress blog and a Coppermine photo gallery. Each one requires users to register before they can use that feature.

I'm hoping there is a way to integrate the user databases, so that if somone registers for one feature, they automatically have access to all features that require a login.

Ideally, i'd like to have them just register once for my site, log in once, then have access to all features without having to register or log in multiple times to use each feature.

Does anyone have an idea of how to accomplish this? :confused:

I'd use one of your three databases for logging in. For example every new log-in attempt on any of your three sites would create a connection to one specific database, which you choose, wherein your table with the users' data would reside. Then you check the validity of the user's account and open up the features for him. That's the simplest way, IMHO.

Originally posted by cynikalsam

I'm hoping there is a way to integrate the user databases, so that if somone registers for one feature, they automatically have access to all features that require a login.


Not unless you can program in PHP, it's not a trivial task.

Originally posted by itspot
I'd use one of your three databases for logging in. For example every new log-in attempt on any of your three sites would create a connection to one specific database, which you choose, wherein your table with the users' data would reside. Then you check the validity of the user's account and open up the features for him. That's the simplest way, IMHO.

How would i set that up in MySql? I'd like to use my forum user database as the member database for the whole site. Im pretty new to this.

Maybe i'll put it this way;

I'd like to use the phpbb register and login script as the only register and login script for the whole site. By registering, the user information is placed in one database. I'd need to get all the features that require a login to use that database. I suspect this can be done in MySql, but i dont know how to do it.

I guess all the features would have to use the same cookie to maintain sessions between features too.

You have to tweak Wordpress & Coppermine authorization system. Study structure of those programs, learn how user can aothorized and do the same when user logs into phpbb.

You would have to change phpbb also.

Good luck.

cynikalsam

As the previous speaker had said, the task would require some coding. It could be done in any programming language. MySQL database being only the storage of your users' data, the logic of user authentication has to be coded.

The log-in system would look as follows. There'll be one MySQL table residing in one of the three databases. Upon logging in, your application would establish a connection to that database, authenticate the user (by looking up the relevant table), create the appropriate Session Object which shall be recognized on all the three sites.

If you aren't comfortable with programming against the database, I'd advise to find someone who'll help you - because the task requires some basic knowledge in the field.

This is absolutely no issue in Java environment. It's still doable with PHP, but in Java it's no brainer.

Peter Kinev.