<%@ Page Language="vb" Debug="true" ValidateRequest="false" %> <% @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 Utente = DeCripta(Request.QueryString("User")) Dim Confirm = DeCripta(Request.QueryString("Confirm")) Dim Gilda = DeCripta(Request.QueryString("Gilda")) If Codice = "Elimina_Gilda" AND Confirm <> "Si" Then Is_Deleting_Gilda_User = 1 Dim Elimina_Gilda = "Elimina_Gilda" Dim Si = "Si" Messaggio.Text = "Vuoi davvero eliminare completamente la Gilda "& Gilda &" ? [Si] [No]" End If If Codice = "Elimina_Gilda" AND Confirm = "Si" Then Dim Id_Administrator sqlConn.Open() sqlComm = New SqlCommand("SELECT Gilda, Id FROM Utenti WHERE Username = '"& Proprietary &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Gilda = r("Gilda") Id_Administrator = r("ID") End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Gilda = '"& Gilda &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Messaggio di Gilda: La Gilda "& Gilda &" di cui facevi parte è stata sciolta. Per informazioni, contatta l'ex Amministratore "& Proprietary &"" m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = r("ID") m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Gilda" m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Gilda = '', Grado_Gilda = 0 WHERE Gilda = '"& Gilda &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Gilde WHERE Tag = '"& Gilda &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If %>


Invia Modulo di richiesta per i Servizi Premium.


 
Gilde Inattive


<% If Is_Deleting_Gilda_User <> 1 Then %> <% Dim Due_Settimane = New System.TimeSpan(-15, 0, 0, 0) Dim Data_15 = Format_Date(Datetime.Now.Add(Due_Settimane)) sqlConn.Open() sqlComm = New SqlCommand("SELECT Count(*) AS Totale_Utenti, Gilde.Data_Creazione, Gilde.Tag FROM Utenti JOIN Gilde ON Gilde.Tag = Utenti.Gilda WHERE Gilde.Data_Creazione < '"& Data_15 &"' GROUP BY Gilde.Tag, Gilde.Data_Creazione ORDER BY Totale_Utenti", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("Totale_Utenti") < 15 Then Response.Write (""& r("Tag") &" ["& r("Totale_Utenti") &"]["& r("Data_Creazione") &"]

") End If End While r.Close() sqlConn.Close() End If %>