X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=modules%2Fevents%2Ffeed.inc.php;h=ac3ee0f7d9bbdfba14ff2280879dea516e750871;hb=73be44347c469de3cf128923e0221b4244915fa6;hp=4e93712c82b47ffd1ebfa8983158affab1e754f4;hpb=61fa44d9e655ba1d183d38b886571907da17920b;p=platal.git diff --git a/modules/events/feed.inc.php b/modules/events/feed.inc.php index 4e93712..ac3ee0f 100644 --- a/modules/events/feed.inc.php +++ b/modules/events/feed.inc.php @@ -33,17 +33,19 @@ class EventFeed extends PlFeed protected function fetch($user) { + global $globals; return XDB::iterator( 'SELECT e.id, e.titre AS title, e.texte, e.creation_date AS publication, e.post_id, p.attachmime IS NOT NULL AS photo, - CONCAT(u2.prenom, " ", IF(u2.nom_usage = "", u2.nom, u2.nom_usage), "(X", u2.promo, ")") AS author, - FIND_IN_SET(\'wiki\', e.flags) AS wiki + CONCAT(u2.prenom, " ", IF(u2.nom_usage = "", u2.nom, u2.nom_usage), " (X", u2.promo, ")") AS author, + FIND_IN_SET(\'wiki\', e.flags) AS wiki, + CONCAT({?}, "/events#newsid", e.id) AS link FROM auth_user_md5 AS u INNER JOIN evenements AS e ON ( (e.promo_min = 0 || e.promo_min <= u.promo) AND (e.promo_max = 0 || e.promo_max >= u.promo) ) LEFT JOIN evenements_photo AS p ON (p.eid = e.id) INNER JOIN auth_user_md5 AS u2 ON (u2.user_id = e.user_id) WHERE u.user_id = {?} AND FIND_IN_SET("valide", e.flags) - AND peremption >= NOW()', $user); + AND peremption >= NOW()', $globals->baseurl, $user); } }