Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/O Code)
 Sub-Forums Mod

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
sr_erick 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.
<
15   L A T E S T    R E P L I E S    (Newest First)
top Posted - 22 October 2014 : 10:40:07
I can not get the code for multiple sub-forums
All text and download links are not working Is there one that helps people in code code for the sub-forum with an explanation of the additions necessary?
Carefree Posted - 23 December 2008 : 23:46:47
Carefree Posted - 23 December 2008 : 23:21:28
Carefree Posted - 23 December 2008 : 22:57:31
Here, AnonJr. I created a bottom-to-top instruction for post_info.asp; maybe it'll save you some work.

quote:
Starting at the end of Post_Info.asp:
 
	(1) Look for the lines marked O (old) at the line numbers provided.

	(2) Replace them with the lines marked N (new).
1520	
O
		strSql = strSql & " SET CAT_ID = " & cLng("0" & Request.Form("Category"))
N
		'	#### Sub-Forums Mod ####
		strSql = strSql & " SET CAT_ID = " & cLng("0" & intSetCategory)
		'	#### Sub-Forums Mod ####

1516
O
	if Err_Msg = "" then
N
	if Err_Msg = "" then
		'	#### Sub-Forums Mod ####
		'Update parent id
		if isnull(intSetParent) = FALSE then
				strSQL = "UPDATE " & strTablePrefix & "FORUM SET F_PARENT = " & intSetParent & " WHERE FORUM_ID = " & Forum_ID
		else
				strSQL = "UPDATE " & strTablePrefix & "FORUM SET F_PARENT = NULL WHERE FORUM_ID = " & Forum_ID
		end if
		my_Conn.Execute(strSQL)
		'End parent mod code -- JUST MAKE SURE YOU CHANGE THAT request.form variable!
		'	#### Sub-Forums Mod ####


1450
O
			strSql = strSql & " SET CAT_ID = " & cLng("0" & Request.Form("Category"))
N
		'	#### Sub-Forums Mod ####
			strSql = strSql & " SET CAT_ID = " & cLng("0" & intSetCategory)
		'	#### Sub-Forums Mod ####

1442
O
			strSql = strSql & " SET CAT_ID = " & cLng("0" & Request.Form("Category"))
N
		'	#### Sub-Forums Mod ####
			strSql = strSql & " SET CAT_ID = " & cLng("0" & intSetCategory)
		'	#### Sub-Forums Mod ####

1435
O
			strSql = strSql & " SET CAT_ID = " & cLng("0" & Request.Form("Category"))
N
		'	#### Sub-Forums Mod ####
			strSql = strSql & " SET CAT_ID = " & cLng("0" & intSetCategory)
		'	#### Sub-Forums Mod ####

1418
O
			strSQL = strSQL & " WHERE CAT_ID=" & cLng("0" & Request.Form("Category"))
N
		'	#### Sub-Forums Mod ####
			strSql = strSql & " WHERE CAT_ID = " & cLng("0" & intSetCategory)
		'	#### Sub-Forums Mod ####

1390
O
		strSql = strSql & " SET CAT_ID = " & cLng("0" & Request.Form("Category"))
N
		'	#### Sub-Forums Mod ####
		strSql = strSql & " SET CAT_ID = " & cLng("0" & intSetCategory)
		'	#### Sub-Forums Mod ####

1384
O
		bolCatIDChanged = (cSTr(rsCatIDCheck("CAT_ID")) <> ChkString(Request.Form("Category"), "SQLString"))
N
		'	#### Sub-Forums Mod ####
		bolCatIDChanged = (cSTr(rsCatIDCheck("CAT_ID")) <> ChkString(intSetCategory, "SQLString"))
		'	#### Sub-Forums Mod ####

1377
O
	if Err_Msg = "" then
N
	if Err_Msg = "" then
		'	#### Sub-Forums Mod ####
		'Parent Location Stuff MOD
		'## Forum_SQL - Update forum parent and cat_id in db
		'We changed lines from request.form("Category") to intSetCategory
		'Update parent id
		if isnull(intSetParent) = FALSE then
 		 	strSQL = "UPDATE " & strTablePrefix & "FORUM SET F_PARENT = " & intSetParent & " WHERE FORUM_ID = " & Forum_ID
		else
			strSQL = "UPDATE " & strTablePrefix & "FORUM SET F_PARENT = NULL WHERE FORUM_ID = " & Forum_ID
		end if
		my_Conn.Execute(strSQL)
		'End parent mod code -- JUST MAKE SURE YOU CHANGE THAT request.form variable!
		'	#### Sub-Forums Mod ####

1289
O
		strSql = strSql & Cat_ID
N
		'	#### Sub-Forums Mod ####
			strSql = strSql & intSetCategory
		if isnull(intSetParent) = FALSE then
			strSql = strSql & ", " & intSetParent
		end if
		'	#### Sub-Forums Mod ####

1270
O
		strSql = strSql & "(CAT_ID"
