root/tags/2.1.1/wp-includes/post.php

<?php

//
// Post functions
//

function get_attached_file( $attachment_id, $unfiltered = false ) {
    $file = get_post_meta( $attachment_id, '_wp_attached_file', true );
    if ( $unfiltered )
        return $file;
    return apply_filters( 'get_attached_file', $file, $attachment_id );
}

function update_attached_file( $attachment_id, $file ) {
    if ( !get_post( $attachment_id ) )
        return false;

    $old_file = get_attached_file( $attachment_id, true );

    $file = apply_filters( 'update_attached_file', $file, $attachment_id );

    if ( $old_file )
        return update_post_meta( $attachment_id, '_wp_attached_file', $file, $old_file );
    else
        return add_post_meta( $attachment_id, '_wp_attached_file', $file );
}

function &get_children($args = '', $output = OBJECT) {
    global $post_cache, $wpdb, $blog_id;

    if ( empty($args) ) {
        if ( isset($GLOBALS['post']) )
            $r = array('post_parent' => & $GLOBALS['post']->post_parent);
        else
            return false;
    } elseif ( is_object($args) )
        $r = array('post_parent' => $post->post_parent);
    elseif ( is_numeric($args) )
        $r = array('post_parent' => $args);
    elseif ( is_array($args) )
        $r = &$args;
    else
        parse_str($args, $r);

    $defaults = array('numberposts' => -1, 'post_type' => '', 'post_status' => '', 'post_parent' => 0);
    $r = array_merge($defaults, $r);

    $children = get_posts( $r );

    if ( $children ) {
        foreach ( $children as $key => $child ) {
            $post_cache[$blog_id][$child->ID] =& $children[$key];
            $kids[$child->ID] =& $children[$key];
        }
    } else {
        return false;
    }

    if ( $output == OBJECT ) {
        return $kids;
    } elseif ( $output == ARRAY_A ) {
        foreach ( $kids as $kid )
            $weeuns[$kid->ID] = get_object_vars($kids[$kid->ID]);
        return $weeuns;
    } elseif ( $output == ARRAY_N ) {
        foreach ( $kids as $kid )
            $babes[$kid->ID] = array_values(get_object_vars($kids[$kid->ID]));
        return $babes;
    } else {
        return $kids;
    }
}

// get extended entry info (<!--more-->)
function get_extended($post) {
    //Match the new style more links
    if ( preg_match('/<!--more(.*?)-->/', $post, $matches) ) {
        list($main, $extended) = explode($matches[0], $post, 2);
    } else {
        $main = $post;
        $extended = '';
    }
    
    // Strip leading and trailing whitespace
    $main = preg_replace('/^[\s]*(.*)[\s]*$/', '\\1', $main);
    $extended = preg_replace('/^[\s]*(.*)[\s]*$/', '\\1', $extended);

    return array('main' => $main, 'extended' => $extended);
}

// Retrieves post data given a post ID or post object.
// Handles post caching.
function &get_post(&$post, $output = OBJECT) {
    global $post_cache, $wpdb, $blog_id;

    if ( empty($post) ) {
        if ( isset($GLOBALS['post']) )
            $_post = & $GLOBALS['post'];
        else
            $_post = null;
    } elseif ( is_object($post) ) {
        if ( 'page' == $post->post_type )
            return get_page($post, $output);
        if ( !isset($post_cache[$blog_id][$post->ID]) )
            $post_cache[$blog_id][$post->ID] = &$post;
        $_post = & $post_cache[$blog_id][$post->ID];
    } else {
        if ( $_post = wp_cache_get($post, 'pages') )
            return get_page($_post, $output);
        elseif ( isset($post_cache[$blog_id][$post]) )
            $_post = & $post_cache[$blog_id][$post];
        else {
            $query = "SELECT * FROM $wpdb->posts WHERE ID = '$post' LIMIT 1";
            $_post = & $wpdb->get_row($query);
            if ( 'page' == $_post->post_type )
                return get_page($_post, $output);
            $post_cache[$blog_id][$post] = & $_post;
        }
    }

    if ( defined('WP_IMPORTING') )
        unset($post_cache[$blog_id]);

    if ( $output == OBJECT ) {
        return $_post;
    } elseif ( $output == ARRAY_A ) {
        return get_object_vars($_post);
    } elseif ( $output == ARRAY_N ) {
        return array_values(get_object_vars($_post));
    } else {
        return $_post;
    }
}

