How To Prune Blog Posts?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • ZoDesigns.com
    Senior Member
    • Nov 2005
    • 272
    • 3.5.x

    [Blog] How To Prune Blog Posts?

    Is there not an option to prune blog posts?
  • Zachery
    Former vBulletin Support
    • Jul 2002
    • 59097

    #2
    No, I believe your best option is inline moderation.

    Comment


    • Muhammad Rahman
      Muhammad Rahman commented
      Editing a comment
      try comment system on vB5 ,, thanks
  • brycethomason
    New Member
    • Apr 2012
    • 5

    #3
    We need a way to prune blog entries. We have hundreds of spam blog entries and Im having to manually delete them one by one in the admin (a multi-step process). I can't use in-line modication because of the notorious Fatal error: is_member_of_blog(): $bloginfo['permissions'] not defined. in [path]/includes/blog_functions_shared.php on line 275 error. Since the page is fatal error, inline mod is impossible.

    Comment

    • pds
      Member
      • Jan 2003
      • 85
      • 3.8.x

      #4
      I have hte same issue. Spammer got in and created 5000 blog posts. I need to delete them. Would be nice to have a way to prune blogs like you prune threads.
      Paul

      "Whoever believes in Telekinesis, raise my hand."

      Comment

      • Dustin L.
        Senior Member
        • Mar 2011
        • 639
        • 4.2.X

        #5
        I copied the following from a quick-tip I submitted that hasn't been accepted/declined yet. Until pruning features are added to the blog (not sure if they will be), you can use this query or similar to remove blog-posts from the database.

        What criteria would you like to prune by? Maybe I can work up a query that you can just copy and paste instead of playing around with what's below.

        I used the following SQL query to remove all blog-posts by a spammer who had registered while I was asleep and created 380 blog-posts.

        As always, back-up your database before running this.

        Code:
        DELETE FROM `yourdatabasename`.`yourprefix_blog` WHERE `yourprefix_blog`.`username` = 'nameofuser'
        You should run this in phpMyAdmin, through the MySQL CLI, or your choice of UI for managing MySQL.

        Make sure to replace "yourdatabasename" with the name of your database, and "yourprefix" with your configured table-prefix, if any.


        Dustin
        http://quikmsg.net/strtoupper/ - Convert lowercase text and code to all uppercase!
        http://quikmsg.net/strtolower/ - Convert uppercase text and code to all lowercase!

        Comment

        • Zxen
          New Member
          • Feb 2010
          • 1
          • 4.0.0

          #6
          Wow, what an awful interface this whole software has. Anyway, I have thousands of spam blogs I need to prune. Can you please tell me how to delete all blogs EXCEPT the ones made by admin?

          Comment

          widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
          Working...