Web Wiz Support and Community Forums : Several forums - one memberbase https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 13 Apr 2026 21:57:03 +0000 Wed, 14 Dec 2005 16:09:54 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=11602 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Several forums - one memberbase : I am working on this very same...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post95331.html#95331 Author: jeffdaro
Subject: 11602
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.
]]> Wed, 14 Dec 2005 16:09:54 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post95331.html#95331 <![CDATA[Several forums - one memberbase : I told you I&#039;d forgotten...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post95306.html#95306 Author: DiffToRegister
Subject: 11602
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_OrderASC;"

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
]]> Wed, 14 Dec 2005 05:11:05 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post95306.html#95306 <![CDATA[Several forums - one memberbase : Hi Maddog, can you please send...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post94546.html#94546 Author: fathom
Subject: 11602
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?
]]> Tue, 29 Nov 2005 11:16:57 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post94546.html#94546 <![CDATA[Several forums - one memberbase : Well thanks to all of the contributers,...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post80060.html#80060 Author: DiffToRegister
Subject: 11602
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
]]> Tue, 29 Mar 2005 12:23:03 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post80060.html#80060 <![CDATA[Several forums - one memberbase : I know, but I want to set All...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post66984.html#66984 Author: FreeMen
Subject: 11602
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...

]]> Wed, 06 Oct 2004 04:20:16 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post66984.html#66984 <![CDATA[Several forums - one memberbase : There are two types of Announcements...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post66982.html#66982 Author: WebWiz-Bruce
Subject: 11602
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)
]]> Wed, 06 Oct 2004 04:10:58 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post66982.html#66982 <![CDATA[Several forums - one memberbase : This thing works like a charm... But...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post66980.html#66980 Author: FreeMen
Subject: 11602
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!?

]]> Wed, 06 Oct 2004 03:57:01 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post66980.html#66980 <![CDATA[Several forums - one memberbase : Sorry... Found out. Never worked...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post64509.html#64509 Author: FreeMen
Subject: 11602
Posted: 01 September 2004 at 9:23am

Sorry...

Found out.

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

Thanks!

]]> Wed, 01 Sep 2004 09:23:51 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post64509.html#64509 <![CDATA[Several forums - one memberbase : Got a problem. Now I&#039;ve...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post64507.html#64507 Author: FreeMen
Subject: 11602
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...

]]> Wed, 01 Sep 2004 09:05:21 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post64507.html#64507 <![CDATA[Several forums - one memberbase : Sorry... I see now... Thanks!!!...]]> https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post64280.html#64280 Author: FreeMen
Subject: 11602
Posted: 26 August 2004 at 4:38am

Sorry...

I see now... Thanks!!!

]]> Thu, 26 Aug 2004 04:38:20 +0000 https://forums.webwiz.net/several-forums-one-memberbase_topic11602_post64280.html#64280