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