%
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
%>