Add scripts for getting CC03 data, and premade SQL.

[ccbs] / sql / cc03 / update-cc03.sh

diff --git a/sql/cc03/update-cc03.sh b/sql/cc03/update-cc03.sh
new file mode 100755 (executable)
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