X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fnotifs.birthday.php;h=7c50fd12489b6abe5cd73992268bc63433b64057;hb=03bda5524bd16c5c160a314d42baefe0b3254c62;hp=2bad4c975b862f4b5054f3862ea88ad5465148d3;hpb=9f5bd98e936d8cef7ca9f774eeef64dbb8a1b079;p=platal.git

diff --git a/bin/cron/notifs.birthday.php b/bin/cron/notifs.birthday.php
index 2bad4c9..7c50fd1 100755
--- a/bin/cron/notifs.birthday.php
+++ b/bin/cron/notifs.birthday.php
@@ -20,20 +20,18 @@
  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  ***************************************************************************/
 
-require('./connect.db.inc.php');
-
-$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
-                    WHERE  naissance LIKE '$like' AND deces=0");
+require './connect.db.inc.php';
 
+$it = 0;
+do {
+    XDB::execute('UPDATE  profiles
+                     SET  next_birthday = DATE_ADD(next_birthday, INTERVAL 1 YEAR)
+                   WHERE  (next_birthday != 0 AND next_birthday IS NOT NULL AND next_birthday < CURDATE())
+                           AND deathdate IS NULL');
+    ++$it;
+    $affected = XDB::affectedRows();
+    //echo "Iteration $it => $affected changes\n";
+} while ($affected > 0);
 
 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
 ?>