Make the DDRFreak parser script case insensitive with regard to previous songs (most...

[ccbs] / parse / parse-ddrfreak-songlist.pl

diff --git a/parse/parse-ddrfreak-songlist.pl b/parse/parse-ddrfreak-songlist.pl
index a880275b6f13a9022ebaba1b2568d0a005709580..c2fc231d05fc324368bbf6f73ad3a9e7b2ee7eb5 100644 (file)
--- a/parse/parse-ddrfreak-songlist.pl
+++ b/parse/parse-ddrfreak-songlist.pl
@@ -90,9 +90,9 @@ while (<>) {
        $artist =~ s/'/\\'/g;
 
        # Insert the song only if it doesn't already exist
-       printf "INSERT INTO songs SELECT nextval('songs_song_seq') AS song, '%s' AS title, '%s' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE '%s' NOT IN ( SELECT title FROM songs );\n",
+       printf "INSERT INTO songs SELECT nextval('songs_song_seq') AS song, '%s' AS title, '%s' AS artist, 0 AS minbpm, 0 AS maxbpm WHERE LOWER('%s') NOT IN ( SELECT LOWER(title) FROM songs );\n",
                $songname, $artist, $songname;
-       printf "INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE title='%s' ), ( SELECT machine FROM machines WHERE machinename='%s' );\n",
+       printf "INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE LOWER(title)=LOWER('%s') ), ( SELECT machine FROM machines WHERE machinename='%s' );\n",
                $songname, $machine;
        
        for my $t (['single', 'beginner', $sb],
@@ -105,7 +105,7 @@ while (<>) {
                    ['double', 'expert', $de],
                    ['double', 'challenge', $dc]) {
                next if (!defined($t->[2]) || $t->[2] eq '');
-               printf "INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='%s'),(SELECT machine FROM machines WHERE machinename='%s'),'%s','%s',%u);\n",
+               printf "INSERT INTO songratings (song,machine,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE LOWER(title)=LOWER('%s')),(SELECT machine FROM machines WHERE machinename='%s'),'%s','%s',%u);\n",
                        $songname, $machine, $t->[0], $t->[1], $t->[2];
        }
 }