<%@ 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" %> <%@ Import namespace="System.Math" %> <% Dim See_Page = (Request.QueryString ("Page")) If See_Page = "" Then See_Page = Request.Form ("Page") End If See_Page = Decripta(See_Page) Dim Code = Request.QueryString ("Code") If Code = "" Then Code = Request.Form ("Code") End If Code = Decripta(Code) If Code = "costruisci" Then Dim Level Dim arr = (Request.QueryString ("Command")) If arr = "" Then arr = Request.Form ("Command") End If arr = Decripta(arr) Dim Level_Before = (Request.QueryString ("Level")) If Level_Before = "" Then Level_Before = Request.Form ("Level") End If Level_Before = Decripta(Level_Before) Dove = "Div_" + arr Risorse_Costruzione(arr, Level_Before, User_Race, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro) Tempo_Costruzione(arr, Level_Before, User_Race) Dim Data_Fine = Datetime.Now Data_Fine = Data_Fine.AddHours(Ore) Data_Fine = Data_Fine.AddMinutes(Minuti) Data_Fine = Replace(Data_Fine,".",":") Data_Fine = Format_Date(Data_Fine) Dim Hidden = 0 Dim Max_Level = 0 sqlConn.Open() If See_Page = "edifici" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Infr, "& arr &", R_Ric_1, C_Costr_1, 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 FROM Pianeti JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Edifici.Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "ricerche" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Res, "& arr &", R_Ric_1, R_Ric_2, R_Ric_3, R_Ric_4, R_Ric_5, R_Ric_6, R_Ric_7, C_Costr_7 FROM Pianeti JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Ricerche.Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "esercito" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Eser, "& arr &", C_Costr_1, 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 FROM Pianeti JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Esercito.Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "difese" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Dif, "& arr &", C_Costr_15 FROM Pianeti JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Pianeti.Id = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "abilita" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Ab, "& arr &" FROM Pianeti JOIN Abilita ON Pianeti.Id = Abilita.Id_Paese WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) End If Dim r As SqlDataReader = sqlComm.ExecuteReader() While r.Read() Legna_Spendi = (r("Ris_Legna") - Legna) Pietra_Spendi = (r("Ris_Pietra") - Pietra) Mana_Spendi = (r("Ris_Mana") - Mana) Oro_Spendi = (r("Ris_Oro") - Oro) Level = Abs(Int(-r(arr))) If (See_Page = "edifici") OR (See_Page = "esercito") Then If (See_Page = "edifici") AND arr = "c_costr_9" AND r("c_costr_8") < 3 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_10" AND ((r("c_costr_8") < 5 OR r("c_costr_9") < 4)) Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_11" AND ((r("c_costr_8") < 8 OR r("c_costr_9") < 5 OR r("c_costr_10") < 3)) Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_12" AND ((r("c_costr_8") < 10 OR r("c_costr_9") < 6 OR r("c_costr_10") < 5 OR r("c_costr_11") < 2)) Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_13" AND ((r("c_costr_8") < 12 OR r("c_costr_9") < 7 OR r("c_costr_10") < 8 OR r("c_costr_11") < 4 OR r("c_costr_12") < 2)) Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_14" AND ((r("c_costr_8") < 14 OR r("c_costr_9") < 8 OR r("c_costr_10") < 10 OR r("c_costr_11") < 5 OR r("c_costr_12") < 3 OR r("c_costr_13") < 3)) Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_15" AND ((r("c_costr_8") < 15 OR r("c_costr_9") < 10 OR r("c_costr_10")< 10 OR r("c_costr_11") < 5 OR r("c_costr_12") < 5 OR r("c_costr_13") < 5 OR r("c_costr_14") < 5)) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_1" AND r("c_costr_8") < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_2" AND r("c_costr_9") < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_3" AND r("c_costr_8") < 4) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_4" AND r("c_costr_9") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_5" AND r("c_costr_10") < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_6" AND r("c_costr_11") < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_7" AND r("c_costr_12") < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_8" AND r("c_costr_8") < 8) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_9" AND r("c_costr_13") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_10" AND r("c_costr_10") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_11" AND r("c_costr_11") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_12" AND r("c_costr_14") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_13" AND r("c_costr_15") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_14" AND r("c_costr_15") < 10) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_15" AND r("R_Ric_1") < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_16" AND r("c_costr_1") < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_17" AND r("c_costr_1") < 2) Then Hidden = 1 Else If (See_Page = "esercito") AND (arr = "e_sold_18" AND r("c_costr_1") < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_1" AND r("c_costr_8") < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_2" AND r("c_costr_9") < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_3" AND r("c_costr_8") < 4) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_4" AND r("c_costr_9") < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_5" AND r("c_costr_10") < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_6" AND r("c_costr_11") < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_7" AND r("c_costr_12") < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_8" AND r("c_costr_8") < 8) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_9" AND r("c_costr_13") < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_10" AND r("c_costr_10") < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_11" AND r("c_costr_11") < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (arr = "ab_12" AND r("c_costr_14") < 5) Then Hidden = 1 End If If (See_Page = "edifici") AND arr = "c_costr_7" AND r("c_costr_7") >= 15 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_8" AND r("c_costr_8") >= 15 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_9" AND r("c_costr_9") >= 10 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_10" AND r("c_costr_10") >= 10 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_11" AND r("c_costr_11") >= 5 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_12" AND r("c_costr_12") >= 5 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_13" AND r("c_costr_13") >= 5 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_14" AND r("c_costr_14") >= 5 Then Hidden = 1 Else If (See_Page = "edifici") AND arr = "c_costr_15" AND r("c_costr_15") >= 10 Then Hidden = 1 End If End If If ((See_Page) = "abilita") AND r(arr) >= 3 Then Hidden = 1 End If If (See_Page) = "difese" Then If (See_Page = "difese") AND arr = "e_sold_20" AND Trim(User_Race) = "Human" AND arr_level_costr(i) >= 4 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_20" AND Trim(User_Race) = "Elf" AND arr_level_costr(i) >= 3 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_20" AND Trim(User_Race) = "Orc" AND arr_level_costr(i) >= 2 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_20" AND Trim(User_Race) = "Undead" AND arr_level_costr(i) >= 3 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_19" AND Trim(User_Race) = "Human" AND arr_level_costr(i) >= 4 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_19" AND Trim(User_Race) = "Elf" AND arr_level_costr(i) >= 5 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_19" AND Trim(User_Race) = "Orc" AND arr_level_costr(i) >= 6 Then Max_Level = 1 Else If (See_Page = "difese") AND arr = "e_sold_19" AND Trim(User_Race) = "Undead" AND arr_level_costr(i) >= 5 Then Max_Level = 1 Else If (See_Page = "difese") AND (arr = "e_sold_19" AND r("c_costr_15") < 5) Then Hidden = 1 Else If (See_Page = "difese") AND (arr = "e_sold_20" AND r("c_costr_15") < 5) Then Hidden = 1 End If End If If ((See_Page) = "ricerche") Then If (See_Page = "ricerche") AND arr = "R_Ric_1" AND r("c_costr_7") < 1 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_2" AND r("c_costr_7") < 3 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_3" AND r("c_costr_7") < 5 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_4" AND r("c_costr_7") < 7 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_5" AND r("c_costr_7") < 10 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_6" AND r("c_costr_7") < 12 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_7" AND r("c_costr_7") < 15 Then Hidden = 1 End If If (See_Page = "ricerche") AND arr = "R_Ric_2" AND r("R_Ric_2") >= 10 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_3" AND r("R_Ric_3") >= 10 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_4" AND r("R_Ric_4") >= 10 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_5" AND r("R_Ric_5") >= 10 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_6" AND r("R_Ric_6") >= 10 Then Hidden = 1 Else If (See_Page = "ricerche") AND arr = "R_Ric_7" AND r("R_Ric_7") >= 10 Then Hidden = 1 End If End If If See_Page = "edifici" Then Is_Already_In_Costruct = r("In_Costr_Infr") End If If See_Page = "ricerche" Then Is_Already_In_Costruct = r("In_Costr_Res") End If If See_Page = "esercito" Then Is_Already_In_Costruct = r("In_Costr_Eser") End If If See_Page = "difese" Then Is_Already_In_Costruct = r("In_Costr_Dif") End If If See_Page = "abilita" Then Is_Already_In_Costruct = r("In_Costr_Ab") End If End While r.Close() sqlConn.Close() Data_Odierna = Datetime.Now Data_Odierna = Replace(Data_Odierna,".",":") Data_Odierna = Format_Date(Data_Odierna) Dim Errore_Costruzione = 0 If Legna_Spendi < 0 OR Mana_Spendi < 0 OR Pietra_Spendi < 0 OR Oro_Spendi < 0 Then Errore_Costruzione = 1 Else If Level_Before <> Int(Level) Then Errore_Costruzione = 1 Else If Hidden = 1 Then Errore_Costruzione = 1 End If If Errore_Costruzione = 0 Then Legna_Spendi = Replace(Legna_Spendi,",",".") Pietra_Spendi = Replace(Pietra_Spendi,",",".") Mana_Spendi = Replace(Mana_Spendi,",",".") Oro_Spendi = Replace(Oro_Spendi,",",".") If Is_Already_In_Costruct = "No" Then Ris_Legna = Replace(Legna_Spendi,".",",") Ris_Pietra = Replace(Pietra_Spendi,".",",") Ris_Mana = Replace(Mana_Spendi,".",",") Ris_Oro = Replace(Oro_Spendi,".",",") sqlConn.Open() If See_Page = "edifici" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Infr = 'Si', Cosa_Costr_Infr = '" + arr + "', Data_Costr_Infr = '"& Data_Odierna &"', Data_Fine_Infr = '"& Data_Fine &"' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "ricerche" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Res = 'Si', Cosa_Costr_Res = '" + arr + "', Data_Costr_Res = '"& Data_Odierna &"', Data_Fine_Res = '"& Data_Fine &"' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "esercito" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Eser = 'Si', Cosa_Costr_Eser = '" + arr + "', Data_Costr_Eser = '"& Data_Odierna &"', Data_Fine_Eser = '"& Data_Fine &"' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "difese" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Dif = 'Si', Cosa_Costr_Dif = '" + arr + "', Data_Costr_Dif = '"& Data_Odierna &"', Data_Fine_Dif = '"& Data_Fine &"' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "abilita" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Ab = 'Si', Cosa_Costr_Ab = '" + arr + "', Data_Costr_Ab = '"& Data_Odierna &"', Data_Fine_Ab = '"& Data_Fine &"' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If End If If Code = "annulla" Then Dim Level Dim arr = Decripta(Request.QueryString ("Command")) Dim Level_Before = Decripta(Request.QueryString ("Level")) If See_Page = "esercito" Then Prefix = "E_Sold_" Else If See_Page = "edifici" Then Prefix = "C_Costr_" Else If See_Page = "ricerche" Then Prefix = "R_Ric_" End If sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Code WHERE Coda_Addestra LIKE '"& Prefix &"%' AND Id_Paese = '"& Id_Paese &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() Risorse_Costruzione(arr, Level_Before, User_Race, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro) sqlConn.Open() If See_Page = "edifici" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Infr, "& arr &" FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "ricerche" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Res, "& arr &" FROM Pianeti JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "esercito" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Eser, "& arr &" FROM Pianeti JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "difese" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Dif, "& arr &" FROM Pianeti JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) End If If See_Page = "abilita" Then sqlComm = New SqlCommand("SELECT Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Ab, "& arr &" FROM Pianeti JOIN Abilita ON Pianeti.Id = Abilita.Id_Paese WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) End If Dim r As SqlDataReader = sqlComm.ExecuteReader() While r.Read() Level = Abs(Int(-r(arr))) Legna_Spendi = (r("Ris_Legna") + Legna) Pietra_Spendi = (r("Ris_Pietra") + Pietra) Mana_Spendi = (r("Ris_Mana") + Mana) Oro_Spendi = (r("Ris_Oro") + Oro) If See_Page = "edifici" Then Is_Already_In_Costruct = r("In_Costr_Infr") End If If See_Page = "ricerche" Then Is_Already_In_Costruct = r("In_Costr_Res") End If If See_Page = "esercito" Then Is_Already_In_Costruct = r("In_Costr_Eser") End If If See_Page = "difese" Then Is_Already_In_Costruct = r("In_Costr_Dif") End If If See_Page = "abilita" Then Is_Already_In_Costruct = r("In_Costr_Ab") End If End While r.Close() sqlConn.Close() Legna_Spendi = Replace(Legna_Spendi,",",".") Pietra_Spendi = Replace(Pietra_Spendi,",",".") Mana_Spendi = Replace(Mana_Spendi,",",".") Oro_Spendi = Replace(Oro_Spendi,",",".") If Level_Before <> Int(Level) Then Is_Already_In_Costruct = "No" End If If Is_Already_In_Costruct = "Si" Then Ris_Legna = Replace(Legna_Spendi,".",",") Ris_Pietra = Replace(Pietra_Spendi,".",",") Ris_Mana = Replace(Mana_Spendi,".",",") Ris_Oro = Replace(Oro_Spendi,".",",") sqlConn.Open() If See_Page = "edifici" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Infr = 'No', Cosa_Costr_Infr = '' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "ricerche" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Res = 'No', Cosa_Costr_Res = '' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "esercito" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Eser = 'No', Cosa_Costr_Eser = '' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "difese" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Dif = 'No', Cosa_Costr_Dif = '' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If If See_Page = "abilita" Then sqlComm = New SqlCommand("UPDATE Pianeti SET Ris_Legna = "& Legna_Spendi &" ,Ris_Mana = "& Mana_Spendi &" ,Ris_Pietra = "& Pietra_Spendi &" ,Ris_Oro = "& Oro_Spendi &" ,In_Costr_Ab = 'No', Cosa_Costr_Ab = '' WHERE Id = '"& Id_Paese &"' ",sqlConn) End If result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If End If If Code = "aggiungi_coda" Then Dim arr = Request.Form ("Command") arr = Decripta(arr) Dim Quantity = Request.Form ("Quantity") If Quantity = "" OR Only_Num(Quantity) <> 0 Then Quantity = 0 Else m_sql = "INSERT INTO Code (Coda_Addestra, Quantity, Race, Id_Paese) VALUES (@Coda_Addestra, @Quantity, @Race, @Id_Paese)" m_conn = New SqlConnection(strConn) m_cmd = new SqlCommand m_cmd.connection = m_conn m_cmd.commandtext = m_sql m_cmd.Parameters.Add("@Coda_Addestra", sqldbtype.varchar).Value = arr m_cmd.Parameters.Add("@Quantity", sqldbtype.varchar).Value = CInt(Quantity) m_cmd.Parameters.Add("@Race", sqldbtype.varchar).Value = User_Race m_cmd.Parameters.Add("@Id_Paese", sqldbtype.int).Value = Id_Paese m_conn.Open m_cmd.ExecuteNonQuery m_conn.Close End If End If If Code = "cancella_coda" Then Prefix = Decripta(Request.QueryString("Command")) sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Code WHERE Coda_Addestra LIKE '"& Prefix &"%' AND Id_Paese = '"& Id_Paese &"' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If %><% Dim See_Page = (Request.QueryString ("Page")) If See_Page = "" Then See_Page = Request.Form ("Page") End If See_Page = Decripta(See_Page) Response.Write ("

