<%
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 &"
"& Read_File("inc\Lang\Languages.aspx",449) &"
 
 
 
 
 
 
")
i = i + 1
End While
i = i + 1
Response.Write ("
"& 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 ("
")
Response.Write ("
")
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 ("
")
End While
r.Close()
sqlConn.Close()
While i <> 51
Response.Write ("