X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=sql%2Fem2-series%2Fupdate-em2s.sh;fp=sql%2Fem2-series%2Fupdate-em2s.sh;h=d391126e64fd2099699c769c3c6f0209e0b77bf9;hb=629352f0146f1e096bfe61cb604bbf848145f844;hp=0000000000000000000000000000000000000000;hpb=29622ff6c28f9e8e44c022f71b62f1d6685718f9;p=ccbs

diff --git a/sql/em2-series/update-em2s.sh b/sql/em2-series/update-em2s.sh
new file mode 100755
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