|
From: Jirka P. <fi...@us...> - 2002-06-26 09:56:56
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv1111/phpbt/inc/db Modified Files: pgsql.php Log Message: Fixed bugfix. :-) Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.10 retrieving revision 1.11 diff -u -r1.10 -r1.11 --- pgsql.php 26 Jun 2002 09:36:27 -0000 1.10 +++ pgsql.php 26 Jun 2002 09:56:53 -0000 1.11 @@ -75,7 +75,7 @@ 'from '.TBL_BUG.' b '. 'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '. 'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id '. - 'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id, '. + 'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id '. 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id, '. TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '. TBL_VERSION.' version, '.TBL_COMPONENT.' component, '. @@ -133,9 +133,9 @@ 'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '. 'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id '. 'left join '.TBL_AUTH_USER.' lastmodifier on b.last_modified_by = lastmodifier.user_id '. - 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_id, '. - 'left join '.TBL_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id, '. - 'left join '.TBL_VERSION.' on version2 b.to_be_closed_in_version_id = version2.version_id, '. + 'left join '.TBL_RESOLUTION.' resolution on b.resolution_id = resolution.resolution_i, '. + 'left join '.TBL_DATABASE.' on b.database_id = '.TBL_DATABASE.'.database_id '. + 'left join '.TBL_VERSION.' on version2 b.to_be_closed_in_version_id = version2.version_id '. 'left join '.TBL_VERSION.' on version3 b.closed_id_version_id = version3.version_id, '. TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '. TBL_VERSION.' version, '.TBL_COMPONENT.' component, '.TBL_PROJECT.' project '. |