afaik – last-activity is no longer stored in the usermeta table.
For the first issue, look at the {prefix}_bp_activity table.
I would just write a custom $wpdb->get_col query that gets the user_id for type=’last_activity’ and date_recorded < NOW() + INTERVAL -60 DAY in the desired range.
The result will be a one-dimensional array of user ids – but it will not factor in user roles.
If roles are important, then write another query that just returns IDs based on role and the array returned by the first query. $user_query = new WP_User_Query( array( 'role' => 'contributor', 'fields' => 'ID'. 'include' => $array_from_first_query ) );
Again – that data is in the WP table for user meta. That table name does not have a bp_ in it. There will be a separate row for each notification setting for each user.
It looks like your user name is being changed – and that is not typically allowed in WP.
So that behavior is specific to your site.
You need to find the code that is changing your username.
Can you still log into the site with your original user name?
By going to the Groups page, typically at yoursite.com/groups/
That page will list all Public and Private groups, and should show a Join or Join Request button.
Use these functions in your custom code after the user is added and their ID exists:
Add user to a group: groups_join_group( $group_id, $user_id );
Make user active on the site: bp_update_user_last_activity( $user_id );
> This requires that the site admin be able to add a validated member without the user log in.
So they can make the payment without signing up as a WordPress user on your site?
If they don’t have a login name, then they don’t have an ID and cannot be added to a group – by any method.
If they do have a WP login name, then you can add them in wp-admin.
Go to Groups, mouse-over a Group Name and click Edit.
On the Edit screen you will see this section: Add New Members.
add_filter( 'wp_mail_from', 'custom_wp_mail_from' );
function custom_wp_mail_from( $original_email_address ) {
//Make sure the email is from the same domain
//as your website to avoid being marked as spam.
return 'webmaster@mydomainname.com';
}
