Web Wiz Support and Community Forums : Category Question https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 19:21:27 +0000 Fri, 24 Mar 2006 12:16:12 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=18835 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Category Question : You would need to create this...]]> https://forums.webwiz.net/category-question_topic18835_post102244.html#102244 Author: WebWiz-Bruce
Subject: 18835
Posted: 24 March 2006 at 12:16pm

You would need to create this as a mod, check the mods forum it has not been done already.]]> Fri, 24 Mar 2006 12:16:12 +0000 https://forums.webwiz.net/category-question_topic18835_post102244.html#102244 <![CDATA[Category Question : Instead of adding an additional...]]> https://forums.webwiz.net/category-question_topic18835_post102218.html#102218 Author: onlinetracker
Subject: 18835
Posted: 23 March 2006 at 9:15pm

 
 Instead of adding an additional thread, I'm just going to post here.
 
 I'm interested in making it so that when you click on a category, it displays ONLY that category and its contents. Right now, when you click on any category it displays all categories (without content) and the chosen category contents broken down more.
 
 Is this an option that I've not located or is this a Mod?
 
Thanks, btw, again, great job -boRg-.
]]> Thu, 23 Mar 2006 21:15:25 +0000 https://forums.webwiz.net/category-question_topic18835_post102218.html#102218 <![CDATA[Category Question : It did have this but is was removed...]]> https://forums.webwiz.net/category-question_topic18835_post101919.html#101919 Author: WebWiz-Bruce
Subject: 18835
Posted: 21 March 2006 at 5:36pm

It did have this but is was removed for performance reasons.

Although it is still wise to set the correct order in the admin section as there are many other parts that issue will happen if forum orders are not correctly set.

I'm going to look at implementing a system for the final version that will auto set the category and forum order, for those people who overlook doing this in the admin section.
]]> Tue, 21 Mar 2006 17:36:59 +0000 https://forums.webwiz.net/category-question_topic18835_post101919.html#101919 <![CDATA[Category Question : Replacing this strSQL = &#034;&#034;...]]> https://forums.webwiz.net/category-question_topic18835_post101918.html#101918 Author: ljamal
Subject: 18835
Posted: 21 March 2006 at 5:32pm

Replacing this 

strSQL = "" & _

"SELECT " & strDbTable & "Category.Cat_ID, " & strDbTable & "Category.Cat_name, " & strDbTable & "Forum.Forum_ID, " & strDbTable & "Forum.Sub_ID, " & strDbTable & "Forum.Forum_name, " & strDbTable & "Forum.Forum_description, " & strDbTable & "Forum.No_of_topics, " & strDbTable & "Forum.No_of_posts, " & strDbTable & "Author.Username, " & strDbTable & "Forum.Last_post_author_ID, " & strDbTable & "Forum.Last_post_date, " & strDbTable & "Forum.Password, " & strDbTable & "Forum.Locked, " & strDbTable & "Forum.Hide, " & strDbTable & "Permissions.View_Forum " & _

"FROM " & strDbTable & "Category" & strDBNoLock & ", " & strDbTable & "Forum" & strDBNoLock & ", " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & " " & _

"WHERE " & strDbTable & "Category.Cat_ID = " & strDbTable & "Forum.Cat_ID " & _

     "AND " & strDbTable & "Forum.Forum_ID = " & strDbTable & "Permissions.Forum_ID " & _ 

     "AND " & strDbTable & "Forum.Last_post_author_ID = " & strDbTable & "Author.Author_ID " & _

     "AND (" & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & " OR " & strDbTable & "Permissions.Group_ID = " & intGroupID & ") " & _

"ORDER BY " & strDbTable & "Category.Cat_order, " & strDbTable & "Forum.Forum_Order;"

with this 


strSQL = "" & _

