<%
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()
%>
| | Nome Generale
| Proprietario
| Exp
|
<%
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
%>
<%
%> |
<% 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")%> | <%
Last_Id_Page = r("ID")
End While
r.Close()
sqlConn.Close()
%>
<% 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
%>
|
 |
|
|
 |
 |
|
 |
 |
|