cvs: phpweb / lstats.php
| From: | Jani Taskinen | Date: | Tue, 08 May 2001 12:13:13 +0000 |
| Subject: | cvs: phpweb / lstats.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-4940@lists.php.net to get a copy of this message | ||
sniper Tue May 8 05:13:13 2001 EDT
Added files:
/phpweb lstats.php
Log:
Lite bug stats page.
Index: phpweb/lstats.php
+++ phpweb/lstats.php
<?php
if(!strstr($MYSITE,"www.php.net")) {
Header("Location: http://www.php.net/lstats.php");
exit;
}
function status_print ($status, $num)
{
$str = ucfirst($status).":";
$str.= str_repeat(" ", 14-strlen($str));
$str.= "<!-- NUM -->$num<!-- /NUM -->\n<br>";
echo $str;
}
$statuses = array (
"open",
"critical",
"closed",
"analyzed",
"suspended",
"duplicate",
"assigned",
"feedback",
"bogus"
);
mysql_connect("localhost","nobody","");
mysql_select_db("php3");
/* REMOVE THIS!!! */
if(isset($create_index_for_status) && $create_index_for_status == "please") {
mysql_query("CREATE INDEX idx_status on bugdb(status)");
}
echo "<h3>Bug stats:</h3><pre>\n";
foreach($statuses as $status) {
$query = "SELECT count(id) from bugdb WHERE";
if ($phpver > 0) {
$query .= " php_version LIKE '" . $phpver . "%' AND";
}
$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]);
}
echo "</pre>\n";
?>