summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2020-08-31 08:54:00 +0200
committerYorhel <git@yorhel.nl>2020-08-31 08:54:00 +0200
commit287e2ebd2aa012e992dc2f2b755ceb74298a95f3 (patch)
tree4bac7900a7001ec30e5d519d1a7db1ec2be54c23
parentdc471affb99ecf20e73111c3414d7344aeca81c6 (diff)
unusedimages.pl: Also scan reviews and comments
-rwxr-xr-xutil/unusedimages.pl2
1 files changed, 2 insertions, 0 deletions
diff --git a/util/unusedimages.pl b/util/unusedimages.pl
index 55797c97..019d3c9d 100755
--- a/util/unusedimages.pl
+++ b/util/unusedimages.pl
@@ -62,6 +62,8 @@ sub cleandb {
UNION ALL SELECT description FROM traits
UNION ALL SELECT comments FROM changes
UNION ALL SELECT msg FROM threads_posts
+ UNION ALL SELECT msg FROM reviews_posts
+ UNION ALL SELECT text FROM reviews
) x(text), regexp_matches(text, '}.$fnmatch.q{', 'g') as y(img)
)
) x