%@ 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)%>
<%
Response.Write ("
")
%>
")
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 (""& Read_File("inc\Lang\Languages.aspx",526) &" "& Read_File("inc\Lang\Languages.aspx",756) &" "& Read_File("inc\Lang\Languages.aspx",525) &" ")
Else
Response.Write (""& UCase(r("Gilda")) &" "& CInt(r("Totale_Utenti")) &" "& CInt(r("Fama_Utenti")/1000) &" ")
End If
End While
r.Close()
sqlConn.Close()
Response.Write(""& UCase(r("Gilda")) &" "& CInt(r("Totale_Utenti")) &" "& CInt(r("Fama_Utenti")/1000) &"