#!/bin/bash
cat *.db.tar.gz | tar -tvz | grep -e "^d" | awk '{print $6}' | grep -Po "(.*)(?=-([^-]*)-([^-]*))" | sort -u > /tmp/pkgs-from-repo.txt
pacman -Qqn > /tmp/pkgs-from-arch.txt
sort /tmp/pkgs-from-arch.txt /tmp/pkgs-from-repo.txt | uniq -d | awk '{print "-o -name \""$1"*.tar.xz\""}' | xargs find -name "*.old" > /tmp/pkgs-rm.txt
echo "[!] Removing: "
cat /tmp/pkgs-rm.txt
read -r -p "[?] Are you sure? [y/N] " U_SURE
case "$U_SURE" in
        [yY])
                cat /tmp/pkgs-rm.txt | xargs repo-remove *.db.tar.gz
                cat /tmp/pkgs-rm.txt | xargs rm
esac