Save products to multiple databases

[radu34]

I have multiple different oscommerce stores, but one of them is the main store with the main database.

The rest are using different databases (but the same content) and i want to do the following:

 

When adding a product or a category in the main store, the same product/category to be added in the others.

 

I added an $_databases configuration array in the admin/includes/configure.php, like this:

 

$_databases = array (

array(

'DB_SERVER' => "localhost",

'DB_DATABASE' => "osc1",

'DB_SERVER_USERNAME' => "user1",

'DB_SERVER_PASSWORD' => "pass1",

),

array(

'DB_SERVER' => "localhost",

'DB_DATABASE' => "osc2",

'DB_SERVER_USERNAME' => "user2",

'DB_SERVER_PASSWORD' => "pass2",

),

array(

...

),

);

 

and then in categories.php, after

if ($action == 'insert_product') {

and after

$sql_data_array = array_merge($sql_data_array, $insert_sql_data);

, before adding the product in the DB, i do a foreach on $_databases, and for each db configuration array,

i open a new mysql link and add the product; after that i close the link and the insert the product in the main db.

 

I do something like this:

foreach ($_databases as $db) {

tep_db_connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD'], $db['DB_DATABASE']);

// do the processing

tep_db_close();

}

I tried it using persistent connections also, because all the connections had the same mysql_link code.

I tried using different names for connections with the $link param:

tep_db_connect($db['DB_SERVER'], $db['DB_SERVER_USERNAME'], $db['DB_SERVER_PASSWORD'], $db['DB_DATABASE'], 'other_link');

and at the end, tep_db_close('other_link');

 

It doesn't work at all.

It either inserts in the main db only, or it inserts in one of the secondary databases only, but not in all.

 

I know this isn't the best way i could do it, because it implies processing of the parent categories also, which i partially handle at this point, but the problem is that i cannot make the product be inserted in all databases.

 

Any idea would be appreciated.

Thanks in advance!

[web-project]

what about orders, settings for every store? are they stored in the same main database?