%Session("Counter") = 0 vip=Request.ServerVariables("REMOTE_ADDR") vrefer=Request.ServerVariables("HTTP_REFERER") & Request.ServerVariables("URL") vtime=time vdate=date vhost=Request.ServerVariables("REMOTE_HOST") Session("IP") = vip SQLQuery= "INSERT INTO Tab_Visitors (ipnum, refer, currtime, currdate, remhost)" SQLQuery= SQLQuery & "VALUES( '" & vip & "', '" & vrefer & "', '" & vtime & "', '" & vdate & "', '" & vhost & "')" Set oConn = Server.CreateObject("ADODB.Connection") oconn.open "online_versadrill","online","0nl1n3" oConn.Execute(SQLQuery) Set rs = Server.CreateObject("ADODB.Recordset") rs.Open ("SELECT Tab_Compteur.* FROM Tab_Compteur"), oConn, 3, 3 rs.MoveFirst Session("Count") = (rs.Fields("Compteur").Value) Set rs=nothing Dim Test : Test = 0 Set rs = Server.CreateObject("ADODB.Recordset") rs.Open ("SELECT Tab_IPdescription.* FROM Tab_IPdescription"), oConn, 3, 3 On error resume next rs.MoveFirst Do While Not rs.EOF If (rs.Fields("ipnum").value) = Session("IP") Then Test = 1 End If rs.MoveNext Loop If Test = 0 Then Dim Ncount : Ncount = Session("Count")+1 Set rs = Server.CreateObject("ADODB.Recordset") rs.Open ("SELECT Tab_Compteur.Compteur FROM Tab_Compteur "), oconn, 1, 2, 1 rs.MoveFirst rs.Fields("Compteur") = Ncount rs.update rs.close Set rs=nothing ' oConn.close ' Set oConn = nothing End If oConn.close Set oConn = nothing %>