Multiple Installs on single site?

[theditchblairproje]

Just a thought!, I am currently looking at setting up a new forum and was wondering if it was possible to have multiple installs sharing the same password files etc.
Let me explain. I am lookin to set up a travel discussion forum and would like to break it down into continents and then down into countries. I think it may be too large and complicated if i have all the continents and countries on one board.
i.e Asia,Africa,Europe etc a different install for each continent and then break each one down by country.

Is this possible ?

[Hypocrite]

I think it is. You just make one database for users but make the boards to different directories for different countries. So you make one database and then setup all boards to use this database.

[theditchblairproje]

Thanx I will give it a go!

[theditchblairproje]

I think it is. You just make one database for users but make the boards to different directories for different countries. So you make one database and then setup all boards to use this database.

Doesnt work I have installed two boards to use the same database and whatever you post on one shows up on the other.
Back to the drawing board

[Jeff Lewis]

If you're looking to share member databases, you'll need to change some code.  What you'd want to do is make it so that the second install reads the member table from the first install.

[theditchblairproje]

Sounds Like what im looking for. I would like all six boards to read and write to the same member file.
Im new to PHP so is the required code change going to be complicated or is it just a case of tracking down and changing urls ?

thankx

 

[Jeff Lewis]

It will be a little complicated.  once you change one though, you're set for the other 4-5

[theditchblairproje]

How and what do i need to change ?

[Jeff Lewis]

Heh, saw that coming  

If you're familiar with PHP or anything like that, all you need to look at is the queries to the members table.  So you're going to need to use table handles.

Start coding and I'm sure guys will help out if you encounter problems...

To start with, you'll need to add a second connection to the first.  So you connect to the database with messages etc, but you also need to connect to the database hosting the members table.

[theditchblairproje]

totally lost already, i have installed two copies of YABB one in a folder called africa and one asia now all i have to do is make each one read and write to the same members table.
I am new to PHP and Mysql, I have a facility called phpmyadmin should this be what i am using to try and make the databases connect or should i be looking in the YABB files ?

[Christer]

I'm guessing look in the YaBB Files....

PhPMyAdmin is used to create/edit/delete mySQL tables

[theditchblairproje]

Ive now got two boards working off of the same database all i need to do is have both talking to a single members table, i have been looking through the PHP files should i just change every occurence of {$db_prefix}members to in each board to match the one single members table.
and will this ensure both read and write to the same table ?

[Jeff Lewis]

Change that {$db_prefix} to the one where you want it to write to.  Replace that across all files that look at the members table.  make sure you're not overwriting any weird joins (can't think of any offhand).

[theditchblairproje]

Seems to work a treat now!! Im gonna test abit more the only problem i have encountered so far is that when you logout of one forum you are still logged in on the other could it be something to do with the logging perhaps ?
Would it be complicated to make all forums use same log files also ?

[Jeff Lewis]

Well that is the cookies  There are different cookies for each domain