<%
'#################################################################################
'## 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
Response.Redirect "admin_login_short.asp?target=admin_config_order.asp"
end if
if Request.Form("Method_Type") = "Write_Configuration" then
if Request.Form("NumberCategories") <> "" then
i = 1
do until i > cLng(Request.Form("NumberCategories"))
SelectName = Request.Form("SortCategory" & i)
if isNull(SelectName) then SelectName = cLng(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),,adCmdText + adExecuteNoRecords
if NumberForums <> "" then
j = 1
do until j > cLng(Request.Form("NumberForums" & SelectID))
SelectNamec = Request.Form("SortCat" & i & "SortForum" & j)
if isNull(SelectNamec) then SelectNamec = cLng(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),,adCmdText + adExecuteNoRecords
j = j + 1
loop
end if
i = i + 1
loop
end if
Response.Write "