X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=sql%2Fvarious%2Fupdate-various.sh;fp=sql%2Fvarious%2Fupdate-various.sh;h=dc2194bc9e65fe498a4825f8c548bee5c4721146;hp=0000000000000000000000000000000000000000;hb=38489516a9ad620f3f5cf5a8e5f36117c579e922;hpb=7dfd3ff8c5e3fde12813a1e7b937e5816a027f7a

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