sr_erick's Sub-forums MOD - Posted (9700 Views)
Forum Moderator
AnonJr
Posts: 5768
5768
sr_erick's Sub-forums v0.2.2b
This MOD will allow you to add one level of sub-forums to your forums.
Ever since sr_erick was kind enough to share his work on this with me, I've been working to clean it up for release. I know that a few people have been interested in something like this and I'd like to put something back into the community... for a change.
This has only been tested with the base code and SBII, using Access on both.
As for the zip, it contains an updated readme and a new version of the subforum code.
I'll try to keep a link to the most current code in this post.
If you would like to see it in action, go over to the Warsong Records forum.
Enjoy!
------------------------------------------
  • 07 Feb 2006 - Added the display fix Bassman made for the Standard Code version
  • 27 Feb 2006 - Fixed a problem with post counts over what an Int can handle (as noted in post 14)
------------------------------------------

You can download a copy here.
You can see the original discussion here.<
 Sort direction, for dates DESC means newest first  
 Page size 
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
It may have been part of an update I was working on then... unfortunately, my file server is down and I don't have access to said files.

I'll try to take a look at this when I get home tonight. If you could, please post a link to a *.txt copy of default.asp, forum.asp, and inc_subforums.asp<
Posted
Starting Member
bitwise2000
Posts: 38
38
Here's the original:
http://content.penturners.org/inc_subforum.txt

Here's my modified version to hide subforums based on the value of F_PrivateForums and strDBNTUserName.
http://content.penturners.org/inc_subforum-new.txt

I added some code to the loop that builds the list of subforums. That works.
What doesn't work is restricting access based on password. So if you set the forum to members only password protected, you don't get the challenge for the forum pswd before you get access. That's a separate issue that has to be addressed in forum.asp. I don't use password protected hidden forums, so it's not an issue for me, but it should be addressed to work correctly.<
Posted
Average Member
modifichicci
Posts: 787
787
there is not an option for hidden forum with password.. my modification use chkDisplayForum from inc_func_secure. it works as the forum is hidden to users not allowed. (I don't see the forum hidden you post.. and the link bring me to default)<
Posted
Starting Member
bitwise2000
Posts: 38
38
Here's my quick and very dirty workaround for the subforum column headers being displayed in the parent forum when all the subforums are invisible to the user. The right way is of course to rewrite the sub ListSubForums so that it doesn't write the column headers right off the bat, only if there's at least one subforum visible to the user.

I didn't want to rewrite the entire ListSubForums sub so I just wrote a function to check to see if there are any subforums visible to the user and if not to exit that sub.

Code:

Function OneVisibleForum(FORUM_ID)
' Is there at least one visible forum under this parent? OneVisibleForum = false
strSQL = "SELECT F.FORUM_ID, F.F_PRIVATEFORUMS, F.F_PASSWORD_NEW " & _
"FROM " & strTablePrefix & "FORUM F " & _
"WHERE F.F_PARENT = " & FORUM_ID & " AND F.F_TYPE = 0;"
set rs = my_Conn.Execute(strSQL)
if not rs.eof then
do until rs.eof
intPrivateForum = rs("F_PRIVATEFORUMS")
strPasswordNew = rs("F_PASSWORD_NEW")
intForumID = rs("FORUM_ID")
intMemberID = getMemberID(strDBNTUserName)
if intMemberID = 0 then intMemberID = -1
if chkDisplayForum(intPrivateForum, strPasswordNew, intForumID, intMemberID) then
OneVisibleForum = true
exit do
end if
rs.movenext
loop
end if
set rs = nothing
end Function

Then I use this like so

Code:
sub ListSubForums(FORUM_ID)

If Not OneVisibleForum(FORUM_ID) then Exit Sub

etc., etc.<
Posted
Average Member
modifichicci
Posts: 787
787
That is very strange.. I have replied to bitwise2000 post 21 February 2008 : 17:33:18

i have posted without login, inserting id and pass, but my reply is shown before the post I have replied..<
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
Were you in a cool De Lorean at the time? tongue<
Posted
Starting Member
OJJE
Posts: 15
15
How well does this mod work with the latest version of Snitz forum and MySQL? Does anybody have the updated files or are the files on Snitzbitz the latest release of this MOD?<
Posted
Forum Moderator
AnonJr
Posts: 5768
5768
The files on Snitzbitz.com are the latest released files. I've used it in 3.4.06 forums with only a few minor issues that have existed from the get-go. I've been meaning to add better support for MySQL but I just haven't had the time... work kicked into high gear and just hasn't stopped. =/ One way to add some better MySQL support has been posted here, as have other changes.<
You Must enter a message