$error = false;
$tab = false;
// details
$details = array();
$alias_topic = '';
foreach ($config['languages'] as $value) {
$topic = $db->sql_trim_str($_POST, "write_topic_{$value}");
$alias = gcms::aliasName($_POST["write_topic_{$value}"]);
$relate = $db->sql_trim($_POST, "write_relate_{$value}");
$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`";
// modules/event/admin_write_save.php
header("content-type: text/html; charset=UTF-8");
// inint
include '../../bin/inint.php';
$ret = array();
// ตรวจสอบ referer และ สมาชิก
if (gcms::isReferer() && gcms::canConfig($config, 'event_can_write')) {
if (isset($_SESSION['login']['account']) && $_SESSION['login']['account'] == 'demo') {
$ret['error'] = 'EX_MODE_ERROR';
} else {
// ค่าที่ส่งมา
$save['topic'] = gcms::getTags($_POST['write_topic']);
$keywords = gcms::getTags($_POST['write_keywords']);
$save['keywords'] = $db->sql_clean(gcms::cutstring(preg_replace('/[\'\\"\\r\\n\\s]{1,}/isu', ' ', $keywords == '' ? $save['topic'] : $keywords), 149));
$description = trim(gcms::getVars($_POST, 'write_description', ''));
$save['description'] = $db->sql_trim_str(gcms::cutstring(gcms::html2txt($description == '' ? $_POST['write_detail'] : $description), 149));
$save['detail'] = gcms::ckDetail($_POST['write_detail']);
$save['published_date'] = $db->sql_trim_str($_POST, 'write_published_date');
$save['published'] = $_POST['write_published'] == '1' ? '1' : '0';
$save['begin_date'] = "{$_POST['write_d']} {$_POST['write_h']}:{$_POST['write_m']}:00";
$save['color'] = $db->sql_trim_str($_POST, 'write_color');
$id = gcms::getVars($_POST, 'write_id', 0);
if ($id > 0) {
// ตรวจสอบโมดูล หรือ เรื่องที่เลือก (แก้ไข)
$sql = "SELECT I.`module_id`,M.`module`";
$sql .= " FROM `" . DB_EVENTCALENDAR . "` AS I";
$sql .= " INNER JOIN `" . DB_MODULES . "` AS M ON M.`owner`='event' AND M.`id`=I.`module_id`";
$sql .= " WHERE I.`id`='{$id}'";
$sql .= " LIMIT 1";
} else {
// ตรวจสอบโมดูล (ใหม่)
}
foreach ($words as $a => $word) {
if (mb_stripos($item['topic'], $word) !== false) {
$v = $v + (90 - $a);
}
if (mb_stripos($item['detail'], $word) !== false) {
$v = $v + (85 - $a);
}
}
$search_result[$i]['id'] = $item['id'];
$search_result[$i]['category_id'] = gcms::getVars($item, 'category_id', 0);
$search_result[$i]['topic'] = $item['topic'];
$search_result[$i]['alias'] = $item['alias'];
$search_result[$i]['index'] = $item['index'];
if ($item['description'] == '') {
$search_result[$i]['detail'] = gcms::cutstring(gcms::html2txt($item['detail']), 149);
} else {
$search_result[$i]['detail'] = $item['description'];
}
$search_result[$i]['module'] = $item['module'];
$search_result[$i]['owner'] = $item['owner'];
$search_result[$i]['value'] = $v * ($item['level'] + $item['index']);
}
if (sizeof($search_result) > 0) {
// เรียงลำดับผลลัพท์ตาม score
gcms::sortby($search_result, 'value', false);
// จัดรูปแบบข้อความ
$searchitem = gcms::loadtemplate('search', 'search', 'searchitem');
$match = array('/{URL}/', '/{TOPIC}/', '/{DETAIL}/', '/{LINK}/');
foreach ($search_result as $item) {
unset($data);
<?php
// modules/gallery/feed.php
if (isset($modules)) {
// ค่าที่ีส่งมา
$aid = gcms::getVars($_GET, 'album', 0);
// query
$sql = "SELECT C.`id`,C.`topic`,C.`detail`,C.`last_update`,G.`image` FROM `" . DB_GALLERY . "` AS G";
$sql .= " INNER JOIN `" . DB_GALLERY_ALBUM . "` AS C ON C.`module_id`='{$modules['id']}' AND C.`id`=G.`album_id`";
$sql .= " WHERE G.`module_id`='{$modules['id']}'";
if ($aid == -1) {
$sql .= " AND G.`count`='0'";
} elseif ($aid > 0) {
$sql .= " AND G.`album_id`={$aid}";
}
$sql .= ' ORDER BY ' . (isset($_GET['rnd']) ? 'RAND()' : 'G.`id` DESC');
$sql .= " LIMIT {$count}";
foreach ($db->customQuery($sql) as $item) {
$link = gcms::getURL($modules['module'], '', 0, 0, "id={$item['id']}");
echo '<item>';
echo '<title>' . $item['topic'] . '</title>';
echo '<link>' . $link . '</link>';
echo '<description><![CDATA[' . gcms::cutstring(gcms::html2txt($item['detail']), 50) . ']]></description>';
echo '<enclosure url="' . urldecode(DATA_URL . "gallery/{$item['id']}/thumb_{$item['image']}") . '" type="image/jpeg"></enclosure>';
echo '<guid isPermaLink="true">' . $link . '</guid>';
echo '<pubDate>' . date("D, d M Y H:M", $item['last_update']) . ':00 +0700</pubDate>';
echo '</item>';
}
}
