<%@ 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" %> <% Dim User = Request.QueryString ("user") Dim Ip sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM utenti WHERE Username = '"& User &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Ip = (r("Initial_Ip")) End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM utenti JOIN Pianeti ON Pianeti.Proprietary = Utenti.Username WHERE Is_Principal = 1 AND Initial_Ip = '"& Ip &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write (r("username")) Response.Write ((" - ")) Response.Write (r("password")) Response.Write ((" - ")) Response.Write (r("Initial_Ip")) Response.Write ((" - ")) Response.Write (r("Email")) Response.Write ((" - ")) Response.Write (r("Registration_Data")) Response.Write ((" - ")) Response.Write (r("Data_Last_Access")) Response.Write (("
")) End While r.Close() sqlConn.Close() %>