% setLocale server_locale If Not session("admin_loggedin" & strSUnique) = Session.SessionID then Response.Redirect "default.asp" Dim fv(20), optionsArray(4, 20) If Request.Form("SM1") = "Set Meta Properties" then smd = sqq(Request.Form("DR4")) smk = sqq(Request.Form("DR5")) dtc = CLng(Request.Form("C1")) objConn.Execute("UPDATE " & tablPfx & "Config SET siteMetaDescr = '" & smd & "', siteMetaKey = '" & smk & "', default_to_cat = " & dtc & ";") Application("Classify_Main_Config" & strUnique) = Empty Response.Redirect "admin_cat.asp" End If rs.CursorType = 2 rs.Open "SELECT " & tablPfx & "Cat.* from " & tablPfx & "Cat;", strConn If rs.EOF then Response.Write "
The Category List is Empty
" disabled = "disabled" objConn.Execute("UPDATE " & tablPfx & "Opt SET isGlobal=0;") End If rs.close flag = Request.Form("submitFlag") Select Case flag '### Create Category Case "create" Application("Cat_List" & strUnique) = Empty newCategory = sqq(Request.Form("ncat")) newDescription = sqq(Request.Form("ndescr")) newSubCategory = sqq(Request.Form("nscat")) newIcon = sqq(Request.Form("nicon")) If newIcon = Empty then newIcon = "bullet.gif" If disabled = "disabled" then catID = 10000 sCatID = 50000 Else If mysql then strSQL = "SELECT " & tablPfx & "Cat.catID, " & tablPfx & "Scat.sCatID " strSQL = strSQL & "FROM " & tablPfx & "Cat, " & tablPfx & "Scat WHERE " & tablPfx & "Scat.sCatID < 100000 " strSQL = strSQL & "ORDER BY " & tablPfx & "Cat.catID DESC, " & tablPfx & "Scat.sCatID DESC LIMIT 0,1;" Else strSQL = "SELECT TOP 1 " & tablPfx & "Cat.catID, " & tablPfx & "Scat.sCatID " strSQL = strSQL & "FROM " & tablPfx & "Cat, " & tablPfx & "Scat WHERE " & tablPfx & "Scat.sCatID < 100000 " strSQL = strSQL & "ORDER BY " & tablPfx & "Cat.catID DESC, " & tablPfx & "Scat.sCatID DESC;" End If set rst = objConn.Execute(strSQL) catID = CLng(rst(0)) + 1 sCatID = CLng(rst(1)) + 1 rst.close End If For L = 1 to 20 strcatOptType = strcatOptType & ", catOptType" & L strcatOptTypeVal = strcatOptTypeVal & ", '0'" strcatOptSearch = strcatOptSearch & ", catOptSearch" & L strcatOptSearchVal = strcatOptSearchVal & ", 0" Next objConn.Execute("INSERT INTO " & tablPfx & "Cat(catID,catName,catDescr,icon,ads,pricelevel" & strcatOptType & strcatOptSearch & ",ftype,isfree) " & _ "VALUES (" & catID & ",'" & newCategory & "','" & newDescription & "','" & newIcon & "',0,'1'" & strcatOptTypeVal & strcatOptSearchVal & ",'default',0);") objConn.Execute("INSERT INTO " & tablPfx & "Scat(sCatID,scatName,catID,ads,ftype) VALUES (" & sCatID & ",'" & newSubCategory & "'," & catID & ",0,'default');") objConn.Execute("UPDATE " & tablPfx & "Cat SET sortID = ID WHERE catID = " & catID & ";") objConn.Execute("UPDATE " & tablPfx & "Scat SET sortID = ID WHERE sCatID = " & sCatID & ";") set rsg = objConn.Execute("SELECT * FROM " & tablPfx & "Opt," & tablPfx & "Cat WHERE (catOpt1 IS NOT NULL AND isglobal = 1) ORDER BY optorder ASC;") If Not rsg.EOF Then Do While Not rsg.EOF L = rsg("optorder") If L = Empty Or L <> nextOpt Then nextOpt = L globSet = globSet & ",catOpt" & L & "='" & sq(rsg("catOpt" & L)) & "',catOptType" & L & "='" & sq(rsg("catOptType" & L)) & "',catOptSearch" & L & "=" & rsg("catOptSearch" & L) globWhere = "catOpt" & L & " IS NULL" End If rsg.MoveNext Loop End If If Len(globSet) > 0 then globSet = Replace(globSet, ",", "", 1, 1) strSQL = "UPDATE " & tablPfx & "Cat SET " & globSet & " WHERE catID = " & catID & ";" objConn.Execute(strSQL) End If If disabled = "disabled" then Response.Redirect "admin_cat.asp" Else: Response.Redirect "admin_cat.asp?catid=" & catID & "&subcatID=" & sCatID End If '### Add Subcategory Case "addsubcat" newSubCategory = sqq(Request.Form("ascat")) catID = CLng(Request.Form("catID")) If mysql then strSQL = "SELECT sCatID FROM " & tablPfx & "Scat WHERE sCatID < 100000 ORDER BY sCatID DESC LIMIT 0,1;" Else: strSQL = "SELECT TOP 1 sCatID FROM " & tablPfx & "Scat WHERE sCatID < 100000 ORDER BY sCatID DESC;" End If set rst = objConn.Execute(strSQL) sCatID = CLng(rst(0)) + 1 rst.close objConn.Execute("INSERT INTO " & tablPfx & "Scat(sCatID,scatName,catID,ads,ftype) VALUES (" & sCatID & ",'" & newSubCategory & "'," & catID & ",0,'default');") objConn.Execute("UPDATE " & tablPfx & "Scat SET sortID = ID WHERE sCatID = " & sCatID & ";") Response.Redirect "admin_cat.asp?catid=" & catID & "&subcatID=" & sCatID '### Add 3-rd Level Category Case "add3rdcat" new3rdCategory = sqq(Request.Form("DR13")) catID = CLng(Request.Form("catID")) scatID = CLng(Request.Form("subcatID")) If mysql then strSQL = "SELECT sCatID FROM " & tablPfx & "Scat WHERE sCatID >= 100000 ORDER BY sCatID DESC LIMIT 0,1;" Else: strSQL = "SELECT TOP 1 sCatID FROM " & tablPfx & "Scat WHERE sCatID >= 100000 ORDER BY sCatID DESC;" End If Set rs3 = objConn.Execute(strSQL) If rs3.EOF then cat3rdID = 100000 Else: cat3rdID = rs3(0) + 1 End If rs3.close cat3rdID = CLng(cat3rdID) objConn.Execute("INSERT INTO " & tablPfx & "Scat(sCatID,scatName,catID,ads,ftype) VALUES (" & cat3rdID & ",'" & new3rdCategory & "'," & scatID & ",0,'default');") objConn.Execute("UPDATE " & tablPfx & "Scat SET sortID = ID WHERE sCatID = " & cat3rdID & ";") Response.Redirect "admin_cat.asp?catid=" & catID & "&subcatID=" & sCatID & "&3rdcatID=" & cat3rdID '### Modify Category Case "catmod" Application("Cat_List" & strUnique) = Empty catID = Request.Form("catID") modCategory = sqq(Request.Form("mcat")) modDescription = sqq(Request.Form("mdescr")) modIcon = sqq(Request.Form("micon")) modFD = sqq(Request.Form("DR1")) modMD = sqq(Request.Form("DR2")) modMK = sqq(Request.Form("DR3")) modT = sqq(Request.Form("DR14")) pricelevel = Request.Form("pl") If modIcon = Empty then modIcon = "bullet.gif" For co = 1 to 20 If CStr(Request.Form("opt" & co)) = "1" then If Len(Trim(Request.Form("F" & co))) > 0 then objConn.Execute("UPDATE " & tablPfx & "Cat SET catOpt" & co & "='" & sqq(Request.Form("F" & co)) & "', catOptType" & co & "='" & Request.Form("OF" & co) & "', catOptSearch" & co & "=" & CLng(Request.Form("S" & co)) & ";") objConn.Execute("UPDATE " & tablPfx & "Opt SET isglobal=1 WHERE optname='optn" & co & "';") End If Else objConn.Execute("UPDATE " & tablPfx & "Opt SET isglobal=0 WHERE optname='optn" & co & "';") strOptionsUpdate = strOptionsUpdate & ", catOpt" & co & " = '" & sqq(Request.Form("F" & co)) & "', catOptType" & co & "='" & Request.Form("OF" & co) & "', catOptSearch" & co & "=" & CLng(Request.Form("S" & co)) End If Next strModCat = "UPDATE " & tablPfx & "Cat SET catName = '" & modCategory & "', catDescr = '" & modDescription & "', " strModCat = strModCat & "icon = '" & modIcon & "' " & strOptionsUpdate & ", catFullDescr = '" & modFD & "', pricelevel = '" & pricelevel & "', " strModCat = strModCat & "catMetaDescr = '" & modMD & "', catMetaKey = '" & modMK & "', catTitle = '" & modT & "' WHERE catID=" & catID & ";" objConn.Execute(strModCat) Response.Redirect "admin_cat.asp?catid=" & catID '### Modify Subcategory Case "catsmod" catID = Request.Form("catID") subcatID = Request.Form("subcatID") modsCategory = sqq(Request.Form("mscat")) modFD = sqq(Request.Form("DR6")) modMD = sqq(Request.Form("DR7")) modMK = sqq(Request.Form("DR8")) modT = sqq(Request.Form("DR15")) strModSCat = "UPDATE " & tablPfx & "Scat SET scatName = '" & modsCategory & "', scatFullDescr = '" & modFD & "', " strModSCat = strModSCat & "scatMetaDescr = '" & modMD & "', scatMetaKey = '" & modMK & "', scatTitle = '" & modT & "' WHERE sCatID=" & subcatID & ";" objConn.Execute(strModSCat) Response.Redirect "admin_cat.asp?catid=" & catID & "&subcatID=" & subcatID '### Modify 3-rd LeveL Category Case "mod3rd" catID = Request.Form("catID") subcatID = Request.Form("subcatID") cat3rdID = Request.Form("cat3rdID") modsCategory = sqq(Request.Form("DR9")) modFD = sqq(Request.Form("DR10")) modMD = sqq(Request.Form("DR11")) modMK = sqq(Request.Form("DR12")) modT = sqq(Request.Form("DR16")) strModSCat = "UPDATE " & tablPfx & "Scat SET scatName = '" & modsCategory & "', scatFullDescr = '" & modFD & "', " strModSCat = strModSCat & "scatMetaDescr = '" & modMD & "', scatMetaKey = '" & modMK & "', scatTitle = '" & modT & "' WHERE sCatID=" & cat3rdID & ";" objConn.Execute(strModSCat) Response.Redirect "admin_cat.asp?catid=" & catID & "&subcatID=" & subcatID & "&3rdcatID=" & cat3rdID '### Display Case Else If not disabled = "disabled" then If request.querystring.count = 3 then querycatID = request.querystring.item(1) querysubcatID = request.querystring.item(2) query3rdcatID = request.querystring.item(3) ElseIf request.querystring.count = 2 then querycatID = request.querystring.item(1) querysubcatID = request.querystring.item(2) If mysql then strSCat = "SELECT sCatID from " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY sCatID LIMIT 0,1;" Else: strSCat = "SELECT TOP 1 sCatID from " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY sCatID;" End If Set rs = objConn.Execute(strSCat) If not rs.EOF then query3rdcatID = rs("sCatID") rs.close ElseIf request.querystring.count = 1 then querycatID = request.querystring.item(1) If mysql then strSCat = "SELECT sCatID from " & tablPfx & "Scat WHERE catID=" & querycatID & " ORDER BY sCatID LIMIT 0,1;" Else: strSCat = "SELECT TOP 1 sCatID from " & tablPfx & "Scat WHERE catID=" & querycatID & " ORDER BY sCatID;" End If Set rs = objConn.Execute(strSCat) If not rs.EOF then querysubcatID = rs("sCatID") rs.close If mysql then strSCat = "SELECT sCatID from " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY sCatID LIMIT 0,1;" Else: strSCat = "SELECT TOP 1 sCatID from " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY sCatID;" End If Set rs = objConn.Execute(strSCat) If not rs.EOF then query3rdcatID = rs("sCatID") rs.close Else If mysql then strCat = "SELECT " & tablPfx & "Cat.catID from " & tablPfx & "Cat ORDER BY catID LIMIT 0,1;" Else: strCat = "SELECT TOP 1 " & tablPfx & "Cat.catID from " & tablPfx & "Cat ORDER BY catID;" End If Set rs = objConn.Execute(strCat) If not rs.EOF then querycatID = CLng(rs("catID")) rs.close If mysql then strSCat = "SELECT " & tablPfx & "Scat.sCatID from " & tablPfx & "Scat WHERE catID=" & querycatID & " ORDER BY sCatID LIMIT 0,1;" Else: strSCat = "SELECT TOP 1 " & tablPfx & "Scat.sCatID from " & tablPfx & "Scat WHERE catID=" & querycatID & " ORDER BY sCatID;" End If Set rs = objConn.Execute(strSCat) If not rs.EOF then querysubcatID = rs("sCatID") rs.close If mysql then strSCat = "SELECT sCatID from " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY sCatID LIMIT 0,1;" Else: strSCat = "SELECT TOP 1 sCatID from " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY sCatID;" End If Set rs = objConn.Execute(strSCat) If not rs.EOF then query3rdcatID = rs("sCatID") rs.close End If set rsOpt = objConn.Execute("SELECT optionName FROM " & tablPfx & "OptTypes;") noOpt = "" If Not rsOpt.EOF then Do While Not rsOpt.EOF nextOptName = rsOpt(0) strOptOpt = strOptOpt & "" rsOpt.MoveNext Loop End If rsOpt.close strOptOpt = noOpt & strOptOpt set rsOpt = objConn.Execute("SELECT * FROM " & tablPfx & "Opt ORDER BY optorder ASC;") For I = 1 to 20 If CInt(rsOpt(1)) = 1 then optionsArray(1, I) = "disabled" optionsArray(2, I) = "checked" Else optionsArray(1, I) = "" optionsArray(2, I) = "" End If rsOpt.MoveNext Next rsOpt.close strCat = "SELECT * FROM " & tablPfx & "Cat ORDER BY catName;" Set rs = objConn.Execute(strCat) If not rs.EOF then Do While Not rs.EOF currentID = rs("catID") currentName = rs("catName") If CStr(querycatID) = CStr(currentID) then optCat = optCat & "" currentDescr = rs("catDescr") currentIcon = rs("icon") currentItems = rs("ads") currentFullDescr = rs("catFullDescr") currentMetaDescr = rs("catMetaDescr") currentMetaKey = rs("catMetaKey") currentTitle = rs("catTitle") pl = rs("pricelevel") displayCatName = currentName For Z = 1 to 20 fv(Z) = rs("catOpt" & Z) If CInt(rs("catOptSearch" & Z)) = 1 then optionsArray(4, Z) = "checked" nextOptType = CStr(rs("catOptType" & Z)) nextOptOption = Replace(strOptOpt, "value='" & nextOptType & "'", " selected value='" & nextOptType & "'") optionsArray(3, Z) = nextOptOption Next Else: optCat = optCat & "" End If rs.MoveNext Loop End If rs.close strSCat = "SELECT * FROM " & tablPfx & "Scat WHERE catID=" & querycatID & " ORDER BY scatName;" Set rs = objConn.Execute(strSCat) If not rs.EOF then Do While Not rs.EOF currentSubID = rs("sCatID") currentSubName = rs("scatName") If CStr(currentSubID) = CStr(querysubcatID) then optSubCat = optSubCat & "" currentSubItems = rs("ads") currentSFullDescr = rs("scatFullDescr") currentSMetaDescr = rs("scatMetaDescr") currentSMetaKey = rs("scatMetaKey") currentSTitle = rs("scatTitle") displaySCatName = currentSubName Else: optSubCat = optSubCat & "" End If rs.MoveNext Loop End If rs.close strSCat = "SELECT * FROM " & tablPfx & "Scat WHERE catID=" & querysubcatID & " ORDER BY scatName;" Set rs = objConn.Execute(strSCat) If not rs.EOF then Do While Not rs.EOF current3rdID = rs("sCatID") current3rdName = rs("scatName") If CStr(current3rdID) = CStr(query3rdcatID) then opt3rdCat = opt3rdCat & "" current3rdItems = rs("ads") current3rdFullDescr = rs("scatFullDescr") current3rdMetaDescr = rs("scatMetaDescr") current3rdMetaKey = rs("scatMetaKey") current3rdTitle = rs("scatTitle") display3rdCatName = current3rdName Else: opt3rdCat = opt3rdCat & "" End If rs.MoveNext Loop Else disable3rd = "disabled" End If rs.close End If End Select Function sqq(inputstr) inputstr = Replace(inputstr, chr(34), """) sqq = Replace(inputstr, "'", "''") End Function %> <%= msg %>![]() |
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
![]() |
![]() |
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||