X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fplatal.php;h=197728eb4ec855442a268eb2608f2501a241654b;hb=fa9994fa46e744766e87e445413610cf3f184374;hp=f396e068cb20956c01fb6686ec1d31dab7bf9f39;hpb=0c02607ec8d2a6aebac70a050c8f6b3a58ff566e;p=platal.git diff --git a/modules/platal.php b/modules/platal.php index f396e06..197728e 100644 --- a/modules/platal.php +++ b/modules/platal.php @@ -1,6 +1,6 @@ $this->make_hook('index', AUTH_PUBLIC), - 'cacert.pem' => $this->make_hook('cacert', AUTH_PUBLIC), - 'changelog' => $this->make_hook('changelog', AUTH_PUBLIC), + '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), + '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), - 'review' => $this->make_hook('review', AUTH_PUBLIC), - 'deconnexion.php' => $this->make_hook('exit', AUTH_PUBLIC), + '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), + 'review' => $this->make_hook('review', AUTH_PUBLIC), + 'deconnexion.php' => $this->make_hook('exit', AUTH_PUBLIC), ); } @@ -64,63 +63,65 @@ class PlatalModule extends PLModule { // Include X-XRDS-Location response-header for Yadis discovery global $globals; - header('X-XRDS-Location: ' . $globals->baseurl . '/openid/idp_xrds'); + header('X-XRDS-Location: ' . $globals->baseurl . '/openid/xrds'); // Redirect to the suitable page if (S::logged()) { pl_redirect('events'); } else if (!@$GLOBALS['IS_XNET_SITE']) { - pl_redirect('review'); + $this->handler_review($page); } } 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; + pl_cached_content_headers("application/x-x509-ca-cert"); + readfile("/etc/ssl/xorgCA/cacert.pem"); exit; } - function handler_changelog(&$page) + function handler_changelog(&$page, $core = null) { $page->changeTpl('platal/changeLog.tpl'); - $clog = pl_entities(file_get_contents(dirname(__FILE__).'/../ChangeLog')); - $clog = preg_replace('/===+\s*/', '
', $clog); - // url catch only (not all wiki syntax) - $clog = preg_replace(array( - '/((?:https?|ftp):\/\/(?:\.*,*[\w@~%$£µ&i#\-+=_\/\?;])*)/ui', - '/(\s|^)www\.((?:\.*,*[\w@~%$£µ&i#\-+=_\/\?;])*)/iu', - '/(?:mailto:)?([a-z0-9.\-+_]+@([\-.+_]?[a-z0-9])+)/i'), - array( - '\\0', - '\\1www.\\2', - '\\0'), - $clog); - $clog = preg_replace('!(#[0-9]+(,[0-9]+)*)!e', 'bugize("\1")', $clog); - $clog = preg_replace('!vim:.*$!', '', $clog); - $clog = preg_replace("!(
(\\s|\n)*)?(\s|\n)*((\\s|\n)*
)?!m", "", "$clog"); - $page->assign('ChangeLog', $clog); + function formatChangeLog($file) { + $clog = pl_entities(file_get_contents($file)); + $clog = preg_replace('/===+\s*/', '
', $clog); + // url catch only (not all wiki syntax) + $clog = preg_replace(array( + '/((?:https?|ftp):\/\/(?:\.*,*[\w@~%$£µ&i#\-+=_\/\?;])*)/ui', + '/(\s|^)www\.((?:\.*,*[\w@~%$£µ&i#\-+=_\/\?;])*)/iu', + '/(?:mailto:)?([a-z0-9.\-+_]+@([\-.+_]?[a-z0-9])+)/i'), + array( + '\\0', + '\\1www.\\2', + '\\0'), + $clog); + $clog = preg_replace('!(#[0-9]+(,[0-9]+)*)!e', 'bugize("\1")', $clog); + $clog = preg_replace('!vim:.*$!', '', $clog); + return preg_replace("!(
(\\s|\n)*)?(\s|\n)*((\\s|\n)*
)?!m", "", "$clog"); + } + if ($core != 'core') { + $page->assign('core', false); + $page->assign('ChangeLog', formatChangeLog(dirname(__FILE__).'/../ChangeLog')); + } else { + $page->assign('core', true); + $page->assign('ChangeLog', formatChangeLog(dirname(__FILE__).'/../core/ChangeLog')); + } } 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')); + S::set('token', rand_url_id(16)); + XDB::execute('UPDATE accounts + SET token = {?} + WHERE uid = {?}', S::s('token'), S::i('uid')); } else { - XDB::execute('UPDATE auth_user_quick - SET core_rss_hash="" WHERE user_id={?}', - S::v('uid')); - S::kill('core_rss_hash'); + S::kill('token'); + XDB::execute('UPDATE accounts + SET token = NULL + WHERE uid = {?}', S::i('uid')); } } @@ -129,14 +130,13 @@ class PlatalModule extends PLModule $page->changeTpl('platal/preferences.tpl'); $page->setTitle('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('email_format')) { + $fmt = Post::s('email_format'); + XDB::execute("UPDATE accounts + SET email_format = {?} + WHERE uid = {?}", + $fmt, S::v('uid')); + S::set('email_format', $fmt); } if (Post::has('rss')) { @@ -147,7 +147,7 @@ class PlatalModule extends PLModule # carva will extend to users not in the main domain. $res = XDB::query("SELECT alias FROM aliases - WHERE id = {?} AND FIND_IN_SET('bestalias', flags)", + WHERE uid = {?} AND FIND_IN_SET('bestalias', flags)", S::user()->id()); $page->assign('bestalias', $res->fetchOneCell()); } @@ -155,39 +155,37 @@ class PlatalModule extends PLModule function handler_webredir(&$page) { $page->changeTpl('platal/webredirect.tpl'); - $page->setTitle('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')); - S::logger()->log('carva_add', 'http://'.Env::v('url')); - $page->trigSuccess("Redirection activée vers $url"); - } elseif (Env::v('submit') == "Supprimer") { - XDB::execute("UPDATE auth_user_quick - SET redirecturl = '' - WHERE user_id = {?}", - S::v('uid')); - S::logger()->log("carva_del", $url); + if (Env::v('submit') == 'Valider' && !Env::blank('url')) { + if (Env::blank('url')) { + $page->trigError('URL invalide'); + } else { + $url = Env::t('url'); + XDB::execute('REPLACE INTO carvas (uid, url) + VALUES ({?}, {?})', + S::i('uid'), $url); + S::logger()->log('carva_add', 'http://' . $url); + $page->trigSuccess("Redirection activée vers $url"); + } + } elseif (Env::v('submit') == 'Supprimer') { + XDB::execute('DELETE FROM carvas + WHERE uid = {?}', S::i('uid')); Post::kill('url'); + S::logger()->log('carva_del'); $page->trigSuccess('Redirection supprimée'); } - $res = XDB::query('SELECT redirecturl - FROM auth_user_quick - WHERE user_id = {?}', - S::v('uid')); - $page->assign('carva', $res->fetchOneCell()); + $url = XDB::fetchOneCell('SELECT url + FROM carvas + WHERE uid = {?}', S::i('uid')); + $page->assign('carva', $url); # FIXME: this code is not multi-domain compatible. We should decide how # carva will extend to users not in the main domain. $res = XDB::query("SELECT alias FROM aliases - WHERE id = {?} AND FIND_IN_SET('bestalias', flags)", + WHERE uid = {?} AND FIND_IN_SET('bestalias', flags)", S::user()->id()); $page->assign('bestalias', $res->fetchOneCell()); } @@ -211,12 +209,11 @@ class PlatalModule extends PLModule if (Post::has('response2')) { S::assert_xsrf_token(); - $_SESSION['password'] = $password = Post::v('response2'); - - XDB::execute('UPDATE auth_user_md5 - SET password={?} - WHERE user_id={?}', $password, - S::v('uid')); + S::set('password', $password = Post::v('response2')); + XDB::execute('UPDATE accounts + SET password = {?} + WHERE uid={?}', $password, + S::i('uid')); // If GoogleApps is enabled, and the user did choose to use synchronized passwords, // updates the Google Apps password as well. @@ -250,27 +247,27 @@ class PlatalModule extends PLModule $wp = new PlWikiPage('Xorg.NNTPSécurisé'); $wp->buildCache(); - $uid = S::v('uid'); + $uid = S::i('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); + && Env::v('smtppass1') == Env::v('smtppass2')) { + XDB::execute('UPDATE accounts + SET weak_password = {?} + WHERE uid = {?}', $pass, $uid); $page->trigSuccess('Mot de passe enregistré'); S::logger()->log("passwd_ssl"); } elseif (Env::v('op') == "Supprimer") { - XDB::execute('UPDATE auth_user_md5 SET smtppass = "" - WHERE user_id = {?}', $uid); + XDB::execute('UPDATE accounts + SET weak_password = NULL + WHERE uid = {?}', $uid); $page->trigSuccess('Compte SMTP et NNTP supprimé'); S::logger()->log("passwd_del"); } - $res = XDB::query("SELECT IF(smtppass != '', 'actif', '') - FROM auth_user_md5 - WHERE user_id = {?}", $uid); + $res = XDB::query("SELECT weak_password IS NOT NULL + FROM accounts + WHERE uid = {?}", $uid); $page->assign('actif', $res->fetchOneCell()); } @@ -296,75 +293,75 @@ class PlatalModule extends PLModule $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) { - $res = XDB::query("SELECT COUNT(*) - FROM emails - WHERE uid = {?} AND flags != 'panne' AND flags != 'filter'", $uid); - $count = intval($res->fetchOneCell()); - if ($count == 0) { - $page->assign('no_addr', true); - return; - } + $profile = Profile::get(Env::t('login')); + if (is_null($profile) || $profile->birthdate != $birth) { + $page->trigError('Les informations que tu as rentrées ne permettent pas de récupérer ton mot de passe.
'. + 'Si tu as un homonyme, utilise prenom.nom.promo comme login'); + return; + } - $page->assign('ok', true); + $user = $profile->owner(); + if ($user->state != 'active') { + $page->trigError('Ton compte n\'est pas activé.'); + return; + } - $url = rand_url_id(); - XDB::execute('INSERT INTO perte_pass (certificat,uid,created) - VALUES ({?},{?},NOW())', $url, $uid); - $res = XDB::query('SELECT email + $res = XDB::query("SELECT COUNT(*) + FROM emails + WHERE uid = {?} AND flags != 'panne' AND flags != 'filter'", $user->id()); + $count = intval($res->fetchOneCell()); + if ($count == 0) { + $page->assign('no_addr', true); + return; + } + + $page->assign('ok', true); + + $url = rand_url_id(); + XDB::execute('INSERT INTO account_lost_passwords (certificat,uid,created) + VALUES ({?},{?},NOW())', $url, $user->id()); + $res = XDB::query('SELECT email + FROM emails + WHERE uid = {?} AND email = {?}', + $user->id(), Post::v('email')); + if ($res->numRows()) { + $mails = $res->fetchOneCell(); + } else { + $res = XDB::query("SELECT email FROM emails - WHERE uid = {?} AND email = {?}', - $uid, Post::v('email')); - if ($res->numRows()) { - $mails = $res->fetchOneCell(); - } else { - $res = XDB::query('SELECT email - FROM emails - WHERE uid = {?} AND NOT FIND_IN_SET("filter", flags)', $uid); - $mails = implode(', ', $res->fetchColumn()); - } - $mymail = new PlMailer(); - $mymail->setFrom('"Gestion des mots de passe"mail->domain . '>'); - $mymail->addTo($mails); - $mymail->setSubject('Ton certificat d\'authentification'); - $mymail->setTxtBody("Visite la page suivante qui expire dans six heures : + WHERE uid = {?} AND NOT FIND_IN_SET('filter', flags)", $user->id()); + $mails = implode(', ', $res->fetchColumn()); + } + $mymail = new PlMailer(); + $mymail->setFrom('"Gestion des mots de passe" mail->domain . '>'); + $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. Si tu n'as pas utilisé ce lien dans six heures, tu peux tout simplement recommencer cette procédure. -- Polytechnique.org -\"Le portail des élèves & anciens élèves de l'Ecole polytechnique\" +\"Le portail des élèves & anciens élèves de l'Ãcole polytechnique\" Email envoyé à ".Env::v('login') . (Post::has('email') ? " Adresse de secours : " . Post::v('email') : "")); - $mymail->send(); + $mymail->send(); - // on cree un objet logger et on log l'evenement - S::logger(uid)->log('recovery', $mails); - } else { - $page->trigError('Les informations que tu as rentrées ne permettent pas de récupérer ton mot de passe.
'. - 'Si tu as un homonyme, utilise prenom.nom.promo comme login'); - } + // on cree un objet logger et on log l'evenement + S::logger($user->id())->log('recovery', $mails); } function handler_tmpPWD(&$page, $certif = null) { global $globals; - XDB::execute('DELETE FROM perte_pass - WHERE DATE_SUB(NOW(), INTERVAL 380 MINUTE) > created'); + // XXX: recovery requires data from the profile + XDB::execute('DELETE FROM account_lost_passwords + WHERE DATE_SUB(NOW(), INTERVAL 380 MINUTE) > created'); - $res = XDB::query('SELECT uid FROM perte_pass WHERE certificat={?}', $certif); + $res = XDB::query('SELECT uid + FROM account_lost_passwords WHERE certificat={?}', $certif); $ligne = $res->fetchOneAssoc(); if (!$ligne) { $page->changeTpl('platal/index.tpl'); @@ -374,10 +371,12 @@ Adresse de secours : " . Post::v('email') : "")); $uid = $ligne["uid"]; if (Post::has('response2')) { $password = Post::v('response2'); - 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); + XDB::query('UPDATE accounts + SET password={?} + WHERE uid = {?} AND state = \'active\'', + $password, $uid); + XDB::query('DELETE FROM account_lost_passwords + WHERE certificat={?}', $certif); // If GoogleApps is enabled, and the user did choose to use synchronized passwords, // updates the Google Apps password as well. @@ -405,21 +404,24 @@ Adresse de secours : " . Post::v('email') : "")); $page->setTitle('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')); + XDB::execute('UPDATE accounts + SET skin = {?} + WHERE uid = {?}', + Env::i('newskin'), S::i('uid')); S::kill('skin'); Platal::session()->setSkin(); } - $res = XDB::query('SELECT id FROM skins WHERE skin_tpl={?}', S::v('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"; + $sql = 'SELECT s.*, auteur, COUNT(*) AS nb + FROM skins AS s + LEFT JOIN accounts AS a ON (a.skin = s.id) + WHERE skin_tpl != \'\' AND ext != \'\' + GROUP BY id ORDER BY s.date DESC'; $page->assign('skins', XDB::iterator($sql)); } @@ -439,8 +441,10 @@ Adresse de secours : " . Post::v('email') : "")); Platal::session()->killLoginFormCookies(); } - S::logger()->log('deconnexion', @$_SERVER['HTTP_REFERER']); - Platal::session()->destroy(); + if (S::logged()) { + S::logger()->log('deconnexion', @$_SERVER['HTTP_REFERER']); + Platal::session()->destroy(); + } if (Get::has('redirect')) { http_redirect(rawurldecode(Get::v('redirect'))); @@ -453,7 +457,7 @@ Adresse de secours : " . Post::v('email') : "")); { // Include X-XRDS-Location response-header for Yadis discovery global $globals; - header('X-XRDS-Location: ' . $globals->baseurl . '/openid/idp_xrds'); + header('X-XRDS-Location: ' . $globals->baseurl . '/openid/xrds'); $this->load('review.inc.php'); $dom = 'Review';