function search_api_saved_searches_update_7105 in Search API Saved Searches 7

Disable saved searches whose users were disabled.

File

./search_api_saved_searches.install, line 233

Install, update and uninstall functions for the Search API saved searches module.

Code

function search_api_saved_searches_update_7105() {

  // Get the UIDs of all inactive users.
  $query = db_select('users', 'u');
  $query
    ->fields('u', array(
    'uid',
  ))
    ->condition('u.status', 0)
    ->condition('u.uid', 0, '<>');

  // Then, disable all their searches.
  db_update('search_api_saved_search')
    ->condition('uid', $query, 'IN')
    ->fields(array(
    'enabled' => 0,
  ))
    ->execute();
}