Order the VNs listed on char browser by release date

2 files changed, 4 insertions, 1 deletions

diff --git a/ChangeLog b/ChangeLog
index cb973773..1f8da59a 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,4 +1,5 @@
 2.20 - ?
+	- Order the VNs listed on char browser by release date
 	- Bugfix: don't accidentally remove char traits when editing
 	- Bugfix: fixed possible SQL table name clash on history browser
 	- Bugfix: properly announce chars and traits in Multi::IRC
diff --git a/lib/VNDB/DB/Chars.pm b/lib/VNDB/DB/Chars.pm
index 8fb01ebf..be620378 100644
--- a/lib/VNDB/DB/Chars.pm
+++ b/lib/VNDB/DB/Chars.pm
@@ -86,7 +86,9 @@ sub dbCharGet {
           JOIN vn_rev vr ON vr.id = v.latest
           LEFT JOIN releases r ON cv.rid = r.id
           LEFT JOIN releases_rev rr ON rr.id = r.latest
-          !W|, { 'cv.cid IN(!l)' => [[keys %r]], $1 ? ('cv.vid = ?', $1) : () }
+          !W
+          ORDER BY v.c_released|,
+        { 'cv.cid IN(!l)' => [[keys %r]], $1 ? ('cv.vid = ?', $1) : () }
       )});
     }
   }