• journalistic

    (@journalistic)


    Hi folks

    I’m using WordPress 1.2 and want to delete a whole load of comment spam, but in Mass Edit Mode it only shows 20 entries at a time.

    How can I change the number to say 100 or 250 on a page to save me some time.

    thanks

    Leslie

Viewing 5 replies - 1 through 5 (of 5 total)
  • lawtai

    (@lawtai)

    heh i’m not sure how to change what you’re asking for, but one way to do it woudl be to go into phpmyadmin and delete in there. I believe you can set how many entries to show too.

    Thread Starter journalistic

    (@journalistic)

    well, a search found what I am looking for an indeed, teaches us all the important lesson – search before you post!

    Anyway, the answer to my question is really easy, as Nuclear Moose explained last year:

    go into wp-admin/edit-comments.php and at around line 68 or so, you’ll find this:
    $comments = $wpdb->get_results(“SELECT * FROM $tablecomments ORDER BY comment_date DESC LIMIT 20”);
    Change the ’20’ to whatever number you like.

    Well, I changed mine to 200 and it works great.

    NuclearMoose

    (@nuclearmoose)

    There is a way to do this, and it requires an edit in one of the PHP files. I once set this to a very large number (250) so that I could delete a major spam attack. This was prior to having most of the great anti-spam plugins available.

    I will poke around my failing memory and try and remember where I changed this.

    Also, if there are any bored coders out there who would like something to do, this would be an excellent plugin! ??

    NuclearMoose

    (@nuclearmoose)

    Okay, I remembered!
    You need to go to /wp-admin/edit-comments.php and look for this line:
    $comments = $wpdb->get_results("SELECT * FROM $tablecomments ORDER BY comment_date DESC LIMIT 20");

    In my file, it was line 68. Change the 20 to whatever value you want. Be aware that loading a lot of comments will slow down page load time.

    Ming

    (@ming)

    This is the plugin you’re looking for. Good timing really, it was only released two days ago.

    https://www.coldforged.org/archives/2005/03/03/where-the-hell-are-my-comments/

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘How to make Mass Edit Mode show more than 20 entries’ is closed to new replies.