Add a flag "Must be validated" for medals instead of hard-coding this
[platal.git] / include / profil / assign_deco.inc.php
1 <?php
2 /***************************************************************************
3 * Copyright (C) 2003-2006 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
23 $res = XDB::iterator("SELECT * FROM profile_medals_grades ORDER BY mid, pos");
24 $grades = Array();
25 while ($tmp = $res->next()) {
26 $grades[$tmp['mid']][] = $tmp;
27 }
28
29 $res = XDB::iterator("SELECT *, FIND_IN_SET(flags, 'validation') AS validate FROM profile_medals ORDER BY type, text");
30 $mlist = Array();
31 while ($tmp = $res->next()) {
32 $mlist[$tmp['type']][] = $tmp;
33 }
34
35 $trad = Array('ordre' => 'Ordres ...', 'croix' => 'Croix ...', 'militaire' => 'Médailles militaires ...',
36 'honneur' => 'Médailles d\'honneur', 'resistance' => 'Médailles de la résistance ...', 'prix' => 'Prix ...');
37
38 $page->assign('grades', $grades);
39 $page->assign('medals', $medals);
40 $page->assign('trad', $trad);
41 $page->assign('medals_pub', $medals_pub);
42 $page->assign('medal_list', $mlist);
43 $page->assign('medals_valid', $medals_valid);
44
45 ?>