cvs: php-bugs-web / search.php

From: 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>

« previous php.mirrors (#19063) next »