%@LANGUAGE="VBSCRIPT"%> <% '=============================================== ' Personals System 2002 ' ©2002 vSpin.net. www.vspin.net '=============================================== ' All rights reserved. ' Use of this code is covered by the terms and ' conditions in the license agreement. No ' unauthorized duplication or distribution is ' permitted. vSpin.net copyright notices must ' remain in the ASP sections of the code. '=============================================== %> <% dim xxxxm, rsheadUpdatee, rsheadUpdatee_numRows ' *** Restrict Access To Page: Grant or deny access to this page Dim MM_authorizedUsers, MM_authFailedURL, MM_grantAccess MM_authorizedUsers="" MM_authFailedURL="login.asp" MM_grantAccess=false If Session("MM_Username") <> "" Then If (true Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End If End If If Not MM_grantAccess Then MM_qsChar = "?" If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&" MM_referrer = Request.ServerVariables("URL") if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString() MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer) Response.Redirect(MM_authFailedURL) End If %> <% Dim rs_main_numRows, p_id, p_headline, p_sex, p_desc, p_seek, p_city, p_relationship, p_age, p_height, p_body, p_weight, p_hair, p_ethnicity, p_religion, p_employ, p_education, p_marital, p_child, p_wantchild, p_smoke, p_drink, p_active, rslocav, rslocav_numRows, p_ethnicty, aryFileType, numFileLoopCounter, strFileStatus, callmode, thepath, fs, numFilePresentCheck, p_idd if Request.Querystring("activate")=1 then Dim thequery if (Session("MM_Username") <> "") then p_idd = Session("MM_Username") Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open MM_conn_STRING sql1 = "UPDATE p_ads SET p_active = 0, p_expdate = Date ()+30 WHERE p_user = '" + Replace(p_idd, "'", "''") + "' " conn.execute(sql1) conn.close set conn = nothing response.redirect("default.asp?message=8") %> <% elseif Request.Querystring("activate")=2 then if (Session("MM_Username") <> "") then p_idd = Session("MM_Username") Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open MM_conn_STRING sql1 = "UPDATE p_ads SET p_active = 1 WHERE p_user = '" + Replace(p_idd, "'", "''") + "' " conn.execute(sql1) conn.close set conn = nothing response.redirect("default.asp?message=7") end if if (Session("MM_Username") <> "") then rsSession__MMColParam = Session("MM_Username") set rs_main = Server.CreateObject("ADODB.Recordset") rs_main.ActiveConnection = MM_conn_STRING rs_main.Source = "SELECT * FROM p_ads WHERE p_user = '" + Replace(rsSession__MMColParam, "'", "''") + "'" rs_main.CursorType = 0 rs_main.CursorLocation = 2 rs_main.LockType = 3 rs_main.Open() rs_main_numRows = 0 If rs_main.EOF Or rs_main.BOF Then %>