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}'";