Changeset 4479

Timestamp:

11/18/2006 06:52:01 AM (19 years ago)

Author:

matt

Message:

Paging for comments

File:

• trunk/wp-admin/edit-comments.php (modified) (2 diffs)

trunk/wp-admin/edit-comments.php

@@ -84 +84 @@
         ORDER BY comment_date DESC");
 } else {
-    if ( isset($_GET['offset']) )
-        $offset = (int) $_GET['offset'] * 20;
+    if ( isset( $_GET['apage'] ) )
+        $page = (int) $_GET['apage'];
     else
-        $offset = 0;
-
-    $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT $offset,20");
-}
+        $page = 1;
+    $start = $offset = ( $page - 1 ) * 20;
+    $end = $start + 20;
+
+    $comments = $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT $start, $end" );
+    $total = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1'" );
+}
+?>
+<?php if ( $total > 20 ) {
+$total_pages = ceil( $total / 20 );
+$r = '';
+if ( 1 < $page ) {
+    $args['apage'] = ( 1 == $page - 1 ) ? FALSE : $page - 1;
+    $r .=  '<a class="prev" href="' . add_query_arg( $args ) . '">&laquo; '. __('Previous Page') .'</a>' . "\n";
+}
+if ( ( $total_pages = ceil( $total / 20 ) ) > 1 ) {
+    for ( $page_num = 1; $page_num <= $total_pages; $page_num++ ) :
+        if ( $page == $page_num ) :
+            $r .=  "<span>$page_num</span>\n";
+        else :
+            $p = false;
+            if ( $page_num < 3 || ( $page_num >= $page - 3 && $page_num <= $page + 3 ) || $page_num > $total_pages - 3 ) :
+                $args['apage'] = ( 1 == $page_num ) ? FALSE : $page_num;
+                $r .= '<a class="page-numbers" href="' . add_query_arg($args) . '">' . ( $page_num ) . "</a>\n";
+                $in = true;
+            elseif ( $in == true ) :
+                $r .= "...\n";
+                $in = false;
+            endif;
+        endif;
+    endfor;
+}
+if ( ( $page ) * 20 < $total || -1 == $total ) {
+    $args['apage'] = $page + 1;
+    $r .=  '<a class="next" href="' . add_query_arg($args) . '">'. __('Next Page') .' &raquo;</a>' . "\n";
+}
+echo "<p>$r</p>";
+?>
+
+<?php } ?>
+
+<?php
 if ('view' == $mode) {
     if ($comments) {
-        if ($offset)
-            $start = " start='$offset'";
-        else
-            $start = '';
+?>
+<?php
+$offset = $offset + 1;
+$start = " start='$offset'";
 
         echo "<ol id='the-comment-list' class='commentlist' $start>";
@@ -204 +242 @@
 }
     ?>
+<?php if ( $total > 20 ) {
+$total_pages = ceil( $total / 20 );
+$r = '';
+if ( 1 < $page ) {
+    $args['apage'] = ( 1 == $page - 1 ) ? FALSE : $page - 1;
+    $r .=  '<a class="prev" href="' . add_query_arg( $args ) . '">&laquo; '. __('Previous Page') .'</a>' . "\n";
+}
+if ( ( $total_pages = ceil( $total / 20 ) ) > 1 ) {
+    for ( $page_num = 1; $page_num <= $total_pages; $page_num++ ) :
+        if ( $page == $page_num ) :
+            $r .=  "<span>$page_num</span>\n";
+        else :
+            $p = false;
+            if ( $page_num < 3 || ( $page_num >= $page - 3 && $page_num <= $page + 3 ) || $page_num > $total_pages - 3 ) :
+                $args['apage'] = ( 1 == $page_num ) ? FALSE : $page_num;
+                $r .= '<a class="page-numbers" href="' . add_query_arg($args) . '">' . ( $page_num ) . "</a>\n";
+                $in = true;
+            elseif ( $in == true ) :
+                $r .= "...\n";
+                $in = false;
+            endif;
+        endif;
+    endfor;
+}
+if ( ( $page ) * 20 < $total || -1 == $total ) {
+    $args['apage'] = $page + 1;
+    $r .=  '<a class="next" href="' . add_query_arg($args) . '">'. __('Next Page') .' &raquo;</a>' . "\n";
+}
+echo "<p>$r</p>";
+?>
+
+<?php } ?>
 
 </div>