Menu Adam R Brown

WP hooks navigation: Home/browseActions indexFilters index

Source View: comment_feed_join

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
1015                     $cjoin = "LEFT JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) $join ";
1016                     $cwhere = "WHERE comment_approved = '1' $where";
1017                     $cgroupby = "GROUP BY $wpdb->comments.comment_id";
1018                } else { // Other non singular e.g. front
1019                     $cjoin = "LEFT JOIN $wpdb->posts ON ( $wpdb->comments.comment_post_ID = $wpdb->posts.ID )";
1020                     $cwhere = "WHERE post_status = 'publish' AND comment_approved = '1'";
1021                     $cgroupby = '';
1022                }
1023
1024                $cjoin = apply_filters('comment_feed_join', $cjoin);
1025                $cwhere = apply_filters('comment_feed_where', $cwhere);
1026                $cgroupby = apply_filters('comment_feed_groupby', $cgroupby);
1027
1028                $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'));
1029                $this->comment_count = count($this->comments);
1030
1031                $post_ids = array();
1032
1033                foreach ($this->comments as $comment)
 
Line Code
1056           if ( !empty($limits) )
1057                $found_rows = 'SQL_CALC_FOUND_ROWS';
1058
1059           $request = " SELECT $found_rows $distinct $fields FROM $wpdb->posts $join WHERE 1=1 $where $groupby ORDER BY $orderby $limits";
1060           $this->request = apply_filters('posts_request', $request);
1061
1062           $this->posts = $wpdb->get_results($this->request);
1063
1064           if ( $this->is_comment_feed && $this->is_singular ) {
1065                $cjoin = apply_filters('comment_feed_join', '');
1066                $cwhere = apply_filters('comment_feed_where', "WHERE comment_post_ID = {$this->posts[0]->ID} AND comment_approved = '1'");
1067                $comments_request = "SELECT $wpdb->comments.* FROM $wpdb->comments $cjoin $cwhere ORDER BY comment_date_gmt DESC LIMIT " . get_option('posts_per_rss');
1068                $this->comments = $wpdb->get_results($comments_request);
1069                $this->comment_count = count($this->comments);
1070           }
1071
1072           if ( !empty($limits) ) {
1073                $found_posts_query = apply_filters( 'found_posts_query', 'SELECT FOUND_ROWS()' );
1074                $this->found_posts = $wpdb->get_var( $found_posts_query );