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); }