/** * Gets all the users in a group * * @param $group_id * * @return array|null */ public function GetRelatedUserGroups($group_id) { $result = Capsule::table('syscrack_users')->where('user_permission_group', $group_id)->get(); return !empty($result) ? Result::GetAllResults($result) : null; }
/** * Gets all the sessions linked to that user * * @param $userid * * @return array|bool|null */ public function GetAllUserSessions($userid) { $result = Capsule::table('syscrack_active_sessions')->where('session_user_id', $userid)->get(); return !empty($result) ? Result::GetAllResults($result) : false; }
/** * Gets all the recent events * * @param $user_ip * * @param $recent_time * * @return array|bool|null */ public function GetRecentAttempts($user_ip, $recent_time) { $result = Capsule::table('syscrack_login_attempt')->where('attempted_user_ip', $user_ip)->orWhere('attempted_time', ">", $recent_time)->get(); return !empty($result) ? Result::GetAllResults($result) : false; }
/** * Gets this user ids tokens * * @param $user_id * * @return array|null */ public function GetVerifyAttempts($user_id) { $result = Capsule::table('syscrack_security_email_tokens')->where('token_user_id', $user_id)->get(); return !empty($result) ? Result::GetAllResults($result) : null; }