<!--#include file="conn.asp"-->
<!--#include file="connopencofigurazione.asp"-->
<%
'############################################################################################# 
'#### 
'#### Script : Mercatino V.1.0
'#### 
'#### Copyright (C) 2002  Roberto Gallo Marchiando
'####
'#### Authore: Roberto Gallo Marchiando
'#### E-mail: webmaster@freepuntonet.com
'#### Web: http:www.freepuntonet.com
'#### Date: 26/05/2002
'#### Linguaggio : ASP (vbscript)
'#### Licenza: Script di libero utilizzo e può essere distribuito liberamente.
'#### A patto che queste linee di testo restino intatte.
'####
'############################################################################################# 
'####
'#### Informazione legale...
'####
'#### FreePuntoNet.com Declina  ogni  responsabilità in caso di danno di qualsiasi natura,
'#### a danni diretti, indiretti.
'#### Pertanto se lei decide di usare questo script sul suo sito web accetta automaticamente
'#### di assumersi le sue responsabilità.
'####
'#### Se lei non è d'accordo su quando è stato detto non usi il mio codice sul suo sito web.
'####
'#### Per problemi rigurdanti lo script contattare:
'#### webmaster@freepuntonet.com
'####
'##############################################################################################

Username= Request.Form("Username")
passw = Request.Form("passw")
function VerificaApostrofo(stringa)
VerificaApostrofo = Replace(stringa, "'","''")
end function
passw = VerificaApostrofo(passw)
Username= VerificaApostrofo(Username)
sql = "SELECT Username, passw FROM utenti WHERE Username = '" & Username & "' AND passw = '" & passw & "'"
Set rsUser = Server.CreateObject("ADODB.Recordset")

rsUser.Open sql, conn, 3, 3

If (not rsUser.BOF) and (not rsUser.EOF) then
  Response.Cookies("Username") = rsUser("Username")
  Response.Cookies("Username").expires = Now()+1
rsUser.close

rsUser.open "Utenti WHERE username= '" & username & "'", conn, 3, 3
rsUser("UtenteAttivo") = True
rsUser.Update
rsUser.close
set rsUser= nothing

conn.close
set conn = nothing
Response.Redirect("pannello.asp")
end if
rsUser.close
set rsUser = nothing
%>

<HTML>
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META NAME="GENERATOR" Content="Microsoft FrontPage 4.0">
<TITLE>Verifica Login..</TITLE>
<style>
A:link, A:visited { text-decoration: none }
A:hover { text-decoration: underline }
</style>

</HEAD>
<BODY>

<div align="center">
  <center>
  <table border="0" width="730" cellpadding="0" height="285" cellspacing="1">
    <caption><!--#include file="top.asp"--></caption>
    <tr>
      <td valign="top" bgcolor="#98A0B8" height="1">
        <p align="center"><img border="0" src="immagini/Ricerca.gif"></td>
      <td rowspan="3" valign="top" height="283"><img border="0" src="immagini/null.gif" width="5" height="5"></td>
      <td valign="top" bgcolor="#98A0B8" height="1">&nbsp;<font color="#FFFFFF" size="2" face="Arial"><b>Navigazione
        :</b></font><font color="#FFFFFF">&nbsp;</font><font face="Arial" size="2"><b><font color="#FFFFFF">Modulo
        : </font></b></font><font face="Arial" color="#FFFF00" size="2"> <b> Login
        Utente</b></font> </td>
    </tr>
    <tr>
      <td valign="top" bgcolor="#D0DCE8" height="307">
        <table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td width="100%" valign="top">
              <div align="center">
                <center>
                <table border="0" width="100%" cellspacing="0" cellpadding="0">
                  <tr>
    <td valign="top">
