X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=daklib%2Fdatabase.py;h=a52555682624ca8aac8fa693acac8f805eb797f4;hb=87bf163d12ec8328d87e1b2a2ca2239221a73bd6;hp=b66f3d83dba6560ce3004fcaa57336e77a903d35;hpb=a59ca3145f204083ffcf5edf322d5b6ee2c4e0f8;p=dak.git

diff --git a/daklib/database.py b/daklib/database.py
index b66f3d83..a5255568 100755
--- a/daklib/database.py
+++ b/daklib/database.py
@@ -851,12 +851,14 @@ def get_new_comments(package):
     """
 
     comments = []
-    query = projectB.query(""" SELECT version, comment, author
+    query = projectB.query(""" SELECT version, comment, author, notedate
                                FROM new_comments
-                               WHERE package = '%s' """ % (package))
+                               WHERE package = '%s'
+                               ORDER BY notedate
+                           """ % (package))
 
     for row in query.getresult():
-        comments.append("\nAuthor: %s\nVersion: %s\n\n%s\n" % (row[2], row[0], row[1]))
+        comments.append("\nAuthor: %s\nVersion: %s\nTimestamp: %s\n\n%s\n" % (row[2], row[0], row[3], row[1]))
         comments.append("-"*72)
 
     return comments
@@ -882,9 +884,9 @@ def has_new_comment(package, version):
                             % (package, version) ).getresult()
 
     if not exists:
-        return false
+        return False
     else:
-        return true
+        return True
 
 def add_new_comment(package, version, comment, author):
     """