Update of /cvsroot/phpbt/phpbt/inc/db
In directory usw-pr-cvs1:/tmp/cvs-serv26076/inc/db
Modified Files:
mysql.php oci8.php pgsql.php
Log Message:
Fixes bug #546264 - Someone verify, please. :)
Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -r1.12 -r1.13
--- mysql.php 18 Jul 2002 13:02:15 -0000 1.12
+++ mysql.php 3 Sep 2002 19:44:56 -0000 1.13
@@ -129,7 +129,7 @@
'query-list-bugs-count' => 'select count(*) '.
'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.' reporter on b.created_by = reporter.user_id where ',
'query-list-bugs' => 'select %s '.
'from '.TBL_BUG.' b '.
'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '.
Index: oci8.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- oci8.php 18 Jul 2002 13:02:15 -0000 1.8
+++ oci8.php 3 Sep 2002 19:44:57 -0000 1.9
@@ -132,7 +132,7 @@
'query-list-bugs-count' => 'select count(*) '.
'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(+) ',
+ 'and b.created_by = reporter.user_id(+) and ',
'query-list-bugs' => 'select %s '.
'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' lastmodifier, '.
TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter, '.
Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- pgsql.php 18 Jul 2002 13:02:15 -0000 1.17
+++ pgsql.php 3 Sep 2002 19:45:01 -0000 1.18
@@ -127,7 +127,7 @@
'query-list-bugs-count' => 'select count(*) '.
'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.' reporter on b.created_by = reporter.user_id where ',
'query-list-bugs' => 'select %s '.
'from '.TBL_BUG.' b '.
'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '.
|
