<%@ 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 Type_Assedio = DeCripta(Request.QueryString("Type_Assedio")) If Type_Assedio = "ai_nemici" Then Response.Write ("


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


") Var_Exist = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id, Pianeti_Arrive.Nome, Pianeti_Arrive.Dimensione, Pianeti_Arrive.Reame, Pianeti_Arrive.Paese FROM Missioni JOIN Pianeti ON Pianeti.Id = Missioni.Id_Started AND Pianeti.Proprietary = Missioni.Army_Of LEFT JOIN Pianeti as Pianeti_Arrive ON Pianeti_Arrive.Id = Missioni.Id_Arrive WHERE Type_Mission = 'Assedio' AND Army_Of = '"& Proprietary &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Exist = 1 Response.Write ("


"& Read_File("inc\Lang\Languages.aspx",494) &" """& r("Nome") &""" ["& r("Dimensione") &"."& r("Reame") &"."& r("Paese") &"]

"& Read_File("inc\Lang\Languages.aspx",495) &"
"& Read_File("inc\Lang\Languages.aspx",496) &"") Response.Write ("

-----------------------------------------------------") End While r.Close() sqlConn.Close() If Var_Exist = 0 Then Response.Write ("


"& Read_File("inc\Lang\Languages.aspx",497) &"") End If End If If Type_Assedio = "a_te" Then Response.Write ("


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


") Var_Exist = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Id, Pianeti_Started.Nome, Pianeti_Started.Dimensione, Pianeti_Started.Reame, Pianeti_Started.Paese FROM Missioni JOIN Pianeti ON Pianeti.Id = Missioni.Id_Arrive AND Pianeti.Proprietary = '"& Proprietary &"' JOIN Pianeti as Pianeti_Started ON Pianeti_Started.Id = Missioni.Id_Started WHERE Type_Mission = 'Assedio' AND Army_Of <> '"& Proprietary &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Exist = 1 Response.Write ("


"& Read_File("inc\Lang\Languages.aspx",498) &" """& r("Nome") &""" ["& r("Dimensione") &"."& r("Reame") &"."& r("Paese") &"]

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

") Response.Write ("

-----------------------------------------------------") End While r.Close() sqlConn.Close() If Var_Exist = 0 Then Response.Write ("


"& Read_File("inc\Lang\Languages.aspx",500) &"") End If End If %>