cvs: pearweb /include/bugs pear-bugs.php
| From: | Greg Beaver | Date: | Sun, 17 Dec 2006 21:51:31 +0000 |
| Subject: | cvs: pearweb /include/bugs pear-bugs.php | ||
| Groups: | php.pear.cvs php.pear.core | ||
| Request: | Send a blank email to pear-core+get-5279@lists.php.net to get a copy of this message | ||
cellog Sun Dec 17 21:51:31 2006 UTC
Modified files:
/pearweb/include/bugs pear-bugs.php
Log:
fix developer bug stats - they were *WAY* off, this is an
accurate tally of what people have done
http://cvs.php.net/viewvc.cgi/pearweb/include/bugs/pear-bugs.php?r1=1.3&r2=1.4&diff_format=u
Index: pearweb/include/bugs/pear-bugs.php
diff -u pearweb/include/bugs/pear-bugs.php:1.3 pearweb/include/bugs/pear-bugs.php:1.4
--- pearweb/include/bugs/pear-bugs.php:1.3 Sat Dec 16 23:07:42 2006
+++ pearweb/include/bugs/pear-bugs.php Sun Dec 17 21:51:31 2006
@@ -87,16 +87,15 @@
b.bug_type \!= "Feature/Change Request" AND
b.status IN ("Assigned", "Analyzed", "Feedback",
"Open", "Critical", "Verified") AND
(b.assign = ? OR b.assign IS NULL OR b.assign="")', array($handle,
$handle));
- $bugrank = $this->_dbh->getAll('SELECT COUNT(*) as c, m.handle
- FROM bugdb b, maintains m, packages p
- WHERE
- p.id = m.package AND
- b.package_name = p.name AND
- b.bug_type != "Feature/Change Request" AND
- b.assign = m.handle AND
- b.status = "Closed"
- GROUP BY m.handle
- ORDER BY c DESC, b.ts1 DESC', array(), DB_FETCHMODE_ASSOC);
+ $bugrank = $this->_dbh->getAll('SELECT COUNT(*) as c, u.handle
+ FROM bugdb b, users u, packages p
+ WHERE
+ b.package_name = p.name AND
+ b.bug_type != "Feature/Change Request" AND
+ b.assign = u.handle AND
+ b.status = "Closed"
+ GROUP BY u.handle
+ ORDER BY c DESC, b.ts2 DESC', array(), DB_FETCHMODE_ASSOC);
$rank = count($bugrank);
$alltimecount = 0;
foreach ($bugrank as $i => $inf) {
@@ -122,16 +121,15 @@
{
static $bugrank = false;
if (!$bugrank) {
- $bugrank = $this->_dbh->getAll('SELECT COUNT(*) as c, m.handle
- FROM bugdb b, maintains m, packages p
+ $bugrank = $this->_dbh->getAll('SELECT COUNT(*) as c, u.handle
+ FROM bugdb b, users u, packages p
WHERE
- p.id = m.package AND
b.package_name = p.name AND
b.bug_type != "Feature/Change Request" AND
- b.assign = m.handle AND
+ b.assign = u.handle AND
b.status = "Closed"
- GROUP BY m.handle
- ORDER BY c DESC, b.ts1 DESC', array(), DB_FETCHMODE_ASSOC);
+ GROUP BY u.handle
+ ORDER BY c DESC, b.ts2 DESC', array(), DB_FETCHMODE_ASSOC);
}
$rank = count($bugrank) + 1;
$alltimecount = 0;
@@ -147,16 +145,15 @@
function allDevelStats()
{
- return $this->_dbh->getAll('SELECT COUNT(*) as c, m.handle
- FROM bugdb b, maintains m, packages p
- WHERE
- p.id = m.package AND
- b.package_name = p.name AND
- b.bug_type != "Feature/Change Request" AND
- b.assign = m.handle AND
- b.status = "Closed"
- GROUP BY m.handle
- ORDER BY c DESC', array(), DB_FETCHMODE_ASSOC);
+ return $this->_dbh->getAll('SELECT COUNT(*) as c, u.handle
+ FROM bugdb b, users u, packages p
+ WHERE
+ b.package_name = p.name AND
+ b.bug_type != "Feature/Change Request" AND
+ b.assign = u.handle AND
+ b.status = "Closed"
+ GROUP BY u.handle
+ ORDER BY c DESC, b.ts2 DESC', array(), DB_FETCHMODE_ASSOC);
}
}
?>
\ No newline at end of file