How to link 3 databases together

I have a game website and mp3 site and Dolphin i want to know how can make it so when they sign up for Dolphin they automatic sign up for the game and mp3 site  like something i can do with the database

Help Plz and thanks

any one help plz

I think you have to do some programming where when user login to dolphin and then go to game site then they will be logged in for ur game or MP3 pages.

Your can do this by using the session variable for dolphin logged in user into game pages.

if im not wrong.

hope it'll give some idea.

Use Synchronization in phpmyadmin.

It takes a little more than that to have user A sign up for web site A, B and C.

Just sync table Profile right after signup.

I didn't know that every web script had the same database, table and entry structure as Dolphin.

File
/inc/classes/BxDolProfilesController.php
Line
155
Add
//--- Creating new user in database B ---//        
$dbhb = mysql_connect("SERVER", "USER", "PASSWORD", true);
mysql_select_db("DATABASE", $dbhb) or die(mysql_error());

$sQueryB = "INSERT INTO `Profiles` SET \n$sSet";
mysql_query( $sQueryB, $dbhb );

mysql_close($dbhb);

Make sure the user ID auto increment values are synchronized.

I have NOT tested this.

 are you sure will try thanks

Should be line 155.

I have just tested it and it works.

You have to enable Database B to accept foreign connections. e.g., comment out bind-address = 127.0.0.1 in /etc/my.cnf

By the way, my method is to post to a database on a foreign server.

Well, the table's a bit messy. Let me test some more.

 ok tell me how it gose and write the list of things you done

Are the databases on different servers?

 yea  Game MP3 and Dolphin

 sorry no same server

Do you require a unified login?

/DM

 what do you mean like recaptcha if yes only for Mp3 and dolphin

Nope.

If you login at the dolphin site - you automatically log into the other sites.

OR

You only require the other sites to be automatically joined - the individual logins are still retained.

/DM

no you have to join and login in to the game site mp3 site and also Dolphin i'm try to make it so when you login at the dolphin site - you automatically log into the other sites ( or when you join )

This is a unified login.

I can outline the basic steps that you need to consider, but it is not a simple straightforward modification to do, it will involve modifying all three scripts, and potentially applying a patch to existing users.

There are a number of different ways of achieving the same goal here. But in essence you need to use the dolphin user authentication to grant access to the other scripts.

This can take one of two different forms - if the other scripts are relatively simple and do not store user-data or have user-data that can be taken from Dolphin (avatars, etc), it may be enough just to substitue the Dolphin authentication in place of the existing authentication within the scripts. Thus if the mp3 script requires a logged in user to be able to download / view a file - the dolphin authentication process provides the details (user_logged). You will also need to replace the user-data (avatars etc) within the script where necessary.

However, if the script stores user-data that you need to retain, then you will have to do a bit more.

You will need to add in the user creation portion of the script into the dolphin user creation process - so that when a Dolphin user is created, an mp3 (or game) user is also created. Then you will need to write a bridge, so that when the Dolphin user is authenticated, the equivalent mp3 user is also authenticated. This will allow you to retain the functionality of each of the scripts, whilst only having a single login. This will likely involve a new database table to cross reference the users and modification of the scripts authentication process to achieve. You will still need to substitute the common user-data such as avatars etc with the dolphin ones.

In both cases, you will also need to disable the logins for the game / mp3 sites, and remove any aspects that are replaced by the dolphin features.

The last point to consider, is that if you have an existing user-base, you may need to retrospectively apply any bridges to these users.

All in all it is a lot of work, and will require a working knowledge of all three scripts to successfully achieve.

HTH

/DM

Have you tried "Replication" in MySql?