Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - Multi Forum
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Multi Forum

 Post Reply Post Reply
Author
gbarcelo View Drop Down
Newbie
Newbie


Joined: 30 January 2005
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote gbarcelo Quote  Post ReplyReply Direct Link To This Post Topic: Multi Forum
    Posted: 30 January 2005 at 7:53pm

Hello all,

Am working on a website that needs 5 forums, one for every city… but shares the all the members. Any suggestions on doing this.

I was thinking of creating a common.mdb with tblAuthor, tblBanlist, tblbuddylist, tblconfiguration, tblDateTimeFormat, tblGroup, tblGuestname, tblPermission, tblPMMessage, tblSmut and a city1.mdb with tblCategory, tblEmailNotify, tblForum, tblPoll, tblPollChoice, tblThread, tblTopic.

And repeat the same for city2, city3, city4, city5.

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 30 January 2005 at 8:55pm
I'd recommend using SQL Server for that and make use of table prefixes thus keep the same for the author table, doing this in jet will cause lots of code changes.
Back to Top
gbarcelo View Drop Down
Newbie
Newbie


Joined: 30 January 2005
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote gbarcelo Quote  Post ReplyReply Direct Link To This Post Posted: 30 January 2005 at 9:37pm
make use of table prefixes thus keep the same for the author table?

Can you please explan this
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 30 January 2005 at 9:47pm
I think it would be easier to just use the same database and create forum categories then add other forums as sub forums.

Then use an IIS URL Rewrite mod to change the URLs so it looks like different forums but its actually the same forum and database.
Back to Top
gbarcelo View Drop Down
Newbie
Newbie


Joined: 30 January 2005
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote gbarcelo Quote  Post ReplyReply Direct Link To This Post Posted: 31 January 2005 at 6:14pm
Thanks Maddog,

City1
    Sub1
       Sub1.1
       Sub1.2
     Sub2
       Sub1.1
       Sub1.2
Then do the same with city2, 3 and so on...

Now can you explain the IIS rewrite mod
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.