Hi, on another component (SP page Builder addon modalpopup) I need to retrieve extrafields from a single K2 item. The code I write works fine on my local xampp environment but on the live web a 500 server error occurs when executing item->extra_fields = $model->getItemExtraFields($item->extra_fields, $item);
Am I using the correct syntax?
<?php
defined ('_JEXEC') or die ('Restricted access');
require_once(JPATH_SITE.'/components/com_k2/helpers/route.php');
require_once(JPATH_SITE.'/components/com_k2/helpers/utilities.php');
class SppagebuilderAddonModal extends SppagebuilderAddons{
public function render() {
$settings = $this->addon->settings;
$class = (isset($settings->class) && $settings->class) ? $settings->class : '';
...
$itemid = (isset($settings->modal_item_id) && $settings->modal_item_id) ? $settings->modal_item_id : '';
if (!$itemid == '') {
$db = JFactory::getDbo();
$query = "SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM #__k2_items as i
LEFT JOIN #__k2_categories c ON c.id = i.catid
WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0
AND i.id=$itemid";
$db->setQuery($query);
$items = $db->loadObjectList();
// Render the query results
$model = K2Model::getInstance('Item', 'K2Model');
(array) $v = array();
if(count($items)) {
foreach($items as $item) {
...
$v["title"] = $item->title;
...
$item->extra_fields = $model->getItemExtraFields($item->extra_fields, $item);
...
}
}
...
Best regards
Roland
Am I using the correct syntax?
<?php
defined ('_JEXEC') or die ('Restricted access');
require_once(JPATH_SITE.'/components/com_k2/helpers/route.php');
require_once(JPATH_SITE.'/components/com_k2/helpers/utilities.php');
class SppagebuilderAddonModal extends SppagebuilderAddons{
public function render() {
$settings = $this->addon->settings;
$class = (isset($settings->class) && $settings->class) ? $settings->class : '';
...
$itemid = (isset($settings->modal_item_id) && $settings->modal_item_id) ? $settings->modal_item_id : '';
if (!$itemid == '') {
$db = JFactory::getDbo();
$query = "SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM #__k2_items as i
LEFT JOIN #__k2_categories c ON c.id = i.catid
WHERE i.published = 1 AND i.access IN(1,1,5) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1,5) AND c.trash = 0
AND i.id=$itemid";
$db->setQuery($query);
$items = $db->loadObjectList();
// Render the query results
$model = K2Model::getInstance('Item', 'K2Model');
(array) $v = array();
if(count($items)) {
foreach($items as $item) {
...
$v["title"] = $item->title;
...
$item->extra_fields = $model->getItemExtraFields($item->extra_fields, $item);
...
}
}
...
Best regards
Roland