FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » private messages
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
private messages [message #29312] Mon, 12 December 2005 00:23 Go to next message
Marticus   United States
Messages: 272
Registered: June 2002
Karma: 1
Senior Member
I am lead to believe that there are two individuals on my forum that exchanged some sensitive data that shouldn't have been exchanged. How difficult would it be to parse the private messages file and the database in order to list private messages by date, displaying the names of the users?
Re: private messages [message #29326 is a reply to message #29312] Tue, 13 December 2005 00:07 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Well, it is a relatively easy query to fetch a messages sent by user A to user B within a certain date range.

Basically something a long the lines of:

SELECT * FROM fud_pmsg WHERE ouser_id=SENDER_ID AND duser_id=RECEPIENT_ID AND post_stamp BETWEEN START_DATE END END_DATE;

Then you can use the foff and length param to fetch the message body.


FUDforum Core Developer
Re: private messages [message #29482 is a reply to message #29312] Fri, 23 December 2005 13:28 Go to previous message
Marticus   United States
Messages: 272
Registered: June 2002
Karma: 1
Senior Member
Thank you very much for this information. I wanted to follow-up and let you know that I was able to learn what I needed to ban the people from the forums. Thanks again. I hope I never need to snoop again. I feel so... icky...

[Updated on: Fri, 23 December 2005 13:28]

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Reducing the overall width of the forum.
Next Topic: Threaded View
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 03:23:05 GMT 2024

Total time taken to generate the page: 0.02385 seconds