protected function find_conflicting($player_id) { $vals = [':dtype' => $this->dtype, ':tournament_id' => $this->tournament_id, ':player_id' => $player_id]; $all_conflicting = Discipline::get_all('WHERE entry.discipline_id = discipline.id AND discipline.dtype = :dtype AND discipline.tournament_id = :tournament_id AND (entry.player_id = :player_id OR entry.partner_id = :player_id) ', $vals, ['entry']); if (\count($all_conflicting) > 0) { return $all_conflicting[0]; } return null; }
public function get_disciplines($add_sql = '') { return Discipline::get_all('WHERE tournament_id=? ' . $add_sql, [$this->id]); }