Weird Feeling their are private message Spammers on the forum, How to find them

mbforums

HI, I have a weird feeling that there is private message spammers on the site.

I see that there are a high number of private messages being sent. How can i monitor them ?

Iam using 2.0.8 version of vanilla.

Regards

peregrine

generally, private messages are private if you think its illegal. you could look in the inboxes.

@mbforums said:

weird feeling ....private message spammers on the site.

one would assume or like to think your users would notify you if they receive spam inbox messages.

or you could look at the body field of Conversation Message thru phpmyadmin. The most recent messages have the highest message id.

the least intrusive and more ethical way would be to see if you see something illegal with first statement.to see messgae without userid

SELECT Body From GDN_ConversationMessage ORDER BY 'DateInserted' desc limit 100

will give you that last 100 messages sent and the body.

---

If you DO see something illegal you can id them via

SELECT Body, InsertUserID From GDN_ConversationMessage ORDER BY 'DateInserted' desc limit 100

will give you that last 100 messages sent userid and the body.

---

or to get the last 3 month's message from current date

SELECT Body, InsertUserID From GDN_ConversationMessage Where 'DateInserted' > DATE_ADD(NOW(), interval -3 month)

however, it is generally frowned upon to look at user messages (privacy and ethics).

mbforums

Thanks mate, thats very helpful. I will try to sneakpeak just to see the health of the forums. Not to spy like the NSA, CIA etc ..

x00

You best defense is your members, ask them to report this stuff.

Manpower wins every time.