"SELECT " & strDbTable & "Category.Cat_ID, " & strDbTable & "Category.Cat_name, " & strDbTable & "Forum.Forum_ID, " & strDbTable & "Forum.Sub_ID, " & strDbTable & "Forum.Forum_name, " & strDbTable & "Forum.Forum_description, " & strDbTable & "Forum.No_of_topics, " & strDbTable & "Forum.No_of_posts, " & strDbTable & "Author.Username, " & strDbTable & "Forum.Last_post_author_ID, " & strDbTable & "Forum.Last_post_date, " & strDbTable & "Forum.Password, " & strDbTable & "Forum.Locked, " & strDbTable & "Forum.Hide, " & strDbTable & "Permissions.View_Forum " & _

"FROM " & strDbTable & "Category" & strDBNoLock & ", " & strDbTable & "Forum" & strDBNoLock & ", " & strDbTable & "Permissions" & strDBNoLock & ", " & strDbTable & "Author" & strDBNoLock & " " & _

"WHERE " & strDbTable & "Category.Cat_ID = " & strDbTable & "Forum.Cat_ID " & _

     "AND " & strDbTable & "Forum.Forum_ID = " & strDbTable & "Permissions.Forum_ID " & _ 

     "AND " & strDbTable & "Forum.Last_post_author_ID = " & strDbTable & "Author.Author_ID " & _

     "AND (" & strDbTable & "Permissions.Author_ID = " & lngLoggedInUserID & " OR " & strDbTable & "Permissions.Group_ID = " & intGroupID & ") " & _

"ORDER BY " & strDbTable & "Category.Cat_order, "& strDbTable & "Category.Cat_ID, " & strDbTable & "Forum.Forum_Order;"


should make the display on default.asp more accurate.]]> Tue, 21 Mar 2006 17:32:38 +0000 https://forums.webwiz.net/category-question_topic18835_post101918.html#101918 <![CDATA[Category Question : Gotcha, thanks. ]]> https://forums.webwiz.net/category-question_topic18835_post101915.html#101915 Author: onlinetracker
Subject: 18835
Posted: 21 March 2006 at 5:13pm

 
 Gotcha, thanks.
]]> Tue, 21 Mar 2006 17:13:11 +0000 https://forums.webwiz.net/category-question_topic18835_post101915.html#101915 <![CDATA[Category Question : You will get problems like this...]]> https://forums.webwiz.net/category-question_topic18835_post101914.html#101914 Author: WebWiz-Bruce
Subject: 18835
Posted: 21 March 2006 at 5:09pm

You will get problems like this if you don't correctly set the order of forums and categories in the admin area.

It's just the way the coding now works, if the correct order for forums and categories is not set it screws things up throughout the board
]]> Tue, 21 Mar 2006 17:09:14 +0000 https://forums.webwiz.net/category-question_topic18835_post101914.html#101914 <![CDATA[Category Question : Okay, so here is my situation....]]> https://forums.webwiz.net/category-question_topic18835_post101913.html#101913 Author: onlinetracker
Subject: 18835
Posted: 21 March 2006 at 5:02pm

 
 Okay, so here is my situation. I have 2 Categories, 3 Forums, and 3 Sub-Forums in a brand new, unmodded 8.0 installation.
 
The Structure is:
 
Category 1
   Forum 1a
     Sub-Forum 1
     Sub-Forum 2
     Sub-Forum 3
   Forum 1b
 
Category 2
   Forum 2a
 
However, when they display on the site [outside of the admin console] they show up as:
 
Category 1
   Forum 1a
     Sub-Forum 1
     Sub-Forum 2
     Sub-Forum 3
 
Category 2
   Forum 2a
 
Category 1
   Forum 1b
 
 
I thought that Categories are supposed to rope any Forum configured for a category, into that category and nothing will display outside of it.
 
Hope that clears up my previous question.
 
Thanks for the quick response btw... sorry I posted this originally in the wrong Forum.
]]> Tue, 21 Mar 2006 17:02:27 +0000 https://forums.webwiz.net/category-question_topic18835_post101913.html#101913