#!/usr/bin/php5 -q
<?php
/***************************************************************************
- * Copyright (C) 2003-2011 Polytechnique.org *
+ * Copyright (C) 2003-2014 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
***************************************************************************/
/**
- * Requires destruction of aliases: a first notification 10 days before
+ * Requires destruction of aliases: a first notification 7 days before
* destruction, a second on the date.
*/
require 'connect.db.inc.php';
$resRobot = XDB::iterator("SELECT uid, email, expire
FROM email_source_account
- WHERE (expire = NOW() + INTERVAL 7 DAY OR expire <= NOW())");
+ WHERE expire <= NOW() + INTERVAL 7 DAY");
while ($old = $resRobot->next()) {
$res = XDB::query('SELECT a.hruid
FROM homonyms_list AS h
INNER JOIN accounts AS a ON (h.uid = a.uid)
- WHERE hrmid = {?}',
- 'h.' . $old['email'] . '.polytechnique.org');
+ WHERE h.hrmid = {?}',
+ User::makeHomonymHrmid($old['email']));
$hruids = $res->fetchColumn();
$homonym = User::getSilent($old['uid']);
$req->submit();
}
-// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
+// vim:set et sw=4 sts=4 sws=4 foldmethod=marker fenc=utf-8:
?>