cvs: php-bugs-web / lstats.php

sniper Sun Nov 10 20:34:30 2002 EDT Modified files: /php-bugs-web lstats.php Log: Make possible to create per-category-bugs graphs with this. Index: php-bugs-web/lstats.php diff -u php-bugs-web/lstats.php:1.3 php-bugs-web/lstats.php:1.4 --- php-bugs-web/lstats.php:1.3 Tue Jul 2 11:49:54 2002 +++ php-bugs-web/lstats.php Sun Nov 10 20:34:30 2002 @@ -7,6 +7,23 @@ echo $str; } +function get_status_count ($status, $category='') +{ + global $phpver; + + $query = "SELECT count(id) from bugdb WHERE"; + if ($phpver > 0) { + $query .= " php_version LIKE '" . $phpver . "%' AND"; + } + $query.= " status='$status' "; + $query.= (empty($category)) ? "AND bug_type NOT LIKE '%Change Request%'" : "AND bug_type='$category'"; + + $result=mysql_unbuffered_query($query); + $row=mysql_fetch_row($result); + mysql_freeresult($result); + return $row[0]; +} + $statuses = array ( "open", "critical", @@ -29,18 +46,25 @@ mysql_pconnect("localhost","nobody",""); mysql_select_db("php3"); -foreach($statuses as $status) { - $query = "SELECT count(id) from bugdb WHERE"; - if ($phpver > 0) { - $query .= " php_version LIKE '" . $phpver . "%' AND"; +if (isset($per_category)) { + include ('bugtypes.inc'); + + foreach ($items as $category => $name) { + $out = "$category"; + foreach($statuses as $status) { + $count = get_status_count ($status, $category); + $out.="|$status=$count"; + } + echo "$out\n<br>"; } - $query.= " status='$status' AND bug_type NOT LIKE '%Change Request%'"; - $result=mysql_unbuffered_query($query); - $row=mysql_fetch_row($result); - mysql_freeresult($result); - - status_print($status, $row[0]); +} else { + + foreach($statuses as $status) { + $count = get_status_count ($status); + status_print($status, $count); + } } + echo "</pre>\n"; ?>