<%@ 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" %> <%@ Import namespace="System.Text.Encoding" %> <% Dim Type = Request.QueryString("type") Dim Id_Mex_Canc = Request.QueryString("id") Id_Mex_Canc = DeCripta(Id_Mex_Canc) If Type = "cancella" Then sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE ID = '" & Id_Mex_Canc & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If If Type = "cancella_tutti" Then sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE ID_Utente = '" & Id_Mex_Canc & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If %>


Messaggi


<% Dim There_Is_Message = 0 Dim Last_Message = 0 sqlConn.Open() sqlComm = New SqlCommand("SELECT Messaggi.Data, Messaggi.Messaggio, Utenti.Id as Id_Utente, Utenti.Username, Messaggi.Id as ID_Messaggi, Messaggi.Id_Utente FROM Messaggi JOIN Utenti ON Utenti.Id = Messaggi.Id_Utente WHERE Utenti.username = '" + Proprietary + "' ORDER BY Messaggi.ID DESC", sqlConn) r = sqlComm.ExecuteReader() While r.Read() If There_Is_Message = 0 Then %>

"><%=Read_File("inc\Lang\Languages.aspx",60)%>

<% End If There_Is_Message = 1 If Last_Message = 0 Then Last_Message = r("ID_Messaggi") End If %>
 
<%=r("Data")%>

<%=r("Messaggio")%>

">Cancella questo Messaggio

 

 

 
<% End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Last_Id = '"& Last_Message &"' WHERE Username = '" & Proprietary & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() If There_Is_Message = 0 Then %>Non hai nessun Messaggio<% End If %>