SQL: Fix all browsing queries to use the new schema

This basically makes VNDB browsable again, but editing entries is still
broken.

I split off the get-old-revision functionality from the db*Get() methods
into db*GetRev(). This split makes sense even with the old SQL schema:
db*Get() had to special-case some joins/filters when fetching an older
revision, and none of the other filters would work in that case. This
split does cause some code duplication in that all db*GetRev() methods
look very much alike, and that the columns they fetch is almost
identical to the db*Get() methods. Not sure yet how to avoid the
duplication elegantly.

I didn't do a whole lot of query optimization yet (most issues require
extra indices, I'll investigate later which indices will make a big
difference), but I did fix some low hanging fruit whenever I encountered
something.

I don't think I've worsened anything, performance-wise.

1 files changed, 1 insertions, 1 deletions

diff --git a/lib/VNDB/Handler/VNEdit.pm b/lib/VNDB/Handler/VNEdit.pm
index 8869d1a9..c383be78 100644
--- a/lib/VNDB/Handler/VNEdit.pm
+++ b/lib/VNDB/Handler/VNEdit.pm
@@ -79,7 +79,7 @@ sub edit {
 
   my $v = $vid && $self->dbVNGet(id => $vid, what => 'extended screenshots relations anime credits changes', $rev ? (rev => $rev) : ())->[0];
   return $self->resNotFound if $vid && !$v->{id};
-  $rev = undef if !$vid || $v->{cid} == $v->{latest};
+  $rev = undef if !$vid || $v->{lastrev};
 
   return $self->htmlDenied if !$self->authCan('edit')
     || $vid && (($v->{locked} || $v->{hidden}) && !$self->authCan('dbmod'));