SimpleCalendar - display category in module

Question

I am configuring the simplecalendar module in Joomla 3.2.2 Wich seems not to be capable of displaying the category of an event in the module?

In the backend there is a line loading different parameters of an event like:

{START_DATE}: {NAME}

I already tryed {CATEGORY}, {CATNAME}, {CAT} and some more, but none of them do the trick. When trying {CATEGORY} it even gives me an output, but it just says "Error!", even though all events are in some sort of category.

I did search for a solution on the developers site, but the contact and the forum seem to be dead.

Answer 1

I don't know if this is the correct way but it works for me.

In the helper.php located in modules/mod_simplecalendar, add the following:

$query->select('c.title AS category');

// Load the permissions functions
$user = JFactory::getUser(); 
$user_levels = implode(',', array_unique($user->getAuthorisedViewLevels()));
$params->get( 'count', '2' );

$query = $db->getQuery(true);

$query->select('a.*');
$query->select('CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(\':\', a.id, a.alias) ELSE a.id END AS slug');
$query->select('CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(\':\', c.id, c.alias) ELSE c.id END AS catslug');
$query->from('#__simplecalendar AS a');
$query->select('c.title AS category');
$query->join('LEFT', '#__categories AS c on c.id = a.catid');       
$query->where("( $where ) AND a.state = 1");        
$query->where('a.access IN ('.$user_levels.') AND c.access IN ( '. $user_levels .')');      

if ( $catid[0] != 0 || $categories == '' )      
{
    $query->where( $categories);
}