query("SELECT * FROM ".$_SESSION['tablename']['mlb_doctype_ext']." WHERE type_id = ?", array($_SESSION['m_admin']['doctypes']['TYPE_ID'])); if($stmt->rowCount() == 0) { $_SESSION['m_admin']['doctypes']['process_delay'] = 21; $_SESSION['m_admin']['doctypes']['delay1'] = 14; $_SESSION['m_admin']['doctypes']['delay2'] = 1; } else { $line = $stmt->fetchObject(); $_SESSION['m_admin']['doctypes']['process_delay'] = $line->process_delay; $_SESSION['m_admin']['doctypes']['delay1'] = $line->delay1; $_SESSION['m_admin']['doctypes']['delay2'] = $line->delay2; } } elseif($_SESSION['service_tag'] == 'doctype_add') { $_SESSION['m_admin']['doctypes']['process_delay'] = 21; $_SESSION['m_admin']['doctypes']['delay1'] = 14; $_SESSION['m_admin']['doctypes']['delay2'] = 1; } elseif($_SESSION['service_tag'] == 'frm_doctype') { $func = new functions(); ?>
= 0) { $_SESSION['m_admin']['doctypes']['process_delay'] = $func->wash($_REQUEST['process_delay'], "num", _PROCESS_DELAY); } if(isset($_REQUEST['delay1']) && $_REQUEST['delay1'] >= 0) { $_SESSION['m_admin']['doctypes']['delay1'] = $func->wash($_REQUEST['delay1'], "num", _ALERT_DELAY_1); } if(isset($_REQUEST['delay2']) && $_REQUEST['delay2'] >= 0) { $_SESSION['m_admin']['doctypes']['delay2'] = $func->wash($_REQUEST['delay2'], "num", _ALERT_DELAY_2); } } elseif($_SESSION['service_tag'] == "doctype_updatedb") { $db = new Database(); $stmt = $db->query("SELECT type_id FROM ".$_SESSION['tablename']['mlb_doctype_ext']." WHERE type_id = ?", array($_SESSION['m_admin']['doctypes']['TYPE_ID'])); if($stmt->rowCount() > 0) { $db->query("UPDATE ".$_SESSION['tablename']['mlb_doctype_ext']." SET process_delay = ?, delay1 = ?, delay2 = ? WHERE type_id = ?", array($_SESSION['m_admin']['doctypes']['process_delay'], $_SESSION['m_admin']['doctypes']['delay1'], $_SESSION['m_admin']['doctypes']['delay2'], $_SESSION['m_admin']['doctypes']['TYPE_ID'])); } else { $db->query("INSERT INTO ".$_SESSION['tablename']['mlb_doctype_ext']." (type_id, process_delay, delay1, delay2) VALUES (?, ?, ?, ?)", array($_SESSION['m_admin']['doctypes']['TYPE_ID'], $_SESSION['m_admin']['doctypes']['process_delay'], $_SESSION['m_admin']['doctypes']['delay1'], $_SESSION['m_admin']['doctypes']['delay2'])); } } elseif($_SESSION['service_tag'] == "doctype_insertdb") { $db = new Database(); $db->query("INSERT INTO ".$_SESSION['tablename']['mlb_doctype_ext']." (type_id, process_delay, delay1, delay2) VALUES (?, ?, ?, ?)", array($_SESSION['m_admin']['doctypes']['TYPE_ID'], $_SESSION['m_admin']['doctypes']['process_delay'], $_SESSION['m_admin']['doctypes']['delay1'], $_SESSION['m_admin']['doctypes']['delay2'])); } elseif($_SESSION['service_tag'] == "doctype_delete") { $db = new Database(); $db->query("DELETE FROM ".$_SESSION['tablename']['mlb_doctype_ext']." WHERE type_id = ?", array($_SESSION['m_admin']['doctypes']['TYPE_ID'])); }