Is there not an option to prune blog posts?
How To Prune Blog Posts?
Collapse
X
-
-
-
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
-
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'
Make sure to replace "yourdatabasename" with the name of your database, and "yourprefix" with your configured table-prefix, if any.
Dustinhttp://quikmsg.net/strtoupper/ - Convert lowercase text and code to all uppercase!
http://quikmsg.net/strtolower/ - Convert uppercase text and code to all lowercase!Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment