From 04396ebcaa4292b0e4461a6fed39aa2ab221839b Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Thu, 23 Jun 2011 10:34:15 +0800 Subject: [PATCH] MTrackWeb.php --- MTrackWeb.php | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/MTrackWeb.php b/MTrackWeb.php index 5f783ef7..dc5b1923 100644 --- a/MTrackWeb.php +++ b/MTrackWeb.php @@ -143,6 +143,10 @@ class MTrackWeb extends HTML_FlexyFramework_Page } else { $p->applyFilters(array(), $this->authUser); + + $p->whereAdd("Projects.id in (SELECT ProjectDirectory.project_id FROM ProjectDirectory WHERE + user_id = '. $this->authUser->id . ' and role != '')") + $p->whereAdd('id in (SELECT distinct(project_id) FROM mtrack_repos)'); // $pd->whereAdd("role != ''"); -- 2.39.2