From 08b6cc444e8956fa9838c9067dce50362d27758d Mon Sep 17 00:00:00 2001 From: x2003bruneau Date: Wed, 29 Nov 2006 12:26:58 +0000 Subject: [PATCH] Oops git-svn-id: svn+ssh://murphy/home/svn/platal/branches/platal-0.9.12@1199 839d8a87-29fc-0310-9880-83ba4fa771e5 --- modules/xnetgrp.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/modules/xnetgrp.php b/modules/xnetgrp.php index 580716b..6f13e5f 100644 --- a/modules/xnetgrp.php +++ b/modules/xnetgrp.php @@ -964,13 +964,15 @@ class XnetGrpModule extends PLModule INNER JOIN groupex.announces AS a ON ( (a.promo_min = 0 OR a.promo_min <= u.promo) AND (a.promo_max = 0 OR a.promo_max <= u.promo)) INNER JOIN auth_user_md5 AS u2 ON (u2.user_id = a.user_id) - WHERE u.user_id = {?} AND peremption >= NOW()", $uid); + WHERE u.user_id = {?} AND peremption >= NOW() AND a.asso_id = {?}", + $uid, $globals->asso('id')); } else { $rss = XDB::iterator("SELECT a.id, a.titre, a.texte, a.create_date, IF(u.nom_usage != '', u.nom_usage, u.nom) AS nom, u.prenom, u.promo FROM groupex.announces AS a INNER JOIN auth_user_md5 AS u USING(user_id) - WHERE FIND_IN_SET(a.flags, 'public') AND peremption >= NOW()"); + WHERE FIND_IN_SET(a.flags, 'public') AND peremption >= NOW() AND a.asso_id = {?}", + $globals->asso('id')); } $page->assign('asso', $globals->asso()); $page->assign('rss', $rss); -- 2.1.4