/**
* Updates Match by ID
* @param ResultSet $result
* @param User $user
* @return Match
*/
protected function insertUserIDifMatchExists($result, $user)
{
$match = new Match();
$match->exchangeArray($result->current());
$sql = new Sql($this->dbAdapter);
$update = $sql->update('tblmatch');
$update->where(array('matchID = ?' => $match->getID()));
//Updates User1 or User2 depending on which is empty
if ($match->getUser1()) {
$update->set(array('User2' => $user->getID(), 'User2ELO' => $user->getELO()));
} else {
$update->set(array('User1' => $user->getID(), 'User1ELO' => $user->getELO()));
}
$stmt = $sql->prepareStatementForSqlObject($update);
$stmt->execute();
//return updated Match
return $this->getMatch($match->getID());
}