From d9a2a5ea9978911f5a9ad051c19b3844ad2621b0 Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Tue, 2 Aug 2005 03:28:16 +0000
Subject: fixed bug in the new update list where it doesn't list most of the
 updated packages, listing instead mostly new ones

---
 web/html/index.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/web/html/index.php b/web/html/index.php
index cf365fc..d23ee35 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -132,7 +132,7 @@ print "<td class='boxSoft' valign='top'>";
 #Hey, how about listing the newest pacakges? :D
 $q = "SELECT * FROM Packages ";
 $q.= "WHERE DummyPkg != 1 ";
-$q.= "ORDER BY SubmittedTS DESC ";
+$q.= "ORDER BY GREATEST(SubmittedTS,ModifiedTS) DESC ";
 $q.= "LIMIT 0 , 10";
 $result = db_query($q,$dbh);
 # Table 2
-- 
cgit v1.2.3-54-g00ecf