X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=classes%2Fprofile.php;h=7af43e9d060723a1e7ac35279363c3bc35c974d1;hb=c52d86d1d876e6def108e1d458604cc9714c252d;hp=6151a1a32a4571a8c3689f6625ba0656ef2978c2;hpb=4f247453ac4a734953df893117b72168c60dd22e;p=platal.git diff --git a/classes/profile.php b/classes/profile.php index 6151a1a..7af43e9 100644 --- a/classes/profile.php +++ b/classes/profile.php @@ -38,7 +38,7 @@ class Profile $from = 'profiles AS p'; $where = XDB::format('p.hrpid = {?}', $login); } - $res = XDB::query('SELECT p.*, pe.entry_year, pe.grad_year, + $res = XDB::query('SELECT p.*, p.sex = \'female\' AS sex, pe.entry_year, pe.grad_year, pn_f.name AS firstname, pn_l.name AS lastname, pn_n.name AS nickname, IF(pn_uf.name IS NULL, pn_f.name, pn_uf.name) AS firstname_usual, IF(pn_ul.name IS NULL, pn_l.name, pn_ul.name) AS lastname_usual,