isAdmin() || !$filter) die('Access Denied'); $qs = array(); $select='SELECT rule.* '; $from='FROM '.FILTER_RULE_TABLE.' rule '; $where='WHERE rule.filter_id='.db_input($filter->getId()); $search=false; if($_REQUEST['q'] && strlen($_REQUEST['q'])>3) { $search=true; if(strpos($_REQUEST['q'],'@') && Validator::is_email($_REQUEST['q'])) $where.=' AND rule.val='.db_input($_REQUEST['q']); else $where.=' AND rule.val LIKE "%'.db_input($_REQUEST['q'],false).'%"'; }elseif($_REQUEST['q']) { $errors['q']=__('Term too short!'); } $sortOptions=array('email'=>'rule.val','status'=>'isactive','created'=>'rule.created','created'=>'rule.updated'); $orderWays=array('DESC'=>'DESC','ASC'=>'ASC'); $sort=($_REQUEST['sort'] && $sortOptions[strtolower($_REQUEST['sort'])])?strtolower($_REQUEST['sort']):'email'; //Sorting options... if($sort && $sortOptions[$sort]) { $order_column =$sortOptions[$sort]; } $order_column=$order_column?$order_column:'rule.val'; if($_REQUEST['order'] && $orderWays[strtoupper($_REQUEST['order'])]) { $order=$orderWays[strtoupper($_REQUEST['order'])]; } $order=$order?$order:'ASC'; if($order_column && strpos($order_column,',')){ $order_column=str_replace(','," $order,",$order_column); } $x=$sort.'_sort'; $$x=' class="'.strtolower($order).'" '; $order_by="$order_column $order "; $total=db_count('SELECT count(DISTINCT rule.id) '.$from.' '.$where); $page=($_GET['p'] && is_numeric($_GET['p']))?$_GET['p']:1; $pageNav=new Pagenate($total, $page, PAGE_LIMIT); $qstr = '&'. Http::build_query($qs); $qs += array('sort' => $_REQUEST['sort'], 'order' => $_REQUEST['order']); $pageNav->setURL('banlist.php', $qs); $qstr.='&order='.($order=='DESC'?'ASC':'DESC'); $query="$select $from $where ORDER BY $order_by LIMIT ".$pageNav->getStart().",".$pageNav->getLimit(); //echo $query; ?>

showing(); else $showing=__('No banned emails matching the query found!'); if($search) $showing=__('Search Results').': '.$showing; ?>
  href="banlist.php?&sort=email"> href="banlist.php?&sort=status"> href="banlist.php?&sort=created"> href="banlist.php?&sort=updated">
>     '.__('Disabled').''; ?>  
:          
 '.__('Page').':'.$pageNav->getPageLinks().' '; ?>