function section_dismissteam()
{
require_once 'lib/common.php';
$id = addslashes($_GET['id']);
$f_ok_x = $_GET['f_ok_x'];
$f_no_x = $_GET['f_no_x'];
$link = $_GET['link'];
// Check permission
$allowed = 0;
$obj = mysql_fetch_object(mysql_query("select name, comment, leader, logo, password, status, adminclosed \n from l_team where id={$id}"));
if (!$obj || $obj->status == 'deleted') {
echo '<BR><CENTER>Team already deleted!<BR>';
return;
}
if (isAdmin() || $_SESSION['playerid'] == $obj->leader) {
// Admin or team leader, allowed
$allowed = 1;
} else {
// Check password
$cypher = crypt($f_password, substr($obj->password, 0, 2));
if ($cypher == $obj->password) {
// Good password, allowed
$allowed = 1;
}
}
if (!$allowed) {
echo "<center>Sorry, you don't have the permission to dismiss the <a href=\"index.php?link=teaminfo&id=" . $id . "\">" . $obj->name . "</a> team.</center>";
} else {
if ($f_ok_x) {
deleteTeam($id);
echo "Team dismissed";
} else {
if ($f_no_x) {
echo "<center>Phew, the <a href=\"index.php?link=teaminfo&id=" . $id . "\">" . $obj->name . "</a> team is still alive!</center>";
} else {
echo "<center>Do you really want to dismiss the <a href=\"index.php?link=teaminfo&id=" . $id . "&" . SID . "\">" . $obj->name . "</a> team?";
echo "<form method=get>\n <input type=hidden name=link value='{$link}'>\n <input type=hidden name=id value={$id}><br>\n " . htmlFormButton('Yes', 'f_ok_x') . "\n \n " . htmlFormButton('No', 'f_no_x', CLRBUT) . "\n </form>";
}
}
}
}
</head>
<body>
<div class="container">
<?php
if (isset($_POST['delete'])) {
//sumbit came from index.php when delete button selected.
if (isset($_POST['table'])) {
//do we have table information
switch ($_POST['table']) {
//what table are we deleting
case "sport":
deleteSport();
break;
case "team":
deleteTeam();
break;
case "game":
deleteGame();
break;
default:
fail();
break;
}
}
}
?>
</div>
</body>
</html>
<?php
function deleteTeams()
{
global $sql;
$q = "SELECT " . TBL_TEAMS . ".*" . " FROM " . TBL_TEAMS . " WHERE (" . TBL_TEAMS . ".Event = '" . $this->fields['EventID'] . "')";
$result = $sql->db_Query($q);
$num_teams = mysql_numrows($result);
if ($num_teams != 0) {
for ($j = 0; $j < $num_teams; $j++) {
$tID = mysql_result($result, $j, TBL_TEAMS . ".TeamID");
deleteTeam($tID);
}
}
}
// TODO: only for ladders?
updateStats($event_id, $time, TRUE);
header("Location: eventmanage.php?eventid={$event_id}");
exit;
}
if (isset($_POST['unban_team']) && $_POST['unban_team'] != "") {
$teamid = $_POST['unban_team'];
unbanTeam($teamid);
// TODO: only for ladders?
updateStats($event_id, $time, TRUE);
header("Location: eventmanage.php?eventid={$event_id}");
exit;
}
if (isset($_POST['kick_team']) && $_POST['kick_team'] != "") {
$teamid = $_POST['kick_team'];
deleteTeam($teamid);
if ($event->getField('FixturesEnable') == TRUE && $event->getField('Status') == 'active') {
$event->brackets(true);
}
updateStats($event_id, $time, TRUE);
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}");
}
while ($row = mysql_fetch_array($res)) {
$deleteteam++;
print "Deleting team {$row[0]} #{$row[1]}\n";
deleteTeam($row[1]);
}
// Delete teams marked for deleting.
$sql = "SELECT t.name, t.id FROM l_team t WHERE t.status = 'deleted' AND t.id != {$deadteam} ";
$res = mysql_query($sql);
if (!$res) {
print " Failed: {$sql}\n";
}
while ($row = mysql_fetch_array($res)) {
$deleteteam++;
print "Deleting team {$row[0]} #{$row[1]}\n";
deleteTeam($row[1]);
}
// Delete all teamless players, who havnt been logged on for 3 months.
$sql = "SELECT p.callsign, p.id " . "FROM l_player p " . "WHERE p.team = 0 " . "AND p.last_login < subdate(now(), INTERVAL 3 MONTH) ORDER BY p.callsign";
$res = mysql_query($sql);
if (!$res) {
print " Failed: {$sql}\n";
}
while ($row = mysql_fetch_array($res)) {
$deleteplayer++;
print "Delete teamless player: " . $row[0] . "\n";
deletePlayer($row[1], stripslashes($row[0]));
}
// Find and mark all active teams (played a match during the last 45 days)
// this may look odd if a user sees this, perhaps rewrite this.
$sql = "UPDATE l_team SET active = 'no'";
