%@ 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
%>