diff options
| author | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-05-20 17:46:52 +0000 |
|---|---|---|
| committer | yorhel <yorhel@1fe2e327-d9db-4752-bcf7-ef0cb4a1748b> | 2008-05-20 17:46:52 +0000 |
| commit | c2615af845fef85c048d3d1b2e0fd83b701dc4e1 (patch) | |
| tree | ffd38c74eee923eedbb6cec3294165dcd5fa733f /lib/VNDB | |
| parent | 2ce770e7e5817f8838fdaf7bc7eda2a8da972962 (diff) | |
Several bugfixes, xml extention to rss feeds, noindex on user forms, client side filter selection, and how the fuck did the "Finished" status get lost!?
git-svn-id: svn://vndb.org/vndb@14 1fe2e327-d9db-4752-bcf7-ef0cb4a1748b
Diffstat (limited to 'lib/VNDB')
| -rw-r--r-- | lib/VNDB/HomePages.pm | 4 | ||||
| -rw-r--r-- | lib/VNDB/Util/DB.pm | 8 | ||||
| -rw-r--r-- | lib/VNDB/VN.pm | 4 |
3 files changed, 9 insertions, 7 deletions
diff --git a/lib/VNDB/HomePages.pm b/lib/VNDB/HomePages.pm index 0e99f517..7ce07983 100644 --- a/lib/VNDB/HomePages.pm +++ b/lib/VNDB/HomePages.pm @@ -62,13 +62,13 @@ sub DocPage { } -sub History { # type(p,v,r,u), id, [rss|/] +sub History { # type(p,v,r,u), id, [rss.xml|/] my($self, $type, $id, $fmt) = @_; $type ||= ''; $id ||= 0; $fmt = undef if !$fmt || $fmt eq '/'; - return $self->ResNotFound if $fmt && $fmt ne 'rss'; + return $self->ResNotFound if $fmt && $fmt ne 'rss.xml'; my $f = $self->FormCheck( { name => 'p', required => 0, default => 1, template => 'int' }, diff --git a/lib/VNDB/Util/DB.pm b/lib/VNDB/Util/DB.pm index a2b4a035..87b7ba89 100644 --- a/lib/VNDB/Util/DB.pm +++ b/lib/VNDB/Util/DB.pm @@ -108,6 +108,7 @@ sub DBCategoryCount { SELECT cat, COUNT(vid) AS cnt FROM vn_categories vc JOIN vn v ON v.latest = vc.vid + WHERE v.hidden = 0 GROUP BY cat ORDER BY cnt| )} @@ -119,10 +120,15 @@ sub DBCategoryCount { sub DBLanguageCount { return { (map { $_ => 0 } keys %$VNDB::LANG ), map { $_->{language} => $_->{count} } @{shift->DBAll(q| - SELECT rr.language, COUNT(DISTINCT rv.vid) AS count + SELECT rr.language, COUNT(DISTINCT v.id) AS count FROM releases_rev rr JOIN releases r ON r.latest = rr.id JOIN releases_vn rv ON rv.rid = rr.id + JOIN vn v ON v.id = rv.vid + WHERE r.hidden = 0 + AND v.hidden = 0 + AND rr.type <> 2 + AND rr.released <= TO_CHAR('today'::timestamp, 'YYYYMMDD')::integer GROUP BY rr.language|)} }; } diff --git a/lib/VNDB/VN.pm b/lib/VNDB/VN.pm index fd46672c..5436f07e 100644 --- a/lib/VNDB/VN.pm +++ b/lib/VNDB/VN.pm @@ -286,12 +286,8 @@ sub VNBrowse { page => $f->{p}, chr => $chr, $chr eq 'search' ? ( - incl => \@cati, - excl => \@cate, cat => $self->DBCategoryCount, langc => $self->DBLanguageCount, - lang => \@lang, - plat => \@plat, ) : (), order => [ $f->{s}, $f->{o} ], }, |