/**
* Trash old topics in this category. Changes topic state to deleted.
*
* @param $time
* @param array $params
* @param int $limit
*
* @return int Number of trashed topics.
*/
public function trash($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} AND tt.hold!=2 {$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::trash($ids);
KunenaUserHelper::recount();
KunenaForumCategoryHelper::recount($this->id);
return $count;
}
