root/tags/1.5.1.3/wp-includes/classes.php

<?php

class WP_Query {
    var $query;
    var $query_vars;
    var $queried_object;
    var $queried_object_id;

    var $posts;
    var $post_count = 0;
    var $current_post = -1;
    var $post;

    var $is_single = false;
    var $is_page = false;
    var $is_archive = false;
    var $is_date = false;
    var $is_year = false;
    var $is_month = false;
    var $is_day = false;
    var $is_time = false;
    var $is_author = false;
    var $is_category = false;
    var $is_search = false;
    var $is_feed = false;
    var $is_trackback = false;
    var $is_home = false;
    var $is_404 = false;
    var $is_comments_popup = false;
    var $is_admin = false;

    function init () {
        $this->is_single = false;
        $this->is_page = false;
        $this->is_archive = false;
        $this->is_date = false;
        $this->is_year = false;
        $this->is_month = false;
        $this->is_day = false;
        $this->is_time = false;
        $this->is_author = false;
        $this->is_category = false;
        $this->is_search = false;
        $this->is_feed = false;
        $this->is_trackback = false;
        $this->is_home = false;
        $this->is_404 = false;
        $this->is_paged = false;
        $this->is_admin = false;

        unset($this->posts);
        unset($this->query);
        unset($this->query_vars);
        unset($this->queried_object);
        unset($this->queried_object_id);
        $this->post_count = 0;
        $this->current_post = -1;
    }

    // Reparse the query vars.
    function parse_query_vars() {
        $this->parse_query('');
    }

    // Parse a query string and set query type booleans.
    function parse_query ($query) {
        if ( !empty($query) || !isset($this->query) ) {
            $this->init();
            parse_str($query, $qv);
            $this->query = $query;
            $this->query_vars = $qv;
        }

        $qv['m'] =  (int) $qv['m'];
        $qv['p'] =  (int) $qv['p'];

        if ('' != $qv['name']) {
            $this->is_single = true;
        } elseif ( $qv['p'] ) {
            $this->is_single = true;
        } elseif (('' != $qv['hour']) && ('' != $qv['minute']) &&('' != $qv['second']) && ('' != $qv['year']) && ('' != $qv['monthnum']) && ('' != $qv['day'])) {
            // If year, month, day, hour, minute, and second are set, a single 
          // post is being queried.        
            $this->is_single = true;
        } elseif ('' != $qv['static'] || '' != $qv['pagename'] || '' != $qv['page_id']) {
            $this->is_page = true;
            $this->is_single = false;
        } elseif (!empty($qv['s'])) {
            $this->is_search = true;
        } else {
        // Look for archive queries.  Dates, categories, authors.

            if ( (int) $qv['second']) {
                $this->is_time = true;
                $this->is_date = true;
            }

            if ( (int) $qv['minute']) {
                $this->is_time = true;
                $this->is_date = true;
            }

            if ( (int) $qv['hour']) {
                $this->is_time = true;
                $this->is_date = true;
            }

            if ( (int) $qv['day']) {
                if (! $this->is_date) {
                    $this->is_day = true;
                    $this->is_date = true;
                }
            }

            if ( (int)  $qv['monthnum']) {
                if (! $this->is_date) {
                    $this->is_month = true;
                    $this->is_date = true;
                }
            }

            if ( (int)  $qv['year']) {
                if (! $this->is_date) {
                    $this->is_year = true;
                    $this->is_date = true;
                }
            }

            if ( (int)  $qv['m']) {
                $this->is_date = true;
                if (strlen($qv['m']) > 9) {
                    $this->is_time = true;
                } else if (strlen($qv['m']) > 7) {
                    $this->is_day = true;
                } else if (strlen($qv['m']) > 5) {
                    $this->is_month = true;
                } else {
                    $this->is_year = true;
                }
            }

            if ('' != $qv['w']) {
                $this->is_date = true;
            }

            if (empty($qv['cat']) || ($qv['cat'] == '0')) {
                $this->is_category = false;
            } else {
                if (stristr($qv['cat'],'-')) {
                    $this->is_category = false;
                } else {
                    $this->is_category = true;
                }
            }

            if ('' != $qv['category_name']) {
                $this->is_category = true;
            }
            
            if ((empty($qv['author'])) || ($qv['author'] == '0')) {
                $this->is_author = false;
            } else {
                $this->is_author = true;
            }

            if ('' != $qv['author_name']) {
                $this->is_author = true;
            }

            if ( ($this->is_date || $this->is_author || $this->is_category)) {
                $this->is_archive = true;
            }
        }

        if ('' != $qv['feed']) {
            $this->is_feed = true;
        }

        if ('' != $qv['tb']) {
            $this->is_trackback = true;
        }

        if ('404' == $qv['error']) {
            $this->is_404 = true;
        }

        if ('' != $qv['paged']) {
            $this->is_paged = true;
        }

        if ('' != $qv['comments_popup']) {
            $this->is_comments_popup = true;
        }

        if (strstr($_SERVER['PHP_SELF'], 'wp-admin/')) {
            $this->is_admin = true;
        }

        if ( ! ($this->is_archive || $this->is_single || $this->is_page || $this->is_search || $this->is_feed || $this->is_trackback || $this->is_404 || $this->is_admin || $this->is_comments_popup)) {
            $this->is_home = true;
        }

        if ( !empty($query) ) {
            do_action('parse_query', array(&$this));
        }
    }

