X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fgadgets.php;h=40651cdeb4d30ae181a2c4ab63d8c629f7d6917d;hb=1d49ff4ae684f13250408798f4b0a945797a5229;hp=ede101f7ccfec2f8cbace0d0b573b309e3e99d6c;hpb=a0b453227e9433d2bd4dea1e07a7463800702839;p=platal.git diff --git a/modules/gadgets.php b/modules/gadgets.php index ede101f..40651cd 100644 --- a/modules/gadgets.php +++ b/modules/gadgets.php @@ -1,6 +1,6 @@ $this->make_hook('ig_events_xml', AUTH_PUBLIC, 'user', NO_HTTPS), - 'gadgets/ig-events' => $this->make_hook('ig_events', AUTH_PUBLIC), + 'gadgets/ig-events' => $this->make_hook('ig_events', AUTH_PUBLIC), 'gadgets/ig-search.xml' => $this->make_hook('ig_search_xml', AUTH_PUBLIC, 'user', NO_HTTPS), - 'gadgets/ig-search' => $this->make_hook('ig_search', AUTH_PUBLIC), + 'gadgets/ig-search' => $this->make_hook('ig_search', AUTH_PUBLIC), ); } @@ -46,8 +46,8 @@ class GadgetsModule extends PLModule 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 - FROM evenements AS e - LEFT JOIN evenements_vus AS ev ON (e.id = ev.evt_id AND ev.user_id = {?}) + 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() ORDER BY e.creation_date DESC', S::i('uid')); $page->assign('event_count', XDB::query("SELECT FOUND_ROWS()")->fetchOneCell());