Comment admin listing controller 24 march 2011: cleaned up 25 march 2011: rewrote to use DAO 29 march 2011: now using getTotal */ // TODO: Consider making a separate admin page for comment sections (i.e., each URL that has a comment plugin) // TODO: Do it by adding filters at the top //$comments = Comment::DAOFactory(); $comments = new Model_Comment(); if (defined('COMMENTS_REQUIRE_APPROVAL')) { $pm->setVariable('comments_require_approval', COMMENTS_REQUIRE_APPROVAL); if (COMMENTS_REQUIRE_APPROVAL) { $comments->where('approved = 0'); $pm->setVariable('totalpending', $comments->getTotal()); //$comments->resetSelect(); $comments = new Model_Comment(); } } if (isset($_REQUEST['show']) && 'unapproved' == $_REQUEST['show']) { $comments->where('approved = 0'); } if (isset($_REQUEST['application'])) { $comments->select()->where('#__page.application = ?', $_REQUEST['application']); } $total = $comments->getTotal(); $comments->order('datecreated DESC'); $comments->setPagination(isset($_REQUEST['page']) ? $_REQUEST['page'] : 1); $pm->setVariable('comments', $comments); $page = !empty($_REQUEST['page']) ? $_REQUEST['page'] : 1; Pagination::Calculate($total, 20, $page);