轶侠的网上小窝

SELECT 
    concat(comment_author,''),
    comment_author_url,
    comment_ID,
    comment_post_ID,
    CONCAT(
        @ex:=LEFT(comment_content,30),
        IF(LENGTH(comment_content)=LENGTH(@ex),'','...')
    ) AS comment,
FROM wp_comments
WHERE comment_approved = '1' 
ORDER BY comment_date_gmt DESC 
LIMIT 10

function yixia_widget_recent_comments($args){
  global $wpdb, $comments, $comment;
  extract($args, EXTR_SKIP);
  $options = get_option('widget_recent_comments');
  $title = empty($options['title']) ? __('Recent Comments') : $options['title'];
  if ( !$number = (int) $options['number'] )
    $number = 5;
  else if ( $number < 1 )
    $number = 1;
  else if ( $number > 15 )
    $number = 15;
  if ( !$length = (int) $options['length'] )
    $length = 16;
  else if ( $length < 6 )
    $length = 6;
  else if ( $length > 60 )
    $length = 60;
  if ( !$comments = wp_cache_get( 'recent_comments', 'widget' ) ) {
    $comments = $wpdb->get_results("SELECT comment_author,comment_author_url,comment_ID,comment_post_ID,CONCAT(@ex:=LEFT(comment_content,$length),IF(LENGTH(comment_content)=LENGTH(@ex),'','...')) as comment_content FROM $wpdb->comments WHERE comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT $number");
    wp_cache_add( 'recent_comments', $comments, 'widget' );
  }
  echo $before_widget;
  echo $before_title . $title . $after_title;
  echo '<ul id="recentcomments">';
  if ( $comments ) : foreach ($comments as $comment) :
    $comment_content = strip_tags($comment->comment_content);
    $comment_content = stripslashes($comment_content);
    echo  '<li class="recentcomments">' . sprintf(__('%1$s: %2$s'), get_comment_author_link(), '<a href="'. get_permalink($comment->comment_post_ID) . '#comment-' . $comment->comment_ID . '" title="'. get_the_title($comment->comment_post_ID) .'">'.$comment_content.'</a>') . '</li>';
  endforeach; endif;
  echo '</ul>'.$after_widget; 
}
function yixia_widget_recent_comments_control() {
  $options = $newoptions = get_option('widget_recent_comments');
  if ( $_POST["recent-comments-submit"] ) {
    $newoptions['title'] = strip_tags(stripslashes($_POST["recent-comments-title"]));
    $newoptions['number'] = (int) $_POST["recent-comments-number"];
    $newoptions['length'] = (int) $_POST["recent-comments-length"];
  }
  if ( $options != $newoptions ) {
    $options = $newoptions;
    update_option('widget_recent_comments', $options);
    wp_delete_recent_comments_cache();
  }
  $title = attribute_escape($options['title']);
  if ( !$number = (int) $options['number'] )
    $number = 5;
  if ( !$length = (int) $options['length'] )
    $length = 16;
?>
      <p><label for="recent-comments-title"><?php _e('Title:'); ?> <input class="widefat" id="recent-comments-title" name="recent-comments-title" type="text" value="<?php echo $title; ?>" /></label></p>
      <p>
        <label for="recent-comments-number"><?php _e('Number of comments to show:'); ?> <input style="width: 25px; text-align: center;" id="recent-comments-number" name="recent-comments-number" type="text" value="<?php echo $number; ?>" /></label>
        <br />
        <small><?php _e('(at most 15)'); ?></small>
      </p>
      <p>
        <label for="recent-comments-number"><?php _e('Length of comments to show:'); ?> <input style="width: 25px; text-align: center;" id="recent-comments-length" name="recent-comments-length" type="text" value="<?php echo $length; ?>" /></label>
        <br />
        <small><?php _e('(6 ~ 60)'); ?></small>
      </p>
      <input type="hidden" id="recent-comments-submit" name="recent-comments-submit" value="1" />
<?php
}
function yixia_widgets_init(){
  unregister_sidebar_widget('recent-comments');
  $widget_ops = array(
    'classname' => 'widget_recent_comments', 
    'description' => __( 'The most recent comments' ) 
  );
  wp_register_sidebar_widget('recent-comments', __('Recent Comments'), 'yixia_widget_recent_comments', $widget_ops);
  wp_register_widget_control('recent-comments', __('Recent Comments'), 'yixia_widget_recent_comments_control');
}
add_action('init', 'yixia_widgets_init', 1000);