summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorpjmattal <pjmattal>2005-08-02 03:28:16 +0000
committerpjmattal <pjmattal>2005-08-02 03:28:16 +0000
commitd9a2a5ea9978911f5a9ad051c19b3844ad2621b0 (patch)
tree2550bfa97454cd64ed86cd92ae7594e35d5fd301
parent65b5c8b0deeb5be780d066949e9f1878b6c80f5d (diff)
downloadaurweb-d9a2a5ea9978911f5a9ad051c19b3844ad2621b0.tar.xz
fixed bug in the new update list where it doesn't list most of the updated packages, listing instead mostly new ones
-rw-r--r--web/html/index.php2
1 files changed, 1 insertions, 1 deletions
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