| Author |
 Topic  |
|
sr_erick
Senior Member
USA
1318 Posts |
 Posted - 16 April 2004 : 13:44:43
|
Ok, I think this has been discussed in the past, but I'm not sure where it went, or what ever happened to the idea. Basically the way this forum works (to my understanding) you have a tree structure like the following:
Discussion Area
-Categories
--Forums
---Topics
----Posts
My proposed Idea is to do something similar to what vBulletin does with thier Sub-Forum idea. Basically a sub-forum inside a forum, and then you can have more sub-forums inside of sub-forums, however deep you want. I have come really need something like this on my website, and have been thinking about it for quite some time.
The result would be something like the following:
Discussion Area
- Category
-- Forum
--- Topic
---- Post
--- SubForum
---- Topic
------ Post
---- SubForum
----- Topic
------- Post
Notice how SubForum sits inside of Forum and the green tree(another subforum) sits inside the first SubForum which is in the Forum. I'm not sure if anyone has a mod already, or whats going on, but if not I'm going to start working on/organizing such a mod because I think it would be most helpfull for me, and many others.
Basically all I think a person would need to do is create another column in the FORUM_FORUMS table (I think that's the one) which would specify a parent forum (Its ID). All forums falling directly under the main categories would have no value, so they would be "root" forums.
Let me know what you think.
< |
Erick
Snowmobile Fanatics
|
Edited by - sr_erick on 16 April 2004 13:51:11 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 16 April 2004 : 16:51:40
|
quote:
Basically all I think a person would need to do is create another column in the FORUM_FORUMS table (I think that's the one) which would specify a parent forum (Its ID). All forums falling directly under the main categories would have no value, so they would be "root" forums.
That's exactly the way I was thinking of it while reading your thread. Same as you, I've seen a lot of requests, but no solutions.
I don't need it on my site (that I can think of  ) but I'm happy to test it for you.< |
 |
|
|
altisdesign
Junior Member
United Kingdom
357 Posts |
Posted - 16 April 2004 : 17:42:33
|
Sounds good. You would probably have to modify various functions with regard to deleting forums, so if you delete the forum containing a sub forum what happens etc. But its only minor details. As far as I know invisionboard only allows one level of subforum.. I can see that being a useful add on for Snitz. Personally I would never use more than one level of subforum, and it would be more complicated to code, but if you think it would be useful to have sub-sub forums it would be a great additional feature for the mod  .< |
Altis Design offers all manner of web design services to a variety of commercial and personal clients |
|
|
|
Jezmeister
Senior Member
United Kingdom
1141 Posts |
Posted - 16 April 2004 : 17:44:39
|
| ive never seen one either, i wouldnt mind testing it either - it could be a useful addition to 123 Chat forums...< |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 16 April 2004 : 20:09:20
|
| I'll probably get started on it this weekend, if I have time.< |
Erick
Snowmobile Fanatics
|
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 16 April 2004 : 22:14:20
|
| OneWayMule, that's an insane amount of subforums. I'd only use it for 1 or two, to try keep my default page smaller.< |
Erick
Snowmobile Fanatics
|
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 17 April 2004 : 05:15:52
|
You can look at goand.net and how it's done there.
This is not a snitz forum, but it was once and worked the same way when it was < |
De Priofundus Calmo Ad Te Damine |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 18 April 2004 : 02:12:17
|
| Should I restrict it to one Sub level or make it virtually unlimited?< |
Erick
Snowmobile Fanatics
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 18 April 2004 : 03:13:19
|
I decided to go unlimited levels, just for future expansion....unless others are against it. I have an issue though...
To get the correct navigation for a subforum in a subforum, I got the looping to work, but it does it backwards, and either it's too late for me to think, but I can't figure out how to get it to go the other way around. Here's what I have.
strSql = "SELECT PARENT_ID, F_SUBJECT FROM " & strTablePrefix & "FORUM WHERE FORUM_ID = " & Forum_ID & ";"
set rsSForum = my_Conn.Execute (StrSql)
if rsSForum.eof or rsSForum.bof then
'#Do Nothing
else
strTempParentPath = rsSForum("PARENT_ID")
do until strTempParentPath = 0
strSql = "SELECT PARENT_ID, F_SUBJECT FROM " & strTablePrefix & "FORUM"
strSQL = strSQL & " WHERE FORUM_ID = " & strTempParentPath & ";"
set rsSForum2 = my_Conn.Execute (StrSql)
if Cat_Status <> 0 then
Response.Write getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""")
else
Response.Write getCurrentIcon(strIconFolderClosed,"","align=""absmiddle""")
end if
Response.Write " <a href=""forum.asp?FORUM_ID=" & rsSForum("PARENT_ID") & """>"
Response.Write rsSForum2("F_SUBJECT") & "</a><br />"
Response.Write getCurrentIcon(strIconBlank,"","align=""absmiddle""")
Response.Write getCurrentIcon(strIconBar,"","align=""absmiddle""")
strTempParentPath = rsSForum2("PARENT_ID")
loopcount = loopcount + 1
loop
rsSForum.Close
set rsSForum = Nothing
end if
If this can't easily be solved I'll just forget the multi-level subforum in subforum, etc..
BTW, here is a link to what I have so far. http://www.dbfanatics.com/newforum/default.asp Go into the shop area.< |
Erick
Snowmobile Fanatics
|
Edited by - sr_erick on 18 April 2004 03:18:45 |
|
|
|
DavidRhodes
Senior Member
United Kingdom
1222 Posts |
Posted - 18 April 2004 : 14:13:02
|
| Do you need to order by the F_ORDER column IN FORUM_FORUM?< |
The UK MkIVs Forum |
|
|
|
wii
Free ASP Hosts Moderator
Denmark
2632 Posts |
Posted - 18 April 2004 : 16:28:37
|
| This change will make it harder for newbies to use the forum, I wouldn´t recommend this change because of lower usability.< |
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 18 April 2004 : 16:31:58
|
quote:
Originally posted by wii
This change will make it harder for newbies to use the forum, I wouldn´t recommend this change because of lower usability.
I wouldn't nessesarily say this. It's a rather simple concept to understand and anyone with a general logical understanding of folder structures should be able to figure it out.< |
Erick
Snowmobile Fanatics
|
|
|
|
Nertz
Junior Member
Canada
341 Posts |
Posted - 19 April 2004 : 08:20:11
|
Eric, I had a look at the link you posted, and I think it looks great. I would however suggest, if it is possible and not too hard, to show the number of subforums in the table cell under the description of the forum. Eg., beneath the description of the "Shop", 3 subforums.
Keep up the great work, looking forward for its release.
cheers,
Nat< |
Sadly, most Family Court Judges wrongfully reward opportunistic gold diggers
that use our children unjustly as "instruments" of power.
www.fathers-4-justice-canada.ca |
|
|
|
Etymon
Advanced Member
United States
2385 Posts |
|
|
Topic |
|
Sub-Forums Mod
