X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=htdocs%2Femails%2Fbroken.php;h=ce6e7b28dfb5981f0f6b704b64f938b2b82aaa4e;hb=575dd9be519a557c47e1288eaa15b1e1446dd058;hp=698747dd6580e04f0b3b6298c0e511b080207686;hpb=0337d704b62718d7c77106c0e4c4e26fb02beacf;p=platal.git diff --git a/htdocs/emails/broken.php b/htdocs/emails/broken.php index 698747d..ce6e7b2 100644 --- a/htdocs/emails/broken.php +++ b/htdocs/emails/broken.php @@ -65,20 +65,27 @@ L' } } elseif (Post::has('email')) { $email = valide_email(Post::get('email')); - $page->assign('email',$email); - $sel = $globals->xdb->query( - "SELECT e1.uid, e1.panne != 0 AS panne, count(e2.uid) AS nb_mails, u.nom, u.prenom, u.promo - FROM emails as e1 - LEFT JOIN emails as e2 ON(e1.uid = e2.uid AND FIND_IN_SET('active', e2.flags) AND e1.email != e2.email) - INNER JOIN auth_user_md5 as u ON(e1.uid = u.user_id) - WHERE e1.email = {?} - GROUP BY e1.uid", $email); - if ($x = $sel->fetchOneAssoc()) { - // on écrit dans la base que l'adresse est cassée - if (!$x['panne']) { - $globals->xdb->execute("UPDATE emails SET panne=NOW() WHERE email = {?}", $email); + + list(,$fqdn) = explode('@', $email); + $fqdn = strtolower($fqdn); + if ($fqdn == 'polytechnique.org' || $fqdn == 'melix.org' || $fqdn == 'm4x.org' || $fqdn == 'melix.net') { + $page->assign('neuneu', true); + } else { + $page->assign('email',$email); + $sel = $globals->xdb->query( + "SELECT e1.uid, e1.panne != 0 AS panne, count(e2.uid) AS nb_mails, u.nom, u.prenom, u.promo + FROM emails as e1 + LEFT JOIN emails as e2 ON(e1.uid = e2.uid AND FIND_IN_SET('active', e2.flags) AND e1.email != e2.email) + INNER JOIN auth_user_md5 as u ON(e1.uid = u.user_id) + WHERE e1.email = {?} + GROUP BY e1.uid", $email); + if ($x = $sel->fetchOneAssoc()) { + // on écrit dans la base que l'adresse est cassée + if (!$x['panne']) { + $globals->xdb->execute("UPDATE emails SET panne=NOW() WHERE email = {?}", $email); + } + $page->assign_by_ref('x', $x); } - $page->assign_by_ref('x', $x); } }