From: Steinar H. Gunderson Date: Mon, 14 Feb 2005 02:18:26 +0000 (+0000) Subject: Update the parser scripts to handle tournament rankings, and fix a typo in the SQL... X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=4ddc2d1937960d5cf4017644a41433eac2f6f391 Update the parser scripts to handle tournament rankings, and fix a typo in the SQL for it. Update CC04 test SQL. --- diff --git a/parse/parse-ddreurope-tournament.pl b/parse/parse-ddreurope-tournament.pl index 5773f13..b0da713 100644 --- a/parse/parse-ddreurope-tournament.pl +++ b/parse/parse-ddreurope-tournament.pl @@ -140,6 +140,32 @@ while (<>) { print " round=$round;\n"; } + # First place + if (/A \s* well-earned \s* victory \s* for .*? class="link"> (.*?) <\/a> (?: , \s* who \s* got \s* (\d+) \s* point )?/x) { + my $nick = $1; + my $points = $2; + + # Whoa :-) + $points = 'NULL' unless defined($points); + + print "INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (\n"; + print " (SELECT tournament FROM tournaments WHERE tournamentname='$name'),\n"; + print " 1, '$nick', $points);\n"; + } + + # All other places + while (s/(\d+) (?: st | nd | rd | th ) \s* place: .*? class="link"> (.*?) <\/a> \s* (?: got \s* (\d+) \s* point )?//x) { + my $ranking = $1; + my $nick = $2; + my $points = $3; + + # Whoa :-) + $points = 'NULL' unless defined($points); + + print "INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES (\n"; + print " (SELECT tournament FROM tournaments WHERE tournamentname='$name'),\n"; + print " $ranking, '$nick', $points);\n"; + } } printf "commit;\n"; diff --git a/sql/cc04/cc1-04.sql b/sql/cc04/cc1-04.sql index d7fd99b..6b8c80c 100644 --- a/sql/cc04/cc1-04.sql +++ b/sql/cc04/cc1-04.sql @@ -9,6 +9,108 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 1, 'Snute', 100); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 2, 'DufF', 90); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 3, 'OJK', 81); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 4, 'Oliyzia', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 5, 'Tom', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 6, 'Snofox', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 7, 'RiChY', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 8, 'Haggar', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 9, 'Mulefisk', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 10, 'Daniil', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 11, 'T|na', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 12, 'Stream', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 13, 'Purity', 43); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 14, 'Spinnvill', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 15, 'Jallaman', 41); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 16, 'Smiph', 40); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 17, 'Electus', 39); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 18, 'Havok', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 19, 'Dexter', 37); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 20, 'Draconia', 36); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 21, 'Advena', 35); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 22, 'Slusk', 34); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 23, 'Telc', 33); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 24, 'Matsi', 32); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 25, 'Olemann', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 26, 'Duckling', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 27, 'Ylini', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 28, 'Golddragon', 28); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 29, 'tombot', 27); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 30, 'x3mnrj', 26); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 31, 'Tha Dragon', 25); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 32, 'Octu', 24); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 33, 'Ink', 23); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), + 34, 'Auran', 22); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 1 - 2004'), diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql index 61dea24..641a3df 100644 --- a/sql/cc04/cc2-04.sql +++ b/sql/cc04/cc2-04.sql @@ -9,6 +9,51 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 1, 'OJK', 100); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 2, 'Snute', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 3, 'DufF', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 4, 'Snofox', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 5, 'T|na', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 6, 'RiChY', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 7, 'Stream', 55); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 8, 'Olemann', 51); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 9, 'Raazu', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 10, 'Ylini', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 11, 'Smiph', 45); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 12, 'Havok', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 13, 'Draconia', 43); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 14, 'Dabi', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), + 15, 'Bush', 41); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 2'), diff --git a/sql/cc04/cc3-04.sql b/sql/cc04/cc3-04.sql index b235ff4..c4d7be7 100644 --- a/sql/cc04/cc3-04.sql +++ b/sql/cc04/cc3-04.sql @@ -9,6 +9,102 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 1, 'Snute', 100); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 2, 'DufF', 90); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 3, 'Hugo', 81); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 4, 'Oliyzia', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 5, 'RiChY', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 6, 'OJK', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 7, 'Haggar', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 8, 'T|na', 51); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 9, 'Stream', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 10, 'Nameless', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 11, 'Ylini', 45); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 12, 'Mulefisk', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 13, 'Th0rny', 43); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 14, 'Duckling', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 15, 'Olemann', 41); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 16, 'Smiph', 40); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 17, 'Dabi', 39); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 18, 'Zyc', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 19, 'Draconia', 37); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 20, 'Advena', 36); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 21, 'Bonzo', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 22, 'Ted Kristian', 34); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 23, 'Jim Andre', 33); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 24, 'Glukko', 32); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 25, 'Tassen', 31); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 26, 'Matsi', 30); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 27, 'Gollum', 29); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 28, 'PÃ¥l Andre', 28); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 29, 'Andre', 27); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 30, 'Eruanna', 26); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 31, 'Auran', 25); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), + 32, 'Ole-Christian', 24); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 3'), diff --git a/sql/cc04/cc4-04.sql b/sql/cc04/cc4-04.sql index 292a562..12a98fb 100644 --- a/sql/cc04/cc4-04.sql +++ b/sql/cc04/cc4-04.sql @@ -9,6 +9,105 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 1, 'Snute', 100); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 2, 'DufF', 90); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 3, 'RiChY', 81); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 4, 'Haggar', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 5, 'Nameless', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 6, 'OJK', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 7, 'Snofox', 55); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 8, 'Tom', 51); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 9, 'Pingo', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 10, 'Oliyzia', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 11, 'Gogo', 45); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 12, 'Duckling', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 13, 'T|na', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 14, 'Daniil', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 15, 'Ylini', 41); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 16, 'Mulefisk', 40); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 17, 'Olemann', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 18, 'Tassen', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 19, 'Bonzo', 37); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 20, 'Mync', 36); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 21, 'Ozon', 35); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 22, 'PÃ¥l Andre', 34); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 23, 'Ted Kristian', 33); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 24, 'Dabi', 32); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 25, 'Draconia', 31); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 26, 'Alexxz', 30); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 27, 'Stream', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 28, 'Smiph', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 29, 'Jim Andre', 27); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 30, 'Glukko', 26); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 31, 'Hyper', 25); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 32, 'Mario', 24); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), + 33, 'Zeek', 23); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 4'), diff --git a/sql/cc04/cc5-04.sql b/sql/cc04/cc5-04.sql index e2dca16..1c0e834 100644 --- a/sql/cc04/cc5-04.sql +++ b/sql/cc04/cc5-04.sql @@ -9,6 +9,120 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 1, 'Snute', 200); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 2, 'DufF', 180); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 3, 'Haggar', 162); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 4, 'OJK', 146); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 5, 'RiChY', 132); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 6, 'Nameless', 120); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 7, 'Gogo', 110); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 8, 'T|na', 102); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 9, 'Pingo', 96); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 10, 'Daniil', 92); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 11, 'Duckling', 90); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 12, 'Oliyzia', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 13, 'Bonzo', 86); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 14, 'Stream', 84); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 15, 'Olemann', 82); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 16, 'Ozon', 80); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 17, 'Mync', 78); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 18, 'Ylini', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 19, 'Smiph', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 20, 'Cuivien', 72); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 21, 'Haanz', 70); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 22, 'Felz', 68); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 23, 'Cehtna', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 24, 'Andeplane', 64); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 25, 'Alexxz', 62); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 26, 'Asphodel', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 27, 'Havok', 58); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 28, 'Zeila', 56); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 29, 'Ngan', 54); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 30, 'Andre', 52); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 31, 'Lindaninja', 50); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 32, 'Eruanna', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 33, 'Ingviild', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 34, 'Marilla', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 35, 'Mickva', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 36, 'Chimera', 40); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 37, 'Maxion', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), + 38, 'Athena', 36); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 5 - NM'), diff --git a/sql/cc04/cc6-04.sql b/sql/cc04/cc6-04.sql index 66b85fb..8c6fcdf 100644 --- a/sql/cc04/cc6-04.sql +++ b/sql/cc04/cc6-04.sql @@ -9,6 +9,126 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 1, 'Snute', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 2, 'DufF', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 3, 'OJK', 81); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 4, 'Snofox', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 5, 'Oliyzia', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 6, 'Haggar', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 7, 'Nameless', 55); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 8, 'Ylini', 51); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 9, 'Bonzo', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 10, 'T|na', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 11, 'Daniil', 45); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 12, 'Pingo', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 13, 'RiChY', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 14, 'ViD', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 15, 'Felz', 41); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 16, 'Gogo', 40); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 17, 'Smiph', 39); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 18, 'Mync', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 19, 'Duckling', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 20, 'Goku', 36); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 21, 'Th0rny', 35); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 22, 'Matsi', 34); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 23, 'Draconia', 33); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 24, 'Ozon', 32); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 25, 'Andeplane', 31); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 26, 'Alexxz', 30); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 27, 'Electron', 29); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 28, 'Pyro', 28); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 29, 'Matti', 27); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 30, 'Athena', 26); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 31, 'Hyper', 25); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 32, 'Zackie', 24); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 33, 'Montana', 23); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 34, 'Annkakri', 22); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 35, 'Glukko', 21); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 36, 'Glock', 20); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 37, 'v|per', 19); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 38, 'Ifrit', 18); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 39, 'JonAnders', 17); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), + 40, 'Guru', 16); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 6'), diff --git a/sql/cc04/cc7-04.sql b/sql/cc04/cc7-04.sql index bf933a6..dab5a73 100644 --- a/sql/cc04/cc7-04.sql +++ b/sql/cc04/cc7-04.sql @@ -9,6 +9,141 @@ INSERT INTO tournaments (SELECT machine FROM machines WHERE machinename='Dancing Stage EuroMix 2'), (SELECT scoringsystem FROM scoringsystems WHERE scoringsystemname='10K Machine score') ); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 1, 'Haggar', 100); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 2, 'Snute', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 3, 'Nameless', 81); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 4, 'Snofox', 73); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 5, 'Bonzo', 66); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 6, 'Oliyzia', 60); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 7, 'RiChY', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 8, 'OJK', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 9, 'Pingo', 48); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 10, 'Gogo', 46); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 11, 'T|na', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 12, 'Olemann', 44); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 13, 'Duckling', 43); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 14, 'Andeplane', 42); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 15, 'Ylini', 41); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 16, 'Daniil', 0); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 17, 'Mync', 39); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 18, 'Smiph', 38); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 19, 'Felz', 37); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 20, 'Alexxz', 36); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 21, 'v|per', 35); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 22, 'Dritago', 34); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 23, 'SLC', 33); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 24, 'Athena', 32); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 25, 'Pfxp', 31); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 26, 'Matsi', 30); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 27, 'Zeila', 29); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 28, 'Electron', 28); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 29, 'Pyro', 27); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 30, 'Volstad', 26); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 31, 'Zackie', 25); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 32, 'Matti', 24); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 33, 'Eruanna', 23); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 34, 'Indy', 22); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 35, 'Crienexzy', 21); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 36, 'Hyper', 20); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 37, 'Benny', 19); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 38, 'Marilla', 18); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 39, 'uSimen', 17); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 40, 'JonAnders', 16); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 41, 'Bush', 15); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 42, 'Voffen', 14); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 43, 'Annkakri', 13); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 44, 'Glock', 12); +INSERT INTO tournamentrankings (tournament, ranking, player, points) VALUES ( + (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), + 45, 'Tove', 11); INSERT INTO rounds (tournament, round, randomsongs, chosensongs) VALUES ( (SELECT tournament FROM tournaments WHERE tournamentname='Challenge Cup 7'), diff --git a/sql/ccbs.sql b/sql/ccbs.sql index 44dcdf9..b7d342a 100644 --- a/sql/ccbs.sql +++ b/sql/ccbs.sql @@ -73,7 +73,7 @@ CREATE TABLE tournamentrankings ( tournament INTEGER NOT NULL REFERENCES tournaments, ranking INTEGER NOT NULL, player INTEGER NOT NULL REFERENCES players, - points INTEGER + points INTEGER, UNIQUE (tournament, player), PRIMARY KEY (tournament, ranking)