<% '################################################################################# '## Snitz Forums 2000 v3.4.06 '################################################################################# '## Copyright (C) 2000-06 Michael Anderson, Pierre Gorissen, '## Huw Reddick and Richard Kinser '## '## This program is free software; you can redistribute it and/or '## modify it under the terms of the GNU General Public License '## as published by the Free Software Foundation; either version 2 '## of the License, or (at your option) any later version. '## '## All copyright notices regarding Snitz Forums 2000 '## must remain intact in the scripts and in the outputted HTML '## The "powered by" text/logo with a link back to '## http://forum.snitz.com in the footer of the pages MUST '## remain visible when the pages are viewed on the internet or intranet. '## '## This program is distributed in the hope that it will be useful, '## but WITHOUT ANY WARRANTY; without even the implied warranty of '## MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the '## GNU General Public License for more details. '## '## You should have received a copy of the GNU General Public License '## along with this program; if not, write to the Free Software '## Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. '## '## Support can be obtained from our support forums at: '## http://forum.snitz.com '## '## Correspondence and Marketing Questions can be sent to: '## manderson@snitz.com '## '################################################################################# %> <% if Session(strCookieURL & "Approval") <> "15916941253" then scriptname = split(request.servervariables("SCRIPT_NAME"),"/") Response.Redirect "admin_login.asp?target=" & scriptname(ubound(scriptname)) end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & " All Forums
" & vbNewLine & _ " " & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderOpen,"","align=""absmiddle""") & " Admin Section
" & vbNewLine & _ " " & getCurrentIcon(strIconBlank,"","align=""absmiddle""") & getCurrentIcon(strIconBar,"","align=""absmiddle""") & getCurrentIcon(strIconFolderOpenTopic,"","align=""absmiddle""") & " Forum Deletion/Archival

" & vbNewLine strWhatToDo = request("action") if strWhatToDo = "" then strWhatToDo = "default" end if Select Case strWhatToDo Case "updateArchive" if Request("id") = "" or IsNull(Request("id")) then Response.write "

There has been a problem!

" & vbNewLine & _ "

No Forums Selected!

" & vbNewLine & _ "

Go back to correct the problem.

" & vbNewLine WriteFooter Response.End end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
Administrative Forum Archive Schedule

    " & vbNewLine reqID = split(Request.Form("id"), ",") for i = 0 to ubound(reqID) tmpStr = "archSched" & trim(reqID(i)) if tmpStr = "" then tmpStr = NULL strSQL = "UPDATE " & strTablePrefix & "FORUM SET F_ARCHIVE_SCHED = " & cLng("0" & Request.Form(tmpStr)) strSQL = strSQL & " WHERE FORUM_ID = " & cLng("0" & trim(reqID(i))) my_conn.execute(strSQL),,adCmdText + adExecuteNoRecords Response.Write "
  • Archive Schedule for " & GetForumName(reqID(i)) & " updated to " & Request.Form(tmpStr) & " days.
  • " & vbNewLine next Response.Write "

" & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine & _ "
" & vbNewLine & _ " Back to Forums Administration

" & vbNewLine Case "default" '################ ARCHIVE Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
Administrative Forum Archive Functions
Archive Reminder:
" & vbNewLine strForumIDN = request("id") if strForumIDN = "" then strsql = "SELECT CAT_ID, FORUM_ID, F_L_ARCHIVE,F_ARCHIVE_SCHED, F_SUBJECT FROM " & strTablePrefix & "FORUM ORDER BY CAT_ID, F_SUBJECT DESC" set drs = my_conn.execute(strsql) thisCat = 0 if drs.eof then Response.Write " No Forums Found!" & vbNewLine else Response.Write "
" & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine do until drs.eof if (IsNull(drs("F_L_ARCHIVE"))) or (drs("F_L_ARCHIVE") = "") then archive_date = "Not archived" else archive_date = StrToDate(drs("F_L_ARCHIVE")) end if Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine thisCat = drs("CAT_ID") drs.movenext loop Response.Write " " & vbNewLine & _ " " & vbNewLine & _ " " & vbNewLine & _ "
" & drs("F_SUBJECT") & " archive schedule: " & " days" & "
" & vbNewLine & _ "
" & vbNewLine end if set drs = nothing Response.Write "
" & vbNewLine & _ "
" & vbNewLine & _ "
Back to Forums Administration

" & vbNewLine end if end Select WriteFooter Response.End Function GetForumName(fID) '## Forum_SQL strSql = "SELECT F.F_SUBJECT " strSql = strSql & " FROM " & strTablePrefix & "FORUM F" strSql = strSql & " WHERE F.FORUM_ID = " & fID set rsGetForumName = my_Conn.Execute(strSql) if rsGetForumName.bof or rsGetForumName.eof then GetForumName = "" else GetForumName = rsGetForumName("F_SUBJECT") end if set rsGetForumName = nothing end Function %>