%
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
If Q2_arr(10) > 0 Then
Dim Exp_General
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Exp FROM Generali WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' AND Is_Dead = 0 ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Exp_General = r("Exp")
End While
r.Close()
sqlConn.Close()
Dim Exp
Exp = Exp_General + 5
If Morti_Ass > Morti_Atk*2
Exp = Exp_General + 10
End If
If Morti_Ass > Morti_Atk*3
Exp = Exp_General + 15
End If
Dim Level_General = CInt(Exp/1000)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Generali SET Exp = '"& Exp &"', Livello = '"& Level_General &"' WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' AND Is_Dead = 0 ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If Q1_arr(10) > 0 Then
Dim Var_Rnd = CInt(9*Rnd()) + 1
Randomize()
If (Var_Rnd) < 2 Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Generali SET Is_Dead = 1 WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' AND Is_Dead = 0 ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET E_Generale = 0 WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Dim Var_Id_Utente_Gen_Dead
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_Gen_Dead = 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 = "Il tuo Generale è stato ucciso dal 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_Gen_Dead
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
End If
If (Var_Rnd) > 8 Then
sqlConn.Open()
sqlComm = New SqlCommand("SELECT C_Prigione, R_Guardie, G_Captured FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_C_Prigione = r("C_Prigione")
Var_R_Guardie = r("R_Guardie")
Var_G_Captured = r("G_Captured")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Id, Livello FROM Generali WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' AND Is_Dead = 0 ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Livello_Generale = r("Livello")
Var_ID_Generale = r("ID")
End While
r.Close()
sqlConn.Close()
If (Var_C_Prigione > 0) AND (Var_R_Guardie > (Var_Livello_Generale/5)-1) AND (Var_G_Captured = 0) Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Generali SET Is_Dead = 2 WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' AND Is_Dead = 0 ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET E_Generale = 0 WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET G_Captured = '"& Var_ID_Generale &"' WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Dim Var_Id_Utente_Gen
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_Gen = 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 = "Il tuo Generale è stato catturato dal 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_Gen
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
End If
If (Var_C_Prigione = 0) OR NOT (Var_R_Guardie > (Var_Livello_Generale/5)-1) OR (Var_G_Captured <> 0) Then
Var_Rnd = 5
End If
End If
If (Var_Rnd) > 1 AND (Var_Rnd) < 9 Then
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET E_Generale = 1 WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
End If
sqlConn.Open()
sqlComm = New SqlCommand("SELECT C_Prigione, R_Guardie, P_Prigionieri FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_C_Prigione = r("C_Prigione")
Var_R_Guardie = r("R_Guardie")
Var_Prigionieri = r("P_Prigionieri")
End While
r.Close()
sqlConn.Close()
If Var_C_Prigione > 0 Then
Var_Prigionieri = Var_Prigionieri + (Morti_Atk/20*Var_R_Guardie)
If (Var_C_Prigione*10) > Var_Prigionieri Then
Var_Prigionieri = (Var_C_Prigione*10)
End If
End If
Dim Proprietary_Old_Paese
Dim Name_Old_Paese
sqlConn.Open()
sqlComm = New SqlCommand("SELECT C_Prigione, Morale, Nome, Proprietary, P_Prigionieri, P_Prigionieri, R_Guardie FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Morale = r("Morale")
Var_C_Prigione = r("C_Prigione")
Var_Prigionieri = r("P_Prigionieri")
Var_Guardie = r("R_Guardie")
Proprietary_Old_Paese = r("Proprietary")
Name_Old_Paese = r("Nome")
End While
r.Close()
sqlConn.Close()
Var_Morale = Var_Morale + 5
If Morti_Atk > Morti_Ass*2 Then
Var_Morale = Var_Morale + 10
End If
If Morti_Atk > Morti_Ass*3 Then
Var_Morale = Var_Morale + 15
End If
If Var_Morale > 100 Then
Var_Morale = 100
End If
Var_Prigionieri = Var_Prigionieri + (CInt(Morti_Atk)/20*Var_Guardie)
If Var_Prigionieri > Var_C_Prigione*10 Then
Var_Prigionieri = Var_C_Prigione*10
End If
Var_Morale = Replace(Var_Morale,",",".")
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET Morale = "& Var_Morale &", P_Prigionieri = "& CInt(Var_Prigionieri) &" WHERE Dimensione = '"& Var_Dimensione_Arrive_Atk &"' AND Reame = '"& Var_Reame_Arrive_Atk &"' AND Paese = '"& Var_Paese_Arrive_Atk &"' ", sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Dim Name_Old_Paese_Nemico
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Nome, Morale FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Morale = r("Morale")
Name_Old_Paese_Nemico = r("Nome")
End While
r.Close()
sqlConn.Close()
Var_Morale = Var_Morale - 5
If Morti_Atk > Morti_Ass*2
Var_Morale = Var_Morale - 10
End If
If Morti_Atk > Morti_Ass*3
Var_Morale = Var_Morale - 15
End If
If Var_Morale < -100 Then
Var_Morale = -100
End If
Var_Morale = Replace(Var_Morale,",",".")
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET Morale = "& Var_Morale &" WHERE Dimensione = '"& Var_Dimensione_Started_Atk &"' AND Reame = '"& Var_Reame_Started_Atk &"' AND Paese = '"& Var_Paese_Started_Atk &"' ", sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
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
%>