|
From: Jirka P. <fi...@us...> - 2002-09-06 13:46:35
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory usw-pr-cvs1:/tmp/cvs-serv24899/phpbt/inc/db Modified Files: oci8.php Log Message: small fix. Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.9 retrieving revision 1.10 diff -u -r1.9 -r1.10 --- oci8.php 3 Sep 2002 19:44:57 -0000 1.9 +++ oci8.php 6 Sep 2002 13:46:31 -0000 1.10 @@ -114,7 +114,7 @@ "sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 0, ".BUG_PROMOTED.", 0, ".BUG_ASSIGNED.", 0, ".BUG_REOPENED.", 0, 1 )), ". 'from '.TBL_BUG.' b, '.TBL_STATUS.' s '. 'where b.status_id = s.status_id (+) and b.assigned_to = %s', - 'include-template-reporter' => "SELECT sum(decode( s.status_name, ".BUG_UNCONFIRMED.", 1, ".BUG_PROMOTED.", 1, ".BUG_ASSIGNED.", 1, ".BUG_REOPENED.", 1, 0 )), ". + 'include-template-reporter' => "SELECT sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 1, ".BUG_PROMOTED.", 1, ".BUG_ASSIGNED.", 1, ".BUG_REOPENED.", 1, 0 )), ". "sum(decode( s.status_id, ".BUG_UNCONFIRMED.", 0, ".BUG_PROMOTED.", 0, ".BUG_ASSIGNED.", 0, ".BUG_REOPENED.", 0, 1 )), ". 'from '.TBL_BUG.' b, ' . TBL_STATUS.' s '. 'where b.status_id = s.status_id (+) and b.created_by = %s', |