%@ Import namespace="System.Math" %>
<%
Application.Lock
Dim Url_Rivolta = Request.ServerVariables("PATH_TRANSLATED")
Url_Rivolta = StrReverse(Split(StrReverse(Url_Rivolta),"\")(0))
%>
<%
Dim There_Is = 1
While There_Is = 1
There_Is = 0
Dim Cosa_Costr_Eser = ""
Dim Cosa_Costr_Infr = ""
Dim Cosa_Costr_Res = ""
Dim Cosa_Costr_Dif = ""
Dim Cosa_Costr_Ab = ""
Dim Is_Costruct_Eser = 0
Dim Is_Costruct_Infr = 0
Dim Is_Costruct_Res = 0
Dim Is_Costruct_Dif = 0
Dim Is_Costruct_Ab = 0
Dim Is_Coda_Eser = 0
Dim Is_Coda_Infr = 0
Dim Is_Coda_Res = 0
Dim Is_Coda_Dif = 0
Dim Is_Coda_Ab = 0
Dim Is_Coda_What = ""
Dim Data_Costr_Eser = ""
Dim Data_Costr_Infr = ""
Dim Data_Costr_Res = ""
Dim Data_Costr_Dif = ""
Dim Data_Costr_Ab = ""
Dim Data_Fine_Eser = ""
Dim Data_Fine_Infr = ""
Dim Data_Fine_Res = ""
Dim Data_Fine_Dif = ""
Dim Data_Fine_Ab = ""
Dim Quantity = 0
Dim Race_Coda = ""
Dim What_Cat = ""
Dim Is_Coda_Level
Dim Id_Utente_Incrementa = 0
Dim Data_Last_Access
Dim Cittadini_X
sqlConn.Open()
sqlComm = New SqlCommand("SELECT TOP 1 Data_Last_Access, P_Cittadini, P_Costr_3, P_Costr_4, P_Costr_5, P_Costr_6, Utenti.Id as Id_Utente, Utenti.Race, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Eser, Data_Costr_Eser, Cosa_Costr_Eser, Data_Fine_Eser, In_Costr_Infr, Data_Costr_Infr, Cosa_Costr_Infr, Data_Fine_Infr, In_Costr_Res, Data_Costr_Res, Cosa_Costr_Res, Data_Fine_Res, In_Costr_Dif, Data_Costr_Dif, Cosa_Costr_Dif, Data_Fine_Dif, In_Costr_Ab, Data_Costr_Ab, Cosa_Costr_Ab, Data_Fine_Ab, Code_Eser.Coda_Addestra as Coda_Addestra_Eser, Code_Infr.Coda_Addestra as Coda_Addestra_Infr, Code_Res.Coda_Addestra as Coda_Addestra_Res, Code_Eser.Quantity as Quantity_Eser, Code_Infr.Quantity as Quantity_Infr, Code_Res.Quantity as Quantity_Res, Pianeti.Id as Id_Paese, Code_Eser.Id as Id_Coda_Eser, Code_Infr.Id as Id_Coda_Infr, Code_Res.Id as Id_Coda_Res, C_Costr_1, C_Costr_2, C_Costr_3, C_Costr_4, C_Costr_5, C_Costr_6, C_Costr_7, C_Costr_8, C_Costr_9, C_Costr_10, C_Costr_11, C_Costr_12, C_Costr_13, C_Costr_14, C_Costr_15, R_Ric_1, R_Ric_2, R_Ric_3, R_Ric_4, R_Ric_5, R_Ric_6, R_Ric_7 FROM Pianeti LEFT JOIN Utenti ON Utenti.Username = Pianeti.Proprietary LEFT JOIN Code as Code_Eser ON Pianeti.Id = Code_Eser.Id_Paese AND Code_Eser.Coda_Addestra LIKE 'E_Sold%' LEFT JOIN Code as Code_Infr ON Pianeti.Id = Code_Infr.Id_Paese AND Code_Infr.Coda_Addestra LIKE 'C_Costr%' LEFT JOIN Code as Code_Res ON Pianeti.Id = Code_Res.Id_Paese AND Code_Res.Coda_Addestra LIKE 'R_Ric%' LEFT JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese LEFT JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese WHERE (Data_Fine_Eser < '"& Format_Date(Datetime.Now) &"' AND In_Costr_Eser <> 'No') OR (Data_Fine_Infr < '"& Format_Date(Datetime.Now) &"' AND In_Costr_Infr <> 'No') OR (Data_Fine_Res < '"& Format_Date(Datetime.Now) &"' AND In_Costr_Res <> 'No') OR (Data_Fine_Dif < '"& Format_Date(Datetime.Now) &"' AND In_Costr_Dif <> 'No') OR (Data_Fine_Ab < '"& Format_Date(Datetime.Now) &"' AND In_Costr_Ab <> 'No') ORDER BY Pianeti.ID, Code_Eser.Id, Code_Infr.Id, Code_Res.Id ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Data_Last_Access = r("Data_Last_Access")
Cittadini_X = r("P_Cittadini")
Livello_Legna = r("P_Costr_3")
Livello_Pietra = r("P_Costr_4")
Livello_Mana = r("P_Costr_5")
Livello_Oro = r("P_Costr_6")
Id_Utente_Incrementa = r("Id_Utente")
Ris_Legna = r("Ris_Legna")
Ris_Pietra = r("Ris_Pietra")
Ris_Mana = r("Ris_Mana")
Ris_Oro = r("Ris_Oro")
If (r("Data_Fine_Eser")) < Datetime.Now AND r("In_Costr_Eser") = "Si" Then
What_Cat = "Eser"
There_Is = 1
Is_Costruct_Eser = r("Id_Paese")
Cosa_Costr_Eser = r("Cosa_Costr_Eser")
Race_Coda = r("Race")
If Not r("Coda_Addestra_Eser") Is System.DBNull.Value Then
Is_Coda_Eser = r("Id_Coda_Eser")
Is_Coda_What = r("Coda_Addestra_Eser")
Data_Costr_Eser = r("Data_Costr_Eser")
Data_Fine_Eser = r("Data_Fine_Eser")
Quantity = r("Quantity_Eser")
End If
End If
If (r("Data_Fine_Infr")) < Datetime.Now AND r("In_Costr_Infr") = "Si" Then
What_Cat = "Infr"
There_Is = 1
Is_Costruct_Infr = r("Id_Paese")
Cosa_Costr_Infr = r("Cosa_Costr_Infr")
Race_Coda = r("Race")
If Not r("Coda_Addestra_Infr") Is System.DBNull.Value Then
Is_Coda_Infr = r("Id_Coda_Infr")
Is_Coda_What = r("Coda_Addestra_Infr")
Is_Coda_Level = r(Is_Coda_What)
Data_Costr_Infr = r("Data_Costr_Infr")
Data_Fine_Infr = r("Data_Fine_Infr")
Quantity = r("Quantity_Infr")
End If
End If
If (r("Data_Fine_Res")) < Datetime.Now AND r("In_Costr_Res") = "Si" Then
What_Cat = "Res"
There_Is = 1
Is_Costruct_Res = r("Id_Paese")
Cosa_Costr_Res = r("Cosa_Costr_Res")
Race_Coda = r("Race")
If Not r("Coda_Addestra_Res") Is System.DBNull.Value Then
Is_Coda_Res = r("Id_Coda_Res")
Is_Coda_What = r("Coda_Addestra_Res")
Is_Coda_Level = r(Is_Coda_What)
Data_Costr_Res = r("Data_Costr_Res")
Data_Fine_Res = r("Data_Fine_Res")
Quantity = r("Quantity_Res")
End If
End If
If (r("Data_Fine_Dif")) < Datetime.Now AND r("In_Costr_Dif") = "Si" Then
What_Cat = "Dif"
There_Is = 1
Is_Costruct_Dif = r("Id_Paese")
Cosa_Costr_Dif = r("Cosa_Costr_Dif")
Race_Coda = r("Race")
End If
If (r("Data_Fine_Ab")) < Datetime.Now AND r("In_Costr_Ab") = "Si" Then
What_Cat = "Ab"
There_Is = 1
Is_Costruct_Ab = r("Id_Paese")
Cosa_Costr_Ab = r("Cosa_Costr_Ab")
Race_Coda = r("Race")
End If
End While
r.Close()
sqlConn.Close()
If Is_Costruct_Eser <> 0 AND What_Cat = "Eser" Then
Incrementa_Livello(Cosa_Costr_Eser,"esercito", Is_Costruct_Eser, Is_Coda_Eser, Is_Coda_What, Data_Costr_Eser, Data_Fine_Eser, 1, Id_Utente_Incrementa, Race_Coda, Quantity, Data_Last_Access, Cittadini_X, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Livello_Legna, Livello_Pietra, Livello_Mana, Livello_Oro)
End If
If Is_Costruct_Infr <> 0 AND What_Cat = "Infr" Then
Incrementa_Livello(Cosa_Costr_Infr,"edifici", Is_Costruct_Infr, Is_Coda_Infr, Is_Coda_What, Data_Costr_Infr, Data_Fine_Infr, Is_Coda_Level, Id_Utente_Incrementa, Race_Coda, Quantity, Data_Last_Access, Cittadini_X, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Livello_Legna, Livello_Pietra, Livello_Mana, Livello_Oro)
End If
If Is_Costruct_Res <> 0 AND What_Cat = "Res" Then
Incrementa_Livello(Cosa_Costr_Res,"ricerche", Is_Costruct_Res, Is_Coda_Res, Is_Coda_What, Data_Costr_Res, Data_Fine_Res, Is_Coda_Level, Id_Utente_Incrementa, Race_Coda, Quantity, Data_Last_Access, Cittadini_X, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Livello_Legna, Livello_Pietra, Livello_Mana, Livello_Oro)
End If
If Is_Costruct_Dif <> 0 AND What_Cat = "Dif" Then
Incrementa_Livello(Cosa_Costr_Dif,"difese", Is_Costruct_Dif, Is_Coda_Dif, Is_Coda_What, Data_Costr_Dif, Data_Fine_Dif, 1, Id_Utente_Incrementa, Race_Coda, Quantity, Data_Last_Access, Cittadini_X, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Livello_Legna, Livello_Pietra, Livello_Mana, Livello_Oro)
End If
If Is_Costruct_Ab <> 0 AND What_Cat = "Ab" Then
Incrementa_Livello(Cosa_Costr_Ab,"abilita", Is_Costruct_Ab, Is_Coda_Ab, Is_Coda_What, Data_Costr_Ab, Data_Fine_Ab, 1, Id_Utente_Incrementa, Race_Coda, Quantity, Data_Last_Access, Cittadini_X, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Livello_Legna, Livello_Pietra, Livello_Mana, Livello_Oro)
End If
End While
%>
<%
Dim E1_arr(20)
Dim Q1_arr(20)
Dim Id_Missione
Dim Var_Dimensione_Gestisci
Dim Var_Reame_Gestisci
Dim Var_Paese_Gestisci
Dim Id_Started
Dim Id_Arrive
Dim Where_Colonize
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Colonize, Time_Started, Time_Arrive, ID, Type_Mission, Army_Of, Id_Arrive, Id_Started FROM Missioni WHERE Time_Arrive < '"& Format_Date(Datetime.Now) &"' AND Type_Mission <> 'Assedio' ORDER BY ID ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Missione = r("ID")
Var_Id_Missione = r("id")
Var_Army_Of = r("Army_Of")
Id_Arrive = r("Id_Arrive")
Id_Started = r("Id_Started")
Var_Time_Started = r("Time_Started")
Var_Time_Arrive = r("Time_Arrive")
Var_Type_Mission = r("Type_Mission")
Ris_Legna = r("Ris_Legna")
Ris_Pietra = r("Ris_Pietra")
Ris_Mana = r("Ris_Mana")
Ris_Oro = r("Ris_Oro")
Where_Colonize = r("Colonize")
End While
r.Close()
sqlConn.Close()
If Var_Type_Mission = "Colonizzare" Then
Dim There_Is_Paese = "0"
Dim Dim_Arrive = Split(Where_Colonize,".")(0)
Dim Rea_Arrive = Split(Where_Colonize,".")(1)
Dim Pae_Arrive = Split(Where_Colonize,".")(2)
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Pianeti WHERE Dimensione = '"& Dim_Arrive &"' AND Reame = '"& Rea_Arrive &"' AND Paese = '"& Pae_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
There_Is_Paese = "1"
End While
r.Close()
sqlConn.Close()
Dim Count_Colony = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID From Pianeti WHERE Proprietary = '"& Var_Army_Of &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Count_Colony = Count_Colony + 1
End While
r.Close()
sqlConn.Close()
If There_Is_Paese = "1" OR Count_Colony > 9 Then
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Data_Adesso = Format_Date(Data_Adesso)
Data_Adesso_Added = Format_Date(Data_Adesso_Added)
Var_Time_Started = Format_Date(Var_Time_Started)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Type_Mission = 'Rinforzi', Time_Started = '"& Var_Time_Started &"', Time_Arrive = '"& Data_Adesso_Added &"', Id_Started = '"& Id_Arrive &"', Id_Arrive = '"& Id_Started &"', Colonize = 1 WHERE ID = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If There_Is_Paese = "0" AND Count_Colony < 10 Then
Dim m_conn
Dim m_cmd
m_sql = "INSERT INTO Pianeti (Data_Last_Access, Is_Principal, Proprietary, Nome, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Dimensione, Reame, Paese, In_Costr_Eser, Cosa_Costr_Eser, Data_Costr_Eser, In_Costr_Infr, Cosa_Costr_Infr, Data_Costr_Infr, In_Costr_Res, Cosa_Costr_Res, Data_Costr_Res, Data_Fine_Eser, Data_Fine_Infr, Data_Fine_Res, Data_Fine_Dif, Data_Fine_Ab, In_Costr_Dif, Cosa_Costr_Dif, Data_Costr_Dif, In_Costr_Ab, Cosa_Costr_Ab, Data_Costr_Ab, P_Cittadini, P_Costr_3, P_Costr_4, P_Costr_5, P_Costr_6) VALUES (@Data_Last_Access, @Is_Principal, @Proprietary, @Nome, @Ris_Legna, @Ris_Pietra, @Ris_Mana, @Ris_Oro, @Dimensione, @Reame, @Paese, @In_Costr_Eser, @Cosa_Costr_Eser, @Data_Costr_Eser, @In_Costr_Infr, @Cosa_Costr_Infr, @Data_Costr_Infr, @In_Costr_Res, @Cosa_Costr_Res, @Data_Costr_Res, @Data_Fine_Eser, @Data_Fine_Infr, @Data_Fine_Res, @Data_Fine_Dif, @Data_Fine_Ab, @In_Costr_Dif, @Cosa_Costr_Dif, @Data_Costr_Dif, @In_Costr_Ab, @Cosa_Costr_Ab, @Data_Costr_Ab, @P_Cittadini, @P_Costr_3, @P_Costr_4, @P_Costr_5, @P_Costr_6)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Data_Last_Access", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@Proprietary", sqldbtype.varchar).Value = Var_Army_Of
m_cmd.Parameters.Add("@Nome", sqldbtype.varchar).Value = "Nome_Paese"
m_cmd.Parameters.Add("@Ris_Legna", sqldbtype.int).Value = 3000
m_cmd.Parameters.Add("@Ris_Pietra", sqldbtype.int).Value = 3000
m_cmd.Parameters.Add("@Ris_Mana", sqldbtype.int).Value = 3000
m_cmd.Parameters.Add("@Ris_Oro", sqldbtype.int).Value = 3000
m_cmd.Parameters.Add("@Dimensione", sqldbtype.int).Value = Dim_Arrive
m_cmd.Parameters.Add("@Reame", sqldbtype.int).Value = Rea_Arrive
m_cmd.Parameters.Add("@Paese", sqldbtype.int).Value = Pae_Arrive
m_cmd.Parameters.Add("@In_Costr_Eser", sqldbtype.char).Value = "No"
m_cmd.Parameters.Add("@Cosa_Costr_Eser", sqldbtype.varchar).Value = ""
m_cmd.Parameters.Add("@Data_Costr_Eser", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@In_Costr_Infr", sqldbtype.char).Value = "No"
m_cmd.Parameters.Add("@Cosa_Costr_Infr", sqldbtype.varchar).Value = ""
m_cmd.Parameters.Add("@Data_Costr_Infr", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@In_Costr_Res", sqldbtype.char).Value = "No"
m_cmd.Parameters.Add("@Cosa_Costr_Res", sqldbtype.varchar).Value = ""
m_cmd.Parameters.Add("@Data_Costr_Res", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@In_Costr_Dif", sqldbtype.char).Value = "No"
m_cmd.Parameters.Add("@Cosa_Costr_Dif", sqldbtype.varchar).Value = ""
m_cmd.Parameters.Add("@Data_Costr_Dif", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@In_Costr_Ab", sqldbtype.char).Value = "No"
m_cmd.Parameters.Add("@Cosa_Costr_Ab", sqldbtype.varchar).Value = ""
m_cmd.Parameters.Add("@Data_Costr_Ab", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@Is_Principal", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Data_Fine_Eser", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@Data_Fine_Infr", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@Data_Fine_Res", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@Data_Fine_Dif", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@Data_Fine_Ab", sqldbtype.datetime).Value = DateTime.Now
m_cmd.Parameters.Add("@P_Cittadini", sqldbtype.int).Value = 40
m_cmd.Parameters.Add("@P_Costr_3", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@P_Costr_4", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@P_Costr_5", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@P_Costr_6", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Dim Id_Paese_Created
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Pianeti WHERE Proprietary = '"& Var_Army_Of &"' ORDER BY ID", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Id_Paese_Created = r("ID")
End While
r.Close()
sqlConn.Close()
m_sql = "INSERT INTO Edifici (Id_Paese, C_Costr_1, C_Costr_2, C_Costr_3, C_Costr_4, C_Costr_5, C_Costr_6, C_Costr_7, C_Costr_8, C_Costr_9, C_Costr_10, C_Costr_11, C_Costr_12, C_Costr_13, C_Costr_14, C_Costr_15) VALUES (@Id_Paese, @C_Costr_1, @C_Costr_2, @C_Costr_3, @C_Costr_4, @C_Costr_5, @C_Costr_6, @C_Costr_7, @C_Costr_8, @C_Costr_9, @C_Costr_10, @C_Costr_11, @C_Costr_12, @C_Costr_13, @C_Costr_14, @C_Costr_15)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Paese", sqldbtype.int).Value = Id_Paese_Created
m_cmd.Parameters.Add("@C_Costr_1", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@C_Costr_2", sqldbtype.int).Value = 2
m_cmd.Parameters.Add("@C_Costr_3", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@C_Costr_4", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@C_Costr_5", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@C_Costr_6", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@C_Costr_7", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_8", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@C_Costr_9", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_10", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_11", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_12", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_13", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_14", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@C_Costr_15", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
m_sql = "INSERT INTO Ricerche (Id_Paese, R_Ric_1, R_Ric_2, R_Ric_3, R_Ric_4, R_Ric_5, R_Ric_6, R_Ric_7) VALUES (@Id_Paese, @R_Ric_1, @R_Ric_2, @R_Ric_3, @R_Ric_4, @R_Ric_5, @R_Ric_6, @R_Ric_7)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Paese", sqldbtype.int).Value = Id_Paese_Created
m_cmd.Parameters.Add("@R_Ric_1", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@R_Ric_2", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@R_Ric_3", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@R_Ric_4", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@R_Ric_5", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@R_Ric_6", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@R_Ric_7", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
m_sql = "INSERT INTO Esercito (Id_Paese, E_Sold_1, E_Sold_2, E_Sold_3, E_Sold_4, E_Sold_5, E_Sold_6, E_Sold_7, E_Sold_8, E_Sold_9, E_Sold_10, E_Sold_11, E_Sold_12, E_Sold_13, E_Sold_14, E_Sold_15, E_Sold_16, E_Sold_17, E_Sold_18, E_Sold_19, E_Sold_20) VALUES (@Id_Paese, @E_Sold_1, @E_Sold_2, @E_Sold_3, @E_Sold_4, @E_Sold_5, @E_Sold_6, @E_Sold_7, @E_Sold_8, @E_Sold_9, @E_Sold_10, @E_Sold_11, @E_Sold_12, @E_Sold_13, @E_Sold_14, @E_Sold_15, @E_Sold_16, @E_Sold_17, @E_Sold_18, @E_Sold_19, @E_Sold_20)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Paese", sqldbtype.int).Value = Id_Paese_Created
m_cmd.Parameters.Add("@E_Sold_1", sqldbtype.int).Value = 25
m_cmd.Parameters.Add("@E_Sold_2", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_3", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_4", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_5", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_6", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_7", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_8", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_9", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_10", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_11", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_12", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_13", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_14", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_15", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_16", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_17", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_18", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@E_Sold_19", sqldbtype.int).Value = 1
m_cmd.Parameters.Add("@E_Sold_20", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
m_sql = "INSERT INTO Abilita (Id_Paese, Ab_1, Ab_2, Ab_3, Ab_4, Ab_5, Ab_6, Ab_7, Ab_8, Ab_9, Ab_10, Ab_11, Ab_12) VALUES (@Id_Paese, @Ab_1, @Ab_2, @Ab_3, @Ab_4, @Ab_5, @Ab_6, @Ab_7, @Ab_8, @Ab_9, @Ab_10, @Ab_11, @Ab_12)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Id_Paese", sqldbtype.int).Value = Id_Paese_Created
m_cmd.Parameters.Add("@Ab_1", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_2", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_3", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_4", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_5", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_6", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_7", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_8", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_9", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_10", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_11", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Ab_12", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Missioni WHERE ID = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Soldati_in_Missione WHERE Id_Missione = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
End If
If Var_Type_Mission = "Attacco" Then
Dim There_Is_Paese = "0"
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Id FROM Pianeti WHERE Id = '"& Id_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
There_Is_Paese = "1"
End While
r.Close()
sqlConn.Close()
If There_Is_Paese = "0" Then
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Data_Adesso = Replace(Var_Time_Arrive,".",":")
Data_Adesso = Format_Date(Data_Adesso)
Data_Adesso_Added = Format_Date(Data_Adesso_Added)
Var_Time_Started = Format_Date(Var_Time_Started)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Type_Mission = 'Rinforzi', Time_Started = '"& Data_Adesso &"', Time_Arrive = '"& Data_Adesso_Added &"', Id_Started = '"& Id_Arrive &"', Id_Arrive = '"& Id_Started &"' WHERE ID = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If There_Is_Paese = "1" Then
Dim E_arr(16)
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Id_Missione = CInt(Id_Missione)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Type_Mission = 'Assedio', Avviso = 'No' WHERE ID = " & Id_Missione & " ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
'INIZIO MESSAGGI
Dim y
Dim Var_Id_Utente_Started
Dim Nome_Paese_Started
Dim Nome_Utente_Started
Dim Var_Id_Utente_Arrive
Dim Nome_Paese_Arrive
Dim Nome_Utente_Arrive
Dim Var_Coord_Atk = ""
Dim Var_Coord_Ass = ""
Var_Mex_Attacco = "
SOLDATI DELL'ATTACCANTE
"
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Dimensione, Reame, Paese, Pianeti.Nome, Pianeti.Proprietary, Type_Soldato, Quantity_Soldato, Utenti.Race, Utenti.Id FROM Soldati_In_Missione JOIN Missioni ON Missioni.Id = Soldati_In_Missione.Id_Missione JOIN Utenti ON Missioni.Army_Of = Utenti.Username JOIN Pianeti ON Pianeti.Id = Missioni.Id_Started WHERE Missioni.Id = '"& Id_Missione &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Coord_Atk = ""& r("Dimensione") &"."& r("Reame") &"."& r("Paese") &""
Var_Id_Utente_Started = r("Id")
Nome_Paese_Started = r("Nome")
Nome_Utente_Started = r("Proprietary")
Dim Var_Row_Esercito = 0
If Trim(r("Race")) = "Human" Then
Var_Row_Esercito = 40
Else If Trim(r("Race")) = "Elf" Then
Var_Row_Esercito = 58
Else If Trim(r("Race")) = "Orc" Then
Var_Row_Esercito = 76
Else If Trim(r("Race")) = "Undead" Then
Var_Row_Esercito = 94
End If
For y = 1 to 14
If r("Type_Soldato") = "E_Sold_"& y AND r("Quantity_Soldato") > 0 Then
Var_Mex_Attacco = Var_Mex_Attacco + ""& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito + y) &": "& Abs(Int(-r("Quantity_Soldato"))) &"
"
End If
Next
End While
r.Close()
sqlConn.Close()
Var_Mex_Attacco = Var_Mex_Attacco + "
----------------------
SOLDATI DELL'ASSEDIATO
"
Dim Nome_Paese
Dim Nome_Utente
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Dimensione, Reame, Paese, Nome, Proprietary, E_Sold_1, E_Sold_2, E_Sold_3, E_Sold_4, E_Sold_5, E_Sold_6, E_Sold_7, E_Sold_8, E_Sold_9, E_Sold_10, E_Sold_11, E_Sold_12, E_Sold_13, E_Sold_14, Utenti.Race, Utenti.Id FROM Pianeti JOIN Utenti ON Utenti.Username = Pianeti.Proprietary JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese WHERE Pianeti.Id = '"& Id_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Coord_Ass = ""& r("Dimensione") &"."& r("Reame") &"."& r("Paese") &""
Dim Var_Row_Esercito = 0
If Trim(r("Race")) = "Human" Then
Var_Row_Esercito = 40
Else If Trim(r("Race")) = "Elf" Then
Var_Row_Esercito = 58
Else If Trim(r("Race")) = "Orc" Then
Var_Row_Esercito = 76
Else If Trim(r("Race")) = "Undead" Then
Var_Row_Esercito = 94
End If
Var_Id_Utente_Arrive = r("Id")
Nome_Paese_Arrive = r("Nome")
Nome_Utente_Arrive = r("Proprietary")
For y = 1 to 14
If r("E_Sold_"& y) > 0 Then
Var_Mex_Attacco = Var_Mex_Attacco + ""& Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito + y) &": "& Abs(Int(-r("E_Sold_"& y))) &"
"
End If
Next
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 = ""& Read_File("inc\Lang\Languages.aspx",845) &" "& Nome_Paese_Arrive &" ["& Var_Coord_Ass &"], "& Read_File("inc\Lang\Languages.aspx",847) &" "& Nome_Utente_Arrive &".
"& Read_File("inc\Lang\Languages.aspx",849) &":
" + Var_Mex_Attacco
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente_Started
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
'MESSAGGIO ALL'ASSEDIATO
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 = ""& Read_File("inc\Lang\Languages.aspx",846) &" "& Nome_Paese_Arrive &" ["& Var_Coord_Ass &"], "& Read_File("inc\Lang\Languages.aspx",848) &" "& Nome_Paese_Started &" ["& Var_Coord_Atk &"], "& Read_File("inc\Lang\Languages.aspx",847) &" "& Nome_Utente_Started &".
"& Read_File("inc\Lang\Languages.aspx",849) &":
" + Var_Mex_Attacco
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente_Arrive
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
End If
If Var_Type_Mission = "Rinforzi" Then
Dim There_Is_Paese = "0"
Dim Proprietary_Started = ""
Dim Proprietary_Arrive = ""
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Dimensione, Reame, Paese, Proprietary FROM Pianeti WHERE Pianeti.Id = '"& Id_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
There_Is_Paese = "1"
Proprietary_Arrive = r("Proprietary")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * FROM Missioni JOIN Soldati_In_Missione ON Missioni.Id = Soldati_In_Missione.Id_Missione WHERE Missioni.Id = "& Var_Id_Missione &" ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Proprietary_Started = r("Army_Of")
For x = 1 To 18
If r("Type_Soldato") = "E_Sold_"& x Then
Q1_arr(x) = r("Quantity_Soldato")
End If
Next
End While
r.Close()
sqlConn.Close()
Dim counter = 0
For x = 1 To 20
counter = counter + Q1_arr(x)
Next
If counter > 0 Then
Stringa = "UPDATE Esercito SET "
For x = 1 to 18
If Q1_arr(x) > 0 Then
Q1_arr(x) = Replace(Q1_arr(x),",",".")
Stringa = Stringa + "E_Sold_"& x &" = E_Sold_"& x &" + "& Q1_arr(x) &", "
End If
Next
Stringa = Mid(Stringa, 1, Len(Stringa)-2)
Stringa = Stringa + " WHERE Id_Paese = '"& Id_Arrive &"' "
End If
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = Ris_Legna + "& Ris_Legna &", Ris_Pietra = Ris_Pietra + "& Ris_Pietra &", Ris_Mana = Ris_Mana + "& Ris_Mana &", Ris_Oro = Ris_Oro + "& Ris_Oro &" WHERE Id = '"& Id_Arrive &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
If counter > 0 Then
sqlComm = New SqlCommand(Stringa ,sqlConn)
result = sqlComm.ExecuteNonQuery()
End If
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Soldati_in_Missione WHERE Id_Missione = '" & Var_Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Missioni WHERE Id = '" & Var_Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If Var_Type_Mission = "Trasporto" Then
Dim There_Is_Paese = "0"
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Dimensione, Reame, Paese FROM Pianeti WHERE Id = '"& Id_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
There_Is_Paese = "1"
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = Ris_Legna + "& Ris_Legna &", Ris_Pietra = Ris_Pietra + "& Ris_Pietra &", Ris_Mana = Ris_Mana + "& Ris_Mana &", Ris_Oro = Ris_Oro + "& Ris_Oro &" WHERE Id = '"& Id_Arrive &"' " ,sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Var_Time_Started = Replace(Var_Time_Started,".",":")
Data_Adesso = Format_Date(Data_Adesso)
Data_Adesso_Added = Format_Date(Data_Adesso_Added)
Var_Time_Started= Format_Date(Var_Time_Started)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Type_Mission = 'Rinforzi', Time_Started = '"& Data_Adesso &"', Time_Arrive = '"& Data_Adesso_Added &"', Id_Started = '"& Id_Arrive &"', Id_Arrive = '"& Id_Started &"', Ris_Legna = 0, Ris_Pietra = 0, Ris_Mana = 0, Ris_Oro = 0 WHERE ID = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If Var_Type_Mission = "Spionaggio" Then
Dim Lvl_Spionaggio
Dim Is_Premium
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Premium_Data, Utenti.Id as Id_Utente, R_Ric_1, Utenti.Username FROM Pianeti JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Utenti ON Pianeti.Proprietary = Utenti.Username WHERE Pianeti.Id = '"& Id_Started &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Var_Id_Utente = r("Id_Utente")
Lvl_Spionaggio = r("R_Ric_1")
If r("Premium_Data") < Datetime.Now Then
Is_Premium = "No"
Else
Is_Premium = "Si"
End If
End While
r.Close()
sqlConn.Close()
Dim There_Is_Paese = "0"
Dim Messaggio
Dim Id_Utente_Nemico
Dim Username_Nemico
Dim Nome_Paese_Nemico
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Race, Utenti.Id as Id_Utente, Is_Principal, Dimensione, Reame, Paese, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Nome, Proprietary, E_Sold_1, E_Sold_2, E_Sold_3, E_Sold_4, E_Sold_5, E_Sold_6, E_Sold_7, E_Sold_8, E_Sold_9, E_Sold_10, E_Sold_11, E_Sold_12, E_Sold_13, E_Sold_14, E_Sold_19, E_Sold_20, R_Ric_1, R_Ric_6, R_Ric_7 FROM Pianeti JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Utenti ON Pianeti.Proprietary = Utenti.Username WHERE Pianeti.Id = '"& Id_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Dim Var_Row_Esercito = 0
If Trim(r("Race")) = "Human" Then
Var_Row_Esercito = 40
Else If Trim(r("Race")) = "Elf" Then
Var_Row_Esercito = 58
Else If Trim(r("Race")) = "Orc" Then
Var_Row_Esercito = 76
Else If Trim(r("Race")) = "Undead" Then
Var_Row_Esercito = 94
End If
Username_Nemico = r("Proprietary")
Nome_Paese_Nemico = r("Nome")
Id_Utente_Nemico = r("Id_Utente")
There_Is_Paese = "1"
Messaggio = Messaggio + "Rapporto di Spionaggio dal Paese "& r("Nome") &" ["& r("Dimensione") &"."& r("Reame") &"."& r("Paese") &"] del sovrano "& r("Proprietary") &":
"
If Lvl_Spionaggio > (r("R_Ric_1")/3)
Messaggio = Messaggio + "Risorse:
Legna: "& Cint(r("Ris_Legna")) &"
Pietra: "& Cint(r("Ris_Pietra")) &"
Mana: "& Cint(r("Ris_Mana")) &"
Oro: "& Cint(r("Ris_Oro")) &"
"
End If
If Lvl_Spionaggio > (r("R_Ric_1")/2)
Messaggio = Messaggio + ""& Read_File("inc\Lang\Languages.aspx",457) &":
"
Messaggio = Messaggio + "
"& Read_File("inc\Lang\Languages.aspx",306) &": Livello "& r("R_Ric_7") &" "
Messaggio = Messaggio + "
Numero Mura: "& r("E_Sold_20") &" "
Messaggio = Messaggio + "
"& Read_File("inc\Lang\Languages.aspx",305) &": Livello "& r("R_Ric_6") &" "
Messaggio = Messaggio + "
Numero Torrette: "& CInt(r("E_Sold_19")) &" "
End If
Dim Check_Quindici = "No"
If Lvl_Spionaggio = 15 AND r("R_Ric_1") = 15 Then
Check_Quindici = "Si"
End If
Randomize()
Dim Random_Spionaggio = CInt(Rnd()*10)
If Lvl_Spionaggio > (r("R_Ric_1")) OR (Check_Quindici = "Si" AND Random_Spionaggio > 6) Then
Messaggio = Messaggio + "
Esercito:
"
For x = 1 to 14
If r("E_Sold_"& x) > 0 Then
Dim Soldat = "E_Sold_"& x
Messaggio = Messaggio & Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito + x) &": "& Int(r(Soldat)) &"
"
End If
Next
End If
End While
r.Close()
sqlConn.Close()
If Is_Premium = "Si" Then
Dim Number_Item = 0
Dim First_Row = 0
Dim Item_Name = ""
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Id as Id_Utente, Item_Quest.Item_Name FROM Utenti JOIN Item_Quest ON Utenti.Id = Item_Quest.Id_Utente JOIN Quest ON Item_Quest.Id_Quest = Quest.Id_Quest JOIN Pianeti ON Pianeti.Proprietary = Utenti.Username WHERE Pianeti.Id = '"& Id_Arrive &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If Item_Name = r("Item_Name") Then
Number_Item = Number_Item + 1
Else
If First_Row <> 0 Then
Messaggio = Messaggio &"
Oggetto Quest: Trovati "& Number_Item &" "& Item_Name &" "
End If
First_Row = 1
Item_Name = r("Item_Name")
Number_Item = 1
End If
End While
r.Close()
sqlConn.Close()
Messaggio = Messaggio &"
Oggetto Quest: Trovati "& Number_Item &" "& Item_Name &" "
End If
If There_Is_Paese = "1" Then
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Var_Time_Started = Replace(Var_Time_Started,".",":")
Data_Adesso = Format_Date(Data_Adesso)
Data_Adesso_Added = Format_Date(Data_Adesso_Added)
Var_Time_Started = Format_Date(Var_Time_Started)
'MESSAGGIO A CHI SPIA
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 = Messaggio
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Var_Id_Utente
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Spionaggio"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Type_Mission = 'Rinforzi', Time_Started = '"& Data_Adesso &"', Time_Arrive = '"& Data_Adesso_Added &"', Id_Started = '"& Id_Arrive &"', Id_Arrive = '"& Id_Started &"' WHERE ID = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
If There_Is_Paese = "0" Then
Dim Orario = Var_Time_Arrive.Subtract(Var_Time_Started)
Dim Data_Adesso = Datetime.Now
Data_Adesso = Replace(Data_Adesso,".",":")
Data_Adesso_Added = Datetime.Now.Add(Orario)
Data_Adesso_Added = Replace(Data_Adesso_Added,".",":")
Var_Time_Started = Replace(Var_Time_Started,".",":")
Data_Adesso = Format_Date(Data_Adesso)
Data_Adesso_Added = Format_Date(Data_Adesso_Added)
Var_Time_Started = Format_Date(Var_Time_Started)
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Missioni SET Type_Mission = 'Rinforzi', Time_Started = '"& Data_Adesso &"', Time_Arrive = '"& Data_Adesso_Added &"', Id_Started = '"& Id_Arrive &"', Id_Arrive = '"& Id_Started &"' WHERE ID = '" & Id_Missione & "' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
End If
End If
Dim Url_Check = Request.ServerVariables("PATH_TRANSLATED")
Url_Check = StrReverse(Split(StrReverse(Url_Check),"\")(0))
If Url_Check <> "attacca.aspx" AND Url_Check <> "ritirati.aspx" AND Url_Check <> "arrenditi.aspx" AND Url_Check <> "ritira_missione.aspx" Then
Application.UnLock
End If
%>