    function get($query_var) {
        if (isset($this->query_vars[$query_var])) {
            return $this->query_vars[$query_var];
        }

        return '';
    }

    function set($query_var, $value) {
        $this->query_vars[$query_var] = $value;
    }

    function &get_posts() {
        global $wpdb, $pagenow, $request, $user_ID;

        // Shorthand.
        $q = $this->query_vars;    

        // First let's clear some variables
        $whichcat = '';
        $whichauthor = '';
        $result = '';
        $where = '';
        $limits = '';
        $distinct = '';
        $join = '';

        if ( !isset($q['posts_per_page']) || $q['posts_per_page'] == 0 )
            $q['posts_per_page'] = get_settings('posts_per_page');
        if ( !isset($q['what_to_show']) )
            $q['what_to_show'] = get_settings('what_to_show');
        if ( isset($q['showposts']) && $q['showposts'] ) {
            $q['showposts'] = (int) $q['showposts'];
            $q['posts_per_page'] = $q['showposts'];
        }
        if ( (isset($q['posts_per_archive_page']) && $q['posts_per_archive_page'] != 0) && ($this->is_archive || $this->is_search) )
            $q['posts_per_page'] = $q['posts_per_archive_page'];
        if ( !isset($q['nopaging']) ) {
            if ($q['posts_per_page'] == -1) {
                $q['nopaging'] = true;
            } else {
                $q['nopaging'] = false;
            }
        }
        if ( $this->is_feed ) {
            $q['posts_per_page'] = get_settings('posts_per_rss');
            $q['what_to_show'] = 'posts';
        }

        if (isset($q['page'])) {
            $q['page'] = trim($q['page'], '/');
            $q['page'] = (int) $q['page'];
        }
    
        $add_hours = intval(get_settings('gmt_offset'));
        $add_minutes = intval(60 * (get_settings('gmt_offset') - $add_hours));
        $wp_posts_post_date_field = "post_date"; // "DATE_ADD(post_date, INTERVAL '$add_hours:$add_minutes' HOUR_MINUTE)";

        // If a month is specified in the querystring, load that month
        if ( (int) $q['m'] ) {
            $q['m'] = '' . preg_replace('|[^0-9]|', '', $q['m']);
            $where .= ' AND YEAR(post_date)=' . substr($q['m'], 0, 4);
            if (strlen($q['m'])>5)
                $where .= ' AND MONTH(post_date)=' . substr($q['m'], 4, 2);
            if (strlen($q['m'])>7)
                $where .= ' AND DAYOFMONTH(post_date)=' . substr($q['m'], 6, 2);
            if (strlen($q['m'])>9)
                $where .= ' AND HOUR(post_date)=' . substr($q['m'], 8, 2);
            if (strlen($q['m'])>11)
                $where .= ' AND MINUTE(post_date)=' . substr($q['m'], 10, 2);
            if (strlen($q['m'])>13)
                $where .= ' AND SECOND(post_date)=' . substr($q['m'], 12, 2);
        }

        if ( (int) $q['hour'] ) {
            $q['hour'] = '' . intval($q['hour']);
            $where .= " AND HOUR(post_date)='" . $q['hour'] . "'";
        }

        if ( (int) $q['minute'] ) {
            $q['minute'] = '' . intval($q['minute']);
            $where .= " AND MINUTE(post_date)='" . $q['minute'] . "'";
        }

        if ( (int) $q['second'] ) {
            $q['second'] = '' . intval($q['second']);
            $where .= " AND SECOND(post_date)='" . $q['second'] . "'";
        }

        if ( (int) $q['year'] ) {
            $q['year'] = '' . intval($q['year']);
            $where .= " AND YEAR(post_date)='" . $q['year'] . "'";
        }

        if ( (int) $q['monthnum'] ) {
            $q['monthnum'] = '' . intval($q['monthnum']);
            $where .= " AND MONTH(post_date)='" . $q['monthnum'] . "'";
        }

        if ( (int) $q['day'] ) {
            $q['day'] = '' . intval($q['day']);
            $where .= " AND DAYOFMONTH(post_date)='" . $q['day'] . "'";
        }

        if ('' != $q['name']) {
            $q['name'] = sanitize_title($q['name']);
            $where .= " AND post_name = '" . $q['name'] . "'";
        } else if ('' != $q['pagename']) {
            $q['pagename'] = sanitize_title(basename(str_replace('%2F', '/', urlencode($q['pagename']))));
            $q['name'] = $q['pagename'];
            $where .= " AND post_name = '" . $q['pagename'] . "'";
        }


        if ( (int) $q['w'] ) {
            $q['w'] = ''.intval($q['w']);
            $where .= " AND WEEK(post_date, 1)='" . $q['w'] . "'";
        }

        if ( intval($q['comments_popup']) )
            $q['p'] = intval($q['comments_popup']);

        // If a post number is specified, load that post
        if (($q['p'] != '') && intval($q['p']) != 0) {
            $q['p'] =  (int) $q['p'];
            $where = ' AND ID = ' . $q['p'];
        }

        if (($q['page_id'] != '') && (intval($q['page_id']) != 0)) {
            $q['page_id'] = intval($q['page_id']);
            $q['p'] = $q['page_id'];
            $where = ' AND ID = '.$q['page_id'];
        }

        // If a search pattern is specified, load the posts that match
        if (!empty($q['s'])) {
            $q['s'] = addslashes_gpc($q['s']);
            $search = ' AND (';
            $q['s'] = preg_replace('/, +/', ' ', $q['s']);
            $q['s'] = str_replace(',', ' ', $q['s']);
            $q['s'] = str_replace('"', ' ', $q['s']);
            $q['s'] = trim($q['s']);
            if ($q['exact']) {
                $n = '';
            } else {
                $n = '%';
            }
            if (!$q['sentence']) {
                $s_array = explode(' ',$q['s']);
                $q['search_terms'] = $s_array;
                $search .= '((post_title LIKE \''.$n.$s_array[0].$n.'\') OR (post_content LIKE \''.$n.$s_array[0].$n.'\'))';
                for ( $i = 1; $i < count($s_array); $i = $i + 1) {
                    $search .= ' AND ((post_title LIKE \''.$n.$s_array[$i].$n.'\') OR (post_content LIKE \''.$n.$s_array[$i].$n.'\'))';
                }
                $search .= ' OR (post_title LIKE \''.$n.$q['s'].$n.'\') OR (post_content LIKE \''.$n.$q['s'].$n.'\')';
                $search .= ')';
            } else {
                $search = ' AND ((post_title LIKE \''.$n.$q['s'].$n.'\') OR (post_content LIKE \''.$n.$q['s'].$n.'\'))';
            }
        }

        // Category stuff

        if ((empty($q['cat'])) || ($q['cat'] == '0') || 
                // Bypass cat checks if fetching specific posts
                ( $this->is_single || $this->is_page )) {
            $whichcat='';
        } else {
            $q['cat'] = ''.urldecode($q['cat']).'';
            $q['cat'] = addslashes_gpc($q['cat']);
            if (stristr($q['cat'],'-')) {
                // Note: if we have a negative, we ignore all the positives. It must
                // always mean 'everything /except/ this one'. We should be able to do
                // multiple negatives but we don't :-(
                $eq = '!=';
                $andor = 'AND';
                $q['cat'] = explode('-',$q['cat']);
                $q['cat'] = intval($q['cat'][1]);
            } else {
                $eq = '=';
                $andor = 'OR';
            }
            $join = " LEFT JOIN $wpdb->post2cat ON ($wpdb->posts.ID = $wpdb->post2cat.post_id) ";
            $cat_array = preg_split('/[,\s]+/', $q['cat']);
            $whichcat .= ' AND (category_id '.$eq.' '.intval($cat_array[0]);
            $whichcat .= get_category_children($cat_array[0], ' '.$andor.' category_id '.$eq.' ');
            for ($i = 1; $i < (count($cat_array)); $i = $i + 1) {
                $whichcat .= ' '.$andor.' category_id '.$eq.' '.intval($cat_array[$i]);
                $whichcat .= get_category_children($cat_array[$i], ' '.$andor.' category_id '.$eq.' ');
            }