Sub-Forums Mod - Snitz™ Forums 2000

The Forum has been Updated

The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.

Sub-Forums Mod - Posted 16 Apr 2004 13:44 (18681 Views)

sr_erick

Senior Member

Posts: 1318

1318

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

Last edited by sr_erick on 16 April 2004, 13:51

Posted 16 Apr 2004 16:51

laser

Member Locked

Posts: 3859

3859

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.<

Posted 16 Apr 2004 17:42

altisdesign

Junior Member

Posts: 357

357

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

Posted 16 Apr 2004 17:44

Jezmeister

Senior Member

Posts: 1141

1141

ive never seen one either, i wouldnt mind testing it either - it could be a useful addition to 123 Chat forums...<

Posted 16 Apr 2004 20:09

sr_erick

Senior Member

Posts: 1318

1318

I'll probably get started on it this weekend, if I have time.<

Erick Snowmobile Fanatics

Posted 16 Apr 2004 20:52

OneWayMule

Dev. Team Member & Support Moderator

Posts: 4969

4969

Although I'm, familiar with sub-forums from VB, and to be honest they cause more confusion instead if naking it all more organized; take a look at this forum Looking forward to your work. I hope you'll make it available.

My MODs:
Birthdays - Custom Policy - F.A.Q. Administration - Forum Rules - Guestbook Links Manager - MyOwnGoogle - Profile Views - Search Log - WebSearch
Useful stuff:
Forum and MOD Installation - MOD Installation Guide - Snitz v3.4.05 Readme - Free ASP Hosts - Support Snitz

Posted 18 Apr 2004 03:13

sr_erick

Senior Member

Posts: 1318

1318

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.

Code:


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

Last edited by sr_erick on 18 April 2004, 03:18