X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fnotifs.birthday.php;h=f783d78b3bb0ad8e67acd6ae5c6c0bf5f2a3769b;hb=684195f33b11e3067200dd3a9e14304bd7d04463;hp=7a6098a89b2e8f91059b159781cf0ac9f195b97e;hpb=50a40a33a496131e817df875607ea5542d096a64;p=platal.git

diff --git a/bin/cron/notifs.birthday.php b/bin/cron/notifs.birthday.php
index 7a6098a..f783d78 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
 <?php
 /***************************************************************************
- *  Copyright (C) 2003-2006 Polytechnique.org                              *
+ *  Copyright (C) 2003-2010 Polytechnique.org                              *
  *  http://opensource.polytechnique.org/                                   *
  *                                                                         *
  *  This program is free software; you can redistribute it and/or modify   *
@@ -22,14 +22,16 @@
 
 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);
-
-$globals->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");
-
+$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:
 ?>