Revert "Initial work on the rewriting of the profile/edit page"
[platal.git] / bin / cron / homonymes.php
CommitLineData
ee68ddc1 1#!/usr/bin/php5 -q
0337d704 2<?php
3/***************************************************************************
5ddeb07c 4 * Copyright (C) 2003-2007 Polytechnique.org *
0337d704 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:
a7de4ef7 23 * crée des demandes de validation pour les kill d'alias
0337d704 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
08cce2ff 31$resRobot = XDB::iterator("SELECT id, alias, expire FROM aliases WHERE (expire = NOW() + $W_PERIOD OR expire <= NOW()) AND type = 'alias'");
0337d704 32
33if ($resRobot->total()) {
34 require_once('validations/homonymes.inc.php');
35 while ($old = $resRobot->next()) {
08cce2ff 36 $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']);
0337d704 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
a7de4ef7 43// vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
0337d704 44?>