X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;ds=sidebyside;f=modules%2Fprofile%2Fgeneral.inc.php;h=945c54f6847d76336f8001de6b5c8ff5ff717a9d;hb=8320b6fba6fa245dd71ae9c11b2a2a03f923d15d;hp=ecb18b32ee15a318cf17e4d709e3f6d870e6d7fb;hpb=a16cf1c2e56cc6e4c6cda1e984d2659c4cf0450c;p=platal.git diff --git a/modules/profile/general.inc.php b/modules/profile/general.inc.php index ecb18b3..945c54f 100644 --- a/modules/profile/general.inc.php +++ b/modules/profile/general.inc.php @@ -290,7 +290,7 @@ class ProfileGeneral extends ProfilePage protected function _fetchData() { // Checkout all data... - $res = XDB::query("SELECT p.promo_display, e.entry_year AS entry_year, e.grad_year AS grad_year, + $res = XDB::query("SELECT p.promo AS promo_display, e.entry_year AS entry_year, e.grad_year AS grad_year, u.nom_usage, u.nationalite, u.nationalite2, u.nationalite3, u.naissance, t.display_tel as mobile, t.pub as mobile_pub, d.email_directory as email_directory, @@ -301,7 +301,7 @@ class ProfileGeneral extends ProfilePage FROM auth_user_md5 AS u INNER JOIN auth_user_quick AS q ON (u.user_id = q.user_id) INNER JOIN profile_names_display AS n ON (n.user_id = u.user_id) - INNER JOIN profile_display AS p ON (p.uid = u.user_id) + INNER JOIN profile_display AS p ON (p.pid = u.user_id) INNER JOIN profile_education AS e ON (e.uid = u.user_id AND FIND_IN_SET('primary', e.flags)) LEFT JOIN profile_phones AS t ON (u.user_id = t.uid AND link_type = 'user') LEFT JOIN profile_directory AS d ON (d.uid = u.user_id) @@ -407,8 +407,8 @@ class ProfileGeneral extends ProfilePage } if ($this->changed['promo_display']) { XDB::execute("UPDATE profile_display - SET promo_display = {?} - WHERE uid = {?}", + SET promo = {?} + WHERE pid = {?}", $this->values['promo_display'], S::v('uid')); } }