public function remove() { global $CC_DBC; $music_dir_id = $this->getId(); $sql = "SELECT DISTINCT s.instance_id from cc_music_dirs as md LEFT JOIN cc_files as f on f.directory = md.id\n RIGHT JOIN cc_schedule as s on s.file_id = f.id WHERE md.id = {$music_dir_id}"; $show_instances = $CC_DBC->GetAll($sql); $this->_dir->delete(); foreach ($show_instances as $show_instance_row) { $temp_show = new ShowInstance($show_instance_row["instance_id"]); $temp_show->updateScheduledTime(); } RabbitMq::PushSchedule(); }