%@ 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 Costo_Crediti 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 If Decripta(Request.QueryString("Post_Scriptum")) = "costruisci_immediatamente" Then Data_Fine = Datetime.Now Data_Fine = Format_Date(Data_Fine) Costo_Crediti = Int((Decripta(Request.QueryString("Level")) + 1)/ 2) If Costo_Crediti < 1 Then Costo_Crediti = 1 End If If Costo_Crediti > Crediti Then Hidden = 1 End If End If 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 If Decripta(Request.QueryString("Post_Scriptum")) = "costruisci_immediatamente" Then sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Crediti = Crediti - "& Costo_Crediti &" WHERE Username = '"& Proprietary &"' ",sqlConn) Dim result As Integer = sqlComm.ExecuteNonQuery() sqlConn.Close() Response.Redirect ("Riepilogo.aspx") 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 Coda_Maxima = 5 Dim arr = Request.Form ("Command") arr = Decripta(arr) Dim Quantity = Request.Form ("Quantity") Dim Quantity_In_Coda = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Quantity FROM Code WHERE Id_Paese = "& Id_Paese &" ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Quantity_In_Coda = Quantity_In_Coda + r("Quantity") End While r.Close() sqlConn.Close() If Quantity = "" OR Only_Num(Quantity) <> 0 Then Quantity = 0 Else If Quantity + Quantity_In_Coda < Coda_Maxima Then Quantity = Quantity Else Quantity = Coda_Maxima - Quantity_In_Coda End If If Quantity > 0 Then 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 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) If DeCripta(Request.QueryString("Code")) = "costruisci_immediatamente" 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")) Level_Before = Decripta(Level_Before) Dim Costo_Crediti = Int((Decripta(Request.QueryString("Level")) + 1)/ 2) If Costo_Crediti < 1 Then Costo_Crediti = 1 End If Response.Write ("
Vuoi costruire immediatamente?")
Response.Write (" Puoi spendere i tuoi Crediti per aumentare istantaneamente il livello di questo edificio o unità (dovrai comunque avere le risorse per farlo). Non hai abbastanza Crediti! Costruisci Immediatamente ")
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 (" "& Read_File("inc\Lang\Languages.aspx",738) &"")
Else
Response.Write ("
La Costruzione Istantanea per passare al livello "& Decripta(Request.QueryString("Level")) + 1 &" ti costerà "& Costo_Crediti &" Crediti")
If Costo_Crediti > Crediti Then
Response.Write ("
")
Else
Response.Write ("
")
End If
Else
Response.Write ("")
Response.Write ("
"& arr_names(i) &" ( "& arr_level_costr(i) &" )
")
Response.Write ("Costo
")
Response.Write (" "& Legna &" -
"& Pietra &" -
"& Mana &" -
"& Oro &"
Tempo impiegato
")
'Response.Write (" "& Ore &"h"& Minuti &"m
Azioni
")
'Response.Write ("
")
If Max_Level = 1 Then
Response.Write ("
Costruisci
")
Response.Write ("Costruisci Immediatamente
")
End If
If Timer_Costruct = "Si" AND Cosa_Costr = Prefix & i Then
Response.Write ("
")
End If
Response.Write ("
")
End If
End If
If Timer_Costruct= "Si" Then
%>
<%
End If
%>
"& 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 ("