pageLimit = 50; $type = 'all'; if (!empty($_GET['type']) && $_GET['type'] == 'free') { $filter_type = " `is_pro` = 0 AND "; $type = "free"; } elseif (!empty($_GET['type']) && $_GET['type'] == 'pro') { $filter_type = " `is_pro` = 1 AND "; $type = "pro"; } if (!empty($filter_keyword)) { $sql = " {$filter_type} (username LIKE '%$filter_keyword%' OR email LIKE '%$filter_keyword%' OR id = '$filter_keyword' OR first_name LIKE '%$filter_keyword%' OR last_name LIKE '%$filter_keyword%') "; $users = $db->where($sql)->orderBy('id', 'DESC')->objectbuilder()->paginate(T_USERS, $page); } else { if ($type == 'free') { $db->where('is_pro',0); } else if($type == 'pro'){ $db->where('is_pro',1); } $users = $db->objectbuilder()->orderBy('id', 'DESC')->paginate(T_USERS, $page); } if (($page > $db->totalPages) && !empty($_GET['page-id'])) { header("Location: " . PT_LoadAdminLinkSettings('manage-users')); exit(); } ?>
ID | Username | IP address | Status | Action |
---|