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)
 multiple sites, same database, feasible or no?
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Addicted2HD
Starting Member

21 Posts

Posted - 28 June 2007 :  14:48:34  Show Profile
Hi,

I am involved with an organization that plans to have a broad website on a particular subject with other supporting sites that are more specific within the subject.

What I would like to be able to do is have multiple installations of Snitz run from the same database so that I can customize the "wrapper" of each board. I would configure the board to have a category for each subject and link to the corresponding category for each respective site.

For example, the overall site would link to:
http://127.0.0.1/forum/

which would display all categories and forums

Then, the more specific sites would link to something like this:
http://127.0.0.2/forum/default.asp?CAT_ID=2
http://127.0.0.3/forum/default.asp?CAT_ID=3

etc.

If I set the config.asp file correctly for each installation is it safe for all installations to run from the same database or is there a technical concern that I should be aware of?

If this isn't feasible then I will just run the whole board from something like forums.somesite.com.

TIA

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 28 June 2007 :  17:14:11  Show Profile  Send ruirib a Yahoo! Message
You can have several sites in the same database as long as you specify different table headers in config.asp for each forum. To have those different sites running properly, you should use MySQL or SQL Server as the database. If you do that, I see no problems at all.


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

Addicted2HD
Starting Member

21 Posts

Posted - 29 June 2007 :  11:32:17  Show Profile
Thanks for the reply. I am using MSSQL for the database, but I was looking to use the same tables on all sites so that users registered at one could login at the others as well.
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 29 June 2007 :  11:38:31  Show Profile  Send ruirib a Yahoo! Message
I lost you there... If you use the same tables, what's the point of having different boards / sites?
Also, the problem with using the same user tables is that a visit to a single site will change the last visit date to all the sites.


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

Addicted2HD
Starting Member

21 Posts

Posted - 02 July 2007 :  17:12:28  Show Profile
Yeah, I realize this is probably a bit unorthodox, but there is a reason. The multiple boards will be under the umbrella of one master topic, but each site will specialize in a sub-category under the master topic. Each site will have it's own specific look and I want to be able to apply that look at the sub category level to match the site it's on. Of course each site will have to ability to back out to the "All Forums" level and view all sub category topics which I'm not worried about. All users will be able to log in at each site with the same user/pass no matter which site they signed up on. As long as I don't have to worry about something breaking because of doing this then I'm ok with the possible limitations it brings as well.

Does that make any more sense? It's probably as hard to understand what I want to do as it is for me to explain it.

TIA
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 02 July 2007 :  17:21:46  Show Profile  Send ruirib a Yahoo! Message
Yeah, it's possible to have multiple forums on the same DB. The only caution is for you to change all three table prefixes in config.asp for each new forum. Once you setup a new forum, change the strMemberTablePrefix so that the user table for the original forum is used. You can delete the new user table once the forum is setup.

If you do this, you should not have any problems.


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

Addicted2HD
Starting Member

21 Posts

Posted - 02 July 2007 :  21:18:26  Show Profile
Cool. Thanks for the help/assurance.
Go to Top of Page

gary b
Junior Member

USA
267 Posts

Posted - 03 July 2007 :  00:02:09  Show Profile  Visit gary b's Homepage
quote:
The multiple boards will be under the umbrella of one master topic, but each site will specialize in a sub-category under the master topic. Each site will have it's own specific look and I want to be able to apply that look at the sub category level to match the site it's on.

Please excuse this interruption... I must be dense, because I cannot picture this scenario. Perhaps that stems from a misunderstanding on my part. I thought the top-level in the hierarchy was category... followed by forums... followed by topics... followed by replies. But that is not what I infer from what you said [above]. Discounting the "unique look and feel" for each of your proposed sites, wouldn't setting up your "sites" as categories be simpler? That is, unless you do not want your Users to see the other categories.

Our "board" uses eight or nine "categories" with each category broken out into ten or eleven "forums" -- each with its associated topics and replies. If you would like to see what I am trying to describe, send me an email and I will forward the URL for our board (forum).

If I am complicating the issue, please excuse the post. But to my mind, you can do what you want to do (minus the cosmetics) with no changes whatsoever.

Or am I having a massive brain cramp?

Go to Top of Page

Addicted2HD
Starting Member

21 Posts

Posted - 03 July 2007 :  14:26:02  Show Profile
Gary, nope you're right on. I am having a really hard time getting the concept across I think partly due to the generalities perhaps.

Maybe this will help. I have a subject (I'll call it "Subject") with sub-subjects (I'll call these sub-sub1, sub-sub2, etc.). Below is how I envision the sites to exist in the future.

Subject.com (mother site -- entry into "forums" from this site brings the user to the very top level of the forums showing all "categories")
sub-sub1.com (sub subject #1 -- entry into "forums" form this site brings the user to the sub subject 1 "category" of the discussion board)
sub-sub2.com (sub subject #2 -- entry into "forums" form this site brings the user to the sub subject 2 "category" of the discussion board)
etc.

I understand I will likely have to modify some functions or hide them on the sub-subject sites (all forums link for instance), but this is a small price to pay to accomplish what is a more important goal. I will try to post a working example once the next 2nd site is up and running.

Does this make more sense now?
Go to Top of Page

gary b
Junior Member

USA
267 Posts

Posted - 03 July 2007 :  21:46:02  Show Profile  Visit gary b's Homepage
Email sent containing URLs.

gary b
Go to Top of Page

rkp
New Member

59 Posts

Posted - 19 September 2007 :  08:59:27  Show Profile
I am contemplating this scenario.

Say I have a city...

and I have division's in the city, as we know there are.

Parks, Water, Waste, Fire, Police, etc.

If I set the categories respective of each can I lock out a parks employee from accessing the Waste Category forums? Can I use the registration process to set the hierarchy? Of course city manager's and department head's would benefit from having access to each category. Is there a mod with a category profile designator, a rank designator and a forum designator available anywhere?

gotta run..
Go to Top of Page

rkp
New Member

59 Posts

Posted - 04 December 2007 :  09:36:01  Show Profile
Anyone contemplate this in to compilation?
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts

Posted - 04 December 2007 :  09:38:53  Show Profile
Private forums are what you're looking for; it's a standard feature.


Search is your friend
“I was having a mildly paranoid day, mostly due to the
fact that the mad priest lady from over the river had
taken to nailing weasels to my front door again.”
Go to Top of Page

rkp
New Member

59 Posts

Posted - 04 December 2007 :  09:57:13  Show Profile
quote:
Originally posted by Shaggy

Private forums are what you're looking for; it's a standard feature.





Wow that was quick.. Thanks, I'll look at it.
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.36 seconds. Powered By: Snitz Forums 2000 Version 3.4.07