isAdmin()) die('Access Denied'); $pages = Page::objects() ->filter(array('type__in'=>array('other','landing','thank-you','offline'))) ->annotate(array('topics'=>SqlAggregate::COUNT('topics'))); $qs = array(); $sortOptions=array( 'name'=>'name', 'status'=>'isactive', 'created'=>'created', 'updated'=>'updated', 'type'=>'type'); $orderWays=array('DESC'=>'-','ASC'=>''); $sort=($_REQUEST['sort'] && $sortOptions[strtolower($_REQUEST['sort'])])?strtolower($_REQUEST['sort']):'name'; //Sorting options... if($sort && $sortOptions[$sort]) { $pages = $pages->order_by( $orderWays[strtoupper($_REQUEST['order'])] ?: '' . $sortOptions[$sort]); } $x=$sort.'_sort'; $$x=' class="'.strtolower($order).'" '; $total = $pages->count(); $page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1; $pageNav=new Pagenate($total, $page, PAGE_LIMIT); $qstr = '&'. Http::build_query($qs); $qstr .= '&order='.($order=='DESC' ? 'ASC' : 'DESC'); $qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']); $pageNav->setURL('pages.php', $qs); //Ok..lets roll...create the actual query if ($total) $showing=$pageNav->showing().' '._N('site page','site pages', $num); else $showing=__('No pages found!'); ?>