%@ 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" %> <%@ Import namespace="System.Drawing" %> <% Dim Var_Id_Arrive = Decripta(Request.QueryString("Id")) Dim There_Is_Paese_x = "0" Dim Proprietary_Paese = "" sqlConn.Open() sqlComm = New SqlCommand("SELECT Dimensione, Reame, Paese, Proprietary FROM Pianeti WHERE Id = '"& Var_Id_Arrive &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Dimensione_Arrive = r("Dimensione") Var_Reame_Arrive = r("Reame") Var_Paese_Arrive = r("Paese") There_Is_Paese_x = "1" Proprietary_Paese = r("Proprietary") End While r.Close() sqlConn.Close() Dim Errore = 0 If There_Is_Paese_x = "0" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",745) &"" End If If Proprietary = Proprietary_Paese Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",746) &"" End If If Var_E_Sold_15 < 1 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",747) &"" End If If Errore = "0" Dim m_conn Dim m_cmd Dim Orario_Cont = Int(Var_Dimensione_Arrive - Dimensione) If Orario_Cont < 0 Then Orario_Cont = -Orario_Cont End If Dim Orario_Reame = Int(Var_Reame_Arrive - Reame) If Orario_Reame < 0 Then Orario_Reame = -Orario_Reame End If Dim Orario_Paese = Int(Var_Paese_Arrive - Paese) If Orario_Paese < 0 Then Orario_Paese = -Orario_Paese End If Dim Orario_Minuti = Time_Movement(Orario_Cont, Orario_Reame, Orario_Paese) Dim Orario = New System.TimeSpan(0, 0, Orario_Minuti, 0) dim m_sql as String = "INSERT INTO Missioni (Type_Mission, Time_Started, Time_Arrive, Army_Of, Id_Arrive, Id_Started, Morti_Atk, Morti_Ass, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Ritirata) VALUES (@Type_Mission, @Time_Started, @Time_Arrive, @Army_Of, @Id_Arrive, @Id_Started, @Morti_Atk, @Morti_Ass, @Ris_Legna, @Ris_Pietra, @Ris_Mana, @Ris_Oro, @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 = "Spionaggio" m_cmd.Parameters.Add("@Time_Started", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Time_Arrive", sqldbtype.datetime).Value = Datetime.Now.Add(Orario) m_cmd.Parameters.Add("@Army_Of", sqldbtype.varchar).Value = Proprietary m_cmd.Parameters.Add("@Id_Arrive", sqldbtype.int).Value = Var_Id_Arrive m_cmd.Parameters.Add("@Id_Started", sqldbtype.int).Value = Id_Paese m_cmd.Parameters.Add("@Morti_Atk", sqldbtype.int).Value = "0" m_cmd.Parameters.Add("@Morti_Ass", sqldbtype.int).Value = "0" 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_Mana", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ritirata", sqldbtype.char).Value = "N" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close Dim ID_Missione_x sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Army_Of = '"& Proprietary &"' AND Id_Arrive = "& Var_Id_Arrive &" AND Id_Started = "& Id_Paese &" ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() ID_Missione_x = r("ID") End While r.Close() sqlConn.Close() m_sql = "INSERT INTO Soldati_in_Missione (Id_Soldato, Id_Missione, Type_Soldato, Quantity_Soldato) VALUES (@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_Missione_x m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_15" m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = 1 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close sqlConn.Open() sqlComm = New SqlCommand("UPDATE Esercito SET E_Sold_15 = E_Sold_15 - 1 WHERE Id_Paese = '"& Id_Paese &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",748) &" " & Var_Dimensione_Arrive &"."& Var_Reame_Arrive &"."& Var_Paese_Arrive &" " End If %>
Pannello Spionaggio