<%@ 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" %> <% Dim TxT_Mappa_Dimensione = Request.Form("TxT_Dimensione") Dim TxT_Mappa_Reame = Request.Form("TxT_Reame") If TxT_Mappa_Dimensione = "" OR TxT_Mappa_Reame = "" OR TxT_Mappa_Dimensione < 1 OR TxT_Mappa_Dimensione > 20 OR TxT_Mappa_Reame < 1 OR TxT_Mappa_Reame > 20 Then sqlConn.Open() sqlComm = New SqlCommand("SELECT Dimensione, Reame FROM Pianeti WHERE Id = '"& Id_Paese &"' ORDER BY Paese ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() TxT_Mappa_Dimensione = r("Dimensione") TxT_Mappa_Reame = r("Reame") End While r.Close() sqlConn.Close() End If TxT_Mappa_Dimensione = Replace(TxT_Mappa_Dimensione,"'","") TxT_Mappa_Reame = Replace(TxT_Mappa_Reame,"'","") Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",12) &"


"& Read_File("inc\Lang\Languages.aspx",454) &": "& TxT_Mappa_Dimensione &"

"& Read_File("inc\Lang\Languages.aspx",455) &": "& TxT_Mappa_Reame &"

") Response.Write ("


") Response.Write ("") Response.Write ("") %> <% i = 1 sqlConn.Open() sqlComm = New SqlCommand("SELECT Utenti.Vacanza as Id_Vacanza, Utenti.Registration_Data, Utenti.Id as Id_Utente, Utenti.Icq_Uin, Utenti.Msn, Utenti.Username, Utenti.Gilda, Utenti.Fama, Pianeti.Dimensione, Pianeti.Reame, Pianeti.Paese, Pianeti.Id, Pianeti.Nome, Pianeti.Proprietary, Pianeti.Is_Principal FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary WHERE Pianeti.Dimensione = '" + TxT_Mappa_Dimensione + "' AND Pianeti.Reame = '" + TxT_Mappa_Reame + "' ORDER BY Paese ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Response.Write ("") While i <> (r("Paese")) Response.Write ("") i = i + 1 End While i = i + 1 Response.Write ("") Response.Write ("") Response.Write ("") End While r.Close() sqlConn.Close() While i <> 51 Response.Write ("") i = i + 1 End While Response.Write ("") Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",456) &""& Read_File("inc\Lang\Languages.aspx",436) &""& Read_File("inc\Lang\Languages.aspx",625) &" "& Read_File("inc\Lang\Languages.aspx",626) &"
               

"& i &"

"& Read_File("inc\Lang\Languages.aspx",449) &"      
"& r("Paese") &"") Response.Write (""& r("Nome") &"") If r("Id_Vacanza") <> 0 Then Response.Write (" (*)") End If Response.Write (""& r("Proprietary") &"") If Trim(r("Gilda")) <> "" Then Response.Write ("["& Trim(r("Gilda")) &"]") End If Response.Write ("") If ((r("Fama") < (Fama_Tua/100*50) AND r("Is_Principal") = 1)) OR r("Registration_Data") > Datetime.Now.AddDays(-7) Then Response.Write ("") Else Response.Write ("
") End If Response.Write ("
") If r("Icq_Uin") <> "" Then Dim Icq_Uin = Replace(r("Icq_Uin"),"-","") Response.Write ("") Else Response.Write ("
") End If Response.Write ("
") If r("Msn") <> "" Then Response.Write ("") Else Response.Write ("
") End If Response.Write ("
"& i &""& Read_File("inc\Lang\Languages.aspx",449) &"      


") Response.Write ("") Response.Write ("") Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",454) &":
"& Read_File("inc\Lang\Languages.aspx",455) &":
") Response.Write ("


") %>