<%@ 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 ("") 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) &"
") %>