root/branches/1.5/wp-includes/functions.php

<?php

require_once(dirname(__FILE__).'/functions-compat.php');

if (!function_exists('_')) {
    function _($string) {
        return $string;
    }
}

function get_profile($field, $user = false) {
    global $wpdb;
    if (!$user)
        $user = $wpdb->escape($_COOKIE['wordpressuser_' . COOKIEHASH]);
    return $wpdb->get_var("SELECT $field FROM $wpdb->users WHERE user_login = '$user'");
}

function mysql2date($dateformatstring, $mysqlstring, $translate = true) {
    global $month, $weekday, $month_abbrev, $weekday_abbrev;
    $m = $mysqlstring;
    if (empty($m)) {
        return false;
    }
    $i = mktime(substr($m,11,2),substr($m,14,2),substr($m,17,2),substr($m,5,2),substr($m,8,2),substr($m,0,4)); 
    if (!empty($month) && !empty($weekday) && $translate) {
        $datemonth = $month[date('m', $i)];
        $datemonth_abbrev = $month_abbrev[$datemonth];
        $dateweekday = $weekday[date('w', $i)];
        $dateweekday_abbrev = $weekday_abbrev[$dateweekday];         
        $dateformatstring = ' '.$dateformatstring;
        $dateformatstring = preg_replace("/([^\\\])D/", "\\1".backslashit($dateweekday_abbrev), $dateformatstring);
        $dateformatstring = preg_replace("/([^\\\])F/", "\\1".backslashit($datemonth), $dateformatstring);
        $dateformatstring = preg_replace("/([^\\\])l/", "\\1".backslashit($dateweekday), $dateformatstring);
        $dateformatstring = preg_replace("/([^\\\])M/", "\\1".backslashit($datemonth_abbrev), $dateformatstring);
    
        $dateformatstring = substr($dateformatstring, 1, strlen($dateformatstring)-1);
    }
    $j = @date($dateformatstring, $i);
    if (!$j) {
    // for debug purposes
    //    echo $i." ".$mysqlstring;
    }
    return $j;
}

function current_time($type, $gmt = 0) {
    switch ($type) {
        case 'mysql':
            if ($gmt) $d = gmdate('Y-m-d H:i:s');
            else $d = gmdate('Y-m-d H:i:s', (time() + (get_settings('gmt_offset') * 3600)));
            return $d;
            break;
        case 'timestamp':
            if ($gmt) $d = time();
            else $d = time() + (get_settings('gmt_offset') * 3600);
            return $d;
            break;
    }
}

function date_i18n($dateformatstring, $unixtimestamp) {
    global $month, $weekday, $month_abbrev, $weekday_abbrev;
    $i = $unixtimestamp; 
    if ((!empty($month)) && (!empty($weekday))) {
        $datemonth = $month[date('m', $i)];
        $datemonth_abbrev = $month_abbrev[$datemonth];
        $dateweekday = $weekday[date('w', $i)];
        $dateweekday_abbrev = $weekday_abbrev[$dateweekday];         
        $dateformatstring = ' '.$dateformatstring;
        $dateformatstring = preg_replace("/([^\\\])D/", "\\1".backslashit($dateweekday_abbrev), $dateformatstring);
        $dateformatstring = preg_replace("/([^\\\])F/", "\\1".backslashit($datemonth), $dateformatstring);
        $dateformatstring = preg_replace("/([^\\\])l/", "\\1".backslashit($dateweekday), $dateformatstring);
        $dateformatstring = preg_replace("/([^\\\])M/", "\\1".backslashit($datemonth_abbrev), $dateformatstring);
        $dateformatstring = substr($dateformatstring, 1, strlen($dateformatstring)-1);
    }
    $j = @date($dateformatstring, $i);
    return $j;
    }

