svn: /pear/pearweb/trunk/scripts/ findOldPackageXml.php

dufuz                                    Wed, 09 Mar 2011 23:15:06 +0000

Revision: http://svn.php.net/viewvc?view=revision&revision=309056

Log:
Make sure we show the latest version as when outputting.

Changed paths:
    U   pear/pearweb/trunk/scripts/findOldPackageXml.php

Modified: pear/pearweb/trunk/scripts/findOldPackageXml.php
===================================================================
--- pear/pearweb/trunk/scripts/findOldPackageXml.php	2011-03-09 20:06:52 UTC (rev 309055)
+++ pear/pearweb/trunk/scripts/findOldPackageXml.php	2011-03-09 23:15:06 UTC (rev 309056)
@@ -6,10 +6,10 @@
 }

 $sql  = '
-    SELECT r.id, p.name, files.packagexml
+    SELECT r.id, r.version, p.name, files.packagexml
     FROM packages p
     LEFT JOIN (
-        SELECT MAX(id) as id, version, package FROM releases GROUP BY package
+        SELECT MAX(id) as id, MAX(version) as version, package FROM releases GROUP BY package
     ) AS r ON p.id = r.package
     JOIN files ON r.id = files.release
     WHERE p.package_type = "pear"
@@ -19,7 +19,7 @@
 $i = 0;
 foreach ($data as $d) {
     if (!preg_match('/<package[^>]+version\s*=\s*"2.0"/', $d['packagexml'])) {
-        echo $d['name'] . "\n";
+        echo $d['name'] . ' (' . $d['version'] . ")\n";
         $i++;
     }
 }