X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=bin%2Fcron%2Fcron_ml_moderate.php;fp=bin%2Fcron%2Fcron_ml_moderate.php;h=32e2ee27e312bcd2ac0e9ed4b428c44f7aae3407;hb=2235cd7f2d11e5b4fdcc4ddd8d4da00a2ae80564;hp=67db63086a05ece2d5303564129a37d432b71f84;hpb=9e8bacfbba170764624f6d3c050c710e398e1dae;p=platal.git diff --git a/bin/cron/cron_ml_moderate.php b/bin/cron/cron_ml_moderate.php index 67db630..32e2ee2 100755 --- a/bin/cron/cron_ml_moderate.php +++ b/bin/cron/cron_ml_moderate.php @@ -29,7 +29,7 @@ $handler = time(); while ($sent_mails < $globals->lists->max_mail_per_min && time() - $handler < 60) { // take a lock on a mail - XDB::execute("UPDATE ml_moderate + XDB::execute("UPDATE email_list_moderate SET handler = {?} WHERE handler IS NULL ORDER BY ts @@ -40,7 +40,7 @@ while ($sent_mails < $globals->lists->max_mail_per_min $query = XDB::query("SELECT nom, prenom, user_id, password, ml, domain, mid, action, message FROM auth_user_md5 AS u - INNER JOIN ml_moderate AS ml ON (u.user_id = ml.uid) + INNER JOIN email_list_moderate AS ml ON (u.user_id = ml.uid) WHERE ml.handler = {?}", $handler); list($nom, $prenom, $uid, $password, $list, $domain, $mid, $action, $reason) = $query->fetchOneRow(); @@ -115,7 +115,7 @@ while ($sent_mails < $globals->lists->max_mail_per_min } // release the lock - XDB::execute("DELETE FROM ml_moderate WHERE handler = {?}", + XDB::execute("DELETE FROM email_list_moderate WHERE handler = {?}", $handler); sleep(60 * $count / $globals->lists->max_mail_per_min); }