<%@ 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" %> <% Application.Lock %> <% Dim codice = Request.QueryString("codice") codice = Decripta(codice) Dim Id_Started Dim Id_Arrive Dim Lavoro Dim Data_Inizio Dim Army_Of Dim Colonize = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Missioni WHERE ID = '"& codice &"' AND Ritirata = 'N' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Started = r("Id_Started") Id_Arrive = r("Id_Arrive") Ris_Legna = r("Ris_Legna") Ris_Pietra = r("Ris_Pietra") Ris_Mana = r("Ris_Mana") Ris_Oro = r("Ris_Oro") Army_Of = r("Army_Of") Lavoro = (DateDiff("s",r("Time_Started"), DateTime.Now)) If r("Type_Mission") = "Colonizzare" Then Colonize = 1 End If End While r.Close() sqlConn.Close() If Army_Of <> Proprietary Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",727) &"") Response.End End If Dim Data_Adesso = DateTime.Now Data_Adesso = Replace(Data_Adesso ,".",":") 'Data_Inizio = DateAdd("s", Lavoro, Data_Adesso) Data_Inizio = Datetime.Now.AddSeconds(Lavoro) Data_Inizio = Replace(Data_Inizio,".",":") 'Data_Inizio = Format_Date(Data_Inizio) 'Data_Adesso = Format_Date(Data_Adesso) If Colonize = 1 Then m_sql = "INSERT INTO Missioni (Type_Mission, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Time_Started, Time_Arrive, Id_Started, Id_Arrive, Morti_Atk, Morti_Ass, Army_Of, Ritirata, Colonize) VALUES (@Type_Mission, @Ris_Legna, @Ris_Pietra, @Ris_Mana, @Ris_Oro, @Time_Started, @Time_Arrive, @Id_Started, @Id_Arrive, @Morti_Atk, @Morti_Ass, @Army_Of, @Ritirata, @Colonize)" 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 = "Rinforzi" m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = Ris_Legna m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = Ris_Pietra m_cmd.Parameters.Add("@Ris_Mana", sqldbtype.int).Value = Ris_Mana m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = Ris_Oro m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = Data_Adesso m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = Data_Inizio m_cmd.Parameters.Add("@Id_Started", sqldbtype.int).Value = Id_Arrive m_cmd.Parameters.Add("@Id_Arrive", sqldbtype.int).Value = Id_Started 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 = Army_Of m_cmd.Parameters.Add("@Ritirata", sqldbtype.varchar).Value = "Y" m_cmd.Parameters.Add("@Colonize", sqldbtype.varchar).Value = Colonize m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If If Colonize <> 1 Then m_sql = "INSERT INTO Missioni (Type_Mission, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Time_Started, Time_Arrive, Id_Started, Id_Arrive, Morti_Atk, Morti_Ass, Army_Of, Ritirata) VALUES (@Type_Mission, @Ris_Legna, @Ris_Pietra, @Ris_Mana, @Ris_Oro, @Time_Started, @Time_Arrive, @Id_Started, @Id_Arrive, @Morti_Atk, @Morti_Ass, @Army_Of, @Ritirata)" 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 = "Rinforzi" m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = Ris_Legna m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = Ris_Pietra m_cmd.Parameters.Add("@Ris_Mana", sqldbtype.int).Value = Ris_Mana m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = Ris_Oro m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = Data_Adesso m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = Data_Inizio m_cmd.Parameters.Add("@Id_Started", sqldbtype.int).Value = Id_Arrive m_cmd.Parameters.Add("@Id_Arrive", sqldbtype.int).Value = Id_Started 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 = Army_Of m_cmd.Parameters.Add("@Ritirata", sqldbtype.varchar).Value = "Y" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If Dim Id_Last_Mission_Created sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Type_Mission = 'Rinforzi' AND Id_Arrive = '"& Id_Started &"' AND Id_Started = '"& Id_Arrive &"' AND Army_Of = '"& Army_Of &"' ORDER BY ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Last_Mission_Created = r("Id") End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Soldati_In_Missione SET Id_Missione = '"& Id_Last_Mission_Created &"' WHERE Id_Missione = '"& codice &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '"& codice &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Application.UnLock Response.Redirect ("riepilogo.aspx") %>