X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=htdocs%2Femails.php;h=d2a8facbfb7229b9db825e5cdcf594c09291b8a2;hb=4f7cc1b23155938922b82d58c077324d0e97a466;hp=9ae78bf0ee351d07a7fd6afbce35f5340965dd26;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git

diff --git a/htdocs/emails.php b/htdocs/emails.php
index 9ae78bf..d2a8fac 100644
--- 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)";