// Takes a post ID, returns its mime type.
function get_post_mime_type($ID = '') {
    $post = & get_post($ID);

    if ( is_object($post) )
        return $post->post_mime_type;

    return false;
}

function get_post_status($ID = '') {
    $post = get_post($ID);

    if ( is_object($post) ) {
        if ( ('attachment' == $post->post_type) && $post->post_parent && ($post->ID != $post->post_parent) )
            return get_post_status($post->post_parent);
        else
            return $post->post_status;
    }

    return false;
}

function get_post_type($post = false) {
    global $wpdb, $posts;

    if ( false === $post )
        $post = $posts[0];
    elseif ( (int) $post )
        $post = get_post($post, OBJECT);

    if ( is_object($post) )
        return $post->post_type;

    return false;
}

function get_posts($args) {
    global $wpdb;

    if ( is_array($args) )
        $r = &$args;
    else
        parse_str($args, $r);

    $defaults = array('numberposts' => 5, 'offset' => 0, 'category' => 0,
        'orderby' => 'post_date', 'order' => 'DESC', 'include' => '', 'exclude' => '',
        'meta_key' => '', 'meta_value' =>'', 'post_type' => 'post', 'post_status' => 'publish', 'post_parent' => 0);
    $r = array_merge($defaults, $r);
    extract($r);
    $numberposts = (int) $numberposts;
    $offset = (int) $offset;
    $category = (int) $category;
    $post_parent = (int) $post_parent;

    $inclusions = '';
    if ( !empty($include) ) {
        $offset = 0;    //ignore offset, category, exclude, meta_key, and meta_value, post_parent if using include
        $category = 0;
        $exclude = '';
        $meta_key = '';
        $meta_value = '';
        $post_parent = 0;
        $incposts = preg_split('/[\s,]+/',$include);
        $numberposts = count($incposts);  // only the number of posts included
        if ( count($incposts) ) {
            foreach ( $incposts as $incpost ) {
                if (empty($inclusions))
                    $inclusions = ' AND ( ID = ' . intval($incpost) . ' ';
                else
                    $inclusions .= ' OR ID = ' . intval($incpost) . ' ';
            }
        }
    }
    if (!empty($inclusions))
        $inclusions .= ')';

    $exclusions = '';
    if ( !empty($exclude) ) {
        $exposts = preg_split('/[\s,]+/',$exclude);
        if ( count($exposts) ) {
            foreach ( $exposts as $expost ) {
                if (empty($exclusions))
                    $exclusions = ' AND ( ID <> ' . intval($expost) . ' ';
                else
                    $exclusions .= ' AND ID <> ' . intval($expost) . ' ';
            }
        }
    }
    if (!empty($exclusions))
        $exclusions .= ')';

    $query ="SELECT DISTINCT * FROM $wpdb->posts " ;
    $query .= ( empty( $category ) ? "" : ", $wpdb->post2cat " );
    $query .= ( empty( $meta_key ) ? "" : ", $wpdb->postmeta " );
    $query .= " WHERE (post_type = 'post' AND post_status = 'publish') $exclusions $inclusions ";
    $query .= ( empty( $category ) ? "" : "AND ($wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. ") " );
    $query .= ( empty( $meta_key ) | empty($meta_value)  ? "" : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )" );
    $query .= " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . " " . $order . " LIMIT " . $offset . ',' . $numberposts;

    $query  = "SELECT DISTINCT * FROM $wpdb->posts ";
    $query .= empty( $category ) ? '' : ", $wpdb->post2cat "; 
    $query .= empty( $meta_key ) ? '' : ", $wpdb->postmeta ";
    $query .= " WHERE 1=1 ";
    $query .= empty( $post_type ) ? '' : "AND post_type = '$post_type' ";
    $query .= empty( $post_status ) ? '' : "AND post_status = '$post_status' ";
    $query .= "$exclusions $inclusions " ;
    $query .= empty( $category ) ? '' : "AND ($wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = " . $category. ") ";
    $query .= empty( $post_parent ) ? '' : "AND $wpdb->posts.post_parent = '$post_parent' ";
    $query .= empty( $meta_key ) | empty($meta_value)  ? '' : " AND ($wpdb->posts.ID = $wpdb->postmeta.post_id AND $wpdb->postmeta.meta_key = '$meta_key' AND $wpdb->postmeta.meta_value = '$meta_value' )";
    $query .= " GROUP BY $wpdb->posts.ID ORDER BY " . $orderby . ' ' . $order;
    if ( 0 < $numberposts )
        $query .= " LIMIT " . $offset . ',' . $numberposts;

    $posts = $wpdb->get_results($query);

    update_post_caches($posts);

    return $posts;
}

