#!/bin/sh

cnt=0
gifscmd="/usr/local/bin/gifsicle -m -l0"
IFS="
"

rm -f *gif

for nadpis in `/usr/local/mysql/bin/mysql DB -uLOGIN -pPASSWORD -e "SELECT \
nadpis FROM tabulka WHERE TO_DAYS(datum)<=TO_DAYS(NOW()) \
ORDER BY datum DESC LIMIT 0,3"`; do
	if test $cnt -ne 0; then
		echo "new
size 400,18
name out$cnt.gif
frect 0,0,399,17,255,255,255
rect 0,0,399,17,0,0,0
string 0,0,0,10,2,small,$nadpis
end" | /usr/local/bin/fly -q

		gifscmd="$gifscmd -d 200 out$cnt.gif"
	fi
	cnt=$[cnt + 1]
done

eval "$gifscmd" >out.gif