function prepare_hoidap_record(&$row_news, $type_image = 'mobile')
{
if (isset($row_news['que_title']) && $row_news['que_title']) {
$row_news['que_title'] = htmlspecialbo($row_news['que_title']);
}
if (isset($row_news['que_image']) && $row_news['que_image']) {
$row_news['que_image_low'] = get_picture_path($row_news['que_image'], $type_image . '_low');
$row_news['que_image'] = get_picture_path($row_news['que_image'], $type_image);
}
if (isset($row_news['que_question_content']) && $row_news['que_question_content']) {
$row_news['full_question_content'] = $row_news['que_question_content'];
$row_news['que_question_content'] = removeHTML($row_news['que_question_content']);
$row_news['que_question_content'] = cut_string($row_news['que_question_content'], 50);
}
if (isset($row_news['que_date']) && $row_news['que_date']) {
$row_news['post_time'] = date('d/m/Y | H:i', $row_news['que_date']);
}
$row_news['link_detail'] = generate_hoidap_detail($row_news);
return $row_news;
}
require 'config.php';
$lastmod_first = date('Y-m-d') . 'T00:00:00+07:00';
$page = getValue('page');
$limit = 10000;
ob_clean();
header('Content-Type: text/xml');
echo '<?xml version="1.0" encoding="UTF-8" ?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:image="http://www.google.com/schemas/sitemap-image/1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd" xmlns:xhtml="http://www.w3.org/1999/xhtml">';
$db = new db_query('SELECT *
FROM questions
LEFT JOIN categories ON cat_id = que_cat_id
WHERE que_type = 0 AND que_status = 1
LIMIT ' . $page * $limit . ',' . $limit);
while ($row = mysqli_fetch_assoc($db->result)) {
$link_detail = generate_hoidap_detail($row);
?>
<url>
<loc><?php
echo DOMAIN_URL . $link_detail;
?>
</loc>
<?php
/*
<xhtml:link rel="alternate" media="only screen and max-width: 480px" href="http://m.24h.com.vn/" />
*/
?>
<lastmod><?php
echo $lastmod_first;
?>
</lastmod>
function get_question_relate($rrrrrr, $yyy, $ssssss, $tttttt)
{
if (!$rrrrrr) {
return array();
}
$rrrrrr = explode(',', $rrrrrr);
$uuuuuu = array();
$vvvvvv = array();
foreach ($rrrrrr as $wwwwww) {
$ll = new db_query('SELECT que_id,que_title,que_date,cat_name
FROM questions
LEFT JOIN categories ON que_cat_id = cat_id
WHERE que_cat_id = ' . $tttttt . ' AND que_tags LIKE "%' . $wwwwww . '%" AND que_id <> ' . $ssssss . '
ORDER BY que_date DESC
LIMIT 20');
while ($ooooo = mysqli_fetch_assoc($ll->result)) {
$ooooo['que_title'] = htmlspecialbo($ooooo['que_title']);
$ooooo['que_date'] = date('d/m', $ooooo['que_date']);
$ooooo['link_detail'] = generate_hoidap_detail($ooooo);
$uuuuuu[] = $ooooo;
$vvvvvv[] = $ooooo['que_id'];
}
}
$uuuuuu = array_unique($uuuuuu);
$vvvvvv = array_unique($vvvvvv);
shuffle($uuuuuu);
$uuuuuu = array_slice($uuuuuu, 0, $yyy);
shuffle($vvvvvv);
$vvvvvv = array_slice($vvvvvv, 0, $yyy);
if ($vvvvvv) {
$vvvvvv = implode(',', $vvvvvv);
} else {
$vvvvvv = '';
}
$xxxxxx = new db_execute('UPDATE questions SET que_relate = "' . $vvvvvv . '" WHERE que_id = ' . $ssssss);
unset($xxxxxx);
return $uuuuuu;
}
WHERE que_cat_id = ' . $detail_data['cat_id'] . '
AND que_status = 1 AND que_type = 0
AND que_id <> ' . $detail_data['que_id'] . '
ORDER BY que_date DESC
LIMIT 0,4');
while ($row = mysqli_fetch_assoc($db_query->result)) {
$row['cat_name'] = $detail_data['cat_name'];
$row['que_title'] = htmlspecialbo($row['que_title']);
$row['que_date'] = date('H:i - d/m/Y', $row['que_date']);
$row['link_detail'] = generate_hoidap_detail($row);
$list_question_cat[] = $row;
}
$rainTpl->assign('list_question_cat', $list_question_cat);
//câu hỏi liên quan
$array_question_relate = array();
if ($detail_data['que_relate']) {
//nếu đã có trong relate thì lấy ra
$db_relate = new db_query('SELECT que_id, que_title, cat_name, que_date
FROM questions
LEFT JOIN categories ON cat_id = que_cat_id
WHERE que_id IN(' . $detail_data['que_relate'] . ')');
while ($row = mysqli_fetch_assoc($db_relate->result)) {
$row['que_title'] = htmlspecialbo($row['que_title']);
$row['que_date'] = date('d/m', $row['que_date']);
$row['link_detail'] = generate_hoidap_detail($row);
$array_question_relate[] = $row;
}
} else {
$array_question_relate = get_question_relate($detail_data['que_tags'], 5, $detail_data['que_id'], $detail_data['cat_id']);
}
$rainTpl->assign('array_question_relate', $array_question_relate);
$rainTpl->assign('css_global', $css_global);
$rainTpl->assign('js_global', $js_global);
$rainTpl->assign('list_categories', $list_category);
include_once '../includes/hoidap/inc_hoidap_detail.php';
if (isset($detail_data['que_title']) && $detail_data['que_title']) {
$page_title = t($detail_data['que_title'] . ' | Chuyên mục hỏi đáp');
} else {
$page_title = t('Trang hỏi đáp, tư vấn khám chữa bệnh miễn phí');
}
$rainTpl->assign('page_title', $page_title);
$og_url = DOMAIN_URL . generate_hoidap_detail($detail_data);
$rainTpl->assign('og_url', $og_url);
//so sánh link với link được request
$check_link_redirect = $_SERVER['REQUEST_URI'] == generate_hoidap_detail($detail_data);
if (!$check_link_redirect) {
move301(generate_hoidap_detail($detail_data));
}
$meta_description = cut_string($detail_data['que_question_content'], 200);
$rainTpl->assign('meta_description', $meta_description);
$meta_keyword = '';
$rainTpl->assign('meta_keyword', $meta_keyword);
$facebook_og = '<meta property="og:title" content="' . htmlspecialbo($detail_data['que_title']) . '"/>
<meta property="fb:app_id" content="1561038610796934" />
<meta property="fb:profile_id" content="1508569846068761" />
<meta property="og:type" content="article" />
<meta property="og:determiner" content="auto" />
<meta property="article:section" content="' . htmlspecialbo($detail_data['cat_name']) . '" />
<meta property="article:publisher" content="https://www.facebook.com/suckhoeankhang" />
<meta property="article:published_time" content="' . $datetime_facebook . '" />
<meta property="og:url" content="' . $og_url . '" />
<meta property="og:image" content="' . $detail_data['que_image'] . '"/>
function get_question_relate($tag_string, $number, $question_origin, $question_category)
{
if (!$tag_string) {
return array();
}
$tag_string = explode(',', $tag_string);
$array_question = array();
$array_id = array();
foreach ($tag_string as $tag_keyword) {
$db_query = new db_query('SELECT que_id,que_title,que_date,cat_name
FROM questions
LEFT JOIN categories ON que_cat_id = cat_id
WHERE que_cat_id = ' . $question_category . ' AND que_tags LIKE "%' . $tag_keyword . '%" AND que_id <> ' . $question_origin . '
ORDER BY que_date DESC
LIMIT 20');
while ($row = mysqli_fetch_assoc($db_query->result)) {
$row['que_title'] = htmlspecialbo($row['que_title']);
$row['que_date'] = date('d/m', $row['que_date']);
$row['link_detail'] = generate_hoidap_detail($row);
$array_question[] = $row;
$array_id[] = $row['que_id'];
}
}
$array_question = array_unique($array_question);
$array_id = array_unique($array_id);
shuffle($array_question);
$array_question = array_slice($array_question, 0, $number);
shuffle($array_id);
$array_id = array_slice($array_id, 0, $number);
//update vào bảng news
if ($array_id) {
$array_id = implode(',', $array_id);
} else {
$array_id = '';
}
$db_update = new db_execute('UPDATE questions SET que_relate = "' . $array_id . '" WHERE que_id = ' . $question_origin);
unset($db_update);
return $array_question;
}
