- $events = XDB::iterator(
- 'SELECT SQL_CALC_FOUND_ROWS
- e.id, e.titre, UNIX_TIMESTAMP(e.creation_date) AS creation_date,
- IF(u.nom_usage = "", u.nom, u.nom_usage) AS nom, u.prenom, u.promo,
- ev.user_id IS NULL AS nonlu
- FROM evenements AS e
- INNER JOIN auth_user_md5 AS u ON e.user_id = u.user_id
- LEFT JOIN evenements_vus AS ev ON (e.id = ev.evt_id AND ev.user_id = {?})
- WHERE FIND_IN_SET("valide", e.flags) AND peremption >= NOW()
- AND (e.promo_min = 0 || e.promo_min <= {?})
- AND (e.promo_max = 0 || e.promo_max >= {?})
- ORDER BY e.creation_date DESC
- LIMIT {?}',
- S::i('uid'), S::i('promo'), S::i('promo'), 5);
- $page->assign('events', $events);
+ $events = XDB::iterator("SELECT SQL_CALC_FOUND_ROWS
+ e.id, e.titre, UNIX_TIMESTAMP(e.creation_date) AS creation_date,
+ ev.uid IS NULL AS nonlu, e.uid
+ FROM announces AS e
+ LEFT JOIN announce_read AS ev ON (e.id = ev.evt_id AND ev.uid = {?})
+ WHERE FIND_IN_SET('valide', e.flags) AND expiration >= NOW()
+ ORDER BY e.creation_date DESC", S::i('uid'));