/**
  * @param Request $request
  *
  * Add a new linking request to the db
  * Then redirect the user back to the linking page
  */
 public function add(Request $request)
 {
     $this->validate($request, ['Byond_Username' => 'required']);
     $helpers = new Helpers();
     $ckey = $helpers->sanitize_ckey($request->input("Byond_Username"));
     //Only add a new linking request if there is no existing one (where the deleted_at date is not set)
     if (DB::connection('server')->table('player_linking')->where('forum_id', '=', $request->user()->user_id)->where('deleted_at', '=', NULL)->count() == 0) {
         DB::connection('server')->table('player_linking')->insert([['forum_id' => $request->user()->user_id, 'forum_username_short' => $request->user()->username_clean, 'forum_username' => $request->user()->username, 'player_ckey' => $ckey, 'status' => 'new', 'created_at' => date('Y-m-d H:i:s', time()), 'updated_at' => date('Y-m-d H:i:s', time())]]);
         return redirect()->route('user.link');
     } else {
         return redirect()->route('user.link')->withErrors(array("Could not create linking request, because there is already a active linking request"));
     }
 }
 public function getAgentList(Request $request)
 {
     $helpers = new Helpers();
     $term = $request->input('term');
     $search_key = $helpers->sanitize_ckey($term);
     //Check for proper input length
     if (strlen($term) >= 3) {
         //Get corresponding ckeys from DB
         $players = ServerPlayer::where('ckey', 'like', '%' . $search_key . '%')->lists('ckey', 'id');
         return json_encode($players);
     }
 }