<%@ 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 Var_Dimensione_Started_Rit_Mis Dim Var_Reame_Started_Rit_Mis Dim Var_Paese_Started_Rit_Mis Dim Var_Dimensione_Arrive_Rit_Mis Dim Var_Reame_Arrive_Rit_Mis Dim Var_Paese_Arrive_Rit_Mis Dim Lavoro Dim Data_Inizio Dim Army_Of sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Missioni WHERE ID = '"& codice &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Dimensione_Started_Rit_Mis = r("Dimensione_Started") Var_Reame_Started_Rit_Mis = r("Reame_Started") Var_Paese_Started_Rit_Mis = r("Paese_Started") Var_Dimensione_Arrive_Rit_Mis = r("Dimensione_Arrive") Var_Reame_Arrive_Rit_Mis = r("Reame_Arrive") Var_Paese_Arrive_Rit_Mis = r("Paese_Arrive") Ris_Legna = r("Ris_Legna") Ris_Pietra = r("Ris_Pietra") Ris_Ferro = r("Ris_Ferro") Ris_Zolfo = r("Ris_Zolfo") Ris_Oro = r("Ris_Oro") Army_Of = r("Army_Of") Lavoro = (DateDiff("s",r("Time_Started"), DateTime.Now)) End While r.Close() sqlConn.Close() If Army_Of <> Proprietary Then Response.Write ("

Questa missione non è tua, non puoi ritirarla!!!") Response.End End If Dim Data_Adesso = DateTime.Now Data_Adesso = Replace(Data_Adesso ,".",":") Data_Adesso = Format_Date(Data_Adesso) Data_Inizio = DateAdd("s", Lavoro, Data_Adesso) Data_Inizio = Replace(Data_Inizio,".",":") Data_Inizio = Format_Date(Data_Inizio) 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 = "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_Ferro", sqldbtype.int).Value = Ris_Ferro m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.int).Value = Ris_Zolfo 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("@Dimensione_Started", sqldbtype.int).Value = Var_Dimensione_Arrive_Rit_Mis m_cmd.Parameters.Add("@Reame_Started", sqldbtype.int).Value = Var_Reame_Arrive_Rit_Mis m_cmd.Parameters.Add("@Paese_Started", sqldbtype.int).Value = Var_Paese_Arrive_Rit_Mis m_cmd.Parameters.Add("@Dimensione_Arrive", sqldbtype.int).Value = Var_Dimensione_Started_Rit_Mis m_cmd.Parameters.Add("@Reame_Arrive", sqldbtype.int).Value = Var_Reame_Started_Rit_Mis m_cmd.Parameters.Add("@Paese_Arrive", sqldbtype.int).Value = Var_Paese_Started_Rit_Mis 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_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 = 'Rinforzi' AND Dimensione_Arrive = '"& Var_Dimensione_Started_Rit_Mis &"' AND Reame_Arrive = '"& Var_Reame_Started_Rit_Mis &"' AND Paese_Arrive = '"& Var_Paese_Started_Rit_Mis &"' AND Dimensione_Started = '"& Var_Dimensione_Arrive_Rit_Mis &"' AND Reame_Started = '"& Var_Reame_Arrive_Rit_Mis &"' AND Paese_Started = '"& Var_Paese_Arrive_Rit_Mis &"' 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") %>

  <% Dim i Dim Pre For i = 1 To Counter Ore_JS = arr_Ore(i) Minuti_JS = arr_Minuti(i) Secondi_JS = arr_Secondi(i) Dove = "Div_Missione" + CStr(arr_id(i)) Pre = "M_"+CStr(arr_id(i))+"_" %> <% Next %>