diff options
| author | Yorhel <git@yorhel.nl> | 2009-01-15 13:20:54 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-01-15 13:20:54 +0100 |
| commit | ef276eff8d84a6e3076b75ca6830a87a6b62909a (patch) | |
| tree | 18089a099923ca9f00ff6c6a3ce674035c4e2c1e | |
| parent | 7fa831a278c6e0f8d42d44969b562c82ae717400 (diff) | |
Keep VN relations on r+ pages ordered by title
| -rw-r--r-- | lib/ChangeLog | 1 | ||||
| -rw-r--r-- | lib/VNDB/DB/Releases.pm | 3 | ||||
| -rw-r--r-- | lib/VNDB/Handler/Releases.pm | 2 |
3 files changed, 4 insertions, 2 deletions
diff --git a/lib/ChangeLog b/lib/ChangeLog index 4f530d10..3feea7d9 100644 --- a/lib/ChangeLog +++ b/lib/ChangeLog @@ -10,6 +10,7 @@ - Don't show hidden release relations on producer pages - Hide the vote dropdown on v+ pages when the VN is already on the wishlist - Don't search for the ADV category when searching for the Game Boy Advance + - Keep VN relations on r+ pages ordered by title 2.1 - 2008-12-29 - Skin support diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm index cf077d0e..52fea2b0 100644 --- a/lib/VNDB/DB/Releases.pm +++ b/lib/VNDB/DB/Releases.pm @@ -69,7 +69,8 @@ sub dbReleaseGet { FROM releases_vn rv JOIN vn v ON v.id = rv.vid JOIN vn_rev vr ON vr.id = v.latest - WHERE rv.rid IN(!l)|, + WHERE rv.rid IN(!l) + ORDER BY vr.title|, [ keys %r ] )}); } diff --git a/lib/VNDB/Handler/Releases.pm b/lib/VNDB/Handler/Releases.pm index c3fe98dc..aed1b291 100644 --- a/lib/VNDB/Handler/Releases.pm +++ b/lib/VNDB/Handler/Releases.pm @@ -244,7 +244,7 @@ sub edit { media => join(',', sort map "$_->{medium} $_->{qty}", @{$r->{media}}), producers => join('|||', map "$_->{id},$_->{name}", sort { $a->{id} <=> $b->{id} } @{$r->{producers}}), ); - $b4{vn} = join('|||', map "$_->{vid},$_->{title}", sort { $a->{vid} <=> $b->{vid} } @$vn); + $b4{vn} = join('|||', map "$_->{vid},$_->{title}", @$vn); my $frm; if($self->reqMethod eq 'POST') { |