%@ 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" %>
<%=Read_File("inc\Lang\Languages.aspx",571)%>
<%
Dim Codice = DeCripta(Request.QueryString("Codice"))
Dim Utente = DeCripta(Request.QueryString("User"))
Dim Confirm = DeCripta(Request.QueryString("Confirm"))
Dim Is_Deleting_Gilda_User
Dim Is_Administrator
Dim Tag_Gilda
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Gilda, Grado_Gilda FROM Utenti WHERE Username = '" & Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Is_Administrator = r("Grado_Gilda")
Tag_Gilda = r("Gilda")
End While
r.Close()
sqlConn.Close()
'CEDI IL POSTO DI AMMINISTRATORE
If Codice = "cedi_administrator" AND Confirm <> "si" Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",572) &"
")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Username FROM Utenti JOIN Gilde ON Utenti.Gilda = Gilde.Tag WHERE Gilda = '" & Tag_Gilda &"' AND Username <> '"& Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Response.Write (""& r("Username") &"
")
End While
r.Close()
sqlConn.Close()
End If
If Codice = "cedi_administrator" AND Confirm = "si" Then
Dim Utente_Admin_Id
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Gilda FROM Utenti WHERE Username = '" & Proprietary &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Tag_Gilda = r("Gilda")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Username = '" & Utente &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Utente_Admin_Id = r("ID")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Grado_Gilda = 1 WHERE Username = '"& Utente &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Grado_Gilda = 2 WHERE Username = '"& Proprietary &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",574) &" "& Proprietary &" "& Read_File("inc\Lang\Languages.aspx",575) &" "& Tag_Gilda &"."
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Utente_Admin_Id
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Gilda"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Response.Write (Utente &""& Read_File("inc\Lang\Languages.aspx",573) &"")
End If
' MODIFICA PERMESSI DEGLI UTENTI
If Codice = "modifica_permessi" AND Confirm <> "Si" Then
Dim Grado_Gilds
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Id, Grado_Gilda, Grado_2, Grado_3, Grado_4, Grado_5 FROM Utenti JOIN Gilde ON Utenti.Gilda = Gilde.Tag WHERE Username = '" & Utente &"'", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
If r("Grado_Gilda") <> 1 Then
Txt_Id_Utente.Text = r("Id")
If r("Grado_Gilda") = 2 Then
Due.Checked = "True"
End If
If r("Grado_Gilda") = 3 Then
Tre.Checked = "True"
End If
If r("Grado_Gilda") = 4 Then
Quattro.Checked = "True"
End If
If r("Grado_Gilda") = 5 Then
Cinque.Checked = "True"
End If
Dim Grado_Gil = "Grado_"& r("Grado_Gilda")
Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",576) &" "& Utente &"
")
End If
If r("Grado_Gilda") = 1 Then
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",577) &""
End If
Grado_Gilds = r("Grado_Gilda")
If Grado_Gilds <> 1 Then
%>
Torna alla Gilda
["& Read_File("inc\Lang\Languages.aspx",580) &"] ["& Read_File("inc\Lang\Languages.aspx",581) &"]"
Is_Deleting_Gilda_User = 1
End If
If Codice = "elimina" AND Confirm = "si" Then
Dim Id_Administrator = 0
Dim Gilda_Utente_Elimina
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Gilda, Id FROM Utenti WHERE Username = '" & Proprietary &"' AND Grado_Gilda = 1 ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Tag_Gilda = r("Gilda")
Id_Administrator = r("ID")
End While
r.Close()
sqlConn.Close()
Dim Nome_Utente_Elimina
Dim Is_Utente_In_Gilda = 0
Dim Is_Utente_Administrator = 0
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Username, Id, Gilda, Grado_Gilda FROM Utenti WHERE ID = '" & Utente &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Nome_Utente_Elimina = r("Username")
Is_Utente_In_Gilda = r("ID")
Is_Utente_Administrator = r("Grado_Gilda")
Gilda_Utente_Elimina = r("Gilda")
End While
r.Close()
sqlConn.Close()
If LCase(Tag_Gilda) <> LCase(Gilda_Utente_Elimina) Then
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",582) &"
Questo utente non si trova nella tua gilda."
End If
If Is_Utente_In_Gilda = 0 Then
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",582) &"
"& Read_File("inc\Lang\Languages.aspx",583) &""
End If
If Is_Utente_Administrator = 1 Then
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",584) &"
"& Read_File("inc\Lang\Languages.aspx",583) &""
End If
If Is_Administrator = 0 Then
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",584) &"
Non sei l'amministratore della tua gilda."
End If
If Is_Utente_In_Gilda <> 0 AND Is_Administrator <> 0 AND Is_Utente_Administrator <> 1 AND LCase(Tag_Gilda) = LCase(Gilda_Utente_Elimina) Then
sqlConn.Open()
Dim sqlComm As New SqlCommand("UPDATE Utenti SET Gilda = '', Grado_Gilda = 0 WHERE ID = '"& Utente &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",585) &""& Tag_Gilda &".
"& Read_File("inc\Lang\Languages.aspx",586) &" " + Proprietary + " "
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = Is_Utente_In_Gilda
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Gilda"
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
Messaggio.Text = "L'Utente "& Nome_Utente_Elimina &" è stato correttamente cancellato dalla Gilda.
"& Read_File("inc\Lang\Languages.aspx",583) &""
End If
End If
' ELIMINA GILDA
If Codice = "elimina_gilda" AND Confirm <> "si" Then
Is_Deleting_Gilda_User = 1
Dim Elimina_Gilda = "Elimina_Gilda"
Dim Si = "Si"
Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",587) &" ["& Read_File("inc\Lang\Languages.aspx",580) &"] ["& Read_File("inc\Lang\Languages.aspx",581) &"]"
End If
If Codice = "elimina_gilda" AND Confirm = "si" Then
Dim Gilda
Dim Id_Administrator
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Gilda, Id FROM Utenti WHERE Username = '"& Proprietary &"' AND Grado_Gilda = 1", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
Gilda = r("Gilda")
Id_Administrator = r("ID")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("SELECT ID FROM Utenti WHERE Gilda = '"& Gilda &"' ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
m_sql = "INSERT INTO Messaggi (Messaggio, Data, Id_Utente, Type_Message, Id_Sender) VALUES (@Messaggio, @Data, @Id_Utente, @Type_Message, @Id_Sender)"
m_conn = New SqlConnection(strConn)
m_cmd = new SqlCommand
m_cmd.connection = m_conn
m_cmd.commandtext = m_sql
m_cmd.Parameters.Add("@Messaggio", sqldbtype.varchar).Value = ""& Read_File("inc\Lang\Languages.aspx",588) &" "& Gilda &" "& Read_File("inc\Lang\Languages.aspx",589) &" "& Proprietary &""
m_cmd.Parameters.Add("@Data", sqldbtype.datetime).Value = Datetime.Now
m_cmd.Parameters.Add("@Id_Utente", sqldbtype.int).Value = r("ID")
m_cmd.Parameters.Add("@Type_Message", sqldbtype.varchar).Value = "Gilda"
m_cmd.Parameters.Add("@Id_Sender", sqldbtype.int).Value = 0
m_conn.Open
m_cmd.ExecuteNonQuery
m_conn.Close
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Gilda = '', Grado_Gilda = 0 WHERE Gilda = '"& Gilda &"' ",sqlConn)
Dim result As Integer = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Gilde WHERE Tag = '"& Gilda &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
Response.Redirect ("gilda.aspx")
End If
%>
<%
If Len(Codice) < 2 Then
If Is_Administrator <> 1 AND Is_Administrator <> 2 Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",590) &"")
Else
sqlConn.Open()
sqlComm = New SqlCommand("SELECT Utenti.Username, 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()
Tag_Gilda = r("Gilda")
If Trim(r("Gilda")) <> "" Then
Txt_Gilda_Grado1.Text = r("Grado_1")
Txt_Gilda_Grado2.Text = r("Grado_2")
Txt_Gilda_Grado3.Text = r("Grado_3")
Txt_Gilda_Grado4.Text = r("Grado_4")
Txt_Gilda_Grado5.Text = r("Grado_5")
Dim Testo_Messaggio = Replace(Txt_Gilda_Descrizione.Text,VbCrLf,"
")
Testo_Messaggio = Replace(Testo_Messaggio,"'","''")
Txt_Gilda_Descrizione.Text = Replace(r("Descrizione"),"
",VbCrLf)
Txt_Gilda_Descrizione.Text = Replace(Txt_Gilda_Descrizione.Text,"''","'")
Response.Write ("Nome Gilda: "& Replace(r("Nome_Gilda"),"''","'") &"
")
Response.Write ("Tag Gilda: "& r("Tag") &"")
Response.Write ("
------------------------------------------------
")
Txt_Gilda_Descrizione.CssClass = "textbox"
%>
<%=Read_File("inc\Lang\Languages.aspx",541)%>:
<%=Read_File("inc\Lang\Languages.aspx",537)%>:
<%=Read_File("inc\Lang\Languages.aspx",538)%>:
<%=Read_File("inc\Lang\Languages.aspx",539)%>:
<%=Read_File("inc\Lang\Languages.aspx",540)%>:
------------------------------------------------
Logo della Gilda
------------------------------------------------
<%=Read_File("inc\Lang\Languages.aspx",591)%>:
<%
End If
If Trim(r("Gilda")) = "" Then
Response.Write (""& Read_File("inc\Lang\Languages.aspx",592) &":
"& Read_File("inc\Lang\Languages.aspx",593) &"")
End If
End While
r.Close()
sqlConn.Close()
Btn_Salva_Gilda.Text = Read_File("inc\Lang\Languages.aspx",594)
%>
------------------------------------------------
<%
If Is_Administrator = 1
Response.Write (""& Read_File("inc\Lang\Languages.aspx",595) &"")
End If
Response.Write ("
------------------------------------------------
"& Read_File("inc\Lang\Languages.aspx",596) &":