Thanks vbgamer45 for the update. I have to do it manually though. What are the database changes for the attachments?
Oh, and where does it call the attachment in the view function???
function ViewArticle()
{
global $txt, $context, $user_info, $scripturl, $smcFunc, $mbname, $user_info;
// Check if the current user can view the articles list
isAllowedTo('view_articles');
$m_cats = allowedTo('articles_admin');
$context['m_cats'] = $m_cats;
if (!isset($_REQUEST['article']))
fatal_error($txt['smfarticles_noarticleselected']);
$article = (int) $_REQUEST['article'];
if ($context['user']['is_guest'])
$groupid = -1;
else
$groupid = $user_info['groups'][0];
// Show the articles in that category
$dbresult = $smcFunc['db_query']('', "
SELECT
a.ID_ARTICLE, a.title, a.date, p.view, a.approved, a.rating, a.totalratings, m.real_name, a.ID_MEMBER,
a.description, a.views, a.commenttotal, a.ID_CAT
FROM {db_prefix}articles AS a
LEFT JOIN {db_prefix}members AS m ON (a.ID_MEMBER = m.ID_MEMBER)
LEFT JOIN {db_prefix}articles_catperm AS p ON (p.ID_GROUP = $groupid AND a.ID_CAT = p.ID_CAT)
WHERE a.ID_ARTICLE = $article LIMIT 1");
$row = $smcFunc['db_fetch_assoc']($dbresult);
$context['article'] = $row;
$smcFunc['db_free_result']($dbresult);
// Check Approval
if ($row['approved'] == 0 && $m_cats == false && $row['ID_MEMBER'] != $user_info['id'])
fatal_error($txt['smfarticles_err_articlenotapproved'],false);
// Check if article is allowed to be viewed
if ($row['view'] == '0' && ($m_cats == false && $row['ID_MEMBER'] != $user_info['id']))
fatal_error($txt['smfarticles_perm_no_view_article'],false);
$addarticle = allowedTo('add_articles');
// MyArticles
if ($addarticle && !($context['user']['is_guest']))
$context['articles']['buttons']['mylisting'] = array(
'text' => 'smfarticles_myarticles',
'url' =>$scripturl . '?action=articles;sa=myarticles;u=' . $user_info['id'],
'lang' => true,
);
// Search
$context['articles']['buttons']['search'] = array(
'text' => 'smfarticles_search',
'url' => $scripturl . '?action=articles;sa=search',
'lang' => true,
);
// View Article Buttons
// Edit Article
if ($m_cats == true || $row['ID_MEMBER'] == $user_info['id'])
$context['articles']['view_article']['edit'] = array(
'text' => 'smfarticles_txtedit3',
'url' =>$scripturl . '?action=articles;sa=editarticle&id=' . $article,
'lang' => true,
);
// Delete Article
if ($m_cats == true || $row['ID_MEMBER'] == $user_info['id'])
$context['articles']['view_article']['delete'] = array(
'text' => 'smfarticles_txtdel3',
'url' => $scripturl . '?action=articles;sa=deletearticle&id=' . $article,
'lang' => true,
);
// Link Tree
$context['linktree'][] = array(
'url' => $scripturl . '?action=articles',
'name' => $txt['smfarticles_title']
);
GetParentLink($context['article']['ID_CAT']);
$dbresult = $smcFunc['db_query']('', "
SELECT
pagetext
FROM {db_prefix}articles_page
WHERE ID_ARTICLE = $article LIMIT 1");
$row2 = $smcFunc['db_fetch_assoc']($dbresult);
$context['article_page'] = $row2;
$smcFunc['db_free_result']($dbresult);
// Display all user comments
$dbresult = $smcFunc['db_query']('', "
SELECT
c.ID_ARTICLE, c.ID_COMMENT, c.date, c.comment, c.ID_MEMBER, c.lastmodified,
c.modified_ID_MEMBER, m.posts, m.real_name, c.approved
FROM ({db_prefix}articles_comment as c)
LEFT JOIN {db_prefix}members AS m ON (c.ID_MEMBER = m.ID_MEMBER)
WHERE c.ID_ARTICLE = " . $context['article']['ID_ARTICLE'] . " AND c.approved = 1 ORDER BY c.ID_COMMENT DESC");
$comment_count = $smcFunc['db_affected_rows']();
$context['article_comments'] = array();
while($row3 = $smcFunc['db_fetch_assoc']($dbresult))
$context['article_comments'][] = $row3;
$smcFunc['db_free_result']($dbresult);
$context['article_comment_count'] = $comment_count;
// Update Views
$dbresult = $smcFunc['db_query']('', "UPDATE {db_prefix}articles
SET views = views + 1 WHERE ID_ARTICLE = $article LIMIT 1");
$context['page_title'] = $mbname . ' - ' . $txt['smfarticles_title'] . ' - ' . $row['title'];
$context['sub_template'] = 'viewarticle';
}
