X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fcc03%2Fupdate-cc03.sh;fp=sql%2Fcc03%2Fupdate-cc03.sh;h=a44d2a8eeb4fc8b25817f53dd5212393e5cc526b;hp=0000000000000000000000000000000000000000;hb=4d850240c7ff389bf6ad596287abb7d542af72bb;hpb=69e91c419df45838d7c85633b10d0998f0f92f7a

diff --git a/sql/cc03/update-cc03.sh b/sql/cc03/update-cc03.sh
new file mode 100755
index 0000000..a44d2a8
--- /dev/null
+++ b/sql/cc03/update-cc03.sh
@@ -0,0 +1,20 @@
+#! /bin/sh
+
+SEASON="Challenge Cup 2003"
+
+(
+	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" > cc$ccno-03.sql
+	done
+) <<"EOF"
+1	1
+2	3
+3	17
+4	18
+5	22
+6	23
+7	25
+8	27
+EOF