|
From: Javier S. <ja...@us...> - 2001-10-29 22:42:02
|
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))"
|