Managing user meta

We’ve developed a custom reports plugin, which uses s2 member meta fields (we have roughly 100 fields per user, and 7000 users) – due to the storage of s2 meta (serialized arrays in a DB), we can’t effectively search across them without inaccurate(i.e. – doing a LIKE won’t work) or extremely long running queries (selecting and looping through PHP side), as such we’ve resorted to storing the s2 user meta into the wp_usermeta table as well – while this seems absurd to store it in two places, it’s allowed us to query the data much more efficiently, unfortunately we’ve found a few cases where the user meta does not match the s2 user meta, so there must be some way s2 is updating/inserting that we’re not catching. These are the current hooks we use to duplicate the s2 usermeta into actual user meta:
‘ws_plugin__s2member_during_configure_user_registration_front_side’
‘ws_plugin__s2member_during_configure_user_registration_admin_side’
‘ws_plugin__s2member_after_handle_profile_modifications’
‘ws_plugin__s2member_during_users_list_update_cols’

Are there any other hooks that we can use to be absolutely sure when an s2 user meta field gets added or updated, we add it to regular wp usermeta?

Thanks!

Thanks for your inquiry. ~ We appreciate your patience :-)

Are there any other hooks that we can use to be absolutely sure when an s2 user meta field gets added or updated, we add it to regular wp usermeta?

I’m sorry, I can’t offer any filters for this. This is not something that filters are designed to handle (i.e. synchronizing DB column values). Even if you found a way to capture every single possibility, it’s likely to change from one release of the software to the next.

Just to point out. While certainly NOT ideal, it IS possible to search serialized data as it exists already. Please see the example below, where we use MySQL’s REGEXP search.

Ex: `meta_value` REGEXP '.*\"country_code\";s:[0-9]+:\"US\".*'

<?php
global $wpdb;
$users = $wpdb->get_results ("SELECT `user_id` as `ID` FROM `" . $wpdb->usermeta . "` WHERE `meta_key` = '" . $wpdb->prefix . "s2member_custom_fields' AND `meta_value` REGEXP '.*\"country_code\";s:[0-9]+:\"US\".*'");
if (is_array ($users) && count ($users) > 0)
    {
        foreach ($users as $user)
            {
                $user = new WP_User ($user->ID); // Get full User object now.
                print_r($user); // Get a full list of properties when/if debugging.
            }
    }