public function install() { $sql = "CREATE TABLE IF NOT EXISTS miscapps (miscapps_id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT, ext VARCHAR( 50 ) , description VARCHAR( 50 ) , dest VARCHAR( 255 ))"; $q = $this->db->prepare($sql); $q = $q->execute(); unset($sql); unset($q); //Migration... Is this still needed global $db; $results = array(); $sql = "SELECT miscapps_id, dest FROM miscapps"; $results = $db->getAll($sql, DB_FETCHMODE_ASSOC); if (!\DB::IsError($results)) { // error - table must not be there foreach ($results as $result) { $old_dest = $result['dest']; $this->id = $result['miscapps_id']; $new_dest = merge_ext_followme(trim($old_dest)); if ($new_dest != $old_dest) { $sql = "UPDATE miscapps SET dest = '{$new_dest}' WHERE miscapps_id = {$miscapps_id} AND dest = '{$old_dest}'"; $results = $db->query($sql); if (DB::IsError($results)) { die_freepbx($results->getMessage()); } } } } }
$sql = "ALTER TABLE ivr_dests ADD ivr_ret TINYINT(1) NOT NULL DEFAULT 0;"; $result = $db->query($sql); if (DB::IsError($result)) { die_freepbx($result->getDebugInfo()); } } $results = array(); $sql = "SELECT ivr_id, selection, dest FROM ivr_dests"; $results = $db->getAll($sql, DB_FETCHMODE_ASSOC); if (!DB::IsError($results)) { // error - table must not be there foreach ($results as $result) { $old_dest = $result['dest']; $ivr_id = $result['ivr_id']; $selection = $result['selection']; $new_dest = merge_ext_followme(trim($old_dest)); if ($new_dest != $old_dest) { $sql = "UPDATE ivr_dests SET dest = '{$new_dest}' WHERE ivr_id = {$ivr_id} AND selection = '{$selection}' AND dest = '{$old_dest}'"; $results = $db->query($sql); if (DB::IsError($results)) { die_freepbx($results->getMessage()); } } } } // Version 2.5.17 adds improved i and t destination handling $sql = "SELECT alt_timeout FROM ivr"; $check = $db->getRow($sql, DB_FETCHMODE_ASSOC); if (DB::IsError($check)) { // add new field $sql = "ALTER TABLE ivr ADD alt_timeout VARCHAR(8);";