cvs: pearweb /public_html packages.php

dufuz		Thu May  8 22:41:30 2008 UTC

  Modified files:              
    /pearweb/public_html	packages.php 
  Log:
  use SITE instead of hard coded pear in the package_type sql
  
http://cvs.php.net/viewvc.cgi/pearweb/public_html/packages.php?r1=1.64&r2=1.65&diff_format=u
Index: pearweb/public_html/packages.php
diff -u pearweb/public_html/packages.php:1.64 pearweb/public_html/packages.php:1.65
--- pearweb/public_html/packages.php:1.64	Sun Mar  9 22:42:29 2008
+++ pearweb/public_html/packages.php	Thu May  8 22:41:30 2008
@@ -15,7 +15,7 @@
    +----------------------------------------------------------------------+
    | Authors: Richard Heyes                                               |
    +----------------------------------------------------------------------+
-   $Id: packages.php,v 1.64 2008/03/09 22:42:29 dufuz Exp $
+   $Id: packages.php,v 1.65 2008/05/08 22:41:30 dufuz Exp $
 */
 
 /*
@@ -108,7 +108,7 @@
 $sth = $dbh->query('SELECT c.*, COUNT(p.id) AS npackages' .
                    ' FROM categories c' .
                    ' LEFT JOIN packages p ON p.category = c.id ' .
-                   " WHERE p.package_type = 'pear'" .
+                   " WHERE p.package_type = '" . SITE . "'" .
                    '  AND p.approved = 1' .
                    "  AND c.parent $category_where " .
                    ' GROUP BY c.id ' .
@@ -130,7 +130,7 @@
                           "  FROM packages p, categories c".
                           " WHERE c.parent $category_where ".
                           '   AND p.approved = 1' .
-                          "   AND p.package_type = 'pear' ".
+                          "   AND p.package_type = '" . SITE . "' ".
                           "   AND (p.newpk_id IS NULL OR p.newpk_id = 0)".
                           "   AND p.category = c.id ORDER BY p.name",
                           false, null, DB_FETCHMODE_ASSOC, true);
@@ -235,7 +235,7 @@
         (SELECT state FROM releases WHERE package = p.id ORDER BY id DESC LIMIT 1) as status
         FROM packages p
         WHERE package_type = ? AND approved = 1 AND category = ? ORDER BY name';
-    $packages = $dbh->getAll($sql, array('pear', $catpid));
+    $packages = $dbh->getAll($sql, array(SITE, $catpid));
 
     // Paging
     $total = count($packages);