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


 


Classifica Utenti

<% 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 Utenti ORDER BY FAMA 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_Imperi_" counter = 0 sqlConn.Open() 'sqlComm = New SqlCommand("SELECT TOP 50 * FROM Utenti WHERE ID NOT IN (SELECT TOP "& Page &" ID FROM Utenti ORDER BY FAMA DESC, ID) ORDER BY FAMA DESC, ID", sqlConn) sqlComm = New SqlCommand("SELECT TOP 50 Utenti.Id as Id_Utente, Utenti.Fama, Utenti.Username, Utenti.Gilda, Pianeti.Proprietary, Pianeti.Nome FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Pianeti.Is_Principal = '1' AND Utenti.ID NOT IN (SELECT TOP "& Page &" ID FROM Utenti ORDER BY FAMA DESC, ID) ORDER BY Fama DESC, Utenti.ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() counter = counter + 1 %> <% %><% Last_Id_Page = r("Id_Utente") End While r.Close() sqlConn.Close() %>
Nome Utente [Gilda]

Paese Principale

Fama

<% If File.Exists(Pagina & r("Id_Utente") & ".jpg") = True Then %> onmouseover="doTooltip(event, messages_g[<%=counter%>] )" onmouseout="hideTip()" <% End If %> ><%=r("Username")%> <% If Trim(r("Gilda")) <> "" Then %>  [<%=r("Gilda")%>] <% End If %> <%=r("Nome")%><%=r("Fama")%>


<% 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 %>