%@ 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()
%>