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);";
