Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Посты с самым большим количеством комментариев за период
- function nlt_getPostsByComments($interval=30, $count=5){
- global $wpdb;
- $interval = date('Y-m-d', strtotime("-$interval days"));
- $result = $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_type = 'post' AND post_status = 'publish' AND post_date > '$interval' ORDER BY comment_count DESC LIMIT 0 , $count");
- $output = '<ul>';
- foreach ($result as $post){
- setup_postdata($post);
- $output .= sprintf('<li><a href="%s">%s<span>%s</span></a></li>', get_permalink($post->ID), get_the_title($post->ID), $post->comment_count);
- }
- $output .= '</ul>';
- echo $output;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement