Hi Houston
To do this modification, you will need to know Joomla, PHP programming. If not, then you will need to find someone to help you. The steps are :
1. Open the file modules/mod_eb_events/mod_eb_events.php, find the code below :
Code:
$sql = 'SELECT a.id, a.event_capacity, a.title, a.location_id, a.event_date, IFNULL(SUM(b.number_registrants), 0) AS total_registrants, c.name AS location_name FROM #__eb_events AS a '
. ' LEFT JOIN #__eb_registrants as b '
. ' ON (a.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" AND b.published != 2))) '
. ' LEFT JOIN #__eb_locations AS c '
. ' ON a.location_id = c.id '
. ' WHERE '.implode(' AND ', $where)
. ' GROUP BY a.id '
. ' HAVING (a.event_capacity = 0 OR (total_registrants < a.event_capacity)) '
. ' ORDER BY a.event_date '
. ' LIMIT '.$numberEvents
;
2. Change it to :
Code:
$sql = 'SELECT a.id, a.event_capacity, a.title, a.location_id, a.event_date, a.event_end_date, IFNULL(SUM(b.number_registrants), 0) AS total_registrants, c.name AS location_name FROM #__eb_events AS a '
. ' LEFT JOIN #__eb_registrants as b '
. ' ON (a.id = b.event_id AND b.group_id=0 AND (b.published = 1 OR (b.payment_method LIKE "os_offline%" AND b.published != 2))) '
. ' LEFT JOIN #__eb_locations AS c '
. ' ON a.location_id = c.id '
. ' WHERE '.implode(' AND ', $where)
. ' GROUP BY a.id '
. ' HAVING (a.event_capacity = 0 OR (total_registrants < a.event_capacity)) '
. ' ORDER BY a.event_date '
. ' LIMIT '.$numberEvents
;
3. In the file modules/mod_eb_events/tmpl/default.php, you can use the code below to display event end date :
Code:
<?php echo JHTML::_('date', $row->event_end_date, $config->event_date_format, $format); ?>
PS : Code modification is not in scope of support, so if you want to do other modifications, maybe you will need to find someone to help you. We might not be able to support you with other modifications (if needed).
Regards,
Tuan
