Hello again.
If you prefer to remove past events of Eventbooking from the sitemap you can edit the SQL query adding an additional where condition as below:
| Code: |
SELECT
`#__eb_events`.`title`,
`#__eb_events`.`id`,
`#__eb_event_categories`.`category_id` AS `catid`,
`#__eb_categories`.`name`
FROM `#__eb_events`
JOIN `#__eb_event_categories` ON `#__eb_events`.`id` = `#__eb_event_categories`.`event_id`
JOIN `#__eb_categories` ON `#__eb_event_categories`.`category_id` = `#__eb_categories`.`id`
WHERE
`#__eb_categories`.`published` = '1'
AND `#__eb_events`.`published` = '1'
AND `#__eb_events`.`access` IN {aid}
AND (`#__eb_events`.`language` = '*' OR `#__eb_events`.`language` = {langtag})
AND `#__eb_events`.`event_date` > NOW()
ORDER BY
`#__eb_categories`.`ordering` ASC,
`#__eb_events`.`ordering` ASC
|
where there is a new condition:
| Code: |
AND `#__eb_events`.`event_date` > NOW()
|
Please refer to the PDF docs about caching technologies there are detailed explanations. Only AJAX precaching requires manual refresh of the cached sitemap.
Cheers,
John
