factoids

#!/bin/bash
[ -e ubuntu.db ] && rm ubuntu.db
wget http://ubottu.com/ubuntu.db
[ -e ubuntu.new.db ] && rm ubuntu.new.db
sqlite ubuntu.db .dump | sqlite3 ubuntu.new.db
sqlite3 ubuntu.new.db 'select * from facts' > factoids.db
cut -d'|' -f3,5 factoids.db > factoids.txt
sed -i 's/<reply>\s*//g' factoids.txt
grep -v "<alias>" factoids.txt > new_factoids.txt
grep "<alias>" factoids.txt > new_aliases.txt
cat new_factoids.txt new_aliases.txt > facts.txt
awk -F '|' -v OFS='|' '$2~/<alias>/{sub(/<alias> /,"",$2);$2=a[$2]} $2!~/<alias>/{a[$1]=$2} 1' facts.txt > factoids.txt
[ -s VoteBotFactoids.txt ] && cat VoteBotFactoids.txt >> factoids.txt
sed -i 's/\$chan/\$channel/g' factoids.txt
rm factoids.db facts.txt new_aliases.txt new_factoids.txt ubuntu.db ubuntu.new.db