$article['content'] = $article['description'];
}
}
$articledb[$article['articleid']] = $article;
}
unset($article);
$DB->free_result($query);
//设置一个时间戳,一定时间内该时间戳有效.用于COOKIE防盗链
scookie('viewarticle', $timestamp);
$metadb = array();
if ($aids) {
$query = $DB->query("SELECT m.mid, m.name, m.slug, m.type, r.cid FROM {$db_prefix}metas m\r\n\t\t\tINNER JOIN {$db_prefix}relationships r ON r.mid = m.mid\r\n\t\t\tWHERE m.type IN ('category', 'tag') AND r.cid IN ({$aids})\r\n\t\t\tORDER BY m.displayorder ASC, m.mid DESC");
while ($meta = $DB->fetch_array($query)) {
if ($meta['type'] == 'tag') {
$meta['url'] = gettaglink($meta['slug']);
$articledb[$meta['cid']]['content'] = highlight_tag($articledb[$meta['cid']]['content'], $meta['name']);
} else {
$meta['url'] = getcatelink($meta['mid'], $meta['slug']);
}
$metadb[$meta['cid']][$meta['type']][] = $meta;
}
unset($meta);
$DB->free_result($query);
if ($haveattach) {
require_once SABLOG_ROOT . 'include/func/attachment.func.php';
$attachdb = array();
$query = $DB->query("SELECT attachmentid, articleid, dateline, filename, filetype, filesize, downloads, filepath, thumb_filepath, thumb_width, thumb_height, isimage FROM {$db_prefix}attachments WHERE articleid IN ({$aids}) ORDER BY attachmentid");
$size = explode('x', strtolower($options['attachments_thumbs_size']));
while ($attach = $DB->fetch_array($query)) {
$attach['filesize'] = sizecount($attach['filesize']);
$attach['dateline'] = sadate('Y-m-d H:i', $attach['dateline']);
$article['avatardb'] = get_avatar($article['email']);
//设置连接
$article['url'] = getpermalink($article['articleid'], $article['alias']);
$article['userurl'] = getuserlink($article['username']);
//隐藏变量,默认模板用不着,方便那些做模板可以单独显示月份和号数的的朋友.
$article['month'] = sadate('M', $article['dateline']);
$article['day'] = sadate('d', $article['dateline']);
$article['dateline'] = sadate($options['article_timeformat'], $article['dateline'], 1);
// 获取文章的关联信息
$metadb = array();
$query = $DB->query("SELECT m.mid, m.name, m.slug, m.type, r.cid FROM {$db_prefix}metas m\r\n\tINNER JOIN {$db_prefix}relationships r ON r.mid = m.mid\r\n\tWHERE m.type IN ('category', 'tag') AND r.cid='" . $article['articleid'] . "'\r\n\tORDER BY m.displayorder ASC, m.mid DESC");
$article['keywords'] = $comma = '';
while ($meta = $DB->fetch_array($query)) {
if ($meta['type'] == 'tag') {
$meta['url'] = gettaglink($meta['slug']);
$article['content'] = highlight_tag($article['content'], $meta['name']);
} else {
$meta['url'] = getcatelink($meta['mid'], $meta['slug']);
}
$article['keywords'] .= $comma . $meta['name'];
$metadb[$article['articleid']][$meta['type']][] = $meta;
$comma = ',';
}
$DB->free_result($query);
if ($_POST['readpassword'] && $article['readpassword'] == sax_addslashes($_POST['readpassword'])) {
scookie('readpassword_' . $article['articleid'], sax_addslashes($_POST['readpassword']), 2592000);
//一个月
}
//设置文章的分类名、作者、TAG、标题成为meta\title信息
if (!$article['keywords']) {
$tmp = $comma = '';
