/**
* Purge old topics from this category. Removes topics from the database.
*
* @param $time
* @param array $params
* @param int $limit
*
* @return int Number of purged topics.
*/
public function purge($time, $params = array(), $limit = 1000)
{
// FIXME: why time isn't used?
if (!$this->exists()) {
return 0;
}
$where = isset($params['where']) ? (string) $params['where'] : '';
$db = JFactory::getDBO();
$query = "SELECT id FROM #__kunena_topics AS tt WHERE tt.category_id={$this->id} {$where} ORDER BY tt.last_post_time ASC";
$db->setQuery($query, 0, $limit);
$ids = $db->loadColumn();
KunenaError::checkDatabaseError();
if (empty($ids)) {
return 0;
}
$count = KunenaForumTopicHelper::delete($ids);
KunenaUserHelper::recount();
KunenaForumCategoryHelper::recount($this->id);
KunenaAttachmentHelper::cleanup();
return $count;
}