$view->addMod('minifiche', 'Minifiches', true);
$view->addMod('trombi', 'Trombinoscope', false, array('with_promo' => true));
$view->addMod('geoloc', 'Planishpère');
- $view->apply('search', $page, $action, $subaction);
+ $view->apply('search/adv', $page, $action, $subaction);
if ($subaction) {
return;
}
// default search
+ $q = preg_quote($q);
$unique = '`user_id`';
$db = '`auth_user_md5`';
$realid = false;
$db = '`groupesx_def`';
break;
case 'nationalite':
- $db = '`geoloc_pays`';
+ $db = '`geoloc_pays` INNER JOIN
+ `auth_user_md5` ON (`geoloc_pays`.`a2` = `auth_user_md5`.`nationalite`)';
$field = 'IF(`nat`=\'\', `pays`, `nat`)';
$id = '`a2`';
break;
$page->assign('list', XDB::iterator('SELECT '.$field.' AS field,
'.$id.' AS id
FROM '.$db.$where.'
+ GROUP BY '.$field.'
ORDER BY '.$field));
}
}