/**
* this will create an array of result objects from an array of ids()
*
* @param array of integer $ids
* @return array of objects
*/
public static function create_array($ids)
{
$contenttypeid = vb_Types::instance()->getContentTypeId('vBCms_Article');
$rst = vB::$vbulletin->db->query_read($sql = "
SELECT a.contentid as itemid, a.htmlstate,
u.username, a.contentid, n.nodeid, u.userid, i.html_title, a.blogid, n.setpublish AS published,
n.url, n.showtitle, n.showuser, n.showpreviewonly,
n.showupdated, n.showviewcount, n.settingsforboth,
a.pagetext, i.title, i.description, n.publishdate, parent.title as parenttitle, i.viewcount,
n.parentnode as parentid, a.threadid, a.postauthor, a.poststarter, a.blogpostid,
a.postid, a.post_started, a.post_posted, thread.threadid AS comment_threadid , thread.title AS threadtitle, thread.replycount,
thread.lastposterid, thread.lastposter, thread.dateline, thread.views, thread.lastpost
FROM " . TABLE_PREFIX . "cms_article a
LEFT JOIN " . TABLE_PREFIX . "cms_node n ON n.contentid = a.contentid
LEFT JOIN " . TABLE_PREFIX . "cms_nodeinfo i ON i.nodeid = n.nodeid
LEFT JOIN " . TABLE_PREFIX . "cms_nodeinfo AS parent ON parent.nodeid = n.parentnode
LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON thread.threadid = i.associatedthreadid
LEFT JOIN " . TABLE_PREFIX . "user u ON u.userid = n.userid
WHERE a.contentid IN (" . implode(', ', $ids) .") AND n.contenttypeid = " . $contenttypeid
);
$id_list = array();
$items = array();
if ($rst)
{
$bbcode_parser = new vBCms_BBCode_HTML(vB::$vbulletin, vBCms_BBCode_HTML::fetchCmsTags());
$bbcode_parser->setOutputPage(1);
while ($search_result = vB::$vbulletin->db->fetch_array($rst))
{
//If unpublished we hide this.
if (!($search_result['publishdate'] < TIMENOW))
{
continue;
}
$item = new vBCms_Search_Result_Article();
$item->itemid = $search_result['itemid'];
$categories = array();
$tags = array();
$item->contenttypeid = $contenttypeid;
$search_result['pagetext'] = $bbcode_parser->do_parse($search_result['pagetext'], true);
$search_result['categories'] = $categories;
$item->record = $search_result;
$id_list[$search_result['nodeid']] = $search_result['itemid'];
$items[$search_result['itemid']] = $item;
}
//avoid database error when all cms items are filtered out.
if (!count($id_list))
{
return array();
}
$ids = implode(', ', array_keys($id_list));
$rst1 = vB::$vbulletin->db->query_read(
"SELECT cat.categoryid, cat.category, nc.nodeid FROM " .
TABLE_PREFIX . "cms_nodecategory AS nc INNER JOIN " . TABLE_PREFIX .
"cms_category AS cat ON nc.categoryid = cat.categoryid WHERE nc.nodeid IN ($ids)"
);
if ($rst1)
{
$route = new vBCms_Route_List();
$route->setParameter('action', 'list');
while($record = vB::$vbulletin->db->fetch_array($rst1))
{
$itemid = $id_list[$record['nodeid']];
$route_info = $record['categoryid'] .
($record['category'] != '' ? '-' . $record['category'] : '');
$record['category_url'] = vBCms_Route_List::getUrl(array('type' =>'category',
'value' => $route_info , 'page' => 1));
$items[$itemid]->addCategory($record['categoryid'], $record) ;
}
}
if ($rst1 = vB::$vbulletin->db->query_read("SELECT tag.tagid, tag.tagtext, node.contentid 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 ($ids) " ))
{
while($record = vB::$vbulletin->db->fetch_array($rst1))
{
$items[$record['contentid']]->addTag($record['tagid'], $record);
}
}
return $items;
}
return false;
}
