function showtrashview($option)
{
$kunena_app =& JFactory::getApplication();
$kunena_db =& JFactory::getDBO();
$filter_order = $kunena_app->getUserStateFromRequest($option . 'filter_order', 'filter_order', 'subject', 'cmd');
$filter_order_Dir = $kunena_app->getUserStateFromRequest($option . 'filter_order_Dir', 'filter_order_Dir', 'asc', 'word');
$search = $kunena_app->getUserStateFromRequest($option . 'search', 'search', '', 'string');
$search = JString::strtolower($search);
$order = JRequest::getVar('order', '');
$limit = $kunena_app->getUserStateFromRequest("global.list.limit", 'limit', $kunena_app->getCfg('list_limit'), 'int');
$limitstart = $kunena_app->getUserStateFromRequest("{$option}.limitstart", 'limitstart', 0, 'int');
$kunena_db->setQuery("SELECT COUNT(*) FROM #__kunena_messages WHERE hold=2");
$total = $kunena_db->loadResult();
if (KunenaError::checkDatabaseError()) {
return;
}
if ($limitstart >= $total) {
$limitstart = 0;
}
if ($limit == 0 || $limit > 100) {
$limit = 100;
}
$where = ' WHERE hold=2 ';
if ($search) {
$where .= ' AND LOWER( a.subject ) LIKE ' . $kunena_db->Quote('%' . $kunena_db->getEscaped($search, true) . '%', false) . ' OR LOWER( c.username )LIKE ' . $kunena_db->Quote('%' . $kunena_db->getEscaped($search, true) . '%', false) . ' OR a.thread LIKE ' . $kunena_db->Quote('%' . $kunena_db->getEscaped($search, true) . '%', false);
}
$orderby = ' ORDER BY ' . $filter_order . ' ' . $filter_order_Dir;
$query = 'SELECT a.*, b.name AS cats_name, c.username FROM #__kunena_messages AS a
INNER JOIN #__kunena_categories AS b ON a.catid=b.id
LEFT JOIN #__users AS c ON a.userid=c.id' . $where . $orderby;
$kunena_db->setQuery($query, $limitstart, $limit);
$trashitems = $kunena_db->loadObjectList();
if (KunenaError::checkDatabaseError()) {
return;
}
// table ordering
$lists['order_Dir'] = $filter_order_Dir;
$lists['order'] = $filter_order;
jimport('joomla.html.pagination');
$pageNavSP = new JPagination($total, $limitstart, $limit);
$lists['search'] = $search;
html_Kunena::showtrashview($option, $trashitems, $pageNavSP, $lists);
}
