%@ 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 Codice = Request.QueryString("Codice") Dim Id = Request.QueryString("Id") If Codice = "Elimina" Then Dim Utente_Da_Bannare sqlConn.Open() sqlComm = New SqlCommand("SELECT Username FROM Utenti WHERE ID = '" & Id &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Utente_Da_Bannare = r("Username") End While r.Close() sqlConn.Close() Dim arr(11) Dim counter = 0 For counter = 0 to 11 sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Pianeti WHERE Proprietary = '" & Utente_Da_Bannare &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() arr(counter) = r("ID") End While r.Close() sqlConn.Close() Next sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Utenti WHERE ID = '"& Id &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Pianeti WHERE Proprietary = '"& Utente_Da_Bannare &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Dim Is_Missione While Is_Missione = 1 Is_Missione = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Missioni WHERE Army_Of = '" & Utente_Da_Bannare &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Missione = r("Id") Is_Missione = 1 End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '"& Id_Missione &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Soldati_In_Missione WHERE Id_Missione = '"& Id_Missione &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End While sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE Id_Utente = '"& Id &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Lista_Amici WHERE Id_Utente = '"& Id &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() For counter = 0 to 11 sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Code WHERE Id_Paese = '"& arr(counter) &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Edifici WHERE Id_Paese = '"& arr(counter) &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Ricerche WHERE Id_Paese = '"& arr(counter) &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Esercito WHERE Id_Paese = '"& arr(counter) &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Next End If %>