3 function get_profile($field, $user = false) {
6 $user = $wpdb->escape($_COOKIE[USER_COOKIE]);
7 return $wpdb->get_var("SELECT $field FROM $wpdb->users WHERE user_login = '$user'");
10 function get_usernumposts($userid) {
12 $userid = (int) $userid;
13 return $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->posts WHERE post_author = '$userid' AND post_type = 'post' AND " . get_private_posts_cap_sql('post'));
16 // TODO: xmlrpc only. Maybe move to xmlrpc.php.
17 function user_pass_ok($user_login,$user_pass) {
18 global $cache_userdata;
19 if ( empty($cache_userdata[$user_login]) ) {
20 $userdata = get_userdatabylogin($user_login);
22 $userdata = $cache_userdata[$user_login];
24 return (md5($user_pass) == $userdata->user_pass);
28 // User option functions
31 function get_user_option( $option, $user = 0 ) {
35 $user = wp_get_current_user();
37 $user = get_userdata($user);
39 if ( isset( $user->{$wpdb->prefix . $option} ) ) // Blog specific
40 return $user->{$wpdb->prefix . $option};
41 elseif ( isset( $user->{$option} ) ) // User specific and cross-blog
42 return $user->{$option};
44 return get_option( $option );
47 function update_user_option( $user_id, $option_name, $newvalue, $global = false ) {
50 $option_name = $wpdb->prefix . $option_name;
51 return update_usermeta( $user_id, $option_name, $newvalue );
54 // Get users with capabilities for the current blog.
55 // For setups that use the multi-blog feature.
56 function get_users_of_blog( $id = '' ) {
57 global $wpdb, $blog_id;
60 $users = $wpdb->get_results( "SELECT user_id, user_login, display_name, user_email, meta_value FROM $wpdb->users, $wpdb->usermeta WHERE " . $wpdb->users . ".ID = " . $wpdb->usermeta . ".user_id AND meta_key = '" . $wpdb->prefix . "capabilities' ORDER BY {$wpdb->usermeta}.user_id" );
65 // User meta functions
68 function delete_usermeta( $user_id, $meta_key, $meta_value = '' ) {
70 if ( !is_numeric( $user_id ) )
72 $meta_key = preg_replace('|[^a-z0-9_]|i', '', $meta_key);
74 if ( is_array($meta_value) || is_object($meta_value) )
75 $meta_value = serialize($meta_value);
76 $meta_value = trim( $meta_value );
78 if ( ! empty($meta_value) )
79 $wpdb->query("DELETE FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key' AND meta_value = '$meta_value'");
81 $wpdb->query("DELETE FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key'");
83 $user = get_userdata($user_id);
84 wp_cache_delete($user_id, 'users');
85 wp_cache_delete($user->user_login, 'userlogins');
90 function get_usermeta( $user_id, $meta_key = '') {
92 $user_id = (int) $user_id;
97 if ( !empty($meta_key) ) {
98 $meta_key = preg_replace('|[^a-z0-9_]|i', '', $meta_key);
99 $metas = $wpdb->get_results("SELECT meta_key, meta_value FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key'");
101 $metas = $wpdb->get_results("SELECT meta_key, meta_value FROM $wpdb->usermeta WHERE user_id = '$user_id'");
104 if ( empty($metas) ) {
105 if ( empty($meta_key) )
111 foreach ($metas as $meta)
112 $values[] = maybe_unserialize($meta->meta_value);
114 if ( count($values) == 1 )
120 function update_usermeta( $user_id, $meta_key, $meta_value ) {
122 if ( !is_numeric( $user_id ) )
124 $meta_key = preg_replace('|[^a-z0-9_]|i', '', $meta_key);
126 // FIXME: usermeta data is assumed to be already escaped
127 if ( is_string($meta_value) )
128 $meta_value = stripslashes($meta_value);
129 $meta_value = maybe_serialize($meta_value);
130 $meta_value = $wpdb->escape($meta_value);
132 if (empty($meta_value)) {
133 return delete_usermeta($user_id, $meta_key);
136 $cur = $wpdb->get_row("SELECT * FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key'");
138 $wpdb->query("INSERT INTO $wpdb->usermeta ( user_id, meta_key, meta_value )
140 ( '$user_id', '$meta_key', '$meta_value' )");
141 } else if ( $cur->meta_value != $meta_value ) {
142 $wpdb->query("UPDATE $wpdb->usermeta SET meta_value = '$meta_value' WHERE user_id = '$user_id' AND meta_key = '$meta_key'");
147 $user = get_userdata($user_id);
148 wp_cache_delete($user_id, 'users');
149 wp_cache_delete($user->user_login, 'userlogins');
155 // Private helper functions
158 // Setup global user vars. Used by set_current_user() for back compat.
159 function setup_userdata($user_id = '') {
160 global $user_login, $userdata, $user_level, $user_ID, $user_email, $user_url, $user_pass_md5, $user_identity;
162 if ( '' == $user_id )
163 $user = wp_get_current_user();
165 $user = new WP_User($user_id);
167 if ( 0 == $user->ID )
170 $userdata = $user->data;
171 $user_login = $user->user_login;
172 $user_level = (int) $user->user_level;
173 $user_ID = (int) $user->ID;
174 $user_email = $user->user_email;
175 $user_url = $user->user_url;
176 $user_pass_md5 = md5($user->user_pass);
177 $user_identity = $user->display_name;
180 function wp_dropdown_users( $args = '' ) {
183 'show_option_all' => '', 'show_option_none' => '',
184 'orderby' => 'display_name', 'order' => 'ASC',
185 'include' => '', 'exclude' => '',
186 'show' => 'display_name', 'echo' => 1,
187 'selected' => 0, 'name' => 'user', 'class' => ''
190 $defaults['selected'] = is_author() ? get_query_var( 'author' ) : 0;
192 $r = wp_parse_args( $args, $defaults );
193 extract( $r, EXTR_SKIP );
195 $query = "SELECT * FROM $wpdb->users";
197 $query_where = array();
199 if ( is_array($include) )
200 $include = join(',', $include);
201 $include = preg_replace('/[^0-9,]/', '', $include); // (int)
203 $query_where[] = "ID IN ($include)";
205 if ( is_array($exclude) )
206 $exclude = join(',', $exclude);
207 $exclude = preg_replace('/[^0-9,]/', '', $exclude); // (int)
209 $query_where[] = "ID NOT IN ($exclude)";
212 $query .= " WHERE " . join(' AND', $query_where);
214 $query .= " ORDER BY $orderby $order";
216 $users = $wpdb->get_results( $query );
219 if ( !empty($users) ) {
220 $output = "<select name='$name' id='$name' class='$class'>\n";
222 if ( $show_option_all )
223 $output .= "\t<option value='0'>$show_option_all</option>\n";
225 if ( $show_option_none )
226 $output .= "\t<option value='-1'>$show_option_none</option>\n";
228 foreach ( $users as $user ) {
229 $user->ID = (int) $user->ID;
230 $_selected = $user->ID == $selected ? " selected='selected'" : '';
231 $output .= "\t<option value='$user->ID'$_selected>" . wp_specialchars($user->$show) . "</option>\n";
234 $output .= "</select>";
237 $output = apply_filters('wp_dropdown_users', $output);