0337d704 |
1 | <?php |
2 | /*************************************************************************** |
5ddeb07c |
3 | * Copyright (C) 2003-2007 Polytechnique.org * |
0337d704 |
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 | |
a7de4ef7 |
22 | // on ramène les données du profil connecté (uid paramètre de session) |
0337d704 |
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, |
dd502514 |
25 | q.profile_from_ax, u.matricule_ax, |
0337d704 |
26 | a1.aid, a1.type, a2.aid, a2.type |
27 | FROM auth_user_md5 AS u |
28 | INNER JOIN auth_user_quick AS q USING(user_id) |
29 | LEFT JOIN applis_ins AS a1 ON(a1.uid = u.user_id and a1.ordre = 0) |
30 | LEFT JOIN applis_ins AS a2 ON(a2.uid = u.user_id and a2.ordre = 1) |
31 | WHERE u.user_id = {?}"; |
32 | |
cab08090 |
33 | $result = XDB::query($sql, S::v('uid', -1)); |
0337d704 |
34 | list($nom, $prenom, $nom_ini, $prenom_ini, $promo, $promo_sortie, $nom_usage, $nationalite, |
35 | $mobile, $mobile_pub, $web, $web_pub, $freetext, $freetext_pub, $nickname, |
dd502514 |
36 | $synchro_ax, $matricule_ax, |
0337d704 |
37 | $appli_id1,$appli_type1, $appli_id2,$appli_type2) = $result->fetchOneRow(); |
38 | |
cab08090 |
39 | $result = XDB::query("SELECT pub FROM photo WHERE uid = {?}", S::v('uid', -1)); |
0337d704 |
40 | $photo_pub = $result->fetchOneCell(); |
41 | |
42 | $nom_anc = $nom; |
43 | $prenom_anc = $prenom; |
44 | $nationalite_anc = $nationalite; |
45 | $nickname_anc = $nickname; |
46 | |
47 | replace_ifset($nom,'nom'); |
48 | replace_ifset($prenom,'prenom'); |
49 | replace_ifset($nationalite,'nationalite'); |
50 | replace_ifset($mobile,'mobile'); |
51 | replace_ifset($web,"web"); |
52 | replace_ifset($freetext,"freetext"); |
53 | replace_ifset($appli_id1,"appli_id1"); |
54 | replace_ifset($appli_id2,"appli_id2"); |
55 | replace_ifset($appli_type1,"appli_type1"); |
56 | replace_ifset($appli_type2,"appli_type2"); |
57 | replace_ifset($nickname,"nickname"); |
58 | |
2f678da1 |
59 | if(Env::has('modifier') || Env::has('suivant') && $opened_tab == 'general') { |
5e2307dc |
60 | $mobile_pub = Env::v('mobile_pub'); |
0337d704 |
61 | $web_pub = Env::has('web_pub')?'public':'private'; |
62 | $freetext_pub = Env::has('freetext_pub')?'public':'private'; |
63 | $photo_pub = Env::has('photo_pub')?'public':'private'; |
3b3e9d15 |
64 | $synchro_ax = Env::has("synchro_ax")?1:0; |
0337d704 |
65 | } |
66 | |
67 | require_once("xorg.misc.inc.php"); |
68 | $nom = strtoupper($nom); |
69 | $nom_comp = replace_accent($nom); |
70 | $nom_anc_comp = replace_accent($nom_anc); |
71 | |
72 | $prenom = make_firstname_case($prenom); |
73 | $prenom_comp = replace_accent($prenom); |
74 | $prenom_anc_comp = replace_accent($prenom_anc); |
75 | |
76 | // Y a-t-il une photo en attente de confirmation ? |
cab08090 |
77 | $sql = XDB::query("SELECT COUNT(*) FROM requests WHERE type='photo' AND user_id = {?}", S::v('uid', -1)); |
0337d704 |
78 | $nouvellephoto=$sql->fetchOneCell(); |
79 | |
a7de4ef7 |
80 | // vim:set et sws=4 sw=4 sts=4 enc=utf-8: |
0337d704 |
81 | ?> |