Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Hosting many forums in the same DB
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

anakreon
Starting Member

6 Posts

Posted - 16 September 2002 :  07:28:36  Show Profile
I downloaded version 34_03 and looked at the README.html.
It says that if I need to have more than one forums than I should change
the table prefix from FORUM_ to something else.
Does this mean that I need to have many version of config.asp for each
forum in the DB?
I gues this is necessery because strTablePrefix can have only one value.

Can someone provide a longer description of how to host more than one
forum in the same Database.

I am using MSSQL 2000

Thanks in advanced

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 September 2002 :  08:02:05  Show Profile  Send ruirib a Yahoo! Message
Basically the only thing you need to host several forums in a SQL Server DB is to have a different copy of the code in a separate folder for each forum. Of course, you need to change config.asp for each forum, so that the table prefixes are different. After changing config.asp just run setup.asp to create the forum and you're done.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

anakreon
Starting Member

6 Posts

Posted - 16 September 2002 :  08:50:19  Show Profile
Thanks for the advice.
I think that if the schema is altered it could support many forums
whithout the table prefix stuff.
Having many copies of the same files it doesn't look like a good idea.
I hope the developers will concider this.

In our site there are 12 databases for each forum we had.
I wrote a SQL script to concat all the databases in one.
However I don't want the user to visit the "All Forums" link.

The fast solution is to disable the "All Forums" link and this is what
I did.

Thanks for the advice again.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 16 September 2002 :  11:25:29  Show Profile
Since the configuration data is stored in Application variables, you need each forum folder to be it's own web application or else the configuration settings will apply to all forums.

======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.37 seconds. Powered By: Snitz Forums 2000 Version 3.4.07