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

<%=Read_File("inc\Lang\Languages.aspx",742)%>



<% Dim Page = Request.QueryString("Page") If Page = "" Then Page = 0 End If Dim Last_Id Dim Last_Id_Page sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Utenti ORDER BY FAMA DESC, ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Last_Id = r("ID") End While r.Close() sqlConn.Close() Response.Write ("") 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 Utenti.Id as Id_Utente, Utenti.Fama, Utenti.Username, Utenti.Gilda, Pianeti.Proprietary, Pianeti.Nome FROM Utenti LEFT JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Attivo = 'Si' AND Pianeti.Is_Principal = '1' AND Utenti.ID NOT IN (SELECT TOP "& Page &" ID FROM Utenti WHERE Attivo = 'Si' ORDER BY FAMA DESC, Utenti.ID) ORDER BY Fama DESC, Utenti.ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() counter = counter + 1 Response.Write ("") Response.Write ("") Last_Id_Page = r("Id_Utente") End While r.Close() sqlConn.Close() Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",743) &"

"& Read_File("inc\Lang\Languages.aspx",438) &"

"& Read_File("inc\Lang\Languages.aspx",525) &"

"& r("Username") &"") If Trim(r("Gilda")) <> "" Then Response.Write (" ["& r("Gilda") &"]") End If Response.Write (""& r("Nome") &""& r("Fama") &"


") If Page <> 0 Then Response.Write (""& Read_File("inc\Lang\Languages.aspx",528) &"") End If If Page <> 0 AND Last_Id <> Last_Id_Page Then Response.Write (" - ") End If If Last_Id <> Last_Id_Page Then Response.Write (""& Read_File("inc\Lang\Languages.aspx",529) &"") End If %>