<%
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%>
|
Paese
|
Nome
|
Proprietario
|
Azioni
|
|   |
  |
  |
  |
  |
  |
  |
  |
<%
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 (" | "& i &" | "& Read_File("inc\Lang\Languages.aspx",302) &" |   |   |   |   |   |   | ")
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 (""& 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 (" | ![]() | ")
Response.Write ("![]() | ")
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 (" | ")
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 ("| "& i &" | "& Read_File("inc\Lang\Languages.aspx",302) &" |   |   |   |   |   |   | ")
If Var_Color = "181818" Then
Var_Color = "393839"
Else
Var_Color = "181818"
End If
i = i + 1
End While
%>
Response.Write ("
")
Response.Write ("| "& Read_File("inc\Lang\Languages.aspx",210) &": | | ")
Response.Write ("| "& Read_File("inc\Lang\Languages.aspx",211) &": | | ")
Response.Write (" ")
%>
<%=Read_File("inc\Lang\Languages.aspx",307)%>
|