X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=include%2Fnotifs.inc.php;h=58d214cd1f0c42c4ac51e95ad998b3ad529d3ebe;hb=f3a7456dbe1cbe78dfe0ccc2e99c299ad97203c5;hp=eb70cc89ad1fded60a0d0833fdd7bc5b47a5c8ba;hpb=25fe4c85de79aa601948d788b5754b5b6070080d;p=platal.git diff --git a/include/notifs.inc.php b/include/notifs.inc.php index eb70cc8..58d214c 100644 --- a/include/notifs.inc.php +++ b/include/notifs.inc.php @@ -34,25 +34,33 @@ function inscription_notifs_base($uid) // }}} // {{{ function register_watch_op -function register_watch_op($uid, $cid, $date='', $info='') +function register_watch_op($uid, $cid, $date = '', $info = '') { if (empty($date)) { $date = date('Y-m-d'); - }; - XDB::execute('REPLACE INTO watch_ops (uid,cid,known,date,info) + } + XDB::execute('REPLACE INTO watch_ops (uid, cid, known, date, info) VALUES ({?}, {?}, NOW(), {?}, {?})', $uid, $cid, $date, $info); - if($cid == WATCH_FICHE) { + if ($cid == WATCH_FICHE) { if ($info) { register_profile_update($uid, $info); } - XDB::execute('UPDATE auth_user_md5 SET DATE=NOW() WHERE user_id={?}', $uid); - } elseif($cid == WATCH_INSCR) { - XDB::execute('REPLACE INTO contacts (uid,contact) - SELECT uid,ni_id + XDB::execute('UPDATE auth_user_md5 + SET DATE = NOW() + WHERE user_id = {?}', $uid); + } elseif ($cid == WATCH_INSCR) { + XDB::execute('REPLACE INTO contacts (uid, contact) + SELECT uid, ni_id FROM watch_nonins - WHERE ni_id={?}', $uid); - XDB::execute('DELETE FROM watch_nonins WHERE ni_id={?}', $uid); + WHERE ni_id = {?}', $uid); + XDB::execute('DELETE FROM watch_nonins + WHERE ni_id = {?}', $uid); + } elseif ($cid == WATCH_DEATH) { + // We delete nonins watches both for the dead (if non registered), and + // for people watched by the dead. + XDB::execute('DELETE FROM watch_nonins + WHERE ni_id = {?} OR uid = {?}', $uid); } Platal::session()->updateNbNotifs(); }