joomla_test/components/com_k2/models/item.php
2020-01-02 22:20:31 +07:00

1770 lines
50 KiB
PHP

<?php
/**
* @version $Id: item.php 1994 2013-07-04 17:25:25Z lefteris.kavadas $
* @package K2
* @author JoomlaWorks http://www.joomlaworks.net
* @copyright Copyright (c) 2006 - 2013 JoomlaWorks Ltd. All rights reserved.
* @license GNU/GPL license: http://www.gnu.org/copyleft/gpl.html
*/
// no direct access
defined('_JEXEC') or die ;
jimport('joomla.application.component.model');
JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
class K2ModelItem extends K2Model
{
function getData()
{
$mainframe = JFactory::getApplication();
$id = JRequest::getInt('id');
$db = JFactory::getDBO();
$query = "SELECT * FROM #__k2_items WHERE id={$id}";
if (K2_JVERSION != '15')
{
$languageFilter = $mainframe->getLanguageFilter();
if ($languageFilter)
{
$languageTag = JFactory::getLanguage()->getTag();
$query .= " AND language IN (".$db->Quote($languageTag).",".$db->Quote('*').")";
}
}
$db->setQuery($query, 0, 1);
$row = $db->loadObject();
return $row;
}
function prepareItem($item, $view, $task)
{
jimport('joomla.filesystem.file');
JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
$limitstart = JRequest::getInt('limitstart');
$application = JFactory::getApplication();
//Initialize params
if ($view != 'item')
{
if (K2_JVERSION == '30')
{
$params = $application->getParams('com_k2');
}
else
{
$component = JComponentHelper::getComponent('com_k2');
$params = class_exists('JParameter') ? new JParameter($component->params) : new JRegistry($component->params);
$itemid = JRequest::getInt('Itemid');
if ($itemid)
{
$menu = $application->getMenu();
$menuparams = $menu->getParams($itemid);
$params->merge($menuparams);
}
}
}
else
{
$params = K2HelperUtilities::getParams('com_k2');
}
//Category
$db = JFactory::getDBO();
$category = JTable::getInstance('K2Category', 'Table');
$category->load($item->catid);
$item->category = $category;
$item->category->link = urldecode(JRoute::_(K2HelperRoute::getCategoryRoute($category->id.':'.urlencode($category->alias))));
//Read more link
$link = K2HelperRoute::getItemRoute($item->id.':'.urlencode($item->alias), $item->catid.':'.urlencode($item->category->alias));
$item->link = urldecode(JRoute::_($link));
//Print link
$item->printLink = urldecode(JRoute::_($link.'&tmpl=component&print=1'));
//Params
$cparams = class_exists('JParameter') ? new JParameter($category->params) : new JRegistry($category->params);
$iparams = class_exists('JParameter') ? new JParameter($item->params) : new JRegistry($item->params);
$item->params = version_compare(PHP_VERSION, '5.0.0', '>=') ? clone $params : $params;
if ($cparams->get('inheritFrom'))
{
$masterCategoryID = $cparams->get('inheritFrom');
$masterCategory = JTable::getInstance('K2Category', 'Table');
$masterCategory->load((int)$masterCategoryID);
$cparams = class_exists('JParameter') ? new JParameter($masterCategory->params) : new JRegistry($masterCategory->params);
}
$item->params->merge($cparams);
$item->params->merge($iparams);
//Edit link
if (K2HelperPermissions::canEditItem($item->created_by, $item->catid))
$item->editLink = JRoute::_('index.php?option=com_k2&view=item&task=edit&cid='.$item->id.'&tmpl=component');
//Tags
if (($view == 'item' && ($item->params->get('itemTags') || $item->params->get('itemRelated'))) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemTags')) || ($view == 'itemlist' && $task == 'user' && $item->params->get('userItemTags')) || ($view == 'latest' && $params->get('latestItemTags')))
{
$tags = $this->getItemTags($item->id);
for ($i = 0; $i < sizeof($tags); $i++)
{
$tags[$i]->link = JRoute::_(K2HelperRoute::getTagRoute($tags[$i]->name));
}
$item->tags = $tags;
}
//Image
$item->imageXSmall = '';
$item->imageSmall = '';
$item->imageMedium = '';
$item->imageLarge = '';
$item->imageXLarge = '';
$date = JFactory::getDate($item->modified);
$timestamp = '?t='.$date->toUnix();
if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_XS.jpg'))
{
$item->imageXSmall = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_XS.jpg';
if ($params->get('imageTimestamp'))
{
$item->imageXSmall .= $timestamp;
}
}
if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_S.jpg'))
{
$item->imageSmall = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_S.jpg';
if ($params->get('imageTimestamp'))
{
$item->imageSmall .= $timestamp;
}
}
if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_M.jpg'))
{
$item->imageMedium = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_M.jpg';
if ($params->get('imageTimestamp'))
{
$item->imageMedium .= $timestamp;
}
}
if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_L.jpg'))
{
$item->imageLarge = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_L.jpg';
if ($params->get('imageTimestamp'))
{
$item->imageLarge .= $timestamp;
}
}
if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_XL.jpg'))
{
$item->imageXLarge = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_XL.jpg';
if ($params->get('imageTimestamp'))
{
$item->imageXLarge .= $timestamp;
}
}
if (JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_Generic.jpg'))
{
$item->imageGeneric = JURI::base(true).'/media/k2/items/cache/'.md5("Image".$item->id).'_Generic.jpg';
if ($params->get('imageTimestamp'))
{
$item->imageGeneric .= $timestamp;
}
}
//Extra fields
if (($view == 'item' && $item->params->get('itemExtraFields')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemExtraFields')) || ($view == 'itemlist' && $task == 'tag' && $item->params->get('tagItemExtraFields')) || ($view == 'itemlist' && ($task == 'search' || $task == 'date') && $item->params->get('genericItemExtraFields')))
{
$item->extra_fields = $this->getItemExtraFields($item->extra_fields, $item);
}
//Attachments
if (($view == 'item' && $item->params->get('itemAttachments')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemAttachments')))
{
$item->attachments = $this->getItemAttachments($item->id);
}
//Rating
if (($view == 'item' && $item->params->get('itemRating')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemRating')))
{
$item->votingPercentage = $this->getVotesPercentage($item->id);
$item->numOfvotes = $this->getVotesNum($item->id);
}
//Filtering
if ($params->get('introTextCleanup'))
{
$filterTags = preg_split('#[,\s]+#', trim($params->get('introTextCleanupExcludeTags')));
$filterAttrs = preg_split('#[,\s]+#', trim($params->get('introTextCleanupTagAttr')));
$item->introtext = K2HelperUtilities::cleanTags($item->introtext, $filterTags);
$item->introtext = K2HelperUtilities::cleanAttributes($item->introtext, $filterTags, $filterAttrs);
}
if ($params->get('fullTextCleanup'))
{
$filterTags = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupExcludeTags')));
$filterAttrs = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupTagAttr')));
$item->fulltext = K2HelperUtilities::cleanTags($item->fulltext, $filterTags);
$item->fulltext = K2HelperUtilities::cleanAttributes($item->fulltext, $filterTags, $filterAttrs);
}
if ($item->params->get('catItemIntroTextWordLimit') && $task == 'category')
{
$item->introtext = K2HelperUtilities::wordLimit($item->introtext, $item->params->get('catItemIntroTextWordLimit'));
}
$item->cleanTitle = $item->title;
$item->title = htmlspecialchars($item->title, ENT_QUOTES);
$item->image_caption = htmlspecialchars($item->image_caption, ENT_QUOTES);
//Author
if (($view == 'item' && ($item->params->get('itemAuthorBlock') || $item->params->get('itemAuthor'))) || ($view == 'itemlist' && ($task == '' || $task == 'category') && ($item->params->get('catItemAuthorBlock') || $item->params->get('catItemAuthor'))) || ($view == 'itemlist' && $task == 'user') || ($view == 'relatedByTag'))
{
if (!empty($item->created_by_alias))
{
$item->author = new stdClass;
$item->author->name = $item->created_by_alias;
$item->author->avatar = K2HelperUtilities::getAvatar('alias');
$item->author->link = JURI::root();
}
else
{
$author = JFactory::getUser($item->created_by);
$item->author = $author;
$item->author->link = JRoute::_(K2HelperRoute::getUserRoute($item->created_by));
$item->author->profile = $this->getUserProfile($item->created_by);
$item->author->avatar = K2HelperUtilities::getAvatar($author->id, $author->email, $params->get('userImageWidth'));
}
if (!isset($item->author->profile) || is_null($item->author->profile))
{
$item->author->profile = new JObject;
$item->author->profile->gender = NULL;
}
}
//Num of comments
$user = JFactory::getUser();
if (!$user->guest && $user->id == $item->created_by && $params->get('inlineCommentsModeration'))
{
$item->numOfComments = $this->countItemComments($item->id, false);
}
else
{
$item->numOfComments = $this->countItemComments($item->id);
}
return $item;
}
function prepareFeedItem(&$item)
{
JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
$params = K2HelperUtilities::getParams('com_k2');
$limitstart = 0;
$view = JRequest::getCmd('view');
//Category
$category = JTable::getInstance('K2Category', 'Table');
$category->load($item->catid);
$item->category = $category;
//Read more link
$item->link = urldecode(JRoute::_(K2HelperRoute::getItemRoute($item->id.':'.$item->alias, $item->catid.':'.urlencode($item->category->alias))));
//Filtering
if ($params->get('introTextCleanup'))
{
$filterTags = preg_split('#[,\s]+#', trim($params->get('introTextCleanupExcludeTags')));
$filterAttrs = preg_split('#[,\s]+#', trim($params->get('introTextCleanupTagAttr')));
$filter = new JFilterInput($filterTags, $filterAttrs, 0, 1);
$item->introtext = $filter->clean($item->introtext);
}
if ($params->get('fullTextCleanup'))
{
$filterTags = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupExcludeTags')));
$filterAttrs = preg_split('#[,\s]+#', trim($params->get('fullTextCleanupTagAttr')));
$filter = new JFilterInput($filterTags, $filterAttrs, 0, 1);
$item->fulltext = $filter->clean($item->fulltext);
}
//Description
$item->description = '';
//Item image
if ($params->get('feedItemImage') && JFile::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'items'.DS.'cache'.DS.md5("Image".$item->id).'_'.$params->get('feedImgSize').'.jpg'))
{
$altText = $item->image_caption ? $item->image_caption : $item->title;
$item->description .= '<div class="K2FeedImage"><img src="'.JURI::root().'media/k2/items/cache/'.md5('Image'.$item->id).'_'.$params->get('feedImgSize').'.jpg" alt="'.$altText.'" /></div>';
}
//Item Introtext
if ($params->get('feedItemIntroText'))
{
//Introtext word limit
if ($params->get('feedTextWordLimit') && $item->introtext)
{
$item->introtext = K2HelperUtilities::wordLimit($item->introtext, $params->get('feedTextWordLimit'));
}
$item->description .= '<div class="K2FeedIntroText">'.$item->introtext.'</div>';
}
//Item Fulltext
if ($params->get('feedItemFullText') && $item->fulltext)
{
$item->description .= '<div class="K2FeedFullText">'.$item->fulltext.'</div>';
}
//Item Tags
if ($params->get('feedItemTags'))
{
$tags = $this->getItemTags($item->id);
if (count($tags))
{
$item->description .= '<div class="K2FeedTags"><ul>';
foreach ($tags as $tag)
{
$item->description .= '<li>'.$tag->name.'</li>';
}
$item->description .= '<ul></div>';
}
}
//Item Video
if ($params->get('feedItemVideo') && $item->video)
{
if (!empty($item->video) && JString::substr($item->video, 0, 1) !== '{')
{
$item->description .= '<div class="K2FeedVideo">'.$item->video.'</div>';
}
else
{
$params->set('vfolder', 'media/k2/videos');
$params->set('afolder', 'media/k2/audio');
if (JString::strpos($item->video, 'remote}'))
{
preg_match("#}(.*?){/#s", $item->video, $matches);
if (!JString::strpos($matches[1], 'http://}'))
$item->video = str_replace($matches[1], JURI::root().$matches[1], $item->video);
}
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin('content');
$item->text = $item->video;
if (K2_JVERSION == '15')
{
$dispatcher->trigger('onPrepareContent', array(
&$item,
&$params,
$limitstart
));
}
else
{
$dispatcher->trigger('onContentPrepare', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
} $item->description .= '<div class="K2FeedVideo">'.$item->text.'</div>';
}
}
//Item gallery
if ($params->get('feedItemGallery') && $item->gallery)
{
$params->set('galleries_rootfolder', 'media/k2/galleries');
$params->set('enabledownload', '0');
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin('content');
$item->text = $item->gallery;
if (K2_JVERSION == '15')
{
$dispatcher->trigger('onPrepareContent', array(
&$item,
&$params,
$limitstart
));
}
else
{
$dispatcher->trigger('onContentPrepare', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
}
$item->description .= '<div class="K2FeedGallery">'.$item->text.'</div>';
}
//Item attachments
if ($params->get('feedItemAttachments'))
{
$attachments = $this->getItemAttachments($item->id);
if (count($attachments))
{
$item->description .= '<div class="K2FeedAttachments"><ul>';
foreach ($attachments as $attachment)
{
$item->description .= '<li><a title="'.htmlentities($attachment->titleAttribute, ENT_QUOTES, 'UTF-8').'" href="'.$attachment->link.'">'.$attachment->title.'</a></li>';
}
$item->description .= '<ul></div>';
}
}
//Author
if (!empty($item->created_by_alias))
{
$item->author->name = $item->created_by_alias;
$item->author->email = '';
}
else
{
$author = JFactory::getUser($item->created_by);
$item->author = $author;
$item->author->link = JRoute::_(K2HelperRoute::getUserRoute($item->created_by));
$item->author->profile = $this->getUserProfile($item->created_by);
}
return $item;
}
function prepareJSONItem($item)
{
$row = new JObject();
unset($row->_errors);
$row->id = $item->id;
$row->title = $item->title;
$row->alias = $item->alias;
$row->link = $item->link;
$row->catid = $item->catid;
$row->introtext = $item->introtext;
$row->fulltext = $item->fulltext;
$row->extra_fields = $item->extra_fields;
$row->created = $item->created;
//$row->created_by = $item->created_by;
$row->created_by_alias = $item->created_by_alias;
$row->modified = $item->modified;
//$row->modified_by = $item->modified_by;
$row->featured = $item->featured;
//$row->ordering = $item->ordering;
//$row->featured_ordering = $item->featured_ordering;
$row->image = isset($item->image) ? $item->image : '';
$row->imageWidth = isset($item->imageWidth) ? $item->imageWidth : '';
$row->image_caption = $item->image_caption;
$row->image_credits = $item->image_credits;
$row->imageXSmall = $item->imageXSmall;
$row->imageSmall = $item->imageSmall;
$row->imageMedium = $item->imageMedium;
$row->imageLarge = $item->imageLarge;
$row->imageXLarge = $item->imageXLarge;
$row->video = $item->video;
$row->video_caption = $item->video_caption;
$row->video_credits = $item->video_credits;
$row->gallery = $item->gallery;
$row->hits = $item->hits;
//$row->plugins = $item->plugins;
$row->category = new stdClass;
$row->category->id = $item->category->id;
$row->category->name = $item->category->name;
$row->category->alias = $item->category->alias;
$row->category->link = $item->category->link;
$row->category->description = $item->category->description;
$row->category->image = $item->category->image;
$row->category->ordering = $item->category->ordering;
//$row->category->plugins = $item->category->plugins;
$row->tags = isset($item->tags) ? $item->tags : array();
$row->attachments = isset($item->attachments) ? $item->attachments : array();
$row->votingPercentage = isset($item->votingPercentage) ? $item->votingPercentage : '';
$row->numOfvotes = isset($item->numOfvotes) ? $item->numOfvotes : '';
if (isset($item->author))
{
$row->author = new stdClass;
//$row->author->id = $item->author->id;
$row->author->name = $item->author->name;
//$row->author->username = $item->author->username;
$row->author->link = $item->author->link;
$row->author->avatar = $item->author->avatar;
if (isset($item->author->profile))
{
unset($item->author->profile->plugins);
}
$row->author->profile = $item->author->profile;
if (isset($row->author->profile->url))
{
$row->author->profile->url = htmlspecialchars($row->author->profile->url, ENT_QUOTES, 'UTF-8');
}
}
$row->numOfComments = $item->numOfComments;
$row->events = $item->event;
$row->language = $item->language;
return $row;
}
function execPlugins($item, $view, $task)
{
jimport('joomla.filesystem.file');
jimport('joomla.filesystem.folder');
$params = K2HelperUtilities::getParams('com_k2');
$limitstart = JRequest::getInt('limitstart');
//Import plugins
$dispatcher = JDispatcher::getInstance();
JPluginHelper::importPlugin('content');
//Gallery
if (($view == 'item' && $item->params->get('itemImageGallery')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemImageGallery')) || ($view == 'relatedByTag'))
{
if ($item->gallery)
{
if (JString::strpos($item->gallery, 'flickr.com') === false)
{
$item->gallery = "{gallery}{$item->id}{/gallery}";
if (!JFolder::exists(JPATH_SITE.DS.'media'.DS.'k2'.DS.'galleries'.DS.$item->id))
{
$item->gallery = null;
}
}
$params->set('galleries_rootfolder', 'media/k2/galleries');
$item->text = $item->gallery;
if (K2_JVERSION == '15')
{
$dispatcher->trigger('onPrepareContent', array(
&$item,
&$params,
$limitstart
));
}
else
{
$dispatcher->trigger('onContentPrepare', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
}
$item->gallery = $item->text;
}
}
//Video
if (($view == 'item' && $item->params->get('itemVideo')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemVideo')) || ($view == 'latest' && $item->params->get('latestItemVideo')) || ($view == 'relatedByTag'))
{
if (!empty($item->video) && JString::substr($item->video, 0, 1) !== '{')
{
$item->video = $item->video;
$item->videoType = 'embedded';
}
else
{
$item->videoType = 'allvideos';
$params->set('afolder', 'media/k2/audio');
$params->set('vfolder', 'media/k2/videos');
if (JString::strpos($item->video, 'remote}'))
{
preg_match("#}(.*?){/#s", $item->video, $matches);
if (JString::substr($matches[1], 0, 7) != 'http://')
$item->video = str_replace($matches[1], JURI::root().$matches[1], $item->video);
}
if ($view == 'item')
{
$params->set('vwidth', $item->params->get('itemVideoWidth'));
$params->set('vheight', $item->params->get('itemVideoHeight'));
$params->set('autoplay', $item->params->get('itemVideoAutoPlay'));
}
else if ($view == 'latest')
{
$params->set('vwidth', $item->params->get('latestItemVideoWidth'));
$params->set('vheight', $item->params->get('latestItemVideoHeight'));
$params->set('autoplay', $item->params->get('latestItemVideoAutoPlay'));
}
else
{
$params->set('vwidth', $item->params->get('catItemVideoWidth'));
$params->set('vheight', $item->params->get('catItemVideoHeight'));
$params->set('autoplay', $item->params->get('catItemVideoAutoPlay'));
}
$item->text = $item->video;
if (K2_JVERSION == '15')
{
$dispatcher->trigger('onPrepareContent', array(
&$item,
&$params,
$limitstart
));
}
else
{
$dispatcher->trigger('onContentPrepare', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
}
$item->video = $item->text;
}
}
//Plugins
$item->text = '';
$params->set('vfolder', NULL);
$params->set('afolder', NULL);
$params->set('vwidth', NULL);
$params->set('vheight', NULL);
$params->set('autoplay', NULL);
$params->set('galleries_rootfolder', NULL);
$params->set('enabledownload', NULL);
if ($view == 'item')
{
if ($item->params->get('itemIntroText'))
$item->text .= $item->introtext;
if ($item->params->get('itemFullText'))
$item->text .= '{K2Splitter}'.$item->fulltext;
}
else
{
switch($task)
{
case '' :
case 'category' :
if ($item->params->get('catItemIntroText'))
$item->text .= $item->introtext;
break;
case 'user' :
if ($item->params->get('userItemIntroText'))
$item->text .= $item->introtext;
break;
case 'tag' :
if ($item->params->get('tagItemIntroText'))
$item->text .= $item->introtext;
break;
default :
if ($item->params->get('genericItemIntroText'))
$item->text .= $item->introtext;
break;
}
}
$item->event = new stdClass;
if (K2_JVERSION != '15')
{
$item->event->BeforeDisplay = '';
$item->event->AfterDisplay = '';
$dispatcher->trigger('onContentPrepare', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
$results = $dispatcher->trigger('onContentAfterTitle', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
$item->event->AfterDisplayTitle = trim(implode("\n", $results));
$results = $dispatcher->trigger('onContentBeforeDisplay', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
$item->event->BeforeDisplayContent = trim(implode("\n", $results));
$results = $dispatcher->trigger('onContentAfterDisplay', array(
'com_k2.'.$view,
&$item,
&$params,
$limitstart
));
$item->event->AfterDisplayContent = trim(implode("\n", $results));
}
else
{
$results = $dispatcher->trigger('onBeforeDisplay', array(
&$item,
&$params,
$limitstart
));
$item->event->BeforeDisplay = trim(implode("\n", $results));
$results = $dispatcher->trigger('onAfterDisplay', array(
&$item,
&$params,
$limitstart
));
$item->event->AfterDisplay = trim(implode("\n", $results));
$results = $dispatcher->trigger('onAfterDisplayTitle', array(
&$item,
&$params,
$limitstart
));
$item->event->AfterDisplayTitle = trim(implode("\n", $results));
$results = $dispatcher->trigger('onBeforeDisplayContent', array(
&$item,
&$params,
$limitstart
));
$item->event->BeforeDisplayContent = trim(implode("\n", $results));
$results = $dispatcher->trigger('onAfterDisplayContent', array(
&$item,
&$params,
$limitstart
));
$item->event->AfterDisplayContent = trim(implode("\n", $results));
$dispatcher->trigger('onPrepareContent', array(
&$item,
&$params,
$limitstart
));
}
//K2 plugins
$item->event->K2BeforeDisplay = '';
$item->event->K2AfterDisplay = '';
$item->event->K2AfterDisplayTitle = '';
$item->event->K2BeforeDisplayContent = '';
$item->event->K2AfterDisplayContent = '';
if (($view == 'item' && $item->params->get('itemK2Plugins')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemK2Plugins')) || ($view == 'itemlist' && $task == 'user' && $item->params->get('userItemK2Plugins')) || ($view == 'itemlist' && ($task == 'search' || $task == 'tag' || $task == 'date')))
{
JPluginHelper::importPlugin('k2');
$results = $dispatcher->trigger('onK2BeforeDisplay', array(
&$item,
&$params,
$limitstart
));
$item->event->K2BeforeDisplay = trim(implode("\n", $results));
$results = $dispatcher->trigger('onK2AfterDisplay', array(
&$item,
&$params,
$limitstart
));
$item->event->K2AfterDisplay = trim(implode("\n", $results));
$results = $dispatcher->trigger('onK2AfterDisplayTitle', array(
&$item,
&$params,
$limitstart
));
$item->event->K2AfterDisplayTitle = trim(implode("\n", $results));
$results = $dispatcher->trigger('onK2BeforeDisplayContent', array(
&$item,
&$params,
$limitstart
));
$item->event->K2BeforeDisplayContent = trim(implode("\n", $results));
$results = $dispatcher->trigger('onK2AfterDisplayContent', array(
&$item,
&$params,
$limitstart
));
$item->event->K2AfterDisplayContent = trim(implode("\n", $results));
$dispatcher->trigger('onK2PrepareContent', array(
&$item,
&$params,
$limitstart
));
}
if ($view == 'item')
{
@list($item->introtext, $item->fulltext) = explode('{K2Splitter}', $item->text);
}
else
{
$item->introtext = $item->text;
}
// Extra fields plugins
if (($view == 'item' && $item->params->get('itemExtraFields')) || ($view == 'itemlist' && ($task == '' || $task == 'category') && $item->params->get('catItemExtraFields')) || ($view == 'itemlist' && $task == 'tag' && $item->params->get('tagItemExtraFields')) || ($view == 'itemlist' && ($task == 'search' || $task == 'date') && $item->params->get('genericItemExtraFields')))
{
if (count($item->extra_fields) && is_array($item->extra_fields))
{
foreach ($item->extra_fields as $key => $extraField)
{
if ($extraField->type == 'textarea' || $extraField->type == 'textfield')
{
$tmp = new JObject();
$tmp->text = $extraField->value;
if (K2_JVERSION != '15')
{
$dispatcher->trigger('onContentPrepare', array(
'com_k2.'.$view,
&$tmp,
&$params,
$limitstart
));
}
else
{
$dispatcher->trigger('onPrepareContent', array(
&$tmp,
&$params,
$limitstart
));
}
$dispatcher->trigger('onK2PrepareContent', array(
&$tmp,
&$params,
$limitstart
));
$extraField->value = $tmp->text;
}
}
}
}
return $item;
}
function hit($id)
{
$row = JTable::getInstance('K2Item', 'Table');
$row->hit($id);
}
function vote()
{
$mainframe = JFactory::getApplication();
JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
//Get item
$item = JTable::getInstance('K2Item', 'Table');
$item->load(JRequest::getInt('itemID'));
//Get category
$category = JTable::getInstance('K2Category', 'Table');
$category->load($item->catid);
//Access check
$user = JFactory::getUser();
if (K2_JVERSION != '15')
{
if (!in_array($item->access, $user->getAuthorisedViewLevels()) || !in_array($category->access, $user->getAuthorisedViewLevels()))
{
JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
}
}
else
{
if ($item->access > $user->get('aid', 0) || $category->access > $user->get('aid', 0))
{
JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
}
}
//Published check
if (!$item->published || $item->trash)
{
JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
}
if (!$category->published || $category->trash)
{
JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
}
$rate = JRequest::getVar('user_rating', 0, '', 'int');
if ($rate >= 1 && $rate <= 5)
{
$db = JFactory::getDBO();
$userIP = $_SERVER['REMOTE_ADDR'];
$query = "SELECT * FROM #__k2_rating WHERE itemID =".(int)$item->id;
$db->setQuery($query);
$rating = $db->loadObject();
if (!$rating)
{
$query = "INSERT INTO #__k2_rating ( itemID, lastip, rating_sum, rating_count ) VALUES ( ".(int)$item->id.", ".$db->Quote($userIP).", {$rate}, 1 )";
$db->setQuery($query);
$db->query();
echo JText::_('K2_THANKS_FOR_RATING');
}
else
{
if ($userIP != ($rating->lastip))
{
$query = "UPDATE #__k2_rating"." SET rating_count = rating_count + 1, rating_sum = rating_sum + {$rate}, lastip = ".$db->Quote($userIP)." WHERE itemID = {$item->id}";
$db->setQuery($query);
$db->query();
echo JText::_('K2_THANKS_FOR_RATING');
}
else
{
echo JText::_('K2_YOU_HAVE_ALREADY_RATED_THIS_ITEM');
}
}
}
$mainframe->close();
}
function getRating($id)
{
$id = (int)$id;
static $K2RatingsInstances = array();
if (array_key_exists($id, $K2RatingsInstances))
{
return $K2RatingsInstances[$id];
}
$db = JFactory::getDBO();
$query = "SELECT * FROM #__k2_rating WHERE itemID = ".$id;
$db->setQuery($query);
$vote = $db->loadObject();
$K2RatingsInstances[$id] = $vote;
return $K2RatingsInstances[$id];
}
function getVotesNum($itemID = NULL)
{
$mainframe = JFactory::getApplication();
$user = JFactory::getUser();
$xhr = false;
if (is_null($itemID))
{
$itemID = JRequest::getInt('itemID');
$xhr = true;
}
$vote = $this->getRating($itemID);
if (!is_null($vote))
$rating_count = intval($vote->rating_count);
else
$rating_count = 0;
if ($rating_count != 1)
{
$result = "(".$rating_count." ".JText::_('K2_VOTES').")";
}
else
{
$result = "(".$rating_count." ".JText::_('K2_VOTE').")";
}
if ($xhr)
{
echo $result;
$mainframe->close();
}
else
return $result;
}
function getVotesPercentage($itemID = NULL)
{
$mainframe = JFactory::getApplication();
$user = JFactory::getUser();
$db = JFactory::getDBO();
$xhr = false;
$result = 0;
if (is_null($itemID))
{
$itemID = JRequest::getInt('itemID');
$xhr = true;
}
$vote = $this->getRating($itemID);
if (!is_null($vote) && $vote->rating_count != 0)
{
$result = number_format(intval($vote->rating_sum) / intval($vote->rating_count), 2) * 20;
}
if ($xhr)
{
echo $result;
$mainframe->close();
}
else
return $result;
}
function comment()
{
$mainframe = JFactory::getApplication();
jimport('joomla.mail.helper');
JTable::addIncludePath(JPATH_COMPONENT_ADMINISTRATOR.DS.'tables');
$params = K2HelperUtilities::getParams('com_k2');
$user = JFactory::getUser();
$config = JFactory::getConfig();
JLoader::register('Services_JSON', JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'JSON.php');
$json = new Services_JSON;
$response = new JObject();
//Get item
$item = JTable::getInstance('K2Item', 'Table');
$item->load(JRequest::getInt('itemID'));
//Get category
$category = JTable::getInstance('K2Category', 'Table');
$category->load($item->catid);
//Access check
if (K2_JVERSION != '15')
{
if (!in_array($item->access, $user->getAuthorisedViewLevels()) || !in_array($category->access, $user->getAuthorisedViewLevels()))
{
JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
}
}
else
{
if ($item->access > $user->get('aid', 0) || $category->access > $user->get('aid', 0))
{
JError::raiseError(403, JText::_('K2_ALERTNOTAUTH'));
}
}
//Published check
if (!$item->published || $item->trash)
{
JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
}
if (!$category->published || $category->trash)
{
JError::raiseError(404, JText::_('K2_ITEM_NOT_FOUND'));
}
//Check permissions
if ((($params->get('comments') == '2') && ($user->id > 0) && K2HelperPermissions::canAddComment($item->catid)) || ($params->get('comments') == '1'))
{
$row = JTable::getInstance('K2Comment', 'Table');
if (!$row->bind(JRequest::get('post')))
{
$response->message($row->getError());
echo $json->encode($response);
$mainframe->close();
}
$row->commentText = JRequest::getString('commentText', '', 'default');
$row->commentText = strip_tags($row->commentText);
//Strip a tags since all urls will be converted to links automatically on runtime.
//Additionaly strip tables to avoid layout issues.
//Also strip all attributes except src, alt and title.
//$filter = new JFilterInput(array('a', 'table'), array('src', 'alt', 'title'), 1);
//$row->commentText = $filter->clean( $row->commentText );
//Clean vars
$filter = JFilterInput::getInstance();
$row->userName = $filter->clean($row->userName, 'username');
if ($row->commentURL && preg_match('/^((http|https|ftp):\/\/)?[a-z0-9]+([\-\.]{1}[a-z0-9]+)*\.[a-z]{2,6}((:[0-9]{1,5})?\/.*)?$/i', $row->commentURL))
{
$url = preg_replace('|[^a-z0-9-~+_.?#=&;,/:]|i', '', $row->commentURL);
$url = str_replace(';//', '://', $url);
if ($url != '')
{
$url = (!strstr($url, '://')) ? 'http://'.$url : $url;
$url = preg_replace('/&([^#])(?![a-z]{2,8};)/', '&#038;$1', $url);
$row->commentURL = $url;
}
}
else
{
$row->commentURL = '';
}
$datenow = JFactory::getDate();
$row->commentDate = K2_JVERSION == '15' ? $datenow->toMySQL() : $datenow->toSql();
if (!$user->guest)
{
$row->userID = $user->id;
$row->commentEmail = $user->email;
$row->userName = $user->name;
}
$userName = trim($row->userName);
$commentEmail = trim($row->commentEmail);
$commentText = trim($row->commentText);
$commentURL = trim($row->commentURL);
if (empty($userName) || $userName == JText::_('K2_ENTER_YOUR_NAME') || empty($commentText) || $commentText == JText::_('K2_ENTER_YOUR_MESSAGE_HERE') || empty($commentEmail) || $commentEmail == JText::_('K2_ENTER_YOUR_EMAIL_ADDRESS'))
{
$response->message = JText::_('K2_YOU_NEED_TO_FILL_IN_ALL_REQUIRED_FIELDS');
echo $json->encode($response);
$mainframe->close();
}
if (!JMailHelper::isEmailAddress($commentEmail))
{
$response->message = JText::_('K2_INVALID_EMAIL_ADDRESS');
echo $json->encode($response);
$mainframe->close();
}
if ($user->guest)
{
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__users WHERE name=".$db->Quote($userName)." OR email=".$db->Quote($commentEmail);
$db->setQuery($query);
$result = $db->loadresult();
if ($result > 0)
{
$response->message = JText::_('K2_THE_NAME_OR_EMAIL_ADDRESS_YOU_TYPED_IS_ALREADY_IN_USE');
echo $json->encode($response);
$mainframe->close();
}
}
// Google reCAPTCHA
if ($params->get('antispam') == 'recaptcha' || $params->get('antispam') == 'both')
{
if ($user->guest || $params->get('recaptchaForRegistered', 1))
{
if (!function_exists('_recaptcha_qsencode'))
{
require_once (JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'recaptchalib.php');
}
$privatekey = $params->get('recaptcha_private_key');
$recaptcha_challenge_field = isset($_POST["recaptcha_challenge_field"]) ? $_POST["recaptcha_challenge_field"] : '';
$recaptcha_response_field = isset($_POST["recaptcha_response_field"]) ? $_POST["recaptcha_response_field"] : '';
$resp = recaptcha_check_answer($privatekey, $_SERVER["REMOTE_ADDR"], $recaptcha_challenge_field, $recaptcha_response_field);
if (!$resp->is_valid)
{
$response->message = JText::_('K2_THE_WORDS_YOU_TYPED_DID_NOT_MATCH_THE_ONES_DISPLAYED_PLEASE_TRY_AGAIN');
echo $json->encode($response);
$mainframe->close();
}
}
}
// Akismet
if ($params->get('antispam') == 'akismet' || $params->get('antispam') == 'both')
{
if ($user->guest || $params->get('akismetForRegistered', 1))
{
if ($params->get('akismetApiKey'))
{
require_once (JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'akismet.class.php');
$akismetApiKey = $params->get('akismetApiKey');
$akismet = new Akismet(JURI::root(false), $akismetApiKey);
$akismet->setCommentAuthor($userName);
$akismet->setCommentAuthorEmail($commentEmail);
$akismet->setCommentAuthorURL($commentURL);
$akismet->setCommentContent($commentText);
$akismet->setPermalink(JURI::root(false).'index.php?option=com_k2&view=item&id='.JRequest::getInt('itemID'));
try
{
if ($akismet->isCommentSpam())
{
$response->message = JText::_('K2_SPAM_ATTEMPT_HAS_BEEN_DETECTED_THE_COMMENT_HAS_BEEN_REJECTED');
echo $json->encode($response);
$mainframe->close();
}
}
catch(Exception $e)
{
$response->message = $e->getMessage();
echo $json->encode($response);
$mainframe->close();
}
}
}
}
if ($commentURL == JText::_('K2_ENTER_YOUR_SITE_URL') || $commentURL == "")
{
$row->commentURL = NULL;
}
else
{
if (substr($commentURL, 0, 7) != 'http://')
{
$row->commentURL = 'http://'.$commentURL;
}
}
if ($params->get('commentsPublishing'))
{
$row->published = 1;
}
else
{
$row->published = 0;
// Auto publish comments for users with administrative permissions
if (K2_JVERSION != '15')
{
if ($user->authorise('core.admin'))
{
$row->published = 1;
}
}
else
{
if ($user->gid > 23)
{
$row->published = 1;
}
}
}
if (!$row->store())
{
$response->message = $row->getError();
echo $json->encode($response);
$mainframe->close();
}
if ($row->published)
{
$caching = K2_JVERSION == '30' ? $config->get('caching') : $config->getValue('config.caching');
if ($caching && $user->guest)
{
$response->message = JText::_('K2_THANK_YOU_YOUR_COMMENT_WILL_BE_PUBLISHED_SHORTLY');
echo $json->encode($response);
}
else
{
$response->message = JText::_('K2_COMMENT_ADDED_REFRESHING_PAGE');
$response->refresh = 1;
echo $json->encode($response);
}
}
else
{
$response->message = JText::_('K2_COMMENT_ADDED_AND_WAITING_FOR_APPROVAL');
echo $json->encode($response);
}
}
$mainframe->close();
}
function getItemTags($itemID)
{
$itemID = (int)$itemID;
static $K2ItemTagsInstances = array();
if (isset($K2ItemTagsInstances[$itemID]))
{
return $K2ItemTagsInstances[$itemID];
}
$db = JFactory::getDBO();
$query = "SELECT tag.*
FROM #__k2_tags AS tag
JOIN #__k2_tags_xref AS xref ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = ".(int)$itemID." ORDER BY xref.id ASC";
$db->setQuery($query);
$rows = $db->loadObjectList();
$K2ItemTagsInstances[$itemID] = $rows;
return $K2ItemTagsInstances[$itemID];
}
function getItemExtraFields($itemExtraFields, &$item = null)
{
static $K2ItemExtraFieldsInstances = array();
if ($item && isset($K2ItemExtraFieldsInstances[$item->id]))
{
$this->buildAliasBasedExtraFields($K2ItemExtraFieldsInstances[$item->id], $item);
return $K2ItemExtraFieldsInstances[$item->id];
}
jimport('joomla.filesystem.file');
$db = JFactory::getDBO();
require_once (JPATH_ADMINISTRATOR.DS.'components'.DS.'com_k2'.DS.'lib'.DS.'JSON.php');
$json = new Services_JSON;
$jsonObjects = $json->decode($itemExtraFields);
$imgExtensions = array(
'jpg',
'jpeg',
'gif',
'png'
);
$params = K2HelperUtilities::getParams('com_k2');
if (count($jsonObjects) < 1)
{
return NULL;
}
foreach ($jsonObjects as $object)
{
$extraFieldsIDs[] = $object->id;
}
JArrayHelper::toInteger($extraFieldsIDs);
$condition = @implode(',', $extraFieldsIDs);
$query = "SELECT extraFieldsGroup FROM #__k2_categories WHERE id=".(int)$item->catid;
$db->setQuery($query);
$group = $db->loadResult();
$query = "SELECT * FROM #__k2_extra_fields WHERE `group` = ".(int)$group." AND published=1 AND (id IN ({$condition}) OR `type` = 'header') ORDER BY ordering ASC";
$db->setQuery($query);
$rows = $db->loadObjectList();
$size = count($rows);
for ($i = 0; $i < $size; $i++)
{
$value = '';
$values = array();
foreach ($jsonObjects as $object)
{
if ($rows[$i]->id == $object->id)
{
if ($rows[$i]->type == 'textfield' || $rows[$i]->type == 'textarea' || $rows[$i]->type == 'date')
{
$value = $object->value;
if ($rows[$i]->type == 'date' && $value)
{
$offset = (K2_JVERSION != '15') ? null : 0;
$value = JHTML::_('date', $value, JText::_('K2_DATE_FORMAT_LC'), $offset);
}
}
else if ($rows[$i]->type == 'image')
{
if ($object->value)
{
$src = '';
if (JString::strpos('http://', $object->value) === false)
{
$src .= JURI::root(true);
}
$src .= $object->value;
$value = '<img src="'.$src.'" alt="'.$rows[$i]->name.'" />';
}
else
{
$value = false;
}
}
else if ($rows[$i]->type == 'labels')
{
$labels = explode(',', $object->value);
if (!is_array($labels))
{
$labels = (array)$labels;
}
$value = '';
foreach ($labels as $label)
{
$label = JString::trim($label);
$label = str_replace('-', ' ', $label);
$value .= '<a href="'.JRoute::_('index.php?option=com_k2&view=itemlist&task=search&searchword='.urlencode($label)).'">'.$label.'</a> ';
}
}
else if ($rows[$i]->type == 'select' || $rows[$i]->type == 'radio')
{
foreach ($json->decode($rows[$i]->value) as $option)
{
if ($option->value == $object->value)
{
$value .= $option->name;
}
}
}
else if ($rows[$i]->type == 'multipleSelect')
{
foreach ($json->decode($rows[$i]->value) as $option)
{
if (@in_array($option->value, $object->value))
{
$values[] = $option->name;
}
}
$value = @implode(', ', $values);
}
else if ($rows[$i]->type == 'csv')
{
$array = $object->value;
if (count($array))
{
$value .= '<table cellspacing="0" cellpadding="0" class="csvTable">';
foreach ($array as $key => $row)
{
$value .= '<tr>';
foreach ($row as $cell)
{
$value .= ($key > 0) ? '<td>'.$cell.'</td>' : '<th>'.$cell.'</th>';
}
$value .= '</tr>';
}
$value .= '</table>';
}
}
else
{
switch ($object->value[2])
{
case 'same' :
default :
$attributes = '';
break;
case 'new' :
$attributes = 'target="_blank"';
break;
case 'popup' :
$attributes = 'class="classicPopup" rel="{\'x\':'.$params->get('linkPopupWidth').',\'y\':'.$params->get('linkPopupHeight').'}"';
break;
case 'lightbox' :
// Joomla! modal required
if (!defined('K2_JOOMLA_MODAL_REQUIRED'))
define('K2_JOOMLA_MODAL_REQUIRED', true);
$filename = @basename($object->value[1]);
$extension = JFile::getExt($filename);
if (!empty($extension) && in_array($extension, $imgExtensions))
{
$attributes = 'class="modal"';
}
else
{
$attributes = 'class="modal" rel="{handler:\'iframe\',size:{x:'.$params->get('linkPopupWidth').',y:'.$params->get('linkPopupHeight').'}}"';
}
break;
}
$object->value[0] = JString::trim($object->value[0]);
$object->value[1] = JString::trim($object->value[1]);
if ($object->value[1] && $object->value[1] != 'http://' && $object->value[1] != 'https://')
{
if ($object->value[0] == '')
{
$object->value[0] = $object->value[1];
}
$value = '<a href="'.$object->value[1].'" '.$attributes.'>'.$object->value[0].'</a>';
}
else
{
$value = false;
}
}
}
}
if ($rows[$i]->type == 'header')
{
$tmp = json_decode($rows[$i]->value);
if (!$tmp[0]->displayInFrontEnd)
{
$value = null;
}
else
{
$value = $tmp[0]->value;
}
}
// Detect alias
$tmpValues = $json->decode($rows[$i]->value);
if (isset($tmpValues[0]) && isset($tmpValues[0]->alias) && !empty($tmpValues[0]->alias))
{
$rows[$i]->alias = $tmpValues[0]->alias;
}
else
{
$filter = JFilterInput::getInstance();
$rows[$i]->alias = $filter->clean($rows[$i]->name, 'WORD');
if (!$rows[$i]->alias)
{
$rows[$i]->alias = 'extraField'.$rows[$i]->id;
}
}
if (JString::trim($value) != '')
{
$rows[$i]->value = $value;
if (!is_null($item))
{
if (!isset($item->extraFields))
{
$item->extraFields = new stdClass;
}
$tmpAlias = $rows[$i]->alias;
$item->extraFields->$tmpAlias = $rows[$i];
}
}
else
{
unset($rows[$i]);
}
}
if ($item)
{
$K2ItemExtraFieldsInstances[$item->id] = $rows;
}
$this->buildAliasBasedExtraFields($K2ItemExtraFieldsInstances[$item->id], $item);
return $K2ItemExtraFieldsInstances[$item->id];
}
function buildAliasBasedExtraFields($extraFields, &$item)
{
if (is_null($item))
{
return false;
}
if (!isset($item->extraFields))
{
$item->extraFields = new stdClass;
}
foreach ($extraFields as $extraField)
{
$tmpAlias = $extraField->alias;
$item->extraFields->$tmpAlias = $extraField;
}
}
function getItemAttachments($itemID)
{
$itemID = (int)$itemID;
static $K2ItemAttachmentsInstances = array();
if (isset($K2ItemAttachmentsInstances[$itemID]))
{
return $K2ItemAttachmentsInstances[$itemID];
}
$db = JFactory::getDBO();
$query = "SELECT * FROM #__k2_attachments WHERE itemID=".$itemID;
$db->setQuery($query);
$rows = $db->loadObjectList();
foreach ($rows as $row)
{
$hash = version_compare(JVERSION, '3.0', 'ge') ? JApplication::getHash($row->id) : JUtility::getHash($row->id);
$row->link = JRoute::_('index.php?option=com_k2&view=item&task=download&id='.$row->id.'_'.$hash);
}
$K2ItemAttachmentsInstances[$itemID] = $rows;
return $K2ItemAttachmentsInstances[$itemID];
}
function getItemComments($itemID, $limitstart, $limit, $published = true)
{
$params = K2HelperUtilities::getParams('com_k2');
$order = $params->get('commentsOrdering', 'DESC');
$ordering = ($order == 'DESC') ? 'DESC' : 'ASC';
$db = JFactory::getDBO();
$query = "SELECT * FROM #__k2_comments WHERE itemID=".(int)$itemID;
if ($published)
{
$query .= " AND published=1 ";
}
$query .= " ORDER BY commentDate {$ordering}";
$db->setQuery($query, $limitstart, $limit);
$rows = $db->loadObjectList();
return $rows;
}
function countItemComments($itemID, $published = true)
{
$itemID = (int)$itemID;
$index = $itemID.'_'.(int)$published;
static $K2ItemCommentsCountInstances = array();
if (isset($K2ItemCommentsCountInstances[$index]))
{
return $K2ItemCommentsCountInstances[$index];
}
$db = JFactory::getDBO();
$query = "SELECT COUNT(*) FROM #__k2_comments WHERE itemID=".$itemID;
if ($published)
{
$query .= " AND published=1 ";
}
$db->setQuery($query);
$result = $db->loadResult();
$K2ItemCommentsCountInstances[$index] = $result;
return $K2ItemCommentsCountInstances[$index];
}
function checkin()
{
$mainframe = JFactory::getApplication();
$id = JRequest::getInt('cid');
$row = JTable::getInstance('K2Item', 'Table');
$row->load($id);
$row->checkin();
$mainframe->close();
}
function getPreviousItem($id, $catid, $ordering)
{
$mainframe = JFactory::getApplication();
$user = JFactory::getUser();
$id = (int)$id;
$catid = (int)$catid;
$ordering = (int)$ordering;
$db = JFactory::getDBO();
$jnow = JFactory::getDate();
$now = K2_JVERSION == '15' ? $jnow->toMySQL() : $jnow->toSql();
$nullDate = $db->getNullDate();
if (K2_JVERSION != '15')
{
$accessCondition = ' AND access IN('.implode(',', $user->getAuthorisedViewLevels()).')';
}
else
{
$accessCondition = ' AND access <= '.$user->aid;
;
}
$languageCondition = '';
if (K2_JVERSION != '15')
{
if ($mainframe->getLanguageFilter())
{
$languageCondition = "AND language IN (".$db->quote(JFactory::getLanguage()->getTag()).",".$db->quote('*').")";
}
}
if ($ordering == "0")
{
$query = "SELECT * FROM #__k2_items WHERE id < {$id} AND catid={$catid} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering DESC";
}
else
{
$query = "SELECT * FROM #__k2_items WHERE id != {$id} AND catid={$catid} AND ordering < {$ordering} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering DESC";
}
$db->setQuery($query, 0, 1);
$row = $db->loadObject();
return $row;
}
function getNextItem($id, $catid, $ordering)
{
$mainframe = JFactory::getApplication();
$user = JFactory::getUser();
$id = (int)$id;
$catid = (int)$catid;
$ordering = (int)$ordering;
$db = JFactory::getDBO();
$jnow = JFactory::getDate();
$now = K2_JVERSION == '15' ? $jnow->toMySQL() : $jnow->toSql();
$nullDate = $db->getNullDate();
if (K2_JVERSION != '15')
{
$accessCondition = ' AND access IN('.implode(',', $user->getAuthorisedViewLevels()).')';
}
else
{
$accessCondition = ' AND access <= '.$user->aid;
;
}
$languageCondition = '';
if (K2_JVERSION != '15')
{
if ($mainframe->getLanguageFilter())
{
$languageCondition = "AND language IN (".$db->quote(JFactory::getLanguage()->getTag()).",".$db->quote('*').")";
}
}
if ($ordering == "0")
{
$query = "SELECT * FROM #__k2_items WHERE id > {$id} AND catid={$catid} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering ASC";
}
else
{
$query = "SELECT * FROM #__k2_items WHERE id != {$id} AND catid={$catid} AND ordering > {$ordering} AND published=1 AND ( publish_up = ".$db->Quote($nullDate)." OR publish_up <= ".$db->Quote($now)." ) AND ( publish_down = ".$db->Quote($nullDate)." OR publish_down >= ".$db->Quote($now)." ) {$accessCondition} AND trash=0 {$languageCondition} ORDER BY ordering ASC";
}
$db->setQuery($query, 0, 1);
$row = $db->loadObject();
return $row;
}
function getUserProfile($id = NULL)
{
$db = JFactory::getDBO();
if (is_null($id))
$id = JRequest::getInt('id');
static $K2UsersInstances = array();
if (isset($K2UsersInstances[$id]))
{
return $K2UsersInstances[$id];
}
$query = "SELECT id, gender, description, image, url, `group`, plugins FROM #__k2_users WHERE userID={$id}";
$db->setQuery($query);
$row = $db->loadObject();
$K2UsersInstances[$id] = $row;
return $row;
}
}