2 OSCommerce-1SQL

[ASDCO]

Somebody said there was a thread here about doing this but I cant find it.

Im only allowed 1 db on my sql server. I set up a store on it then I transferred all my store files to a sub domain to set up a different store,the catalog works perfect but heres my prob.I go to my second (sub domain store)admin to set up the catalog and when I select a file it sends me to the 1st stores files(main domain store)I cant set up the second store separately. Anyone have a fix?or know where that thread is hiding? thx

[peterr]

Hi,

 

Not too sure if I understand what you need. That is, you say that only one db is allowed, and then ask why you can only see the one db. :unsure:

 

Anyway, usually sub domains work like this:

 

http://yoursubdomain/example.com

 

would point to ...........

 

/home/username/public_html/yoursubdomain/

 

path, so you would need to specify in the /yoursubdomain/ path, in the configure.php, etc, the path name to the db,etc.

 

Hope that helps,

 

Peter

[Guest]

if you check includes/database_tables.php it references all the files used within osCommerce. to use one database with two stores, the first store uses the original tables. for the new store, you would preceed the filenames with something like store2_filename.php

and in the configure.php you point to the same database, same password, etc. so store2 has all the tables preceeded with store2

 

Original:

define('TABLE_ADDRESS_BOOK', 'address_book');

define('TABLE_ADDRESS_FORMAT', 'address_format');

define('TABLE_BANNERS', 'banners');

 

New:

define('TABLE_ADDRESS_BOOK', 'store1_address_book');

define('TABLE_ADDRESS_FORMAT', 'store1_address_format');

define('TABLE_BANNERS', 'store1_banners');

[Guest]

you would also have to change the sql installation file to make these respective changes

[Guest]

I am doing this with the Database Prefix Contribution. Just install each osCommerce with a different prefix. This may interfere with other contributions however. For example I can't use the Admin Level Contribution now.