|
From: Benjamin C. <bc...@us...> - 2002-04-03 01:01:06
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv15790/db Modified Files: mysql.php oci8.php pgsql.php Log Message: Switching to smarty templates. Updating copyright notices Index: mysql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v retrieving revision 1.2 retrieving revision 1.3 diff -u -r1.2 -r1.3 --- mysql.php 29 Mar 2002 18:25:38 -0000 1.2 +++ mysql.php 3 Apr 2002 01:01:04 -0000 1.3 @@ -116,10 +116,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 ', - 'query-list-bugs' => 'select b.*, reporter.login as reporter, '. - 'owner.login as owner, lastmodifier.login as lastmodifier, '. - 'project_name, severity_name, severity_color, status_name, '. - 'os_name, version_name, component_name, resolution_name '. + 'query-list-bugs' => 'select %s '. '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 '. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.1 retrieving revision 1.2 diff -u -r1.1 -r1.2 --- oci8.php 29 Mar 2002 18:25:38 -0000 1.1 +++ oci8.php 3 Apr 2002 01:01:04 -0000 1.2 @@ -118,11 +118,7 @@ 'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter '. 'where b.assigned_to = owner.user_id(+) '. 'and b.created_by = reporter.user_id(+) ', - 'query-list-bugs' => 'select b.*, reporter.login as reporter, '. - 'owner.login as owner, lastmodifier.login as lastmodifier, '. - 'project.project_name, severity.severity_name, severity.severity_color, '. - 'status.status_name, os.os_name, version.version_name,'. - 'component.component_name, resolution.resolution_name '. + 'query-list-bugs' => 'select %s '. 'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' lastmodifier, '. TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter, '. TBL_SEVERITY.' severity, '.TBL_STATUS.' status, '.TBL_OS.' os, '. Index: pgsql.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v retrieving revision 1.3 retrieving revision 1.4 diff -u -r1.3 -r1.4 --- pgsql.php 29 Mar 2002 18:25:38 -0000 1.3 +++ pgsql.php 3 Apr 2002 01:01:04 -0000 1.4 @@ -116,10 +116,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 ', - 'query-list-bugs' => 'select b.*, reporter.login as reporter, '. - 'owner.login as owner, lastmodifier.login as lastmodifier, '. - 'project_name, severity_name, severity_color, status_name, '. - 'os_name, version_name, component_name, resolution_name '. + 'query-list-bugs' => 'select %s '. '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 '. |