Spammers now post visitor messages that are not searchable

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • taylorpiano
    Member
    • Nov 2009
    • 64
    • 3.8.x

    Spammers now post visitor messages that are not searchable

    I just discovered that some of the new users I approved this year that looked legit, are now posting spammer messages with links to their products on the visitor messages of users profiles.
    There is no way for me to search how many visitor messages that spammer posted. I can only search if they posted messages in forums, which in this case, this user did not because they knew they would be detected immediately.
    How can I easily find these messages?
    The ones I stumbled on recently all have links to their products with codes that obviously mean they are making money on the clicks alone.
  • Lats
    Senior Member
    • Mar 2002
    • 3671

    #2
    Try this query in phpmyadmin where you can delete selected entries easily...
    Code:
    SELECT 
        postuserid,
        postusername,
        pagetext 
    FROM 
        visitormessage 
    WHERE 
        pagetext like '%[URL%'
    Lats...

    Comment

    Related Topics

    Collapse

    Working...