case 8:
$slen = parse_int32($data, $lastlen) * 2;
$lastlen += 4;
$skillsdata['linhas'][$l][$i] = parse_string($data, $lastlen, $slen);
$lastlen += $slen;
break;
case 9:
$skillsdata['linhas'][$l][$i] = parse_int32($data, $lastlen);
$lastlen += 4;
break;
case 11:
$skillsdata['linhas'][$l][$i] = parse_int64($data, $lastlen);
$lastlen += 8;
break;
case 12:
$skillsdata['linhas'][$l][$i] = parse_int($data, $lastlen);
$lastlen += 1;
break;
}
}
}
fclose($fio);
unlink($uploadfile);
}
$table = strtok($filename, ".");
$query = "DROP TABLE IF EXISTS `{$table}`;\n";
$query .= "CREATE TABLE `{$table}` (\n";
for ($i = 0; $i < $skillsdata['total_colunas']; $i++) {
switch ($skillsdata['colunas'][$i]['tipo']) {
case 1:
$query .= "\t`{$skillsdata['colunas'][$i]['nome']}` INT NOT NULL DEFAULT '0'";
die("Usage: {$argv['0']} --episode=episode_number --title=track_title --artist=track_artist --album=track_album --comments=track_comments --genre=track_genre --drafts-folder=/path/to/drafts/output/folder/ --audio-filename==/path/to/audio/input/filename.(mp3|m4a) --audio-folder=/path/to/audio/output/folder/ --audio-prefix=prefix_of_new_audio_filename\n\n");
}
if (!file_exists($options['audio-filename'])) {
die("Audio file at {$options['audio-filename']} doesn’t exist.\n");
}
$file_extension = pathinfo($options['audio-filename'], PATHINFO_EXTENSION);
if (!($file_extension == "mp3" || $file_extension == "m4a")) {
die("Only M4A and MP3 files are supported. {$options['audio-filename']} doesn’t seem to be one.\n");
}
if (!file_exists($options['drafts-folder'])) {
die("Drafts output folder at {$options['drafts-folder']} doesn’t exist.\n");
}
if (!file_exists($options['audio-folder'])) {
die("Audio output folder at {$options['audio-folder']} doesn’t exist.\n");
}
$episode = parse_int($options['episode']);
$track_filename = $options['audio-prefix'] . '-' . $episode . '.' . $file_extension;
$track_full_filename = $options['audio-folder'] . $track_filename;
if (file_exists($track_full_filename)) {
die("Audio file at output folder already exist. Won’t overwrite.\n");
}
if (!copy($options['audio-filename'], $track_full_filename)) {
die("Couldn’t copy audio file {$options['audio-filename']} to audio output folder {$options['audio-folder']}.\n");
} else {
unlink($options['audio-filename']);
}
$post_filename = date('Y-m-d') . '-episode-' . $episode . '.markdown';
$post_full_filename = $options['drafts-folder'] . $post_filename;
if ($file_extension == "mp3") {
$get_id3 = new getID3();
$get_id3->setOption(array('encoding' => 'UTF-8'));
