function OnLoadPageData()
 {
     # Require an API key to include personal contact details to avoid spam bots picking them up
     $api_keys = $this->GetSettings()->GetApiKeys();
     $valid_key = false;
     if (isset($_GET['key']) and in_array($_GET['key'], $api_keys)) {
         $valid_key = true;
     }
     $data = array();
     $data[] = array("Match id", "Title", "Start time", "Latitude", "Longitude", "Website", "Description");
     require_once 'stoolball/match-manager.class.php';
     require_once "search/match-search-adapter.class.php";
     $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
     $match_manager->FilterByDateStart(gmdate("U"));
     $match_manager->ReadByMatchId();
     while ($match_manager->MoveNext()) {
         $match = $match_manager->GetItem();
         $adapter = new MatchSearchAdapter($match);
         /* @var $match Match */
         # Add this match to the data array
         $data[] = array($match->GetId(), $match->GetTitle(), $match->GetStartTime(), $match->GetGround() instanceof Ground ? $match->GetGround()->GetAddress()->GetLatitude() : "", $match->GetGround() instanceof Ground ? $match->GetGround()->GetAddress()->GetLongitude() : "", "https://" . $this->GetSettings()->GetDomain() . $match->GetNavigateUrl(), $adapter->GetSearchDescription());
     }
     unset($match_manager);
     require_once "data/csv.class.php";
     CSV::PublishData($data);
     # Test code only. Comment out CSV publish line above to enable display as a table.
     require_once "xhtml/tables/xhtml-table.class.php";
     $table = new XhtmlTable();
     $table->BindArray($data, false, false);
     echo $table;
 }
 function OnLoadPageData()
 {
     /* @var $match_manager MatchManager */
     /* @var $editor TournamentEditControl */
     # get id of Match
     $i_id = $this->match_manager->GetItemId();
     if (!$i_id) {
         return;
     }
     # no need to read if redisplaying invalid form
     if ($this->IsValid()) {
         $this->match_manager->ReadByMatchId(array($i_id));
         $this->tournament = $this->match_manager->GetFirst();
         if ($this->tournament instanceof Match) {
             $this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->tournament->GetAddedBy()->GetId();
             $this->b_is_tournament = $this->tournament->GetMatchType() == MatchType::TOURNAMENT;
         } else {
             return;
         }
     }
     if ($this->b_user_is_match_admin or $this->b_user_is_match_owner) {
         # Get all seasons
         # Don't filter by match type at this point because we want to know what other types of match the seasons support.
         # If it's tournaments only, they'll be treated differently.
         require_once 'stoolball/season-manager.class.php';
         $season_manager = new SeasonManager($this->GetSettings(), $this->GetDataConnection());
         $season_dates = Season::SeasonDates($this->tournament->GetStartTime());
         $season_manager->FilterByDateStart($season_dates[0]);
         $season_manager->FilterByDateEnd($season_dates[1]);
         $season_manager->ReadSeasonSummaries(array($this->tournament->GetPlayerType()));
         $this->editor->Seasons()->SetItems($season_manager->GetItems());
         unset($season_manager);
     }
 }
 function OnLoadPageData()
 {
     /* @var Match $tournament */
     # check parameter
     if (!isset($_GET['match']) or !is_numeric($_GET['match'])) {
         $this->Redirect();
     }
     # get tournament
     $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
     $match_manager->ReadByMatchId(array($_GET['match']));
     $this->tournament = $match_manager->GetFirst();
     unset($match_manager);
     # must have found a match
     if (!$this->tournament instanceof Match) {
         $this->page_not_found = true;
         return;
     }
     # Get some stats on the best players
     require_once 'stoolball/statistics/statistics-manager.class.php';
     $statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
     $statistics_manager->FilterByTournament(array($this->tournament->GetId()));
     $this->statistics["querystring"] = "?tournament=" . $this->tournament->GetId();
     require_once "_summary-data-query.php";
     unset($statistics_manager);
 }
 function OnLoadPageData()
 {
     # get match
     if (!is_object($this->match)) {
         $i_id = $this->manager->GetItemId($this->match);
         if ($i_id) {
             $this->manager->ReadByMatchId(array($i_id));
             $this->match = $this->manager->GetFirst();
         }
     }
     # tidy up
     unset($this->manager);
     if (is_object($this->match) and $this->match->GetMatchType() == MatchType::TOURNAMENT) {
         $this->match_or_tournament = 'tournament';
     }
 }
 private function ReadMatchData($start_date)
 {
     require_once 'stoolball/match-manager.class.php';
     $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
     $match_manager->FilterByDateStart($start_date);
     $match_manager->FilterByMatchType(array(MatchType::CUP, MatchType::FRIENDLY, MatchType::LEAGUE, MatchType::PRACTICE, MatchType::TOURNAMENT));
     $match_manager->ReadByMatchId();
     $data = $match_manager->GetItems();
     unset($match_manager);
     return $data;
 }
 public function OnLoadPageData()
 {
     if (!is_null($this->i_match_id)) {
         require_once 'stoolball/match-manager.class.php';
         $o_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
         $o_manager->ReadByMatchId(array($this->i_match_id));
         $o_match = $o_manager->GetFirst();
         if ($o_match instanceof Match) {
             $this->s_cal_title = $o_match->GetTitle() . ' – ' . $o_match->GetStartTimeFormatted();
             $this->s_cal_url = $o_match->GetCalendarNavigateUrl();
         }
         unset($o_manager);
     } else {
         if (!is_null($this->i_team_id)) {
             require_once 'stoolball/team-manager.class.php';
             $o_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
             $o_manager->ReadById(array($this->i_team_id));
             $o_team = $o_manager->GetFirst();
             if ($o_team instanceof Team) {
                 $this->s_cal_title = $o_team->GetName() . '\'s current season';
                 $this->s_cal_url = $o_team->GetCalendarNavigateUrl();
             }
             unset($o_manager);
         } else {
             if (!is_null($this->i_season_id)) {
                 require_once 'stoolball/competition-manager.class.php';
                 $o_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
                 $o_manager->ReadById(null, array($this->i_season_id));
                 $o_comp = $o_manager->GetFirst();
                 if ($o_comp instanceof Competition) {
                     $o_season = $o_comp->GetWorkingSeason();
                     $this->s_cal_title = $o_season->GetCompetitionName();
                     $this->s_cal_url = $o_season->GetCalendarNavigateUrl();
                 }
                 unset($o_manager);
             } else {
                 if ($this->tournament_player_type) {
                     $this->s_matches = $this->tournament_player_type . " tournaments";
                     $this->s_cal_url = "/tournaments/" . $this->tournament_player_type . "/calendar";
                 }
             }
         }
     }
     if (is_null($this->s_cal_url)) {
         header('Location: /play/');
         exit;
     }
 }
 function OnLoadPageData()
 {
     /* @var $match_manager MatchManager */
     /* @var $editor TournamentMatchesControl */
     # get id of Match
     $i_id = $this->match_manager->GetItemId();
     if (!$i_id) {
         return;
     }
     # no need to read if redisplaying invalid form
     if ($this->IsValid()) {
         $this->match_manager->ReadByMatchId(array($i_id));
         $this->tournament = $this->match_manager->GetFirst();
         if ($this->tournament instanceof Match) {
             $this->b_is_tournament = $this->tournament->GetMatchType() == MatchType::TOURNAMENT;
         } else {
             return;
         }
     }
 }
 function OnLoadPageData()
 {
     /* @var $match_manager MatchManager */
     /* @var $editor TournamentEditControl */
     # get id of Match
     $i_id = $this->match_manager->GetItemId();
     if (!$i_id) {
         return;
     }
     # no need to read if redisplaying invalid form
     if ($this->IsValid()) {
         $this->match_manager->ReadByMatchId(array($i_id));
         $this->tournament = $this->match_manager->GetFirst();
         if ($this->tournament instanceof Match) {
             $this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->tournament->GetAddedBy()->GetId();
             $this->b_is_tournament = $this->tournament->GetMatchType() == MatchType::TOURNAMENT;
         } else {
             return;
         }
     }
     if ($this->b_user_is_match_admin or $this->b_user_is_match_owner) {
         # get all grounds
         require_once 'stoolball/ground-manager.class.php';
         $o_ground_manager = new GroundManager($this->GetSettings(), $this->GetDataConnection());
         $o_ground_manager->ReadAll();
         $this->editor->Grounds()->SetItems($o_ground_manager->GetItems());
         unset($o_ground_manager);
         # get teams in seasons, in order to promote home grounds of teams
         $season_ids = array();
         foreach ($this->tournament->Seasons() as $season) {
             $season_ids[] = $season->GetId();
         }
         require_once 'stoolball/team-manager.class.php';
         $team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
         if (count($season_ids)) {
             $team_manager->ReadBySeasonId($season_ids);
             $this->editor->ProbableTeams()->SetItems($team_manager->GetItems());
         }
         unset($team_manager);
     }
 }
 function OnLoadPageData()
 {
     /* @var Match $tournament */
     # check parameter
     if (!isset($_GET['match']) or !is_numeric($_GET['match'])) {
         $this->Redirect();
     }
     # get match
     $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
     $match_manager->ReadByMatchId(array($_GET['match']));
     $match_manager->ExpandMatchScorecards();
     $this->match = $match_manager->GetFirst();
     unset($match_manager);
     # must have found a match
     if (!$this->match instanceof Match) {
         $this->page_not_found = true;
         return;
     }
     $result = $this->match->Result();
     $this->has_statistics = $result->HomeOvers()->GetCount() or $result->AwayOvers()->GetCount();
 }
 function OnLoadPageData()
 {
     /* @var $match_manager MatchManager */
     # get id of Match
     $i_id = $this->match_manager->GetItemId();
     # Get details of match but, if invalid, don't replace submitted details with saved ones
     if ($i_id and $this->IsValid()) {
         $this->match_manager->ReadByMatchId(array($i_id));
         $this->match_manager->ExpandMatchScorecards();
         $this->match = $this->match_manager->GetFirst();
         if ($this->match instanceof Match) {
             $this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->match->GetAddedBy()->GetId();
             $this->b_is_tournament = $this->match->GetMatchType() == MatchType::TOURNAMENT;
         }
     }
     unset($this->match_manager);
     # Tournament or match in the future or not played is page not found
     $editable_results = array(MatchResult::UNKNOWN, MatchResult::HOME_WIN, MatchResult::AWAY_WIN, MatchResult::TIE, MatchResult::ABANDONED);
     if (!$this->match instanceof Match or $this->b_is_tournament or $this->match->GetStartTime() > gmdate('U') or !in_array($this->match->Result()->GetResultType(), $editable_results)) {
         http_response_code(404);
         $this->page_not_found = true;
     }
 }
 private function IndexMatches()
 {
     require_once "data/process-manager.class.php";
     $this->process = new ProcessManager("matches", 200);
     if ($this->process->ReadyToDeleteAll()) {
         $this->SearchIndexer()->DeleteFromIndexByType("match");
     }
     $match = $this->GetSettings()->GetTable('Match');
     $match_batch = $this->GetDataConnection()->query("SELECT match_id FROM {$match} ORDER BY start_time, match_id" . $this->process->GetQueryLimit());
     $match_ids = array();
     while ($row = $match_batch->fetch()) {
         $match_ids[] = $row->match_id;
     }
     if (count($match_ids)) {
         require_once 'stoolball/match-manager.class.php';
         require_once 'search/match-search-adapter.class.php';
         $manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
         $manager->ReadByMatchId($match_ids);
         $results = $manager->GetItems();
         unset($manager);
         foreach ($results as $match) {
             $adapter = new MatchSearchAdapter($match);
             $this->SearchIndexer()->Index($adapter->GetSearchableItem());
             $this->process->OneMoreDone();
         }
         $this->SearchIndexer()->CommitChanges();
     }
 }
 /**
  * If the tournament parameter is in the query string apply tournament filter
  * @param SiteSettings $settings
  * @param MySqlConnection $connection
  * @param StatisticsManager $statistics_manager
  */
 public static function ApplyTournamentFilter(SiteSettings $settings, MySqlConnection $connection, StatisticsManager $statistics_manager)
 {
     $filter = "";
     if (isset($_GET['tournament']) and is_numeric($_GET['tournament'])) {
         require_once 'stoolball/match-manager.class.php';
         $match_manager = new MatchManager($settings, $connection);
         $match_manager->ReadByMatchId(array($_GET['tournament']));
         $tournament = $match_manager->GetFirst();
         unset($match_manager);
         if (!is_null($tournament)) {
             $statistics_manager->FilterByTournament(array($tournament->GetId()));
             $filter = "in the " . $tournament->GetTitle() . " on " . Date::BritishDate($tournament->GetStartTime()) . " ";
         }
     }
     return $filter;
 }
 public function OnLoadPageData()
 {
     /* @var $topic ForumTopic */
     /* @var $match Match */
     # new data manager
     $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
     # get match
     $match_manager->ReadByMatchId(array($_GET['item']));
     $match_manager->ExpandMatchScorecards();
     $this->match = $match_manager->GetFirst();
     # must have found a match
     if (!$this->match instanceof Match) {
         header('Location: /matches/');
         exit;
     }
     # Update search engine
     if ($this->match->GetSearchUpdateRequired()) {
         require_once "search/match-search-adapter.class.php";
         $this->SearchIndexer()->DeleteFromIndexById("match" . $this->match->GetId());
         $adapter = new MatchSearchAdapter($this->match);
         $this->SearchIndexer()->Index($adapter->GetSearchableItem());
         $this->SearchIndexer()->CommitChanges();
         $match_manager->SearchUpdated($this->match->GetId());
     }
     # tidy up
     unset($match_manager);
     # Get comments
     $this->review_item = new ReviewItem($this->GetSettings());
     $this->review_item->SetId($this->match->GetId());
     $this->review_item->SetType(ContentType::STOOLBALL_MATCH);
     $this->review_item->SetTitle($this->match->GetTitle());
     $this->review_item->SetNavigateUrl("https://" . $this->GetSettings()->GetDomain() . $this->review_item->GetNavigateUrl());
     $this->review_item->SetLinkedDataUri($this->match->GetLinkedDataUri());
     $topic_manager = new TopicManager($this->GetSettings(), $this->GetDataConnection());
     if ($this->IsPostback()) {
         $this->SavePostedComments($topic_manager);
     }
     $topic_manager->ReadCommentsForReviewItem($this->review_item);
     $this->topic = $topic_manager->GetFirst();
     unset($topic_manager);
     if ($this->match->GetMatchType() == MatchType::TOURNAMENT or $this->match->GetMatchType() == MatchType::TOURNAMENT_MATCH) {
         # Get stats highlights
         require_once 'stoolball/statistics/statistics-manager.class.php';
         $statistics_manager = new StatisticsManager($this->GetSettings(), $this->GetDataConnection());
         if ($this->match->GetMatchType() == MatchType::TOURNAMENT) {
             $statistics_manager->FilterByTournament(array($this->match->GetId()));
         } else {
             $statistics_manager->FilterByTournament(array($this->match->GetTournament()->GetId()));
         }
         $statistics_manager->FilterMaxResults(1);
         $this->best_batting = $statistics_manager->ReadBestBattingPerformance();
         $this->best_bowling = $statistics_manager->ReadBestBowlingPerformance();
         $this->most_runs = $statistics_manager->ReadBestPlayerAggregate("runs_scored");
         $this->most_wickets = $statistics_manager->ReadBestPlayerAggregate("wickets");
         $this->most_catches = $statistics_manager->ReadBestPlayerAggregate("catches");
         # See what stats we've got available
         $best_batting_count = count($this->best_batting);
         $best_bowling_count = count($this->best_bowling);
         $best_batters = count($this->most_runs);
         $best_bowlers = count($this->most_wickets);
         $best_catchers = count($this->most_catches);
         $this->has_player_stats = ($best_batting_count or $best_batters or $best_bowling_count or $best_bowlers or $best_catchers);
         if (!$this->has_player_stats) {
             $player_of_match = $statistics_manager->ReadBestPlayerAggregate("player_of_match");
             $this->has_player_stats = (bool) count($player_of_match);
         }
         unset($statistics_manager);
     }
 }
    public function OnLoadPageData()
    {
        $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
        $match_manager->ReadByMatchId(array($_GET['match']));
        $match_manager->ExpandMatchScorecards();
        $this->match = $match_manager->GetFirst();
        unset($match_manager);
        if ($this->match->GetHomeTeam() instanceof Team and $this->match->GetAwayTeam() instanceof Team) {
            ?>
{
    "worm": {
        "labels": [
            <?php 
            $overs = $this->HowManyOversInTheMatch();
            echo $this->BuildOversLabels(0, $overs);
            ?>
        
        ],
        "datasets": [
        <?php 
            $home_batted_first = $this->match->Result()->GetHomeBattedFirst();
            if ($home_batted_first === true || is_null($home_batted_first)) {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeOverTotals($this->match->Result()->AwayOvers()->GetItems());
                ?>
]
            },
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeOverTotals($this->match->Result()->HomeOvers()->GetItems());
                ?>
]
            }      
            <?php 
            } else {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeOverTotals($this->match->Result()->HomeOvers()->GetItems());
                ?>
]
            },      
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeOverTotals($this->match->Result()->AwayOvers()->GetItems());
                ?>
]
            }
            <?php 
            }
            ?>
]    
    },
    "runRate": {
        "labels": [
            <?php 
            echo $this->BuildOversLabels(0, $overs);
            ?>
        
        ],
        "datasets": [
        <?php 
            $home_batted_first = $this->match->Result()->GetHomeBattedFirst();
            if ($home_batted_first === true || is_null($home_batted_first)) {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName() . " run rate", $home_batted_first === true);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeRunRate($this->match->Result()->AwayOvers()->GetItems());
                ?>
]
            },
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName() . " run rate", null);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeRunRate($this->match->Result()->HomeOvers()->GetItems());
                ?>
]
            },
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName() . " rate required", null);
                ?>
