xdb->query( "SELECT u.nom,u.nom_usage,u.flags,e.alias FROM auth_user_md5 AS u LEFT JOIN aliases AS e ON(u.user_id = e.id AND FIND_IN_SET('usage',e.flags)) WHERE user_id={?}", Session::getInt('uid')); list($nom,$usage_old,$flags,$alias_old) = $res->fetchOneRow(); $flags = new flagset($flags); $page->assign('usage_old', $usage_old); $page->assign('alias_old', $alias_old); $nom_usage = replace_accent(trim(Env::get('nom_usage'))); $nom_usage = strtoupper($nom_usage); $page->assign('usage_req', $nom_usage); if (Env::has('submit') && ($nom_usage != $usage_old)) { // on vient de recevoir une requete, differente de l'ancien nom d'usage if ($nom_usage == $nom) { $page->assign('same', true); } else { // le nom de mariage est distinct du nom à l'X // on calcule l'alias pour l'afficher $reason = Env::get('reason'); if ($reason == 'other') $reason = Env::get('other_reason'); $myusage = new UsageReq(Session::getInt('uid'), $nom_usage, $reason); $myusage->submit(); $page->assign('myusage', $myusage); } } $page->run(); ?>