%@ 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 (""& Read_File("inc\Lang\Languages.aspx",743) &" "& Read_File("inc\Lang\Languages.aspx",438) &" "& Read_File("inc\Lang\Languages.aspx",525) &" ")
Last_Id_Page = r("Id_Utente")
End While
r.Close()
sqlConn.Close()
Response.Write (""& 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
%>