$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 = '';