function user_relationships_api_update_7 in User Relationships 5.3

File

user_relationships_api/user_relationships_api.install, line 209

Code

function user_relationships_api_update_7() {
  global $db_type;
  $ret = array();
  $ids = array();
  if (strpos($db_type, 'mysql') !== FALSE || $db_type == 'pgsql') {
    $results = db_query(" SELECT ur_1.rid AS ur_1, ur_2.rid AS ur_2 \n        FROM {user_relationships} ur_1 \n          JOIN {user_relationships} ur_2 ON ur_1.rtid = ur_2.rtid \n            AND ur_1.requester_id = ur_2.requestee_id \n            AND ur_1.requestee_id = ur_2.requester_id\n      ");
    while ($result = db_fetch_object($results)) {
      if (!isset($ids[$result->ur_1])) {
        $ids[$result->ur_1] = $result->ur_2;
        $ids[$result->ur_2] = $result->ur_1;
        $ret[] = update_sql("UPDATE {user_relationships} SET rid = {$result->ur_1} WHERE rid = {$result->ur_2}");
      }
    }
  }
  else {
    drupal_set_message(t('Unsupported database.'));
  }
  return $ret;
}