[phpBT-dev] CVS: phpbt include.php,1.64,1.65

[Javier S. <ja...@us...>]

Update of /cvsroot/phpbt/phpbt
In directory usw-pr-cvs1:/tmp/cvs-serv5652

Modified Files:
	include.php 
Log Message:
Changing SQL syntax for postgres compatibilty on template extends 

Index: include.php
===================================================================
RCS file: /cvsroot/phpbt/phpbt/include.php,v
retrieving revision 1.64
retrieving revision 1.65
diff -u -r1.64 -r1.65
--- include.php	2001/10/29 22:41:59	1.64
+++ include.php	2001/10/29 22:56:54	1.65
@@ -213,6 +213,7 @@
 class templateclass extends Template {
   function pparse($target, $handle, $append = false) {
     global $auth, $perm, $q;
+$q->Debug=true;
 
     $u = $auth->auth['uid'];
     $this->set_block('wrap', 'logoutblock', 'loblock');
@@ -220,14 +221,14 @@
     $this->set_block('wrap', 'adminnavblock', 'anblock');
     if ($u && $u != 'nobody') {
       list($owner_open, $owner_closed) =
-        $q->grab("select sum(if(status_name in ('Unconfirmed','New','Assigned','Reopened'),1,0)),"
-        	."  sum(if(status_name not in ('Unconfirmed','New','Assigned','Reopened'),1,0))"
-    			." from ".TBL_BUG." b left join ".TBL_STATUS." s using(status_id)"
-    			." where assigned_to = $u where status_name in ");
+		$q->grab("SELECT sum(CASE WHEN status_name in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END ) ,"
+				."sum(CASE WHEN status_name not in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END )"
+				."from ".TBL_BUG." b left join ".TBL_STATUS." s using(status_id) where assigned_to = $u");
+				
       list($reporter_open, $reporter_closed) =
- 				$q->grab("select sum(if(status_name in ('Unconfirmed','New','Assigned','Reopened'),1,0)),"
-    			."  sum(if(status_name not in ('Unconfirmed','New','Assigned','Reopened'),1,0))"
-    			." from ".TBL_BUG." b left join ".TBL_STATUS." s using(status_id) where created_by = $u");
+		$q->grab("SELECT sum(CASE WHEN status_name in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END ) ,"
+				."sum(CASE WHEN status_name not in ('Unconfirmed','New','Assigned','Reopened') THEN 1 ELSE 0 END )"
+				."from ".TBL_BUG." b left join ".TBL_STATUS." s using(status_id) where created_by = $u");
       $this->set_var(array(
         'loggedinas' => $auth->auth['uname'],
         'liblock' => '',