[platal.git] / modules / platal.php

<?php
/***************************************************************************
 *  Copyright (C) 2003-2006 Polytechnique.org                              *
 *  http://opensource.polytechnique.org/                                   *
 *                                                                         *
 *  This program is free software; you can redistribute it and/or modify   *
 *  it under the terms of the GNU General Public License as published by   *
 *  the Free Software Foundation; either version 2 of the License, or      *
 *  (at your option) any later version.                                    *
 *                                                                         *
 *  This program is distributed in the hope that it will be useful,        *
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of         *
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the          *
 *  GNU General Public License for more details.                           *
 *                                                                         *
 *  You should have received a copy of the GNU General Public License      *
 *  along with this program; if not, write to the Free Software            *
 *  Foundation, Inc.,                                                      *
 *  59 Temple Place, Suite 330, Boston, MA  02111-1307  USA                *
 ***************************************************************************/

function bugize($list)
{
    $list = split(',', $list);
    $ans  = array();

    foreach ($list as $bug) {
        $clean = str_replace('#', '', $bug);
        $ans[] = "<a href='http://trackers.polytechnique.org/task/$clean'>$bug</a>";
    }

    return join(',', $ans);
}


class PlatalModule extends PLModule
{
    function handlers()
    {
        return array(
            'index'       => $this->make_hook('index',     AUTH_PUBLIC),
    	    'cacert.pem'  => $this->make_hook('cacert',    AUTH_PUBLIC),
            'changelog'   => $this->make_hook('changelog', AUTH_PUBLIC),

            // Preferences thingies
            'prefs'       => $this->make_hook('prefs',     AUTH_COOKIE),
            'prefs/rss'   => $this->make_hook('prefs_rss', AUTH_COOKIE),
            'prefs/webredirect'
                          => $this->make_hook('webredir',  AUTH_MDP),
            'prefs/skin'  => $this->make_hook('skin',      AUTH_COOKIE),

            // password related thingies
            'password'      => $this->make_hook('password',  AUTH_MDP),
            'tmpPWD'        => $this->make_hook('tmpPWD',    AUTH_PUBLIC),
            'password/smtp' => $this->make_hook('smtppass',  AUTH_MDP),
            'recovery'      => $this->make_hook('recovery',  AUTH_PUBLIC),
            'exit'          => $this->make_hook('exit', AUTH_PUBLIC),
            'deconnexion.php' => $this->make_hook('exit', AUTH_PUBLIC),

            // happenings related thingies
            'rss'         => $this->make_hook('rss',       AUTH_PUBLIC),
        );
    }

    function handler_index(&$page)
    {
        if (S::logged()) {
            pl_redirect('events');
        }
    }

    function handler_cacert(&$page)
    {
        $data = file_get_contents("/etc/ssl/xorgCA/cacert.pem","r");
        header("Pragma:");
        header("Set-Cookie:");
        header("Cache-Control:");
        header("Expires:");
        header("Content-Type: application/x-x509-ca-cert");
        header("Content-Length: ".strlen($data));
        echo $data;
        exit;
    }

    function handler_changelog(&$page)
    {
        $page->changeTpl('changeLog.tpl');
        $page->addJsLink('wiki.js');

        $clog = htmlentities(file_get_contents(dirname(__FILE__).'/../ChangeLog'));
        $clog = preg_replace('!(#[0-9]+(,[0-9]+)*)!e', 'bugize("\1")', $clog);
        $clog = preg_replace('!([-a-z0-9_.]+@[-a-z0-9_.]+)!ie',
            '"<script type=\'text/javascript\'>Nix.decode(\"" . str_rot13("\1") . "\"); </script>"', $clog);
        $clog = preg_replace('!vim:.*$!', '', $clog);
        $page->assign('ChangeLog', $clog);
    }

    function __set_rss_state($state)
    {
        if ($state) {
            $_SESSION['core_rss_hash'] = rand_url_id(16);
            XDB::execute('UPDATE  auth_user_quick
                                   SET  core_rss_hash={?} WHERE user_id={?}',
                                   S::v('core_rss_hash'), S::v('uid'));
        } else {
            XDB::execute('UPDATE  auth_user_quick
                                   SET  core_rss_hash="" WHERE user_id={?}',
                                   S::v('uid'));
            S::kill('core_rss_hash');
        }
    }

