function StartSixserverSeason()
{
$appRoot = realpath(dirname(__FILE__)) . '/';
require $appRoot . './../variables.php';
require $appRoot . './../variablesdb.php';
require $appRoot . './../sixserver/functions.php';
$msg = "";
$pointsArray = GetStandingsArray(true);
$sql = "SELECT season FROM six_stats";
$sixSeason = mysql_fetch_array(mysql_query($sql))[0];
$sql = "SELECT sp.id as profileId, sp.points, sp.disconnects, " . "weblm_players.player_id, weblm_players.name AS playerName, weblm_players.nationality, weblm_players.approved FROM six_profiles sp " . "LEFT JOIN weblm_players ON weblm_players.player_id=sp.user_id " . "ORDER BY sp.points DESC, playerName ASC";
$msg .= "<p>" . $sql;
$result = mysql_query($sql);
$oldPoints = -1;
$counter = 1;
$pos = -1;
while ($row = mysql_fetch_array($result)) {
$profileId = $row['profileId'];
$playerId = $row['player_id'];
$points = $row['points'];
$disconnects = $row['disconnects'];
if (isset($pointsArray[$profileId]['w'])) {
$wins = $pointsArray[$profileId]['w'];
} else {
$wins = 0;
}
if (isset($pointsArray[$profileId]['l'])) {
$losses = $pointsArray[$profileId]['l'];
} else {
$losses = 0;
}
if (isset($pointsArray[$profileId]['d'])) {
$draws = $pointsArray[$profileId]['d'];
} else {
$draws = 0;
}
$games = $wins + $losses + $draws;
$approved = $row['approved'] == 'yes';
if (!$approved) {
$pos = 0;
} else {
if ($oldPoints != $points) {
$pos = $counter;
$oldPoints = $points;
}
$counter++;
}
if ($games > 0) {
$percentage = $wins / $games;
$sql = "INSERT INTO six_history (playerId, profileId, season, position, points, games, wins, losses, draws, DC) " . "VALUES ('{$playerId}', '{$profileId}', '{$sixSeason}', '{$pos}', '{$points}', '{$games}', '{$wins}', '{$losses}', '{$draws}', '{$disconnects}')";
$msg .= "<p>" . $sql . "</p>" . PHP_EOL;
mysql_query($sql);
}
}
// set points and dc to zero
$update_sql = "UPDATE six_profiles set points=0, disconnects=0";
$result = mysql_query($update_sql);
$msg .= "<p>set points to zero [" . mysql_affected_rows() . "]<p>" . PHP_EOL;
// update season var
$update_sql = "UPDATE six_stats set season=season+1";
$result = mysql_query($update_sql);
$msg .= "<p>update season var [" . mysql_affected_rows() . "]<p>" . PHP_EOL;
return $msg;
}
} else {
if (!empty($_GET['group'])) {
$group = mysql_real_escape_string($_GET['group']);
}
}
if ($type == "points2") {
$pointsArray = GetStandingsArray(true);
$orderByField = "points2";
$colTitle = "Points2";
} else {
if ($type == "s") {
$pointsArray = GetStandingsArray(true);
$orderByField = "points";
$colTitle = "Points";
} else {
$pointsArray = GetStandingsArray(false);
$orderByField = "rating";
$colTitle = "Rating";
}
}
$left = $subNavText . getRaquo() . getSubNavigation($subpage, null);
$right = "our time is <b>" . date("m/d h:i a") . " " . $timezone . "</b>";
echo getOuterBoxTop($left, $right);
?>
<?
$columnTitlesArray = array ('Pos', 'Player', 'Profile', $colTitle, 'W', 'D', 'L', 'DC', 'Percentage');
$boxTitle = "Sixserver Standings";
?>
<table width="900"><tr><td>
<table class="formtable"><tr><td nowrap>
