Multiple Sites - One Member DBase

Basically, as mentioned above, there is a variable for table prefix in the common.asp file. The problem is it will append that prefix to the users table as well. So in the code, you can do one of the following:

1. remove the table prefix variable from every reference to the users table

2. Hard code a new prefix for every reference to the users table

3. Create a new variable to store a prefix to the users table and then modify every reference of the original table prefix to the users table to use the new variable.

I would REALLY like to see the code base changed to use option 3.

If they all use the same table prefix they will all have the same forums and message database as well. Each site should have its own prefix for messages and a common one for the users if that is what you are trying to accomplish.

I am doing this, and it works well.  You need to do some modding to get this to work though.

This mod is NOT for non-programmers.  Since each project is unique, I can't just give you code.  But here is the steps you need to take.  If you don't know what I am talking about, then this mod is not for you. 

Note: This is not the only way to do it, but this method does work.

You do the following:

1. Install and set-up WWF like normal.
2. Set-up your DNS so that multiple domains point to the same copy of WWF.
3. At the end of common.asp, use server variables to detect what domain name is being used and set a variable you will key on later.
4. If you want to change certain variables based on the domain name, do so here using if then statements.  The variables you set wll override the variables in the database if you do this at the end of common.asp.  This is useful if you want one domain to have one forum name, and another domain name to have a different forum name, for example.
5. If you want certain forums to display on certain domain names, you will need to create a field in the database that specifies this.  How you stucture it will depend on what you are trying to accomplish.  Alternately, you could hard code it in the default.asp page instead of using a database field.
6. Change default.asp so that it displays the correct forums for the correct domains by using if then statements based on the domain (using the variable you set at the end of common.asp) and the field you put in the database.  If you don't use a field in the database, then you will need to hard code your preferences.
7. All the other pages should work fine without modifications if you used my method of overriding the database variables in step 4.

I hope that helps and good luck.

I did the same thing migrating from Snitz.  I baught a copy of MS Access 2003 Upgrade.  And then I imported

Forum_Members, Forum_Reply, Forum_Topics

from my Snitz Database into my WWF database.  I reregistered all ny users with the same info and 12345 password at my WWF site.  I had 13 posts and 52 replys.  So I made 13 posts and 523 replys.  Not all cuz it would take to long to retype.  Just aaaa subject and bbbb message.

Cuz the database table are all related.  It is easier to copy stuff in with the appropriate # of fields rather than make new ones.

Then in Access under tbl_Author added E-Mail address and what ever else except passwords cuz they are encrypted.  I looked at the Author_ID in there copyed it to a notepad file.  The ID and corresponding name. 

In tbl_Topic I copied the Topic_ID Forum_ID and Subject to a note pad file.

Or Paint works to.  Print Screen and paste in Paint.

I wrote down the Forum_ID from the Snitz site with 13 topics and the corresponding subjects somewhere. 

I filled the Subject colum in the tbl_topic with the new ones from Forum_Topics in T_Subject colum which I had imported from the Snitz database. 

I also copied the T_Message colum to the right of T_Subject colum as they'll now be considered replys. 

Then I opened tbl_Thread and in the Message colum I pasted the stuff I just copied from T_Message in the Forum_Topics into the Message colum.

Then I opened Forum_Reply which I imported from the Snitz Database.  And I copied the whole R_Message coloum and pasted it right under the ones I just added in tbl_Thread in the Message colum.

Save the whole database.  Make a backup if U have to now. 

Then in tbl_Thread just match the Topic_ID and Author_ID with the Notepad files U saved.

Seems like a lot but I did it in 1 day.  And I'm no expert.