    function handler_prefs(&$page)
    {
        $page->changeTpl('preferences.tpl');
        $page->assign('xorg_title','Polytechnique.org - Mes pr�f�rences');

        if (Post::has('mail_fmt')) {
            $fmt = Post::v('mail_fmt');
            if ($fmt != 'texte') $fmt = 'html';
            XDB::execute("UPDATE auth_user_quick
                                       SET core_mail_fmt = '$fmt'
                                     WHERE user_id = {?}",
                                     S::v('uid'));
            $_SESSION['mail_fmt'] = $fmt;
        }

        if (Post::has('rss')) {
            $this->__set_rss_state(Post::b('rss'));
        }
    }

    function handler_webredir(&$page)
    {
        $page->changeTpl('webredirect.tpl');

        $page->assign('xorg_title','Polytechnique.org - Redirection de page WEB');

        $log =& S::v('log');
        $url = Env::v('url');

        if (Env::v('submit') == 'Valider' and Env::has('url')) {
            XDB::execute('UPDATE auth_user_quick
                                       SET redirecturl = {?} WHERE user_id = {?}',
                                   $url, S::v('uid'));
            $log->log('carva_add', 'http://'.Env::v('url'));
            $page->trig("Redirection activ�e vers <a href='http://$url'>$url</a>");
        } elseif (Env::v('submit') == "Supprimer") {
            XDB::execute("UPDATE auth_user_quick
                                       SET redirecturl = ''
                                     WHERE user_id = {?}",
                                   S::v('uid'));
            $log->log("carva_del", $url);
            Post::kill('url');
            $page->trig('Redirection supprim�e');
        }

        $res = XDB::query('SELECT redirecturl
                                       FROM auth_user_quick
                                      WHERE user_id = {?}',
                                    S::v('uid'));
        $page->assign('carva', $res->fetchOneCell());
    }

    function handler_prefs_rss(&$page)
    {
        $page->changeTpl('filrss.tpl');

        $page->assign('goback', Env::v('referer', 'login'));

        if (Env::v('act_rss') == 'Activer') {
            $this->__set_rss_state(true);
            $page->trig("Ton Fil RSS est activ�.");
        }
    }

    function handler_password(&$page)
    {
        if (Post::has('response2'))  {
            require_once 'secure_hash.inc.php';

            $_SESSION['password'] = $password = Post::v('response2');

            XDB::execute('UPDATE  auth_user_md5 
                                       SET  password={?}
                                     WHERE  user_id={?}', $password,
                                     S::v('uid'));

            $log =& S::v('log');
            $log->log('passwd', '');

            if (Cookie::v('ORGaccess')) {
                setcookie('ORGaccess', hash_encrypt($password), (time()+25920000), '/', '' ,0);
            }

            $page->changeTpl('motdepasse.success.tpl');
            $page->assign('now', strftime("%Y%m%d%H%M%S"));
            $page->run();
        }

        $page->changeTpl('motdepasse.tpl');
        $page->addJsLink('motdepasse.js');
        $page->assign('xorg_title','Polytechnique.org - Mon mot de passe');
    }

