modules/admin/homonyms.inc.php

   1 <?php
   2 /***************************************************************************
   3  *  Copyright (C) 2003-2008 Polytechnique.org                              *
   4  *  http://opensource.polytechnique.org/                                   *
   5  *                                                                         *
   6  *  This program is free software; you can redistribute it and/or modify   *
   7  *  it under the terms of the GNU General Public License as published by   *
   8  *  the Free Software Foundation; either version 2 of the License, or      *
   9  *  (at your option) any later version.                                    *
  10  *                                                                         *
  11  *  This program is distributed in the hope that it will be useful,        *
  12  *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
  13  *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
  14  *  GNU General Public License for more details.                           *
  15  *                                                                         *
  16  *  You should have received a copy of the GNU General Public License      *
  17  *  along with this program; if not, write to the Free Software            *
  18  *  Foundation, Inc.,                                                      *
  19  *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
  20  ***************************************************************************/
  21
  22 function select_if_homonyme(PlUser &$user) {
  23     return XDB::fetchOneCell("SELECT  a.alias
  24                                 FROM  aliases AS a
  25                                WHERE  a.id = {?} AND a.expire != ''",
  26                              $user->id());
  27 }
  28
  29 function send_warning_homonyme(PlUser &$user, $loginbis) {
  30     global $globals;
  31     $cc = "support+homonyme@" . $globals->mail->domain;
  32     $FROM = "\"Support Polytechnique.org\" <$cc>";
  33     $mymail = new PlMailer();
  34     $mymail->setFrom($FROM);
  35     $mymail->addCc($cc);
  36     $mymail->setSubject("Dans 2 semaines, suppression de $loginbis@" . $globals->mail->domain);
  37     $mymail->setTxtBody(Env::v('mailbody'));
  38     $mymail->sendTo($user);
  39 }
  40
  41 function send_robot_homonyme(PlUser &$user, $loginbis) {
  42     global $globals;
  43     $cc = "support+homonyme@" . $globals->mail->domain;
  44     $FROM = "\"Support Polytechnique.org\" <$cc>";
  45     $mymail = new PlMailer();
  46     $mymail->setFrom($FROM);
  47     $mymail->setSubject("Mise en place du robot $loginbis@" . $globals->mail->domain);
  48     $mymail->addCc($cc);
  49     $mymail->setTxtBody(Env::v('mailbody'));
  50     $mymail->sendTo($user);
  51 }
  52
  53 function switch_bestalias(PlUser &$user, $loginbis) {
  54     // check if loginbis was the bestalias
  55     $bestailas = XDB::fetchOneCell("SELECT  alias
  56                                       FROM  aliases
  57                                      WHERE  id = {?} AND FIND_IN_SET('bestalias', flags)",
  58                                    $user->id());
  59     if ($bestalias && $bestalias != $loginbis) {
  60         return false;
  61     }
  62
  63     // select the shortest alias still alive
  64     $newbest = XDB::fetchOneCell("SELECT  alias
  65                                     FROM  aliases
  66                                    WHERE  id = {?} AND alias != {?} AND expire IS NULL
  67                                 ORDER BY  LENGTH(alias)
  68                                    LIMIT  1", $user->id(), $loginbis);
  69     // change the bestalias flag
  70     XDB::execute("UPDATE  aliases
  71                      SET  flags = (flags & (255 - 1)) | IF(alias = {?}, 1, 0)
  72                    WHERE  id = {?}", $newbest, $user->id());
  73     return $newbest;
  74 }
  75
  76 // vim:set et sw=4 sts=4 sws=4 foldmethod=marker enc=utf-8:
  77 ?>