<%@ 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.Drawing" %>

<% If TxT_Mappa_Dimensione.Text = "" Then TxT_Mappa_Dimensione.Text = Dimensione End If If TxT_Mappa_Reame.Text = "" Then TxT_Mappa_Reame.Text = Reame End If TxT_Mappa_Dimensione.Text = Replace(TxT_Mappa_Dimensione.Text,"'","") TxT_Mappa_Reame.Text = Replace(TxT_Mappa_Reame.Text,"'","") %> Mappa

Continente: <%=TxT_Mappa_Dimensione.Text%>

Reame: <%=TxT_Mappa_Reame.Text%>


<% Dim Var_Color = "181818" Dim Fama_Tua sqlConn.Open() sqlComm = New SqlCommand("SELECT Fama FROM Utenti WHERE Username = '" + Proprietary + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Fama_Tua = r("Fama") End While r.Close() sqlConn.Close() Dim i = 1 Dim There_Is_Paese = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Vacanza.Id_Utente as Id_Vacanza, Utenti.Id as Id_Utente, Utenti.Icq_Uin, Utenti.Msn, Utenti.Username, Utenti.Gilda, Utenti.Fama, Pianeti.Dimensione, Pianeti.Reame, Pianeti.Paese, Pianeti.Nome, Pianeti.Proprietary, Pianeti.Is_Principal FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary LEFT Join Vacanza ON Utenti.Id = Vacanza.Id_Utente WHERE Pianeti.Dimensione = '" + TxT_Mappa_Dimensione.Text + "' AND Pianeti.Reame = '" + TxT_Mappa_Reame.Text + "' ORDER BY Paese ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("") While i <> (r("Paese")) Response.Write ("") If Var_Color = "181818" Then Var_Color = "393839" Else Var_Color = "181818" End If i = i + 1 End While i = i + 1 There_Is_Paese = 1 Response.Write ("") Response.Write ("") Response.Write ("") If Var_Color = "181818" Then Var_Color = "393839" Else Var_Color = "181818" End If End While r.Close() sqlConn.Close() While i <> 51 Response.Write ("") If Var_Color = "181818" Then Var_Color = "393839" Else Var_Color = "181818" End If i = i + 1 End While %> Response.Write ("
Paese Nome Proprietario Azioni
               
"& i &""& Read_File("inc\Lang\Languages.aspx",302) &"      
"& r("Paese") &"") Response.Write (""& r("Nome") &"") If Not r("Id_Vacanza") Is System.DbNull.Value Then Response.Write (" (*)") End If Response.Write (""& r("Proprietary") &"") If Trim(r("Gilda")) <> "" Then Response.Write ("["& Trim(r("Gilda")) &"]") End If Response.Write ("") Dim Cat_Nemico Dim Cat_Tua If r("Fama")> -1 AND r("Fama")< 16 Then Cat_Nemico = 0 End If If r("Fama")> 15 AND r("Fama")< 50 Then Cat_Nemico = 1 End If If r("Fama")> 49 AND r("Fama")< 200 Then Cat_Nemico = 2 End If If r("Fama")> 199 AND r("Fama")< 351 Then Cat_Nemico = 3 End If If r("Fama")> 350 AND r("Fama")< 501 Then Cat_Nemico = 4 End If If r("Fama")> 500 AND r("Fama")< 901 Then Cat_Nemico = 5 End If If r("Fama")> 900 AND r("Fama")< 1501 Then Cat_Nemico = 6 End If If r("Fama")> 1500 Cat_Nemico = 7 End If If Fama_Tua > -1 AND Fama_Tua < 16 Then Cat_Tua = 0 End If If Fama_Tua > 15 AND Fama_Tua < 50 Then Cat_Tua = 1 End If If Fama_Tua > 49 AND Fama_Tua < 200 Then Cat_Tua = 2 End If If Fama_Tua > 199 AND Fama_Tua < 351 Then Cat_Tua = 3 End If If Fama_Tua > 350 AND Fama_Tua < 501 Then Cat_Tua = 4 End If If Fama_Tua > 500 AND Fama_Tua < 901 Then Cat_Tua = 5 End If If Fama_Tua > 900 AND Fama_Tua < 1501 Then Cat_Tua = 6 End If If Fama_Tua > 1500 Cat_Tua = 7 End If If Cat_Tua > Cat_Nemico Then Response.Write ("") End If Response.Write ("") If r("Icq_Uin") <> "" Then Dim Icq_Uin = Replace(r("Icq_Uin"),"-","") Response.Write ("") End If Response.Write ("") If r("Msn") <> "" Then Response.Write ("") End If Response.Write ("
"& i &""& Read_File("inc\Lang\Languages.aspx",302) &"      


") Response.Write ("") Response.Write ("") Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",210) &":
"& Read_File("inc\Lang\Languages.aspx",211) &":
") %>



<%=Read_File("inc\Lang\Languages.aspx",307)%>