# Parses songlist from the DDRNO wiki
+print "begin;\n";
+
while (<>) {
m/
\| \s* \[\[ (.*?) \]\] \s* # song name
\|\| \s* \[\[ (.*?) \]\] \s* # artist
- \|\| \s* (\d+(-\d+)?) \s* # bpm
+ \|\| \s* (\d+(?:-(\d+))?) \s* # bpm
\|\| \s* (\d+) \s* # single beginner
\|\| \s* (\d+) \s* # single standard
\|\| \s* (\d+) \s* # single difficult
printf "INSERT INTO songratings (song,playmode,difficulty,feetrating) VALUES ((SELECT song FROM songs WHERE title='%s'),'%s','%s',%u);\n",
$songname, $t->[0], $t->[1], $t->[2];
}
-
}
+
+printf "commit;\n";