if (!$USER || !isOfficer($USER)) {
die("UNAUTHORIZED");
}
if ($action == "add") {
$query = "insert into `song` (`choir`, `title`, `info`) values ('{$CHOIR}', '{$title}', '{$info}')";
if (mysql_query($query)) {
echo mysql_insert_id();
} else {
echo mysql_error();
}
} else {
if ($action == "delete") {
$query = "select `id` from `songLink` where `song` = '{$id}'";
$sql = mysql_query($query);
while ($result = mysql_fetch_array($sql)) {
repertoire_delfile($result[0]) || die("NODEL");
}
$query = "delete from `song` where `id` = '{$id}'";
if (mysql_query($query)) {
echo "OK";
} else {
echo mysql_error();
}
} else {
if ($action == "update") {
$query = "update `song` set `title` = '{$title}', `info` = '{$info}' where `id` = '{$id}'";
if (mysql_query($query)) {
echo "OK";
} else {
echo mysql_error();
}
}
$query = "update `songLink` set `target` = '{$name}' where `id` = '{$id}'";
if (mysql_query($query)) {
echo "OK {$musicdir}/{$name}";
} else {
die("FAIL");
}
} else {
if ($action == "rmfile") {
if (!repertoire_delfile($id)) {
die("NODEL");
}
echo "OK";
} else {
if ($action == "delete") {
if (!repertoire_delfile($id)) {
die("NODEL");
}
// Remove associated file
$query = "delete from `songLink` where `id` = '{$id}'";
if (mysql_query($query)) {
echo "OK";
} else {
die("FAIL");
}
} else {
if ($action == "update") {
$query = "select `type` from `songLink` where `id` = '{$id}'";
$result = mysql_fetch_array(mysql_query($query));
$type = $result[0];
$query = "select `storage` from `mediaType` where `typeid` = '{$type}'";
