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!'); ?>
getDefaultPages(); foreach ($pages as $page) { $sel=false; if($ids && in_array($row['id'], $ids)) $sel=true; $inuse = ($page->topics || in_array($page->id, $defaultPages)); ?>
  href="pages.php?&sort=name"> href="pages.php?&sort=type"> href="pages.php?&sort=status"> href="pages.php?&sort=created"> href="pages.php?&sort=updated">
>  getLocalName() ?: $page->getName()); ?> type; ?>  isActive()?__('Active'):''.__('Disabled').''; ?>   '.__('(in-use)').'':''; ?>  created); ?>  updated); ?>
        
 '.__('Page').':'.$pageNav->getPageLinks().' '; ?>