N
		strSql = strSql & "(CAT_ID"
		'	#### Sub-Forums Mod ####
		if isnull(intSetParent) = FALSE then
				strSql = strSql & ", " & intSetParent
		end if
		'	#### Sub-Forums Mod ####

1168
O
		strSql = strSql & Cat_ID
N
		'	#### Sub-Forums Mod ####
		strSql = strSql & intSetCategory
		if isnull(intSetParent) = FALSE then
				strSql = strSql & ", " & intSetParent
		end if
		'	#### Sub-Forums Mod ####

1146
O
		strSql = strSql & "(CAT_ID"
N
		strSql = strSql & "(CAT_ID"
		'	#### Sub-Forums Mod ####
		if isnull(intSetParent) = FALSE then
				strSql = strSql & ", F_PARENT"
		end if
		'	#### Sub-Forums Mod ####

1108-1110
O
		end if
	end if
end if
N
		end if
	end if
end if
'	#### Sub-Forums Mod ####
'Parent Location Stuff MOD
strParent = replace(request.form("Parent"), "'", "''")
if strParent <> "" then
		strParentType = left(strParent, 1)
		strParentValue = right(strParent, len(strParent) - 1)
end if
if strParentType = "F" then
		'## Forum_SQL - Find the CAT_ID if forum is now a subforum
		strSQL = "SELECT CAT_ID FROM " & strTablePrefix & "FORUM WHERE FORUM_ID = " & strParentValue & ";"
		set rsFindCat = my_Conn.Execute(strSQL)
		if not rsFindCat.eof then
				intCategoryValue = rsFindCat("CAT_ID")
		end if
		set rsFindCat = Nothing
		intSetParent = strParentValue
		intSetCategory = intCategoryValue
else
		intSetParent = NULL
		intSetCategory = strParentValue
end if
'End parent location stuff mod - Change variables below for adding a forum
'	#### Sub-Forums Mod ####


If you'd like, I'll convert all of them into a similar format.<
AnonJr Posted - 31 January 2006 : 10:45:28
I've got a better readme going, I've just got to get the line numbers and code for a standard Snitz installation since all I work with is the SBII implementation (I love having some CSS).

As side note, I've noticed that there are a lot of problems getting it to work with Image's forums... not sure why. Anyway, one problem at a time.

I wish I could give a specific date as to when I'll have something up, but with the increased training needs at work I've been pulled from programming to teaching in order to cover all the new classes that have had to be created. With the volume of work during the day (my regular duties still have to get done as well as all the new classes) I'm exhausted by the time I get home.

Like Visita, all I can say is "soon". <
rabufo Posted - 31 January 2006 : 02:57:50
is there any news about?<
ElPazzo Posted - 23 December 2005 : 04:18:48
did you manage to solve it?<
AnonJr Posted - 15 December 2005 : 09:16:27
I don't know if it will help or not, but about 4 posts down on pg. 6 of this topic I posted up an edited subforum.asp and over here I'd put together some other minor fixes.

Add them if they help, disregard them if you've got a better solution for the same problem. I'd intended to take over this project and get something released, and then I got swamped at work and hadn't really touched it much since. I'm going on vacation soon and had planned to work on it some then... but I've been planning a lot and not doing much lately. (I feel like the Vista team )

If you need any help, let me know. Post up what you got. I think one of us ought to gather all the scattered work thats been done and put up a good beta 2 version for those looking to add this. That way there isn't 9 pages of posts to go through to find all the bug fixes et al.<
Bassman Posted - 15 December 2005 : 04:23:29
please do<
cladon Posted - 15 December 2005 : 03:10:32
yes<
FlorisMark Posted - 14 December 2005 : 18:34:07
I've got nearly everything working now, the links on the frontpage, the colorschemes etc. Still working on the new forum bug....

I have written everything down that I had to change, is it interesting to place it here?<
AnonJr Posted - 13 December 2005 : 08:20:10
There is a function in subforums.asp called "ForumSubForums(ForumID)" - just place it where you want the list to show.

Alternatly you could look at this thread where its explained, and an alternate method. If you've got questions, just put them here. <
FlorisMark Posted - 13 December 2005 : 07:29:16
I have changed the colorscheme in Subforums.asp to make the table look better, the only lines I can't fix are the lines around the moderatorbox whenever there is no moderator.

I can now move sub-forums to another forum, it shows up in a new table with the right colors . Can you tell me how to show the sub-forums on the default forum page?

I still can't post new forums.... It's killing me ... <
FlorisMark Posted - 08 December 2005 : 13:47:15
link to new post.txt. http://www.froude.tudelft.nl/postnew.txt<
AnonJr Posted - 08 December 2005 : 12:48:56
Try using a text comparison tool like TextDiff (its something like that...). It may be something very simple and small like a missing "& _"

When I get home tonight I'll put up a text copy of my post.asp. IS filters all FTP access at work...<

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.07