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