//
// Post meta functions
//

function add_post_meta($post_id, $key, $value, $unique = false) {
    global $wpdb, $post_meta_cache, $blog_id;

    $post_id = (int) $post_id;

    if ( $unique ) {
        if ( $wpdb->get_var("SELECT meta_key FROM $wpdb->postmeta WHERE meta_key = '$key' AND post_id = '$post_id'") ) {
            return false;
        }
    }

    $post_meta_cache[$blog_id][$post_id][$key][] = $value;

    $value = maybe_serialize($value);
    $value = $wpdb->escape($value);

    $wpdb->query("INSERT INTO $wpdb->postmeta (post_id,meta_key,meta_value) VALUES ('$post_id','$key','$value')");

    return true;
}

function delete_post_meta($post_id, $key, $value = '') {
    global $wpdb, $post_meta_cache, $blog_id;

    $post_id = (int) $post_id;

    if ( empty($value) ) {
        $meta_id = $wpdb->get_var("SELECT meta_id FROM $wpdb->postmeta WHERE post_id = '$post_id' AND meta_key = '$key'");
    } else {
        $meta_id = $wpdb->get_var("SELECT meta_id FROM $wpdb->postmeta WHERE post_id = '$post_id' AND meta_key = '$key' AND meta_value = '$value'");
    }

    if ( !$meta_id )
        return false;

    if ( empty($value) ) {
        $wpdb->query("DELETE FROM $wpdb->postmeta WHERE post_id = '$post_id' AND meta_key = '$key'");
        unset($post_meta_cache[$blog_id][$post_id][$key]);
    } else {
        $wpdb->query("DELETE FROM $wpdb->postmeta WHERE post_id = '$post_id' AND meta_key = '$key' AND meta_value = '$value'");
        $cache_key = $post_meta_cache[$blog_id][$post_id][$key];
        if ($cache_key) foreach ( $cache_key as $index => $data )
            if ( $data == $value )
                unset($post_meta_cache[$blog_id][$post_id][$key][$index]);
    }

    unset($post_meta_cache[$blog_id][$post_id][$key]);

    return true;
}

function get_post_meta($post_id, $key, $single = false) {
    global $wpdb, $post_meta_cache, $blog_id;

    $post_id = (int) $post_id;

    if ( isset($post_meta_cache[$blog_id][$post_id][$key]) ) {
        if ( $single ) {
            return maybe_unserialize( $post_meta_cache[$blog_id][$post_id][$key][0] );
        } else {
            return maybe_unserialize( $post_meta_cache[$blog_id][$post_id][$key] );
        }
    }

    if ( !isset($post_meta_cache[$blog_id][$post_id]) )
        update_postmeta_cache($post_id);

    if ( $single ) {
        if ( isset($post_meta_cache[$blog_id][$post_id][$key][0]) )
            return maybe_unserialize($post_meta_cache[$blog_id][$post_id][$key][0]);
        else
            return '';
    }    else {
        return maybe_unserialize($post_meta_cache[$blog_id][$post_id][$key]);
    }
}

