@`/usr/bin/osascript /Applications/.SqlTunes/Interfaces/iTunes.Interface.app {$i} 2>&1 /dev/null`; // Load the iTunes dump, dump the load read if we are logging it $iTunesTrack->setData(getDump($credentials["Log"])); switch ($credentials["Log"]) { case "Debug": wlog($iTunesTrack->debug(), false, false); case "Verbose": printf("\n%06.2f%% %6d %6d | %s - %s", $i / $tracks * 100, $i, $iTunesTrack->getDatabaseID(), $iTunesTrack->getArtist(), $iTunesTrack->getTrackName()); wlog($i . " " . $iTunesTrack->getDatabaseID() . " " . $iTunesTrack->getArtist() . " - " . $iTunesTrack->getTrackName(), false, false); break; case "Normal": printf("\n%06.2f%% %s - %s", $i / $tracks * 100, $iTunesTrack->getArtist(), $iTunesTrack->getTrackName()); break; } // perform non-fatal query on MySql DB query($iTunesTrack->getQuery(), false); } // log the summary stats $processTime = time() - $startTime; wlog($tracks . " processed, total processing time: " . $processTime . " seconds. Processing rate: " . round($tracks / $processTime, 2) . " songs/sec.", false, false); // close dump file fclose($log); // cleanup clean(); // Function: getDump // Requires: string - log level; only "Debug" level makes it log any output (sliently) // Returns: array of key => value pairs // Purpose: Parses loaded file into an array of key => value pairs containing data function getDump($log) { $file = loadtrack();