<%@ 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" %> <%@ Import namespace="System.Globalization" %>
 

Abbonati ai Servizi Premium di R.O.D.!!!

Informati cliccando qui
 

<% 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.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 (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 If (r("Type_Mission") = "Rubare" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Attacco" AND r("Army_Of") = Proprietary) OR (r("Type_Mission") = "Attacco" AND r("Proprietary") = Proprietary AND Ora < Var_R_Esplorazione + 1) OR (r("Type_Mission") <> "Attacco" AND r("Type_Mission") <> "Rubare" AND (r("Army_Of") = Proprietary OR r("Proprietary") = Proprietary)) Then There_Is_Mission = There_Is_Mission + 1 There_Is_Mission_X = 1 If There_Is_Mission = 1 Then %>

<% End If Counter = Counter + 1 Ore_Js = Ore Minuti_Js = Minuti Secondi_Js = Secondi Dove = "Div_Missione" + CStr(Counter) arr_id(Counter) = Counter arr_Ore(Counter) = Ore arr_Minuti(Counter) = Minuti arr_Secondi(Counter) = Secondi %> <% If r("Army_Of") = Proprietary AND r("Type_Mission") <> "Rinforzi" Then %> <% End If %> <% If r("Army_Of") = Proprietary AND r("Type_Mission") = "Rinforzi" AND r("Dimensione_Started") = Dimensione AND r("Reame_Started") = Reame AND r("Paese_Started") = Paese Then %> <% End If %> <% End If End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT Missioni.Time_started, Missioni.Time_arrive, Missioni.Type_Mission, Missioni.Army_Of, Missioni.Id as Id_Missione FROM Missioni WHERE Army_Of = '" + Proprietary + "' AND Type_Mission = 'Colonizzare' ", 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 There_Is_Mission = There_Is_Mission + 1 There_Is_Mission_X = 1 If There_Is_Mission = 1 Then %>

<%=Read_File("inc\Lang\Languages.aspx",31)%>
   
"> <% If r("Army_Of") = Proprietary AND r("Type_Mission") = "Attacco" Then %> <%=Read_File("inc\Lang\Languages.aspx",32)%> <% End if %> <% If r("Army_Of") <> Proprietary AND r("Type_Mission") = "Attacco" Then %> <%=Read_File("inc\Lang\Languages.aspx",33)%> <% End if %> <% If r("Type_Mission") = "Rubare" Then %> <%=Read_File("inc\Lang\Languages.aspx",34)%> <% End if %> <% If r("Type_Mission") = "Spionaggio" Then %> <%=Read_File("inc\Lang\Languages.aspx",35)%> <% End if %> <% If r("Type_Mission") = "Rinforzi" Then %> <%=Read_File("inc\Lang\Languages.aspx",36)%> <% End if %> <% If r("Type_Mission") = "Trasporto" Then %> <%=Read_File("inc\Lang\Languages.aspx",37)%> <% End if %> <% If r("Type_Mission") = "Colonizzare" Then %> <%=Read_File("inc\Lang\Languages.aspx",38)%> <% End if %>
"> <%=Read_File("inc\Lang\Languages.aspx",39)%> "> <%=Read_File("inc\Lang\Languages.aspx",39)%>
<% End If Counter = Counter + 1 Ore_Js = Ore Minuti_Js = Minuti Secondi_Js = Secondi Dove = "Div_Missione" + CStr(Counter) arr_id(Counter) = Counter arr_Ore(Counter) = Ore arr_Minuti(Counter) = Minuti arr_Secondi(Counter) = Secondi %> <% If r("Type_Mission") <> "Rinforzi" AND r("Army_Of") = Proprietary Then %> <% End If %> <% End While r.Close() sqlConn.Close() If There_Is_Mission_X = 0 Then %>

<%=Read_File("inc\Lang\Languages.aspx",31)%>
   
"> <%=r("Type_Mission")%>
"> Ritira
<% End If %>
<%=Read_File("inc\Lang\Languages.aspx",31)%>
   

Non ci sono missioni in corso.


  <% Dim Var_C_Statua = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT C_Laboratorio, C_Caserma, C_Taglialegna, C_Tesoreria, C_Torture, C_Prigione, C_Taverna, C_Scuderia, R_Assedio, C_Mercato, C_Poligono_Tiro FROM Pianeti WHERE Dimensione = '"& Dimensione &"' AND Reame = '"& Reame &"' AND Paese = '"& Paese &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() %>


 
Fattorie
<% If r("C_Laboratorio") > 0 %>Università<% End If %>
Miniere  
<% If r("C_Caserma") > 0 %>Caserma<% End If %>
<% If r("C_Taglialegna") > 0 %>Segheria<% End If %>
<% If r("C_Tesoreria") > 0 %>Tesoreria<% End If %>
<% If r("C_Torture") > 0 %>Sala Torture<% End If %> <% If r("C_Prigione") > 0 %>Prigione<% End If %> <% If r("C_Taverna") > 0 %>Taverna<% End If %>
<% If r("C_Scuderia") > 0 %>Scuderia<% End If %>
<% If r("R_Assedio") > 0 %>Laboratorio D'Assedio<% End If %>
<% If r("C_Mercato") > 0 %>Mercato<% End If %> <% If Var_C_Statua > 0 %><% End If %>  
<% If r("C_Poligono_Tiro") > 0 %>Poligono di Tiro<% End If %>
 
<% End While r.Close() sqlConn.Close() %> <% Dim i Dim Pre For i = 1 To Counter Ore_JS = arr_Ore(i) Minuti_JS = arr_Minuti(i) Secondi_JS = arr_Secondi(i) Dove = "Div_Missione" + CStr(arr_id(i)) Pre = "M_"+CStr(arr_id(i))+"_" response.write (arr_Ore(i)) response.write (arr_Minuti(i)) response.write (arr_Secondi(i)) %> <% Next %>