Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Jun 2002
Posts: 47
User
User
Offline
Joined: Jun 2002
Posts: 47
At some point in every admins life, there comes a time when you have a few specific users who like to cause problems.

In order to be just in my removal of these users I like to have proof of thier touble making in case there is any questions regarding their removal. How can I have it so that I (as an admin) get a copy of every private message they send. Or if it is easier to get a copy of every private message sent on the board. Or if this is even possible.

Thank you

Sponsored Links
Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 1,068
This should do it for you, go to your Admin panel and run these queries one at a time, where M_Sender and M_Uid is where you will put the user number.


This will show the messages that the usernumber sent:

SELECT *
FROM w3t_Messages
WHERE M_Sender ='2'

This will show what messages that usernumber has received:

SELECT *
FROM w3t_Messages
WHERE M_Uid ='2'

Joined: May 2003
Posts: 115
Journeyman
Journeyman
Offline
Joined: May 2003
Posts: 115
Thats handy... cheers!

Joined: Jun 2002
Posts: 47
User
User
Offline
Joined: Jun 2002
Posts: 47
This is quite helpful but not exactly what I was looking for.. or it still needs to be modified as I would prefer to see who the message is from (the username) instead of seeing a user number which I then have to try and refernce to a name. Also I need to see the date the message was sent.

I would really love to just received all the PMs the user sends out in my email or my PM box. The SQL query works but does not give me the info I need.

If there is anyway to modify the SQL query or some other script to accomplish that, it would be appricaited.

Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 1,068
Well, that sort of takes the "private" out of it That table only has the user number, what you are asking is a bit more involved. Maybe if you post this request in the developer for hire forum someone will be able to help.

Sponsored Links
Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
There's no magic command to do that, you'd need to modify some scripts which is a bit more than a quick "how do I". I've done this for a couple of clients before, having PMs BCCed to the admins.

If you're not familiar with the scripts - then the dev for hire forum or our Services Page will get it written up fairly quickly for you.

Basically you'd need to modify the two scripts which send PMs to your email or PM box. You'd also need to cleanup the output a bit, so you had names instead of numbers.

Joined: Feb 2002
Posts: 295
Member
Member
Offline
Joined: Feb 2002
Posts: 295
Hi,

While I can understand the frustration some of these guys can cause, isn't this an invasion of privacy?

I mean I would have to answer to my members if they ever found out I was reading their private messages. It might very well result in having to shut down the site as people would see this as a serious breach of confidence.

Up to you, but I would be *very* cautious with this.

Sanuk!

Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 1,068
I have to agree with you on this, I do expect that any site I visit can track everything I say though just to be safe. There is an option not to allow PM's also if an admin is that concerned about it. Even though I would never personally go through my users PM's it is awfully accessible.

Joined: Nov 2001
Posts: 10,369
I type Like navaho
I type Like navaho
Joined: Nov 2001
Posts: 10,369
Yes, it could really cause a large scale revolt or loss of trust..... so use cautiously.


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
AllenAyres
AllenAyres
Texas
Posts: 21,079
Joined: March 2000
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)