function featurecodes_delFeatureCode($modulename, $featurename) { $s = "DELETE "; $s .= "FROM featurecodes "; $s .= "WHERE modulename = " . sql_formattext($modulename) . " "; $s .= "AND featurename = " . sql_formattext($featurename); sql($s, 'query'); return true; }
function customappsreg_customextens_edit($old_custom_exten, $custom_exten, $description, $notes) { global $db; $sql = "UPDATE custom_extensions SET " . "custom_exten = " . sql_formattext($custom_exten) . ", " . "description = " . sql_formattext($description) . ", " . "notes = " . sql_formattext($notes) . " " . "WHERE custom_exten = " . sql_formattext($old_custom_exten); $result = $db->query($sql); if (DB::IsError($result)) { die_freepbx($result->getMessage() . $sql); } }
function tts_update($p_id, $p_name, $p_text, $p_goto, $p_engine) { $results = sql("UPDATE tts SET name=" . sql_formattext($p_name) . ", text=" . sql_formattext($p_text) . ", goto=" . sql_formattext($p_goto) . ", engine=" . sql_formattext($p_engine) . " WHERE id=" . $p_id); }
/** * Deletes the feature code from the system * * @return bool True if it's deleted */ function delete() { $s = "DELETE "; $s .= "FROM featurecodes "; $s .= "WHERE modulename = " . sql_formattext($this->_modulename) . " "; $s .= "AND featurename = " . sql_formattext($this->_featurename); sql($s, 'query'); $this->_enabled = -1; // = not ready return true; }
function addextensions($addarray) { global $db; $sql = "INSERT INTO extensions (context, extension, priority, application, args, descr, flags) VALUES ('" . $addarray[0] . "', '" . $addarray[1] . "', '" . $addarray[2] . "', '" . $addarray[3] . "', '" . $addarray[4] . "', " . sql_formattext($addarray[5]) . " , '" . $addarray[6] . "')"; $result = $db->query($sql); if (DB::IsError($result)) { die($result->getMessage() . $sql); } return $result; }
function miscdests_update($id, $description, $destdial) { $results = sql("UPDATE miscdests SET description = " . sql_formattext($description) . ", destdial = " . sql_formattext($destdial) . " WHERE id = " . $id); }