Update the parser scripts to handle tournament rankings, and fix a typo in the SQL...

[ccbs] / sql / cc04 / cc2-04.sql

diff --git a/sql/cc04/cc2-04.sql b/sql/cc04/cc2-04.sql
index 61dea244d0d10102ce6e01d122498f20ad34bc4b..641a3df21ba2402f19ad36566a4d4a4fe52a1d40 100644 (file)
--- 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'),