") If See_Page = "edifici" Then Response.Write (Read_File("inc\Lang\Languages.aspx",4)) End If If See_Page = "ricerche" Then Response.Write (Read_File("inc\Lang\Languages.aspx",6)) End If If See_Page = "esercito" Then Response.Write (Read_File("inc\Lang\Languages.aspx",5)) End If If See_Page = "difese" Then Response.Write (Read_File("inc\Lang\Languages.aspx",10)) End If If See_Page = "abilita" Then Response.Write (Read_File("inc\Lang\Languages.aspx",11)) End If Response.Write ("") Dim Var_First_Line = 0 Dim Var_Row_Esercito = 0 Dim Var_Row_Edifici = 0 Dim Var_Row_Difese = 0 Dim Var_Row_Abilita = 0 If User_Race = "Human" Then Var_First_Line = 41 Var_Row_Esercito = 113 Var_Row_Edifici = 185 Var_Row_Difese = 305 Var_Row_Abilita = 335 Else If User_Race = "Elf" Then Var_First_Line = 55 Var_Row_Esercito = 131 Var_Row_Edifici = 200 Var_Row_Difese = 307 Var_Row_Abilita = 347 Else If User_Race = "Orc" Then Var_First_Line = 69 Var_Row_Esercito = 149 Var_Row_Edifici = 215 Var_Row_Difese = 309 Var_Row_Abilita = 359 Else If User_Race = "Undead" Then Var_First_Line = 83 Var_Row_Esercito = 167 Var_Row_Edifici = 230 Var_Row_Difese = 311 Var_Row_Abilita = 371 End If Application.Lock Dim Q_Cosa_Costr Dim R_Espl sqlConn.Open() If See_Page = "edifici" OR See_Page = "" Then sqlComm = New SqlCommand("SELECT Data_Costr_Infr, Cosa_Costr_Infr, In_Costr_Infr, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, 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 FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese WHERE Id = "& Id_Paese &" ", sqlConn) End If If See_Page = "ricerche" Then sqlComm = New SqlCommand("SELECT Data_Costr_Infr, Cosa_Costr_Infr, In_Costr_Infr, Data_Costr_Res, Cosa_Costr_Res, In_Costr_Res, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, C_Costr_7, R_Ric_1, R_Ric_2, R_Ric_3, R_Ric_4, R_Ric_5, R_Ric_6, R_Ric_7, Data_Costr_Res, Cosa_Costr_Res, In_Costr_Res, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, 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 FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese WHERE Id = "& Id_Paese &" ", sqlConn) End If If See_Page = "esercito" Then sqlComm = New SqlCommand("SELECT Data_Costr_Infr, Cosa_Costr_Infr, In_Costr_Infr, Data_Costr_Eser, Cosa_Costr_Eser, In_Costr_Eser, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, 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, R_Ric_1, R_Ric_2, R_Ric_3, R_Ric_4, R_Ric_5, R_Ric_6, R_Ric_7, Data_Costr_Res, Cosa_Costr_Res, In_Costr_Res, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, 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 FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese WHERE Id = "& Id_Paese &" ", sqlConn) End If If See_Page = "difese" Then sqlComm = New SqlCommand("SELECT Data_Costr_Infr, Cosa_Costr_Infr, In_Costr_Infr, Data_Costr_Dif, Cosa_Costr_Dif, In_Costr_Dif, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, E_Sold_19, E_Sold_20, R_Ric_1, R_Ric_2, R_Ric_3, R_Ric_4, R_Ric_5, R_Ric_6, R_Ric_7, Data_Costr_Res, Cosa_Costr_Res, In_Costr_Res, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, 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 FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese JOIN Ricerche ON Pianeti.Id = Ricerche.Id_Paese JOIN Esercito ON Pianeti.Id = Esercito.Id_Paese WHERE Id = "& Id_Paese &" ", sqlConn) End If If See_Page = "abilita" Then sqlComm = New SqlCommand("SELECT Data_Costr_Infr, Cosa_Costr_Infr, In_Costr_Infr, Data_Costr_Ab, Cosa_Costr_Ab, In_Costr_Ab, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, Ab_1, Ab_2, Ab_3, Ab_4, Ab_5, Ab_6, Ab_7, Ab_8, Ab_9, Ab_10, Ab_11, Ab_12, Data_Costr_Ab, Cosa_Costr_Ab, In_Costr_Ab, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, 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 FROM Pianeti JOIN Edifici ON Pianeti.Id = Edifici.Id_Paese JOIN Abilita ON Pianeti.Id = Abilita.Id_Paese WHERE Id = "& Id_Paese &" ", sqlConn) End If r = sqlComm.ExecuteReader() While r.Read() Ris_Legna = r("Ris_Legna") Ris_Pietra = r("Ris_Pietra") Ris_Mana = r("Ris_Mana") Ris_Oro = r("Ris_Oro") If See_Page = "edifici" Then Prefix = "c_costr_" Cosa_Costr = r("Cosa_Costr_Infr") Timer_Costruct = r("In_Costr_Infr") Var_Data_Costr_Infr = r("Data_Costr_Infr") For i = 1 to 15 arr_Names(i) = Read_File("inc\Lang\Languages.aspx",Var_Row_Edifici + i - 1) arr_level_costr(i) = r("C_Costr_"&i) Next End If If See_Page = "ricerche" Then Prefix = "r_ric_" Cosa_Costr = r("Cosa_Costr_Res") Timer_Costruct = r("In_Costr_Res") Var_Data_Costr_Infr = r("Data_Costr_Res") For i = 1 to 7 arr_Names(i) = Read_File("inc\Lang\Languages.aspx",320 + i) arr_level_costr(i) = r("R_Ric_"&i) Next arr_level_costr_Edif(7) = r("C_Costr_7") End If If See_Page = "esercito" Then Prefix = "e_sold_" Cosa_Costr = r("Cosa_Costr_Eser") Timer_Costruct = r("In_Costr_Eser") Var_Data_Costr_Infr = r("Data_Costr_Eser") For i = 1 to 18 arr_Names(i) = Read_File("inc\Lang\Languages.aspx",Var_Row_Esercito - 73 + i) arr_level_costr(i) = r("E_Sold_"&i) Next For i = 1 to 15 arr_level_costr_Edif(i) = r("C_Costr_"&i) Next R_Espl = r("R_Ric_1") End If If See_Page = "difese" Then Prefix = "e_sold_" Cosa_Costr = r("Cosa_Costr_Dif") Timer_Costruct = r("In_Costr_Dif") Var_Data_Costr_Infr = r("Data_Costr_Dif") For i = 19 to 20 arr_Names(i) = Read_File("inc\Lang\Languages.aspx",Var_Row_Difese - 19 + i) arr_level_costr(i) = r("E_Sold_"&i) Next For i = 1 to 15 arr_level_costr_Edif(i) = r("C_Costr_"&i) Next End If If See_Page = "abilita" Then Prefix = "ab_" Cosa_Costr = r("Cosa_Costr_Ab") Timer_Costruct = r("In_Costr_Ab") Var_Data_Costr_Infr = r("Data_Costr_Ab") For i = 1 to 12 arr_Names(i) = Read_File("inc\Lang\Languages.aspx",Var_Row_Abilita + i - 1) arr_level_costr(i) = r("Ab_"&i) Next For i = 1 to 15 arr_level_costr_Edif(i) = r("C_Costr_"&i) Next End If If Cosa_Costr <> "" Then Q_Cosa_Costr = r(Cosa_Costr) End If End While r.Close() sqlConn.Close() If Timer_Costruct = "Si" Then Dim Lavoro = (DateDiff("s",Var_Data_Costr_Infr, DateTime.Now)) Ore = Tempo_Costruzione(Cosa_Costr,Q_Cosa_Costr, User_Race) Secondi_Ore(((Minuti * 60) + (Ore * 60 * 60)) - Lavoro) Ore_Js = Ore Minuti_Js = Minuti Secondi_Js = Secondi Dove = "Div_" + (Cosa_Costr) End If Dim Cycle = 0 Dim Lang_Row = 0 Dim First_i = 0 If See_Page = "edifici" Then First_i = 1 Cycle = 15 Lang_Row = Var_Row_Edifici + 60 End If If See_Page = "ricerche" Then First_i = 1 Cycle = 7 Lang_Row = 328 End If If See_Page = "esercito" Then First_i = 1 Cycle = 18 Lang_Row = Var_Row_Esercito End If If See_Page = "difese" Then First_i = 19 Cycle = 2 Lang_Row = Var_Row_Difese - 10 End If If See_Page = "abilita" Then First_i = 1 Cycle = 12 Lang_Row = Var_Row_Abilita + 48 End If Dim Var_Quant_Costr = Read_File("inc\Lang\Languages.aspx",470) Dim Var_Livello = Read_File("inc\Lang\Languages.aspx",471) Dim Var_TC_Lang = Read_File("inc\Lang\Languages.aspx",465) Dim Var_Ore_Lang = Read_File("inc\Lang\Languages.aspx",466) Dim Var_Minuti_Lang = Read_File("inc\Lang\Languages.aspx",467) Dim Var_Richiede_Lang = Read_File("inc\Lang\Languages.aspx",468) Dim Var_Legna_Lang = Read_File("inc\Lang\Languages.aspx",460) Dim Var_Pietra_Lang = Read_File("inc\Lang\Languages.aspx",461) Dim Var_Mana_Lang = Read_File("inc\Lang\Languages.aspx",462) Dim Var_Oro_Lang = Read_File("inc\Lang\Languages.aspx",463) Response.Write ("

") Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write ("
") For i = First_i to Cycle + First_i - 1 If See_Page <> "difese" AND See_Page <> "esercito" Then arr_level_costr(i) = Int(arr_level_costr(i)) End If If See_Page = "difese" OR See_Page = "esercito" Then arr_level_costr(i) = Abs(Int(-arr_level_costr(i))) End If Dim Hidden = 0 Dim Max_Level = 0 If (See_Page = "edifici") AND (i = 9 AND arr_level_costr(8) < 3) Then Hidden = 1 Else If (See_Page = "edifici") AND i = 10 AND (arr_level_costr(8) < 5 OR arr_level_costr(9) < 4) Then Hidden = 1 Else If (See_Page = "edifici") AND i = 11 AND (arr_level_costr(8) < 8 OR arr_level_costr(9) < 5 OR arr_level_costr(10) < 3) Then Hidden = 1 Else If (See_Page = "edifici") AND i = 12 AND (arr_level_costr(8) < 10 OR arr_level_costr(9) < 6 OR arr_level_costr(10) < 5 OR arr_level_costr(11) < 2) Then Hidden = 1 Else If (See_Page = "edifici") AND i = 13 AND (arr_level_costr(8) < 12 OR arr_level_costr(9) < 7 OR arr_level_costr(10) < 8 OR arr_level_costr(11) < 4 OR arr_level_costr(12) < 2) Then Hidden = 1 Else If (See_Page = "edifici") AND i = 14 AND (arr_level_costr(8) < 14 OR arr_level_costr(9) < 8 OR arr_level_costr(10) < 10 OR arr_level_costr(11) < 5 OR arr_level_costr(12) < 3 OR arr_level_costr(13) < 3) Then Hidden = 1 Else If (See_Page = "edifici") AND i = 15 AND (arr_level_costr(8) < 15 OR arr_level_costr(9) < 10 OR arr_level_costr(10) < 10 OR arr_level_costr(11) < 5 OR arr_level_costr(12) < 5 OR arr_level_costr(13) < 5 OR arr_level_costr(14) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 1 AND arr_level_costr_Edif(8) < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 2 AND arr_level_costr_Edif(9) < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 3 AND arr_level_costr_Edif(8) < 4) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 4 AND arr_level_costr_Edif(9) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 5 AND arr_level_costr_Edif(10) < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 6 AND arr_level_costr_Edif(11) < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 7 AND arr_level_costr_Edif(12) < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 8 AND arr_level_costr_Edif(8) < 8) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 9 AND arr_level_costr_Edif(13) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 10 AND arr_level_costr_Edif(10) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 11 AND arr_level_costr_Edif(11) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 12 AND arr_level_costr_Edif(14) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 13 AND arr_level_costr_Edif(15) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 14 AND arr_level_costr_Edif(15) < 10) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 15 AND R_Espl < 1) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 16 AND arr_level_costr_Edif(1) < 5) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 17 AND arr_level_costr_Edif(1) < 2) Then Hidden = 1 Else If (See_Page = "esercito") AND (i = 18 AND arr_level_costr_Edif(1) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 1 AND arr_level_costr_Edif(8) < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 2 AND arr_level_costr_Edif(9) < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 3 AND arr_level_costr_Edif(8) < 4) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 4 AND arr_level_costr_Edif(9) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 5 AND arr_level_costr_Edif(10) < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 6 AND arr_level_costr_Edif(11) < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 7 AND arr_level_costr_Edif(12) < 1) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 8 AND arr_level_costr_Edif(8) < 8) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 9 AND arr_level_costr_Edif(13) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 10 AND arr_level_costr_Edif(10) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 11 AND arr_level_costr_Edif(11) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 12 AND arr_level_costr_Edif(14) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 13 AND arr_level_costr_Edif(15) < 5) Then Hidden = 1 Else If (See_Page = "abilita") AND (i = 14 AND arr_level_costr_Edif(15) < 10) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 1 AND arr_level_costr_Edif(7) < 1) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 2 AND arr_level_costr_Edif(7) < 3) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 3 AND arr_level_costr_Edif(7) < 5) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 4 AND arr_level_costr_Edif(7) < 7) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 5 AND arr_level_costr_Edif(7) < 10) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 6 AND arr_level_costr_Edif(7) < 12) Then Hidden = 1 Else If (See_Page = "ricerche") AND (i = 7 AND arr_level_costr_Edif(7) < 15) Then Hidden = 1 Else If (See_Page = "difese") AND (i = 19 AND arr_level_costr_Edif(15) < 5 AND arr_level_costr(i) = 0) Then Hidden = 1 Else If (See_Page = "difese") AND (i = 20 AND arr_level_costr_Edif(15) < 5) Then Hidden = 1 End If If (See_Page = "edifici") AND i = 7 AND arr_level_costr(7) >= 15 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 8 AND arr_level_costr(8) >= 15 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 9 AND arr_level_costr(9) >= 10 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 10 AND arr_level_costr(10) >= 10 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 11 AND arr_level_costr(11) >= 5 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 12 AND arr_level_costr(12) >= 5 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 13 AND arr_level_costr(13) >= 5 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 14 AND arr_level_costr(14) >= 5 Then Max_Level = 1 Else If (See_Page = "edifici") AND i = 15 AND arr_level_costr(15) >= 10 Then Max_Level = 1 Else If (See_Page = "ricerche") AND i = 2 AND arr_level_costr(2) >= 15 Then Max_Level = 1 Else If (See_Page = "ricerche") AND i = 3 AND arr_level_costr(3) >= 10 Then Max_Level = 1 Else If (See_Page = "ricerche") AND i = 4 AND arr_level_costr(4) >= 10 Then Max_Level = 1 Else If (See_Page = "ricerche") AND i = 5 AND arr_level_costr(5) >= 10 Then Max_Level = 1 Else If (See_Page = "ricerche") AND i = 6 AND arr_level_costr(6) >= 10 Then Max_Level = 1 Else If (See_Page = "ricerche") AND i = 7 AND arr_level_costr(7) >= 10 Then Max_Level = 1 Else If (See_Page = "abilita") AND arr_level_costr(i) >= 3 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 20 AND Trim(User_Race) = "Human" AND arr_level_costr(i) >= 4 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 20 AND Trim(User_Race) = "Elf" AND arr_level_costr(i) >= 3 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 20 AND Trim(User_Race) = "Orc" AND arr_level_costr(i) >= 2 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 20 AND Trim(User_Race) = "Undead" AND arr_level_costr(i) >= 3 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 19 AND Trim(User_Race) = "Human" AND arr_level_costr(i) >= 4 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 19 AND Trim(User_Race) = "Elf" AND arr_level_costr(i) >= 5 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 19 AND Trim(User_Race) = "Orc" AND arr_level_costr(i) >= 6 Then Max_Level = 1 Else If (See_Page = "difese") AND i = 19 AND Trim(User_Race) = "Undead" AND arr_level_costr(i) >= 5 Then Max_Level = 1 End If If Hidden = 0 Then Ore = Tempo_Costruzione(Prefix & i &"", arr_level_costr(i), User_Race) Risorse_Costruzione(Prefix & i &"", arr_level_costr(i), User_Race, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro) Response.Write ("") Response.Write ("


