Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Multiple WWF Domains with One Account
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Multiple WWF Domains with One Account
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
redtide View Drop Down
Newbie
Newbie


Joined: 07 February 2004
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote redtide Quote  Post ReplyReply Direct Link To This Post Topic: Multiple WWF Domains with One Account
    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?
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
redtide View Drop Down
Newbie
Newbie


Joined: 07 February 2004
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote redtide Quote  Post ReplyReply Direct Link To This Post 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. 



Edited by redtide
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.