Title: MYSQL capabilities set
Last modified: August 20, 2016

---

# MYSQL capabilities set

 *  [CptOVERLORD](https://wordpress.org/support/users/cptoverlord/)
 * (@cptoverlord)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/mysql-capabilities-set/)
 *     ```
       <?php $user_idby = get_current_user_id();
       if ( is_user_logged_in() == true ) {
       if (!(current_user_can('edit_post'))) {
       $capnew = 'a:1:{s:13:"subscriber";s:1:"1";}';
       $capkey = 'wp010_capabilities';
       global $wpdby;
       $wpdby->query( $wpdby->prepare("UPDATE<code>wp015_usermeta</code>SET<code>meta_value</code>='{$capnew}' WHERE<code>wp015_usermeta</code>.<code>user_id</code>='{$user_idby}' AND meta_key = '{$capkey}'"));
       }
       }?>
       ```
   
 * table: wp015_usermeta
    and i want to set the currect user’s wp010_capabilities
   to a:1:{s:13:”subscriber”;s:1:”1″;}
 * Is my code good?
    Thank you in advance.

Viewing 1 replies (of 1 total)

 *  Thread Starter [CptOVERLORD](https://wordpress.org/support/users/cptoverlord/)
 * (@cptoverlord)
 * [13 years, 9 months ago](https://wordpress.org/support/topic/mysql-capabilities-set/#post-2912013)
 * maybe more readable here:
    <?php $user_idby = get_current_user_id(); if ( is_user_logged_in()
   == true ) { if (!(current_user_can(‘edit_post’))) { $capnew = ‘a:1:{s:13:”subscriber”;
   s:1:”1″;}’; $capkey = ‘wp010_capabilities’; global $wpdby; $wpdby->query( $wpdby-
   >prepare(“UPDATE`wp015_usermeta`SET`meta_value`='{$capnew}’ WHERE`wp015_usermeta`.`
   user_id`='{$user_idby}’ AND meta_key = ‘{$capkey}'”)); } }?>

Viewing 1 replies (of 1 total)

The topic ‘MYSQL capabilities set’ is closed to new replies.

 * 1 reply
 * 1 participant
 * Last reply from: [CptOVERLORD](https://wordpress.org/support/users/cptoverlord/)
 * Last activity: [13 years, 9 months ago](https://wordpress.org/support/topic/mysql-capabilities-set/#post-2912013)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics