Add various tournaments from DDR Europe. Not all are insertable into the current...

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

diff --git a/sql/various/update-various.sh b/sql/various/update-various.sh
new file mode 100755 (executable)
index 0000000..dc2194b
--- /dev/null
+++ b/sql/various/update-various.sh
@@ -0,0 +1,26 @@
+#! /bin/sh
+
+(
+       while read season no id; do
+               season="`echo $season | tr _ ' '`"
+               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" > various-$no.sql
+       done
+) <<"EOF"
+European_Cup   1       30
+Beginner       2       32
+Frittstående  3       20
+Frittstående  4       26
+Frittstående  5       19
+Frittstående  6       34
+Frittstående  7       33
+Frittstående  8       24
+Geneva_Tournament      9       37
+Geneva_Tournament      10      36
+International  11      21
+International  12      28
+Norgesmesterskap       13      2
+Testturnering  14      4
+Testturnering  15      5
+EOF