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


<% Response.Write (Read_File("inc\Lang\Languages.aspx",15) &"

") Dim Var_Last_Id Dim Total_Exist = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT ID FROM Missioni ORDER BY ID", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_Last_Id = r("ID") End While r.Close() sqlConn.Close() Var_Last_Id = Var_Last_Id + 1 Var_Exist = 1 While Var_Exist = 1 Var_Exist = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.ID, Missioni.Dimensione_Arrive, Missioni.Reame_Arrive, Missioni.Paese_Arrive, Pianeti.Nome, Pianeti.Dimensione, Pianeti.Reame, Pianeti.Paese FROM Missioni JOIN Pianeti ON Pianeti.DImensione = Missioni.Dimensione_Arrive AND Pianeti.Reame = Missioni.Reame_Arrive AND Pianeti.Paese = Missioni.Paese_Arrive AND Pianeti.Proprietary <> Missioni.Army_Of WHERE Type_Mission = 'Assedio' AND Pianeti.Proprietary = '"& Proprietary &"' ORDER BY Missioni.ID DESC", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If r("ID") < Var_Last_Id AND Var_Exist = 0 Then Id_Missione = r("id") Var_Last_Id = r("id") Var_Exist = 1 End If End While r.Close() sqlConn.Close() If Var_Exist = 1 Then Total_Exist = 1 Dim Nome_Paese_Attaccato Dim Is_Principal sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.ID, Missioni.Dimensione_Arrive, Missioni.Reame_Arrive, Missioni.Paese_Arrive, Pianeti.Nome, Pianeti.Dimensione, Pianeti.Reame, Pianeti.Paese, Pianeti.Is_Principal FROM Missioni JOIN Pianeti ON Pianeti.DImensione = Missioni.Dimensione_Arrive AND Pianeti.Reame = Missioni.Reame_Arrive AND Pianeti.Paese = Missioni.Paese_Arrive WHERE Missioni.Id = '"& Id_Missione &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Nome_Paese_Attaccato = (r("Nome")) Is_Principal = (r("Is_Principal")) End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.ID, Missioni.Dimensione_Arrive, Missioni.Reame_Arrive, Missioni.Paese_Arrive, Missioni.Dimensione_Started, Missioni.Reame_Started, Missioni.Paese_Started, Pianeti.Nome, Pianeti.Dimensione, Pianeti.Reame, Pianeti.Paese FROM Missioni JOIN Pianeti ON Pianeti.DImensione = Missioni.Dimensione_Started AND Pianeti.Reame = Missioni.Reame_Started AND Pianeti.Paese = Missioni.Paese_Started WHERE Missioni.Id = '"& Id_Missione &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() %>
 
<% Response.Write("
"& Read_File("inc\Lang\Languages.aspx",215) &" "& r("Nome") &"

"& Read_File("inc\Lang\Languages.aspx",210) &": "& r("Dimensione_Started") &"
"& Read_File("inc\Lang\Languages.aspx",211) &": "& r("Reame_Started") &"
"& Read_File("inc\Lang\Languages.aspx",212) &": "& r("Paese_Started") &"

") If Is_Principal = 1 Then Response.Write (""& Read_File("inc\Lang\Languages.aspx",216) &" "& Nome_Paese_Attaccato &"!!!") End If If Is_Principal = 0 Then Response.Write (""& Read_File("inc\Lang\Languages.aspx",217) &" "& Nome_Paese_Attaccato &"!!!") End If Response.Write ("

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

") %>
 

<% End While r.Close() sqlConn.Close() End If End While If Total_Exist = 0 Then %>
 


<%=Read_File("inc\Lang\Languages.aspx",214)%>

 
<% End If %>