| private messages [message #29312] |
Mon, 12 December 2005 00:23  |
Marticus
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  |
Ilia
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 |
Marticus
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 |
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]