Manage | Comments question

Bump

If you’re in View mode, there’s a button at the bottom of the list to view the next 20 comments.

If you’re in Mass Edit mode there’s no button.

I don’t have a button in either.

I don’t have a button in either mode either.

The quickest solution is to edit the query line in edit-comments.php to increase the number of comments it retrieves. So change:

$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT $offset,20");

to:

$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT $offset,50");

to get the last 50 comments. Note the numeric value right at the end. Just change that to the number of comments you want to display.

An alternative quick and dirty fix:
About 2/3 of the way down this page https://cvs.sourceforge.net/viewcvs.py/cafelog/wordpress/wp-admin/edit-comments.php?rev=1.44&view=markup is the code for making the button appear, it starts with <"form action="" method="get"> and ends </form> I pasted the 6 lines into my edit-comments.php. Works for me ??

Or as a temporary solution access the page with this…
/wp-admin/edit-comments.php?offset=1
to get the 2nd page. Just keep increasing that 1 to go back pages. The functionality is built in, they just don’t have any button or link to move back yet.

Well, I was a little late, Ian has a better solution. ??

Hmm, but I believe MDV’s is actually the quickest, though…

Actually, as long as you’re hacking edit-comments.php,

if (‘view’ == $mode) {
if ($comments) {
$olstart = $offset+1;
if ($offset)
$start = ” start=’$olstart'”;
else
$start = ”;

This is really unbelievable that there is no “next” button. Same with the Manage Posts page. I’ve never seen a software product not have paging!

Is there a plugin that can do this?

In this thread (https://www.ads-software.com/support/topic/51742?replies=3) they recommend the Paged Comment Editing Plugin (https://www.coldforged.org/paged-comment-editing-plugin/).

I certainly find it strange that this is not built in…