affiche le ChangeLog sur une page du site

[platal.git] / htdocs / emails.php

diff --git a/htdocs/emails.php b/htdocs/emails.php
index 9ae78bf..d2a8fac 100644 (file)
--- a/htdocs/emails.php
+++ b/htdocs/emails.php
@@ -21,6 +21,7 @@
 
 require_once("xorg.inc.php");
 new_skinned_page('emails.tpl',AUTH_COOKIE);
+$page->assign('xorg_title','Polytechnique.org - Mes emails');
 
 $uid = Session::getInt('uid');
 
@@ -32,7 +33,7 @@ if (Post::has('best')) {
 }
 
 // on regarde si on a affaire à un homonyme
-$sql = "SELECT  alias, (type='a_vie') AS a_vie, FIND_IN_SET('bestalias',flags) AS best, expire
+$sql = "SELECT  alias, (type='a_vie') AS a_vie, (alias REGEXP '\\\\.[0-9]{2}$') AS cent_ans, FIND_IN_SET('bestalias',flags) AS best, expire
           FROM  aliases
          WHERE  id = {?} AND type!='homonyme'
       ORDER BY  LENGTH(alias)";