<%@ 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" %> <%@ Import namespace="System.Drawing" %>

<% sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Dimensione = '" + Dimensione + "' AND Reame = '" + Reame + "' AND Paese = '" + Paese + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Timer_Costruct = r("In_Costr_Eser") Ris_Legna = r("Ris_Legna") Ris_Ferro = r("Ris_Ferro") Ris_Zolfo = r("Ris_Zolfo") Ris_Pietra = r("Ris_Pietra") Ris_Oro = r("Ris_Oro") Cosa_Costr = r("Cosa_Costr_Eser") End While r.Close() sqlConn.Close() %>
Generali


 


Classifica Generali

<% Var_Id_Generale = Request.QueryString("ID") Dim Page = Request.QueryString("Page") If Page = "" Then Page = 0 End If If Var_Id_Generale = "" Dim Last_Id Dim Last_Id_Page sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Generali ORDER BY EXP DESC, ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Last_Id = r("ID") End While r.Close() sqlConn.Close() %> <% Dim counter Dim Pagina Pagina = Request.ServerVariables("PATH_TRANSLATED") Pagina = Mid(Pagina,1,Len(Pagina)-Len(Split(StrReverse(Pagina),"\")(0))-1) Pagina = Mid(Pagina,1,Len(Pagina)-Len(Split(StrReverse(Pagina),"\")(0))) Pagina = Pagina + "\public\Avatar_Generali_" counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 50 * FROM Generali WHERE ID NOT IN (SELECT TOP "& Page &" ID FROM Generali ORDER BY EXP DESC, ID) ORDER BY EXP DESC, ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() counter = counter + 1 %> <% %><% Last_Id_Page = r("ID") End While r.Close() sqlConn.Close() %>
Nome Generale

Proprietario

Exp

<% If r("Is_Dead") = 1 Then%> <% End If %> " target="_Blank" <% If File.Exists(Pagina & r("Id") & ".jpg") = True Then %> onmouseover="doTooltip(event, messages_g[<%=counter%>] )" onmouseout="hideTip()" <% End If %> ><%=r("Nome")%><%=r("Proprietary")%><%=r("Exp")%>


<% If Page <> 0 Then %> Pagina Precedente <% End If %> <% If Page <> 0 AND Last_Id <> Last_Id_Page Then %> - <% End If %> <% If Last_Id <> Last_Id_Page Then %> Pagina Successiva <% End If %> <% End If %> <% If Var_Id_Generale <> "" Then sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Generali WHERE ID = '"& Var_Id_Generale &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() %>
Nome Generale Stato Livello Exp

<%=r("Nome")%> <% If r("Is_Dead") = 0 Then %>Vivo<% End If %> <% If r("Is_Dead") = 1 Then %>Morto<% End If %> <% If r("Is_Dead") = 2 Then %>Catturato<% End If %> <%=r("Livello")%><%=r("Exp")%>
<% End While r.Close() sqlConn.Close() End If %>