function deleteTeam($team_id) { global $sql; deleteTeamAwards($team_id); deleteTeamMatches($team_id); // delete all the players of that team $q = "SELECT " . TBL_PLAYERS . ".*" . " FROM " . TBL_PLAYERS . " WHERE (" . TBL_PLAYERS . ".Team = '{$team_id}')"; $result = $sql->db_Query($q); $numPlayers = mysql_numrows($result); for ($i = 0; $i < $numPlayers; $i++) { $player_id = mysql_result($result, $i, TBL_PLAYERS . ".PlayerID"); deletePlayer($player_id); } $q = "DELETE FROM " . TBL_TEAMS . " WHERE (" . TBL_TEAMS . ".TeamID = '{$team_id}')"; $result = $sql->db_Query($q); }
header("Location: eventmanage.php?eventid={$event_id}"); exit; } if (isset($_POST['del_team_games']) && $_POST['del_team_games'] != "") { $teamid = $_POST['del_team_games']; deleteTeamMatches($teamid); if ($event->getField('FixturesEnable') == TRUE) { $event->brackets(true); } updateStats($event_id, $time, TRUE); header("Location: eventmanage.php?eventid={$event_id}"); exit; } if (isset($_POST['del_team_awards']) && $_POST['del_team_awards'] != "") { $teamid = $_POST['del_team_awards']; deleteTeamAwards($teamid); header("Location: eventmanage.php?eventid={$event_id}"); exit; } if (isset($_POST['checkin_team']) && $_POST['checkin_team'] != "") { $teamid = $_POST['checkin_team']; checkinTeam($teamid); if ($event->getField('FixturesEnable') == TRUE && $event->getField('Status') == 'active') { $event->brackets(true); } $event->setFieldDB('IsChanged', 1); header("Location: eventmanage.php?eventid={$event_id}"); exit; } if (isset($_POST['replace_team']) && $_POST['replace_team'] != "") { $teamid = $_POST['replace_team'];