From 8ac6eb68670cae63b150f5e10ad52f6cdbf2733f Mon Sep 17 00:00:00 2001 From: "Steinar H. Gunderson" Date: Fri, 18 Feb 2005 16:26:56 +0000 Subject: [PATCH] Make the DDRFreak parse script also add the songs to machinesongs. --- parse/parse-ddrfreak-songlist.pl | 2 ++ 1 file changed, 2 insertions(+) diff --git a/parse/parse-ddrfreak-songlist.pl b/parse/parse-ddrfreak-songlist.pl index 9e404cf..a880275 100644 --- a/parse/parse-ddrfreak-songlist.pl +++ b/parse/parse-ddrfreak-songlist.pl @@ -92,6 +92,8 @@ while (<>) { # 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", $songname, $artist, $songname; + printf "INSERT INTO machinesongs SELECT ( SELECT song FROM songs WHERE title='%s' ), ( SELECT machine FROM machines WHERE machinename='%s' );\n", + $songname, $machine; for my $t (['single', 'beginner', $sb], ['single', 'standard', $ss], -- 2.39.2