require './../functions.php';
require './functions.php';
require './../top.php';
$ids = $_POST['ids'];
$rejectIds = $_POST['rejectIds'];
$rejectReasonsText = $_POST['rejectReasonText'];
$rejectReasonsSelect = $_POST['rejectReasonSelect'];
$approveDefault = "<p>Select players to approve.</p>";
$approveMsg = $approveDefault;
$logToday = "log_" . date("Y-m-d") . ".txt";
$logYesterday = "log_" . date("Y-m-d", time() - 60 * 60 * 24) . ".txt";
$boxTitle = 'Approve Players - <a target="_new" href="/log/join/' . $logToday . '">Today\'s log</a> - <a target="_new" href="/log/' . $logYesterday . '">Yesterday\'s log</a>';
?>

<?php 
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Approve Players", "");
?>
<?

if (!$isAdminFull) {
    echo "<p>Access denied.</p>";
} else {

if (sizeof($rejectReasonsSelect) > 0) {
  $approveMsg = "";

  for ($i = 0; $i < sizeof($rejectReasonsSelect); $i++) {
    
    $id = $ids[$i];
    $rejectId = $rejectIds[$i];
    $rejectReasonText = $rejectReasonsText[$i];

    <option value="">(all players)</option>
    <option value=""></option>
    <?php 
echo getPlayersOptionsAllIdSelected($selectId);
?>
    </select>
    &nbsp;&nbsp;<input type="Submit" class="width100" name="submit2" value="Show" /></form>
    </td>
  </tr>
</table>
 <?php 
echo getOuterBoxBottom();
?>

<?php 
echo getOuterBoxTop($left, $right);
?>
<table width="95%"><tr><td>
<?
if (isset($_GET['mode']) && $_GET['mode'] == 'inactive') {
	$inactiveMode = true;
} else {
	$inactiveMode = false;
}

if ($inactiveMode) {
	$whereClause = "WHERE type = 'I'";
	$statusLinks[] = array('playerStatus.php?mode=inactive&amp;limit=no', 'show_all_inactive', 'show all inactive');
	$statusLinks[] = array('playerStatus.php', 'show_warnings_bans', 'show warnings and bans');
	if (isset($_GET['limit'])) {
		$limit = "";		

<?php

// this displays a form to edit a game.
header("Cache-Control: no-cache");
header("Pragma: no-cache");
$page = "editGame";
require './../variables.php';
require './../variablesdb.php';
require './../functions.php';
require './../top.php';
$back = "<p><a href='javascript:history.back()'>go back</a></p>";
$index = "<p><a href='index.php'>go to index</a></p>";
$msg = "";
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Edit Game", "");
?>
<?

if (!$isAdminFull) {
    echo "<p>Access denied.</p>";
} else {

	
	if (!empty($_GET['submit'])) {
		$winnergoals = $_POST['winnergoals'];
		if (empty($winnergoals) && $winnergoals != '0') {
			$msg .= '<p>Error: Winner Goals empty.</p>';
		}
		$losergoals = $_POST['losergoals'];
		if (empty($losergoals) && $losergoals != '0') {
			$msg .= '<p>Error: Loser Goals empty.</p>';
		}

<?php

$page = "recalculatePointsForProfiles";
require '../../variables.php';
require '../../variablesdb.php';
require_once '../functions.php';
require_once './../../functions.php';
require '../../top.php';
$log = new KLogger('/var/www/yoursite/http/log/runonce/', KLogger::INFO);
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Recalculate Points For Profiles", "");
?>
<?

$sql = "SELECT * FROM six_profiles where id=591 ORDER BY Id ASC";
$resultX = mysql_query($sql);
while ($profile = mysql_fetch_array($resultX)) {
  $profileId = $profile['id'];
  $log->logInfo('profileId='.$profileId);
  $log->logInfo('RecalculatePointsForProfile='.RecalculatePointsForProfile($profile['id'], $profile['disconnects'], $profile['points'], $profile['rating']));
  $log->logInfo('RecalculateStreak='.RecalculateStreak($profile['id']));
}

?>
<?php 
echo getOuterBoxBottom();
?>
<?


require ('../../bottom.php');
?>

<?php

require '../variables.php';
require '../variablesdb.php';
require '../functions.php';
require '../top.php';
$page = "leagues";
$subpage = "leagues";
?>

<?php 
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> All Leagues", "");
?>
<table width="70%"><tr><td>
<? $columnsArray = array('Id', '', 'Name', 'Winner', 'Year', 'Status'); ?>
<?php 
echo getRankBoxTop("Leagues", $columnsArray);
?>

<?
$sql = "SELECT wlm.*, wa.profileImage, wp.name FROM weblm_leagues_meta wlm ".
  "LEFT JOIN weblm_awards wa ON wa.leagueId=wlm.leagueId ".
  "LEFT JOIN weblm_players wp ON wp.player_id=wa.playerId ".
  "ORDER BY wlm.leagueId DESC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
  $leagueLink = '<a href="/leagues/league.php?id='.$row['leagueId'].'">'.$row['leagueName'].'</a>';
  if ($row['isActive'] <> 1) {
    $status = '<span class="grey-small">finished</span>';
  } else {
    $status = '<span class="darkgrey-small">ongoing</span>';

<?php

$page = "encrytPasswords";
require '../../variables.php';
require '../../variablesdb.php';
require_once '../functions.php';
require_once './../../functions.php';
require '../../top.php';
$log = new KLogger('/var/www/yoursite/http/log/encrypt/', KLogger::INFO);
$startId = $_GET['id'];
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Encrypt Passwords", "");
?>
<?

$sql = "SELECT player_id, name FROM `weblm_players` where convert(pwd using 'utf8') like 'xxx%'"; 
$res = mysql_query($sql);
echo "<p>".$sql."</p>";
while ($row = mysql_fetch_array($res)) {
  $id = $row['player_id'];
  $name = $row['name'];
  
  $length = 10;

  $randomString = substr(str_shuffle("0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, $length);
  $pwHash = password_hash($randomString, PASSWORD_DEFAULT);
  
  $msg = "<p>id=".$id." randomString=".$randomString." name=".$name."</p>";
  $log->LogInfo($msg);
  
  $sql = "UPDATE weblm_players set pwd='".$pwHash."' WHERE player_id=".$id;
  mysql_query($sql);

<?php

// the rules and information page
header("Cache-Control: no-cache");
header("Pragma: no-cache");
$page = "sitemap";
require 'variables.php';
require 'variablesdb.php';
require 'functions.php';
require 'top.php';
list($pageinfo1, $pageinfo2, $pageinfo3, $pageinfo4, $pageinfo5, $pageinfo6, $pageinfo7, $pageinfo8, $pageinfo9, $pageinfo10, $pageinfo11, $pageinfo12, $pageinfo13, $pageinfo14) = explode("*", $menuorder);
$pageinfos = explode("*", $menuorder);
?>

<?php 
echo getOuterBoxTop($leaguename . getRaquo() . " Sitemap", "");
?>
<p style="padding: 5px 3px 5px 0;">If you forgot where a certain page is or the dynamic menu isn't working for you, this table shows all main and sub menu items. Click the page name 
		to go to the page.</p>
<table border="1" style="width:800px; border-collapse:collapse;">
	<tr>
		
<?
$count = 0;
$tdstyle = 'style="vertical-align:top; border-collapse:collapse; border:1px solid #AAAAAA;  padding: 10px 10px 10px 10px"';
if (!empty($cookie_name) && $cookie_name != 'null') {
	$subs = getSubNavArrayForPage('profile', $cookie_name);
	echo '<td nowrap colspan="4" width="800" '.$tdstyle.'><p><b><a href="/profile.php?name='.$cookie_name.'">My Profile</a></b>'.
		'&nbsp;&nbsp;<span class="grey-small">(only when logged in or by clicking other players name)</span></p><p>';
	foreach ($subs as $sub) {
		$urlFormatted = str_replace($playerDummy, "?name=".$cookie_name, $sub[0]);

require_once('functions.php');

?>
	</td>
</tr>

<tr>
	<td colspan="3">
	<?
    $isSixserver = stristr($_SERVER['PHP_SELF'], "sixserver");
    $title_left = GetBottomLine($isSixserver);
		$title_right = $leaguename.' powered by <a href="https://github.com/IkeC/evo-league">evo-league</a>';
    
	?>
	<?php 
echo getOuterBoxTop($title_left, $title_right);
?>
		<table id="bottom" class="layouttable">
		<tr class="row_bottom">
		<td>
		<b>Last online</b> -
		<?php 
$ago = time() - 60 * 60 * 12;
$sql = "SELECT user, accesstime, ip FROM weblm_log_access WHERE user <>'' AND user <>'Ike' ORDER BY id DESC limit 0,50";
$accessPlayers = array();
$ips = array();
$result = mysql_query($sql);
$bottomLine = "";
while (($row = mysql_fetch_array($result)) && count($accessPlayers) < 8) {
    $user = $row['user'];
    $ip = $row['ip'];

require '../functions.php';
require '../variables.php';
require '../variablesdb.php';
require '../top.php';
if (empty($_GET['nosound'])) {
    $otherversion = '<a href="chat.php?nosound=true">Turn sound off</a>';
} else {
    $otherversion = '<a href="chat.php">Turn sound on</a>';
}
if (!empty($_GET['channel'])) {
    $channel = mysql_real_escape_string($_GET['channel']);
} else {
    $channel = $leaguename;
}
$chatNick = getChatNick();
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Chat", $otherversion);
?>


<p>This chat applet connects you to the IRC channel #<?php 
echo $channel;
?>
 on <a href="http://www.quakenet.org" target="_new">Quakenet</a>.</p>
<p>Not working for you? Select one of the other chat methods from the Chat menu above.</p>

<applet code=IRCApplet.class archive="irc.jar,pixx.jar" width="640" height="400">
    <param name="CABINETS" value="irc.cab,securedirc.cab,pixx.cab">
    
<param name="nick" value="<?php 
echo $chatNick;
?>

<?php

$page = "setSixMatchesNumParticipants";
require '../../variables.php';
require '../../variablesdb.php';
require_once '../functions.php';
require_once './../../functions.php';
require '../../top.php';
$log = new KLogger('/var/www/yoursite/http/log/runonce/', KLogger::INFO);
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Fix NumParticipants", "");
?>
<?

$sql = "SELECT id FROM six_matches WHERE numParticipants=0 ORDER BY Id ASC";
$resultX = mysql_query($sql);
while ($row = mysql_fetch_array($resultX)) {
  $matchId = $row[0];
  $sql = "SELECT COUNT(*) FROM six_matches_played where match_id=$matchId";
  $log->logInfo('matchId='.$matchId.' sql='.$sql);
  $rescount = mysql_query($sql);
  $count = mysql_fetch_array($rescount)[0];
  $sql = "UPDATE six_matches SET numParticipants=$count, played_on=played_on WHERE id=$matchId";
  $log->logInfo('matchId='.$matchId.' sql='.$sql);
  mysql_query($sql);
}

?>
<?php 
echo getOuterBoxBottom();
?>
<?

<?php

// this page allows users to upload tournament schedule images, it's not linked from anywhere!
// the players that are allowed to upload images are defined in weblm_tournaments.uploaders (comma-seperated)
// they need to be logged in to access this page.
// the images are written to the /Cup folder with the name defined in weblm_tournaments.imageFilename,
// make sure web users have write access to your /Cup and /pictures folders!
$page = "uploadTournamentImage";
require '../variables.php';
require '../variablesdb.php';
require '../functions.php';
require '../top.php';
?>

<?php 
echo getOuterBoxTop("Cup Images Upload", "");
?>
 
<table width="50%">
<tr><td>
<?php 
$back = '<p><a href="javascript:history.back()">go back</a></p>';
$contact = "<p>Please contact me at " . $adminmail . " or in the forum if the problem persists." . $back;
if (!$isAdminFull && !$isModFull) {
    echo "<p>Access denied.</p>";
} else {
    if (!empty($_POST['imageSlot'])) {
        $imageSlot = mysql_real_escape_string($_POST['imageSlot']);
        if (stristr($imageSlot, '#')) {
            // slot image
            $slots = explode('#', $imageSlot);

?>
      <img src="<? echo $imgpath ?>" />
	<?php 
echo getBoxBottom();
?>
   <? } ?>
   &nbsp;
    </td></tr></table>
  </td>
 </tr>
</table>
    <?
    
   }
   else {
   	echo getOuterBoxTop("error", "");
   	echo "<p>The player <b>$name</b> could not be found in the database.</p>";
   }
?>

<?php 
echo getOuterBoxBottom();
?>

<?

require('bottom.php');

function GetAwards($player_id, $name) {
  require('variables.php');
  require('variablesdb.php');

<?php

// running this will disable accounts for players that have not played a single game in the last 12 weeks.
// if mail sending is properly configured, the admin will receive a notification email.
// an equal file is in the /cron folder which can be used to run this file automatically every day
// if you can set up a cronjob on your server.
header("Cache-Control: no-cache");
header("Pragma: no-cache");
$page = "pruneUnused";
require './../variables.php';
require './../variablesdb.php';
require_once '../functions.php';
require_once './functions.php';
require './../top.php';
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Prune Unused", "");
?>
<?
if (!$isAdminFull) {
  echo "<p>Access denied.</p>";
} else {

  $disableSpan = 60 * 60 * 24 * 7 * 15; // 15 weeks

  $playersquery = "select distinct winner from $gamestable ".
  "where (UNIX_TIMESTAMP() - date < $disableSpan) "."UNION ".
  "select distinct loser from $gamestable ".
  "where (UNIX_TIMESTAMP() - date < $disableSpan)";

  $result = mysql_query($playersquery);

  $played_array = array ();

        $filter = "";
    }
}
if (!empty($_GET['ago'])) {
    $ago = mysql_real_escape_string($_GET['ago']);
} else {
    if (!empty($_POST['ago'])) {
        $ago = mysql_real_escape_string($_POST['ago']);
    } else {
        $ago = 1;
    }
}
?>

<?php 
echo getOuterBoxTop($leaguename . getRaquo() . " Chatlog", "");
?>

<?
$timespanAgo = 60*60*24*$ago;
$dateString = date('Y_n_j', time()-$timespanAgo);

echo "<p>/var/log/sixserver/sixserver.log.".$dateString."</p>";
EchoFile("/var/log/sixserver/sixserver.log.".$dateString, $filter);
echo "<p>/var/log/sixserver/sixserver.log</p>";
EchoFile("/var/log/sixserver/sixserver.log", $filter);

?>
<?php 
echo getOuterBoxBottom();
?>

<?PHP


// displays the form to post news

$page = "post";

require ('./../../variables.php');
require ('./../../variablesdb.php');
require ('./../../functions.php');
require ('./../functions.php');
require ('./../../top.php');

?>
<?= getOuterBoxTop($leaguename. " <span class='grey-small'>&raquo;</span> Post News", "") ?>
<?


if (!$isAdminFull) {
    echo "<p>Access denied.</p>";
} else {
	if (isset ($_GET['submit'])) {
		$submit = mysql_real_escape_string($_GET['submit']);
	} else {
		$submit = 0;
	}
	if ($submit) {
		if (!empty ($_POST['date'])) {
			$date = mysql_real_escape_string($_POST['date']);
		} else {
			$date = date('d/m/Y');

<?php

header("Cache-Control: no-cache");
header("Pragma: no-cache");
$page = "newSeason";
require './../variables.php';
require './../variablesdb.php';
require './../functions.php';
require './../top.php';
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> FixSixHistory", "");
?>
<?
if (!$isAdminFull) {
  echo "<p>Access denied.</p>";
} else {
  /*
  $sql = "SELECT * FROM six_profiles ORDER BY points DESC";
  $result = mysql_query($sql);
  $checkSeason = 3;
  
  while ($row = mysql_fetch_array($result)) {
    $id = $row['id'];
    $w = GetSixserverWinsForSeason($id, $checkSeason);
    $l = GetSixserverLossesForSeason($id, $checkSeason);
    $d = GetSixserverDrawsForSeason($id, $checkSeason);
    
    $w2 = GetSixserverWinsHistoryForSeason($id, $checkSeason);
    $l2 = GetSixserverLossesHistoryForSeason($id, $checkSeason);
    $d2 = GetSixserverDrawsHistoryForSeason($id, $checkSeason);
    
    if (($w>0 && $w2>0 && $w<>$w2) || ($d>0 && $d2>0 && $d<>$d2) || ($l>0 && $l2>0 && $l<>$l2)) {

<?php

header("Cache-Control: no-cache");
header("Pragma: no-cache");
$page = "getMailAddresses";
require './../variables.php';
require './../variablesdb.php';
require_once '../functions.php';
require_once './functions.php';
require './../top.php';
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Get mail addresses", "");
?>
<?

if (!$isAdminFull) {
  echo "<p>Access denied.</p>";
} else {

	$sql = "SELECT mail, name, player_id, msn from $playerstable  ".
		"where player_id order by player_id asc";
	$result = mysql_query($sql);
	$i = 1;
	$block = 200;
	while($row = mysql_fetch_array($result)) {
		$name = $row['name'];
		$mail = $row['mail'];
		if (!isValidEmailAddress($mail)) {
			$mail = $row['msn'];
		}
		if (!isValidEmailAddress($mail)) {
			// echo "<p>Invalid mail address for [$player_id] $name: $mail</p>";

<?php

$page = "populateGoals";
require '../../variables.php';
require '../../variablesdb.php';
require_once '../functions.php';
require_once './../../functions.php';
require_once './../../files/functions.php';
require '../../top.php';
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Populate New", "");
?>
<?


$goalsDir = "./../../files/goals/";
$thumbsDir = "./../../files/goals/thumbnails/";

$filesList = getAllFiles($goalsDir);

$filesListRev = array ();

foreach ($filesList as $fileArray) {
	if (!is_dir($fileArray[0])) {
		$filesListRev[] = array (
			$fileArray[1],
			$fileArray[0]
		);
	}
}

$fullList = $filesListRev;

	$whereclause = str_replace("and ".$not_deleted, "", $whereclause);
	$whereclause = str_replace("WHERE ".$not_deleted, "", $whereclause);
	
	if (substr($whereclause,1,3) == 'AND') {
		$whereclause = "WHERE".substr($whereclause,4);
	}

	$sql="SELECT * FROM $gamestable $whereclause ORDER BY $sortby LIMIT $startplayed, $finishplayed";

	$result = mysql_query($sql);
	$num = mysql_num_rows($result);
	$cur = 1;
}
	?>

	<?= getOuterBoxTop($navLine, $navRight) ?>
	<table width="100%" style="padding-bottom:5px">
	<tr><td><p><?= $msgRes ?></p></td></tr></table>
<? if ($yo > 0 || $yo_deleted > 0) { ?>
	<? $columnsArray = array('Id', 'Season', 'Game', 'Date', 'Pt+', 'Winner', 'WT', 'Result', 'LT', 'Loser', 'Pt-', 'Comment'); ?>
	<?= getRankBoxTop("Games", $columnsArray); ?>
	<?
	
	while ($num >= $cur) {
    $row = mysql_fetch_array($result);
    $gameid = $row["game_id"];
    $winner = $row["winner"];
    $winner2 = $row["winner2"];
    $loser = $row["loser"];
    $loser2 = $row["loser2"];
    $winnerresult = $row["winnerresult"];

<?php

// displays the game reporting page if the user is logged in.
// the actual point calculation and database update is done in /functions.php#ReportGame
$page = "reportMini";
require '../variables.php';
require '../variablesdb.php';
require '../functions.php';
require '../top.php';
$back = "<p><a href='javascript:history.back()'>Go back</a></p>";
?>

<?php 
echo getOuterBoxTop($leaguename . " <span class='grey-small'>&raquo;</span> Report Mini Tournament", "");
?>
<table class="layouttable">
  <tr><td style="width:60%;horizontal-align:right;">
<?


if (!$isAdminFull && !$isModFull) {
	echo "<p>Access denied.</p>";
} else {
	if (!empty($_GET["submit"])) {
		$playerName = mysql_real_escape_string($_POST["playerName"]);
		$forumLink = mysql_real_escape_string($_POST["forumLink"]);
		if (empty($playerName)) {
			echo doParagraph("Please enter the winner name.".$back);
		} else if (empty($forumLink)) {
			echo doParagraph("Please enter the link to the tournament thread.".$back);
		} else {