$formName = '';
$formPasswd = '';
$showMessage = false;
$inactive = false;
$inactiveAndBanned = false;
$loggedIn = false;
$loggingOut = false;
$statemsg = '';
$versionsImages = '';
$msg = '';
$nameClass = '';
$approved = '';
$row = "";
$donator = false;
$timestamp_expire = time() + 14 * 24 * 60 * 60;
$visitorIP = Get_ip();
$cookieSessionId = GetInfo($idcontrol, 'SessionId');
$cookie_name = "";
if (!empty($_GET['key'])) {
$cookieSessionId = mysql_real_escape_string($_GET['key']);
setcookie('SessionId', $cookieSessionId, $timestamp_expire);
}
if (!empty($_POST['form_name'])) {
$formName = mysql_real_escape_string($_POST['form_name']);
}
if (!empty($_POST['form_passwd'])) {
$formPasswd = mysql_real_escape_string($_POST['form_passwd']);
}
if (isset($_GET['action'])) {
if ($_GET['action'] == 'login') {
if (empty($formName)) {
$logJoin = new KLogger('/var/www/yoursite/http/log/join/', KLogger::INFO);
?>
<?= getOuterBoxTop($leaguename. " <span class='grey-small'>»</span> Join League", "") ?>
<?php
$na = "n/a";
$checked = "checked='checked'";
$back = "<p><a href='javascript:history.back()'>go back</a></p>";
$alias = "";
$uploadSpeed = "";
$downloadSpeed = "";
$message = "";
$ip = Get_ip();
$blacklist = false;
$sid = mysql_real_escape_string($_GET['sid']);
// if (date('w') <> 0) {
if ($false) {
echo "<p>Site signups only open on Sundays. <a href=\"/forum/viewtopic.php?t=6776\">Here's why.</a></p>";
echo '<p>You can <a href="http://www.yoursite/forum/ucp.php?mode=register">sign up for the forums</a> while you wait, but a forum account only enables you to post on the forums.</p>';
echo "<p>While you wait until you can sign up for a player account, we highly recommend reading these topics <b>before</b> you sign up:</p>";
echo '<p>- <b><a href="/forum/viewtopic.php?f=3&t=5340" target="_new">How to play PES 6 online on Sixserver</a></b><br>';
echo '- <b><a href="/forum/viewtopic.php?f=3&t=5438" target="_new">Sixserver FAQ</a></b></p>';
} else {
$xml_string = file_get_contents("http://www.stopforumspam.com/api?ip=" . urlencode($ip));
if (!$xml_string) {
$logJoin->logInfo('Could not read http://www.stopforumspam.com/api?ip='.urlencode($ip));
function ReportGame($winnername, $winnername2, $losername, $losername2, $date, $comment, $gameid, $winnerresult, $loserresult, $host, $fairness, $version, $winnerteam, $loserteam, $sixGameId)
{
require 'variables.php';
require 'variablesdb.php';
require_once 'log/KLogger.php';
$log = new KLogger('/var/www/yoursite/http/log/report', KLogger::INFO);
$log->logInfo('Reporting ' . $winnername . ' vs. ' . $losername);
$resultText = "";
$comment = htmlentities($comment);
$comment = nl2br($comment);
if (!empty($winnername2) || !empty($losername2)) {
// game for team ladder
$pointsField = "teamPoints";
$gamesField = "teamGames";
$winsField = "teamWins";
$lossesField = "teamLosses";
$drawsField = "teamDraws";
$teamLadder = 1;
$ladderType = "Team";
} else {
// single ladder
$pointsField = getPointsFieldForVersion($version);
$gamesField = getGamesFieldForVersion($version);
$winsField = getWinsFieldForVersion($version);
$lossesField = getLossesFieldForVersion($version);
$drawsField = "draws";
$teamLadder = 0;
$ladderType = "Single";
}
$row = getRatingAndPointsForPlayer($winnername, $pointsField);
$ratingOldWinner1 = $row["rating"];
$pointsOldWinner1 = $row[$pointsField];
$row = getRatingAndPointsForPlayer($losername, $pointsField);
$ratingOldLoser1 = $row["rating"];
$pointsOldLoser1 = $row[$pointsField];
$type = "1on1";
if (!empty($winnername2)) {
$type = "2on1";
$row = getRatingAndPointsForPlayer($winnername2, $pointsField);
$ratingOldWinner2 = $row["rating"];
$pointsOldWinner2 = $row[$pointsField];
}
if (!empty($losername2)) {
$type = "1on2";
$row = getRatingAndPointsForPlayer($losername2, $pointsField);
$ratingOldLoser2 = $row["rating"];
$pointsOldLoser2 = $row[$pointsField];
}
if (!empty($winnername2) && !empty($losername2)) {
$type = "2on2";
}
if ($winnerresult - $loserresult == 0) {
$isDraw = 1;
$winLoss = 0;
$sqlDraw = " " . $drawsField . " = " . $drawsField . " + 1, totaldraws = totaldraws + 1, ";
$addWinOrDefeat = 0;
} else {
$isDraw = 0;
$winLoss = 1;
$sqlDraw = "";
$addWinOrDefeat = 1;
}
$calc = calculateGamePointsReportGame($winnername, $winnername2, $losername, $losername2, $winnerresult, $loserresult, $winnerteam, $loserteam, $ratingOldWinner1, $ratingOldWinner2, $ratingOldLoser1, $ratingOldLoser2, $pointsOldWinner1, $pointsOldWinner2, $pointsOldLoser1, $pointsOldLoser2, $type, $isDraw, $comment, $sixGameId);
$ratingdiff = $calc["ratingdiff"];
$ra2newwinneradd = $calc["addPointsWinner"];
$ra2newloserremL1 = $calc["removePointsLoser1"];
$ra2newloserremL2 = $calc["removePointsLoser2"];
$ra2newwinner = $calc["pointsNewWinner1"];
$ra2newwinner2 = $calc["pointsNewWinner2"];
$ra2newloser = $calc["pointsNewLoser1"];
$ra2newloser2 = $calc["pointsNewLoser2"];
$teamBonusWinner = $calc["teamBonusWinner"];
$message = $calc["message"];
echo $message;
// $log->logInfo('ra2newwinneradd: '.$ra2newwinneradd);
// $log->logInfo('ra2newwinner: '.$ra2newwinner);
// $log->logInfo('ra2newloser: '.$ra2newloser);
if (strlen($comment) > 256) {
$comment = substr($comment, 0, 255);
}
$comment = mysql_real_escape_string($comment);
$dateday = date("d/m/Y");
$ip = Get_ip();
$deleted = "no";
$sql = "UPDATE {$playerstable} " . " SET {$lossesField} = {$lossesField} + {$winLoss}, totallosses = totallosses + {$winLoss}, " . "{$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . $sqlDraw . "streakwins = 0, " . "streaklosses = streaklosses + {$winLoss}, " . "rating = rating - {$ratingdiff}, " . "{$pointsField} = {$ra2newloser} " . "WHERE name='{$losername}'";
$log->logInfo('sql: ' . $sql);
$res = mysql_query($sql);
$result = $res;
$log->logInfo('result: ' . $result);
$sql = "UPDATE {$playerstable} " . " SET {$winsField} = {$winsField} + {$winLoss}, totalwins = totalwins + {$winLoss}, {$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "streakwins = streakwins + {$winLoss}, " . "streaklosses = 0, " . $sqlDraw . "rating = rating + {$ratingdiff}, " . "{$pointsField} = {$ra2newwinner} " . "WHERE name='{$winnername}'";
$log->logInfo('sql: ' . $sql);
$res = mysql_query($sql);
$result = $result + $res;
$log->logInfo('result: ' . $result);
if (!empty($losername2)) {
$sql = "UPDATE {$playerstable} " . " SET {$lossesField} = {$lossesField} + {$winLoss}, totallosses = totallosses + {$winLoss}, " . "{$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "streakwins = 0, " . "streaklosses = streaklosses + {$winLoss}, " . $sqlDraw . "rating = rating - {$ratingdiff}, " . "{$pointsField} = {$ra2newloser2} " . "WHERE name='{$losername2}'";
$log->logInfo('sql: ' . $sql);
$res = mysql_query($sql);
$result = $result + $res;
$log->logInfo('result: ' . $result);
// echo "<p>".$sql." - <b>$res</b></p>";
}
if (!empty($winnername2)) {
$sql = "UPDATE {$playerstable} " . " SET {$winsField} = {$winsField} + {$winLoss}, totalwins = totalwins + {$winLoss}, {$gamesField} = {$gamesField} + 1, " . "totalgames = totalgames + 1, " . "streakwins = streakwins + {$winLoss}, " . "streaklosses = 0, " . $sqlDraw . "rating = rating + {$ratingdiff}, " . "{$pointsField} = {$ra2newwinner2} " . "WHERE name='{$winnername2}'";
$log->logInfo('sql: ' . $sql);
$res = mysql_query($sql);
$result = $result + $res;
$log->logInfo('result: ' . $result);
// echo "<p>".$sql." - <b>$res</b></p>";
}
if (is_null($sixGameId)) {
$sql = "INSERT INTO {$gamestable} " . "(isDraw, winner, winner2, loser, loser2, date, winnerresult, loserresult, comment, " . "dateday, winpoints, losepoints, losepoints2, ratingdiff, ip, deleted, " . "host, season, fairness, version, winnerteam, loserteam, teamBonus, teamLadder) " . "VALUES ('{$isDraw}', '{$winnername}', '{$winnername2}', '{$losername}', '{$losername2}', '{$date}', '{$winnerresult}', '{$loserresult}', '{$comment}', " . "'{$dateday}', '{$ra2newwinneradd}', '{$ra2newloserremL1}', '{$ra2newloserremL2}', '{$ratingdiff}', '{$ip}', '{$deleted}', '{$host}', " . "'{$season}', '{$fairness}', '{$version}', '{$winnerteam}', '{$loserteam}', '{$teamBonusWinner}', '{$teamLadder}')";
} else {
$sql = "INSERT INTO {$gamestable} " . "(isDraw, winner, winner2, loser, loser2, date, winnerresult, loserresult, comment, " . "dateday, winpoints, losepoints, losepoints2, ratingdiff, ip, deleted, " . "host, season, fairness, version, winnerteam, loserteam, teamBonus, teamLadder, sixGameId) " . "VALUES ('{$isDraw}', '{$winnername}', '{$winnername2}', '{$losername}', '{$losername2}', '{$date}', '{$winnerresult}', '{$loserresult}', '{$comment}', " . "'{$dateday}', '{$ra2newwinneradd}', '{$ra2newloserremL1}', '{$ra2newloserremL2}', '{$ratingdiff}', '{$ip}', '{$deleted}', '{$host}', " . "'{$season}', '{$fairness}', '{$version}', '{$winnerteam}', '{$loserteam}', '{$teamBonusWinner}', '{$teamLadder}', '{$sixGameId}')";
}
$log->logInfo('sql: ' . $sql);
$res = mysql_query($sql);
$result = $result + $res;
$log->logInfo('result: ' . $result);
if ($result > 2) {
$resultText .= "<p>Your game was successfully reported for the " . $ladderType . " Ladder.</p>";
} else {
$resultText .= "<p>There seems to be a problem with the database, your game has not been reported.</p>" . "<p>Please contact an admin if the problem persists.</p>" . "<p>Error code: <b>{$result}</p>";
}
echo $resultText;
return $result;
}
