Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Weird Feeling their are private message Spammers on the forum, How to find them
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
0
Comments
generally, private messages are private if you think its illegal. you could look in the inboxes.
@mbforums said:
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).
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
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 ..
You best defense is your members, ask them to report this stuff.
Manpower wins every time.
grep is your friend.