[PHP-WEBMASTER] com web/bugs: Fix bug search: include/query.php

[Johannes Schlüter]

Commit:    5719e9e81504c226d10e924f8e4a5e555b01b305
Author:    Johannes Schlüter <johan...@schlueters.de>         Wed, 13 Feb 2013 
21:40:25 +0100
Parents:   e67097c14b4b9938db21aac13d42c40b544e7cbd
Branches:  master

Link:       
http://git.php.net/?p=web/bugs.git;a=commitdiff;h=5719e9e81504c226d10e924f8e4a5e555b01b305

Log:
Fix bug search

Changed paths:
  M  include/query.php


Diff:
diff --git a/include/query.php b/include/query.php
index ec3c369..5f8d435 100644
--- a/include/query.php
+++ b/include/query.php
@@ -177,15 +177,18 @@ if (isset($_GET['cmd']) && $_GET['cmd'] == 'display')
        }
 
        /* A search for patch&pull should be (patch or pull) */
-       $where_clause .= " AND (1=2";
+       if ($patch != '' || $pull != '') {
+               $where_clause .= " AND (1=2";
+       }
        if ($patch != '') {
                $where_clause .= " OR EXISTS (SELECT 1 FROM bugdb_patchtracker 
WHERE bugdb_id = bugdb.id LIMIT 1)";
        }
        if ($pull != '') {
                $where_clause .= " OR EXISTS (SELECT 1 FROM bugdb_pulls WHERE 
bugdb_id = bugdb.id LIMIT 1)";
        }
-       $where_clause .= ")";
-
+       if ($patch != '' || $pull != '') {
+               $where_clause .= ")";
+       }
        if ($assign != '') {
                $where_clause .= ' AND bugdb.assign = ' . $dbh->quote($assign);
        }


--
PHP Webmaster List Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php