cvs: php-bugs-web / search.php
| From: | Philip Olson | Date: | Mon, 30 Jun 2003 21:39:37 +0000 |
| Subject: | cvs: php-bugs-web / search.php | ||
| Groups: | php.mirrors | ||
| Request: | Send a blank email to php-mirrors+get-19063@lists.php.net to get a copy of this message | ||
philip Mon Jun 30 17:39:37 2003 EDT
Modified files:
/php-bugs-web search.php
Log:
Remove developer/comment emails from email search, it's too slow of a query.
Index: php-bugs-web/search.php
diff -u php-bugs-web/search.php:1.43 php-bugs-web/search.php:1.44
--- php-bugs-web/search.php:1.43 Sat Jun 28 05:51:59 2003
+++ php-bugs-web/search.php Mon Jun 30 17:39:37 2003
@@ -33,11 +33,7 @@
else
$query = "SELECT ";
- if (empty($author_email)) {
- $query .= "*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb ";
- } else {
- $query .= "DISTINCT bugdb.*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb,
bugdb_comments ";
- }
+ $query .= "*, TO_DAYS(NOW())-TO_DAYS(ts2) AS unchanged FROM bugdb ";
if ($bug_type == "Any") {
$where_clause = "WHERE bug_type != 'Feature/Change Request'";
@@ -96,7 +92,7 @@
}
if (!empty($author_email)) {
- $where_clause .= " AND (bugdb.email = '$author_email' OR (bugdb_comments.email
= '$author_email' AND bugdb.id = bugdb_comments.bug))";
+ $where_clause .= " AND bugdb.email = '$author_email' ";
}
$query .= "$where_clause ";
@@ -276,8 +272,8 @@
</td>
</tr>
<tr>
- <th>Developer email</th>
- <td nowrap="nowrap">Return only bugs with an email from</td>
+ <th>Author email</th>
+ <td nowrap="nowrap">Return only bugs with author email</td>
<td><input type="text" name="author_email" value="<?php echo
htmlspecialchars(stripslashes($author_email)); ?>" /></td>
</tr>
<tr>