|
From: Benjamin C. <bc...@us...> - 2004-02-25 12:49:21
|
Update of /cvsroot/phpbt/phpbt/inc/db In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv10363/inc/db Modified Files: Tag: htmltemplates oci8.php Log Message: Fixed a query Index: oci8.php =================================================================== RCS file: /cvsroot/phpbt/phpbt/inc/db/oci8.php,v retrieving revision 1.15 retrieving revision 1.15.4.1 diff -u -r1.15 -r1.15.4.1 --- oci8.php 21 Jun 2003 13:36:30 -0000 1.15 +++ oci8.php 25 Feb 2004 12:42:11 -0000 1.15.4.1 @@ -39,7 +39,7 @@ 'group by d.database_id, database_name, sort_order '. 'order by %s %s', 'admin-list-sites' => 'select s.site_id, site_name, sort_order, '. - 'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG. + 'count(bug_id) as bug_count from '.TBL_SITE. ' s, '.TBL_BUG.' b '. 'where s.site_id = b.site_id(+) group by s.site_id, site_name, '. 'sort_order order by %s %s', 'admin-list-statuses' => 'select s.status_id, status_name, status_desc, '. |