Sharing data base info

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
Sonic98
Forum Newbie
Posts: 16
Joined: Tue Dec 17, 2002 8:55 pm
Contact:

Sharing data base info

Post by Sonic98 »

have 3 databases on my sites: one for chatrooms, IM, and forums. How can I make it so you don't have to login to each seperately? Once people sign up for the forum(which is really overall page sign-up) I don't want them to have to register again for IM. Is there a way to just copy the username and password tables from the forum database to the IM database?

The table for the IM is called users. The Table for the forum is called ibf_members. The password fields are both called password but the fields for the usernames have different names.

Would it be as simple as using the forum data base instead of a seperate database for the IM then adding the one field "chatdata" that is not included in both?
User avatar
Elmseeker
Forum Contributor
Posts: 132
Joined: Sun Dec 22, 2002 5:48 am
Location: Worcester, MA

Multiple DB's

Post by Elmseeker »

Is there a way to just copy the username and password tables from the forum database to the IM database?
I wish it was as easy as all that. It ALMOST is but then again it ALMOST isn't...You also ned get the session or cookie info from your forum. The way you have things set up now if you just copied the username and password fields when a user creates an account on the forums it would also create one in chat and IM. However, they not login to all of them at once simply by supplying that user name and password on one of them. for that you'd need make sure that all 3 systems are using the same cookie and/or session info.
User avatar
AVATAr
Forum Regular
Posts: 524
Joined: Tue Jul 16, 2002 4:19 pm
Location: Uruguay -- Montevideo
Contact:

besto solution

Post by AVATAr »

i supouse (im gessing here) that systems have some kind of autentication function... so the best solucion is to modify that function to use only on DB to check. Use for example the forum DB from de IM and chatrooms..

:wink:
Post Reply