function get_weekstartend($mysqlstring, $start_of_week) {
    $my = substr($mysqlstring,0,4);
    $mm = substr($mysqlstring,8,2);
    $md = substr($mysqlstring,5,2);
    $day = mktime(0,0,0, $md, $mm, $my);
    $weekday = date('w',$day);
    $i = 86400;

    if ($weekday < get_settings('start_of_week'))
        $weekday = 7 - (get_settings('start_of_week') - $weekday);

    while ($weekday > get_settings('start_of_week')) {
        $weekday = date('w',$day);
        if ($weekday < get_settings('start_of_week'))
            $weekday = 7 - (get_settings('start_of_week') - $weekday);

        $day = $day - 86400;
        $i = 0;
    }
    $week['start'] = $day + 86400 - $i;
    //$week['end']   = $day - $i + 691199;
    $week['end'] = $week['start'] + 604799;
    return $week;
}

function get_lastpostdate($timezone = 'server') {
    global $cache_lastpostdate, $pagenow, $wpdb;
    $add_seconds_blog = get_settings('gmt_offset') * 3600;
    $add_seconds_server = date('Z');
    $now = current_time('mysql', 1);
    if ( !isset($cache_lastpostdate[$timezone]) ) {
        switch(strtolower($timezone)) {
            case 'gmt':
                $lastpostdate = $wpdb->get_var("SELECT post_date_gmt FROM $wpdb->posts WHERE post_date_gmt <= '$now' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1");
                break;
            case 'blog':
                $lastpostdate = $wpdb->get_var("SELECT post_date FROM $wpdb->posts WHERE post_date_gmt <= '$now' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1");
                break;
            case 'server':
                $lastpostdate = $wpdb->get_var("SELECT DATE_ADD(post_date_gmt, INTERVAL '$add_seconds_server' SECOND) FROM $wpdb->posts WHERE post_date_gmt <= '$now' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1");
                break;
        }
        $cache_lastpostdate[$timezone] = $lastpostdate;
    } else {
        $lastpostdate = $cache_lastpostdate[$timezone];
    }
    return $lastpostdate;
}

function get_lastpostmodified($timezone = 'server') {
    global $cache_lastpostmodified, $pagenow, $wpdb;
    $add_seconds_blog = get_settings('gmt_offset') * 3600;
    $add_seconds_server = date('Z');
    $now = current_time('mysql', 1);
    if ( !isset($cache_lastpostmodified[$timezone]) ) {
        switch(strtolower($timezone)) {
            case 'gmt':
                $lastpostmodified = $wpdb->get_var("SELECT post_modified_gmt FROM $wpdb->posts WHERE post_modified_gmt <= '$now' AND post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1");
                break;
            case 'blog':
                $lastpostmodified = $wpdb->get_var("SELECT post_modified FROM $wpdb->posts WHERE post_modified_gmt <= '$now' AND post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1");
                break;
            case 'server':
                $lastpostmodified = $wpdb->get_var("SELECT DATE_ADD(post_modified_gmt, INTERVAL '$add_seconds_server' SECOND) FROM $wpdb->posts WHERE post_modified_gmt <= '$now' AND post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1");
                break;
        }
        $lastpostdate = get_lastpostdate($timezone);
        if ($lastpostdate > $lastpostmodified) {
            $lastpostmodified = $lastpostdate;
        }
        $cache_lastpostmodified[$timezone] = $lastpostmodified;
    } else {
        $lastpostmodified = $cache_lastpostmodified[$timezone];
    }
    return $lastpostmodified;
}

function user_pass_ok($user_login,$user_pass) {
    global $cache_userdata;
    if ( empty($cache_userdata[$user_login]) ) {
        $userdata = get_userdatabylogin($user_login);
    } else {
        $userdata = $cache_userdata[$user_login];
    }
    return (md5($user_pass) == $userdata->user_pass);
}


function get_usernumposts($userid) {
    global $wpdb;
    return $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_author = '$userid' AND post_status = 'publish'");
}

