Example #1
0
     $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 . "`";