Update user role for expired membership

Question

Is it possible to use a function in functions.php that would automatically change user role when a membership goes from status "active" to "expired" ?

For example : if an active membership switches to expired, I want the user role to change automatically from "Subscriber" to "Blocked" for the concerned user.

I've tried the following hook but it's not doing anything when I update the user membership to expired. I think my problem comes from the meta data "expired" which is registered on table "rcp_membership" (field "status") and not on "usermeta" table.

add_action( 'profile_update', 'my_profile_update', 10, 2 );

function my_profile_update( $user_id, $old_user_data ) {

  if( get_the_author_meta( "rcp_status", $user_id ) == "expired") {
     $u = new WP_User( $user_id );
     $u->set_role('blocked');
   }
}

And data I have to update (what I try through function "set_role()" in the code) is in the database table "metadata", with this SQL request :

UPDATE `wp_usermeta` SET `meta_value` = 'a:1:{s:11:\"bbp_blocked\";b:1;}' WHERE `wp_usermeta`.`user_id` = 29;

Answer 1

If you need to get the value of a field in a custom database table you can try using an SQL query. You'll have to check the column or table name to construct final version of the query.

add_action( 'profile_update', 'my_profile_update', 10, 2 );
function my_profile_update( $user_id, $old_user_data ) {

    global $wpdb;
    $status = $wpdb->get_var( $wpdb->prepare(
        " SELECT rcp_status FROM rcp_membership WHERE ID = %d ",
        $user_id
    ) );

    if( $status == "expired") {
        $new_role = array( 'bbp_blocked' => 1 );
        $data = serialize( $new_role ); 
        $updated = update_user_meta( $user_id, 'wp_capabilities', $data );

        // check and make sure the stored value matches $new_role.
        if ( $data != get_user_meta( $user_id, 'wp_capabilities', true ) ) {
            wp_die( __( 'user role not updated', 'textdomain' ) );
        }
    }

}