<%
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
Dim There_Is_Mission_X = 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 LEFT JOIN Pianeti ON Missioni.Dimensione_Arrive = Pianeti.Dimensione AND Missioni.Reame_Arrive = Pianeti.Reame AND Missioni.Paese_Arrive = Pianeti.Paese WHERE (Army_Of = '" + Proprietary + "' OR ( Missioni.Dimensione_Arrive = Pianeti.Dimensione AND Missioni.Reame_Arrive = Pianeti.Reame AND Missioni.Paese_Arrive = Pianeti.Paese) ) AND Type_Mission <> 'Assedio' AND Type_Mission <> 'Vendita' ", 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
Dim Prop_Paese = r("Proprietary")
If Prop_Paese Is System.DbNull.Value Then
Prop_Paese = ""
End If
If (r("Type_Mission") = "Rubare" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Colonizzare" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Attacco" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Attacco" AND Prop_Paese = Proprietary AND Ora < Var_R_Esplorazione + 1) OR (r("Type_Mission") <> "Attacco" AND r("Type_Mission") <> "Rubare" AND (r("Army_Of") = Proprietary OR Prop_Paese = Proprietary)) Then
There_Is_Mission = There_Is_Mission + 1
There_Is_Mission_X = 1
If There_Is_Mission = 1 Then
Response.Write (" ")
Response.Write ("
|
|
 |