<%@ 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" %>


Classifiche


  <% 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() %><% End While r.Close() sqlConn.Close() %>
Classifica Gilde

Gilda

Membri

Fama

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