X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fhomonymes.php;h=9cfc622146403ff4bdf3e3c2447ab71335c46880;hb=8dd15edbdf4930b2d549f88c5532cfd4d94b1a8f;hp=fb8d50ac0fe33cc86ea84bc558592c8021175029;hpb=50a40a33a496131e817df875607ea5542d096a64;p=platal.git diff --git a/bin/cron/homonymes.php b/bin/cron/homonymes.php index fb8d50a..9cfc622 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']); + $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(); $req = new HomonymeReq($old['id'], $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: ?>