XDB::execute("UPDATE aliases
SET type = 'homonyme', expire=NOW()
WHERE alias = {?}", $loginbis);
- XDB::execute("REPLACE INTO homonyms (homonyme_id, uid)
- VALUES ({?}, {?})", $target, $target);
+ XDB::execute('INSERT IGNORE INTO homonyms (homonyme_id, uid)
+ VALUES ({?}, {?})', $target, $target);
send_robot_homonyme($user, $loginbis);
$op = 'list';
$page->trigSuccess('Email envoyé à ' . $user->forlifeEmail() . ', alias supprimé.');
$hide[] = $cat;
}
$hide_requests = join(',', $hide);
- XDB::query('REPLACE INTO requests_hidden (uid, hidden_requests)
- VALUES ({?}, {?})',
+ XDB::query('INSERT INTO requests_hidden (uid, hidden_requests)
+ VALUES ({?}, {?})
+ ON DUPLICATE KEY UPDATE hidden_requests = VALUES(hidden_requests)',
S::v('uid'), $hide_requests);
} elseif ($hide_requests) {
foreach (explode(',', $hide_requests) as $hide_type)