|
From: Benjamin C. <bc...@us...> - 2002-12-17 13:27:24
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory sc8-pr-cvs1:/tmp/cvs-serv13459/inc/db Modified Files: pgsql.php Log Message: Same as before. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.21 retrieving revision 1.22 diff -u -r1.21 -r1.22 --- pgsql.php 17 Dec 2002 13:26:07 -0000 1.21 +++ pgsql.php 17 Dec 2002 13:27:21 -0000 1.22 @@ -100,7 +100,7 @@ 'functions-bug-cc' => 'select b.user_id, login '. 'from '.TBL_BUG_CC.' b left join '. TBL_AUTH_USER.' using(user_id) '. 'where bug_id = %s', - 'functions-project-js' => 'select p.project_id, project_name '. + 'functions-project-js' => 'select p.project_id, p.project_name '. 'from '.TBL_PROJECT. ' p '. 'left join '.TBL_PROJECT_GROUP.' pg using(project_id) '. 'where active = 1 and (pg.project_id is null or pg.group_id in (%s)) '. |