Add scripts and example SQL for parsing the EM2 series from 2002.

[ccbs] / sql / em2-series / update-em2s.sh

diff --git a/sql/em2-series/update-em2s.sh b/sql/em2-series/update-em2s.sh
new file mode 100755 (executable)
index 0000000..d391126
--- /dev/null
+++ b/sql/em2-series/update-em2s.sh
@@ -0,0 +1,23 @@
+#! /bin/sh
+
+SEASON="Euromix 2-serie 2002"
+
+(
+       while read ccno id; do
+               wget -O- "http://www.ddreurope.com/results.php?since=0&act=2&t_id=$id" |
+               iconv -f latin1 -t utf8 |
+                       perl ../../parse/parse-ddreurope-tournament.pl "$SEASON" > em2s$ccno.sql
+       done
+) <<"EOF"
+01     6
+02     7
+03     8
+04     9
+05     10
+06     11
+07     12
+08     13
+09     14
+10     15
+11     16
+EOF