www programming

Code: Select all

== Changelog ==

= 2.6.7 =
*Release Date - 16 Dec, 2022*
* Fix: wp_login hook not firing when on wp_login page (when certain plugins installed)
* Fix: little improve last_topics and last_topics_by_forums_ids shorcodes code
* Fix: add cookie samesite param for the phpBB session cookie when on Php 7.4 or better, while leave the old setcookie code for all others olders Php versions
* Fix: minor fixes
* Hint: remember that instead to use the page-forum for the iframe integration, on the new WP templates editor, and themes like WP Twenty Twenty Three, you should use the Awesome iframe integration using shortcode: https://www.axew3.com/w3/2022/02/the-awesome-iframe-template-integration-using-shortcode/

Code: Select all

           if(current_user_can('mepr-active','rules:111')){
             echo 'yes MEPR membership2 active, move this user to a phpBB group'; exit;
           } else { remove the user from a group }

Code: Select all

   #$uid = $w3all_phpbb_connection->get_var("SELECT user_id FROM ".$w3all_config["table_prefix"]."users WHERE LOWER(user_email) = '$old_user_data->user_email'");
   $phpbbug = $w3all_phpbb_connection->get_results("SELECT user_id, group_id FROM ".$w3all_config["table_prefix"]."users WHERE LOWER(user_email) = '$old_user_data->user_email'");
     
     if(empty($phpbbug[0])){ return; } // if the user (still?) do not exist
 
   $uid  = $phpbbug[0]->user_id;
   $ugid = $phpbbug[0]->group_id;

############################################
### START
# Roles -> Groups switches
  
  // **** MemberPress: (do not know if it is a bug of the version i am testing) but when an user is set as NoRole in WordPress,
  // set/leave the user as subscriber by the way. 
  // So that it is necessary another way to detect that the user may have no active mepr subscriptions/memberships and deactivate the user in phpBB if the case
  
  // ** note that here, may you would add memberships from external wp plugins and more complex roles/groups/memberships switches
   include( WPW3ALL_PLUGIN_DIR.'common/wpRoles_phpbbGroups.php' );
   
  // before we check if this user has been set as NoRole in WP    
     if( empty($wpu->roles) )
      { // no role for this site, deactivate in phpBB
        $w3all_phpbb_connection->query("UPDATE ".$w3all_config["table_prefix"]."users SET user_type = '1' WHERE user_id = '$uid'");
      }
   
  // if old user's data role do not match, then there is an user role change: update/activate in phpBB based on Roles/Groups array
  // check that the user had a role before 
   if( empty($old_user_data->roles[0]) && !empty($wpu->roles) && !empty($wpRoles_phpBBGroups) 
       OR !empty($wpu->roles) && $old_user_data->roles[0] != $wpu->roles[0] && !empty($wpRoles_phpBBGroups) ) // **
   { // retrieve all groups which the user belong to (for more complex roles/groups switches)
     $uid_groups = $w3all_phpbb_connection->get_results("SELECT * FROM ".$w3all_config["table_prefix"]."user_group WHERE user_id = $uid");

       if( $wpu->roles[0] == 'subscriber' OR $wpu->roles[0] == 'contributor' )
       {
     	   if( $ugid != 2 )
     	   {
     	 	  $w3all_phpbb_connection->query("UPDATE ".$w3all_config["table_prefix"]."users SET user_type = '0', group_id = '2' WHERE user_id = '$uid'");
      	  // on duplicate key is not possible, there is no index into the user_group table: remove the record if exist before to insert again
      	  // even if the user_group table can contain duplicated values
      	  // *** also note that here, may the phpBB user should be removed from any other group, which may belong to into phpBB 
      	  $w3all_phpbb_connection->query("DELETE FROM ".$w3all_config["table_prefix"]."user_group WHERE user_id = '$uid' AND group_id IN('2','$ugid')");
          $w3all_phpbb_connection->query("INSERT INTO ".$w3all_config["table_prefix"]."user_group (group_id, user_id, group_leader, user_pending) VALUES ('2','$uid','0','0')");
     	   } 
     	 } elseif( $wpu->roles[0] == 'editor' && $ugid != 4 )
         {
     	 	  $w3all_phpbb_connection->query("UPDATE ".$w3all_config["table_prefix"]."users SET user_type = '0', group_id = '4' WHERE user_id = '$uid'");
      	  // same as above
      	  $w3all_phpbb_connection->query("DELETE FROM ".$w3all_config["table_prefix"]."user_group WHERE user_id = '$uid' AND group_id IN('4','$ugid')");
          $w3all_phpbb_connection->query("INSERT INTO ".$w3all_config["table_prefix"]."user_group (group_id, user_id, group_leader, user_pending) VALUES ('4','$uid','0','0')");
       	  } elseif( $wpu->roles[0] == 'administrator' && $ugid != 5 )
            {
     	 	     $w3all_phpbb_connection->query("UPDATE ".$w3all_config["table_prefix"]."users SET user_type = '0', group_id = '5' WHERE user_id = '$uid'");
      	     // same as above
      	     $w3all_phpbb_connection->query("DELETE FROM ".$w3all_config["table_prefix"]."user_group WHERE user_id = '$uid' AND group_id IN('5','$ugid')");
             $w3all_phpbb_connection->query("INSERT INTO ".$w3all_config["table_prefix"]."user_group (group_id, user_id, group_leader, user_pending) VALUES ('5','$uid','0','0')");
       	    }
    }

     # if(current_user_can('mepr-active','rules:111')){
     #  # the user belong and is active on mepr Rule ID 111
     # }
     
# Roles -> Groups switches
### END
############################################