pageLimit = 50; $type = 'all'; $link = ""; if (!empty($filter_keyword)) { $link .= "&query=".$filter_keyword; $sql = " (name LIKE '%$filter_keyword%' OR description LIKE '%$filter_keyword%') "; $db->where($sql); } $link .= "&type=".$type; if (!empty($this_start) && !empty($this_end)) { $db->where('time',$this_start,'>=')->where('time',$this_end,'<='); } $sort_link = $link; $sort_array = array('DESC_i' => array('id' , 'DESC'), 'ASC_i' => array('id' , 'ASC'), 'DESC_n' => array('name' , 'DESC'), 'ASC_n' => array('name' , 'ASC'), 'DESC_t' => array('type' , 'DESC'), 'ASC_t' => array('type' , 'ASC'), 'DESC_l' => array('length' , 'DESC'), 'ASC_l' => array('length' , 'ASC'), 'DESC_p' => array('placement' , 'DESC'), 'ASC_p' => array('placement' , 'ASC')); if (!empty($_GET['sort']) && in_array($_GET['sort'], array_keys($sort_array))) { $db->orderBy($sort_array[$_GET['sort']][0],$sort_array[$_GET['sort']][1]); $link .= "&sort=".PT_Secure($_GET['sort']); } else{ $_GET['sort'] = 'DESC_i'; $db->orderBy('id', 'DESC'); } $fields = $db->objectbuilder()->paginate(T_FIELDS, $page); if (($page > $db->totalPages) && !empty($_GET['page-id'])) { header("Location: " . PT_LoadAdminLinkSettings('manage-profile-fields')); exit(); } ?>
ID | Field name | Type | Length | Placement | Action |
---|