<%@ 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 Fama_Nemico Dim Id_Paese_Nemico Dim Utente_Nemico Dim Errore = "0" Dim Counter_Sold_Atk = 0 Dim Counter_Sold_General = 0 Dim Utente_In_Vacanza = 0 Dim Utente_Is_Banned = 0 Dim Var_arr(20) Dim Dim_Paese Dim Rea_Paese Dim Pae_Paese Dim There_Is_Paese_VE Dim QF_arr(20) For i = 1 to 18 QF_arr(i) = Request.Form("Txt_E_Sold_"& i) QF_arr(i) = Replace(QF_arr(i),".","") QF_arr(i) = Replace(QF_arr(i),",","") Next Dim Not_Enough_Sold = "0" Dim Dim_To_Go = Request.Form("Text_Coord_Cont") Dim Rea_To_Go = Request.Form("Text_Coord_Reame") Dim Pae_To_Go = Request.Form("Text_Coord_Paese") Dim Tipo_Missione = Request.Form("Tipo_Missione") Dim Req_Legna = Request.Form("Text_Ris_Legna") Dim Req_Pietra = Request.Form("Text_Ris_Pietra") Dim Req_Mana = Request.Form("Text_Ris_Mana") Dim Req_Oro = Request.Form("Text_Ris_Oro") If Only_Num(Req_Legna) <> 0 OR Only_Num(Req_Pietra) <> 0 OR Only_Num(Req_Mana) <> 0 OR Only_Num(Req_Oro) <> 0 OR Only_Num(Dim_To_Go) <> 0 OR Only_Num(Rea_To_Go) <> 0 OR Only_Num(Pae_To_Go) <> 0 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",684) &"" End If If Errore = "0" Then For i = 1 to 18 If Only_Num(QF_arr(i)) <> 0 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",684) &"" End If Var_arr(i) = (Abs(Int(-Q_arr(i))) - QF_arr(i)) If i < 15 Then Counter_Sold_Atk = Counter_Sold_Atk + QF_arr(i) End If Counter_Sold_General = Counter_Sold_General + QF_arr(i) If Var_arr(i) < 0 Then Not_Enough_Sold = "1" End If Next If Tipo_Missione <> "" Then For i = 1 to 18 If Q_arr(i) <> CInt(Q_arr(i)) Then QF_arr(i) = (QF_arr(i) - 1) + (Q_arr(i) - Int(Q_arr(i))) End If Next If Dim_To_Go < 1 OR Dim_To_Go > 20 OR Rea_To_Go < 1 OR Rea_To_Go > 20 OR Pae_To_Go < 1 OR Pae_To_Go > 50 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",760) &"" End If If Tipo_Missione = "Radio_Attacco" AND Counter_Sold_Atk = 0 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",761) &"" End If If Tipo_Missione = "Radio_Rinforzi" AND Counter_Sold_General = 0 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",761) &"" End If If Not_Enough_Sold = "1" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",762) &"" End If There_Is_Paese_VE = "0" Dim Is_Principal_Col sqlConn.Open() sqlComm = New SqlCommand("SELECT Pianeti.Id, Pianeti.Nome, Pianeti.Is_Principal, Utenti.Registration_Data, Username, Fama, Vacanza, Ban FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Pianeti.Dimensione = '" + Dim_To_Go + "' AND Pianeti.Reame = '" + Rea_To_Go + "' AND Pianeti.Paese = '" + Pae_To_Go + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() There_Is_Paese_VE = "1" Fama_Nemico = r("Fama") Id_Paese_Nemico = r("Id") Utente_Nemico = r("Username") Utente_In_Vacanza = r("Vacanza") Utente_Is_Banned = r("Ban") Registration_Data = r("Registration_Data") Is_Principal_Col = r("Is_Principal") End While r.Close() sqlConn.Close() If Proprietary <> Utente_Nemico AND Tipo_Missione = "Radio_Rinforzi" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",839) &"" End If If Proprietary = Utente_Nemico AND Tipo_Missione = "Radio_Attacco" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",763) &"" End If 'response.write (Fama_Nemico) If Fama_Nemico < (Fama_Tua/100*50) AND Tipo_Missione = "Radio_Attacco" AND Is_Principal_Col = 1 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",764) &"
" End If If Registration_Data > Datetime.Now.AddDays(-7) AND Tipo_Missione = "Radio_Attacco" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",836) &"
" End If If Utente_In_Vacanza <> 0 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",765) &"
" End If If Utente_Is_Banned <> 0 Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",766) &"
" End If If There_Is_Paese_VE = "0" AND Tipo_Missione <> "Radio_Colonizza" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",767) &"" End If If There_Is_Paese_VE = "1" AND Tipo_Missione = "Radio_Colonizza" Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",777) &"" End If If Tipo_Missione = "Radio_Trasporto" AND (CInt(Req_Legna) + CInt(Req_Pietra) + CInt(Req_Mana) + CInt(Req_Oro)) > (QF_arr(17)*5000 + QF_arr(18)*10000) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",768) &"" End If If Tipo_Missione = "Radio_Trasporto" AND (Only_Num(Req_Legna) <> 0 OR Only_Num(Req_Pietra) <> 0 OR Only_Num(Req_Mana) <> 0 OR Only_Num(Req_Oro) <> 0) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",684) &"" End If If Tipo_Missione = "Radio_Trasporto" AND (CInt(Req_Legna) > Ris_Legna) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",786) &"" End If If Tipo_Missione = "Radio_Trasporto" AND (CInt(Req_Pietra) > Ris_Pietra) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",787) &"" End If If Tipo_Missione = "Radio_Trasporto" AND (CInt(Req_Mana) > Ris_Mana) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",788) &"" End If If Tipo_Missione = "Radio_Trasporto" AND (CInt(Req_Oro) > Ris_Oro) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",789) &"" End If If Tipo_Missione = "Radio_Colonizza" AND (QF_arr(16) < 1) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",769) &"" End If If Tipo_Missione = "Radio_Trasporto" AND ((QF_arr(17) < 1) AND (QF_arr(18) < 1)) Then Errore = "1" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",761) &"" End If If Errore = "0" Then Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",770) &"" Dim m_conn Dim m_cmd Dim Orario_Cont = Int(Dim_To_Go - Dimensione) If Orario_Cont < 0 Then Orario_Cont = -Orario_Cont End If Dim Orario_Reame = Int(Rea_To_Go - Reame) If Orario_Reame < 0 Then Orario_Reame = -Orario_Reame End If Dim Orario_Paese = Int(Pae_To_Go - Paese) If Orario_Paese < 0 Then Orario_Paese = -Orario_Paese End If If Tipo_Missione = "Radio_Attacco" Then sqlConn.Open() Dim Stringa = "UPDATE Esercito SET " For i = 1 to 14 Var_arr(i) = Replace(Var_arr(i),",",".") Stringa = Stringa + " E_Sold_"& i &" = "& Var_arr(i) &" " If i < 14 Then Stringa = Stringa + ", " End If Next Stringa = Stringa + "WHERE Id_Paese = '"& Id_Paese &"' " sqlComm = New SqlCommand(Stringa ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 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 = "Attacco" 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 = Id_Paese_Nemico 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_VE sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id FROM Missioni WHERE Army_Of = '" + Proprietary + "' AND Id_Arrive = '"& Id_Paese_Nemico &"' ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() ID_Missione_VE = r("ID") End While r.Close() sqlConn.Close() For i = 1 to 14 If QF_arr(i) > 0 Then 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 = i m_cmd.Parameters.Add("@Id_Missione", sqldbtype.int).Value = ID_Missione_VE m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_"& i m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.float).Value = QF_arr(i) m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If Next End If If Tipo_Missione = "Radio_Rinforzi" Then sqlConn.Open() Dim Stringa = "UPDATE Esercito SET " For i = 1 to 18 Var_arr(i) = Replace(Var_arr(i),",",".") Stringa = Stringa + " E_Sold_"& i &" = "& Var_arr(i) &" " If i < 18 Then Stringa = Stringa + ", " End If Next Stringa = Stringa + "WHERE Id_Paese = '"& Id_Paese &"' " sqlComm = New SqlCommand(Stringa ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 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 = "Rinforzi" 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 = Id_Paese_Nemico 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_VE sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id FROM Missioni WHERE Army_Of = '" + Proprietary + "' AND Id_Arrive = '"& Id_Paese_Nemico &"' ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() ID_Missione_VE = r("ID") End While r.Close() sqlConn.Close() For i = 1 to 18 If QF_arr(i) > 0 Then 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 = i m_cmd.Parameters.Add("@Id_Missione", sqldbtype.int).Value = ID_Missione_VE m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_"& i m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.float).Value = QF_arr(i) m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If Next End If If Tipo_Missione = "Radio_Trasporto" Then sqlConn.Open() Dim Stringa = "UPDATE Esercito SET " For i = 17 to 18 Var_arr(i) = Replace(Var_arr(i),",",".") Stringa = Stringa + " E_Sold_"& i &" = "& Var_arr(i) &" " If i < 18 Then Stringa = Stringa + ", " End If Next Stringa = Stringa + "WHERE Id_Paese = '"& Id_Paese &"' " sqlComm = New SqlCommand(Stringa ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() Stringa = "UPDATE Pianeti SET Ris_Legna = Ris_Legna - "& CInt(Req_Legna) &", Ris_Pietra = Ris_Pietra - "& CInt(Req_Pietra) &", Ris_Mana = Ris_Mana - "& CInt(Req_Mana) &", Ris_Oro = Ris_Oro - "& CInt(Req_Oro) &" WHERE Id = '"& Id_Paese &"' " sqlComm = New SqlCommand(Stringa ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 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 = "Trasporto" 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 = Id_Paese_Nemico 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 = Req_Legna m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = Req_Pietra m_cmd.Parameters.Add("@Ris_Mana", sqldbtype.int).Value = Req_Mana m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = Req_Oro m_cmd.Parameters.Add("@Ritirata", sqldbtype.char).Value = "N" m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close Dim ID_Missione_VE sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id FROM Missioni WHERE Army_Of = '" + Proprietary + "' AND Id_Arrive = '"& Id_Paese_Nemico &"' ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() ID_Missione_VE = r("ID") End While r.Close() sqlConn.Close() For i = 17 to 18 If QF_arr(i) > 0 Then 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 = i m_cmd.Parameters.Add("@Id_Missione", sqldbtype.int).Value = ID_Missione_VE m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_"& i m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = QF_arr(i) m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If Next End If If Tipo_Missione = "Radio_Colonizza" Then sqlConn.Open() Var_arr(16) = Replace(Var_arr(16),",",".") Stringa = "UPDATE Esercito SET E_Sold_16 = E_Sold_16 - 1 WHERE Id_Paese = '"& Id_Paese &"' " sqlComm = New SqlCommand(Stringa ,sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() 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, Colonize) 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, @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 = "Colonizzare" 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 = 0 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 = Req_Legna m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = Req_Pietra m_cmd.Parameters.Add("@Ris_Mana", sqldbtype.int).Value = 0 m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = Req_Oro m_cmd.Parameters.Add("@Ritirata", sqldbtype.char).Value = "N" m_cmd.Parameters.Add("@Colonize", sqldbtype.varchar).Value = Dim_To_Go &"."& Rea_To_Go &"."& Pae_To_Go m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close Dim ID_Missione_VE sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id FROM Missioni WHERE Army_Of = '" + Proprietary + "' AND Id_Arrive = '"& Id_Paese_Nemico &"' ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() ID_Missione_VE = 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_VE m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Sold_16" m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = 1 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If Response.Redirect ("Riepilogo.aspx") End If End If End If %> <% Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",771) &"

") %>
<% If CStr(QF_arr(1)) = "" Then Response.Write ("") Response.Write ("") For i = 1 to 18 If Q_arr(i) > 0 Then Response.Write ("") End If Next Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",772) &""& Read_File("inc\Lang\Languages.aspx",773) &""& Read_File("inc\Lang\Languages.aspx",774) &"

") If User_Race = "Human" Then Response.Write (Read_File("inc\Lang\Languages.aspx",40 + i)) Else If User_Race = "Elf" Then Response.Write (Read_File("inc\Lang\Languages.aspx",58 + i)) Else If User_Race = "Orc" Then Response.Write (Read_File("inc\Lang\Languages.aspx",76 + i)) Else If User_Race = "Undead" Then Response.Write (Read_File("inc\Lang\Languages.aspx",94 + i)) End If Response.Write (""& Abs(Int(-Q_arr(i)))&"


") Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",37) &"
"& Read_File("inc\Lang\Languages.aspx",775) &"
"& Read_File("inc\Lang\Languages.aspx",36) &"
"& Read_File("inc\Lang\Languages.aspx",38) &"



") Response.Write ("") Response.Write ("

") Response.Write (""& Read_File("inc\Lang\Languages.aspx",460) &": ") Response.Write (""& Read_File("inc\Lang\Languages.aspx",461) &": ") Response.Write ("

") Response.Write (""& Read_File("inc\Lang\Languages.aspx",462) &": ") Response.Write (""& Read_File("inc\Lang\Languages.aspx",463) &": ") Response.Write ("

") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("



") Response.Write (""& Read_File("inc\Lang\Languages.aspx",454) &": ") Response.Write (""& Read_File("inc\Lang\Languages.aspx",455) &": ") Response.Write (""& Read_File("inc\Lang\Languages.aspx",456) &": ") Response.Write ("

") Response.Write ("

") Response.Write ("

") Response.Write ("

") Response.Write ("

") End If %>