Category Question
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=18835
Printed Date: 12 April 2026 at 7:19pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Category Question
Posted By: onlinetracker
Subject: Category Question
Date 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.
|
Replies:
Posted By: WebWiz-Bruce
Date 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
|
Posted By: onlinetracker
Date Posted: 21 March 2006 at 5:13pm
Posted By: ljamal
Date 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.
-------------
L. Jamal Walton
http://www.ljamal.com/" rel="nofollow - L. Jamal Inc : Web/ Print Design and ASP Programming
|
Posted By: WebWiz-Bruce
Date 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.
|
Posted By: onlinetracker
Date 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-.
|
Posted By: WebWiz-Bruce
Date 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.
|
|