/**
*
* @param Game $oGame
*/
public static function updatePenaltyMinutes(TeamPerson $oTeamPerson = null)
{
$query = 'UPDATE TeamPerson
SET Game.actions_retrieved = 1
WHERE
(
SELECT COUNT(GameAction.ID)
FROM GameAction
LEFT JOIN GameActionType ON GameActionType.id = GameAction.type_id
WHERE
GameActionType.is_goal = 1
AND
Game.nefub_id = GameAction.game_nefub_id
) >= Game.team1_score + Game.team2_score';
if ($oGame) {
$query .= " AND TeamPerson.id = '" . $oTeamPerson->getId() . "'";
}
Database::query($query);
}
