I am trying to add the usergroup mod security to gelliot's privae forum version of the RSS feed. I am adding this code.
'####### Begin UserGroup MOD #######
strDeniedForums = Session(strCookieURL & "DeniedForums" & MemberID)
if strDeniedForums <> "" and strDeniedForums <> "-1" then
strSql = strSql & " AND F.FORUM_ID NOT IN(" & Session(strCookieURL & "DeniedForums" & MemberID) & ") "
end if
'####### End UserGroup MOD #######
behind this in the rss.asp
strSql = strSql & strAllowedForums
So it looks like this
strSql = strSql & " WHERE T.FORUM_ID = F.FORUM_ID"
strSql = strSql & strAllowedForums
'####### Begin UserGroup MOD #######
strDeniedForums = Session(strCookieURL & "DeniedForums" & MemberID)
if strDeniedForums <> "" and strDeniedForums <> "-1" then
strSql = strSql & " AND F.FORUM_ID NOT IN(" & Session(strCookieURL & "DeniedForums" & MemberID) & ") "
end if
'####### End UserGroup MOD #######
if Request.QueryString("FORUM_ID") <> "" then
strSql = strSql & " AND T.FORUM_ID = " & cLng(Request.QueryString("FORUM_ID"))
end if
I am having a brain freeze. I am sure there is more I need to mod to make it work. I don't even think those I can pass those variables to the Usergroup since they probably not available to select since inc_header.asp isn't included. Gelliott or anyone else have any ideas? Would be a sweet addition to the mod.