$keywords = gcms::getTags($_POST["write_keywords_{$value}"]); $description = $db->sql_trim($_POST, "write_description_{$value}"); if ($topic != '') { $save = array(); $save['topic'] = $topic; $save['keywords'] = $db->sql_clean(gcms::cutstring(preg_replace('/[\'\\"\\r\\n\\s]{1,}/isu', ' ', $keywords == '' ? gcms::getTags($_POST["write_topic_{$value}"]) : $keywords), 255)); $save['description'] = gcms::cutstring(gcms::html2txt($description == '' ? $_POST["write_detail_{$value}"] : $description), 255); $save['detail'] = gcms::ckDetail($_POST["write_detail_{$value}"]); $save['language'] = $value; $save['relate'] = $relate == '' ? $save['keywords'] : $relate; $details[$value] = $save; $alias_topic = $alias_topic == '' ? $alias : $alias_topic; } } $save = array(); $save['alias'] = gcms::aliasName($_POST['write_alias']); // id ที่แก้ไข $id = gcms::getVars($_POST, 'write_id', 0); $module_id = gcms::getVars($_POST, 'module_id', 0); if ($id > 0) { // ตรวจสอบโมดูล หรือ เรื่องที่เลือก (แก้ไข) $sql = "SELECT I.`id`,I.`module_id`,M.`module`,M.`config`,I.`picture`,I.`member_id`"; $sql .= " FROM `" . DB_MODULES . "` AS M"; $sql .= " INNER JOIN `" . DB_INDEX . "` AS I ON I.`module_id`=M.`id` AND I.`id`='{$id}' AND I.`index`='0'"; $sql .= " WHERE M.`id`='{$module_id}' AND M.`owner`='document'"; $sql .= " LIMIT 1"; } else { // ตรวจสอบโมดูล (ใหม่) $sql = "SELECT `id` AS `module_id`,`module`,`config`"; $sql .= ",(SELECT MAX(`id`)+1 FROM `" . DB_INDEX . "` WHERE `module_id`='{$module_id}') AS `id`"; $sql .= " FROM `" . DB_MODULES . "`";