Bug 335 suppression sans validation du statut orange. Rajout de quelques tests supplé...
[platal.git] / bin / cron / homonymes.php
CommitLineData
0337d704 1#!/usr/bin/php4 -q
2<?php
3/***************************************************************************
4 * Copyright (C) 2003-2004 Polytechnique.org *
5 * http://opensource.polytechnique.org/ *
6 * *
7 * This program is free software; you can redistribute it and/or modify *
8 * it under the terms of the GNU General Public License as published by *
9 * the Free Software Foundation; either version 2 of the License, or *
10 * (at your option) any later version. *
11 * *
12 * This program is distributed in the hope that it will be useful, *
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
15 * GNU General Public License for more details. *
16 * *
17 * You should have received a copy of the GNU General Public License *
18 * along with this program; if not, write to the Free Software *
19 * Foundation, Inc., *
20 * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA *
21 ***************************************************************************/
22/* vim: set sw=4 ts=4 sts=4 tw=100:
23 * crée des demandes de validation pour les kill d'alias
24 * une demande 10 jours avant pour un warning, puis une autre pour le robot
25*/
26
27$W_PERIOD = "INTERVAL 7 DAY"; // temps d'envoi du warning avant la deadline
28
29require('./connect.db.inc.php');
30
31$resRobot = $globals->xdb->iterator("SELECT id, alias, expire FROM aliases WHERE (expire = NOW() + $W_PERIOD OR expire <= NOW()) AND type = 'alias'");
32
33if ($resRobot->total()) {
34 require_once('validations/homonymes.inc.php');
35 while ($old = $resRobot->next()) {
36 $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']);
37 $forlifes = $res->fetchColumn();
38 $req = new HomonymeReq($old['id'], $old['alias'], $forlifes, $old['expire'] > date("Y-m-d"));
39 $req->submit();
40 }
41}
42
43?>