/** * Get all users with permission to access admin */ public function getMods($h, $permission = 'can_access_admin', $value = 'yes') { $sql = "SELECT user_id FROM " . TABLE_USERS . " WHERE (user_role = %s) || (user_role = %s) || (user_role = %s)"; $users = $h->db->get_results($h->db->prepare($sql, 'admin', 'supermod', 'moderator')); if (!$users) { return false; } $mods = array(); foreach ($users as $user) { $details = new UserBase(); $details->getUser($h, $user->user_id); if ($details->getPermission($permission) == $value) { $mods[$details->id]['id'] = $details->id; $mods[$details->id]['role'] = $details->role; $mods[$details->id]['name'] = $details->name; $mods[$details->id]['email'] = $details->email; } } return $mods; }