diff options
author | Yorhel <git@yorhel.nl> | 2009-01-16 15:16:39 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-01-16 15:16:39 +0100 |
commit | 9ee7694a4b6f7dce174ec785cf5a71a5a38774bb (patch) | |
tree | 38e6dbb83d21dffec285f731fc1ae421e55801f5 /lib/VNDB/DB/Releases.pm | |
parent | 6dc9a434619d28f87eaf768b00d3696bb7c24c61 (diff) | |
parent | 910bb9f397cec1a49526e09e7d2c9b856bd5bdae (diff) |
Merge branch 'beta'2.2
Diffstat (limited to 'lib/VNDB/DB/Releases.pm')
-rw-r--r-- | lib/VNDB/DB/Releases.pm | 9 |
1 files changed, 5 insertions, 4 deletions
diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm index 6af2f736..52fea2b0 100644 --- a/lib/VNDB/DB/Releases.pm +++ b/lib/VNDB/DB/Releases.pm @@ -41,7 +41,7 @@ sub dbReleaseGet { ); my @select = ( - qw|r.id r.locked r.hidden rr.title rr.original rr.gtin rr.language rr.website rr.released rr.notes rr.minage rr.type|, 'rr.id AS cid', + qw|r.id r.locked r.hidden rr.title rr.original rr.gtin rr.language rr.website rr.released rr.notes rr.minage rr.type rr.patch|, 'rr.id AS cid', $o{what} =~ /changes/ ? qw|c.added c.requester c.comments r.latest u.username c.rev| : (), ); @@ -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 ] )}); } @@ -135,9 +136,9 @@ sub insert_rev { my($self, $cid, $rid, $o) = @_; $self->dbExec(q| - INSERT INTO releases_rev (id, rid, title, original, gtin, language, website, released, notes, minage, type) + INSERT INTO releases_rev (id, rid, title, original, gtin, language, website, released, notes, minage, type, patch) VALUES (!l)|, - [ $cid, $rid, @$o{qw| title original gtin language website released notes minage type|} ]); + [ $cid, $rid, @$o{qw| title original gtin language website released notes minage type patch|} ]); $self->dbExec(q| INSERT INTO releases_producers (rid, pid) |