%@ Page Language="vb" Debug="true" %>
<% @Import NameSpace="System.Data" %>
<% @Import NameSpace="System.Data.SQLClient" %>
<% @Import NameSpace="System.Diagnostics.Debug" %>
<% @Import Namespace="System.Web.Mail" %>
<% @Import Namespace="System.Text.RegularExpressions" %>
<% @Import NameSpace="System.Data.OleDb" %>
<%@ Import namespace="System.IO" %>
<%@ Import namespace="System.Net" %>
<%
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Id, Pianeti.Id, Pianeti.Nome as Nome_Paese, Utenti.Username, Pianeti.Proprietary, Utenti.Initial_Ip, Pianeti.Data_Last_Access FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Utenti.Initial_Ip = '83.176.74.209' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
%>Nome: <%=r("Username")%>, Paese: <%=r("Nome_Paese")%>, Last_Access: <%=r("Data_Last_Access")%>
<%
End While
r.Close()
sqlConn.Close()
%>