<%
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 ("| "& Read_File("inc\Lang\Languages.aspx",259) &" | Fama |
|
| ")
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 ("| "& (r("Gilda")) &" | "& CInt(r("Fama_Utenti")/1000) &" | ")
End While
r.Close()
sqlConn.Close()
Response.Write (" ")
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 ("| "& Read_File("inc\Lang\Languages.aspx",260) &" | "& Replace(r("Nome"),"''","'") &" | ")
Response.Write ("| "& Read_File("inc\Lang\Languages.aspx",261) &" | "& Trim(r("Tag")) &" | ")
Response.Write ("| "& Read_File("inc\Lang\Languages.aspx",262) &" | "& CInt(Fama_Gilda/1000) &" | ")
Response.Write ("
|
| ")
Response.Write ("| "& Read_File("inc\Lang\Languages.aspx",263) &" "& Read_File("inc\Lang\Languages.aspx",264) &" | "& r("Grado_1") &" | ")
Response.Write ("| "& 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") &" | ")
Response.Write ("| "& 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") &" | ")
Response.Write ("| "& 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") &" | ")
Response.Write ("| "& 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 ("
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",266) &":
")
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
%>
|
 |
|
|
 |
 |
|
 |
 |
|