<?php
/***************************************************************************
- * Copyright (C) 2003-2004 Polytechnique.org *
+ * Copyright (C) 2003-2007 Polytechnique.org *
* http://opensource.polytechnique.org/ *
* *
* This program is free software; you can redistribute it and/or modify *
***************************************************************************/
-$res = $globals->xdb->iterator("SELECT * FROM profile_medals_grades ORDER BY mid, pos");
+$res = XDB::iterator("SELECT * FROM profile_medals_grades ORDER BY mid, pos");
$grades = Array();
while ($tmp = $res->next()) {
$grades[$tmp['mid']][] = $tmp;
}
-$res = $globals->xdb->iterator("SELECT * FROM profile_medals ORDER BY type, text");
+$res = XDB::iterator("SELECT *, FIND_IN_SET(flags, 'validation') AS validate FROM profile_medals ORDER BY type, text");
$mlist = Array();
while ($tmp = $res->next()) {
$mlist[$tmp['type']][] = $tmp;
$trad = Array('ordre' => 'Ordres ...', 'croix' => 'Croix ...', 'militaire' => 'Médailles militaires ...',
'honneur' => 'Médailles d\'honneur', 'resistance' => 'Médailles de la résistance ...', 'prix' => 'Prix ...');
-$page->gassign('grades');
-$page->gassign('medals');
-$page->gassign('trad');
+$page->assign('grades', $grades);
+$page->assign('medals', $medals);
+$page->assign('trad', $trad);
$page->assign('medals_pub', $medals_pub);
$page->assign('medal_list', $mlist);
+$page->assign('medals_valid', $medals_valid);
?>