git.sesse.net Git - ccbs/blob - sql/cc03/update-cc03.sh

   1 #! /bin/sh
   2
   3 SEASON="Challenge Cup 2003"
   4
   5 (
   6         while read ccno id; do
   7                 wget -O- "http://www.ddreurope.com/results.php?since=0&act=2&t_id=$id" |
   8                 iconv -f latin1 -t utf8 |
   9                         perl ../../parse/parse-ddreurope-tournament.pl "$SEASON" > cc$ccno-03.sql
  10         done
  11 ) <<"EOF"
  12 1       1
  13 2       3
  14 3       17
  15 4       18
  16 5       22
  17 6       23
  18 7       25
  19 8       27
  20 EOF