",
                "data": [<?php 
                echo $this->BuildRunRateRequired($this->match->Result()->AwayOvers()->GetItems(), $this->match->Result()->HomeOvers()->GetItems(), $overs);
                ?>
]
            }      
            <?php 
            } else {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName() . " run rate", $home_batted_first === false);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeRunRate($this->match->Result()->HomeOvers()->GetItems());
                ?>
]
            },      
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName() . " run rate", null);
                ?>
",
                "data": [0<?php 
                echo $this->BuildCumulativeRunRate($this->match->Result()->AwayOvers()->GetItems());
                ?>
]
            },      
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName() . " rate required", null);
                ?>
",
                "data": [<?php 
                echo $this->BuildRunRateRequired($this->match->Result()->HomeOvers()->GetItems(), $this->match->Result()->AwayOvers()->GetItems(), $overs);
                ?>
]
            }
            <?php 
            }
            ?>
]    
    },
    "manhattanFirstInnings": {
        "labels": [
            <?php 
            $overs = $this->HowManyOversInTheMatch();
            echo $this->BuildOversLabels(1, $overs);
            ?>
        
        ],
        "datasets": [
        <?php 
            if ($home_batted_first === true || is_null($home_batted_first)) {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
                ?>
",
                "data": [<?php 
                echo $this->BuildOverTotals($this->match->Result()->AwayOvers()->GetItems(), $overs);
                ?>
]
            }      
            <?php 
            } else {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
                ?>
",
                "data": [<?php 
                echo $this->BuildOverTotals($this->match->Result()->HomeOvers()->GetItems(), $overs);
                ?>
]
            }      
        <?php 
            }
            ?>
        ]
    },
    "manhattanSecondInnings": {
        "labels": [
            <?php 
            $overs = $this->HowManyOversInTheMatch();
            echo $this->BuildOversLabels(1, $overs);
            ?>
        
        ],
        "datasets": [
        <?php 
            if ($home_batted_first === false) {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetHomeTeam()->GetName(), $home_batted_first === true);
                ?>
",
                "data": [<?php 
                echo $this->BuildOverTotals($this->match->Result()->AwayOvers()->GetItems(), $overs);
                ?>
]
            }      
            <?php 
            } else {
                ?>
            {
                "label": "<?php 
                echo $this->BuildTeamNameLabel($this->match->GetAwayTeam()->GetName(), $home_batted_first === false);
                ?>
",
                "data": [<?php 
                echo $this->BuildOverTotals($this->match->Result()->HomeOvers()->GetItems(), $overs);
                ?>
]
            }      
        <?php 
            }
            ?>
        ]
    }
    <?php 
        }
        ?>
}
        <?php 
        exit;
    }
 /**
  * Call this method when a match has changed to update derived match data 
  */
 public function UpdateMatchDataInStatistics(MatchManager $match_manager, $match_id)
 {
     $match_manager->ReadByMatchId(array($match_id));
     $match = $match_manager->GetFirst();
     $sql = "UPDATE nsa_player_match SET \r\n                           match_title = " . Sql::ProtectString($this->GetDataConnection(), $match->GetTitle()) . ",\r\n                           won_match = NULL \r\n                           WHERE match_id = " . Sql::ProtectNumeric($match->GetId());
     $this->GetDataConnection()->query($sql);
     $match_result = $match->Result()->GetResultType();
     if ($match_result == MatchResult::HOME_WIN) {
         $sql = "UPDATE nsa_player_match \r\n                           SET won_match = 1 \r\n                           WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n                           AND team_id = " . Sql::ProtectNumeric($match->GetHomeTeamId());
         $this->GetDataConnection()->query($sql);
         $sql = "UPDATE nsa_player_match \r\n                           SET won_match = -1 \r\n                           WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n                           AND team_id = " . Sql::ProtectNumeric($match->GetAwayTeamId());
         $this->GetDataConnection()->query($sql);
     } else {
         if ($match_result == MatchResult::AWAY_WIN) {
             $sql = "UPDATE nsa_player_match \r\n                           SET won_match = 1 \r\n                           WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n                           AND team_id = " . Sql::ProtectNumeric($match->GetAwayTeamId());
             $this->GetDataConnection()->query($sql);
             $sql = "UPDATE nsa_player_match \r\n                           SET won_match = -1 \r\n                           WHERE match_id = " . Sql::ProtectNumeric($match->GetId()) . "\r\n                           AND team_id = " . Sql::ProtectNumeric($match->GetHomeTeamId());
             $this->GetDataConnection()->query($sql);
         } else {
             if ($match_result == MatchResult::TIE) {
                 $sql = "UPDATE nsa_player_match \r\n                           SET won_match = 0 \r\n                           WHERE match_id = " . Sql::ProtectNumeric($match->GetId());
                 $this->GetDataConnection()->query($sql);
             }
         }
     }
 }
 function OnLoadPageData()
 {
     /* @var $match_manager MatchManager */
     /* @var $editor MatchEditControl */
     # get id of Match
     $i_id = $this->match_manager->GetItemId();
     if ($i_id) {
         # Get details of match but, if invalid, don't replace submitted details with saved ones
         if ($this->IsValid()) {
             $this->match_manager->ReadByMatchId(array($i_id));
             $this->match_manager->ExpandMatchScorecards();
             $this->match = $this->match_manager->GetFirst();
             if ($this->match instanceof Match) {
                 $this->b_user_is_match_owner = AuthenticationManager::GetUser()->GetId() == $this->match->GetAddedBy()->GetId();
                 $this->b_is_tournament = $this->match->GetMatchType() == MatchType::TOURNAMENT;
             }
         }
         unset($this->match_manager);
         # get all competitions if user has permission to change the season
         if ($this->b_user_is_match_admin) {
             require_once 'stoolball/competition-manager.class.php';
             $o_comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
             $o_comp_manager->ReadAllSummaries();
             $this->editor->SetSeasons(CompetitionManager::GetSeasonsFromCompetitions($o_comp_manager->GetItems()));
             unset($o_comp_manager);
         }
         if ($this->b_user_is_match_admin or $this->b_user_is_match_owner) {
             # get all teams
             $season_ids = array();
             if ($this->match instanceof Match) {
                 foreach ($this->match->Seasons() as $season) {
                     $season_ids[] = $season->GetId();
                 }
             }
             require_once 'stoolball/team-manager.class.php';
             $o_team_manager = new TeamManager($this->GetSettings(), $this->GetDataConnection());
             if ($this->match instanceof Match and $this->match->GetMatchType() == MatchType::TOURNAMENT_MATCH) {
                 $o_team_manager->FilterByTournament(array($this->match->GetTournament()->GetId()));
                 $o_team_manager->FilterByTeamType(array());
                 # override default to allow all team types
                 $o_team_manager->ReadTeamSummaries();
             } else {
                 if ($this->b_user_is_match_admin or !count($season_ids) or $this->match->GetMatchType() == MatchType::FRIENDLY) {
                     $o_team_manager->ReadById();
                     # we need full data on the teams to get the seasons they are playing in;
                 } else {
                     # If the user can't change the season, why let them select a team that's not in the season?
                     $o_team_manager->ReadBySeasonId($season_ids);
                 }
             }
             $this->editor->SetTeams(array($o_team_manager->GetItems()));
             unset($o_team_manager);
             # get all grounds
             require_once 'stoolball/ground-manager.class.php';
             $o_ground_manager = new GroundManager($this->GetSettings(), $this->GetDataConnection());
             $o_ground_manager->ReadAll();
             $this->editor->SetGrounds($o_ground_manager->GetItems());
             unset($o_ground_manager);
         }
     }
     # Tournament or match not found is page not found
     if (!$this->match instanceof Match or $this->b_is_tournament) {
         http_response_code(404);
         $this->page_not_found = true;
     }
 }
 function OnLoadPageData()
 {
     /* @var $o_match Match */
     /* @var $o_team Team */
     # new data manager
     $match_manager = new MatchManager($this->GetSettings(), $this->GetDataConnection());
     # create repeater control, and save any posted data
     $this->repeater = new DataEditRepeater($this, 'CreateEditControl');
     $this->repeater->SetCssClass('matchResults');
     $this->repeater->SetPersistedParameters(array('team', 'season', "tournament"));
     $this->repeater->SetButtonText('Save all results');
     $this->repeater->SetShowButtonsAtTop(true);
     if ($this->IsPostback() and !$this->IsRefresh() and $this->IsValid()) {
         require_once 'forums/topic-manager.class.php';
         require_once 'forums/review-item.class.php';
         require_once 'forums/subscription-manager.class.php';
         $topic_manager = new TopicManager($this->GetSettings(), $this->GetDataConnection());
         foreach ($this->repeater->GetDataObjects() as $o_current_match) {
             /* @var $o_current_match Match */
             $match_manager->SaveResult($o_current_match);
             $match_manager->ExpandMatchUrl($o_current_match);
             $match_manager->NotifyMatchModerator($o_current_match->GetId());
             if (trim($o_current_match->GetNewComment())) {
                 $item_to_comment_on = new ReviewItem($this->GetSettings());
                 $item_to_comment_on->SetType(ContentType::STOOLBALL_MATCH);
                 $item_to_comment_on->SetId($o_current_match->GetId());
                 $item_to_comment_on->SetNavigateUrl("https://" . $this->GetSettings()->GetDomain() . $o_current_match->GetNavigateUrl());
                 $message = $topic_manager->SaveComment($item_to_comment_on, $o_current_match->GetNewComment());
                 # send subscription emails - new object each time to reset list of who's already recieved an email
                 $subs_manager = new SubscriptionManager($this->GetSettings(), $this->GetDataConnection());
                 $subs_manager->SendCommentsSubscriptions($item_to_comment_on, $message);
                 unset($subs_manager);
             }
         }
         $this->b_saved = true;
     }
     # get matches
     if (!is_null($this->i_team_id)) {
         $a_season_times = Season::SeasonDates();
         $match_manager->FilterByTeam(array($this->i_team_id));
         $match_manager->FilterByDateStart($a_season_times[0]);
         $match_manager->FilterByDateEnd($a_season_times[1]);
         $match_manager->ReadMatchSummaries();
     } else {
         if (!is_null($this->i_season_id)) {
             $match_manager->ReadBySeasonId(array($this->i_season_id), true);
         } else {
             if (!is_null($this->tournament_id)) {
                 $match_manager->FilterByTournament($this->tournament_id);
                 $this->a_matches = $match_manager->ReadMatchSummaries();
             }
         }
     }
     $this->a_matches = $match_manager->GetItems();
     # Make sure we have some matches
     if (count($this->a_matches)) {
         # If it's matches for a team, get the team
         if (!is_null($this->i_team_id)) {
             # Should only need to look at the first match, because the team must be a
             # part of that match in order for the match to be in this list
             $o_match =& $this->a_matches[0];
             $o_team = $o_match->GetHomeTeam();
             if ($o_team instanceof Team and $o_team->GetId() == $this->i_team_id) {
                 $this->team = $o_team;
             } else {
                 foreach ($o_match->GetAwayTeams() as $o_team) {
                     if ($o_team->GetId() == $this->i_team_id) {
                         $this->team = $o_team;
                         break;
                     }
                 }
             }
             if (!is_object($this->team)) {
                 $this->Redirect();
             }
             # Now that we have short URL data, if data has just been saved for team, redirect back to team
             if ($this->b_saved) {
                 $this->Redirect($this->team->GetNavigateUrl());
             }
         } else {
             if (!is_null($this->i_season_id)) {
                 # get details of the season
                 require_once 'stoolball/competition-manager.class.php';
                 $o_comp_manager = new CompetitionManager($this->GetSettings(), $this->GetDataConnection());
                 $o_comp_manager->ReadById(null, array($this->i_season_id));
                 $o_competition = $o_comp_manager->GetFirst();
                 unset($o_comp_manager);
                 if ($o_competition instanceof Competition) {
                     $this->season = $o_competition->GetWorkingSeason();
                 }
                 if (!$this->season instanceof Season) {
                     $this->Redirect();
                 }
                 # Now that we have short URL data, if data has just been saved for season, redirect back to season
                 if ($this->b_saved) {
                     $this->Redirect($this->season->GetNavigateUrl());
                 }
             } else {
                 if (!is_null($this->tournament_id)) {
                     $match_manager->ReadByMatchId(array($this->tournament_id));
                     $this->tournament = $match_manager->GetFirst();
                     if (!is_null($this->tournament)) {
                         # If the tournament has just been saved, now we have its URL so redirect to the thanks page
                         if ($this->b_saved) {
                             $this->Redirect($this->tournament->GetNavigateUrl());
                         }
                     }
                 }
             }
         }
     } else {
         $this->Redirect();
     }
     unset($match_manager);
 }