[wp-trac] Re: [WordPress Trac] #8169: Recent comments for unpublished posts showing at the sidebar

[WordPress Trac]

#8169: Recent comments for unpublished posts showing at the sidebar
-------------------------+--------------------------------------------------
 Reporter:  mberasategi  |        Owner:     
     Type:  defect       |       Status:  new
 Priority:  normal       |    Milestone:  2.8
Component:  Comments     |      Version:     
 Severity:  major        |   Resolution:     
 Keywords:  comments,    |  
-------------------------+--------------------------------------------------
Comment (by Viper007Bond):

 Replying to [comment:2 mrmist]:
 > The only issue that I can see with it is that it shows the content on
 comments that are awaiting approval to people who aren't comment
 moderators.

 No it doesn't.

 `$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE
 comment_approved = '1' ORDER BY comment_date_gmt DESC LIMIT $number");`

-- 
Ticket URL: <http://trac.wordpress.org/ticket/8169#comment:3>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software