rendered paste body<?phpglobal $db;global $amp_conf;$sql = "CREATE TABLE IF NOT EXISTS announcement ( announcement_id integer NOT NULL PRIMARY KEY" . ( (($amp_conf["AMPDBENGINE"] == "sqlite") || ($amp_conf["AMPDBENGINE"] == "sqlite3")) ? "AUTOINCREMENT":"AUTO_INCREMENT") ." description VARCHAR( 50 ) , recording VARCHAR( 255 ) , allow_skip INT, post_dest VARCHAR( 255 ) , return_ivr TINYINT(1) NOT NULL DEFAULT 0, noanswer TINYINT(1) NOT NULL DEFAULT 0, repeat VARCHAR(2) NOT NULL DEFAULT '')";// Version 0.3 adds auto-return to IVR$sql = "SELECT return_ivr FROM announcement";$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);if(DB::IsError($check)) { // add new field $sql = "ALTER TABLE announcement ADD return_ivr TINYINT(1) NOT NULL DEFAULT 0;"; $result = $db->query($sql); if(DB::IsError($result)) { die($result->getDebugInfo()); }}// Version 0.4 adds auto-return to IVR$sql = "SELECT noanswer FROM announcement";$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);if(DB::IsError($check)) { // add new field $sql = "ALTER TABLE announcement ADD noanswer TINYINT(1) NOT NULL DEFAULT 0;"; $result = $db->query($sql); if(DB::IsError($result)) { die($result->getDebugInfo()); }}// Version 0.6 adds repeat$sql = "SELECT repeat FROM announcement";$check = $db->getRow($sql, DB_FETCHMODE_ASSOC);if(DB::IsError($check)) { // add new field $sql = "ALTER TABLE announcement ADD `repeat` VARCHAR(2) NOT NULL DEFAULT '';"; $result = $db->query($sql); if(DB::IsError($result)) { die($result->getDebugInfo()); }}?>