// examine a url (supposedly from this blog) and try to
// determine the post ID it represents.
function url_to_postid($url) {
    global $wp_rewrite;

    // First, check to see if there is a 'p=N' or 'page_id=N' to match against:
    preg_match('#[?&](p|page_id)=(\d+)#', $url, $values);
    $id = intval($values[2]);
    if ($id) return $id;

    // URI is probably a permalink.
    $rewrite = $wp_rewrite->wp_rewrite_rules();

    if ( empty($rewrite) )
        return 0;

    $req_uri = $url;

    if ( false !== strpos($req_uri, get_settings('home')) ) {
        $req_uri = str_replace(get_settings('home'), '', $req_uri);
    } else {
        $home_path = parse_url(get_settings('home'));
        $home_path = $home_path['path'];
        $req_uri = str_replace($home_path, '', $req_uri);
    }

    $req_uri = trim($req_uri, '/');
    $request = $req_uri;
    
    // Look for matches.
    $request_match = $request;
    foreach ($rewrite as $match => $query) {
        // If the requesting file is the anchor of the match, prepend it
        // to the path info.
        if ((! empty($req_uri)) && (strpos($match, $req_uri) === 0)) {
            $request_match = $req_uri . '/' . $request;
        }

        if (preg_match("!^$match!", $request_match, $matches)) {
            // Got a match.
            // Trim the query of everything up to the '?'.
            $query = preg_replace("!^.+\?!", '', $query);
            
            // Substitute the substring matches into the query.
            eval("\$query = \"$query\";");
            $query = new WP_Query($query);
            if ( !empty($query->post) )
                return $query->post->ID;
            else
                return 0;
        }
    }

    return 0;
}


/* Options functions */

function get_settings($setting) {
  global $wpdb, $cache_settings, $cache_nonexistantoptions;
    if ( strstr($_SERVER['REQUEST_URI'], 'wp-admin/install.php') || defined('WP_INSTALLING') )
        return false;

    if ( empty($cache_settings) )
        $cache_settings = get_alloptions();

    if ( empty($cache_nonexistantoptions) )
        $cache_nonexistantoptions = array();

    if ('home' == $setting && '' == $cache_settings->home)
        return apply_filters('option_' . $setting, $cache_settings->siteurl);

    if ( isset($cache_settings->$setting) ) :
        return apply_filters('option_' . $setting, $cache_settings->$setting);
    else :
        // for these cases when we're asking for an unknown option
        if ( isset($cache_nonexistantoptions[$setting]) )
            return false;

        $option = $wpdb->get_var("SELECT option_value FROM $wpdb->options WHERE option_name = '$setting'");

        if (!$option) :
            $cache_nonexistantoptions[$setting] = true;
            return false;
        endif;

        @ $kellogs = unserialize($option);
        if ($kellogs !== FALSE)
            return apply_filters('option_' . $setting, $kellogs);
        else return apply_filters('option_' . $setting, $option);
    endif;
}

function get_option($option) {
    return get_settings($option);
}

function form_option($option) {
    echo htmlspecialchars( get_option($option), ENT_QUOTES );
}

function get_alloptions() {
    global $wpdb, $wp_queries;
    $wpdb->hide_errors();
    if (!$options = $wpdb->get_results("SELECT option_name, option_value FROM $wpdb->options WHERE autoload = 'yes'")) {
        $options = $wpdb->get_results("SELECT option_name, option_value FROM $wpdb->options");
    }
    $wpdb->show_errors();

    foreach ($options as $option) {
        // "When trying to design a foolproof system, 
        //  never underestimate the ingenuity of the fools :)" -- Dougal
        if ('siteurl' == $option->option_name) $option->option_value = preg_replace('|/+$|', '', $option->option_value);
        if ('home' == $option->option_name) $option->option_value = preg_replace('|/+$|', '', $option->option_value);
        if ('category_base' == $option->option_name) $option->option_value = preg_replace('|/+$|', '', $option->option_value);
        @ $value = unserialize($option->option_value);
        if ($value === FALSE)
            $value = $option->option_value;
        $all_options->{$option->option_name} = apply_filters('pre_option_' . $option->option_name, $value);
    }
    return apply_filters('all_options', $all_options);
}

