X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fgadgets.php;h=b8700de7c31a1f84520a0db0bd4ccec2d983668a;hb=d667c548989db9d77b9abb0efe46d89c60369fc1;hp=d769a9d8707ac9b2793d5b36ffc5b8512478e1d4;hpb=f280f651c1ea4059896655b132ddaec1e39cbd1b;p=platal.git diff --git a/modules/gadgets.php b/modules/gadgets.php index d769a9d..b8700de 100644 --- a/modules/gadgets.php +++ b/modules/gadgets.php @@ -42,14 +42,13 @@ class GadgetsModule extends PLModule require_once 'gadgets/gadgets.inc.php'; init_igoogle_html('gadgets/ig-events.tpl', AUTH_COOKIE); - $events = XDB::iterator('SELECT SQL_CALC_FOUND_ROWS + $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.uid - FROM announces AS e + 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 peremption >= NOW() - ORDER BY e.creation_date DESC', S::i('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()); Platal::load('events', 'feed.inc.php'); @@ -72,7 +71,9 @@ class GadgetsModule extends PLModule function handler_ig_search(&$page) { if (Env::has('quick') && Env::s('quick') != '') { + global $globals; require_once 'userset.inc.php'; + $view = new SearchSet(true); $view->addMod('gadget', 'Gadget', true); $view->apply(null, $page); @@ -86,6 +87,8 @@ class GadgetsModule extends PLModule $page->assign('error', 'Recherche trop générale.'); } elseif (empty($nb_tot)) { $page->assign('error', 'Il n\'existe personne correspondant à ces critères dans la base !'); + } else { + $page->assign('error', false); } }