# Scripting Adlist Management in v5

**URL:** https://discourse.pi-hole.net/t/scripting-adlist-management-in-v5/31962
**Category:** Customizing Pi-hole
**Tags:** v5-0
**Created:** [May 11, 2020, 1:23pm UTC](https://discourse.pi-hole.net/t/scripting-adlist-management-in-v5/31962 "2020-05-11T13:23:34Z")
**Posts on this page:** 1
**Showing post:** 3

<div class="post-metadata">

### Author: ![papasan](https://discourse-cdn.pi-hole.net/letter_avatar_proxy/v4/letter/p/ee7513/32.png) [@papasan](https://discourse.pi-hole.net/u/papasan)
#### Post date: [May 11, 2020, 5:14pm UTC](https://discourse.pi-hole.net/t/scripting-adlist-management-in-v5/31962/3 "2020-05-11T17:14:54Z")

</div>

so I poked around a bit and answered my own question...

```auto
sudo sqlite3 /etc/pihole/gravity.db "DELETE FROM adlist"
sudo wget -qO - https://v.firebog.net/hosts/lists.php?type=tick |xargs -I {} sudo sqlite3 /etc/pihole/gravity.db "INSERT INTO adlist (Address) VALUES ('{}');"
pihole -g

```

---

_[View the full topic](https://discourse.pi-hole.net/t/scripting-adlist-management-in-v5/31962)._