cvs: php-bugs-web / search.php
| From: | Philip Olson | Date: | Sat, 28 Jun 2003 07:35:32 +0000 |
| Subject: | cvs: php-bugs-web / search.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-18998@lists.php.net to get a copy of this message | ||
philip Sat Jun 28 03:35:32 2003 EDT
Modified files:
/php-bugs-web search.php
Log:
Have the email search option also search developer and comment email addresses.
Index: php-bugs-web/search.php
diff -u php-bugs-web/search.php:1.41 php-bugs-web/search.php:1.42
--- php-bugs-web/search.php:1.41 Fri Jun 27 02:32:17 2003
+++ php-bugs-web/search.php Sat Jun 28 03:35:31 2003
@@ -33,7 +33,7 @@
else
$query = "SELECT ";
- $query .= "*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb ";
+ $query .= "DISTINCT bugdb.*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb,
bugdb_comments ";
if ($bug_type == "Any") {
$where_clause = "WHERE bug_type != 'Feature/Change Request'";
@@ -92,7 +92,7 @@
}
if (!empty($author_email)) {
- $where_clause .= " AND email = '$author_email'";
+ $where_clause .= " AND (bugdb.email = '$author_email' OR (bugdb_comments.email
= '$author_email' AND bugdb.id = bugdb_comments.bug))";
}
$query .= "$where_clause ";