%@ 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" %>
Assedi al Tuo Castello
<%
Dim Var_Last_Id
Dim Total_Exist = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT * 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 * 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 * 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 * 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()
%>
![]()
![]()
![]()
![]()
![]()
![]()
![]()
Assedio dal Paese "<%=r("Nome")%>"
Continente: <%=r("Dimensione_Started")%>
Reame: <%=r("Reame_Started")%>
Paese: <%=r("Paese_Started")%>
<% If Is_Principal = 1 Then %>
Sta attaccando il tuo Paese Principale <%=Nome_Paese_Attaccato%>!!!
<% End If %>
<% If Is_Principal = 0 Then %>
Sta attaccando la tua Colonia <%=Nome_Paese_Attaccato%>!!!
<% End If %>
">Dettagli
![]()
![]()
![]()
![]()
<%
End While
r.Close()
sqlConn.Close()
End If
End While
If Total_Exist = 0 Then
%>
<%
End If
%>
![]()
![]()
![]()
![]()
![]()
![]()
![]()
Non ci sono Assedi in Corso
![]()
![]()
![]()
![]()