diff options
| author | Yorhel <git@yorhel.nl> | 2020-03-19 12:40:27 +0100 |
|---|---|---|
| committer | Yorhel <git@yorhel.nl> | 2020-03-19 12:40:27 +0100 |
| commit | 26fd8b8eba6efaa79748c91b557ebe8494b7068c (patch) | |
| tree | 9c80fac1b0535a9458a8e6b27acc0a7e5ff91bea | |
| parent | d733208de47d2f71d6f14a97796dbfc8f67f2715 (diff) | |
dbdump/imgflag: Make sure to include users who voted on images
| -rwxr-xr-x | util/dbdump.pl | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/util/dbdump.pl b/util/dbdump.pl index 11cd2046..9946ad9e 100755 --- a/util/dbdump.pl +++ b/util/dbdump.pl @@ -88,7 +88,8 @@ my %tables = ( ulist_vns_labels => { where => 'vid IN(SELECT id FROM vn WHERE NOT hidden)' .' AND EXISTS(SELECT 1 FROM ulist_labels ul WHERE ul.uid = ulist_vns_labels.uid AND id = lbl AND NOT ul.private)' }, users => { where => 'id IN(SELECT DISTINCT uvl.uid FROM ulist_vns_labels uvl JOIN ulist_labels ul ON ul.uid = uvl.uid AND ul.id = uvl.lbl WHERE NOT ul.private)' - .' OR id IN(SELECT DISTINCT uid FROM tags_vn)' }, + .' OR id IN(SELECT DISTINCT uid FROM tags_vn)' + .' OR id IN(SELECT DISTINCT uid FROM image_votes)' }, vn => { where => 'NOT hidden' }, vn_anime => { where => 'id IN(SELECT id FROM vn WHERE NOT hidden)' }, vn_relations => { where => 'id IN(SELECT id FROM vn WHERE NOT hidden)' }, |