Print Page | Close Window

Several forums - one memberbase

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=11602
Printed Date: 13 April 2026 at 9:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Several forums - one memberbase
Posted By: FreeMen
Subject: Several forums - one memberbase
Date Posted: 23 August 2004 at 5:27am

Let's see if I can explain this right...

I want to run multiple forums for different kinds of people, but with just one memberdatabase. Is this possible and if so, how?

Example:
We got a mainsite, where you sign up and then some subsites with their own forum.

When you sign up, you sign up to all subsites, but they still run seperately, with categories.

Help!




Replies:
Posted By: MadDog
Date Posted: 23 August 2004 at 2:34pm

Its possible, but would require some modification and hard code.

I did it between http://www.aspinvision.com/forum - http://www.aspinvision.com/forum and http://www.invisionportal.com/forum - http://www.invisionportal.com/forum



-------------
http://www.iportalx.net" rel="nofollow">


Posted By: MadDog
Date Posted: 23 August 2004 at 7:06pm

Maybe i should explain how lol ....

Make a new category for each "forum" you are setting up. Then add the forums you want. Then for each copy of the forum you have to edit default.asp and in the SQL statements you have to do a WHERE statement on Cat_ID = (ID of the category for that forum).

Basically i have http://www.aspinvision.com/forum - http://www.aspinvision.com/forum to show only a single category, but on http://www.invisionportal.com/forum - http://www.invisionportal.com/forum i have it set to display all the categories. So the two websites share the same table and members.



-------------
http://www.iportalx.net" rel="nofollow">


Posted By: FreeMen
Date Posted: 24 August 2004 at 7:52am

Oh, I see...

I'll give at try!

Thanks for your help, MadDog...

I might return with some ????



Posted By: FreeMen
Date Posted: 24 August 2004 at 7:55am

Btw...

Is it possible to have different desig on each forum this way?



Posted By: dpyers
Date Posted: 24 August 2004 at 11:13am
I think If you'll look at the links MadDog posted, you'll answer your own question.

-------------

Lead me not into temptation... I know the short cut, follow me.


Posted By: MadDog
Date Posted: 24 August 2004 at 2:47pm
Originally posted by FreeMen FreeMen wrote:

Btw...

Is it possible to have different desig on each forum this way?

Of course. The websites are using completly different code. The only thing they share is a DB.



-------------
http://www.iportalx.net" rel="nofollow">


Posted By: FreeMen
Date Posted: 26 August 2004 at 4:38am

Sorry...

I see now... Thanks!!!



-------------
http://www.tomtom-user.dk - TomTom-User.dk
Running WWF SQL with more than 32.000 members...


Posted By: FreeMen
Date Posted: 01 September 2004 at 9:05am

Got a problem.

Now I've switched to SQL...

How is this done here? Not the same I found out...



-------------
http://www.tomtom-user.dk - TomTom-User.dk
Running WWF SQL with more than 32.000 members...


Posted By: FreeMen
Date Posted: 01 September 2004 at 9:23am

Sorry...

Found out.

Never worked with SQL before, but found a StoredProcedure...

Thanks!



-------------
http://www.tomtom-user.dk - TomTom-User.dk
Running WWF SQL with more than 32.000 members...


Posted By: FreeMen
Date Posted: 06 October 2004 at 3:57am

This thing works like a charm...

But when I make an announcement in one section, I just want it to show there an not in alle the other sections!?

Can this be done!?



-------------
http://www.tomtom-user.dk - TomTom-User.dk
Running WWF SQL with more than 32.000 members...


Posted By: WebWiz-Bruce
Date Posted: 06 October 2004 at 4:10am
There are two types of Announcements you need to sellect:-

Announcement (this forum)

and not:-

Announcement (all forums)


-------------
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: FreeMen
Date Posted: 06 October 2004 at 4:20am

I know, but I want to set All forums and then only get it to show in the 10 categories assignet to that section...

I have devided my database into 9 sections, where if you enter section A on my website you only see cat id 1-10, Section B = cat id 11-20 and so on...

So I want to make an announcement in all forums in Section A but not in section B...

Hope you get this!?

To do so I used StoredProcedures to devide...



-------------
http://www.tomtom-user.dk - TomTom-User.dk
Running WWF SQL with more than 32.000 members...


Posted By: DiffToRegister
Date Posted: 29 March 2005 at 12:23pm
Well thanks to all of the contributers, above.  I've got the forums filtered by category.  Using the same skin, though.
My version of WWF is 7.9, using MSAccess.
 
My process was:
1.  Add the new Categories to the Categories table.
1.5 Oh, and add forums to those Categories.
2.  Create a cookie in my own application saving the Category number that the user is going to use.  This will be our filter Response.Cookies("COG")("C") = "4", for example
3.  As mentioned many times above, changed Default.asp:
  • (Line 117?) Obtain filter

intCatShow = Request.Cookies("COG")("C")

  • (Line 133?) Apply SQL filter to Categories shown.

strSQL = "SELECT " & strDbTable & "Category.Cat_name, " & strDbTable & "Category.Cat_ID FROM " & strDbTable & "Category WHERE " & strDbTable & "Category.Cat_ID = " & intCatShow & " ORDER BY " & strDbTable & "Category.Cat_order ASC;"

4.  Oh, had to change the search function too!  See search_form.asp:

  • (Line 167?) Add to SQL Where clause our cookie category filter

strSQL = "SELECT " & strDbTable & "Forum.* FROM " & strDbTable & "Forum WHERE " & strDbTable & "Forum.Cat_ID = " & Request.Cookies("COG")("C") & " ORDER BY " & strDbTable & "Forum.Cat_ID ASC, " & strDbTable & "Forum.Forum_Order ASC;"

  • (Line 161?) Comment out HTML default "select all" option:

(Better not paste html in here)

  • I wreckon I've missed something...  Erm, later...
Well that's all folks!
 
ian_scho


Posted By: fathom
Date Posted: 29 November 2005 at 11:16am
Hi Maddog,

can you please send me an example of your default.asp file so I can see exactly where to edit the CAT=ID bit?


Posted By: DiffToRegister
Date Posted: 14 December 2005 at 5:11am
I told you I'd forgotten something:

4.  Change the search engine to filter by category.
  • In search_form.asp - following from the example above (Line 165?).
strSQL = "SELECT " & strDbTable & "Forum.* FROM " & strDbTable & "Forum WHERE " & strDbTable & "Forum.Cat_ID = " & Request.Cookies("COG")("C") & " ORDER BY " & strDbTable & "Forum.Cat_ID ASC, " & strDbTable & "Forum.Forum_Order ASC;"

5.  Change Active Topics to filter by category.
  • In active_topics.asp add the following (Line 286?), just in front of the ORDER BY clause:
strSQL = strSQL & " AND tblCategory.Cat_Id = " & Request.Cookies("COG")("C") & " "

ian_scho


Posted By: jeffdaro
Date Posted: 14 December 2005 at 4:09pm
I am working on this very same issue right now. I plan to set up another forum, and I want it to share the same user base. I have a future plan for a site to use the same topic table, etc.

What I am doing is this...Instead of custom coding each page, I am in the process of stripping out the use of strDbTable variable. I am replacing the strDBTable  prefix, and updating it to hold the actual table name. I am doing the same for stored procedures. These table name s are then stored in a config file. This way I can have two forums set up, and tell each to hit MainAuthor as the author table.

Admittedly this is taking a lot of changes to the code, which prevents me from ever upgrading, and I have to make changes in the SP's, but that's OK with me, as I am also converting much of the embedded SQL to SP's anyway.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net