function ure_direct_site_roles_update($blogIds) { global $wpdb, $table_prefix, $ure_roles, $ure_capabilitiesToSave, $ure_currentRole, $ure_currentRoleName; if (!isset($ure_roles[$ure_currentRole])) { $ure_roles[$ure_currentRole]['name'] = $ure_currentRoleName; } $ure_roles[$ure_currentRole]['capabilities'] = $ure_capabilitiesToSave; $serialized_roles = serialize($ure_roles); foreach ($blogIds as $blog_id) { $prefix = $wpdb->get_blog_prefix($blog_id); $options_table_name = $prefix . 'options'; $option_name = $prefix . 'user_roles'; $query = "update {$options_table_name}\n set option_value='{$serialized_roles}'\n where option_name='{$option_name}'\n limit 1"; $record = $wpdb->query($query); if ($wpdb->last_error) { ure_logEvent($wpdb->last_error, true); return false; } } }
function ure_saveRolesToDb() { global $wpdb, $ure_roles, $ure_capabilitiesToSave, $ure_currentRole, $ure_currentRoleName; $ure_OptionsTable = $wpdb->prefix . 'options'; if (!isset($ure_roles[$ure_currentRole])) { $ure_roles[$ure_currentRole]['name'] = $ure_currentRoleName; } $ure_roles[$ure_currentRole]['capabilities'] = $ure_capabilitiesToSave; $option_name = $wpdb->prefix . 'user_roles'; $serialized_roles = serialize($ure_roles); $query = "update {$ure_OptionsTable}\n set option_value='{$serialized_roles}'\n where option_name='{$option_name}'\n limit 1"; $record = $wpdb->query($query); if ($wpdb->last_error) { ure_logEvent($wpdb->last_error, true); return false; } return true; }