diff options
Diffstat (limited to 'devel/flyspray/files/patch-index.php')
| -rw-r--r-- | devel/flyspray/files/patch-index.php | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/devel/flyspray/files/patch-index.php b/devel/flyspray/files/patch-index.php new file mode 100644 index 0000000..3edb77a --- /dev/null +++ b/devel/flyspray/files/patch-index.php @@ -0,0 +1,29 @@ +--- index.php.orig Sat Oct 22 13:40:26 2005 ++++ index.php Thu Oct 27 00:09:01 2005 +@@ -384,15 +384,17 @@ + // or, if the user is logged in + } elseif (isset($_COOKIE['flyspray_userid'])) + { +- $get_projects = $db->Query("SELECT DISTINCT p.* +- FROM {$dbprefix}users_in_groups uig +- LEFT JOIN {$dbprefix}groups g ON uig.group_id = g.group_id, +- {$dbprefix}projects p +- WHERE ((uig.user_id = ? +- AND g.view_tasks = '1') +- OR p.others_view = '1') +- AND p.project_is_active = '1' +- GROUP BY p.project_id", ++ $get_projects = $db->Query("SELECT p.* FROM {$dbprefix}projects p ++ LEFT JOIN {$dbprefix}groups g ++ ON p.project_id=g.belongs_to_project ++ AND g.view_tasks=1 ++ LEFT JOIN {$dbprefix}users_in_groups uig ++ ON uig.group_id = g.group_id ++ AND uig.user_id = ? ++ WHERE p.project_is_active='1' ++ AND (p.others_view ++ OR uig.user_id IS NOT NULL) ++ ORDER BY p.project_title", + array($current_user['user_id']) + ); + // Anonymous users |
