%@ 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 = "Crea_Gilda" Then
Dim Errore = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT SUM(Soldiers.Level) as Fama_Utente, Gilda FROM Utenti JOIN Soldiers ON Soldiers.Id_Utente = Utenti.Id WHERE Utenti.Id = '"& Id_This_User &"' GROUP BY Gilda ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If r("Fama_Utente") < 1 Then
Response.Write ("
La tua fama non è abbastanza alta per fondare una gilda.")
Errore = 1
End If
If Trim(r("Gilda")) <> "" Then
Response.Write ("
Fai già parte di una gilda!!!")
Errore = 1
End If
End While
r.Close()
sqlConn.Close()
If Errore = 0 Then
TXT_Id_This_User.Text = Id_This_User
%>
Crea Gilda
Nome Gilda: Tag Gilda:
Tag: "& Replace(r("Tag"),"''","'") &"")
Response.Write (" Crea una Gilda")
End If
End If
%>
")
End If
If See_Bg = "" Then
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 WHERE Guilds.Tag = '"& See_Bg &"' 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 (" ")
Response.Write ("
Gilda: "& Replace(r("Name"),"''","'") &"")
Response.Write ("
Background:
"& Replace(Replace(r("Background"),"''","'"),VbCrLf,"
") &" ")
Response.Write ("Utente Grado Fama ")
End If
Times = Times + 1
Tot_Fama = Tot_Fama + r("Fama_Utenti")
Dim Grado_Gilda_Tot = "Grado_" & r("Grado_Gilda")
Response.Write (" ")
End While
r.Close()
sqlConn.Close()
Response.Write (""& r("Username") &" "& r(Grado_Gilda_Tot) &" "& r("Fama_Utenti") &" ")
Response.Write (" ")
If Gilda_This_User = " " Then
Response.Write ("Membri: "& Times &" Tot: "& Tot_Fama &" ")
End If
If Gilda_This_User = Gilda_Tag AND Grado_Gilda_This_User <> 1 Then
Response.Write ("
Richiedi ingresso in questa Gilda. ")
End If
Response.Write ("
Lascia questa Gilda
")
Response.Write ("Gilda Membri Fama
")
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()
Response.Write (""& r("Gilda") &" "& r("Totale_Utenti") &" "& r("Fama_Utenti") &"