%@ 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 ("
")
%>
"& 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 ("
")
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 ("
"& 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) &": ")
End While
r.Close()
sqlConn.Close()
Response.Write("
"& 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",755) &" ")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT SUM(Utenti.Fama) as Fama_Utenti, Count(*) AS Totale_Utenti, Utenti.Gilda FROM Utenti WHERE Utenti.Gilda <> '' GROUP BY Utenti.Gilda ORDER BY Fama_Utenti DESC, Totale_Utenti", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Response.Write (""& Read_File("inc\Lang\Languages.aspx",526) &" "& Read_File("inc\Lang\Languages.aspx",756) &" "& Read_File("inc\Lang\Languages.aspx",525) &" ")
End While
r.Close()
sqlConn.Close()
%>
"& UCase(r("Gilda")) &" "& CInt(r("Totale_Utenti")) &" "& CInt(r("Fama_Utenti")/1000) &"