public function del_from_track($track)
{
$result = DigiplayDB::delete("audioartists", "audioid = " . $track->get_id() . " AND artistid = " . $this->id);
$remaining = DigiplayDB::select("* FROM audioartists WHERE artistid = " . $this->id . ";");
if (!$remaining) {
$result = DigiplayDB::delete("artists", "id = " . $this->id);
}
return (bool) $result;
}
public function del_from_track($track)
{
$result = DigiplayDB::delete("audiokeywords", "audioid = " . $track->get_id() . " AND keywordid = " . $this->id);
$remaining = DigiplayDB::select("* FROM audiokeywords WHERE keywordid = " . $this->id);
if (!$remaining) {
DigiplayDB::delete("keywords", "id = " . $this->id);
}
return $result;
}
if (Session::is_group_user("Music Admin")) {
$track_id = (int) $_REQUEST["id"];
$track = Audio::get_by_id($track_id);
$md5 = $track->get_md5();
$archive = $track->get_archive();
$dir = $archive->get_localpath();
$folder = $md5[0];
$files = array(0 => ".flac", 1 => ".xml");
$tables = array(0 => 'audioartists', 1 => 'audiocomments', 2 => 'audiodir', 3 => 'audiogroups', 4 => 'audiojinglepkgs', 5 => 'audiokeywords', 6 => 'audioplaylists', 7 => 'audiousers');
$wherepre = "audioid = " . $track_id;
$where = pg_escape_string($wherepre);
$track_id_escaped = pg_escape_string($track_id);
DigiplayDB::delete('audio', "id = " . $track_id_escaped);
foreach ($tables as $table) {
DigiplayDB::delete($table, $where);
}
foreach ($files as $file) {
$path = $dir . "/" . $folder . "/" . $md5 . $file;
$cmd = "rm " . $path;
shell_exec($cmd);
}
if (Errors::occured()) {
http_response_code(400);
exit(json_encode(array("error" => "Something went wrong. You may have discovered a bug!", "detail" => Errors::report("array"))));
Errors::clear();
} else {
exit(json_encode(array('response' => 'success', 'id' => 1)));
}
} else {
http_response_code(403);
public function delete()
{
return DigiplayDB::delete("showitems", "id = " . $this->id);
}
public function delete()
{
return DigiplayDB::delete("info_faults", "id = " . $this->id);
}
public function del_track($track)
{
return DigiplayDB::delete("audioplaylists", "audioid = " . $track->get_id() . " AND playlistid = " . $this->id);
}
public function move_to_music_folder()
{
DigiplayDB::delete("audiodir", "audioid = " . $this->id);
return DigiplayDB::insert("audiodir", array("dirid" => 2, "audioid" => $this->id));
}
public function delete_jingle($jingle)
{
return DigiplayDB::delete('audiojinglepkgs', 'audioid = \'' . $jingle->get_id() . '\' AND jinglepkgid = \'' . $this->id . '\'');
}
public function delete()
{
return DigiplayDB::delete("groups", "id = '" . $this->id . "'");
}
public function delete()
{
return DigiplayDB::delete("requests", "id = " . $this->id);
}
