diff options
author | Yorhel <git@yorhel.nl> | 2014-12-02 11:39:35 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2014-12-02 11:39:35 +0100 |
commit | 65db0718f4a3e42930dbf660068c1c309d47b08a (patch) | |
tree | 2a47031435820efa88e9aa5a804c60faf9ce829d /lib/VNDB/DB/VN.pm | |
parent | 42e5a4793fc02ef54805ab5706830bbb2e1bd086 (diff) |
Completely drop l_vnn column from VN info
Used to link to a visual-novels.net review or something. Links have been
hidden and dead since ages. No need to keep the column around.
Diffstat (limited to 'lib/VNDB/DB/VN.pm')
-rw-r--r-- | lib/VNDB/DB/VN.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm index cd844a27..090f9ecb 100644 --- a/lib/VNDB/DB/VN.pm +++ b/lib/VNDB/DB/VN.pm @@ -103,7 +103,7 @@ sub dbVNGet { my @select = ( # see https://rt.cpan.org/Ticket/Display.html?id=54224 for the cast on c_languages and c_platforms qw|v.id v.locked v.hidden v.c_released v.c_languages::text[] v.c_platforms::text[] vr.title vr.original v.rgraph|, 'vr.id AS cid', $o{what} =~ /extended/ ? ( - qw|vr.alias vr.image vr.img_nsfw vr.length vr.desc vr.l_wp vr.l_encubed vr.l_renai vr.l_vnn| ) : (), + qw|vr.alias vr.image vr.img_nsfw vr.length vr.desc vr.l_wp vr.l_encubed vr.l_renai| ) : (), $o{what} =~ /changes/ ? ( qw|c.requester c.comments v.latest u.username c.rev c.ihid c.ilock|, q|extract('epoch' from c.added) as added|) : (), $o{what} =~ /relgraph/ ? 'vg.svg' : (), @@ -203,7 +203,7 @@ sub dbVNRevisionInsert { $o->{img_nsfw} = $o->{img_nsfw}?1:0 if exists $o->{img_nsfw}; my %set = map exists($o->{$_}) ? (qq|"$_" = ?| => $o->{$_}) : (), - qw|title original desc alias image img_nsfw length l_wp l_encubed l_renai l_vnn|; + qw|title original desc alias image img_nsfw length l_wp l_encubed l_renai|; $self->dbExec('UPDATE edit_vn !H', \%set) if keys %set; if($o->{screenshots}) { |