%@ Page Language="vb" Debug="true" ValidateRequest="false" %>
<% @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" %>
<%
Dim Codice = DeCripta(Request.QueryString ("Codice"))
Dim Confirm = DeCripta(Request.QueryString ("Confirm"))
If Codice = "lascia_gilda" AND Confirm <> "si" Then
Form1.Visible = False
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",604) &"
["& Read_File("inc\Lang\Languages.aspx",580) &"] ["& Read_File("inc\Lang\Languages.aspx",581) &"]")
End If
If Codice = "lascia_gilda" AND Confirm = "si" Then
Form1.Visible = False
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Utenti SET Gilda = '', Grado_Gilda = 0 WHERE Username = '" & Proprietary &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",605) &"")
End If
If Codice <> "lascia_gilda" Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",526) &"
")
%>
<%
Dim Grado
Dim TG_Gilda = ""
Dim TG_Grado = ""
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Username, Utenti.Fama, Utenti.Gilda, Utenti.Grado_Gilda, Gilde.Nome as Nome_Gilda, Gilde.Tag, Gilde.Descrizione, Gilde.Grado_1, Gilde.Grado_2, Gilde.Grado_3, Gilde.Grado_4, Gilde.Grado_5 FROM Utenti LEFT JOIN Gilde ON Utenti.Gilda = Gilde.Tag WHERE Username = '" & Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If Trim(r("Gilda")) <> "" Then
Response.Write (""& Replace(r("Nome_Gilda"),"''","'") &" ["& Trim(r("Tag")) &"]
")
Dim Grado_Gilda_Tot = "Grado_" & r("Grado_Gilda")
Response.Write ("Grado: "& r(Grado_Gilda_Tot) &"")
Response.Write ("
------------------------------------------------
")
Response.Write (""& Read_File("inc\Lang\Languages.aspx",591) &":
"& Replace(r("Descrizione"),"''","'") &"")
Response.Write ("
------------------------------------------------
")
Grado = r("Grado_Gilda")
If r("Grado_Gilda") = 1 Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",606) &":
"& Read_File("inc\Lang\Languages.aspx",571) &"
"& Read_File("inc\Lang\Languages.aspx",609) &"")
Response.Write ("
------------------------------------------------
")
End If
If r("Grado_Gilda") = 2 Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",607) &":
"& Read_File("inc\Lang\Languages.aspx",571) &"")
Response.Write ("
------------------------------------------------
")
End If
If r("Grado_Gilda") <> 1 Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",608) &":
"& Read_File("inc\Lang\Languages.aspx",610) &"")
Response.Write ("
------------------------------------------------
")
End If
End If
If Trim(r("Gilda")) = "" Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",611) &"
")
If (r("Fama")) > 149 OR r("Username") = "valvonauta_84" Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",593) &"
")
End If
If (r("Fama")) < 150 Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",612) &"")
End If
End If
TG_Gilda = r("Gilda")
TG_Grado = r("Grado_Gilda")
End While
r.Close()
sqlConn.Close()
If Grado < 3 AND Grado <> 0 Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",434) &"")
Btn_Invia_Messaggio_Gilda.Text = Read_File("inc\Lang\Languages.aspx",613)
Txt_Messaggio_Gilda.CssClass = "textbox"
%>
------------------------------------------------
")
End If
If TG_Gilda <> "" AND Tg_Grado <> 0 Then
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",435) &":
")
End If
End If
%>
"& Read_File("inc\Lang\Languages.aspx",436) &" "& Read_File("inc\Lang\Languages.aspx",437) &" "& Read_File("inc\Lang\Languages.aspx",21) &" Icq Msn ")
Dim counter = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Id as Id_Utente, Utenti.Username, Utenti.Gilda, Utenti.Grado_Gilda, Utenti.Icq_Uin, Utenti.Msn, Pianeti.Nome, Pianeti.Dimensione, Pianeti.Reame, Pianeti.Paese, Pianeti.Proprietary, Pianeti.Is_Principal, Gilde.Tag, Gilde.Grado_1, Gilde.Grado_2, Gilde.Grado_3, Gilde.Grado_4, Gilde.Grado_5 FROM Utenti JOIN Pianeti ON Utenti.Username = Pianeti.Proprietary AND Pianeti.Is_Principal = 1 JOIN Gilde ON TAG = '" & TG_Gilda &"' WHERE Gilda = '" & TG_Gilda &"' ORDER BY Grado_Gilda", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Counter = Counter + 1
Response.Write ("")
Dim Gilda_GR = "Grado_" + CStr(r("Grado_Gilda"))
Response.Write (" ")
End While
r.Close()
sqlConn.Close()
Response.Write (""& r("Username") &" "& r(Gilda_GR) &" 
")
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 ("