0337d704 |
1 | <?php |
2 | /*************************************************************************** |
3 | * Copyright (C) 2003-2004 Polytechnique.org * |
4 | * http://opensource.polytechnique.org/ * |
5 | * * |
6 | * This program is free software; you can redistribute it and/or modify * |
7 | * it under the terms of the GNU General Public License as published by * |
8 | * the Free Software Foundation; either version 2 of the License, or * |
9 | * (at your option) any later version. * |
10 | * * |
11 | * This program is distributed in the hope that it will be useful, * |
12 | * but WITHOUT ANY WARRANTY; without even the implied warranty of * |
13 | * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the * |
14 | * GNU General Public License for more details. * |
15 | * * |
16 | * You should have received a copy of the GNU General Public License * |
17 | * along with this program; if not, write to the Free Software * |
18 | * Foundation, Inc., * |
19 | * 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA * |
20 | ***************************************************************************/ |
21 | |
22 | // on ramène les données du profil connecté (uid paramètre de session) |
23 | $sql = "SELECT u.nom, u.prenom, u.nom_ini, u.prenom_ini, u.promo, u.promo_sortie, u.nom_usage, u.nationalite, |
24 | q.profile_mobile, q.profile_mobile_pub, q.profile_web, q.profile_web_pub, q.profile_freetext, q.profile_freetext_pub, q.profile_nick, |
25 | a1.aid, a1.type, a2.aid, a2.type |
26 | FROM auth_user_md5 AS u |
27 | INNER JOIN auth_user_quick AS q USING(user_id) |
28 | LEFT JOIN applis_ins AS a1 ON(a1.uid = u.user_id and a1.ordre = 0) |
29 | LEFT JOIN applis_ins AS a2 ON(a2.uid = u.user_id and a2.ordre = 1) |
30 | WHERE u.user_id = {?}"; |
31 | |
32 | $result = $globals->xdb->query($sql, Session::getInt('uid', -1)); |
33 | list($nom, $prenom, $nom_ini, $prenom_ini, $promo, $promo_sortie, $nom_usage, $nationalite, |
34 | $mobile, $mobile_pub, $web, $web_pub, $freetext, $freetext_pub, $nickname, |
35 | $appli_id1,$appli_type1, $appli_id2,$appli_type2) = $result->fetchOneRow(); |
36 | |
37 | $result = $globals->xdb->query("SELECT pub FROM photo WHERE uid = {?}", Session::getInt('uid', -1)); |
38 | $photo_pub = $result->fetchOneCell(); |
39 | |
40 | $nom_anc = $nom; |
41 | $prenom_anc = $prenom; |
42 | $nationalite_anc = $nationalite; |
43 | $nickname_anc = $nickname; |
44 | |
45 | replace_ifset($nom,'nom'); |
46 | replace_ifset($prenom,'prenom'); |
47 | replace_ifset($nationalite,'nationalite'); |
48 | replace_ifset($mobile,'mobile'); |
49 | replace_ifset($web,"web"); |
50 | replace_ifset($freetext,"freetext"); |
51 | replace_ifset($appli_id1,"appli_id1"); |
52 | replace_ifset($appli_id2,"appli_id2"); |
53 | replace_ifset($appli_type1,"appli_type1"); |
54 | replace_ifset($appli_type2,"appli_type2"); |
55 | replace_ifset($nickname,"nickname"); |
56 | |
57 | if(Env::has('modifier') || Env::has('suivant')) { |
58 | $mobile_pub = Env::get('mobile_pub'); |
59 | $web_pub = Env::has('web_pub')?'public':'private'; |
60 | $freetext_pub = Env::has('freetext_pub')?'public':'private'; |
61 | $photo_pub = Env::has('photo_pub')?'public':'private'; |
62 | } |
63 | |
64 | require_once("xorg.misc.inc.php"); |
65 | $nom = strtoupper($nom); |
66 | $nom_comp = replace_accent($nom); |
67 | $nom_anc_comp = replace_accent($nom_anc); |
68 | |
69 | $prenom = make_firstname_case($prenom); |
70 | $prenom_comp = replace_accent($prenom); |
71 | $prenom_anc_comp = replace_accent($prenom_anc); |
72 | |
73 | // Y a-t-il une photo en attente de confirmation ? |
74 | $sql = $globals->xdb->query("SELECT COUNT(*) FROM requests WHERE type='photo' AND user_id = {?}", Session::getInt('uid', -1)); |
75 | $nouvellephoto=$sql->fetchOneCell(); |
76 | |
77 | // vim:set et sws=4 sw=4 sts=4: |
78 | ?> |