[aur-dev] [PATCH] Add Maintainer element in search/info object

djszapi2 at gmail.com djszapi2 at gmail.com
Tue Sep 29 00:04:37 EDT 2009


From: Laszlo Papp <djszapi at archlinux.us>

    Add 'Maintainer' element into search/info type object handling
    too for the unity, it will be handled so not just in msearch
    case separately.

Signed-off-by: Laszlo Papp <djszapi at archlinux.us>
---
 web/lib/aurjson.class.php |    9 ++++-----
 1 files changed, 4 insertions(+), 5 deletions(-)

diff --git a/web/lib/aurjson.class.php b/web/lib/aurjson.class.php
index 5794ebc..f8f011b 100644
--- a/web/lib/aurjson.class.php
+++ b/web/lib/aurjson.class.php
@@ -94,9 +94,8 @@ class AurJSON {
         }

         $keyword_string = mysql_real_escape_string($keyword_string, $this->dbh);
-
-        $query = "SELECT " . implode(',', $this->fields) .
-            " FROM Packages WHERE DummyPkg=0 AND " .
+        $base_query = "SELECT Users.Username as Maintainer, " . implode(',',$this->fields) .
+            " FROM Packages, Users WHERE Users.ID=Packages.MaintainerUID AND DummyPkg=0 AND " .
             "  ( Name LIKE '%{$keyword_string}%' OR " .
             "    Description LIKE '%{$keyword_string}%' )";
         $result = db_query($query, $this->dbh);
@@ -121,8 +120,8 @@ class AurJSON {
      * @return mixed Returns an array of value data containing the package data
      **/
     private function info($pqdata) {
-        $base_query = "SELECT " . implode(',', $this->fields) .
-            " FROM Packages WHERE DummyPkg=0 AND ";
+        $base_query = "SELECT Users.Username as Maintainer, " . implode(',',$this->fields) .
+            " FROM Packages, Users WHERE Users.ID=Packages.MaintainerUID AND DummyPkg=0 AND ";

         if ( is_numeric($pqdata) ) {
             // just using sprintf to coerce the pqd to an int
--
1.6.4.4



More information about the aur-dev mailing list