} 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"; }