diff options
author | Yorhel <git@yorhel.nl> | 2020-12-29 12:37:21 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2020-12-29 12:37:24 +0100 |
commit | 7363cd3f6ebc9b78c2bc6f56d0e3894dac30e824 (patch) | |
tree | acb09d5e66a375799446f4fbba6c56848c3c0619 /util | |
parent | f18a9815d079620820df3e22b631f306b3181c4d (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-x | util/dbdump.pl | 1 |
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)' }, |