} else {
if (!empty($_GET['region'])) {
$region = mysql_real_escape_string($_GET['region']);
}
}
if (!empty($_GET['ladder'])) {
$ladder = mysql_real_escape_string($_GET['ladder']);
}
if (!empty($_GET['type'])) {
$type = mysql_real_escape_string($_GET['type']);
} else {
if (!empty($_POST['type'])) {
$type = mysql_real_escape_string($_POST['type']);
}
}
$version = getVersionForLadder($ladder);
if ($version == 'A') {
$subpage = 'standingsPes4';
}
echo getOuterBoxTop($subNavText . getRaquo() . getSubNavigation($subpage, null), "");
?>
<?
if (!stristr(getSupportedVersions(), $version)) {
echo "<p>The ".$ladder." ladder is unknown or not supported anymore!</P>".$back;
} else {
?>
<table width="80%"><tr><td>
<table class="formtable"><tr><td nowrap>
<form method="post" action="<?php
echo "{$directory}";
function StartLadderSeason()
{
$appRoot = realpath(dirname(__FILE__)) . '/';
require $appRoot . './../variables.php';
require $appRoot . './../variablesdb.php';
require $appRoot . './../functions.php';
$msg = "";
$sql = "SELECT ladders FROM weblm_seasons WHERE season=" . $season;
$result = mysql_query($sql);
$ladder2 = mysql_fetch_array($result)[0];
// set maintenance
$sql = "update {$varstable} set maintenance = 'yes'";
$result = mysql_query($sql);
$version2 = getVersionForLadder('H');
// PES 6
$pointsField2 = getPointsFieldForVersion($version2);
$gamesField2 = getGamesFieldForVersion($version2);
$winsField2 = getWinsFieldForVersion($version2);
$lossesField2 = getLossesFieldForVersion($version2);
$sortby = $pointsField2 . " DESC, percentage DESC, {$lossesField2} ASC";
$sql = "SELECT *, {$winsField2}/{$gamesField2} as percentage FROM {$playerstable} " . "WHERE {$gamesField2} > 0 ORDER BY {$sortby}";
$result = mysql_query($sql);
$pos = 0;
// iterate over players and update history
while ($row = mysql_fetch_array($result)) {
$player_id = $row['player_id'];
$name = $row['name'];
$points = $row[$pointsField2];
$games = $row[$gamesField2];
$wins = $row[$winsField2];
$losses = $row[$lossesField2];
$draws = $row["draws"];
$approved = $row['approved'] == 'yes';
if ($approved) {
$pos++;
$position = $pos;
} else {
$position = 0;
}
$msg .= "<p>" . PHP_EOL;
// goals as winner / 1on1
$games_sql = "SELECT sum(winnerresult) as goals_for, sum(loserresult) as goals_against " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND winner = '{$name}' AND winner2 = '' AND loser2 = '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForWinner1on1 = $games_row['goals_for'];
$msg .= "{$name} goalsForWinner1on1: {$goalsForWinner1on1}<br>" . PHP_EOL;
$goalsAgainstWinner1on1 = $games_row['goals_against'];
$msg .= "{$name} goalsAgainstWinner1on1: {$goalsAgainstWinner1on1}<br>" . PHP_EOL;
$goals_for = $goalsForWinner1on1;
$goals_against = $goalsAgainstWinner1on1;
// goals as winner / 1on2
$games_sql = "SELECT sum(winnerresult) as goals_for, sum(loserresult) as goals_against " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND winner = '{$name}' AND winner2 = '' AND loser2 != '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForWinner1on2 = $games_row['goals_for'];
$msg .= "{$name} goalsForWinner1on2: {$goalsForWinner1on2}<br>" . PHP_EOL;
$goals_for += $goalsForWinner1on2;
$goalsAgainstWinner1on2 = $games_row['goals_against'] / 2;
$msg .= "{$name} goalsAgainstWinner1on2: {$goalsAgainstWinner1on2}<br>" . PHP_EOL;
$goals_against += $goalsAgainstWinner1on2;
// goals as winner / 2on1
$games_sql = "SELECT sum(winnerresult) as goals_for, sum(loserresult) as goals_against " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND (winner = '{$name}' OR winner2 = '{$name}') " . "AND winner2 != '' AND loser2 = '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForWinner2on1 = $games_row['goals_for'] / 2;
$msg .= "{$name} goalsForWinner2on1: {$goalsForWinner2on1}<br>" . PHP_EOL;
$goals_for += $goalsForWinner2on1;
$goalsAgainstWinner2on1 = $games_row['goals_against'];
$msg .= "{$name} goalsAgainstWinner2on1: {$goalsAgainstWinner2on1}<br>" . PHP_EOL;
$goals_against += $goalsAgainstWinner2on1;
// goals as winner / 2on2
$games_sql = "SELECT sum(winnerresult) as goals_for, sum(loserresult) as goals_against " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND (winner = '{$name}' OR winner2 = '{$name}') " . "AND winner2 != '' AND loser2 != '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForWinner2on2 = $games_row['goals_for'] / 2;
$msg .= "{$name} goalsForWinner2on2: {$goalsForWinner2on2}<br>" . PHP_EOL;
$goals_for += $goalsForWinner2on2;
$goalsAgainstWinner2on2 = $games_row['goals_against'] / 2;
$msg .= "{$name} goalsAgainstWinner2on2: {$goalsAgainstWinner2on2}<br>" . PHP_EOL;
$goals_against += $goalsAgainstWinner2on2;
// goals as loser / 1on1
$games_sql = "SELECT sum(winnerresult) as goals_against, sum(loserresult) as goals_for " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND loser = '{$name}' AND loser2 = '' AND winner2 = '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForLoser1on1 = $games_row['goals_for'];
$msg .= "{$name} goalsForLoser1on1: {$goalsForLoser1on1}<br>" . PHP_EOL;
$goals_for += $goalsForLoser1on1;
$goalsAgainstLoser1on1 = $games_row['goals_against'];
$msg .= "{$name} goalsAgainstLoser1on1: {$goalsAgainstLoser1on1}<br>" . PHP_EOL;
$goals_against += $goalsAgainstLoser1on1;
// goals as loser / 1on2
$games_sql = "SELECT sum(winnerresult) as goals_against, sum(loserresult) as goals_for " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND (loser = '{$name}' OR loser2 = '{$name}') AND loser2 != '' AND winner2 = '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForLoser1on2 = $games_row['goals_for'] / 2;
$msg .= "{$name} goalsForLoser1on2: {$goalsForLoser1on2}<br>" . PHP_EOL;
$goals_for += $goalsForLoser1on2;
$goalsAgainstLoser1on2 = $games_row['goals_against'];
$msg .= "{$name} goalsAgainstLoser1on2: {$goalsAgainstLoser1on2}<br>" . PHP_EOL;
$goals_against += $goalsAgainstLoser1on2;
// goals as loser / 2on1
$games_sql = "SELECT sum(winnerresult) as goals_against, sum(loserresult) as goals_for " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND loser = '{$name}' AND loser2 = '' AND winner2 != '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForLoser2on1 = $games_row['goals_for'];
$msg .= "{$name} goalsForLoser2on1: {$goalsForLoser2on1}<br>" . PHP_EOL;
$goals_for += $goalsForLoser2on1;
$goalsAgainstLoser2on1 = $games_row['goals_against'] / 2;
$msg .= "{$name} goalsAgainstLoser2on1: {$goalsAgainstLoser2on1}<br>" . PHP_EOL;
$goals_against += $goalsAgainstLoser2on1;
// goals as loser / 2on2
$games_sql = "SELECT sum(winnerresult) as goals_against, sum(loserresult) as goals_for " . "FROM {$gamestable} " . "WHERE season = '{$season}' AND (loser = '{$name}' OR loser2 = '{$name}') AND loser2 != '' AND winner2 != '' AND deleted = 'no'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$goalsForLoser2on2 = $games_row['goals_for'] / 2;
$msg .= "{$name} goalsForLoser2on2: {$goalsForLoser2on2}<br>" . PHP_EOL;
$goals_for += $goalsForLoser2on2;
$goalsAgainstLoser2on2 = $games_row['goals_against'] / 2;
$msg .= "{$name} goalsAgainstLoser2on2: {$goalsAgainstLoser2on2}<br>" . PHP_EOL;
$goals_against += $goalsAgainstLoser2on2;
$msg .= "</p>" . PHP_EOL;
// aggregate games
$games_sql = "SELECT count(*) as aggregate " . "FROM {$gamestable} " . "WHERE season = '{$season}' " . "AND (loser = '{$name}' or loser2 = '{$name}' or winner ='{$name}' or winner2 = '{$name}') AND deleted = 'no' AND host = 'A'";
$games_result = mysql_query($games_sql);
$games_row = mysql_fetch_array($games_result);
$aggregate = $games_row['aggregate'];
$msg .= "<p>[{$name}] goals for: [{$goals_for}] / " . "goals against: [{$goals_against}] / " . "aggregate: [{$aggregate}]<br>" . PHP_EOL;
$history_sql = "INSERT INTO {$historytable} " . "(id, player_id, player_name, season, ladder, position, points, games, aggregate, wins, " . "losses, draws, goals_for, goals_against) " . "VALUES " . "('', '{$player_id}', '{$name}', '{$season}', '{$ladder2}', '{$position}', '{$points}', '{$games}', '{$aggregate}', " . "'{$wins}', '{$losses}', '{$draws}', '{$goals_for}', '{$goals_against}')";
$msg .= "SQL: [{$history_sql}]<br>" . PHP_EOL;
$history_result = mysql_query($history_sql);
$msg .= "Insert for [{$name}] result [{$history_result}] position [{$position}]</p>" . PHP_EOL;
}
$msg .= "<p>" . $ladder2 . " ladder done!</p>" . PHP_EOL;
$msg .= "<p><hr></p>" . PHP_EOL;
// update players and set games to 0
$update_sql = "UPDATE {$playerstable} SET {$gamesField2} = 0, {$winsField2} = 0, {$lossesField2} = 0, {$pointsField2} = 0, draws = 0";
$result = mysql_query($update_sql);
$msg .= "<p>Set games to 0 - Result [{$result}]<p>" . PHP_EOL;
$msg .= "<p><hr></p>" . PHP_EOL;
// update season var
$update_sql = "UPDATE {$varstable} set season = season + 1";
$result = mysql_query($update_sql);
$msg .= "<p>update season var [{$result}]<p>" . PHP_EOL;
// unset maintenance
$sql = "update {$varstable} set maintenance = 'no'";
$result = mysql_query($sql);
$msg .= "Unset maintenance - Result [{$result}]<p>" . PHP_EOL;
return $msg;
}
} else {
if (!is_numeric($loserresult)) {
$msg .= "<p>Please enter the goals for the loser!</p>";
} else {
if ($loserresult > $winnerresult) {
$msg .= "<p>The loser can't have more goals than the winner!</p>";
}
}
}
}
}
}
}
}
if (empty($msg)) {
$version = getVersionForLadder("PES/WE");
if (!empty($winnername2) || !empty($losername2)) {
// game for team ladder
$pointsField = "teamPoints";
$gamesField = "teamGames";
$winsField = "teamWins";
$lossesField = "teamLosses";
$ladderType = "Team";
} else {
// single ladder
$pointsField = getPointsFieldForVersion($version);
$gamesField = getGamesFieldForVersion($version);
$winsField = getWinsFieldForVersion($version);
$lossesField = getLossesFieldForVersion($version);
$ladderType = "Single";
}
