/**
* Creates a new, empty content item to add to a node.
*
* @param vBCms_DM_Node $nodedm - The DM of the node that the content is being created for
* @return int | false - The id of the new content or false if not applicable
*/
public function createDefaultContent(vBCms_DM_Node $nodedm)
{
global $vbphrase;
require_once DIR . '/includes/functions_databuild.php';
fetch_phrase_group('cpcms');
vB::$vbulletin->input->clean_array_gpc('r', array(
'nodeid' => vB_Input::TYPE_UINT,
'parentnode' => vB_Input::TYPE_UINT,
'parentid' => vB_Input::TYPE_UINT,
'pagecontent' => vB_Input::TYPE_STR,
));
//We should have a nodeid, but a parentnode is even better.
($hook = vBulletinHook::fetch_hook($this->content_start_hook)) ? eval($hook) : false;
if ($this->parent_node)
{
$parentnode = $this->parent_node;
}
else if (vB::$vbulletin->GPC_exists['parentnode'] AND intval(vB::$vbulletin->GPC['parentnode'] ))
{
$parentnode = vB::$vbulletin->GPC['parentnode'];
}
else if (vB::$vbulletin->GPC_exists['parentid'] AND intval(vB::$vbulletin->GPC['parentid'] ))
{
$parentnode = vB::$vbulletin->GPC['parentid'];
}
else if (vB::$vbulletin->GPC_exists['nodeid'] AND intval(vB::$vbulletin->GPC['nodeid'] )
and $record = vB::$vbulletin->db->query_first("SELECT contenttypeid, nodeid, parentnode FROM " .
TABLE_PREFIX . "cms_node where nodeid = " . vB::$vbulletin->GPC['nodeid'] ))
{
$parentnode = vB_Types::instance()->getContentTypeID("vBCms_Section") == $record['contenttypeid'] ?
$record['nodeid'] : $record['parentnode'];
}
else
{
throw (new vB_Exception_Content('No valid parent node'));
}
$contenttypeid = vB_Types::instance()->getContentTypeID($this->package . '_' . $this->class);
//Verify Permissions
if (!vBCMS_Permissions::canUseHtml($parentnode, $contenttypeid, vB::$vbulletin->userinfo['userid']))
{
throw (new vB_Exception_AccessDenied());
}
$this->config = array('pagetext' => $vbphrase['pagetext_goes_here'],
'previewtext' => $vbphrase['preview_goes_here_desc']);
$nodedm->set('config', $this->config);
$nodedm->set('contenttypeid', $contenttypeid);
$nodedm->set('parentnode', $parentnode);
$nodedm->set('publicpreview', 1);
$nodedm->set('comments_enabled', 1);
$title = new vB_Phrase('vbcms', 'new_static_page');
$nodedm->set('description', $title);
$nodedm->set('title', $title);
if (!($contentid = $nodedm->save()))
{
throw (new vB_Exception_Content('Failed to create default content for contenttype ' . get_class($this)));
}
($hook = vBulletinHook::fetch_hook($this->content_end_hook)) ? eval($hook) : false;
return $contentid;
}
/**
* function to return the rendered html for this result
*
* @param string $current_user
* @param object $criteria
* @return
*/
public function render($current_user, $criteria, $template_name = '')
{
global $vbulletin;
global $show;
require_once DIR . '/vb/search/searchtools.php';
require_once DIR . "/includes/functions_user.php";
require_once DIR . "/includes/functions.php";
if (!strlen($template_name))
{
$template_name = 'vbcms_searchresult_article_general';
}
$template = vB_Template::create($template_name);
$template->register('title', vBCMS_Permissions::canUseHtml($this->record['nodeid'], vb_Types::instance()->getContentTypeId('vBCms_Article'),
$this->record['userid']) ? $this->record['title'] : htmlspecialchars_uni($this->record['title']));
$template->register('html_title', vBCMS_Permissions::canUseHtml($this->record['nodeid'], vb_Types::instance()->getContentTypeId('vBCms_Article'),
$this->record['userid']) ? $this->record['html_title'] : htmlspecialchars_uni($this->record['html_title']));
// Bug 35855: due to a different bug, 35413, users are able to save articles with
// invalid seo url aliases. this causes the getCurrentUrl to throw a vB_Exception_Router
// exception when attempting to build article URL's for search. so, to prevent
// the search from blowing up on these articles results, we will trap these exceptions,
// and generate the url without the alias in that case
try
{
$page_url = vB_Route::create('vBCms_Route_Content', $this->record['nodeid'] .
($this->record['url'] == '' ? '' : '-' . $this->record['url'] ))->getCurrentURL();
}
catch (vB_Exception_Router $e)
{
$page_url = vB_Route::create('vBCms_Route_Content', $this->record['nodeid'])->getCurrentURL();
}
$template->register('page_url', $page_url);
$this->record['page_url'] = $page_url;
try
{
$parent_url = vB_Route::create('vBCms_Route_Content', $this->record['parentid'] .
($this->record['parenttitle'] == '' ? '' : '-' . $this->record['parenttitle'] ) )->getCurrentURL();
}
catch (vB_Exception_Router $e)
{
$parent_url = vB_Route::create('vBCms_Route_Content', $this->record['parentid'])->getCurrentURL();
}
$template->register('parent_url', $parent_url);
$template->register('lastcomment_url', $page_url . "#new_comment");
$template->register('username', $this->record['username']);
$template->register('description', $this->record['description']);
$template->register('parenttitle' , htmlspecialchars_uni($this->record['parenttitle']) );
$template->register('parentid' , $this->record['parentid'] );
$template->register('threadid' , $this->record['threadid'] );
$template->register('postauthor' , $this->record['postauthor'] );
$template->register('poststarter' , $this->record['poststarter'] );
$template->register('blogpostid' , $this->record['blogpostid'] );
$template->register('parentnode' , $this->record['parentnode'] );
$template->register('postid' , $this->record['postid'] );
$template->register('post_started' , $this->record['post_started'] );
$template->register('post_posted' , $this->record['post_posted'] );
$can_use_html = vBCMS_Permissions::canUseHtml($this->record['nodeid'], vb_Types::instance()->getContentTypeId('vBCms_Article'),
$this->record['userid']) ;
$template->register('previewtext', $this->getPreviewText($this->record));
$template->register('pagetext',
$can_use_html ? fetch_censored_text($this->record['pagetext']) :
fetch_censored_text(htmlspecialchars_uni($this->record['pagetext'])));
$template->register('publish_phrase', ($this->record['publishdate'] ?
$vbphrase['page_published'] : $vbphrase['page_unpublished']) );
$template->register('author_phrase', 'author');
$template->register('published', ($this->record['publishdate'] ?
true : false));
$template->register('categories', $this->categories);
$template->register('tags', $this->tags);
$template->register('replycount', ($this->record['replycount'] ?
$this->record['replycount'] : '0'));
$template->register('article', $this->record);
$template->register('publishdate', vbdate($vbulletin->options['dateformat'], $this->record['publishdate'], true));
$template->register('publishtime', vbdate($vbulletin->options['timeformat'], $this->record['publishdate']));
$template->register('lastpostdate', vbdate($vbulletin->options['dateformat'], $this->record['lastpost'], true));
$template->register('lastpostdatetime', vbdate($vbulletin->options['timeformat'], $this->record['lastpost']));
$template->register('lastposter', $this->record['lastposter']);
$template->register('lastposterinfo', array('userid'=>$this->record['lastposterid'], 'username'=>$this->record['lastposter']));
$template->register('dateformat', $vbulletin->options['dateformat']);
$template->register('timeformat', $vbulletin->options['default_timeformat']);
$user = vB_Legacy_User::createFromId($this->record['userid']);
//get the avatar
if (intval($this->record['userid']))
{
$avatar = fetch_avatar_url($this->record['userid']);
}
if (!isset($avatar) OR (count($avatar) < 2))
{
$avatar = false;
}
$template->register('avatar', $avatar);
$result = $template->render();
return $result;
}
public function canUseHtml($userid)
{
$this->loadInfo();
return vBCMS_Permissions::canUseHtml($this->nodeid,
$this->contenttypeid, $userid);
}
/** This function gets the article information based on the defined criteria
*
* @return array
*/
protected function getContent()
{
// First, compose the sql
$sql = "SELECT article.pagetext, article.previewimage, article.imagewidth,
article.imageheight, article.previewvideo, article.htmlstate, node.url, node.publishdate, node.userid,
node.setpublish, node.publicpreview, info.title, user.username, node.showuser,
node.nodeid, node.contenttypeid, thread.replycount FROM "
. TABLE_PREFIX . "cms_article AS article INNER JOIN "
. TABLE_PREFIX . "cms_node AS node ON (node.contentid = article.contentid
AND node.contenttypeid = " . vb_Types::instance()->getContentTypeID("vBCms_Article") .
") INNER JOIN " . TABLE_PREFIX . "cms_nodeinfo AS info on info.nodeid = node.nodeid "
. ( (($this->config['categories'] != '') AND ($this->config['categories'] != '0')) ?
" INNER JOIN " . TABLE_PREFIX .
"cms_nodecategory nc ON nc.nodeid = node.nodeid " : '') . "
LEFT JOIN " . TABLE_PREFIX . "user AS user ON user.userid = node.userid
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.threadid = info.associatedthreadid
WHERE " . vBCMS_Permissions::getPermissionString() ;
if (($this->config['categories'] != '') AND ($this->config['categories'] != '0') )
{
$sql .= "\n AND nc.categoryid IN (" . $this->config['categories'] . ")\n";
}
if (($this->config['sections'] != '') AND ($this->config['sections'] != '0'))
{
$sql .= "\n AND node.parentnode IN (" . $this->config['sections'] . ")\n";
}
if (isset($this->config['days']) AND (intval($this->config['days'])) )
{
$sql .= "\n AND node.publishdate > " . (TIMENOW - (86400 * $this->config['days'])) . "\n";
}
$sql .= "\n ORDER BY node.publishdate DESC LIMIT " . $this->config['count'];
$articles = array();
//Execute
if ($rst = vB::$db->query_read($sql))
{
$current_record = array('contentid' => -1);
$contenttypeid = vb_Types::instance()->getContentTypeId($this->package . '_' . $this->view_class);
//now build the results array
$bbcode_parser = new vBCms_BBCode_HTML(vB::$vbulletin, vBCms_BBCode_HTML::fetchCmsTags());
while($article = vB::$db->fetch_array($rst))
{
$article['categories'] = array();
$article['tags'] = array();
$allow_html = vBCMS_Permissions::canUseHtml($article['nodeid'], $contenttypeid, $article['userid']);
$pagetext = $bbcode_parser->get_preview(fetch_censored_text($article['pagetext']),
vB::$vbulletin->options['default_cms_previewlength'], $allow_html);
$article['previewtext'] = strip_bbcode($pagetext);
//get the avatar
if (vB::$vbulletin->options['avatarenabled'])
{
$article['avatar'] = fetch_avatar_url($article['userid']);
}
$articles[$article['nodeid']] = $article;
}
//Let's get the tags and the categories
// we can do that with one query each.
if (count($articles))
{
//first let's get categories
$nodeids = implode(', ', array_keys($articles));
$sql = "SELECT nc.nodeid, nc.categoryid, category.category FROM " . TABLE_PREFIX . "cms_nodecategory AS nc
INNER JOIN " . TABLE_PREFIX . "cms_category AS category ON category.categoryid = nc.categoryid
WHERE nc.nodeid IN ($nodeids)";
if ($rst = vB::$db->query_read($sql))
{
while ($record = vB::$db->fetch_array($rst))
{
$route_info = $record['categoryid'] .
($record['category'] != '' ? '-' . str_replace(' ', '-', $record['category']) : '');
$record['route_info'] = $route_info;
$record['category_url'] = vB_Route::create('vBCms_Route_List', "category/" . $record['route_info'] . "/1")->getCurrentURL();
$articles[$record['nodeid']]['categories'][$record['categoryid']] = $record;
}
}
//next tags;
$sql = "SELECT tag.tagid, node.nodeid, tag.tagtext FROM " .
TABLE_PREFIX . "cms_node AS node INNER JOIN " . TABLE_PREFIX .
"tagcontent AS tc ON (tc.contentid = node.contentid AND tc.contenttypeid = node.contenttypeid)
INNER JOIN " . TABLE_PREFIX .
"tag AS tag ON tag.tagid = tc.tagid
WHERE node.nodeid IN ($nodeids) ";
if ($rst = vB::$db->query_read($sql))
{
while ($record = vB::$db->fetch_array($rst))
{
$articles[$record['nodeid']]['tags'][$record['tagid']] = $record['tagtext'];
}
}
}
}
return $articles;
}
public function getRendered($forceload = false)
{
$context = new vB_Context($this->package . '_' . $this->class . '_pagetext_' ,
array( 'nodeid' => $this->nodeid,
'permissions' => vB::$vbulletin->userinfo['permissions']['cms']));
$hashkey = strval($context);
if (!$forceload AND ($rendered = vB_Cache::instance()->read($hashkey, true, true)))
{
return $rendered;
}
$this->Load(self::INFO_CONTENT);
$bbcode_parser = new vBCms_BBCode_HTML(vB::$vbulletin, vBCms_BBCode_HTML::fetchCmsTags());
$bbcode_parser->setCanDownload($this->canDownload());
$pages = array();
// Articles will generally have an attachment but they should still keep a counter so that this query isn't always running
require_once(DIR . '/packages/vbattach/attach.php');
if ($this->canDownload())
{
$viewinfo = array();
$attach = new vB_Attach_Display_Content(vB::$vbulletin, 'vBCms_Article');
$attachments = $attach->fetch_postattach(0, $this->nodeid);
$bbcode_parser->attachments = $attachments;
$bbcode_parser->unsetattach = true;
}
$validpage = true;
$pageno = 1;
require_once DIR . '/includes/functions.php';
while($validpage)
{
$bbcode_parser->setOutputPage($pageno);
$pagetext = fetch_censored_text($bbcode_parser->do_parse(
$this->pagetext,
vBCMS_Permissions::canUseHtml($this->nodeid, $this->contenttypeid, $this->userid),
$this->htmlstate
));
$validpage = $bbcode_parser->fetchedValidPage();
if ($pageno == 1)
{
$pagelist = $bbcode_parser->getPageTitles();
}
if ($validpage)
{
$pages[$pageno] = $pagetext;
}
$pageno++;
}
if ($this->canDownload())
{
$attach->process_attachments($viewinfo, $bbcode_parser->attachments, false, false, true, false, true);
}
$rendered = array('pages' => $pages, 'attachments' => $bbcode_parser->attachments,
'viewinfo' => $viewinfo, 'pagelist' => $pagelist);
vB_Cache::instance()->write($hashkey ,
$rendered, 1440, array_merge($this->getCacheEvents(), array($this->getContentCacheEvent())));
//If we updated the page text we need to also update the preview.
$this->getPreviewText(true);
return $rendered;
}
