%@ 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" %> <% Application.Lock %>
<%
E1_arr(1) = "E_Sold_Semp"
E1_arr(2) = "E_Sold_Cavallo"
E1_arr(3) = "E_Arcieri_Corto"
E1_arr(4) = "E_Arcieri_Lungo"
E1_arr(5) = "E_Fanteria_Pesante"
E1_arr(6) = "E_Balestrieri"
E1_arr(7) = "E_Cavalleria_Pesante"
E1_arr(8) = "E_Bombardieri"
E1_arr(9) = "E_Cannone"
E1_arr(10) = "E_Generale"
E1_arr(11) = "E_Petardo"
E1_arr(12) = "E_Ballista"
E1_arr(13) = "E_Catapulta"
E1_arr(14) = "E_Ariete"
E1_arr(15) = "E_Trabucco"
Dim Id_Arren = Request.QueryString("id")
Id_Arren = DeCripta(Id_Arren)
Dim VR = Request.QueryString("VR")
VR = DeCripta(VR)
Dim Orario
Dim Orario_Cont
Dim Orario_Reame
Dim Orario_Paese
If VR <> "Confirm" Then
Dim There_Is_Mission = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Type_Mission FROM Missioni WHERE ID = '"& Id_Arren &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If r("Type_Mission") = "Assedio" Then
There_Is_Mission = 1
End If
End While
r.Close()
sqlConn.Close()
If There_Is_Mission = 1 Then
%> Questo attacco non è tuo, non puoi arrenderti!!!")
Response.End
End If
'NOME DEL PAESE ATTACCANTE
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Nome FROM Pianeti WHERE Dimensione = '"& Var_Dimensione_Started_Arren &"' AND Reame = '"& Var_Reame_Started_Arren &"' AND Paese = '"& Var_Paese_Started_Arren &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Nome_Paese_Attaccante = r("Nome")
End While
r.Close()
sqlConn.Close()
'TROVA GLI ID DEI DUE CONTENDENTI PER MANDARE POI I MESSAGGI
Dim Id_Utente_Arreso
Dim Id_Utente_Attaccante
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Username = '"& Var_Army_Of &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Utente_Arreso = r("ID")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Username = '"& Var_Prop_Attaccante &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Utente_Attaccante = r("ID")
End While
r.Close()
sqlConn.Close()
Dim Var_Id_Principal_Paese
Dim Var_Dimensione_Arrive_Arren_P
Dim Var_Reame_Arrive_Arren_P
Dim Var_Paese_Arrive_Arren_P
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID, Dimensione, Reame, Paese FROM Pianeti WHERE Proprietary = '"& Var_Army_Of &"' AND Is_Principal = 1 ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Dimensione_Arrive_Arren_P = r("Dimensione")
Var_Reame_Arrive_Arren_P = r("Reame")
Var_Paese_Arrive_Arren_P = r("Paese")
Var_Id_Principal_Paese = r("ID")
End While
r.Close()
sqlConn.Close()
If Var_Is_Principal = 0 Then
Dim Somma_Soldati_da_Spostare = 0
For I = 1 tO 15
Somma_Soldati_da_Spostare = Somma_Soldati_da_Spostare + Q1_arr(i)
Next
'SE CI SONO SOLDATI SPOSTALI DALLA COLONIA AL PIANETA PRINCIPALE
If Somma_Soldati_da_Spostare > 0 Then
Orario_Cont = Int(Var_Dimensione_Started_Arren - Var_Dimensione_Arrive_Arren_P)
If Orario_Cont < 0 Then
Orario_Cont = -Orario_Cont
End If
Orario_Reame = Int(Var_Reame_Started_Arren - Var_Reame_Arrive_Arren_P)
If Orario_Reame < 0 Then
Orario_Reame = -Orario_Reame
End If
Orario_Paese = Int(Var_Paese_Started_Arren - Var_Paese_Arrive_Arren_P)
If Orario_Paese < 0 Then
Orario_Paese = -Orario_Paese
End If
Orario = New System.TimeSpan(0, ((Orario_Cont*3)+Orario_Reame*0.1), ((Orario_Reame*10)+(Orario_Paese*10)), 0)
dim m_sql as String = "INSERT INTO Missioni (Type_Mission, Time_Started, Time_Arrive, Army_Of, Dimensione_Arrive, Reame_Arrive, Paese_Arrive, Dimensione_Started, Reame_Started, Paese_Started, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro) VALUES (@Type_Mission, @Time_Started, @Time_Arrive, @Army_Of, @Dimensione_Arrive, @Reame_Arrive, @Paese_Arrive, @Dimensione_Started, @Reame_Started, @Paese_Started, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro)"
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 = Var_Army_Of
m_cmd.Parameters.Add("@Dimensione_Arrive", sqldbtype.int).Value = Var_Dimensione_Arrive_Arren_P
m_cmd.Parameters.Add("@Reame_Arrive", sqldbtype.int).Value = Var_Reame_Arrive_Arren_P
m_cmd.Parameters.Add("@Paese_Arrive", sqldbtype.int).Value = Var_Paese_Arrive_Arren_P
m_cmd.Parameters.Add("@Dimensione_Started", sqldbtype.int).Value = Var_Dimensione_Arrive_Arren
m_cmd.Parameters.Add("@Reame_Started", sqldbtype.int).Value = Var_Reame_Arrive_Arren
m_cmd.Parameters.Add("@Paese_Started", sqldbtype.int).Value = Var_Paese_Arrive_Arren
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_Ferro", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Dim ID_Missione
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Army_Of = '"& Var_Army_Of &"' ORDER BY ID ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
ID_Missione = r("ID")
End While
r.Close()
sqlConn.Close()
For i = 1 to 15
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
m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = E1_arr(i)
m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = Q1_arr(i)
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Next
End If
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Soldati_In_Missione WHERE Id_Missione= '"& Id_Arren &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
For i = 1 to 15
If r("Type_Soldato") = E1_arr(i) Then
Q1_arr(i) = r("Quantity_Soldato")
End If
Next
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
Stringa = "UPDATE Pianeti SET "
For i = 1 to 15
If i <> 10 Then
Stringa = Stringa + " "& E1_arr(i) &" = '"& Q1_arr(i) &"', "
End If
Next
Stringa = Stringa + "Proprietary = '"& Var_Prop_Attaccante &"' WHERE ID = "& Id_Paese_Arreso &" "
sqlComm = New SqlCommand(Stringa ,sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
'CANCELLA LA MISSIONE TANTO ORMAI HA CONQUISTATO LA COLONIA
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Missioni WHERE ID = '" & Id_Arren & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Soldati_In_Missione WHERE ID_Missione = '" & Id_Arren & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
'SE C'ERA ANCHE UN GENERALE QUELLO DEVE TORNARE A CASA
If Q1_arr(10) > 0 Then
Dim m_conn
Dim m_cmd
Orario_Cont = Int(Var_Dimensione_Arrive_Arren - Var_Dimensione_Started_Arren)
If Orario_Cont < 0 Then
Orario_Cont = -Orario_Cont
End If
Orario_Reame = Int(Var_Reame_Arrive_Arren - Var_Reame_Started_Arren)
If Orario_Reame < 0 Then
Orario_Reame = -Orario_Reame
End If
Orario_Paese = Int(Var_Paese_Arrive_Arren - Var_Paese_Started_Arren)
If Orario_Paese < 0 Then
Orario_Paese = -Orario_Paese
End If
Orario = New System.TimeSpan(0, ((Orario_Cont*3)+Orario_Reame*0.1), ((Orario_Reame*10)+(Orario_Paese*10)), 0)
m_sql = "INSERT INTO Missioni (Type_Mission, Time_Started, Time_Arrive, Army_Of, Dimensione_Arrive, Reame_Arrive, Paese_Arrive, Dimensione_Started, Reame_Started, Paese_Started, Ris_Legna, Ris_Pietra, Ris_Ferro, Ris_Zolfo, Ris_Oro) VALUES (@Type_Mission, @Time_Started, @Time_Arrive, @Army_Of, @Dimensione_Arrive, @Reame_Arrive, @Paese_Arrive, @Dimensione_Started, @Reame_Started, @Paese_Started, @Ris_Legna, @Ris_Pietra, @Ris_Ferro, @Ris_Zolfo, @Ris_Oro)"
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 = Var_Prop_Attaccante
m_cmd.Parameters.Add("@Dimensione_Arrive", sqldbtype.int).Value = Var_Dimensione_Started_Arren
m_cmd.Parameters.Add("@Reame_Arrive", sqldbtype.int).Value = Var_Reame_Started_Arren
m_cmd.Parameters.Add("@Paese_Arrive", sqldbtype.int).Value = Var_Paese_Started_Arren
m_cmd.Parameters.Add("@Dimensione_Started", sqldbtype.int).Value = Var_Dimensione_Arrive_Arren
m_cmd.Parameters.Add("@Reame_Started", sqldbtype.int).Value = Var_Reame_Arrive_Arren
m_cmd.Parameters.Add("@Paese_Started", sqldbtype.int).Value = Var_Paese_Arrive_Arren
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_Ferro", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ris_Zolfo", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
DIm ID_Missione_Generale
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Missioni WHERE Army_Of = '"& Var_Prop_Attaccante &"' AND Type_Mission = 'Rinforzi' AND Dimensione_Started = '"& Var_Dimensione_Arrive_Arren &"' AND Reame_Started = '"& Var_Reame_Arrive_Arren &"' AND Paese_Started = '"& Var_Paese_Arrive_Arren &"' AND Dimensione_Arrive = '"& Var_Dimensione_Started_Arren &"' AND Reame_Arrive = '"& Var_Reame_Started_Arren &"' AND Paese_Arrive = '"& Var_Paese_Started_Arren &"' ORDER BY ID ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
ID_Missione_Generale = 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_Generale
m_cmd.Parameters.Add("@Type_Soldato", sqldbtype.varchar).Value = "E_Generale"
m_cmd.Parameters.Add("@Quantity_Soldato", sqldbtype.int).Value = "1"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
End If
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 di "& Nome_Paese_Arreso &" si sono arrese al Paese di "& Nome_Paese_Attaccante &" e hanno dovuto cedere la colonia, comprese le risorse che vi si trovavano: |