<%@ 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" %> <% Dim User_Race = "Orc" %> Lords Of Wars <% Dim Risorsa_1 Dim Risorsa_2 Dim Risorsa_3 Dim Risorsa_4 Dim Ris_Legna_P Dim Ris_Pietra_P Dim Ris_Mana_P Dim Ris_Oro_P If User_Race = "Human" Then Risorsa_1 = 0.007 Risorsa_2 = 0.004 Risorsa_3 = 0.003 Risorsa_4 = 0.008 Else If User_Race = "Elf" Then Risorsa_1 = 0.008 Risorsa_2 = 0.003 Risorsa_3 = 0.004 Risorsa_4 = 0.007 Else If User_Race = "Orc" Then Risorsa_1 = 0.007 Risorsa_2 = 0.008 Risorsa_3 = 0.003 Risorsa_4 = 0.004 Else If User_Race = "Undead" Then Risorsa_1 = 0.007 Risorsa_2 = 0.003 Risorsa_3 = 0.008 Risorsa_4 = 0.004 End If Dim Is_Already_In_Costruct Dim Data_Odierna Dim i Dim arr_Names_Costr(20) Dim arr_Names_Ris(20) Dim arr_Names_Eser(20) 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 = 41 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 = 59 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 = 77 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 = 95 Var_Row_Edifici = 230 Var_Row_Difese = 311 Var_Row_Abilita = 371 End If For i = 1 to 15 arr_Names_Costr(i) = Read_File("inc\Lang\Languages.aspx",Var_Row_Edifici + i - 1) Next For i = 1 to 7 arr_Names_Ris(i) = Read_File("inc\Lang\Languages.aspx", 321 + i - 1) Next For i = 1 to 18 arr_Names_Eser(i) = Read_File("inc\Lang\Languages.aspx", Var_Row_Esercito + i - 1) Next Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") For i = 1 to 15 Response.Write ("") Next Response.Write ("") For i = 1 to 7 Response.Write ("") Next Response.Write ("") For i = 1 to 18 Response.Write ("") Next Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") sqlConn.Open() sqlComm = New SqlCommand("SELECT Nome, Ris_Legna, Ris_Pietra, Ris_Mana, Ris_Oro, In_Costr_Infr, Cosa_Costr_Infr, Data_Costr_Infr, In_Costr_Eser, Cosa_Costr_Eser, Data_Costr_Eser, In_Costr_Res, Cosa_Costr_Res, Data_Costr_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, 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, P_Cittadini, P_Costr_3, P_Costr_4, P_Costr_5, P_Costr_6 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 Pianeti.Proprietary = '"& Decripta(Request.Cookies("Reign_Of_Darkness")("Username").ToString()) &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If User_Race = "Human" OR User_Race = "Orc" Then Ris_Legna_P = (Risorsa_1 * (r("P_Costr_3")/50))*6 Ris_Pietra_P = (Risorsa_2 * (r("P_Costr_4")/50))*6 Ris_Mana_P = (Risorsa_3 * (r("P_Costr_5")/50))*6 + (Risorsa_3 * (r("P_Costr_5")/50))*6 * (r("R_Ric_4")/20) Ris_Oro_P = (Risorsa_4 * (r("P_Costr_6")/50))*6 End If If User_Race = "Elf" OR User_Race = "Undead" Then Ris_Legna_P = (Risorsa_1 * (r("P_Costr_3")/50))*6 Ris_Pietra_P = (Risorsa_2 * (r("P_Costr_4")/50))*6 + (Risorsa_2 * (r("P_Costr_4")/50))*6 * (r("R_Ric_4")/20) Ris_Mana_P = (Risorsa_3 * (r("P_Costr_5")/50))*6 Ris_Oro_P = (Risorsa_4 * (r("P_Costr_6")/50))*6 End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Dim Prefix Dim Cosa_Costr Dim Timer_Costruct Dim Var_Data_Costr_Infr Dim arr_level_costr(20) Dim arr_level_eser(20) Dim arr_level_ric(20) Dim Q_Cosa_Costr Dim Lavoro Prefix = "c_costr_" Cosa_Costr = r("Cosa_Costr_Infr") If Cosa_Costr <> "" Then Q_Cosa_Costr = r(Cosa_Costr) End If Timer_Costruct = r("In_Costr_Infr") Var_Data_Costr_Infr = r("Data_Costr_Infr") For i = 1 to 15 arr_level_costr(i) = r("C_Costr_"&i) Next 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) If Len(CStr(Minuti)) < 2 Then Minuti = "0" & CStr(Minuti) End If If Secondi < 0 Then Secondi = 0 If Len(CStr(Secondi)) < 2 Then Secondi = "0" & CStr(Secondi) End If Response.Write ("") Response.Write ("") Response.Write ("") Prefix = "e_sold_" Cosa_Costr = r("Cosa_Costr_Eser") If Cosa_Costr <> "" Then Q_Cosa_Costr = r(Cosa_Costr) End If Timer_Costruct = r("In_Costr_Eser") Var_Data_Costr_Infr = r("Data_Costr_Eser") For i = 1 to 18 arr_level_Eser(i) = r("E_Sold_"&i) Next 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) If Len(CStr(Minuti)) < 2 Then Minuti = "0" & CStr(Minuti) End If If Secondi < 0 Then Secondi = 0 If Len(CStr(Secondi)) < 2 Then Secondi = "0" & CStr(Secondi) End If Response.Write ("") Response.Write ("") Response.Write ("") Prefix = "r_ric_" Cosa_Costr = r("Cosa_Costr_Res") If Cosa_Costr <> "" Then Q_Cosa_Costr = r(Cosa_Costr) End If Timer_Costruct = r("In_Costr_Res") Var_Data_Costr_Infr = r("Data_Costr_Res") For i = 1 to 7 arr_level_Ric(i) = r("R_Ric_"&i) Next 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) If Len(CStr(Minuti)) < 2 Then Minuti = "0" & CStr(Minuti) End If If Secondi < 0 Then Secondi = 0 If Len(CStr(Secondi)) < 2 Then Secondi = "0" & CStr(Secondi) End If Response.Write ("") Response.Write ("") Response.Write ("") End While r.Close() sqlConn.Close() %>
 Risorse Edifici Ricerche Esercito Cittadini Produzioni Orarie Attuali Costruzioni Attuali Addestramenti Attuali Ricerche
        LegnoPietraManaOro    "& arr_Names_Costr(i) &"    "& arr_Names_Ris(i) &"    "& arr_Names_Eser(i) &"    Cittadini TotaliTaglialegnaMinatori di PietreFedeliMinatori D'Oro    Prod. LegnaProd. PietraProd. ManaProd. Oro    In CostruzioneTempo Rimasto    In AddestramentoTempo Rimasto    In RicercaTempo Rimasto
