%
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Winner = 'Ass', Morti_Atk = "& Morti_Atk &", Morti_Ass = "& Morti_Ass &" WHERE Id = '"+ Id +"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
If End_Battle = 1
If Q2_arr(10) Then
Dim Exp_General
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Generali WHERE Dimensione = '"& Var_Dimensione_Arrive &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' 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 &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' 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 &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' 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 &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If (Var_Rnd) > 8 Then
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Arrive &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' ", 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 * FROM Generali WHERE Dimensione = '"& Var_Dimensione_Started &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' 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 &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' 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 &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET G_Captured = '"& Var_ID_Generale &"' WHERE Dimensione = '"& Var_Dimensione_Arrive &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.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
Application.Lock
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET E_Generale = 1 WHERE Dimensione = '"& Var_Dimensione_Started &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Application.UnLock
End If
End If
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Arrive &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' ", 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 * FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Arrive &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' ", 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 = "& Var_Prigionieri &" WHERE Dimensione = '"& Var_Dimensione_Arrive &"' AND Reame = '"& Var_Reame_Arrive &"' AND Paese = '"& Var_Paese_Arrive &"' ", sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Dim Name_Old_Paese_Nemico
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Started &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' ", 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 &"' AND Reame = '"& Var_Reame_Started &"' AND Paese = '"& Var_Paese_Started &"' ", sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
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 + "' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Id_Utente = r("Id_Utente")
End While
r.Close()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente) VALUES (@Messaggio, @Data, @Id_Utente)"
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 & "
Reame: " & Var_Reame_Arrive & "
Paese: " & Var_Paese_Arrive & ""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Utenti WHERE Username = '" + Proprietary_Old_Paese+ "' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Id_Utente = r("ID")
End While
r.Close()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente) VALUES (@Messaggio, @Data, @Id_Utente)"
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 & "
Reame: " & Var_Reame_Started & "
Paese: " & Var_Paese_Started & ""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Soldati_in_Missione WHERE Id_Missione = '" & Id & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '" & Id & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
%>