function update_post_meta($post_id, $key, $value, $prev_value = '') {
    global $wpdb, $post_meta_cache, $blog_id;

    $post_id = (int) $post_id;

    $original_value = $value;
    $value = maybe_serialize($value);
    $value = $wpdb->escape($value);

    $original_prev = $prev_value;
    $prev_value = maybe_serialize($prev_value);
    $prev_value = $wpdb->escape($prev_value);

    if (! $wpdb->get_var("SELECT meta_key FROM $wpdb->postmeta WHERE meta_key = '$key' AND post_id = '$post_id'") ) {
        return false;
    }

    if ( empty($prev_value) ) {
        $wpdb->query("UPDATE $wpdb->postmeta SET meta_value = '$value' WHERE meta_key = '$key' AND post_id = '$post_id'");
        $cache_key = $post_meta_cache[$blog_id][$post_id][$key];
        if ( !empty($cache_key) )
            foreach ($cache_key as $index => $data)
                $post_meta_cache[$blog_id][$post_id][$key][$index] = $original_value;
    } else {
        $wpdb->query("UPDATE $wpdb->postmeta SET meta_value = '$value' WHERE meta_key = '$key' AND post_id = '$post_id' AND meta_value = '$prev_value'");
        $cache_key = $post_meta_cache[$blog_id][$post_id][$key];
        if ( !empty($cache_key) )
            foreach ($cache_key as $index => $data)
                if ( $data == $original_prev )
                    $post_meta_cache[$blog_id][$post_id][$key][$index] = $original_value;
    }

    return true;
}


function get_post_custom($post_id = 0) {
    global $id, $post_meta_cache, $wpdb, $blog_id;

    if ( !$post_id )
        $post_id = $id;

    $post_id = (int) $post_id;

    if ( !isset($post_meta_cache[$blog_id][$post_id]) )
        update_postmeta_cache($post_id);

    return $post_meta_cache[$blog_id][$post_id];
}

function get_post_custom_keys( $post_id = 0 ) {
    $custom = get_post_custom( $post_id );

    if ( !is_array($custom) )
        return;

    if ( $keys = array_keys($custom) )
        return $keys;
}


function get_post_custom_values( $key = '', $post_id = 0 ) {
    $custom = get_post_custom($post_id);

    return $custom[$key];
}

function wp_delete_post($postid = 0) {
    global $wpdb, $wp_rewrite;
    $postid = (int) $postid;

    if ( !$post = $wpdb->get_row("SELECT * FROM $wpdb->posts WHERE ID = $postid") )
        return $post;

    if ( 'attachment' == $post->post_type )
        return wp_delete_attachment($postid);

    do_action('delete_post', $postid);

    if ( 'publish' == $post->post_status && 'post' == $post->post_type ) {
        $categories = wp_get_post_categories($post->ID);
        if( is_array( $categories ) ) {
            foreach ( $categories as $cat_id ) {
                $wpdb->query("UPDATE $wpdb->categories SET category_count = category_count - 1 WHERE cat_ID = '$cat_id'");
                wp_cache_delete($cat_id, 'category');
                do_action('edit_category', $cat_id);
            }
        }
    }

    if ( 'page' == $post->post_type )
        $wpdb->query("UPDATE $wpdb->posts SET post_parent = $post->post_parent WHERE post_parent = $postid AND post_type = 'page'");

    $wpdb->query("UPDATE $wpdb->posts SET post_parent = $post->post_parent WHERE post_parent = $postid AND post_type = 'attachment'");

    $wpdb->query("DELETE FROM $wpdb->posts WHERE ID = $postid");

    $wpdb->query("DELETE FROM $wpdb->comments WHERE comment_post_ID = $postid");

    $wpdb->query("DELETE FROM $wpdb->post2cat WHERE post_id = $postid");

    $wpdb->query("DELETE FROM $wpdb->postmeta WHERE post_id = $postid");

    if ( 'page' == $post->post_type ) {
        clean_page_cache($postid);
        $wp_rewrite->flush_rules();
    }

    return $post;
}

function wp_get_post_categories($post_id = 0) {
    $cats = &get_the_category($post_id);
    $cat_ids = array();
    foreach ( $cats as $cat )
        $cat_ids[] = (int) $cat->cat_ID;
    return array_unique($cat_ids);
}

function wp_get_recent_posts($num = 10) {
    global $wpdb;

    // Set the limit clause, if we got a limit
    if ($num) {
        $limit = "LIMIT $num";
    }

    $sql = "SELECT * FROM $wpdb->posts WHERE post_type = 'post' ORDER BY post_date DESC $limit";
    $result = $wpdb->get_results($sql,ARRAY_A);

    return $result?$result:array();
}

function wp_get_single_post($postid = 0, $mode = OBJECT) {
    global $wpdb;

    $post = get_post($postid, $mode);

    // Set categories
    if($mode == OBJECT) {
        $post->post_category = wp_get_post_categories($postid);
    }
    else {
        $post['post_category'] = wp_get_post_categories($postid);
    }