cvs: pearweb /public_html package-search.php
| From: | Martin Jansen | Date: | Mon, 27 May 2002 06:19:10 +0000 |
| Subject: | cvs: pearweb /public_html package-search.php | ||
| Groups: | php.pear.cvs | ||
| Request: | Send a blank email to pear-cvs+get-4129@lists.php.net to get a copy of this message | ||
mj Mon May 27 02:19:10 2002 EDT
Modified files:
/pearweb/public_html package-search.php
Log:
* Only show people from user table that actually maintain a package.
Index: pearweb/public_html/package-search.php
diff -u pearweb/public_html/package-search.php:1.14 pearweb/public_html/package-search.php:1.15
--- pearweb/public_html/package-search.php:1.14 Sun May 26 18:58:11 2002
+++ pearweb/public_html/package-search.php Mon May 27 02:19:08 2002
@@ -2,8 +2,8 @@
/**
* Filename.......: package-search.php
* Project........: PEAR Website
-* Last Modified..: $Date: 2002/05/26 22:58:11 $
-* CVS Revision...: $Revision: 1.14 $
+* Last Modified..: $Date: 2002/05/27 06:19:08 $
+* CVS Revision...: $Revision: 1.15 $
*
* Searches for packages matching various user definable
* criteria including:
@@ -50,7 +50,7 @@
/**
* Fetch list of users/maintainers
*/
- $users = $dbh->getAll('SELECT handle, name FROM users ORDER BY name',
DB_FETCHMODE_ASSOC);
+ $users = $dbh->getAll('SELECT u.handle, u.name FROM users u, maintains m WHERE u.handle =
m.handle GROUP BY handle ORDER BY u.name', DB_FETCHMODE_ASSOC);
for ($i=0; $i<count($users); $i++) {
if (empty($users[$i]['name'])) {
$users[$i]['name'] = $users[$i]['handle'];