/** * @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); } }