diff options
| -rw-r--r-- | ChangeLog | 1 | ||||
| -rw-r--r-- | lib/VNDB/DB/Chars.pm | 4 |
2 files changed, 4 insertions, 1 deletions
@@ -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) : () } )}); } } |