Map - Events Current and Future - Not Past

It does not make sense to display past events on the maps. Is there a way of only showing current and future events on the world map?

No response! Does this mean that we are stuck with a nonsensical function?

Alright, I have investigated this problem and have a suggestion.

The issue appears that the map table contains records that are out of date. Therefore, it should be a simple matter to remove those redundant records without deleting the associated events.

I have constructed a SQL query to display the redundant map records:

SELECT *
FROM `bx_wmap_locations`
INNER JOIN `bx_events_main` ON bx_wmap_locations.id = bx_events_main.ID
AND bx_events_main.EventEnd < UNIX_TIMESTAMP( )
WHERE `part` = 'events'
ORDER BY bx_events_main.EventEnd

However, I am neither good or confident with SQL and therefore do not know what the command line is to delete the redundant records.

Can someone post the SQL statement to delete the redundant map records and will this work?

Found the fix:

DELETE FROM l1 USING bx_wmap_locations l1 INNER JOIN `bx_events_main`
ON l1.id=bx_events_main.ID
AND bx_events_main.EventEnd < UNIX_TIMESTAMP()
AND l1.part = 'events'

I agree it does not make much sense to have past events on the World Map.

Just spreading some love your way to let you know you're not alone with this feature request.

More thoughts on this issue. If the SQL could be embedded into a PHP script then it could be easily run every month. However, clearing the CACHE afterwards is essential.