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

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

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

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.63
retrieving revision 1.64
diff -u -r1.63 -r1.64
--- include.php	2001/10/13 23:15:52	1.63
+++ include.php	2001/10/29 22:41:59	1.64
@@ -223,7 +223,7 @@
         $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 assigned_to = $u where status_name in ");
       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))"