summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-12-29 12:37:21 +0100
committerYorhel <git@yorhel.nl>2020-12-29 12:37:24 +0100
commit7363cd3f6ebc9b78c2bc6f56d0e3894dac30e824 (patch)
treeacb09d5e66a375799446f4fbba6c56848c3c0619 /util
parentf18a9815d079620820df3e22b631f306b3181c4d (diff)
DB dumps: also export the quotes table
The full list of quotes used to be one of VNDB's most well guarded secrets, but it's been scraped often enough now that I might as well just make it public.
Diffstat (limited to 'util')
-rwxr-xr-xutil/dbdump.pl1
1 files changed, 1 insertions, 0 deletions
diff --git a/util/dbdump.pl b/util/dbdump.pl
index 51503b44..754981e1 100755
--- a/util/dbdump.pl
+++ b/util/dbdump.pl
@@ -60,6 +60,7 @@ my %tables = (
image_votes => { where => "id IN(SELECT id FROM images WHERE c_weight > 0)", order => 'uid, id' },
producers => { where => 'NOT hidden' },
producers_relations => { where => 'id IN(SELECT id FROM producers WHERE NOT hidden)' },
+ quotes => { where => 'vid IN(SELECT id FROM vn WHERE NOT hidden)' },
releases => { where => 'NOT hidden' },
releases_lang => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden)' },
releases_media => { where => 'id IN(SELECT id FROM releases WHERE NOT hidden)' },