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


<% Dim Codice = DeCripta(Request.QueryString("Codice")) Dim Gilda = Request.QueryString("Gilda") Response.Write(Read_File("inc\Lang\Languages.aspx",259)) %>


 
<% If Codice = "Lista" Then Response.Write ("") sqlConn.Open() sqlComm = New SqlCommand("SELECT SUM(Utenti.Fama) as Fama_Utenti, Utenti.Gilda FROM Utenti WHERE Utenti.Gilda <> '' GROUP BY Utenti.Gilda ORDER BY Utenti.Gilda", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("") End While r.Close() sqlConn.Close() Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",259) &"Fama


"& (r("Gilda")) &""& CInt(r("Fama_Utenti")/1000) &"
") End If If Codice = "Gilda" Then Response.Write ("") Dim Fama_Gilda = 0 Dim Amministratore_Nome sqlConn.Open() sqlComm = New SqlCommand("SELECT Fama, Grado_Gilda, Username FROM Utenti WHERE Gilda = '" & Gilda &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Fama_Gilda = Fama_Gilda + r("Fama") If r("Grado_Gilda") = 1 Then Amministratore_Nome = r("Username") End If End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT Descrizione, Nome, Tag, Grado_1, Grado_2, Grado_3, Grado_4, Grado_5 FROM Gilde WHERE Tag = '" & Gilda &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("

") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",260) &""& Replace(r("Nome"),"''","'") &"
"& Read_File("inc\Lang\Languages.aspx",261) &""& Trim(r("Tag")) &"
"& Read_File("inc\Lang\Languages.aspx",262) &""& CInt(Fama_Gilda/1000) &"


"& Read_File("inc\Lang\Languages.aspx",263) &" "& Read_File("inc\Lang\Languages.aspx",264) &""& r("Grado_1") &"
"& Read_File("inc\Lang\Languages.aspx",263) &" "& Read_File("inc\Lang\Languages.aspx",265) &" 2° "& Read_File("inc\Lang\Languages.aspx",266) &""& r("Grado_2") &"
"& Read_File("inc\Lang\Languages.aspx",263) &" "& Read_File("inc\Lang\Languages.aspx",265) &" 3° "& Read_File("inc\Lang\Languages.aspx",266) &""& r("Grado_3") &"
"& Read_File("inc\Lang\Languages.aspx",263) &" "& Read_File("inc\Lang\Languages.aspx",265) &" 4° "& Read_File("inc\Lang\Languages.aspx",266) &""& r("Grado_4") &"
"& Read_File("inc\Lang\Languages.aspx",263) &" "& Read_File("inc\Lang\Languages.aspx",265) &" 5° "& Read_File("inc\Lang\Languages.aspx",266) &""& r("Grado_5") &"




") Response.Write (""& Read_File("inc\Lang\Languages.aspx",266) &":

"& r("Descrizione") &"
") End While r.Close() sqlConn.Close() Response.Write ("


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

"& Amministratore_Nome &"


Lista Membri:

") sqlConn.Open() sqlComm = New SqlCommand("SELECT Utenti.Id as Id_Utente, Username, Grado_Gilda, Grado_1, Grado_2, Grado_3, Grado_4, Grado_5 FROM Utenti JOIN Gilde ON TAG = '" & Gilda &"' WHERE Gilda = '" & Gilda &"' ORDER BY Grado_Gilda", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("
"& r("Username") &":") Dim Gilda_GR = "Grado_" + CStr(r("Grado_Gilda")) Response.Write (""& r(Gilda_GR) &"
") End While r.Close() sqlConn.Close() End If %>