<%@ 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 %> <%=r("Grado_2")%>
<%=r("Grado_3")%>
<%=r("Grado_4")%>
<%=r("Grado_5")%>


Torna alla Gilda

<% End If End While r.Close() sqlConn.Close() End If ' ELIMINA UTENTE If Codice = "elimina" AND Confirm <> "si" Then Dim Nome_Utente_Elimina sqlConn.Open() sqlComm = New SqlCommand("SELECT Username FROM Utenti WHERE Id = '"& Utente &"' ", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Nome_Utente_Elimina = r("Username") End While r.Close() sqlConn.Close() Dim Elimina = "elimina" Dim Si = "Si" Messaggio.Text = ""& Read_File("inc\Lang\Languages.aspx",578) &" "& Nome_Utente_Elimina &" "& Read_File("inc\Lang\Languages.aspx",579) &"

["& 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) &":

") sqlConn.Open() sqlComm = New SqlCommand("SELECT Grado_Gilda, Grado_1, Grado_2, Grado_3, Grado_4, Grado_5, Username, Utenti.ID as Id_Utente FROM Utenti JOIN Gilde ON Utenti.Gilda = Gilde.Tag WHERE Gilda = '" & Tag_Gilda &"' ORDER BY GRADO_GILDA", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Dim Grado_Gild = "Grado_"& R("Grado_Gilda") Response.Write ("") End While r.Close() sqlConn.Close() Response.Write ("
"& r("Username") &""& r(Grado_Gild) &"
") End If End If %>