Web Wiz Forums - Multiple WWF Domains with One Account

Print Page | Close Window

Multiple WWF Domains with One Account

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9621
Printed Date: 07 April 2026 at 11:49pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Multiple WWF Domains with One Account

Posted By: redtide
Subject: Multiple WWF Domains with One Account
Date Posted: 07 February 2004 at 9:30pm

I would like to run WWF on 4 domains and 4 SQL databases, but have it so that users can have one account for all domains. This will prevent them from having to have separate accounts for each domain.

Any suggestions on how this can be done?

Replies:

Posted By: WebWiz-Bruce
Date Posted: 08 February 2004 at 3:27am

That may not be very simple.

An easier solution would be to run all 4 forums from the same SQL server database, but use only 1 authors table.

The way this could be done is.

In the common.asp files there is a variable that holds the table and stored procedure prefixes so that multiple forums can run from the same MS SQL DB. Make these prefixes different for each forum.

Now is the more difficult part. You will need to run some sort of global search and replace on each forum so that each of the forums will use the same tblAuthors table.

I've never tried it myself, but should in theory work.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: redtide
Date Posted: 08 February 2004 at 11:13pm

Ok, that looks like a good suggestion. I'll work with that. Does this also apply to the stored procedures? Do I need to have different sets of stored procedures for each instance of the database?

----Update----

Never mind. I figured it out. You edit the two variables in the msSQL_server_setup.asp script and it does it all for you.