<%@ 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 Dim Filoni_Oro 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() AND There_Is = 0 Filoni_Oro = r("R_Ric_4") 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 'Response.write ("Eser - ") 'Response.write (r("Id_Paese")) 'Response.write (" - ") 'Response.write (r("Cosa_Costr_Eser")) 'Response.write (" - ") 'Response.write (r("Race")) 'Response.write ("
") 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, Filoni_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, Filoni_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, Filoni_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, Filoni_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, Filoni_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 Dim Email Dim Premium_Data_Ass sqlConn.Open() sqlComm = New SqlCommand("SELECT Email, Premium_Data, 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() Email = r("Email") Premium_Data_Ass = r("Premium_Data") 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 ' EMAIL ALL'ASSEDIATO If Not Premium_Data_Ass < Datetime.Now Then Dim mail As New MailMessage mail.From = "account@lordsofwars.com" mail.To = Email mail.Subject = "Email From Lords Of Wars - Ti stanno attaccando!" Mail.BodyFormat = MailFormat.HTML mail.Body = ""& 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 Mail.Fields("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1 Mail.Fields("http://schemas.microsoft.com/cdo/configuration/sendusername") = "luca.mascolo@gamecaffe.net" Mail.Fields("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "kalortpor" SmtpMail.SmtpServer = "smtp.gamecaffe.net" SmtpMail.Send(mail) End If 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() If Proprietary_Started <> Proprietary_Arrive Then sqlConn.Open() sqlComm = New SqlCommand("SELECT ID, Dimensione, Reame, Paese, Proprietary FROM Pianeti WHERE Proprietary = '"& Proprietary_Started &"' AND Is_Principal = 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Id_Arrive = r("ID") End While r.Close() sqlConn.Close() End If 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() 'METTO CHE CHIUNQUE PUO SPIARE I FRAMMENTI ANCHE SE NON PREMIUM '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 %>