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






<% End If 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 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 ("") Response.Write ("") 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 ("") Response.Write ("") If Gilda_This_User = " " Then Response.Write ("") End If If Gilda_This_User = Gilda_Tag AND Grado_Gilda_This_User <> 1 Then Response.Write ("") End If Response.Write ("



Gilda: "& Replace(r("Name"),"''","'") &"") Response.Write ("

Tag: "& Replace(r("Tag"),"''","'") &"") Response.Write ("



Background:

"& Replace(Replace(r("Background"),"''","'"),VbCrLf,"
") &"



UtenteGradoFama

"& r("Username") &""& r(Grado_Gilda_Tot) &""& r("Fama_Utenti") &"

Membri: "& Times &"Tot: "& Tot_Fama &"



Richiedi ingresso in questa Gilda.



Lascia questa Gilda
") End If If See_Bg = "" Then Response.Write ("
GildaMembriFama
") 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 ("
"& r("Gilda") &""& r("Totale_Utenti") &""& r("Fama_Utenti") &"
") End While r.Close() sqlConn.Close() Response.Write ("

Crea una Gilda") End If End If %>