diff options
-rw-r--r-- | ChangeLog | 2 | ||||
-rw-r--r-- | lib/VNDB/DB/VN.pm | 2 | ||||
-rw-r--r-- | lib/VNDB/Handler/Misc.pm | 2 | ||||
-rwxr-xr-x | util/vndb.pl | 2 |
4 files changed, 4 insertions, 4 deletions
@@ -1,4 +1,4 @@ -2.4 - ? +2.4 - 2009-06-07 - Release search + browser + filters - Javascript date input - More release information: diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index dcb3bd39..d0a38ced 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -80,7 +80,7 @@ sub dbVNGet { $o{what} =~ /changes/ ? ( qw|c.added c.requester c.comments v.latest u.username c.rev c.causedby|) : (), $o{what} =~ /relgraph/ ? 'rg.cmap' : (), - $o{what} =~ /ranking/ ? '(SELECT COUNT(*) FROM vn iv WHERE iv.hidden = false AND iv.c_popularity > v.c_popularity) AS ranking' : (), + $o{what} =~ /ranking/ ? '(SELECT COUNT(*)+1 FROM vn iv WHERE iv.hidden = false AND iv.c_popularity > v.c_popularity) AS ranking' : (), ); my($r, $np) = $self->dbPage(\%o, q| diff --git a/lib/VNDB/Handler/Misc.pm b/lib/VNDB/Handler/Misc.pm index dacc0f9c..f2f66f0b 100644 --- a/lib/VNDB/Handler/Misc.pm +++ b/lib/VNDB/Handler/Misc.pm @@ -330,7 +330,7 @@ sub itemmod { return $self->htmlDenied if !$self->authCan($act eq 'hide' ? 'del' : 'lock'); my $obj = $type eq 'v' ? $self->dbVNGet(id => $iid)->[0] : - $type eq 'r' ? $self->dbReleaseGet(id => $iid, what => 'vn')->[0] : + $type eq 'r' ? $self->dbReleaseGet(id => $iid, what => 'vn extended')->[0] : $self->dbProducerGet(id => $iid)->[0]; return 404 if !$obj->{id}; diff --git a/util/vndb.pl b/util/vndb.pl index ca61836f..8a9a83e5 100755 --- a/util/vndb.pl +++ b/util/vndb.pl @@ -73,7 +73,7 @@ sub handle404 { h1 'Page not found'; div class => 'warning'; h2 'Oops!'; - p "It seems the page you were looking for does not exists,\n". + p "It seems the page you were looking for does not exist,\n". "you may want to try using the menu on your left to find what you are looking for."; end; end; |