diff options
| author | Yorhel <git@yorhel.nl> | 2009-02-21 22:35:36 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-02-21 22:35:36 +0100 |
| commit | 4e3b1942275ca2ef07488ac68678adb26338df27 (patch) | |
| tree | 82b1cdc8bc304c855685abf8a459b71bb238ada1 /lib/VNDB/DB/Releases.pm | |
| parent | 203509ffd8fc2fbbd76129d701a6c20110f6050d (diff) | |
Small performance improvements for dbReleaseGet()
Using the same method as 203509ffd8fc2fbbd76129d701a6c20110f6050d
Diffstat (limited to 'lib/VNDB/DB/Releases.pm')
| -rw-r--r-- | lib/VNDB/DB/Releases.pm | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/lib/VNDB/DB/Releases.pm b/lib/VNDB/DB/Releases.pm index e35ef722..1df13894 100644 --- a/lib/VNDB/DB/Releases.pm +++ b/lib/VNDB/DB/Releases.pm @@ -10,7 +10,7 @@ our @EXPORT = qw|dbReleaseGet dbReleaseAdd dbReleaseEdit|; # Options: id vid rev order unreleased page results what -# What: changes vn producers platforms media +# What: extended changes vn producers platforms media sub dbReleaseGet { my($self, %o) = @_; $o{results} ||= 50; @@ -41,8 +41,9 @@ sub dbReleaseGet { ); my @select = ( - qw|r.id r.locked r.hidden rr.title rr.original rr.gtin rr.catalog rr.language|, - qw|rr.website rr.released rr.notes rr.minage rr.type rr.patch|, 'rr.id AS cid', + 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 r.hidden r.locked| : (), $o{what} =~ /changes/ ? qw|c.added c.requester c.comments r.latest u.username c.rev| : (), ); |