diff options
author | Yorhel <git@yorhel.nl> | 2009-05-23 11:03:02 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-05-23 11:04:02 +0200 |
commit | fbd24e0c11ccd0fae499a38b4c1ab7b971a42094 (patch) | |
tree | 9503820417275bc6799b1c8546a3b2952fedf4bc /lib/VNDB/DB/Releases.pm | |
parent | dbe40977ddbc77863f68e0ae61eca6b3e3e1335f (diff) |
Added freeware and doujin information to releases
TODO:
- update d3
- filters on /r
Diffstat (limited to 'lib/VNDB/DB/Releases.pm')
-rw-r--r-- | lib/VNDB/DB/Releases.pm | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm index 89b3d671..63c99019 100644 --- a/lib/VNDB/DB/Releases.pm +++ b/lib/VNDB/DB/Releases.pm @@ -72,7 +72,7 @@ sub dbReleaseGet { my @select = ( qw|r.id rr.title rr.original rr.language rr.website rr.released rr.minage rr.type rr.patch|, 'rr.id AS cid', - $o{what} =~ /extended/ ? qw|rr.notes rr.catalog rr.gtin rr.resolution rr.voiced r.hidden r.locked| : (), + $o{what} =~ /extended/ ? qw|rr.notes rr.catalog rr.gtin rr.resolution rr.voiced rr.freeware rr.doujin r.hidden r.locked| : (), $o{what} =~ /changes/ ? qw|c.added c.requester c.comments r.latest u.username c.rev| : (), ); @@ -167,9 +167,11 @@ sub insert_rev { my($self, $cid, $rid, $o) = @_; $self->dbExec(q| - INSERT INTO releases_rev (id, rid, title, original, gtin, catalog, language, website, released, notes, minage, type, patch, resolution, voiced) + INSERT INTO releases_rev (id, rid, title, original, gtin, catalog, language, website, released, + notes, minage, type, patch, resolution, voiced, freeware, doujin) VALUES (!l)|, - [ $cid, $rid, @$o{qw| title original gtin catalog language website released notes minage type patch resolution voiced|} ]); + [ $cid, $rid, @$o{qw| title original gtin catalog language website released + notes minage type patch resolution voiced freeware doujin|} ]); $self->dbExec(q| INSERT INTO releases_producers (rid, pid) |