| Author |
 Topic Search  Topic Options
|
onlinetracker 
Newbie
Joined: 07 March 2005
Status: Offline
Points: 30
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Category Question
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.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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
|
|
onlinetracker
Newbie
Joined: 07 March 2005
Status: Offline
Points: 30
|
Post Options
Thanks(0)
Quote Reply
Posted: 21 March 2006 at 5:13pm |
|
|
|
ljamal
Mod Builder Group
Joined: 16 April 2003
Status: Offline
Points: 888
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
onlinetracker
Newbie
Joined: 07 March 2005
Status: Offline
Points: 30
|
Post Options
Thanks(0)
Quote Reply
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-.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
