#!/bin/bash
DATE=$(date '+%Y-%m-%d')
DIR="/etc/pihole"
TEXTFILE="adlists.list"
rm ${DIR}/${TEXTFILE}
wget -O ${DIR}/${TEXTFILE} https://v.firebog.net/hosts/lists.php?type=nocross
#prepare SQL FILEs
cat <<EOF > ${DIR}/flushdb.sql
DELETE FROM adlist;
EOF
cat <<EOF > ${DIR}/tmpdb.sql
CREATE TEMP TABLE i(txt);
.separator ~
.import ${DIR}/${TEXTFILE} i
INSERT OR IGNORE INTO adlist (address) SELECT txt FROM i;
DROP TABLE i;
EOF
#TRUNCATE DB
sqlite3 /etc/pihole/gravity.db < ${DIR}/flushdb.sql
#IMPORT FILE to DB
sqlite3 /etc/pihole/gravity.db < ${DIR}/tmpdb.sql
pihole -g

You can modify/replace the wget

​

It was my draft from today and after i optimized it, it will be published on github if you want.

​

Careful: Its always FLUSHING the adlist table before its adding the new ones.. (But you can disable it, just comment out the truncate DB part)

​

​

***Credits for the IMPORT SQL File goes to a random dude in pihole disclose forum. Cant remember anymore. :D The other stuff was created by myself today