<%
'#################################################################################
'## Copyright (C) 2000 Michael Anderson and Pierre Gorissen
'##
'## 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 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 support forums at:
'## http://forum.snitz.com
'##
'## Correspondence and Marketing Questions can be sent to:
'## reinhold@bigfoot.com
'##
'## or
'##
'## Snitz Communications
'## C/O: Michael Anderson
'## PO Box 200
'## Harpswell, ME 04079
'#################################################################################
%>
<% If Session(strCookieURL & "Approval") = "15916941253" Then %>
<%
if Request.Form("Method_Type") = "Write_Configuration" then
if Request.Form("NumberCategories") <> "" then
i = 1
do until i > cint(Request.Form("NumberCategories"))
SelectName = Request.Form("SortCategory" & i)
if isNull(SelectName) then SelectName = cint(Request.Form("NumberCategories"))
SelectID = Request.Form("SortCatID" & i)
NumberForums = Request.Form("NumberForums" & SelectID)
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "CATEGORY "
strSql = strSql & " SET CAT_ORDER = " & SelectName & " "
strSql = strSql & " WHERE CAT_ID = " & SelectID & " "
my_Conn.Execute (strSql)
if NumberForums <> "" then
j = 1
do until j > cint(Request.Form("NumberForums" & SelectID))
SelectNamec = Request.Form("SortCat" & i & "SortForum" & j)
if isNull(SelectNamec) then SelectNamec = cint(Request.Form("NumberForums" & SelectID))
SelectIDc = Request.Form("SortCatID" & i & "SortForumID" & j)
'## Forum_SQL - Do DB Update
strSql = "UPDATE " & strTablePrefix & "FORUM "
strSql = strSql & " SET F_ORDER = " & SelectNamec & " "
strSql = strSql & " WHERE FORUM_ID = " & SelectIDc & " "
strSql = strSql & " AND CAT_ID = " & SelectID & " "
my_Conn.Execute (strSql)
j = j + 1
loop
end if
i = i + 1
loop
end if
Response.Write "
" & vbNewline & _
"" & _
"Order Submitted!
" & vbNewline
'
Response.Write "
" & vbNewline & _
"" & _
"Congratulations!
" & vbNewline
else
Response.Write "
" & vbNewline
Response.Write "
" & vbNewline & _
"" & vbNewline & _
rs.close
rsForum.close
set rs = nothing
set rsForum = nothing
end if
Response.Write " " & vbNewline %>
<% Else
Response.Redirect "admin_login_short.asp?target=admin_config_order.asp"
End if %>