<%@ 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.IO" %> <%@ Import namespace="System.Net" %> <%@ Import namespace="System.Globalization" %> <% If (-DateDiff("d",Datetime.Now,Registration_Data)) < 7 Then Response.Write ("

Sei sotto la protezione newbie e non puoi essere attaccato per altri giorni: "& 7 - (-DateDiff("d",Datetime.Now,Registration_Data)) &"

") End If If (-DateDiff("d",Datetime.Now,Registration_Data)) < 15 Then Response.Write ("

Giorni gratuiti di Servizi Premium rimasti: "& 15 - (-DateDiff("d",Datetime.Now,Registration_Data)) &"

") End If sqlConn.Open() sqlComm = New SqlCommand("SELECT R_Ric_1 FROM Ricerche JOIN Pianeti ON Pianeti.Id = Ricerche.Id_Paese WHERE Proprietary = '"& Proprietary &"' And Is_Principal = 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_R_Esplorazione = r("R_Ric_1") End While r.Close() sqlConn.Close() Dim There_Is_Mission = 0 Dim There_Is_Mission_X = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Ritirata, Missioni.Id_started, Missioni.Time_started, Missioni.Time_arrive, Missioni.Type_Mission, Missioni.Army_Of, Missioni.Id as Id_Missione, Pianeti.Proprietary FROM Missioni LEFT JOIN Pianeti ON Missioni.Id_Arrive = Pianeti.Id WHERE (Army_Of = '" + Proprietary + "' OR Missioni.Id_Arrive = Pianeti.Id) AND Type_Mission <> 'Assedio' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Dim Lavoro = (DateDiff("s",r("Time_Started"), DateTime.Now)) Secondi_Ore(DateDiff("s",r("Time_Started"), r("Time_Arrive")) - Lavoro) Dim Prop_Paese = r("Proprietary") If Prop_Paese Is System.DbNull.Value Then Prop_Paese = "" End If If (r("Type_Mission") = "Rubare" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Colonizzare" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Attacco" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Attacco" AND Prop_Paese = Proprietary AND Ore < Var_R_Esplorazione + 1) OR (r("Type_Mission") <> "Attacco" AND (r("Army_Of") = Proprietary OR Prop_Paese = Proprietary)) Then There_Is_Mission = There_Is_Mission + 1 There_Is_Mission_X = 1 If There_Is_Mission = 1 Then Response.Write ("



") End If Counter = Counter + 1 Ore_Js = Ore Minuti_Js = Minuti Secondi_Js = Secondi Dove = "Div_Missione" + CStr(Counter) Redim Preserve arr_Id(Counter + 1) Redim Preserve arr_Ore(Counter + 1) Redim Preserve arr_Minuti(Counter + 1) Redim Preserve arr_Secondi(Counter + 1) arr_id(Counter) = Counter arr_Ore(Counter) = Ore arr_Minuti(Counter) = Minuti arr_Secondi(Counter) = Secondi Response.Write ("") If r("Army_Of") = Proprietary AND r("Type_Mission") <> "Rinforzi" AND r("Ritirata") <> "Y" Then Response.Write ("") End If If r("Army_Of") = Proprietary AND r("Type_Mission") = "Rinforzi" AND r("Id_Started") = Id_Paese AND r("Ritirata") <> "Y" Then Response.Write ("") End If Response.Write ("") End If End While r.Close() sqlConn.Close() If There_Is_Mission_X = 0 Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",31) &"
  
") If r("Army_Of") = Proprietary AND r("Type_Mission") = "Attacco" Then Response.Write (Read_File("inc\Lang\Languages.aspx",32)) End if If r("Army_Of") <> Proprietary AND r("Type_Mission") = "Attacco" Then Response.Write (Read_File("inc\Lang\Languages.aspx",33)) End if If r("Type_Mission") = "Rubare" Then Response.Write (Read_File("inc\Lang\Languages.aspx",34)) End if If r("Type_Mission") = "Spionaggio" Then Response.Write (Read_File("inc\Lang\Languages.aspx",35)) End if If r("Type_Mission") = "Rinforzi" Then Response.Write (Read_File("inc\Lang\Languages.aspx",36)) End if If r("Type_Mission") = "Trasporto" Then Response.Write (Read_File("inc\Lang\Languages.aspx",37)) End if If r("Type_Mission") = "Colonizzare" Then Response.Write (Read_File("inc\Lang\Languages.aspx",38)) End if Response.Write ("
") Response.Write (Read_File("inc\Lang\Languages.aspx",39) &"") Response.Write (Read_File("inc\Lang\Languages.aspx",39) &"
") Response.Write ("") End If Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",31) &"
  

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

") Response.Write ("



") If Not Premium_Data < Datetime.Now Then Response.Write ("-----------------------------------------------------------------------

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

") sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Edifici WHERE Id_Paese = '"& Id_Paese &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If User_Race = "Undead" Then 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 ("") If r("C_Costr_1") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_13") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_15") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_12") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_4") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_2") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_14") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_8") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_10") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_5") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_9") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_3") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_7") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_11") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("
") End If If User_Race = "Orc" Then 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 ("") If r("C_Costr_5") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_13") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_14") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_15") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_6") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_9") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_2") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_10") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_12") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_11") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_7") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_1") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_8") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_3") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_1") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_1") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("
") End If If User_Race = "Elf" Then Response.Write ("") Response. Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response. Write ("") Response. Write ("") If r("C_Costr_11") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_10") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_8") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_14") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_6") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_13") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_7") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_2") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_1") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_9") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_5") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_12") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_15") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("
") End If If User_Race = "Human" Then 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 ("") If r("C_Costr_7") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_10") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_15") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_11") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_2") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_6") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_13") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_3") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_8") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_12") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_1") > 0 Then Response.Write ("") Else Response.Write ("") End If If r("C_Costr_5") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_14") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") Response.Write ("") If r("C_Costr_9") > 0 Then Response.Write ("") Else Response.Write ("") End If Response.Write ("") Response.Write ("") Response.Write ("
") End If End While r.Close() sqlConn.Close() End If Dim Pre For i = 1 To Counter Ore_JS = arr_Ore(i) Minuti_JS = arr_Minuti(i) Secondi_JS = arr_Secondi(i) Dove = "Div_Missione" + CStr(arr_id(i)) Pre = "M_"+CStr(arr_id(i))+"_" %><% Next %>