    function handler_smtppass(&$page)
    {
        $page->changeTpl('acces_smtp.tpl');
        $page->assign('xorg_title','Polytechnique.org - Acces SMTP/NNTP');

        $uid  = S::v('uid');
        $pass = Env::v('smtppass1');
        $log  = S::v('log');

        if (Env::v('op') == "Valider" && strlen($pass) >= 6 
        &&  Env::v('smtppass1') == Env::v('smtppass2')) 
        {
            XDB::execute('UPDATE auth_user_md5 SET smtppass = {?}
                                     WHERE user_id = {?}', $pass, $uid);
            $page->trig('Mot de passe enregistr�');
            $log->log("passwd_ssl");
        } elseif (Env::v('op') == "Supprimer") {
            XDB::execute('UPDATE auth_user_md5 SET smtppass = ""
                                     WHERE user_id = {?}', $uid);
            $page->trig('Compte SMTP et NNTP supprim�');
            $log->log("passwd_del");
        }

        $res = XDB::query("SELECT IF(smtppass != '', 'actif', '') 
                                       FROM auth_user_md5
                                      WHERE user_id = {?}", $uid);
        $page->assign('actif', $res->fetchOneCell());
    }

    function handler_recovery(&$page)
    {
        global $globals;

        $page->changeTpl('recovery.tpl');

        if (!Env::has('login') || !Env::has('birth')) {
            return;
        }

        if (!ereg('[0-3][0-9][0-1][0-9][1][9]([0-9]{2})', Env::v('birth'))) {
            $page->trig('Date de naissance incorrecte ou incoh�rente');
            return;
        }

        $birth   = sprintf('%s-%s-%s',
                           substr(Env::v('birth'), 4, 4),
                           substr(Env::v('birth'), 2, 2),
                           substr(Env::v('birth'), 0, 2));

        $mailorg = strtok(Env::v('login'), '@');

        // paragraphe rajout� : si la date de naissance dans la base n'existe pas, on l'update
        // avec celle fournie ici en esp�rant que c'est la bonne

        $res = XDB::query(
                "SELECT  user_id, naissance
                   FROM  auth_user_md5 AS u
             INNER JOIN  aliases       AS a ON (u.user_id=a.id AND type != 'homonyme')
                  WHERE  a.alias={?} AND u.perms IN ('admin','user') AND u.deces=0", $mailorg);
        list($uid, $naissance) = $res->fetchOneRow();

        if ($naissance == $birth) {
            $page->assign('ok', true);

            $url   = rand_url_id(); 
            XDB::execute('INSERT INTO perte_pass (certificat,uid,created) VALUES ({?},{?},NOW())', $url, $uid);
            $res   = XDB::query('SELECT email FROM emails WHERE uid = {?} AND NOT FIND_IN_SET("filter", flags)', $uid);
            $mails = implode(', ', $res->fetchColumn());

            require_once "diogenes/diogenes.hermes.inc.php";
            $mymail = new HermesMailer();
            $mymail->setFrom('"Gestion des mots de passe" <support+password@polytechnique.org>');
            $mymail->addTo($mails);
            $mymail->setSubject('Ton certificat d\'authentification');
            $mymail->setTxtBody("Visite la page suivante qui expire dans six heures :
{$globals->baseurl}/tmpPWD/$url

Si en cliquant dessus tu n'y arrives pas, copie int�gralement l'adresse dans la barre de ton navigateur.

-- 
Polytechnique.org
\"Le portail des �l�ves & anciens �l�ves de l'Ecole polytechnique\"".(Post::v('email') ? "

Adresse de secours :
    ".Post::v('email') : "")."

Mail envoy� � ".Env::v('login'));
            $mymail->send();

            // on cree un objet logger et on log l'evenement
            $logger = $_SESSION['log'] = new CoreLogger($uid);
            $logger->log('recovery', $emails);
        } else {
            $page->trig('Les informations que tu as rentr�es ne permettent pas de r�cup�rer ton mot de passe.<br />'.
                        'Si tu as un homonyme, utilise prenom.nom.promo comme login');
        }
    }

    function handler_tmpPWD(&$page, $certif = null)
    {
        XDB::execute('DELETE FROM perte_pass
                                      WHERE DATE_SUB(NOW(), INTERVAL 380 MINUTE) > created');

        $res   = XDB::query('SELECT uid FROM perte_pass WHERE certificat={?}', $certif);
        $ligne = $res->fetchOneAssoc();
        if (!$ligne) {
            $page->changeTpl('index.tpl');
            $page->kill("Cette adresse n'existe pas ou n'existe plus sur le serveur.");
        }

        $uid = $ligne["uid"];
        if (Post::has('response2')) {
            $password = Post::v('response2');
            $logger   = new CoreLogger($uid);
            XDB::query('UPDATE  auth_user_md5 SET password={?}
                                   WHERE  user_id={?} AND perms IN("admin","user")',
                                 $password, $uid);
            XDB::query('DELETE FROM perte_pass WHERE certificat={?}', $certif);
            $logger->log("passwd","");
            $page->changeTpl('tmpPWD.success.tpl');
            $page->assign('now', strftime("%Y%m%d%H%M%S"));
        } else {
            $page->changeTpl('motdepasse.tpl');
            $page->addJsLink('motdepasse.js');
        }
    }

    function handler_skin(&$page)
    {
        global $globals;

        $page->changeTpl('skins.tpl');
        $page->assign('xorg_title','Polytechnique.org - Skins');

        if (Env::has('newskin'))  {  // formulaire soumis, traitons les donn�es envoy�es
            XDB::execute('UPDATE auth_user_quick
                             SET skin={?} WHERE user_id={?}',
                         Env::i('newskin'), S::v('uid'));
            S::kill('skin');
            set_skin();
        }

        $res = XDB::query('SELECT id FROM skins WHERE skin_tpl={?}', S::v('skin'));
        $page->assign('skin_id', $res->fetchOneCell());

        $sql = "SELECT s.*,auteur,count(*) AS nb
                  FROM skins AS s
             LEFT JOIN auth_user_quick AS a ON s.id=a.skin
                 WHERE skin_tpl != '' AND ext != ''
              GROUP BY id ORDER BY s.date DESC";
        $page->assign_by_ref('skins', XDB::iterator($sql));
    }

    function handler_exit(&$page, $level = null)
    {
        if (S::has('suid')) {
            if (S::has('suid')) {
                $a4l  = S::v('forlife');
                $suid = S::v('suid');
                $log  = S::v('log');
                $log->log("suid_stop", S::v('forlife') . " by " . $suid['forlife']);
                $_SESSION = $suid;
                S::kill('suid');
                pl_redirect('admin/utilisateurs.php', 'login='.$a4l);
            } else {
                pl_redirect('events');
            }
        }

        if ($level == 'forget' || $level == 'forgetall') {
            setcookie('ORGaccess', '', time() - 3600, '/', '', 0);
            Cookie::kill('ORGaccess');
            if (isset($_SESSION['log']))
                $_SESSION['log']->log("cookie_off");
        }

        if ($level == 'forgetuid' || $level == 'forgetall') {
            setcookie('ORGuid', '', time() - 3600, '/', '', 0);
            Cookie::kill('ORGuid');
            setcookie('ORGdomain', '', time() - 3600, '/', '', 0);
            Cookie::kill('ORGdomain');
        }

        if (isset($_SESSION['log'])) {
            $ref = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
            $_SESSION['log']->log('deconnexion',$ref);
        }

        XorgSession::destroy();

        if (Get::has('redirect')) {
            http_redirect(rawurldecode(Get::v('redirect')));
        } else {
            $page->changeTpl('exit.tpl');
        }
    }

    function handler_rss(&$page, $user = null, $hash = null)
    {
        require_once 'rss.inc.php';

        $uid = init_rss('rss.tpl', $user, $hash);

        $rss = XDB::iterator(
                'SELECT  e.id, e.titre, e.texte, e.creation_date,
                         IF(u2.nom_usage = "", u2.nom, u2.nom_usage) AS nom, u2.prenom, u2.promo
                   FROM  auth_user_md5   AS u
             INNER JOIN  evenements      AS e ON ( (e.promo_min = 0 || e.promo_min <= u.promo)
                                                 AND (e.promo_max = 0 || e.promo_max >= u.promo) )
             INNER JOIN  auth_user_md5   AS u2 ON (u2.user_id = e.user_id)
                  WHERE  u.user_id = {?} AND FIND_IN_SET(e.flags, "valide")
                                         AND peremption >= NOW()', $uid);
        $page->assign('rss', $rss);
    }
}

?>
Commit	Line	Data
e59506eb	1	<?php
	2	/***************************************************************************
	3	* Copyright (C) 2003-2006 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
5de0b7e1	22	function bugize($list)
	23	{
	24	$list = split(',', $list);
	25	$ans = array();
	26
	27	foreach ($list as $bug) {
	28	$clean = str_replace('#', '', $bug);
	29	$ans[] = "<a href='http://trackers.polytechnique.org/task/$clean'>$bug</a>";
	30	}
	31
	32	return join(',', $ans);
	33	}
	34
	35
e59506eb	36	class PlatalModule extends PLModule
	37	{
	38	function handlers()
	39	{
	40	return array(
c9178c75	41	'index' => $this->make_hook('index', AUTH_PUBLIC),
dc41059a	42	'cacert.pem' => $this->make_hook('cacert', AUTH_PUBLIC),
5de0b7e1	43	'changelog' => $this->make_hook('changelog', AUTH_PUBLIC),
5de0b7e1	44
4da0b8d7	45	// Preferences thingies
bee33d93	46	'prefs' => $this->make_hook('prefs', AUTH_COOKIE),
bee33d93	47	'prefs/rss' => $this->make_hook('prefs_rss', AUTH_COOKIE),
bce2f8eb	48	'prefs/webredirect'
bee33d93	49	=> $this->make_hook('webredir', AUTH_MDP),
bee33d93	50	'prefs/skin' => $this->make_hook('skin', AUTH_COOKIE),
4da0b8d7	51
4da0b8d7	52	// password related thingies
1a5da857	53	'password' => $this->make_hook('password', AUTH_MDP),
	54	'tmpPWD' => $this->make_hook('tmpPWD', AUTH_PUBLIC),
	55	'password/smtp' => $this->make_hook('smtppass', AUTH_MDP),
8858cfc1	56	'recovery' => $this->make_hook('recovery', AUTH_PUBLIC),
5de0b7e1	57	'exit' => $this->make_hook('exit', AUTH_PUBLIC),
58abb43b	58	'deconnexion.php' => $this->make_hook('exit', AUTH_PUBLIC),
4da0b8d7	59
	60	// happenings related thingies
	61	'rss' => $this->make_hook('rss', AUTH_PUBLIC),
e59506eb	62	);
	63	}
	64
c9178c75	65	function handler_index(&$page)
c9178c75	66	{
cab08090	67	if (S::logged()) {
8b00e0e0	68	pl_redirect('events');
c9178c75	69	}
c9178c75	70	}
c9178c75	71
5de0b7e1	72	function handler_cacert(&$page)
5de0b7e1	73	{
ca877168	74	$data = file_get_contents("/etc/ssl/xorgCA/cacert.pem","r");
ca877168	75	header("Pragma:");
dc41059a	76	header("Set-Cookie:");
	77	header("Cache-Control:");
	78	header("Expires:");
	79	header("Content-Type: application/x-x509-ca-cert");
ca877168	80	header("Content-Length: ".strlen($data));
5de0b7e1	81	echo $data;
	82	exit;
	83	}
	84
	85	function handler_changelog(&$page)
	86	{
	87	$page->changeTpl('changeLog.tpl');
5d25e495	88	$page->addJsLink('wiki.js');
5de0b7e1	89
	90	$clog = htmlentities(file_get_contents(dirname(__FILE__).'/../ChangeLog'));
	91	$clog = preg_replace('!(#[0-9]+(,[0-9]+)*)!e', 'bugize("\1")', $clog);
5d25e495	92	$clog = preg_replace('!([-a-z0-9_.]+@[-a-z0-9_.]+)!ie',
5d25e495	93	'"<script type=\'text/javascript\'>Nix.decode(\"" . str_rot13("\1") . "\"); </script>"', $clog);
9408f155	94	$clog = preg_replace('!vim:.*$!', '', $clog);
5de0b7e1	95	$page->assign('ChangeLog', $clog);
	96	}
	97
7927d719	98	function __set_rss_state($state)
7927d719	99	{
7927d719	100	if ($state) {
7927d719	101	$_SESSION['core_rss_hash'] = rand_url_id(16);
08cce2ff	102	XDB::execute('UPDATE auth_user_quick
7927d719	103	SET core_rss_hash={?} WHERE user_id={?}',
cab08090	104	S::v('core_rss_hash'), S::v('uid'));
7927d719	105	} else {
08cce2ff	106	XDB::execute('UPDATE auth_user_quick
7927d719	107	SET core_rss_hash="" WHERE user_id={?}',
cab08090	108	S::v('uid'));
cab08090	109	S::kill('core_rss_hash');
7927d719	110	}
	111	}
	112
e59506eb	113	function handler_prefs(&$page)
e59506eb	114	{
e59506eb	115	$page->changeTpl('preferences.tpl');
	116	$page->assign('xorg_title','Polytechnique.org - Mes pr�f�rences');
	117
bee33d93	118	if (Post::has('mail_fmt')) {
5e2307dc	119	$fmt = Post::v('mail_fmt');
e59506eb	120	if ($fmt != 'texte') $fmt = 'html';
08cce2ff	121	XDB::execute("UPDATE auth_user_quick
e59506eb	122	SET core_mail_fmt = '$fmt'
e59506eb	123	WHERE user_id = {?}",
cab08090	124	S::v('uid'));
e59506eb	125	$_SESSION['mail_fmt'] = $fmt;
e59506eb	126	}
e59506eb	127
bee33d93	128	if (Post::has('rss')) {
5e2307dc	129	$this->__set_rss_state(Post::b('rss'));
e59506eb	130	}
e59506eb	131	}
9bae6004	132
bce2f8eb	133	function handler_webredir(&$page)
bce2f8eb	134	{
bce2f8eb	135	$page->changeTpl('webredirect.tpl');
	136
	137	$page->assign('xorg_title','Polytechnique.org - Redirection de page WEB');
	138
cab08090	139	$log =& S::v('log');
5e2307dc	140	$url = Env::v('url');
bce2f8eb	141
5e2307dc	142	if (Env::v('submit') == 'Valider' and Env::has('url')) {
08cce2ff	143	XDB::execute('UPDATE auth_user_quick
bce2f8eb	144	SET redirecturl = {?} WHERE user_id = {?}',
cab08090	145	$url, S::v('uid'));
5e2307dc	146	$log->log('carva_add', 'http://'.Env::v('url'));
bce2f8eb	147	$page->trig("Redirection activ�e vers <a href='http://$url'>$url</a>");
5e2307dc	148	} elseif (Env::v('submit') == "Supprimer") {
08cce2ff	149	XDB::execute("UPDATE auth_user_quick
bce2f8eb	150	SET redirecturl = ''
bce2f8eb	151	WHERE user_id = {?}",
cab08090	152	S::v('uid'));
bce2f8eb	153	$log->log("carva_del", $url);
	154	Post::kill('url');
	155	$page->trig('Redirection supprim�e');
	156	}
	157
08cce2ff	158	$res = XDB::query('SELECT redirecturl
bce2f8eb	159	FROM auth_user_quick
bce2f8eb	160	WHERE user_id = {?}',
cab08090	161	S::v('uid'));
bce2f8eb	162	$page->assign('carva', $res->fetchOneCell());
bce2f8eb	163	}
bce2f8eb	164
4da0b8d7	165	function handler_prefs_rss(&$page)
7927d719	166	{
7927d719	167	$page->changeTpl('filrss.tpl');
7927d719	168
5e2307dc	169	$page->assign('goback', Env::v('referer', 'login'));
7927d719	170
5e2307dc	171	if (Env::v('act_rss') == 'Activer') {
7927d719	172	$this->__set_rss_state(true);
	173	$page->trig("Ton Fil RSS est activ�.");
	174	}
7927d719	175	}
7927d719	176
7c77c3ee	177	function handler_password(&$page)
7c77c3ee	178	{
7c77c3ee	179	if (Post::has('response2')) {
	180	require_once 'secure_hash.inc.php';
	181
5e2307dc	182	$_SESSION['password'] = $password = Post::v('response2');
7c77c3ee	183
08cce2ff	184	XDB::execute('UPDATE auth_user_md5
7c77c3ee	185	SET password={?}
7c77c3ee	186	WHERE user_id={?}', $password,
cab08090	187	S::v('uid'));
7c77c3ee	188
cab08090	189	$log =& S::v('log');
7c77c3ee	190	$log->log('passwd', '');
7c77c3ee	191
5e2307dc	192	if (Cookie::v('ORGaccess')) {
7c77c3ee	193	setcookie('ORGaccess', hash_encrypt($password), (time()+25920000), '/', '' ,0);
	194	}
	195
	196	$page->changeTpl('motdepasse.success.tpl');
eb56722b	197	$page->assign('now', strftime("%Y%m%d%H%M%S"));
7c77c3ee	198	$page->run();
	199	}
	200
	201	$page->changeTpl('motdepasse.tpl');
c99ef281	202	$page->addJsLink('motdepasse.js');
7c77c3ee	203	$page->assign('xorg_title','Polytechnique.org - Mon mot de passe');
7c77c3ee	204	}
7c77c3ee	205
1a5da857	206	function handler_smtppass(&$page)
1a5da857	207	{
1a5da857	208	$page->changeTpl('acces_smtp.tpl');
	209	$page->assign('xorg_title','Polytechnique.org - Acces SMTP/NNTP');
	210
cab08090	211	$uid = S::v('uid');
5e2307dc	212	$pass = Env::v('smtppass1');
cab08090	213	$log = S::v('log');
1a5da857	214
5e2307dc	215	if (Env::v('op') == "Valider" && strlen($pass) >= 6
5e2307dc	216	&& Env::v('smtppass1') == Env::v('smtppass2'))
1a5da857	217	{
08cce2ff	218	XDB::execute('UPDATE auth_user_md5 SET smtppass = {?}
1a5da857	219	WHERE user_id = {?}', $pass, $uid);
	220	$page->trig('Mot de passe enregistr�');
	221	$log->log("passwd_ssl");
5e2307dc	222	} elseif (Env::v('op') == "Supprimer") {
08cce2ff	223	XDB::execute('UPDATE auth_user_md5 SET smtppass = ""
1a5da857	224	WHERE user_id = {?}', $uid);
	225	$page->trig('Compte SMTP et NNTP supprim�');
	226	$log->log("passwd_del");
	227	}
	228
08cce2ff	229	$res = XDB::query("SELECT IF(smtppass != '', 'actif', '')
1a5da857	230	FROM auth_user_md5
	231	WHERE user_id = {?}", $uid);
	232	$page->assign('actif', $res->fetchOneCell());
1a5da857	233	}
1a5da857	234
8858cfc1	235	function handler_recovery(&$page)
	236	{
	237	global $globals;
	238
	239	$page->changeTpl('recovery.tpl');
	240
	241	if (!Env::has('login') \|\| !Env::has('birth')) {
fd8f77de	242	return;
8858cfc1	243	}
8858cfc1	244
5e2307dc	245	if (!ereg('[0-3][0-9][0-1][0-9][1][9]([0-9]{2})', Env::v('birth'))) {
c9110c6c	246	$page->trig('Date de naissance incorrecte ou incoh�rente');
c9110c6c	247	return;
8858cfc1	248	}
c9110c6c	249
c9110c6c	250	$birth = sprintf('%s-%s-%s',
5e2307dc	251	substr(Env::v('birth'), 4, 4),
	252	substr(Env::v('birth'), 2, 2),
	253	substr(Env::v('birth'), 0, 2));
8858cfc1	254
5e2307dc	255	$mailorg = strtok(Env::v('login'), '@');
8858cfc1	256
	257	// paragraphe rajout� : si la date de naissance dans la base n'existe pas, on l'update
	258	// avec celle fournie ici en esp�rant que c'est la bonne
	259
08cce2ff	260	$res = XDB::query(
8858cfc1	261	"SELECT user_id, naissance
8858cfc1	262	FROM auth_user_md5 AS u
3a5c1551	263	INNER JOIN aliases AS a ON (u.user_id=a.id AND type != 'homonyme')
8858cfc1	264	WHERE a.alias={?} AND u.perms IN ('admin','user') AND u.deces=0", $mailorg);
	265	list($uid, $naissance) = $res->fetchOneRow();
	266
	267	if ($naissance == $birth) {
	268	$page->assign('ok', true);
	269
	270	$url = rand_url_id();
08cce2ff	271	XDB::execute('INSERT INTO perte_pass (certificat,uid,created) VALUES ({?},{?},NOW())', $url, $uid);
08cce2ff	272	$res = XDB::query('SELECT email FROM emails WHERE uid = {?} AND NOT FIND_IN_SET("filter", flags)', $uid);
8858cfc1	273	$mails = implode(', ', $res->fetchColumn());
	274
	275	require_once "diogenes/diogenes.hermes.inc.php";
	276	$mymail = new HermesMailer();
	277	$mymail->setFrom('"Gestion des mots de passe" <support+password@polytechnique.org>');
	278	$mymail->addTo($mails);
	279	$mymail->setSubject('Ton certificat d\'authentification');
	280	$mymail->setTxtBody("Visite la page suivante qui expire dans six heures :
	281	{$globals->baseurl}/tmpPWD/$url
	282
	283	Si en cliquant dessus tu n'y arrives pas, copie int�gralement l'adresse dans la barre de ton navigateur.
	284
	285	--
	286	Polytechnique.org
5e2307dc	287	\"Le portail des �l�ves & anciens �l�ves de l'Ecole polytechnique\"".(Post::v('email') ? "
8858cfc1	288
8858cfc1	289	Adresse de secours :
5e2307dc	290	".Post::v('email') : "")."
8858cfc1	291
5e2307dc	292	Mail envoy� � ".Env::v('login'));
8858cfc1	293	$mymail->send();
	294
	295	// on cree un objet logger et on log l'evenement
c4271d38	296	$logger = $_SESSION['log'] = new CoreLogger($uid);
8858cfc1	297	$logger->log('recovery', $emails);
8858cfc1	298	} else {
3a5c1551	299	$page->trig('Les informations que tu as rentr�es ne permettent pas de r�cup�rer ton mot de passe.<br />'.
3a5c1551	300	'Si tu as un homonyme, utilise prenom.nom.promo comme login');
8858cfc1	301	}
8858cfc1	302	}
8858cfc1	303
6c49d0af	304	function handler_tmpPWD(&$page, $certif = null)
6c49d0af	305	{
08cce2ff	306	XDB::execute('DELETE FROM perte_pass
6c49d0af	307	WHERE DATE_SUB(NOW(), INTERVAL 380 MINUTE) > created');
6c49d0af	308
08cce2ff	309	$res = XDB::query('SELECT uid FROM perte_pass WHERE certificat={?}', $certif);
6c49d0af	310	$ligne = $res->fetchOneAssoc();
	311	if (!$ligne) {
	312	$page->changeTpl('index.tpl');
	313	$page->kill("Cette adresse n'existe pas ou n'existe plus sur le serveur.");
	314	}
	315
	316	$uid = $ligne["uid"];
	317	if (Post::has('response2')) {
5e2307dc	318	$password = Post::v('response2');
c4271d38	319	$logger = new CoreLogger($uid);
08cce2ff	320	XDB::query('UPDATE auth_user_md5 SET password={?}
6c49d0af	321	WHERE user_id={?} AND perms IN("admin","user")',
6c49d0af	322	$password, $uid);
08cce2ff	323	XDB::query('DELETE FROM perte_pass WHERE certificat={?}', $certif);
6c49d0af	324	$logger->log("passwd","");
6c49d0af	325	$page->changeTpl('tmpPWD.success.tpl');
eb56722b	326	$page->assign('now', strftime("%Y%m%d%H%M%S"));
6c49d0af	327	} else {
6c49d0af	328	$page->changeTpl('motdepasse.tpl');
c99ef281	329	$page->addJsLink('motdepasse.js');
6c49d0af	330	}
6c49d0af	331	}
6c49d0af	332
9bae6004	333	function handler_skin(&$page)
	334	{
	335	global $globals;
	336
f09cee18	337	$page->changeTpl('skins.tpl');
9bae6004	338	$page->assign('xorg_title','Polytechnique.org - Skins');
	339
	340	if (Env::has('newskin')) { // formulaire soumis, traitons les donn�es envoy�es
08cce2ff	341	XDB::execute('UPDATE auth_user_quick
63528107	342	SET skin={?} WHERE user_id={?}',
5e2307dc	343	Env::i('newskin'), S::v('uid'));
92e6a287	344	S::kill('skin');
9bae6004	345	set_skin();
	346	}
	347
92e6a287	348	$res = XDB::query('SELECT id FROM skins WHERE skin_tpl={?}', S::v('skin'));
	349	$page->assign('skin_id', $res->fetchOneCell());
	350
9bae6004	351	$sql = "SELECT s.,auteur,count() AS nb
	352	FROM skins AS s
	353	LEFT JOIN auth_user_quick AS a ON s.id=a.skin
	354	WHERE skin_tpl != '' AND ext != ''
	355	GROUP BY id ORDER BY s.date DESC";
08cce2ff	356	$page->assign_by_ref('skins', XDB::iterator($sql));
9bae6004	357	}
4da0b8d7	358
5de0b7e1	359	function handler_exit(&$page, $level = null)
5de0b7e1	360	{
cab08090	361	if (S::has('suid')) {
	362	if (S::has('suid')) {
	363	$a4l = S::v('forlife');
	364	$suid = S::v('suid');
	365	$log = S::v('log');
	366	$log->log("suid_stop", S::v('forlife') . " by " . $suid['forlife']);
5de0b7e1	367	$_SESSION = $suid;
cab08090	368	S::kill('suid');
8b00e0e0	369	pl_redirect('admin/utilisateurs.php', 'login='.$a4l);
5de0b7e1	370	} else {
8b00e0e0	371	pl_redirect('events');
5de0b7e1	372	}
	373	}
	374
	375	if ($level == 'forget' \|\| $level == 'forgetall') {
	376	setcookie('ORGaccess', '', time() - 3600, '/', '', 0);
	377	Cookie::kill('ORGaccess');
	378	if (isset($_SESSION['log']))
	379	$_SESSION['log']->log("cookie_off");
	380	}
	381
	382	if ($level == 'forgetuid' \|\| $level == 'forgetall') {
	383	setcookie('ORGuid', '', time() - 3600, '/', '', 0);
	384	Cookie::kill('ORGuid');
	385	setcookie('ORGdomain', '', time() - 3600, '/', '', 0);
	386	Cookie::kill('ORGdomain');
	387	}
	388
	389	if (isset($_SESSION['log'])) {
	390	$ref = isset($_SERVER['HTTP_REFERER']) ? $_SERVER['HTTP_REFERER'] : '';
	391	$_SESSION['log']->log('deconnexion',$ref);
	392	}
	393
	394	XorgSession::destroy();
	395
	396	if (Get::has('redirect')) {
5e2307dc	397	http_redirect(rawurldecode(Get::v('redirect')));
5de0b7e1	398	} else {
	399	$page->changeTpl('exit.tpl');
	400	}
5de0b7e1	401	}
5de0b7e1	402
4da0b8d7	403	function handler_rss(&$page, $user = null, $hash = null)
4da0b8d7	404	{
4da0b8d7	405	require_once 'rss.inc.php';
	406
	407	$uid = init_rss('rss.tpl', $user, $hash);
	408
08cce2ff	409	$rss = XDB::iterator(
522162cc	410	'SELECT e.id, e.titre, e.texte, e.creation_date,
522162cc	411	IF(u2.nom_usage = "", u2.nom, u2.nom_usage) AS nom, u2.prenom, u2.promo
4da0b8d7	412	FROM auth_user_md5 AS u
4da0b8d7	413	INNER JOIN evenements AS e ON ( (e.promo_min = 0 \|\| e.promo_min <= u.promo)
522162cc	414	AND (e.promo_max = 0 \|\| e.promo_max >= u.promo) )
522162cc	415	INNER JOIN auth_user_md5 AS u2 ON (u2.user_id = e.user_id)
4da0b8d7	416	WHERE u.user_id = {?} AND FIND_IN_SET(e.flags, "valide")
	417	AND peremption >= NOW()', $uid);
	418	$page->assign('rss', $rss);
4da0b8d7	419	}
e59506eb	420	}
	421
	422	?>