PiHole CNAME cloacking updater using NextDNS blocklist

cname-cloaking-nextdns-updater.sh

#!/usr/bin/env bash
# https://github.com/nextdns/cname-cloaking-blocklist
# Add this script to /etc/cron.weekly and make it executable

file=/tmp/pihole-nextdns.$$
Cleanup() {
    rm -f $file
}
trap Cleanup EXIT

wget -q https://raw.githubusercontent.com/nextdns/cname-cloaking-blocklist/master/domains -O $file

# Clear old list
# echo "SQL: DELETE FROM domainlist WHERE type=3 AND comment='NextDNS CNAME list';"
sqlite3 /etc/pihole/gravity.db "DELETE FROM domainlist WHERE type=3 AND comment='NextDNS CNAME list';"

while read -r domain
do
   if ! [[ "$domain" == \#* ]]; then
      if [ ! -z "$domain" ]; then
         # echo -ne "\n\nDomain: ${domain}\n"
         regex=(\\.\|^)${domain%.*}\\.${domain##*.}$
         # echo "Regex: ${regex}"
         # echo "SQL: INSERT OR IGNORE INTO domainlist (type, domain, enabled, comment) VALUES (3, \"$regex\", 1, 'NextDNS CNAME list');"
         sqlite3 /etc/pihole/gravity.db "INSERT OR IGNORE INTO domainlist (type, domain, enabled, comment) VALUES (3, \"$regex\", 1, 'NextDNS CNAME list');"
      fi
   fi
done < $file

/usr/local/bin/pihole restartdns reload-lists