diff options
author | Yorhel <git@yorhel.nl> | 2009-10-10 12:46:43 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-10-10 12:46:43 +0200 |
commit | 1e125f67ab50a5de477c538b3f7dd27a9ec3c62f (patch) | |
tree | 785cd10412c9b990e7e1c96d07d839743064ff1f /lib/VNDB/DB/Producers.pm | |
parent | 4c4546ca2410844effb2edc72b80a3e1f8465f71 (diff) |
Updated Producer and VN pages with developer/publisher information
Diffstat (limited to 'lib/VNDB/DB/Producers.pm')
-rw-r--r-- | lib/VNDB/DB/Producers.pm | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/lib/VNDB/DB/Producers.pm b/lib/VNDB/DB/Producers.pm index 65d1fbca..18f372f9 100644 --- a/lib/VNDB/DB/Producers.pm +++ b/lib/VNDB/DB/Producers.pm @@ -61,7 +61,8 @@ sub dbProducerGet { } 0..$#$r; push @{$r->[$r{$_->{pid}}]{vn}}, $_ for (@{$self->dbAll(q| - SELECT MAX(vp.pid) AS pid, v.id, MAX(vr.title) AS title, MAX(vr.original) AS original, MIN(rr.released) AS date + SELECT MAX(vp.pid) AS pid, v.id, MAX(vr.title) AS title, MAX(vr.original) AS original, MIN(rr.released) AS date, + MAX(CASE WHEN vp.developer = true THEN 1 ELSE 0 END) AS developer, MAX(CASE WHEN vp.publisher = true THEN 1 ELSE 0 END) AS publisher FROM releases_producers vp JOIN releases_rev rr ON rr.id = vp.rid JOIN releases r ON r.latest = rr.id |