From 287e2ebd2aa012e992dc2f2b755ceb74298a95f3 Mon Sep 17 00:00:00 2001 From: Yorhel Date: Mon, 31 Aug 2020 08:54:00 +0200 Subject: unusedimages.pl: Also scan reviews and comments --- util/unusedimages.pl | 2 ++ 1 file changed, 2 insertions(+) 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 -- cgit v1.2.3