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

    (@cptoverlord)

    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(“UPDATEwp015_usermetaSETmeta_value='{$capnew}’ WHEREwp015_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.