%@ 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" %> <% sqlConn.Open() sqlComm = New SqlCommand("SELECT R_Esplorazione FROM Pianeti WHERE Proprietary = '"& Proprietary &"' And Is_Principal = 1 ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Var_R_Esplorazione = r("R_Esplorazione") End While r.Close() sqlConn.Close() Dim There_Is_Mission = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Ritirata, Missioni.Dimensione_started, Missioni.Reame_started, Missioni.Paese_started, Missioni.Time_started, Missioni.Time_arrive, Missioni.Type_Mission, Missioni.Army_Of, Missioni.Id as Id_Missione, Pianeti.Proprietary FROM Missioni JOIN Pianeti ON Missioni.Dimensione_Arrive = Pianeti.Dimensione AND Missioni.Reame_Arrive = Pianeti.Reame AND Missioni.Paese_Arrive = Pianeti.Paese WHERE Pianeti.Proprietary = '"& Proprietary &"' AND Type_Mission = 'Attacco' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Dim Lavoro = (DateDiff("s",r("Time_Started"), DateTime.Now)) Secondi_Ore(DateDiff("s",r("Time_Started"), r("Time_Arrive")) - Lavoro) Dim Ora = Ore If (Ora < Var_R_Esplorazione + 1) Then There_Is_Mission = 1 End If End While r.Close() sqlConn.Close() If There_Is_Mission = 1 Response.Write ("") End If %>
|