WordPress.org
Get WordPress

Make WordPress Core


Ignore:
File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/wp-admin/edit-comments.php

    r4781 r5226  
    5757    foreach ($_POST['delete_comments'] as $comment) : // Check the permissions on each
    5858        $comment = (int) $comment;
    59         $post_id = $wpdb->get_var("SELECT comment_post_ID FROM $wpdb->comments WHERE comment_ID = $comment");
     59        $post_id = (int) $wpdb->get_var("SELECT comment_post_ID FROM $wpdb->comments WHERE comment_ID = $comment");
    6060        // $authordata = get_userdata( $wpdb->get_var("SELECT post_author FROM $wpdb->posts WHERE ID = $post_id") );
    6161        if ( current_user_can('edit_post', $post_id) ) {
    … …  
    7676endif;
    7777
    78 if (isset($_GET['s'])) {
    79     $s = $wpdb->escape($_GET['s']);
    80     $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments  WHERE
    81         (comment_author LIKE '%$s%' OR
    82         comment_author_email LIKE '%$s%' OR
    83         comment_author_url LIKE ('%$s%') OR
    84         comment_author_IP LIKE ('%$s%') OR
    85         comment_content LIKE ('%$s%') ) AND
    86         comment_approved != 'spam'
    87         ORDER BY comment_date DESC");
    88 } else {
    89     if ( isset( $_GET['apage'] ) )
    90         $page = (int) $_GET['apage'];
    91     else
    92         $page = 1;
    93     $start = $offset = ( $page - 1 ) * 20;
    94 
    95     $comments = $wpdb->get_results( "SELECT * FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1' ORDER BY comment_date DESC LIMIT $start, 20" );
    96     $total = $wpdb->get_var( "SELECT COUNT(*) FROM $wpdb->comments WHERE comment_approved = '0' OR comment_approved = '1'" );
    97 }
    98 ?>
    99 <?php if ( $total > 20 ) {
    100 $total_pages = ceil( $total / 20 );
    101 $r = '';
    102 if ( 1 < $page ) {
    103     $args['apage'] = ( 1 == $page - 1 ) ? FALSE : $page - 1;
    104     $r .=  '<a class="prev" href="' . add_query_arg( $args ) . '">&laquo; '. __('Previous Page') .'</a>' . "\n";
    105 }
    106 if ( ( $total_pages = ceil( $total / 20 ) ) > 1 ) {
    107     for ( $page_num = 1; $page_num <= $total_pages; $page_num++ ) :
    108         if ( $page == $page_num ) :
    109             $r .=  "<span>$page_num</span>\n";
    110         else :
    111             $p = false;
    112             if ( $page_num < 3 || ( $page_num >= $page - 3 && $page_num <= $page + 3 ) || $page_num > $total_pages - 3 ) :
    113                 $args['apage'] = ( 1 == $page_num ) ? FALSE : $page_num;
    114                 $r .= '<a class="page-numbers" href="' . add_query_arg($args) . '">' . ( $page_num ) . "</a>\n";
    115                 $in = true;
    116             elseif ( $in == true ) :
    117                 $r .= "...\n";
    118                 $in = false;
    119             endif;
    120         endif;
    121     endfor;
    122 }
    123 if ( ( $page ) * 20 < $total || -1 == $total ) {
    124     $args['apage'] = $page + 1;
    125     $r .=  '<a class="next" href="' . add_query_arg($args) . '">'. __('Next Page') .' &raquo;</a>' . "\n";
    126 }
    127 echo "<p class='pagenav'>$r</p>";
    128 ?>
    129 
    130 <?php } ?>
    131 
    132 <?php
     78if ( isset( $_GET['apage'] ) )
     79    $page = (int) $_GET['apage'];
     80else
     81    $page = 1;
     82$start = $offset = ( $page - 1 ) * 20;
     83
     84list($_comments, $total) = _wp_get_comment_list( isset($_GET['s']) ? $_GET['s'] : false, $start, 25 ); // Grab a few extra
     85
     86$comments = array_slice($_comments, 0, 20);
     87$extra_comments = array_slice($_comments, 20);
     88
     89$page_links = paginate_links( array(
     90    'base' => 'edit-comments.php?%_%',
     91    'format' => 'apage=%#%',
     92    'total' => ceil($total / 20),
     93    'current' => $page
     94));
     95
     96if ( $page_links )
     97    echo "<p class='pagenav'>$page_links</p>";
     98
    13399if ('view' == $mode) {
    134100    if ($comments) {
    135 ?>
    136 <?php
    137 $offset = $offset + 1;
    138 $start = " start='$offset'";
    139 
    140         echo "<ol id='the-comment-list' class='commentlist' $start>";
     101        $offset = $offset + 1;
     102        $start = " start='$offset'";
     103
     104        echo "<ol id='the-comment-list' class='commentlist' $start>\n";
    141105        $i = 0;
    142         foreach ($comments as $comment) {
    143         ++$i; $class = '';
    144         $authordata = get_userdata($wpdb->get_var("SELECT post_author FROM $wpdb->posts WHERE ID = $comment->comment_post_ID"));
    145             $comment_status = wp_get_comment_status($comment->comment_ID);
    146             if ('unapproved' == $comment_status)
    147                 $class .= ' unapproved';
    148             if ($i % 2)
    149                 $class .= ' alternate';
    150             echo "<li id='comment-$comment->comment_ID' class='$class'>";
    151 ?>
    152 <p><strong><?php comment_author() ?></strong> <?php if ($comment->comment_author_email) { ?>| <?php comment_author_email_link() ?> <?php } if ($comment->comment_author_url && 'http://' != $comment->comment_author_url) { ?> | <?php comment_author_url_link() ?> <?php } ?>| <?php _e('IP:') ?> <a href="http://ws.arin.net/cgi-bin/whois.pl?queryinput=<?php comment_author_IP() ?>"><?php comment_author_IP() ?></a></p>
    153 
    154 <?php comment_text() ?>
    155 
    156 <p><?php comment_date('M j, g:i A');  ?> &#8212; [
    157 <?php
    158 if ( current_user_can('edit_post', $comment->comment_post_ID) ) {
    159     echo " <a href='comment.php?action=editcomment&amp;c=".$comment->comment_ID."'>" .  __('Edit') . '</a>';
    160     echo ' | <a href="' . wp_nonce_url('comment.php?action=deletecomment&amp;p=' . $comment->comment_post_ID . '&amp;c=' . $comment->comment_ID, 'delete-comment_' . $comment->comment_ID) . '" onclick="return deleteSomething( \'comment\', ' . $comment->comment_ID . ', \'' . js_escape(sprintf(__("You are about to delete this comment by '%s'.\n'Cancel' to stop, 'OK' to delete."), $comment->comment_author)) . "', theCommentList );\">" . __('Delete') . '</a> ';
    161     if ( ('none' != $comment_status) && ( current_user_can('moderate_comments') ) ) {
    162         echo '<span class="unapprove"> | <a href="' . wp_nonce_url('comment.php?action=unapprovecomment&amp;p=' . $comment->comment_post_ID . '&amp;c=' . $comment->comment_ID, 'unapprove-comment_' . $comment->comment_ID) . '" onclick="return dimSomething( \'comment\', ' . $comment->comment_ID . ', \'unapproved\', theCommentList );">' . __('Unapprove') . '</a> </span>';
    163         echo '<span class="approve"> | <a href="' . wp_nonce_url('comment.php?action=approvecomment&amp;p=' . $comment->comment_post_ID . '&amp;c=' . $comment->comment_ID, 'approve-comment_' . $comment->comment_ID) . '" onclick="return dimSomething( \'comment\', ' . $comment->comment_ID . ', \'unapproved\', theCommentList );">' . __('Approve') . '</a> </span>';
    164     }
    165     echo " | <a href=\"" . wp_nonce_url("comment.php?action=deletecomment&amp;dt=spam&amp;p=" . $comment->comment_post_ID . "&amp;c=" . $comment->comment_ID, 'delete-comment_' . $comment->comment_ID) . "\" onclick=\"return deleteSomething( 'comment-as-spam', $comment->comment_ID, '" . js_escape(sprintf(__("You are about to mark as spam this comment by '%s'.\n'Cancel' to stop, 'OK' to mark as spam."), $comment->comment_author))  . "', theCommentList );\">" . __('Spam') . "</a> ";
    166 }
    167 $post = get_post($comment->comment_post_ID);
    168 $post_title = wp_specialchars( $post->post_title, 'double' );
    169 $post_title = ('' == $post_title) ? "# $comment->comment_post_ID" : $post_title;
    170 ?>
    171  | <a href="<?php echo get_permalink($comment->comment_post_ID); ?>" title="<?php echo $post_title; ?>"><?php _e('View Post') ?></a> ]</p>
    172         </li>
    173 
    174 <?php } // end foreach($comment) ?>
    175 </ol>
     106        foreach ( $comments as $comment ) {
     107            get_comment( $comment ); // Cache it
     108            _wp_comment_list_item( $comment->comment_ID, ++$i );
     109        }
     110        echo "</ol>\n\n";
     111
     112if ( $extra_comments ) : ?>
     113<div id="extra-comments" style="display:none">
     114<ul id="the-extra-comment-list" class="commentlist">
     115<?php
     116    foreach ( $extra_comments as $comment ) {
     117        get_comment( $comment ); // Cache it
     118        _wp_comment_list_item( $comment->comment_ID, ++$i );
     119    }
     120?>
     121</ul>
     122</div>
     123<?php endif; // $extra_comments ?>
    176124
    177125<div id="ajax-response"></div>
    … …  
    243191    } // end if ($comments)
    244192}
    245     ?>
    246 <?php if ( $total > 20 ) {
    247 $total_pages = ceil( $total / 20 );
    248 $r = '';
    249 if ( 1 < $page ) {
    250     $args['apage'] = ( 1 == $page - 1 ) ? FALSE : $page - 1;
    251     $r .=  '<a class="prev" href="' . add_query_arg( $args ) . '">&laquo; '. __('Previous Page') .'</a>' . "\n";
    252 }
    253 if ( ( $total_pages = ceil( $total / 20 ) ) > 1 ) {
    254     for ( $page_num = 1; $page_num <= $total_pages; $page_num++ ) :
    255         if ( $page == $page_num ) :
    256             $r .=  "<span>$page_num</span>\n";
    257         else :
    258             $p = false;
    259             if ( $page_num < 3 || ( $page_num >= $page - 3 && $page_num <= $page + 3 ) || $page_num > $total_pages - 3 ) :
    260                 $args['apage'] = ( 1 == $page_num ) ? FALSE : $page_num;
    261                 $r .= '<a class="page-numbers" href="' . add_query_arg($args) . '">' . ( $page_num ) . "</a>\n";
    262                 $in = true;
    263             elseif ( $in == true ) :
    264                 $r .= "...\n";
    265                 $in = false;
    266             endif;
    267         endif;
    268     endfor;
    269 }
    270 if ( ( $page ) * 20 < $total || -1 == $total ) {
    271     $args['apage'] = $page + 1;
    272     $r .=  '<a class="next" href="' . add_query_arg($args) . '">'. __('Next Page') .' &raquo;</a>' . "\n";
    273 }
    274 echo "<p class='pagenav'>$r</p>";
    275 ?>
    276 
    277 <?php } ?>
     193
     194if ( $page_links )
     195    echo "<p class='pagenav'>$page_links</p>";
     196
     197?>
    278198
    279199</div>
Note: See TracChangeset for help on using the changeset viewer.