CONCAT(b.alias, '@m4x.org') AS email,
CONCAT(b.alias, '@polytechnique.org') AS email2,
m.perms='admin' AS perms, m.origine,
- FIND_IN_SET(flags, 'femme') AS sexe
+ FIND_IN_SET(u.flags, 'femme') AS sexe
FROM auth_user_md5 AS u
INNER JOIN aliases AS a ON ( u.user_id = a.id AND a.type != 'homonyme' )
INNER JOIN aliases AS b ON ( u.user_id = b.id AND b.type = 'a_vie' )
{
global $globals;
- define('NB_PER_PAGE', 25);
-
if ($globals->asso('pub') == 'public') {
new_group_page('xnet/groupe/annuaire.tpl');
} else {
}
$page->assign('group', $group);
$page->assign('request_group', Env::v($group));
+ $page->assign('only_admin', Env::has('admin'));
$page->assign('alphabet', $alphabet);
$page->assign('nb_tot', $nb_tot);
} elseif (Env::has('promo')) {
$ini = 'AND IF(m.origine="X", u.promo, "extérieur") = "'
.addslashes(Env::v('promo')).'"';
+ } elseif (Env::has('admin')) {
+ $ini = 'AND m.perms = "admin"';
}
$ann = XDB::iterator(
AND (m.origine = 'ext' OR u.perms != 'pending' OR m.email IS NOT NULL)
ORDER BY $tri
LIMIT {?},{?}", $globals->asso('id'), $ofs*NB_PER_PAGE, NB_PER_PAGE);
-
$page->assign('ann', $ann);
}
function handler_admin_member_new_ajax(&$page)
{
+ header('Content-Type: text/html; charset="iso-8859-15"');
$page->changeTpl('xnet/groupe/membres-new-search.tpl', NO_SKIN);
list($nom, $prenom) = str_replace(array('-', ' ', "'"), '%', array(Env::v('nom'), Env::v('prenom')));
$where = "perms = 'pending'";
if (!empty($prenom)) {
$where .= " AND prenom LIKE '%$prenom%'";
}
- if (is_numeric(Env::v('promo'))) {
+ if (preg_match('/^[0-9]{4}$/', Env::v('promo'))) {
$where .= " AND promo = " . Env::i('promo');
+ } elseif (Env::has('promo')) {
+ return;
}
$res = XDB::iterator("SELECT user_id, nom, prenom, promo
FROM auth_user_md5