X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fhomonymes.php;h=90e106a314f728d34b0af0ad937492edf932e976;hb=12a587df92f7bc9efeb91c1a2d27f763070b8609;hp=fb8d50ac0fe33cc86ea84bc558592c8021175029;hpb=50a40a33a496131e817df875607ea5542d096a64;p=platal.git diff --git a/bin/cron/homonymes.php b/bin/cron/homonymes.php index fb8d50a..90e106a 100755 --- a/bin/cron/homonymes.php +++ b/bin/cron/homonymes.php @@ -1,7 +1,7 @@ -#!/usr/bin/php4 -q +#!/usr/bin/php5 -q xdb->iterator("SELECT id, alias, expire FROM aliases WHERE (expire = NOW() + $W_PERIOD OR expire <= NOW()) AND type = 'alias'"); +$resRobot = XDB::iterator("SELECT id, alias, expire FROM aliases WHERE (expire = NOW() + $W_PERIOD OR expire <= NOW()) AND type = 'alias'"); if ($resRobot->total()) { require_once('validations/homonymes.inc.php'); while ($old = $resRobot->next()) { - $res = $globals->xdb->query("SELECT alias AS forlife FROM homonymes INNER JOIN aliases ON(user_id = id) WHERE homonyme_id = {?} AND type='a_vie'", $old['id']); - $forlifes = $res->fetchColumn(); - $req = new HomonymeReq($old['id'], $old['alias'], $forlifes, $old['expire'] > date("Y-m-d")); + $res = XDB::query("SELECT alias AS forlife FROM homonymes INNER JOIN aliases ON(user_id = id) WHERE homonyme_id = {?} AND type='a_vie'", $old['id']); + $forlifes = $res->fetchColumn(); + + $user = User::getSilent($old['id']); + $req = new HomonymeReq($user, $old['alias'], $forlifes, $old['expire'] > date("Y-m-d")); $req->submit(); } } +// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8: ?>