%@ 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" %>
<%
Dim Last_Id = 0
Dim Last_Id_Tot = 0
Dim counter = 0
Dim Type_Message = Request.QueryString("Type_Message")
Response.Write ("
Messaggi
")
Response.Write ("
")
sqlConn.Open()
sqlComm = New SqlCommand("SELECT TOP 100 Messaggi.Id, Type_Message, Data_Messaggio, Messaggio FROM Messaggi WHERE Messaggi.Id_Utente = '"& Id_This_User &"' ORDER BY Data_Messaggio DESC ", sqlConn)
r = sqlComm.ExecuteReader()
While r.Read()
counter = counter + 1
If counter = 1 Then
Last_Id_Tot = (r("Id"))
End If
Last_Id = (r("Id"))
Response.Write ("![]() | ")
Response.Write (r("Data_Messaggio"))
Response.Write (" |
| ")
Response.Write ("")
Response.Write (r("Messaggio"))
Response.Write (" |
")
Response.Write ("
|
")
End While
r.Close()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("DELETE FROM Messaggi WHERE ID < '"& Last_Id &"' AND Id_Utente = '"& Id_This_User &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
sqlConn.Open()
sqlComm = New SqlCommand("UPDATE Utenti SET Last_Id = " & Last_Id_Tot & " WHERE Id = '"& Id_This_User &"' ",sqlConn)
result = sqlComm.ExecuteNonQuery()
sqlConn.Close()
%>