<form method="get" action="search.asp">
  <div align="center">
  <table border="0" cellpadding="0" cellspacing="0" >
    <tr><td>
    <p align="center"><font size="1" face="Arial">
    <br>
    <input name="search" size="13" >
    </font>
      </td>
    </tr>
    <tr>
      <td>
    <p align="center"><font size="1" face="Arial">
    <br>
    </font>
    <font size="2" face="Arial">
     <select name="xxx" size="1">
      <option value="1">Parola esatta</option>
      <option value="2">Tutte le parole</option>
        </select></font>
      </td>
    </tr>
    <tr>
      <td>
    <p align="center"><font size="1" face="Arial"><br>
    <input type="submit" value="Ricerca" >
    </font>
      </td>
    </tr>
    <tr>
      <td>
        <p align="center"><b><font face="Arial" size="1">Risultato per
        pagina<br>
        <input type="radio" value="10" checked name="num">
        10&nbsp; <input type="radio" name="num" value="20">20&nbsp; 
        <input type="radio" name="num" value="30">
        30</font></b>
      </td>
    </tr>
  </table>
  </div>
</form>
  </td>
                  </tr>
                  <tr>
      <td bgcolor="#D0DCE8" valign="top">
         <p align="center"><!--#include file="news.asp"-->
         </p>
          </td>
                  </tr>
                  <tr>
                    <td width="100%" valign="top"></td>
                  </tr>
                </table>
                </center>
              </div>
            </td>
          </tr>
        </table>
      </td>
      <td valign="top" bgcolor="#FFFFFF" height="307">
        <div align="center">
          <center>
        <table border="0" width="528" cellspacing="0" cellpadding="0" height="104">
          <tr>
            <td width="526" colspan="2" height="21">&nbsp;</td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="31">
              <p align="center"><b><font face="Arial" color="#98A0B8" size="5">Messaggio
            di errore&nbsp;</font></b>
            </td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="21">
            <hr size="1" color="#4B96D3" align="center">
            </td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="40">
<p align="center">
<b><font face="Arial" size="3" color="#800000">
<br>
Attenzione</font></b><font
      color="#800000" size="3" face="Arial">:</font>
            </td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="27">
              <p align="center"><font face="Arial"><b><font size="1"><img border="0" src="immagini/bullet.gif">
</font></b></font><font face="Arial" size="2" color="#98A0B8"><b>Questa
              area è riservata solo agli iscritti al nostro Mercatino
              Iscriversi è gratuito,&nbsp;<br>
              e ti permette di avere accesso all’inserimento&nbsp; dei tuoi
              Annunci</b>
</font></td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="7"><font color="#4B96D3" face="Arial" size="2"><b>&nbsp;</b></font></td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="12">
            <hr size="1" color="#4B96D3" align="center">
            </td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="9">&nbsp;</td>
          </tr>
          <tr>
            <td width="91" height="21"></td>
            <td width="433" height="21"><font face="Arial"><b><font size="1"><img border="0" src="immagini/bullet.gif"></font></b></font>&nbsp;<b><font color="#98A0B8" face="Arial" size="2">Se
              non sei ancora Registrato</font><font color="#4B96D3" face="Arial" size="2"> <a href="preform.asp">Clicca Qui</a></font></b></td>
          </tr>
          </center>
  </center>
          <tr>
            <td width="91" height="21">
              <p align="left"></p>
            </td>
  <center>
          <center>
            <td width="433" height="21"><font face="Arial"><b><font size="1"><img border="0" src="immagini/bullet.gif">
              </font></b></font><b><font color="#98A0B8" face="Arial" size="2">Se
              invece hai perso la Password </font><font color="#4B96D3" face="Arial" size="2"> <a href="richiestapassword.asp"> Clicca Qui</a></font></b></td>
          </tr>
          <tr>
            <td width="91" height="21">&nbsp;</td>
            <td width="433" height="21"></td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="1">&nbsp;</td>
          </tr>
          <tr>
            <td width="526" colspan="2" height="16">&nbsp;</td>
          </tr>
  <tr>
            <td width="526" colspan="2" height="11"></td>
  </tr>
  <tr>
            <td width="526" colspan="2" height="10"></td>
  </tr>
        </table>
          </center>
        </div>
      </td>
    </tr>
    <tr>
      <td width="138" valign="top" bgcolor="#FFFFFF" align="left" height="21"><img border="0" src="immagini/barrapicola.gif"></td>
      <td width="576" valign="top" bgcolor="#FFFFFF" height="21"><img border="0" src="immagini/barralunga.gif"></td>
    </tr>
  </table>
</div>
<p align="center"><!--#include file="Fine.asp"-->
</p>
</BODY>
</HTML>
<%
conn.close
set conn = nothing
%>