cvs: pearweb /public_html/qa packages_status.php
| From: | Tobias Schlitt | Date: | Sat, 13 Aug 2005 21:45:06 +0000 |
| Subject: | cvs: pearweb /public_html/qa packages_status.php | ||
| Groups: | php.pear.cvs php.pear.core | ||
| Request: | Send a blank email to pear-core+get-3512@lists.php.net to get a copy of this message | ||
toby Sat Aug 13 17:45:06 2005 EDT
Modified files:
/pearweb/public_html/qa packages_status.php
Log:
* Fix SQL for bugs.
* Some layout stuff.
http://cvs.php.net/diff.php/pearweb/public_html/qa/packages_status.php?r1=1.1&r2=1.2&ty=u
Index: pearweb/public_html/qa/packages_status.php
diff -u pearweb/public_html/qa/packages_status.php:1.1
pearweb/public_html/qa/packages_status.php:1.2
--- pearweb/public_html/qa/packages_status.php:1.1 Sat Aug 13 07:14:37 2005
+++ pearweb/public_html/qa/packages_status.php Sat Aug 13 17:45:05 2005
@@ -15,7 +15,7 @@
+----------------------------------------------------------------------+
| Authors: Arnaud Limbourg <arnaud@limbourg.com> |
+----------------------------------------------------------------------+
- $Id: packages_status.php,v 1.1 2005/08/13 11:14:37 toby Exp $
+ $Id: packages_status.php,v 1.2 2005/08/13 21:45:05 toby Exp $
*/
/**
@@ -132,21 +132,21 @@
$out = '
<div id="container">
- <div id="pageHeader">
+ <p id="pageHeader">
<h1>Summary</h1>
<div id="subtitle">
<h2>Number of packages in PEAR: {{TOTAL_PACKAGES_NUMBER}}</h2>
<h2>Number of packages studied here : {{STUDIED_PACKAGES_NUMBER}}</h2>
</div>
- </div>
+ </p>
- <div id="details">
+ <p id="details">
{{TABLES}}
- </div>
+ </p>
- <div id="footer">
+ <p id="footer">
Page last updated on: {{UPDATE_DATE}}
- </div>
+ </p>
</div>
';
@@ -180,13 +180,16 @@
{
global $dbh;
- $query = "
+ $query = '
SELECT
COUNT(*)
FROM
bugdb
WHERE
- package_name=" . $dbh->quoteSmart($package);
+ package_name=' . $dbh->quoteSmart($package) . '
+ AND bug_type = "Bug"
+ AND status IN ("Open", "Critical", "Assigned",
"Analyzed")
+ ';
$count = $dbh->getOne($query);