[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.12,1.13 oci8.php,1.8,1.9 pgsql.php,1.17,1.18

[Benjamin C. <bc...@us...>]

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 '.