") Response.Write ("
"abilita" Then Response.Write ("width=""96"" height=""85""") End If Response.Write (">"& Var_Quant_Costr &": "& (arr_level_costr(i)) &"
"& arr_names(i) &"
") Response.Write (""& Var_TC_Lang &":
"& Ore &" "& Var_Ore_Lang &" "& Minuti &" "& Var_Minuti_Lang &"
") Response.Write (Var_Richiede_Lang &":
"& Var_Legna_Lang &": "& Legna &" "& Var_Pietra_Lang &": "& Pietra &" "& Var_Mana_Lang &": "& Mana &" "& Var_Oro_Lang &": "& Oro) Response.Write ("

") If Max_Level = 1 Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",738) &"") Else Response.Write ("

") If Timer_Costruct = "Si" AND See_Page <> "difese" AND See_Page <> "abilita" AND Not Premium_Data < Datetime.Now Then Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write ("
") Response.Write (" ") Response.Write ("
") End If If (Check_Ris="Si" AND Timer_Costruct = "No") Then Response.Write ("

Costruisci") End If If Timer_Costruct = "Si" AND Cosa_Costr = Prefix & i Then Response.Write ("

Annulla") End If End If Response.Write ("

-------------------------------------------------------------
") End If Next If See_Page <> "difese" AND See_Page <> "abilita" AND Not Premium_Data < Datetime.Now Then Response.Write ("


"& Read_File("inc\Lang\Languages.aspx",739) &"

") Dim Is_Coda = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Coda_Addestra, Quantity FROM Code WHERE Coda_Addestra LIKE '"& Prefix &"%' AND Id_Paese = '"& Id_Paese &"' ORDER BY ID ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Is_Coda = 1 Response.Write (arr_names(Mid (r("Coda_Addestra"), Len(Prefix) + 1)) &" "& r("Quantity")&"
") End While r.Close() sqlConn.Close() Response.Write ("

") If Is_Coda = 1 Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",740) &"") End If Response.Write ("
") End If If Timer_Costruct= "Si" Then %> <% End If %>