root/branches/2.0/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[USER_COOKIE]);
    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 ( -1 == $i || false == $i )
        $i = 0;

    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;
    $userid = (int) $userid;
    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;

    // Check to see if we are using rewrite rules
    $rewrite = $wp_rewrite->wp_rewrite_rules();

    // Not using rewrite rules, and 'p=N' and 'page_id=N' methods failed, so we're out of options
    if ( empty($rewrite) )
        return 0;

    // $url cleanup by Mark Jaquith
    // This fixes things like #anchors, ?query=strings, missing 'www.',
    // added 'www.', or added 'index.php/' that will mess up our WP_Query
    // and return a false negative

    // Get rid of the #anchor
    $url_split = explode('#', $url);
    $url = $url_split[0];

    // Get rid of URI ?query=string
    $url_split = explode('?', $url);
    $url = $url_split[0];

    // Add 'www.' if it is absent and should be there
    if ( false !== strpos(get_settings('home'), '://www.') && false === strpos($url, '://www.') )
        $url = str_replace('://', '://www.', $url);

    // Strip 'www.' if it is present and shouldn't be
    if ( false === strpos(get_settings('home'), '://www.') )
        $url = str_replace('://www.', '://', $url);

    // Strip 'index.php/' if we're not using path info permalinks
    if ( false === strpos($rewrite, 'index.php/') )
        $url = str_replace('index.php/', '', $url);

    if ( false !== strpos($url, get_settings('home')) ) {
        // Chop off http://domain.com
        $url = str_replace(get_settings('home'), '', $url);
    } else {
        // Chop off /path/to/blog
        $home_path = parse_url(get_settings('home'));
        $home_path = $home_path['path'];
        $url = str_replace($home_path, '', $url);
    }

    // Trim leading and lagging slashes
    $url = trim($url, '/');

    $request = $url;

    // Done with cleanup

    // 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($url)) && (strpos($match, $url) === 0) ) {
            $request_match = $url . '/' . $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 ( $query->is_single || $query->is_page )
                return $query->post->ID;
            else
                return 0;
        }
    }
    return 0;
}


function maybe_unserialize($original) {
    if ( is_serialized($original) ) // don't attempt to unserialize data that wasn't serialized going in
        if ( false !== $gm = @ unserialize($original) )
            return $gm;
    return $original;
}

function maybe_serialize($data) {
    if ( is_string($data) )
        $data = trim($data);
    elseif ( is_array($data) || is_object($data) )
        return serialize($data);
    if ( is_serialized($data) )
        return serialize($data);
    return $data;
}

function is_serialized($data) {
    if ( !is_string($data) ) // if it isn't a string, it isn't serialized
        return false;
    $data = trim($data);
    if ( preg_match("/^[adobis]:[0-9]+:.*[;}]/si",$data) ) // this should fetch all legitimately serialized data
        return true;
    return false;
}

function is_serialized_string($data) {
    if ( !is_string($data) ) // if it isn't a string, it isn't a serialized string
        return false;
    $data = trim($data);
    if ( preg_match("/^s:[0-9]+:.*[;}]/si",$data) ) // this should fetch all serialized strings
        return true;
    return false;
}

/* Options functions */

// expects $setting to already be SQL-escaped
function get_settings($setting) {
    global $wpdb;

    $value = wp_cache_get($setting, 'options');

    if ( false === $value ) {
        if ( defined('WP_INSTALLING') )
            $wpdb->hide_errors();
        $row = $wpdb->get_row("SELECT option_value FROM $wpdb->options WHERE option_name = '$setting' LIMIT 1");
        if ( defined('WP_INSTALLING') )
            $wpdb->show_errors();

        if( is_object( $row) ) { // Has to be get_row instead of get_var because of funkiness with 0, false, null values
            $value = $row->option_value;
            wp_cache_set($setting, $value, 'options');
        } else {
            return false;
        }
    }

    // If home is not set use siteurl.
    if ( 'home' == $setting && '' == $value )
        return get_settings('siteurl');

    if ( 'siteurl' == $setting || 'home' == $setting || 'category_base' == $setting )
        $value = preg_replace('|/+$|', '', $value);

    return apply_filters( 'option_' . $setting, maybe_unserialize($value) );
}

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

function get_user_option( $option, $user = 0 ) {
    global $wpdb;
    
    if ( empty($user) )
        $user = wp_get_current_user();
    else
        $user = get_userdata($user);

    if ( isset( $user->{$wpdb->prefix . $option} ) ) // Blog specific
        return $user->{$wpdb->prefix . $option};
    elseif ( isset( $user->{$option} ) ) // User specific and cross-blog
        return $user->{$option};
    else // Blog global
        return get_option( $option );
}

function form_option($option) {
    echo attribute_escape( get_option($option));
}

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 = maybe_unserialize($option->option_value);
        $all_options->{$option->option_name} = apply_filters('pre_option_' . $option->option_name, $value);
    }
    return apply_filters('all_options', $all_options);
}

// expects $option_name to NOT be SQL-escaped
function update_option($option_name, $newvalue) {
    global $wpdb;

    $safe_option_name = $wpdb->escape($option_name);

    if ( is_string($newvalue) )
        $newvalue = trim($newvalue);

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

    if ( false === $oldvalue ) {
        add_option($option_name, $newvalue);
        return true;
    }

    $_newvalue = $newvalue;
    $newvalue = maybe_serialize($newvalue);

    wp_cache_set($option_name, $newvalue, 'options');

    $newvalue = $wpdb->escape($newvalue);
    $option_name = $wpdb->escape($option_name);
    $wpdb->query("UPDATE $wpdb->options SET option_value = '$newvalue' WHERE option_name = '$option_name'");
    if ( $wpdb->rows_affected == 1 ) {
        do_action("update_option_{$option_name}", array('old'=>$oldvalue, 'new'=>$_newvalue));
        return true;
    }
    return false;
}

function update_user_option( $user_id, $option_name, $newvalue, $global = false ) {
    global $wpdb;
    if ( !$global )
        $option_name = $wpdb->prefix . $option_name;
    return update_usermeta( $user_id, $option_name, $newvalue );
}

// thx Alex Stapleton, http://alex.vort-x.net/blog/
// expects $name to NOT be SQL-escaped
function add_option($name, $value = '', $description = '', $autoload = 'yes') {
    global $wpdb;

    $safe_name = $wpdb->escape($name);

    // Make sure the option doesn't already exist
    if ( false !== get_option($safe_name) )
        return;

    $value = maybe_serialize($value);

    wp_cache_set($name, $value, 'options');

    $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')");

    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'");
    wp_cache_delete($name, 'options');
    return true;
}

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

    $post_id = (int)