%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% ' *** Logout the current user. MM_Logout = CStr(Request.ServerVariables("URL")) & "?MM_Logoutnow=1" If (CStr(Request("MM_Logoutnow")) = "1") Then Session.Contents.Remove("MM_Username") Session.Contents.Remove("MM_UserAuthorization") MM_logoutRedirectPage = "../index2.asp" ' redirect with URL parameters (remove the "MM_Logoutnow" query param). if (MM_logoutRedirectPage = "") Then MM_logoutRedirectPage = CStr(Request.ServerVariables("URL")) If (InStr(1, UC_redirectPage, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_newQS = "?" For Each Item In Request.QueryString If (Item <> "MM_Logoutnow") Then If (Len(MM_newQS) > 1) Then MM_newQS = MM_newQS & "&" MM_newQS = MM_newQS & Item & "=" & Server.URLencode(Request.QueryString(Item)) End If Next if (Len(MM_newQS) > 1) Then MM_logoutRedirectPage = MM_logoutRedirectPage & MM_newQS End If Response.Redirect(MM_logoutRedirectPage) End If %> <% ' *** Restrict Access To Page: Grant or deny access to this page 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 tiposinmuebles Dim tiposinmuebles_numRows Set tiposinmuebles = Server.CreateObject("ADODB.Recordset") tiposinmuebles.ActiveConnection = MM_inmosol_STRING tiposinmuebles.Source = "SELECT id_tipo, tipo_es FROM tbl_tipoinmuebles ORDER BY tipo_es ASC" tiposinmuebles.CursorType = 0 tiposinmuebles.CursorLocation = 2 tiposinmuebles.LockType = 1 tiposinmuebles.Open() tiposinmuebles_numRows = 0 %> <% Dim inmuebles__MMColParam inmuebles__MMColParam = "1" If (request.querystring("tipo_es") <> "") Then inmuebles__MMColParam = request.querystring("tipo_es") End If %> <% Dim inmuebles__MMColParam2 inmuebles__MMColParam2 = "Venta" If (request.querystring("tipo_es") <> "") Then inmuebles__MMColParam2 = request.querystring("operacion") End If %> <% Dim inmuebles Dim inmuebles_numRows Set inmuebles = Server.CreateObject("ADODB.Recordset") inmuebles.ActiveConnection = MM_inmosol_STRING inmuebles.Source = "SELECT id_inmueble, operacion, referencia, tbl_tipoinmuebles.tipo_es, localidad, precioeuros, precioptas, tbl_urbanizaciones.nombreurbanizacion, supconstruida, supparcela, detalles, enconstruccion, paginaprincipal, orden FROM tbl_inmuebles, tbl_urbanizaciones, tbl_tipoinmuebles WHERE tipoinmueble = " + Replace(inmuebles__MMColParam, "'", "''") + " and tbl_inmuebles.operacion='" + Replace(inmuebles__MMColParam2, "'", "''") + "' and tbl_inmuebles.urbanizacion = tbl_urbanizaciones.id_urbanizacion and tbl_tipoinmuebles.id_tipo = tbl_inmuebles.tipoinmueble ORDER BY orden ASC" inmuebles.CursorType = 0 inmuebles.CursorLocation = 2 inmuebles.LockType = 1 inmuebles.Open() inmuebles_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 inmuebles_numRows = inmuebles_numRows + Repeat1__numRows %>