<%@ 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) &"



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

"& Replace(r("Descrizione"),"''","'") &"

") 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) &"") End If If r("Grado_Gilda") = 2 Then Response.Write ("


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

"& Read_File("inc\Lang\Languages.aspx",571) &"") End If If r("Grado_Gilda") <> 1 Then Response.Write ("


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

"& Read_File("inc\Lang\Languages.aspx",610) &"") 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) &":

") 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 ("
"& Read_File("inc\Lang\Languages.aspx",436) &""& Read_File("inc\Lang\Languages.aspx",437) &""& Read_File("inc\Lang\Languages.aspx",21) &"IcqMsn

"& r("Username") &""& r(Gilda_GR) &""& Read_File("inc\Lang\Languages.aspx",439) &"") 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 ("
") End If End If %>