X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fhomonymes.php;h=1530531eb344cc8a0c0043a0345ce165ce139984;hb=c974e61c78efb98c0cbe81aa78bfdc47f3c31ead;hp=1c1349dc28ba0260c2468d3460eb3091b2b1e809;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git diff --git a/bin/cron/homonymes.php b/bin/cron/homonymes.php index 1c1349d..1530531 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: ?>