function update_option($option_name, $newvalue) {
    global $wpdb, $cache_settings;
    if ( is_array($newvalue) || is_object($newvalue) )
        $newvalue = serialize($newvalue);

    $newvalue = trim($newvalue); // I can't think of any situation we wouldn't want to trim

    // If the new and old values are the same, no need to update.
    if ($newvalue == get_option($option_name)) {
        return true;
    }

    // If it's not there add it
    if ( !$wpdb->get_var("SELECT option_name FROM $wpdb->options WHERE option_name = '$option_name'") )
        add_option($option_name);

    $newvalue = $wpdb->escape($newvalue);
    $wpdb->query("UPDATE $wpdb->options SET option_value = '$newvalue' WHERE option_name = '$option_name'");
    $cache_settings = get_alloptions(); // Re cache settings
    return true;
}


// thx Alex Stapleton, http://alex.vort-x.net/blog/
function add_option($name, $value = '', $description = '', $autoload = 'yes') {
    global $wpdb;
    $original = $value;
    if ( is_array($value) || is_object($value) )
        $value = serialize($value);

    if( !$wpdb->get_var("SELECT option_name FROM $wpdb->options WHERE option_name = '$name'") ) {
        $name = $wpdb->escape($name);
        $value = $wpdb->escape($value);
        $description = $wpdb->escape($description);
        $wpdb->query("INSERT INTO $wpdb->options (option_name, option_value, option_description, autoload) VALUES ('$name', '$value', '$description', '$autoload')");

        if($wpdb->insert_id) {
            global $cache_settings;
            $cache_settings->{$name} = $original;
        }
    }
    return;
}

function delete_option($name) {
    global $wpdb;
    // Get the ID, if no ID then return
    $option_id = $wpdb->get_var("SELECT option_id FROM $wpdb->options WHERE option_name = '$name'");
    if (!$option_id) return false;
    $wpdb->query("DELETE FROM $wpdb->options WHERE option_name = '$name'");
    return true;
}

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

    $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;

    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'");
    } else {
        $wpdb->query("DELETE FROM $wpdb->postmeta WHERE post_id = '$post_id'
AND meta_key = '$key' AND meta_value = '$value'");
    }
        
    return true;
}

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

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

    $metalist = $wpdb->get_results("SELECT meta_value FROM $wpdb->postmeta WHERE post_id = '$post_id' AND meta_key = '$key'", ARRAY_N);

    $values = array();
    if ($metalist) {
        foreach ($metalist as $metarow) {
            $values[] = $metarow[0];
        }
    }

    if ($single) {
        if (count($values)) {
            return $values[0];
        } else {
            return '';
        }
    } else {
        return $values;
    }
}

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

        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'");
    } else {
        $wpdb->query("UPDATE $wpdb->postmeta SET meta_value = '$value' WHERE
meta_key = '$key' AND post_id = '$post_id' AND meta_value = '$prev_value'");
    }

    return true;
}

// Deprecated.  Use get_post().
function get_postdata($postid) {
    $post = &get_post($postid);
    
    $postdata = array (
        'ID' => $post->ID, 
        'Author_ID' => $post->post_author, 
        'Date' => $post->post_date, 
        'Content' => $post->post_content, 
        'Excerpt' => $post->post_excerpt, 
        'Title' => $post->post_title, 
        'Category' => $post->post_category,
        'post_status' => $post->post_status,
        'comment_status' => $post->comment_status,
        'ping_status' => $post->ping_status,
        'post_password' => $post->post_password,
        'to_ping' => $post->to_ping,
        'pinged' => $post->pinged,
        'post_name' => $post->post_name
    );

    return $postdata;
}

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