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; }