Mass delete comments in wordpress? - GoFuckYourself.com

Jack Sparrow · 09-28-2010, 10:29 PM

Is there some plugin (i know theres the phpmyadmin option to figure it out) that lets me delete ALL comments on a wordpress blog with one click?

Jdoughs · 09-28-2010, 10:33 PM

Quote:

Originally Posted by Jack Sparrow

Is there some plugin (i know theres the phpmyadmin option to figure it out) that lets me delete ALL comments on a wordpress blog with one click?

Never saw a plugin for it, but:

Code:

delete from wp_comments where comment_approved = '0'

CunningStunt · 09-28-2010, 10:34 PM

No there isn't and it's fucking ridiculous that WP doesn't have the option to do it built in.

You have to do it via phpmyadmin - it is actually really simple to do: http://www.raymond.cc/blog/archives/...ng-phpmyadmin/

Scotty.T · 09-29-2010, 03:18 AM

Not aware of a plug-in.

I just use the bulk actions option in the comment admin page to delete them.

Does upto 999 at a time.

DVTimes · 09-29-2010, 03:22 AM

just use the built in thing.

though i noticed you now have to pay for the activation code (it used to be free).

Scotty.T · 09-29-2010, 03:29 AM

Quote:

Originally Posted by DVTimes

just use the built in thing.

though i noticed you now have to pay for the activation code (it used to be free).

activation code? where?

CaptainWolfy · 09-29-2010, 03:44 AM

spam karma will do the trick sending all spam comment's away

fris · 09-29-2010, 04:03 AM

or

DELETE FROM wp_comments WHERE comment_approved = ‘spam’

if you just wanna delete spammed comments.

DVTimes · 09-29-2010, 04:09 AM

Quote:

Originally Posted by Scotty.T

activation code? where?

Akismet

http://akismet.com/

http://en.support.wordpress.com/api-keys/

fris · 09-29-2010, 05:08 AM

this will delete all spam, unapproved, and approved comments.

http://jet.li/delete-comments.zip

let me know if this suits you

Fbomb - BANNED FOR LIFE · 09-29-2010, 05:53 AM

Ask eastwood or marco. They should know.

MrBottomTooth · 09-29-2010, 06:22 AM

Ya, if you haven't activated Askimet yet, do it. I am surprised how well it works. Has basically eliminated 100% of the spam comments I used to get.

HomerSimpson · 09-29-2010, 06:36 AM

Quote:

Originally Posted by DVTimes

Akismet

http://akismet.com/

http://en.support.wordpress.com/api-keys/

fris · 09-29-2010, 12:42 PM

The plugin I posted deletes all comments,made it thi morning

Doug E · 09-29-2010, 01:08 PM

There is an option to show more posts per page so you can select all and delete them at once. Just click on screen options and adjust the `show on screen`figure to 10,000 or however many to cover all the spam u got and delete them all at once. I only just discovered it myself. Was a nightmare before that.

georgeyw · 10-12-2010, 07:27 PM

Got the shits with an install this morning so made a *basic* solution for it :

Creates menu tab called 'Delete' - > it will delete ALL of your UNAPPROVED comments with one click.

Any problems with it - suck my nuts

Copy the code here - create a php file called 'deletecomments.php' upload to plugin folder.

PHP Code:


			
<?php
/*
Plugin Name: Delete Comments
Plugin URI: [email protected]
Description: Deletes ALL comments from a wordpress install.
Version:  1.0
Author: Georgeyw
Author URI: [email protected]
License: GPL1
*/

/*  Copyright 2010  Georgeyw  (email : [email protected])

    This program is free software; you can redistribute it and/or modify
    it under the terms of the GNU General Public License, version 2, as 
    published by the Free Software Foundation.

    This program is distributed in the hope that it will be useful,
    but WITHOUT ANY WARRANTY; without even the implied warranty of
    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    GNU General Public License for more details.

    You should have received a copy of the GNU General Public License
    along with this program; if not, write to the Free Software
    Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA
*/

add_action('admin_menu', 'delete_comments_plugin_menu');

