-
- function _trombi_getlist($offset, $limit)
- {
- $where = ( $this->promo > 0 ? "WHERE promo='{$this->promo}'" : "" );
-
- $res = XDB::query(
- "SELECT COUNT(*)
- FROM auth_user_md5 AS u
- RIGHT JOIN photo AS p ON u.user_id=p.uid
- $where");
- $pnb = $res->fetchOneCell();
-
- $res = XDB::query(
- "SELECT promo, user_id, a.alias AS forlife,
- IF (nom_usage='', nom, nom_usage) AS nom, prenom
- FROM photo AS p
- INNER JOIN auth_user_md5 AS u ON u.user_id=p.uid
- INNER JOIN aliases AS a ON ( u.user_id=a.id AND a.type='a_vie' )
- $where
- ORDER BY promo, nom, prenom LIMIT {?}, {?}", $offset*$limit, $limit);
-
- return array($pnb, $res->fetchAllAssoc());
- }
-