function ReportToLadder($matchId, $teamLeft, $teamRight, $winner1, $winner2, $loser1, $loser2, $scoreLeft, $scoreRight, $scoreLeftExt, $scoreRightExt, $patchId, $log, $finished)
{
// Settings correct?
$sql = "SELECT matchTime FROM six_matches_info WHERE matchId={$matchId} AND type=";
if ($finished) {
$sql .= "'F'";
} else {
$sql .= "'U'";
}
$log->logInfo('ReportToLadder: sql=' . $sql);
$matchTime = 1;
$res = mysql_query($sql);
if ($row = mysql_fetch_array($res)) {
$matchTime = $row['matchTime'];
$log->logInfo('ReportToLadder: six_matches_info.matchTime=' . $matchTime);
}
if ($matchTime != 1) {
$log->logInfo('ReportToLadder: Not reporting match #' . $matchId . ' - MatchTime is set to ' . $matchTime);
} else {
// new match -> save the old one
$winnerTeam = 0;
$loserTeam = 0;
// teams known?
$sql = "SELECT st.ladderTeamId FROM six_teams st " . "WHERE st.patchId=" . $patchId . " AND st.sixTeamId=" . $teamLeft;
$log->logInfo('ReportToLadder: sql=' . $sql);
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
$row = mysql_fetch_array($res);
$winnerTeam = $row[0];
}
$sql = "SELECT st.ladderTeamId FROM six_teams st " . "WHERE st.patchId=" . $patchId . " AND st.sixTeamId=" . $teamRight;
$log->logInfo('ReportToLadder: sql=' . $sql);
$res = mysql_query($sql);
if (mysql_num_rows($res) > 0) {
$row = mysql_fetch_array($res);
$loserTeam = $row[0];
}
$commentSuffix = "";
if ($scoreLeftExt > $scoreLeft || $scoreRightExt > $scoreRight) {
$commentSuffix = " (score after regular time)";
}
if ($finished) {
$commentPrefix = "Sixserver Game";
} else {
$commentPrefix = "Unfinished Sixserver Game";
}
$gamesplayedplayer = 0;
$gamesmaxdayplayer = 6;
if (empty($winner2) && empty($loser2)) {
// check max. games
$dateday = date("d/m/Y");
$sql = "SELECT game_id FROM weblm_games " . "WHERE ((winner = '{$winner1}' and loser = '{$loser1}') OR (winner = '{$loser1}' and loser = '{$winner1}')) " . "AND deleted='no' and dateday = '{$dateday}'";
$result = mysql_query($sql);
$gamesplayedplayer = mysql_num_rows($result);
}
$log->logInfo("ReportToLadder: matchId=" . $matchId . " winner1=" . $winner1 . " loser1=" . $loser1 . " winner2=" . $winner2 . " loser2=" . $loser2 . " teamLeft=" . $teamLeft . " teamRight=" . $teamRight . " scoreLeft=" . $scoreLeft . " scoreRight=" . $scoreRight . " finished=" . $finished);
$log->logInfo("ReportToLadder: gamesmaxdayplayer=" . $gamesmaxdayplayer . " gamesplayedplayer=" . $gamesplayedplayer);
if ($gamesplayedplayer >= $gamesmaxdayplayer) {
$log->logInfo("ReportToLadder: limit reached, not reporting game");
} else {
ReportGame($winner1, $winner2, $loser1, $loser2, time(), $commentPrefix . ' #' . $matchId . $commentSuffix, null, $scoreLeft, $scoreRight, 'B', 5, 'H', $winnerTeam, $loserTeam, $matchId);
}
}
if ($finished) {
$sql = "UPDATE six_matches SET reported=1, played_on=played_on WHERE id=" . $matchId;
} else {
$sql = "UPDATE six_matches_status SET reported=1, updated=updated WHERE id=" . $matchId;
}
$log->logInfo("ReportToLadder: " . $sql);
$res = mysql_query($sql);
}
$gameid = $row['game_id'];
$timeago = formatAgoSpan($row['date']);
$error.= "<p>A similar draw with the same teams was reported ".$timeago.' ago. Please check <b><a href="/games.php?gameId='.$gameid.
'" target="_blank">Game #'.$gameid.'</a></b> to check if your report is correct, then submit again.</p>';
$drawOverride = true;
}
}
if (empty($error)) {
$replayname = '';
if ($approvegames != "yes") {
$rec = 'no';
$gameid = 'null';
$report = ReportGame($winnername, $winnername2, $losername, $losername2, $date, $comment,
$gameid, $winnerresult, $loserresult, $host,
$fairness, $version, $winnerteamId, $loserteamId, NULL);
if ($report == 3) {
$gamesleft = $gamesmaxday - $gamesplayedday-1;
$gamesplayerleft = $gamesmaxdayplayer - $gamesplayedplayer-1;
updateTeamladders();
if (strlen($comment) < 11) {
echo "<p><b>Your game comment is very short.</b> Please try to make game reports more enjoyable to read and supply a better description of the game next time.</p>";
}
echo "<p>You can play <b>";
echo $gamesleft;
echo "</b> more game(s) today and <b>";