function delete_comments_plugin_menu() {
  add_menu_page( "Delete Comments", "Delete", 10, "delete_comments_menu", "delete_comments_main", '',20 );
}

function delete_comments_main() {

  if (!current_user_can('manage_options'))  {
    wp_die( __('You do not have sufficient permissions to access this page.') );
  }
  if($_POST['delete_hidden'] == 'Y')
  {
    echo func_delete_comments();  
  }
  echo '<div class="wrap">';
  echo '<div id="icon-index" class="icon32"><br /></div><h2>Delete Wordpress Comments</h2>';
  echo '<p><strong>WARNING :</strong> Clicking on the button below will delete ALL comments from your Wordpress install.</p>';
  echo '<p><form method="post" action="'. str_replace( "%7E", "~", $_SERVER["REQUEST_URI"]).'" >
<input type="submit" name="Delete" value="Delete">
<input type="hidden" name="delete_hidden" value="Y"> </form></p>';
  echo '</div>';

}

function func_delete_comments()
{
    global $wpdb;
    if(isset($_POST['Delete']))
    {
        // delete unapproved comments from db
        $wpdb->query("DELETE FROM wp_comments WHERE comment_approved = '0'");
        $success = '<div id="message" class="updated fade">Successfully <b>DELETED</b> ALL Comments.</b></div>';
    }
    return $success;
}
?>

Intrinsic · 10-12-2010, 07:42 PM

Quote:

Originally Posted by georgeyw

Got the shits with an install this morning so made a *basic* solution for it :

Creates menu tab called 'Delete' - > it will delete ALL of your UNAPPROVED comments with one click.

Any problems with it - suck my nuts

Copy the code here - create a php file called 'deletecomments.php' upload to plugin folder.

PHP Code:


			
<?php

/*

Plugin Name: Delete Comments

Plugin URI: [email protected]

Description: Deletes ALL comments from a wordpress install.

Version:  1.0

Author: Georgeyw

Author URI: [email protected]

License: GPL1

*/



/*  Copyright 2010  Georgeyw  (email : [email protected])



    This program is free software; you can redistribute it and/or modify

    it under the terms of the GNU General Public License, version 2, as 

    published by the Free Software Foundation.



    This program is distributed in the hope that it will be useful,

    but WITHOUT ANY WARRANTY; without even the implied warranty of

    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

    GNU General Public License for more details.



    You should have received a copy of the GNU General Public License

    along with this program; if not, write to the Free Software

    Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA  02110-1301  USA

*/



add_action('admin_menu', 'delete_comments_plugin_menu');



function delete_comments_plugin_menu() {

  add_menu_page( "Delete Comments", "Delete", 10, "delete_comments_menu", "delete_comments_main", '',20 );

}



function delete_comments_main() {



  if (!current_user_can('manage_options'))  {

    wp_die( __('You do not have sufficient permissions to access this page.') );

  }

  if($_POST['delete_hidden'] == 'Y')

  {

    echo func_delete_comments();  

  }

  echo '<div class="wrap">';

  echo '<div id="icon-index" class="icon32"><br /></div><h2>Delete Wordpress Comments</h2>';

  echo '<p><strong>WARNING :</strong> Clicking on the button below will delete ALL comments from your Wordpress install.</p>';

  echo '<p><form method="post" action="'. str_replace( "%7E", "~", $_SERVER["REQUEST_URI"]).'" >

<input type="submit" name="Delete" value="Delete">

<input type="hidden" name="delete_hidden" value="Y"> </form></p>';

  echo '</div>';



}



function func_delete_comments()

{

    global $wpdb;

    if(isset($_POST['Delete']))

    {

        // delete unapproved comments from db

        $wpdb->query("DELETE FROM wp_comments WHERE comment_approved = '0'");

        $success = '<div id="message" class="updated fade">Successfully <b>DELETED</b> ALL Comments.</b></div>';

    }

    return $success;

}

?>

sweet!! i'd rep you if i could, could someone do it for me? :p

fris · 10-12-2010, 08:07 PM

mine deletes every comment on your site, approved, or unapproved, thats how the OP wanted it, but mine has a check where you have to copy and paste a line of text, just to make sure you dont do anything by accident.

http://jet.li/delete-comments.zip

georgeyw · 10-12-2010, 08:18 PM

Quote:

Originally Posted by fris

mine deletes every comment on your site, approved, or unapproved, thats how the OP wanted it, but mine has a check where you have to copy and paste a line of text, just to make sure you dont do anything by accident.

http://jet.li/delete-comments.zip

Would you like a medal?

I made a basic plugin to suit my own *PERSONAL* needs and thought i'd do a quick search on gfy and post it as a reply to a topic and guess what, this was the first topic I found so I posted it.

fris · 10-12-2010, 08:24 PM

Quote:

Originally Posted by georgeyw

Would you like a medal?

I made a basic plugin to suit my own *PERSONAL* needs and thought i'd do a quick search on gfy and post it as a reply to a topic and guess what, this was the first topic I found so I posted it.

woah, settle down, no need to get all pissy.

georgeyw · 10-12-2010, 08:34 PM

Quote:

Originally Posted by fris

woah, settle down, no need to get all pissy.

Pot Kettle - read :

Quote:

mine deletes every comment on your site, approved, or unapproved, thats how the OP wanted it, but mine has a check where you have to copy and paste a line of text, just to make sure you dont do anything by accident.

Intrinsic · 10-12-2010, 08:38 PM

Quote:

Originally Posted by fris

mine deletes every comment on your site, approved, or unapproved, thats how the OP wanted it, but mine has a check where you have to copy and paste a line of text, just to make sure you dont do anything by accident.

http://jet.li/delete-comments.zip

chrismccoy your link didn't work at the time that i tried georgeyw's so :321gfy

tonyparra · 10-12-2010, 08:40 PM

there is a delete all pending comments plugin + use that witht the bad behavior plugin that shuts down spammers before they connect with your site + wp spam free for ultra protect

bad behavior is awesome on its on though

fris · 10-12-2010, 08:44 PM

Quote:

Originally Posted by Intrinsic

chrismccoy your link didn't work at the time that i tried georgeyw's so :321gfy

you know everyone knows my real name, so it doesnt really bother me.

09-28-2010, 10:29 PM	#1
Jack Sparrow Almost goners.. Industry Role: Join Date: May 2008 Location: Netherlands Posts: 11,420	Mass delete comments in wordpress? Is there some plugin (i know theres the phpmyadmin option to figure it out) that lets me delete ALL comments on a wordpress blog with one click?

09-29-2010, 03:18 AM	#4
Scotty.T Confirmed User Join Date: Nov 2004 Location: Scotland Posts: 1,062	Not aware of a plug-in. I just use the bulk actions option in the comment admin page to delete them. Does upto 999 at a time. __________________ .

09-29-2010, 03:22 AM	#5
DVTimes xxx Industry Role: Join Date: Jun 2003 Location: UK Posts: 31,544	just use the built in thing. though i noticed you now have to pay for the activation code (it used to be free). __________________ The Affiliate Program

09-29-2010, 04:03 AM	#8
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,242	or DELETE FROM wp_comments WHERE comment_approved = ‘spam’ if you just wanna delete spammed comments. __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

09-29-2010, 05:08 AM	#10
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,242	this will delete all spam, unapproved, and approved comments. http://jet.li/delete-comments.zip let me know if this suits you __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

09-28-2010, 10:34 PM	#3
CunningStunt Confirmed User Industry Role: Join Date: Aug 2006 Posts: 5,594	No there isn't and it's fucking ridiculous that WP doesn't have the option to do it built in. You have to do it via phpmyadmin - it is actually really simple to do: http://www.raymond.cc/blog/archives/...ng-phpmyadmin/

09-29-2010, 03:44 AM	#7
CaptainWolfy Playa Industry Role: Join Date: Dec 2005 Location: Somewhere on the Earth Posts: 8,439	spam karma will do the trick sending all spam comment's away

