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

Comments

• Options

  peregrine MVP

  April 2014 edited April 2014

  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).

  I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.

  5
• Options

  mbforums ✭

  April 2014

  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 ..

  1
• Options

  x00 MVP

  April 2014

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

  Manpower wins every time.

  grep is your friend.

  3