Article: How To Clean Up A Spammed Forum

Discussion in 'Managing Your Online Community' started by BamaStangGuy, Nov 19, 2011.

  1. BamaStangGuy

    BamaStangGuy Administrator

    Joined:
    Jun 23, 2009
    Messages:
    769
    Likes Received:
    549
    Location:
    Huntsville, AL
    Big Dan, cpvr and Brandon like this.
  2. cpvr

    cpvr Regular Member

    Joined:
    Aug 14, 2009
    Messages:
    3,219
    Likes Received:
    823
    Excellent article man!
     
  3. BamaStangGuy

    BamaStangGuy Administrator

    Joined:
    Jun 23, 2009
    Messages:
    769
    Likes Received:
    549
    Location:
    Huntsville, AL
    Updated it with a query to find all posts with a link in them, sorted by latest post.

    PHP:
    SELECT FROM post WHERE pagetext LIKE '[URL=%' ORDER BY dateline DESC
     
  4. BamaStangGuy

    BamaStangGuy Administrator

    Joined:
    Jun 23, 2009
    Messages:
    769
    Likes Received:
    549
    Location:
    Huntsville, AL
    Can't edit my post. The above query should be:

    PHP:
    SELECT FROM post WHERE pagetext LIKE '[/url]' ORDER BY dateline DESC
     
  5. Brandon

    Brandon Regular Member

    Joined:
    Jun 1, 2009
    Messages:
    6,602
    Likes Received:
    1,706
    Location:
    Topeka, Kansas
    First Name:
    Brandon
    You should add some social media icons to help share the article :)
    you'll be able to once promoted to the next usergroup, I think it's 25 post ATM and some likes
     
  6. BamaStangGuy

    BamaStangGuy Administrator

    Joined:
    Jun 23, 2009
    Messages:
    769
    Likes Received:
    549
    Location:
    Huntsville, AL
    Updated the blog with a script you can run to collect all links on your forum. It will print the domains so that you can paste them into vBSEO's nofollow blacklist.
     
    Brandon likes this.
  7. BamaStangGuy

    BamaStangGuy Administrator

    Joined:
    Jun 23, 2009
    Messages:
    769
    Likes Received:
    549
    Location:
    Huntsville, AL
    What other social media icons do I need?
     
  8. cpvr

    cpvr Regular Member

    Joined:
    Aug 14, 2009
    Messages:
    3,219
    Likes Received:
    823
    I'm not @Brandon but I'd say you should add "Like this" for facebook and "Tweet this" for twitter. Never know, you might get some free promotion from people who think you did a great job on the article.:D
     
    Brandon likes this.
  9. Brandon

    Brandon Regular Member

    Joined:
    Jun 1, 2009
    Messages:
    6,602
    Likes Received:
    1,706
    Location:
    Topeka, Kansas
    First Name:
    Brandon
    yup ^
    I don't see any social media buttons on the blog, so anything really :)
    Maybe as simple as an addthis badge so you have a few to chose from yet not clutter up the place.
     

Share This Page