From 2bc5effcd31c8d569eab9dda69f9468b53be5a92 Mon Sep 17 00:00:00 2001 From: Florent Bruneau Date: Sun, 8 Jun 2008 18:40:59 +0200 Subject: [PATCH] Birthday cron remove old entries (Closes #831) Signed-off-by: Florent Bruneau --- bin/cron/notifs.birthday.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/bin/cron/notifs.birthday.php b/bin/cron/notifs.birthday.php index ca27d84..542f67f 100755 --- a/bin/cron/notifs.birthday.php +++ b/bin/cron/notifs.birthday.php @@ -26,6 +26,9 @@ $date = date('Y-m-d', time() + 7 * 24*60*60); $stamp = date('Ymd000000'); $like = date('%-m-d', time() + 7 * 24*60*60); +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 -- 2.1.4