<%@ 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" %> <% sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Type_Mission = 'Assedio' AND Army_Of = 'Denotar Delsing' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Type_Mission = 'Assedio' AND Army_Of = 'Spillero' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() m_sql = "INSERT INTO Missioni (Type_Mission, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro, Time_Started, Time_Arrive, Dimensione_Started, Reame_Started, Paese_Started, Dimensione_Arrive, Reame_Arrive, Paese_Arrive, Morti_Atk, Morti_Ass, Army_Of) VALUES (@Type_Mission, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro, @Time_Started, @Time_Arrive, @Dimensione_Started, @Reame_Started, @Paese_Started, @Dimensione_Arrive, @Reame_Arrive, @Paese_Arrive, @Morti_Atk, @Morti_Ass, @Army_Of)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Type_Mission", sqldbtype.varchar).Value = "Assedio" m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Ferro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = "11/12/2005 2:25:00" m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = "11/12/2005 3:25:00" m_cmd.Parameters.Add("@Dimensione_Started", sqldbtype.int).Value = 11 m_cmd.Parameters.Add("@Reame_Started", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Paese_Started", sqldbtype.int).Value = 21 m_cmd.Parameters.Add("@Dimensione_Arrive", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Reame_Arrive", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Paese_Arrive", sqldbtype.int).Value = 19 m_cmd.Parameters.Add("@Morti_Atk", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Morti_Ass", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Army_Of", sqldbtype.varchar).Value = "Denotar Delsing" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close Dim Id_Last_Mission_Created sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Type_Mission = 'Assedio' AND Army_Of = 'Denotar Delsing' ORDER BY ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Last_Mission_Created = r("Id") End While r.Close() sqlConn.Close() response.write (Id_Last_Mission_Created) m_sql = "INSERT INTO Soldati_in_Missione (PF, Id_Soldato, Id_Missione, Type_Soldato, Quantity_Soldato) VALUES (@PF, @Id_Soldato, @Id_Missione, @Type_Soldato, @Quantity_Soldato)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Soldato", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Id_Missione", sqldbtype.int).Value = Id_Last_Mission_Created m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_Semp" m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = 15 m_cmd.Parameters.Add("@PF", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close m_sql = "INSERT INTO Missioni (Type_Mission, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro, Time_Started, Time_Arrive, Dimensione_Started, Reame_Started, Paese_Started, Dimensione_Arrive, Reame_Arrive, Paese_Arrive, Morti_Atk, Morti_Ass, Army_Of) VALUES (@Type_Mission, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro, @Time_Started, @Time_Arrive, @Dimensione_Started, @Reame_Started, @Paese_Started, @Dimensione_Arrive, @Reame_Arrive, @Paese_Arrive, @Morti_Atk, @Morti_Ass, @Army_Of)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Type_Mission", sqldbtype.varchar).Value = "Assedio" m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Ferro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = "11/12/2005 2:25:00" m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = "11/12/2005 3:25:00" m_cmd.Parameters.Add("@Dimensione_Started", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Reame_Started", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Paese_Started", sqldbtype.int).Value = 24 m_cmd.Parameters.Add("@Dimensione_Arrive", sqldbtype.int).Value = 3 m_cmd.Parameters.Add("@Reame_Arrive", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Paese_Arrive", sqldbtype.int).Value = 19 m_cmd.Parameters.Add("@Morti_Atk", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Morti_Ass", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Army_Of", sqldbtype.varchar).Value = "Spillero" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Type_Mission = 'Assedio' AND Army_Of = 'Spillero' ORDER BY ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Last_Mission_Created = r("Id") End While r.Close() sqlConn.Close() response.write (Id_Last_Mission_Created) m_sql = "INSERT INTO Soldati_in_Missione (PF, Id_Soldato, Id_Missione, Type_Soldato, Quantity_Soldato) VALUES (@PF, @Id_Soldato, @Id_Missione, @Type_Soldato, @Quantity_Soldato)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Id_Soldato", sqldbtype.int).Value = 1 m_cmd.Parameters.Add("@Id_Missione", sqldbtype.int).Value = Id_Last_Mission_Created m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_Semp" m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = 5 m_cmd.Parameters.Add("@PF", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close sqlConn.Open() sqlComm = New SqlCommand("SELECT Type_Soldato, Quantity_Soldato, PF, Morti_Atk, Morti_Ass FROM Missioni JOIN Soldati_In_Missione ON Missioni.Id = Soldati_In_Missione.Id_Missione WHERE Missioni.Id = '"& Id_Last_Mission_Created &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.write (r("Type_Soldato")) Response.write (r("Quantity_Soldato")) Response.write ("
") End While r.Close() sqlConn.Close() %>