function user_relationships_update_7 in User Relationships 5.2
File
- ./
user_relationships.install, line 213
Code
function user_relationships_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;
}