%@ 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 Page = Request.QueryString ("Page")
Dim See_Bg = Request.QueryString ("See_Bg")
Dim Id_Gilda = 0
Dim Gilda_Tag = ""
If Page = "Lascia_Gilda" Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Gilda = ' ', Grado_Gilda = 0 WHERE Utenti.Id = '"& Id_This_User &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Id_Utente, Type_Message, Messaggio, Data_Messaggio) VALUES (@Id_Utente, @Type_Message, @Messaggio, @Data_Messaggio)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Id_This_User
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Gilda"
m_cmd.Parameters.Add("@Data_Messaggio", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Hai lasciato la tua Gilda."
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Response.Write ("
Hai lasciato la tua Gilda.")
End If
If Page = "" Then
If See_Bg <> "" Then
Dim Times = 0
Dim Tot_Fama = 0
Dim Id
Response.Write ("")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Guilds.Id, SUM(Soldiers.Level) as Fama_Utenti, Guilds.Background, Guilds.Tag, Guilds.Name, Utenti.Username, Utenti.Grado_Gilda, Guilds.Grado_1, Guilds.Grado_2, Guilds.Grado_3, Guilds.Grado_4, Guilds.Grado_5 FROM Utenti JOIN Guilds ON Utenti.Gilda = Guilds.Tag JOIN Soldiers ON Soldiers.Id_Utente = Utenti.Id GROUP BY Utenti.Username, Utenti.Grado_Gilda, Guilds.Grado_1, Guilds.Grado_2, Guilds.Grado_3, Guilds.Grado_4, Guilds.Grado_5, Guilds.Background, Guilds.Tag, GUilds.Name, GUilds.Id ORDER BY Grado_Gilda, Fama_Utenti DESC", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Gilda = r("Id")
Gilda_Tag = r("Tag")
If Times = 0 Then
Response.Write ("
Gilda: "& Replace(r("Name"),"''","'") &"")
Response.Write ("
Tag: "& Replace(r("Tag"),"''","'") &"")
Response.Write ("
Background:
"& Replace(Replace(r("Background"),"''","'"),VbCrLf," ") &"
| ")
Response.Write ("
| Utente | Grado | Fama |
")
Response.Write ("
| | |
")
End If
Times = Times + 1
Tot_Fama = Tot_Fama + r("Fama_Utenti")
Dim Grado_Gilda_Tot = "Grado_" & r("Grado_Gilda")
Response.Write ("| "& r("Username") &" | "& r(Grado_Gilda_Tot) &" | "& r("Fama_Utenti") &" |
")
End While
r.Close()
sqlConn.Close()
Response.Write ("
| | |
")
Response.Write ("| Membri: "& Times &" | | Tot: "& Tot_Fama &" |
")
If Gilda_This_User = " " Then
Response.Write ("
Richiedi ingresso in questa Gilda. |
")
End If
If Gilda_This_User = Gilda_Tag AND Grado_Gilda_This_User <> 1 Then
Response.Write ("
Lascia questa Gilda |
")
End If
Response.Write ("
")
End If
If See_Bg = "" Then
Response.Write ("")
Response.Write ("")
Dim counter = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT TOP 10 SUM(Soldiers.Level) as Fama_Utenti, Count(DISTINCT Utenti.id) AS Totale_Utenti, Utenti.Gilda FROM Utenti JOIN Soldiers ON Utenti.Id = Soldiers.Id_Utente WHERE Utenti.Gilda <> '' GROUP BY Utenti.Gilda ORDER BY Fama_Utenti DESC, Totale_Utenti ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Response.Write ("")
End While
r.Close()
sqlConn.Close()
End If
End If
%>