From: Steinar H. Gunderson Date: Fri, 18 Feb 2005 17:25:43 +0000 (+0000) Subject: Fix DDRFreak parser to output some UTF-8 glyphs instead of HTML entities. Update... X-Git-Url: https://git.sesse.net/?p=ccbs;a=commitdiff_plain;h=2dc466098bdc888c668881c51644eae61adedb1b Fix DDRFreak parser to output some UTF-8 glyphs instead of HTML entities. Update Extreme SQL accordingly. --- diff --git a/parse/parse-ddrfreak-songlist.pl b/parse/parse-ddrfreak-songlist.pl index c2fc231..d4f3e5c 100644 --- a/parse/parse-ddrfreak-songlist.pl +++ b/parse/parse-ddrfreak-songlist.pl @@ -85,6 +85,13 @@ while (<>) { $songname = "$songname ($artist)"; } + # Some HTML -> UTF-8 stuff + $songname =~ s/♥/\xe2\x9d\xa4/g; + $songname =~ s/∀/\xe2\x88\x80/g; + $songname =~ s/★/\xe2\x98\x85/g; + $songname =~ s/é/\xc3\xa9/g; + $songname =~ s/2<\/sup>/\xc2\xb2/g; + # minimal SQL escaping $songname =~ s/'/\\'/g; $artist =~ s/'/\\'/g; diff --git a/sql/ex-songlist.sql b/sql/ex-songlist.sql index d1c6c67..040b7aa 100644 --- a/sql/ex-songlist.sql +++ b/sql/ex-songlist.sql @@ -96,16 +96,16 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LA COPA DE LA VIDA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LA COPA DE LA VIDA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LA COPA DE LA VIDA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'LOVE ♥ SHINE' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('LOVE ♥ SHINE') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',8); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ♥ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'LOVE ❤ SHINE' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('LOVE ❤ SHINE') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('LOVE ❤ SHINE')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'MEMORIES' AS title, 'NAOKI feat. PAULA TERRY' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('MEMORIES') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('MEMORIES') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MEMORIES')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); @@ -217,14 +217,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'B4U (B4 ZA BEAT MIX INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('B4U (B4 ZA BEAT MIX)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('B4U (B4 ZA BEAT MIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('B4U (B4 ZA BEAT MIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BRE∀K DOWN!' AS title, 'Be For U' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('BRE∀K DOWN!') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BRE∀K DOWN!' AS title, 'Be For U' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('BRE∀K DOWN!') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRE∀K DOWN!')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BRILLIANT 2U (K.O.G. G3 MIX)' AS title, 'NAOKI' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('BRILLIANT 2U (K.O.G. G3 MIX)') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BRILLIANT 2U (K.O.G. G3 MIX)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BRILLIANT 2U (K.O.G. G3 MIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7); @@ -233,14 +233,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'BURNIN\' THE FLOOR INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('BURNIN\' THE FLOOR (BLUE FIRE mix)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BURNIN\' THE FLOOR (BLUE FIRE mix)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('BURNIN\' THE FLOOR (BLUE FIRE mix)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY♥' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY♥') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY❤' AS title, 'Riyu Kosaka' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY❤') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CELEBRATE NITE (EURO TRANCE STYLE)' AS title, 'N.M.R.' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CELEBRATE NITE (EURO TRANCE STYLE)') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CELEBRATE NITE (EURO TRANCE STYLE)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CELEBRATE NITE (EURO TRANCE STYLE)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',8); @@ -399,14 +399,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'SUPER STAR (FROM NO INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('SUPER STAR (FROM NONSTOP MEGAMIX)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('SUPER STAR (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('SUPER STAR (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Sweet Sweet ♥ Magic' AS title, 'jun' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Sweet Sweet ♥ Magic') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ♥ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Sweet Sweet ❤ Magic' AS title, 'jun' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Sweet Sweet ❤ Magic') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',9); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Sweet Sweet ❤ Magic')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'THE REFLEX' AS title, 'DURAN DURAN' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('THE REFLEX') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('THE REFLEX') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('THE REFLEX')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',2); @@ -447,14 +447,14 @@ INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'WILD RUSH (FROM NON INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('WILD RUSH (FROM NONSTOP MEGAMIX)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('WILD RUSH (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','challenge',7); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('WILD RUSH (FROM NONSTOP MEGAMIX)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','challenge',7); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY★' AS title, 'Luv unlimited' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY★') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',8); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'CANDY★' AS title, 'Luv unlimited' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('CANDY★') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('CANDY★')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',9); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'COW GIRL' AS title, 'BAMBEE' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('COW GIRL') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('COW GIRL') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('COW GIRL')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); @@ -1503,15 +1503,15 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Matsuri JAPAN')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Matsuri JAPAN')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Matsuri JAPAN')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'MOBO★MOGA' AS title, 'Orange Lounge' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('MOBO★MOGA') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'MOBO★MOGA' AS title, 'Orange Lounge' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('MOBO★MOGA') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('MOBO★MOGA')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'STAY (Organic house Version)' AS title, 'emi' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('STAY (Organic house Version)') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('STAY (Organic house Version)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('STAY (Organic house Version)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); @@ -1595,15 +1595,15 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('The Least 100 sec')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',5); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('The Least 100 sec')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',8); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('The Least 100 sec')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',8); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, '♥LOVE2 SUGAR♥' AS title, 'dj TAKA featuring Noria' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('♥LOVE2 SUGAR♥') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('♥LOVE2 SUGAR♥')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, '❤LOVE² SUGAR❤' AS title, 'dj TAKA featuring Noria' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('❤LOVE² SUGAR❤') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',7); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('❤LOVE² SUGAR❤')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Daikenkai' AS title, 'Des-ROW feat. TSUBOI for ALPHA' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Daikenkai') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Daikenkai') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Daikenkai')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); @@ -1845,15 +1845,15 @@ INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((S INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('I Was The One')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',3); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('I Was The One')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',5); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('I Was The One')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',6); -INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'L\'amour et la liberté (DDR ver.)' AS title, 'NAOKI underground' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('L\'amour et la liberté (DDR ver.)') NOT IN ( SELECT LOWER(title) FROM songs ); -INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',8); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); -INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); +INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'L\'amour et la liberté (DDR ver.)' AS title, 'NAOKI underground' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('L\'amour et la liberté (DDR ver.)') NOT IN ( SELECT LOWER(title) FROM songs ); +INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','expert',8); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','standard',4); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','difficult',6); +INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('L\'amour et la liberté (DDR ver.)')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'double','expert',7); INSERT INTO songs SELECT nextval('songs_song_seq') AS song, 'Last Message' AS title, 'good-cool feat. Meg' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('Last Message') NOT IN ( SELECT LOWER(title) FROM songs ); INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('Last Message') ), ( SELECT machine FROM machines WHERE machinename='DDR Extreme' ); INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('Last Message')),(SELECT machine FROM machines WHERE machinename='DDR Extreme'),'single','beginner',1);