Menu Adam R Brown

WP hooks navigation: Home/browseActions indexFilters index

Source View: comment_feed_where

To save our bandwidth, we show only a snippet of code around each occurence of the hook. View complete file in SVN (without highlighting).

Understanding Source Code

The best way to understand what a hook does is to look at where it occurs in the source code.

Remember, this hook may occur in more than one file. Moreover, the hook's context may change from version to version.

Source View

This hook occurs 2 times in this file.

Line Code
1366                     $cwhere = "WHERE comment_approved = '1' $where";
1367                     $cgroupby = "GROUP BY $wpdb->comments.comment_id";
1368                } else { // Other non singular e.g. front
1369                     $cjoin = "LEFT JOIN $wpdb->posts ON ( $wpdb->comments.comment_post_ID = $wpdb->posts.ID )";
1370                     $cwhere = "WHERE post_status = 'publish' AND comment_approved = '1'";
1371                     $cgroupby = '';
1372                }
1373
1374                $cjoin = apply_filters('comment_feed_join', $cjoin);
1375                $cwhere = apply_filters('comment_feed_where', $cwhere);
1376                $cgroupby = apply_filters('comment_feed_groupby', $cgroupby);
1377
1378                $this->comments = (array) $wpdb->get_results("SELECT $distinct $wpdb->comments.* FROM $wpdb->comments $cjoin $cwhere $cgroupby ORDER BY comment_date_gmt DESC LIMIT " . get_option('posts_per_rss'));
1379                $this->comment_count = count($this->comments);
1380
1381                $post_ids = array();
1382
1383                foreach ($this->comments as $comment)
1384                     $post_ids[] = (int) $comment->comment_post_ID;
 
Line Code
1425           $request = " SELECT $found_rows $distinct $fields FROM $wpdb->posts $join WHERE 1=1 $where $groupby $orderby $limits";
1426           $this->request = apply_filters('posts_request', $request);
1427
1428           $this->posts = $wpdb->get_results($this->request);
1429           // Raw results filter.  Prior to status checks.
1430           $this->posts = apply_filters('posts_results', $this->posts);
1431
1432           if ( !empty($this->posts) && $this->is_comment_feed && $this->is_singular ) {
1433                $cjoin = apply_filters('comment_feed_join', '');
1434                $cwhere = apply_filters('comment_feed_where', "WHERE comment_post_ID = '{$this->posts[0]->ID}' AND comment_approved = '1'");
1435                $comments_request = "SELECT $wpdb->comments.* FROM $wpdb->comments $cjoin $cwhere ORDER BY comment_date_gmt DESC LIMIT " . get_option('posts_per_rss');
1436                $this->comments = $wpdb->get_results($comments_request);
1437                $this->comment_count = count($this->comments);
1438           }
1439
1440           if ( !empty($limits) ) {
1441                $found_posts_query = apply_filters( 'found_posts_query', 'SELECT FOUND_ROWS()' );
1442                $this->found_posts = $wpdb->get_var( $found_posts_query );
1443                $this->found_posts = apply_filters( 'found_posts', $this->found_posts );