09-29-2010, 05:53 AM	#11
Fbomb - BANNED FOR LIFE So Fucking Banned Join Date: May 2010 Location: Mexifornia Posts: 970	Ask eastwood or marco. They should know.

09-29-2010, 06:22 AM	#12
MrBottomTooth Confirmed User Join Date: Sep 2009 Posts: 5,795	Ya, if you haven't activated Askimet yet, do it. I am surprised how well it works. Has basically eliminated 100% of the spam comments I used to get. __________________ Get Paid Per Email Like The WEGCASH Days!!!!

09-29-2010, 12:42 PM	#14
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,242	The plugin I posted deletes all comments,made it thi morning __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

09-29-2010, 01:08 PM	#15
Doug E Confirmed User Join Date: Sep 2005 Posts: 511	There is an option to show more posts per page so you can select all and delete them at once. Just click on screen options and adjust the `show on screen`figure to 10,000 or however many to cover all the spam u got and delete them all at once. I only just discovered it myself. Was a nightmare before that.

10-12-2010, 07:27 PM	#16
georgeyw 58008 53773 Industry Role: Join Date: Jul 2005 Location: Australia Posts: 9,864	Got the shits with an install this morning so made a basic solution for it : Creates menu tab called 'Delete' - > it will delete ALL of your UNAPPROVED comments with one click. Any problems with it - suck my nuts Copy the code here - create a php file called 'deletecomments.php' upload to plugin folder. PHP Code: <?php /* Plugin Name: Delete Comments Plugin URI: [email protected] Description: Deletes ALL comments from a wordpress install. Version: 1.0 Author: Georgeyw Author URI: [email protected] License: GPL1 / / Copyright 2010 Georgeyw (email : [email protected]) This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License, version 2, as published by the Free Software Foundation. This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details. You should have received a copy of the GNU General Public License along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA */ add_action('admin_menu', 'delete_comments_plugin_menu'); function delete_comments_plugin_menu() { add_menu_page( "Delete Comments", "Delete", 10, "delete_comments_menu", "delete_comments_main", '',20 ); } function delete_comments_main() { if (!current_user_can('manage_options')) { wp_die( __('You do not have sufficient permissions to access this page.') ); } if($_POST['delete_hidden'] == 'Y') { echo func_delete_comments(); } echo '<div class="wrap">'; echo '<div id="icon-index" class="icon32"><br /></div><h2>Delete Wordpress Comments</h2>'; echo '<p><strong>WARNING :</strong> Clicking on the button below will delete ALL comments from your Wordpress install.</p>'; echo '<p><form method="post" action="'. str_replace( "%7E", "~", $_SERVER["REQUEST_URI"]).'" > <input type="submit" name="Delete" value="Delete"> <input type="hidden" name="delete_hidden" value="Y"> </form></p>'; echo '</div>'; } function func_delete_comments() { global $wpdb; if(isset($_POST['Delete'])) { // delete unapproved comments from db $wpdb->query("DELETE FROM wp_comments WHERE comment_approved = '0'"); $success = '<div id="message" class="updated fade">Successfully <b>DELETED</b> ALL Comments.</b></div>'; } return $success; } ?>

10-12-2010, 08:07 PM	#18
fris Too lazy to set a custom title Industry Role: Join Date: Aug 2002 Posts: 55,242	mine deletes every comment on your site, approved, or unapproved, thats how the OP wanted it, but mine has a check where you have to copy and paste a line of text, just to make sure you dont do anything by accident. http://jet.li/delete-comments.zip __________________ Since 1999: 69 Adult Industry awards for Best Hosting Company and professional excellence. WP Stuff

10-12-2010, 08:40 PM	#23
tonyparra Confirmed User Industry Role: Join Date: Jul 2008 Location: In your back seat with duck tape Posts: 4,568	there is a delete all pending comments plugin + use that witht the bad behavior plugin that shuts down spammers before they connect with your site + wp spam free for ultra protect bad behavior is awesome on its on though __________________ High Performance Vps $10 Linode Manage your Digital Ocean, Linode, or Favorite Cloud Server. Simple, fast, and secure Server Pilot