function miscapps_delete($miscapps_id) { global $db; $sql = "DELETE FROM miscapps WHERE miscapps_id = " . $db->escapeSimple($miscapps_id); $result = $db->query($sql); if (DB::IsError($result)) { die_freepbx($result->getMessage() . $sql); } $fc = new featurecode('miscapps', 'miscapp_' . $miscapps_id); $fc->delete(); }
<?php // Delete the old code if still there // $fcc = new featurecode('daynight', 'toggle-mode'); $fcc->delete(); unset($fcc); $list = daynight_list(); foreach ($list as $item) { $id = $item['ext']; $fcc = new featurecode('daynight', 'toggle-mode-' . $id); $fcc->delete(); unset($fcc); } sql('DROP TABLE IF EXISTS daynight');
function recordings_del($id) { $results = sql("DELETE FROM recordings WHERE id = \"{$id}\""); // delete the feature code if it existed $fcc = new featurecode('recordings', 'edit-recording-' . $id); $fcc->delete(); unset($fcc); }
/** * Update Recording by ID * @param integer $id The recording ID * @param string $name The recording short name * @param string $description The recording long name * @param string $files & separated list of files to playback * @param integer $fcode Feature Code number_format * @param string $fcode_pass Feature code password */ public function updateRecording($id, $name, $description, $files, $fcode = 0, $fcode_pass = '') { $sql = "UPDATE recordings SET displayname = ?, description = ?, filename = ?, fcode = ?, fcode_pass = ? WHERE id = ?"; $sth = $this->db->prepare($sql); $sth->execute(array($name, $description, $files, $fcode, $fcode_pass, $id)); if ($fcode != 1) { // delete the feature code if it existed // $fcc = new \featurecode('recordings', 'edit-recording-' . $id); $fcc->delete(); unset($fcc); } else { // Add the feature code if it is needed // $fcc = new \featurecode('recordings', 'edit-recording-' . $id); $fcc->setDescription("Edit Recording: {$name}"); $fcc->setDefault('*29' . $id); $fcc->setProvideDest(); $fcc->update(); unset($fcc); } needreload(); }
public function delete($miscapps_id) { $db = $this->db; $sql = "DELETE FROM miscapps WHERE miscapps_id = ?"; $q = $db->prepare($sql); $q->execute(array($miscapps_id)); if ($q) { debug('******* q was true **********'); $fc = new \featurecode('miscapps', 'miscapp_' . $miscapps_id); $fc->delete(); return true; } return false; }
public function delTimeCondition($id) { $sql = "DELETE FROM timeconditions WHERE timeconditions_id = :id"; $stmt = $this->db->prepare($sql); $fcc = new \featurecode('timeconditions', 'toggle-mode-' . $id); $fcc->delete(); unset($fcc); if ($this->astman != null) { $this->astman->database_del("TC", $id); } \FreePBX::Hooks()->processHooks($id); return $stmt->execute(array(':id' => $id)); }
function daynight_del($id) { // TODO: delete ASTDB entry when deleting the mode // $results = sql("DELETE FROM daynight WHERE ext = {$id}", "query"); $fcc = new featurecode('daynight', 'toggle-mode-' . $id); $fcc->delete(); unset($fcc); $dn = new dayNightObject($id); $dn->del(); unset($dn); }