linking fields

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
bytte
Forum Commoner
Posts: 75
Joined: Sun Nov 23, 2003 8:20 am
Location: Belgium

linking fields

Post by bytte »

My database has two tables that hold username/password information.
That's because people can actually sign in on 2 different places on my website (one on the forum, the other one on the site itself).

I want to be ablo to link the username/password/email fields in these two tables so that if a user signs up on the website, he can use the same username/pass to log in to the forum and vice versa.

Any idea on how to do that?
User avatar
scorphus
Forum Regular
Posts: 589
Joined: Fri May 09, 2003 11:53 pm
Location: Belo Horizonte, Brazil
Contact:

Post by scorphus »

What have you done so far? Is there some piece of code or some database design?

-- Scorphus
bytte
Forum Commoner
Posts: 75
Joined: Sun Nov 23, 2003 8:20 am
Location: Belgium

Post by bytte »

Thanks.
I'm using a PHPBB forum. I have recently built a website that requires users to log in to have full functionality.

Of course I want users that sign up on the website, can use the same username/pass on the forum. And vice versa: when users sign up on the forum, they should be able to log in to the website as well with the same username/pass information.

I haven't done anything so far. What would be the best option?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

As it can be a pain to modify phpBB's login code to work with another system, having your main site use theirs is the easiest way to set it up.. It'd be even easier if the entire site was actually run through phpBB, as then, all the areas would have its login system already..
bytte
Forum Commoner
Posts: 75
Joined: Sun Nov 23, 2003 8:20 am
Location: Belgium

Post by bytte »

Thanks. I guess you're right. I've spent a few hours trying and in the end I just figured out the best way would be to use their system.
Post Reply