global $globals;
$this->entriesPerPage = $globals->search->per_page;
if (@$params['with_score']) {
- $this->addSortKey('score', array('-score', '-watch_last', '-promo', 'nom', 'prenom'), 'pertinence');
+ $this->addSortKey('score', array('-score', '-date', '-promo', 'nom', 'prenom'), 'pertinence');
}
$this->addSortKey('name', array('nom', 'prenom'), 'nom');
$this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
- $this->addSortKey('date', array('-watch_last', '-promo', 'nom', 'prenom'), 'dernière modification');
+ $this->addSortKey('date_mod', array('-date', '-promo', 'nom', 'prenom'), 'dernière modification');
parent::__construct($set, $data, $params);
}
$this->addSortKey('rand', array('RAND(' . S::i('uid') . ')'), 'aléatoirement');
$this->addSortKey('name', array('nom', 'prenom'), 'nom');
$this->addSortKey('promo', array('-promo', 'nom', 'prenom'), 'promotion');
- $this->addSortKey('date', array('-watch_last', '-promo', 'nom', 'prenom'), 'dernière modification');
+ $this->addSortKey('date_mod', array('-date', '-promo', 'nom', 'prenom'), 'dernière modification');
parent::__construct($set, $data, $params);
}
$it =& $this->set->get('u.user_id AS id, u.prenom, u.nom, u.promo, al.alias',
"INNER JOIN adresses AS adrf ON (adrf.uid = u.user_id)
LEFT JOIN aliases AS al ON (u.user_id = al.id
- AND FIND_IN_SET(al.flags, 'bestalias'))
- INNER JOIN adresses AS av ON (" . getadr_join('av') . ")",
+ AND FIND_IN_SET('bestalias', al.flags))
+ INNER JOIN adresses AS avg ON (" . getadr_join('avg') . ")",
'adrf.cityid = ' . Env::i('cityid'), null, null, 11);
$page->assign('users', $it);
break;