X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fgadgets.php;h=188dc57077e017a65edcae31b6d586a225160ad8;hb=6d8ec13c63e3efbe91396273a3bf8449843e10d5;hp=40651cdeb4d30ae181a2c4ab63d8c629f7d6917d;hpb=06f4daf9ceb56712582d81330896848a1a262894;p=platal.git

diff --git a/modules/gadgets.php b/modules/gadgets.php
index 40651cd..188dc57 100644
--- a/modules/gadgets.php
+++ b/modules/gadgets.php
@@ -45,10 +45,10 @@ class GadgetsModule extends PLModule
         $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, e.user_id
+                                         ev.user_id IS NULL AS nonlu, e.uid
                                    FROM  announces AS e
-                              LEFT JOIN  announce_read AS ev ON (e.id = ev.evt_id AND ev.user_id = {?})
-                                  WHERE  FIND_IN_SET("valide", e.flags) AND peremption >= NOW()
+                              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'));
         $page->assign('event_count', XDB::query("SELECT FOUND_ROWS()")->fetchOneCell());