<% Response.Write (""& Read_File("inc\Lang\Languages.aspx",240) &" ""& Var_Paese_Attaccante &"" "& Read_File("inc\Lang\Languages.aspx",242) &" "& Morti_Atk &" "& Read_File("inc\Lang\Languages.aspx",243) &"

") Response.Write (""& Read_File("inc\Lang\Languages.aspx",241) &" ""& Var_Paese_Assediato &"" "& Read_File("inc\Lang\Languages.aspx",242) &" "& Morti_Ass &" "& Read_File("inc\Lang\Languages.aspx",243) &"



") sqlConn.Open() sqlComm = New SqlCommand("UPDATE Missioni SET Winner = 'Ass', Morti_Atk = "& Morti_Atk &", Morti_Ass = "& Morti_Ass &" WHERE Id = '"+ Id_Attacca +"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() If End_Battle = 1 Dim Proprietary_Old_Paese Dim Name_Old_Paese Dim Name_Old_Paese_Nemico Dim Var_Id_Utente_Attacca_Win_Ass sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id, Missioni.Army_Of, Utenti.Username, Utenti.Id as Id_Utente FROM Missioni JOIN Utenti ON Utenti.Username = Missioni.Army_Of WHERE Missioni.ID = '" + Id_Attacca + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Id_Utente_Attacca_Win_Ass = r("Id_Utente") End While r.Close() sqlConn.Close() m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Le tue truppe hanno perso la battaglia contro il Paese di " & Name_Old_Paese & " alle coordinate:

Continente: " & Var_Dimensione_Arrive_Atk & "
Reame: " & Var_Reame_Arrive_Atk & "
Paese: " & Var_Paese_Arrive_Atk & "" m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente_Attacca_Win_Ass m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Assedio" m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Username = '" + Proprietary_Old_Paese+ "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Id_Utente_Attacca_Win_Ass = r("ID") End While r.Close() sqlConn.Close() m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = "Le tue truppe hanno respinto un assedio vincendo la battaglia contro il Paese di " & Name_Old_Paese_Nemico & " provenienti dalle coordinate:

Continente: " & Var_Dimensione_Started_Atk & "
Reame: " & Var_Reame_Started_Atk & "
Paese: " & Var_Paese_Started_Atk & "" m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente_Attacca_Win_Ass m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Assedio" m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0 m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Soldati_in_Missione WHERE Id_Missione = '" & Id_Attacca & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '" & Id_Attacca & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If %>