public function deleteOldEvents() { $db = JFactory::getDBO(); // Load all events happening now or before now $query = 'SELECT `id`' . ' FROM #__acctexp_event' . ' WHERE `due_date` <= \'' . date('Y-m-d H:i:s', (int) gmdate('U')) . '\'' . ' AND `status` = \'waiting\''; $db->setQuery($query); $events = xJ::getDBArray($db); // Call each event individually foreach ($events as $evid) { $event = new aecEvent(); $event->load($evid); $event->trigger(); } }