#!/bin/bash
grep llamajuice /var/log/apache/access_log|
  grep -E 'ogg|mp3|flac'|
  grep GET|
  awk '{print $1,$7}'|
  sort|
  uniq|
  awk '{print $2}'|
  rev|
  cut -d. -f2|
  cut -d/ -f1|
  rev|
  sed 's/%../_/g;s/[^-a-zA-Z0-9_]/_/g'|
  sort|
  uniq -c >/var/www/htdocs/media/llamajuice/HITS.txt

