<%@ 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 Props = "" Dim counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Is_Principal = 1 ORDER BY Proprietary", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Proprietary") <> Props Then Props = r("Proprietary") Counter = 0 End If If r("Proprietary") = Props Then Counter = counter + 1 End If If counter > 1 Then Response.write (r("Proprietary")) Response.write ("
") End If End While r.Close() sqlConn.Close() Dim User = Request.QueryString("User") %>


<% sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Proprietary = '"& User &"' ORDER BY Proprietary", sqlConn) r = sqlComm.ExecuteReader() While r.Read() %><%=(r("Proprietary"))%>: <%=r("Nome")%>, Principal: <%=r("Is_Principal")%>, Legna: <%=CInt(r("Ris_Legna"))%>, Pietra: <%=CInt(r("Ris_Pietra"))%>, Ferro: <%=CInt(r("Ris_Ferro"))%>, Zolfo: <%=CInt(r("Ris_Zolfo"))%>, Oro: <%=CInt(r("Ris_Oro"))%>, Last_Access: <%=r("Data_Last_Access")%>, Id: <%=r("ID")%>
<% End While r.Close() sqlConn.Close() %>