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

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

<% Dim Item Dim Arr_Mex(50) Dim Stringa = " WHERE " i = 0 For Each Item In Request.Form i = i + 1 If i > 1 AND i <> Request.Form.Count Then Stringa = Stringa + "ID = "& Item &" OR " End If Next Stringa = Mid(Stringa,1,Len(Stringa)-4) If Request.Form.Count > 2 Then sqlConn.Open() sqlComm = New SqlCommand("DELETE FROM Messaggi"& Stringa &"",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() End If Response.Write ("") Dim There_Is_Message = 0 Dim Last_Message = 0 Dim Id_Utente_Mex Dim Page = Request.QueryString("Page") If Page = "" Then Page = 0 End If Dim Last_Id Dim Last_Id_Page Dim counter Dim Last_Id_Tot Dim First_Line = 0 Response.Write ("") sqlConn.Open() sqlComm = New SqlCommand("SELECT Messaggi.ID as Id_Messaggio, Utenti.Id as Id_Utente FROM Messaggi JOIN Utenti ON Messaggi.Id_Utente = Utenti.Id WHERE Utenti.Username = '"& Proprietary &"' ORDER BY Messaggi.ID DESC", sqlConn) r = sqlComm.ExecuteReader() While r.Read() Last_Id = r("Id_Messaggio") Id_Utente_Mex = r("Id_Utente") If First_Line = 0 Then Last_Id_Tot = r("Id_Messaggio") First_Line = 1 End If End While r.Close() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("UPDATE Utenti SET Last_Id = '"& Last_Id_Tot &"' WHERE Username = '" & Proprietary & "' ",sqlConn) result = sqlComm.ExecuteNonQuery() sqlConn.Close() sqlConn.Open() sqlComm = New SqlCommand("SELECT TOP 100 Messaggi.ID, Messaggi.Type_Message, Messaggi.Id_Sender, Messaggi.Data, Messaggi.Messaggio, Utenti.Id as Id_Utente, Utenti.Username, Messaggi.Id as ID_Messaggi, Messaggi.Id_Utente FROM Messaggi LEFT JOIN Utenti ON Utenti.Id = Messaggi.Id_Sender WHERE Messaggi.Id_Utente = '"& Id_Utente_Mex &"' AND Messaggi.ID NOT IN (SELECT TOP "& Page &" ID FROM Messaggi WHERE Messaggi.Id_Utente = '"& Id_Utente_Mex &"' ORDER BY Messaggi.ID DESC) ORDER BY Messaggi.ID DESC", sqlConn) r = sqlComm.ExecuteReader() While r.Read() counter = counter + 1 Last_Id_Page = r("ID") If There_Is_Message = 0 Then Response.Write ("

"& Read_File("inc\Lang\Languages.aspx",630) &"

") End If There_Is_Message = 1 If Last_Message = 0 Then Last_Message = r("ID_Messaggi") End If Dim Messaggio_Tot Dim Messaggio = r("Messaggio") Messaggio = Replace(Messaggio,"[QUOTE]","

--------------------------
") Messaggio = Replace(Messaggio,"[/QUOTE]","
--------------------------

") If r("Type_Message") = "Utente" Then Messaggio_Tot = "Messaggio da " Messaggio = Messaggio_Tot + "" + r("Username") + "
" + Messaggio End If Response.Write ("

") Response.Write ("") End While r.Close() sqlConn.Close() If There_Is_Message <> 0 Then Response.Write ("") End If If Page <> 0 Then 'Response.Write (""& Read_File("inc\Lang\Languages.aspx",633) &"") End If If Page <> 0 AND Last_Id <> Last_Id_Page Then 'Response.Write (" - ") End If If Last_Id <> Last_Id_Page Then 'Response.Write (""& Read_File("inc\Lang\Languages.aspx",634) &"") End If Response.Write ("

") Response.Write (r("Data")) Response.Write ("

") Response.Write ("") Response.Write (Messaggio) Response.Write ("
"& Read_File("inc\Lang\Languages.aspx",632) &"

") If There_Is_Message = 0 Then Response.Write (""& Read_File("inc\Lang\Languages.aspx",635) &"") End If %>