"& r("Nome") &"    "& CInt(r("Ris_Legna")) &""& CInt(r("Ris_Pietra")) &""& CInt(r("Ris_Mana")) &""& CInt(r("Ris_Oro")) &"    "& r("C_Costr_1") &""& r("C_Costr_2") &""& r("C_Costr_3") &""& r("C_Costr_4") &""& r("C_Costr_5") &""& r("C_Costr_6") &""& r("C_Costr_7") &""& r("C_Costr_8") &""& r("C_Costr_9") &""& r("C_Costr_10") &""& r("C_Costr_11") &""& r("C_Costr_12") &""& r("C_Costr_13") &""& r("C_Costr_14") &""& r("C_Costr_15") &"    "& r("R_Ric_1") &""& r("R_Ric_2") &""& r("R_Ric_3") &""& r("R_Ric_4") &""& r("R_Ric_5") &""& r("R_Ric_6") &""& r("R_Ric_7") &"    "& CInt(r("E_Sold_1")) &""& CInt(r("E_Sold_2")) &""& CInt(r("E_Sold_3")) &""& CInt(r("E_Sold_4")) &""& CInt(r("E_Sold_5")) &""& CInt(r("E_Sold_6")) &""& CInt(r("E_Sold_7")) &""& CInt(r("E_Sold_8")) &""& CInt(r("E_Sold_9")) &""& CInt(r("E_Sold_10")) &""& CInt(r("E_Sold_11")) &""& CInt(r("E_Sold_12")) &""& CInt(r("E_Sold_13")) &""& CInt(r("E_Sold_14")) &""& CInt(r("E_Sold_15")) &""& CInt(r("E_Sold_16")) &""& CInt(r("E_Sold_17")) &""& CInt(r("E_Sold_18")) &"    "& CInt(r("P_Cittadini")) &""& CInt(r("P_Costr_3")) &""& CInt(r("P_Costr_4")) &""& CInt(r("P_Costr_5")) &""& CInt(r("P_Costr_6")) &"    "& Cint((Ris_Legna_P)*3600) &""& Cint((Ris_Pietra_P)*3600) &""& Cint((Ris_Mana_P)*3600) &""& Cint((Ris_Oro_P)*3600) &"    ") If Cosa_Costr <> "" Then Response.Write (arr_Names_Costr(Replace(Cosa_Costr,"c_costr_",""))) Else Response.Write ("No") End If Response.Write ("") If Cosa_Costr <> "" Then Response.Write (Ore &":"& Minuti &":"& Secondi) Else Response.Write ("No") End If Response.Write ("    ") If Cosa_Costr <> "" Then Response.Write (arr_Names_Eser(Replace(Cosa_Costr,"e_sold_",""))) Else Response.Write ("No") End If Response.Write ("") If Cosa_Costr <> "" Then Response.Write (Ore &":"& Minuti &":"& Secondi) Else Response.Write ("No") End If Response.Write ("    ") If Cosa_Costr <> "" Then Response.Write (arr_Names_Ris(Replace(Cosa_Costr,"r_ric_",""))) Else Response.Write ("No") End If Response.Write ("") If Cosa_Costr <> "" Then Response.Write (Ore &":"& Minuti &":"& Secondi) Else Response.Write ("No") End If Response.Write ("