diff options
| author | Yorhel <git@yorhel.nl> | 2009-01-10 17:07:00 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2009-01-10 17:10:25 +0100 |
| commit | 33e3b6dc9f4c2e44cdeb0128d8c924668fa76801 (patch) | |
| tree | 65e16bf5d7d00a2b3ed53284e77b4f44ee3b4590 /lib | |
| parent | 5d89294fdbbe7c4c030439171b9c24d52bf462fc (diff) | |
Don't show hidden release relations on producer pages
17:00:20 <ImmLff> Can someone explain why p440 have relation to v198 without having a release?
17:00:20 <Multi> [p440] Team Free @ http://vndb.org/p440
17:00:20 <Multi> [v198] Princess Holiday @ http://vndb.org/v198
17:01:07 <applehq> it's deleted...
17:01:14 <Yorhel> oh my, a bug
Diffstat (limited to 'lib')
| -rw-r--r-- | lib/ChangeLog | 1 | ||||
| -rw-r--r-- | lib/VNDB/DB/Producers.pm | 1 |
2 files changed, 2 insertions, 0 deletions
diff --git a/lib/ChangeLog b/lib/ChangeLog index 3deb59c4..56af1996 100644 --- a/lib/ChangeLog +++ b/lib/ChangeLog @@ -7,6 +7,7 @@ - Limit account creation to one account in 24 hours per IP address - Fixed error message when uploading VN images larger than 500kB - Fixed 3 grammar mistakes related to singular/plural + - Don't show hidden release relations on producer pages 2.1 - 2008-12-29 - Skin support diff --git a/lib/VNDB/DB/Producers.pm b/lib/VNDB/DB/Producers.pm index edee4a8a..c7abd765 100644 --- a/lib/VNDB/DB/Producers.pm +++ b/lib/VNDB/DB/Producers.pm @@ -69,6 +69,7 @@ sub dbProducerGet { JOIN vn_rev vr ON vr.id = v.latest WHERE vp.pid IN(!l) AND v.hidden = FALSE + AND r.hidden = FALSE GROUP BY v.id ORDER BY date|, [ keys %r ] |