<%@ 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" %>
<% If Lbl_Confirm.Text = "" Then Dim Nome_Utente = "" sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Utenti WHERE Username = '" + Request.QueryString("Username") + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Nome_Utente = r("Username") End While r.Close() sqlConn.Close() Dim Is_Banned = "No" sqlConn.Open() sqlComm = New SqlCommand("SELECT * FROM Ban WHERE Username_Bannato = '" + Request.QueryString("Username") + "' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Is_Banned = "Si" End While r.Close() sqlConn.Close() If Is_Banned = "No" Then Response.write ("

L'Utente """& Request.QueryString("Username") &""" non è bannato!!!") form1.Visible = false End If If Nome_Utente = "" Then Response.write ("

L'Utente """& Request.QueryString("Username") &""" non esiste!!!") form1.Visible = false End If Lbl_Confirm.Text = "Vuoi togliere il ban all'utente """& Request.QueryString("Username") &""" ?" End If %>

<% If Lbl_Confirm.Text <> "" Then %> <% End If %>