/**
* Fetches one score from database.
*
* @param int $id Id of score to be fetched.
*
* @return Score Returns score if found. Otherwise returns null.
*/
public static function find($id)
{
$query = DB::connection()->prepare('SELECT * FROM Score WHERE id = :id LIMIT 1');
$query->execute(array('id' => $id));
$row = $query->fetch();
if ($row) {
$tmp = Score::getScore($row['id']);
$throws = $tmp['throws'];
$par = $tmp['par'];
$score = new Score(array('id' => $row['id'], 'player' => $row['playerid'], 'roundId' => $row['roundid'], 'throws' => $throws, 'par' => $par));
return $score;
}
return null;
}
