<%@ 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" %> <% Dim Stats_Race = Decripta(Request.QueryString("Code")) If Stats_Race = "aru" Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",750) &"") End If If Stats_Race = "io" Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",751) &"") End If Response.Write ("

") %><% Response.Write ("


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

") Dim Race_Uno Dim Race_Due If Stats_Race = "aru" Then Race_Uno = "Human" Race_Due = "Elf" End If If Stats_Race = "io" Then Race_Uno = "Orc" Race_Due = "Undead" End If Dim 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_" Response.Write ("") Dim counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 1 Utenti.Id as Id_Utente, Gilda, Utenti.Fama, Utenti.Username, Pianeti.Proprietary, Pianeti.Nome FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Pianeti.Is_Principal = '1' AND (Utenti.Race = '"& Race_Uno &"' OR Utenti.Race = '"& Race_Due &"') ORDER BY Fama DESC", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("
") If File.Exists(Pagina & r("Id_Utente") & ".jpg") = True Then Response.Write ("") End If Response.Write ("
") Response.Write ("") End While r.Close() sqlConn.Close() Response.Write("
"& Read_File("inc\Lang\Languages.aspx",753) &":

"& r("Username") &"") If Trim(r("Gilda")) <> "" Then Response.Write ("["& UCase(Trim(r("Gilda"))) &"]") End If Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",456) &":

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

"& r("Fama") &"




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

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

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

") counter = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 11 Utenti.Id as Id_Utente, Gilda, Utenti.Fama, Utenti.Username, Pianeti.Proprietary, Pianeti.Nome FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Pianeti.Is_Principal = '1' AND (Utenti.Race = '"& Race_Uno &"' OR Utenti.Race = '"& Race_Due &"') ORDER BY Fama DESC", sqlConn) r = sqlComm.ExecuteReader() While r.Read() counter = counter + 1 If counter > 1 Then Response.write ("") Response.write ("") End If End While r.Close() sqlConn.Close() Response.Write("
"& r("Username") &"") If Trim(r("Gilda")) <> "" Then Response.Write ("["& UCase(Trim(r("Gilda"))) &"]") End If Response.write (""& r("Nome") &""& r("Fama") &"



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





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

") Dim i = 0 Dim Paginax sqlConn.Open() sqlComm = New SqlCommand("SELECT SUM(Utenti.Fama) as Fama_Utenti, Count(*) AS Totale_Utenti, Utenti.Gilda, Gilde.Id as Id_Gilda FROM Utenti JOIN GILDE ON UTENTI.GILDA = GILDE.TAG WHERE Utenti.Gilda <> '' GROUP BY Utenti.Gilda, Gilde.Id ORDER BY Fama_Utenti DESC, Totale_Utenti", sqlConn) r = sqlComm.ExecuteReader() While r.Read() i = i + 1 Response.Write ("") Paginax = Request.ServerVariables("PATH_TRANSLATED") Paginax = Mid(Paginax,1,Len(Paginax)-Len(Split(StrReverse(Paginax),"\")(0))-1) Paginax = Paginax + "\public\Logo_Gilda_" & r("Id_Gilda") & ".jpg" If File.Exists(Paginax) = True Then Response.Write ("") Else Response.Write ("") End If End While r.Close() sqlConn.Close() Response.Write("
"& Read_File("inc\Lang\Languages.aspx",526) &"

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

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

"& UCase(r("Gilda")) &""& CInt(r("Totale_Utenti")) &""& CInt(r("Fama_Utenti")/1000) &"
"& UCase(r("Gilda")) &""& CInt(r("Totale_Utenti")) &""& CInt(r("Fama_Utenti")/1000) &"
") %>