[phpBT-dev] CVS: phpbt/inc/db mysql.php,1.13,1.14 oci8.php,1.11,1.12 pgsql.php,1.18,1.19

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

Update of /cvsroot/phpbt/phpbt/inc/db
In directory usw-pr-cvs1:/tmp/cvs-serv9701/inc/db

Modified Files:
	mysql.php oci8.php pgsql.php 
Log Message:
Trying to fix the latest oracle problem with the bug query.

Index: mysql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/mysql.php,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- mysql.php	3 Sep 2002 19:44:56 -0000	1.13
+++ mysql.php	13 Sep 2002 19:33:17 -0000	1.14
@@ -129,7 +129,8 @@
 	'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 where ',
+		'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id ',
+	'query-list-bugs-count-join' => '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.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- oci8.php	6 Sep 2002 17:42:04 -0000	1.11
+++ oci8.php	13 Sep 2002 19:33:17 -0000	1.12
@@ -132,7 +132,8 @@
 	'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 ',
+		'and b.created_by = reporter.user_id(+) ',
+	'query-list-bugs-count-join' => 'and ',
 	'query-list-bugs' => 'select %s '.
 		'from '.TBL_BUG.' b, '.TBL_AUTH_USER.' lastmodifier, '.
 		TBL_AUTH_USER.' owner, '.TBL_AUTH_USER.' reporter, '.
@@ -177,5 +178,5 @@
 		'where v.project_id = %s and v.version_id = b.version_id(+) '.
 		'group by v.version_id, v.version_name, v.created_date, v.active',
 	);
-	
+
 ?>

Index: pgsql.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/inc/db/pgsql.php,v
retrieving revision 1.18
retrieving revision 1.19
diff -u -r1.18 -r1.19
--- pgsql.php	3 Sep 2002 19:45:01 -0000	1.18
+++ pgsql.php	13 Sep 2002 19:33:17 -0000	1.19
@@ -127,7 +127,8 @@
 	'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 where ',
+		'left join '.TBL_AUTH_USER.' reporter on b.created_by = reporter.user_id ',
+	'query-list-bugs-count-join' => 'where ',
 	'query-list-bugs' => 'select %s '.
 		'from '.TBL_BUG.' b '.
 		'left join '.TBL_AUTH_USER.' owner on b.assigned_to = owner.user_id '.