Title: miscon2's Replies | WordPress.org

---

# miscon2

  [  ](https://wordpress.org/support/users/miscon2/)

 *   [Profile](https://wordpress.org/support/users/miscon2/)
 *   [Topics Started](https://wordpress.org/support/users/miscon2/topics/)
 *   [Replies Created](https://wordpress.org/support/users/miscon2/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/miscon2/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/miscon2/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/miscon2/engagements/)
 *   [Favorites](https://wordpress.org/support/users/miscon2/favorites/)

 Search replies:

## Forum Replies Created

Viewing 1 replies (of 1 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [What function updates user_status, spam and deleted column?](https://wordpress.org/support/topic/what-function-updates-user_status-spam-and-deleted-column/)
 *  [miscon2](https://wordpress.org/support/users/miscon2/)
 * (@miscon2)
 * [13 years, 8 months ago](https://wordpress.org/support/topic/what-function-updates-user_status-spam-and-deleted-column/#post-2769557)
 * I just ran into this myself and found the same thing for user_status. wp_update_user()
   won’t change user_status.
 * From other threads I see that user_status is effectively a “dead” field. It remains
   in the wp_user table, but isn’t used by WP itself for anything anymore. Probably
   explains why wp_update_user doesn’t touch it.
 * Regardless, my solution was just using wpdb to write a direct SQL call to update
   the user_status field:
 *     ```
       global $wpdb;
       $wpdb->query('UPDATE wp_users SET user_status = 1 WHERE ID = '.$current_user->ID);
       ```
   
 * Note that I’m setting an explicit internal value here via code. If you’re setting
   values based on user input, don’t use a literal SQL string as I’ve done above.
   Instead use one of the many secure SQL-generating functions detailed on this 
   page:
 * [http://codex.wordpress.org/Class_Reference/wpdb](http://codex.wordpress.org/Class_Reference/wpdb)

Viewing 1 replies (of 1 total)