#! /bin/sh

# save web site with table tennis table of Verbandsklasse South Men
wget -O /tmp/tmp_table.htm "http://ttvbw.click-tt.de/cgi-bin/WebObjects/ClickTTVBW.woa/wa/groupPage?championship=SK+TTVWH+05/06&group=11528"

# remove everything apart from the target table
sed -e '1,/<h2>Tabelle<\/h2>/d;/<\/table>/,$d' /tmp/tmp_table.htm > /tmp/tmp_table2.htm

# remove html tags
sed -e 's/<[^>]*>//g' /tmp/tmp_table2.htm > /tmp/tmp_table.txt

# remove trailing whitespaces or tabs
# delete lines which contain &nbsp;
# delete empty lines
sed -e 's/^[ 	]*//g' -e '/&nbsp;/d' -e '/^[ 	]*$/d' /tmp/tmp_table.txt > /tmp/tmp_table2.txt

# make all teams the same length and replace special characters
sed -e 's/MUTTV Bad Liebenzell e.V./MUTTV Bad Liebenzell e.V./g
	s/TTC Reutlingen/TTC Reutlingen~t/g
	s/SC Staig/SC Staig~t~t/g
	s/TTC Ergenzingen/TTC Ergenzingen~t/g
	s/TSG Ailingen/TSG Ailingen~t~t/g
	s/SSV Ulm 46/SSV Ulm 46~t~t/g
	s/TSV Nusplingen/TSV Nusplingen~t/g
	s/TTC Lossburg-Rodt/TTC Lossburg-Rodt~t/g
	s/SV B.blingen/SV B~oblingen~t~t/g
	s/TSV Betzingen/TSV Betzingen~t~t/g' /tmp/tmp_table2.txt > /tmp/tmp_table3.txt 	

# beginning at line 1, print every 8th line
# beginning at line 2, print every 8th line
# beginning at line 3, print every 8th line
# beginning at line 7, print every 8th line and add a tab
# beginning at line 8, print every 8th line
sed -n 'p;n;p;n;p;n;n;n;n;s/$/~t/g;p;n;p' /tmp/tmp_table3.txt > /tmp/tmp_table4.txt

# make a table with 5 columns
sed -e 'N;N;N;N' -e 's/\n/~t/g' /tmp/tmp_table4.txt > /tmp/tmp_table5.txt

# remove first line of table
# mark the first team in green
# mark the last two teams in red
sed -e '1d
	2s/^/~G/g
	10,11s/^/~Y/g' /tmp/tmp_table5.txt > /tmp/tmp_table6.txt

msgbox title="Herren Verbandsklasse S~ud" size=34 msg=/tmp/tmp_table6.txt

# delete all temporary files
rm /tmp/tmp_table.htm
rm /tmp/tmp_table2.htm
rm /tmp/tmp_table.txt
rm /tmp/tmp_table2.txt
rm /tmp/tmp_table3.txt
rm /tmp/tmp_table4.txt
rm /tmp/tmp_table5.txt
rm /tmp/tmp_table6.txt
