sto cercando ma vedo solo questo precedentemente
$query = "SELECT title as title,"
. "\n b.start_date AS created,"
. "\n b.description as text,"
. "\n '$ItemName' as section,"
. "\n CONCAT('index.php?option=com_jcalpro&Itemid=99999999&extmode=view&extid=',extid) as href,"
. "\n b.cat as category,"
. "\n c.level as level,"
. "\n '3' as browsernav"
. "\n FROM #__jcalpro_events AS b LEFT JOIN #__jcalpro_categories AS c ON c.cat_id=b.cat"
. "\n WHERE $where"
. "\n AND approved=1";
$database->setQuery( $query );
$data = $database->loadObjectList();
foreach( $data as $item )
{
if( $levels[$item->level] <= $gids[$my->usertype] )
{
$item->created = strftime(_DATE_FORMAT_LC,strtotime($item->created));
$item->text = html_entity_decode($item->text);
$row[] = $item;
}
}
return $row;
}
?>
