public function riding($id)
 {
     $competitiongroup = Competitiongroup::whereId($id)->firstOrFail();
     $competitor_list = Result::where('competitiongroup_id', '=', $id)->where('riding_status', '')->where('dsq_status', 0)->get();
     $horses = Horse::orderBy('name', 'asc')->lists('name', 'id')->all();
     $competitor_in = [];
     $competitor_riding_point = [];
     $competitor_riding_time = [];
     $competitor_horse = [];
     $competitor_riding_points = [];
     //Versenyzők neve, lovas pontszáma, lova
     foreach ($competitor_list as $comp) {
         $competitor_in[$comp->competitor->id] = $comp->competitor->full_name;
         $competitor_riding_point[$comp->competitor->id] = $comp->riding_point;
         $competitor_riding_time[$comp->competitor->id] = $comp->riding_time;
         $competitor_riding_points[$comp->competitor->id] = $comp->riding_points;
         if ($comp->horse != null) {
             $competitor_horse[$comp->competitor->id] = $comp->horse->id;
         } else {
             $competitor_horse[$comp->competitor->id] = "";
         }
     }
     natsort($competitor_in);
     return view('backend.results.riding', compact('competitiongroup', 'competitor_in', 'competitor_riding_point', 'horses', 'competitor_horse', 'competitor_riding_time', 'competitor_riding_points'));
 }