X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fnotifs.birthday.php;h=542f67f813babda52d93f7c618150e66560ad243;hb=12a587df92f7bc9efeb91c1a2d27f763070b8609;hp=39d9d373ec50e09f95d4aa7739ceaa350f0c1d15;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git diff --git a/bin/cron/notifs.birthday.php b/bin/cron/notifs.birthday.php index 39d9d37..542f67f 100755 --- a/bin/cron/notifs.birthday.php +++ b/bin/cron/notifs.birthday.php @@ -1,7 +1,7 @@ -#!/usr/bin/php4 -q +#!/usr/bin/php5 -q db->query("INSERT INTO watch_ops (uid, cid, known, date) - SELECT user_id, 4, $stamp, '$date' - FROM auth_user_md5 - WHERE naissance LIKE '$like' AND deces=0"); +XDB::execute("DELETE FROM watch_ops + WHERE cid = 4 AND date < CURDATE()"); +XDB::execute("INSERT INTO watch_ops (uid, cid, known, date) + SELECT user_id, 4, $stamp, '$date' + FROM auth_user_md5 + WHERE naissance LIKE '$like' AND deces=0"); + +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>