$sql = "SELECT sh.*, wp.name AS playerName, wp.nationality, sp.name AS profileName FROM six_history sh ".
"LEFT JOIN weblm_players wp ON wp.player_id = sh.playerId ".
"LEFT JOIN six_profiles sp ON sp.id = sh.profileId ".
"WHERE sh.season=$seasonLadder ".
"AND position=0 ".
"ORDER BY sh.points DESC";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
}
if ($num > 0) {
$columnTitlesArray = array ('Player', 'Profile', 'Points', 'W', 'D', 'L', 'DC', 'Percentage');
$boxTitle = "Inactive at season end";
echo '<table width="900"><tr><td>';
?>
<?= getRankBoxTop($boxTitle, $columnTitlesArray) ?>
<?
$cur = 1;
$oldPos = -1;
while ($row = mysql_fetch_array($result)) {
$name = $row["playerName"];
$profileName = $row['profileName'];
$points = $row['points'];
$games = $row["games"];
$wins = $row["wins"];
$draws = $row["draws"];
$losses = $row["losses"];
$dc = $row["DC"];
$nationality = $row["nationality"];
$subpage = "voters";
require '../variables.php';
require '../variablesdb.php';
require '../functions.php';
require './functions.php';
require '../top.php';
$columnTitlesArray = array('Pos', 'Player', 'Votes');
?>
<?php
echo getOuterBoxTop($subNavText . getRaquo() . getSubNavigation($subpage, null), "");
?>
<table width="100%">
<tr><td width="50%">
<?php
echo getRankBoxTop("Voters", $columnTitlesArray);
?>
<?
$sql = "SELECT count( v.id ) AS count, p.name ".
"FROM $votestable v ".
"LEFT JOIN $playerstable p ON v.player_id = p.player_id ".
"GROUP BY v.player_id ".
"ORDER BY count DESC";
$result = mysql_query($sql);
$i = 0;
$oldCount = "";
while ($row = mysql_fetch_array($result)) {
$i++;
$name = $row['name'];
$count = $row['count'];
} else {
$whereClause = "WHERE type != 'I'";
$statusLinks[] = array('playerStatus.php?mode=inactive', 'show_inactive', 'show inactive');
$limit = " LIMIT 0, 200";
}
if (!empty($selectId)) {
$whereClause .= " AND userId=".$selectId;
}
$sql = "SELECT * FROM $playerstatustable $whereClause ORDER BY 'date' DESC, id DESC $limit";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
$playerStatusArray = array('Player', 'Type', 'Active', 'Date', 'Expiry', 'Reason');
?>
<?php
echo getRankBoxTop("Player Status", $playerStatusArray);
?>
<?
while ($row = mysql_fetch_array($result)) {
$name = $row['userName'];
$expireDate = $row['expireDate'];
if (!empty($expireDate)) {
$expireDate = $expireDate + (60*60*24);
$expireDaysFormatted = formatShortDate($expireDate) ." 12:05 am";
} else {
$expireDaysFormatted = "";
}
$forumLink = $row['forumLink'];
require '../variables.php';
require '../variablesdb.php';
require '../functions.php';
require '../top.php';
$page = "leagues";
$subpage = "leagues";
?>
<?php
echo getOuterBoxTop($leaguename . " <span class='grey-small'>»</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>';
}
</td>
</tr>
<?php
$sql = "SELECT * FROM {$playerstable} {$whereclause} ORDER BY {$sortby} LIMIT 0,200";
$result = mysql_query($sql);
$yo = mysql_num_rows($result);
if ($yo == 0) {
echo "<tr><td><p>No matches found.</p></td></tr></table>";
} else {
?>
</table>
<br>
<? $columnsArray = array("ID", "Joined", "Nation", "Location", "Name", "Alias", "Games", "ICQ", "MSN", "AIM", "Group"); ?>
<?php
echo getRankBoxTop("Players", $columnsArray);
?>
<?
if (! empty($_GET['finishplayers'])) {
$finishplayers = mysql_real_escape_string($_GET['finishplayers']);
} else {
$finishplayers = $finishnumber;
}
$sql = "SELECT * FROM $playerstable $whereclause ORDER BY $sortby LIMIT 0,200";
if ($paging) {
$sql = $sql . " LIMIT $startplayers, $finishplayers";
}
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$cur = 1;
}
$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"];
$loserresult = $row["loserresult"];
$winpoints = $row["winpoints"];
$losepoints = $row["losepoints"];
$losepoints2 = $row["losepoints2"];
$date = $row["date"];
</td>
<td style="text-align:right"><b><?php
echo $streak;
?>
</b></td>
</tr>
<? } ?>
<?php
echo getRankBoxBottom();
?>
<? $columnsArray = array('Pos','Begin', 'End', 'Streak'); ?>
<?php
echo getRankBoxTop("Losing Streaks", $columnsArray);
?>
<?
$pos = 1;
$currentStreak = "";
foreach ($loseStreakArray as $winItem => $item) {
$streak = $item[0];
if (strcmp($streak, $currentStreak) == 0) {
$posDisplay = ".";
} else {
$posDisplay = $pos;
$currentStreak = $streak;
}
$pos++;
?>
<tr class="row">
?>
</td>
<td style="width:14%; text-align:right;"><b><?php
echo $games;
?>
</b></td>
</td>
</tr>
<? } ?>
<?php
echo getRankBoxBottom();
?>
<? $columnsArray = array('Pos','', 'Team', 'W', 'D', 'L', 'Ratio'); ?>
<?php
echo getRankBoxTop("Winning percentage against <span style='font-weight:normal;font-size:9px;'>(teams with 3+ games)</span>", $columnsArray);
?>
<?
$percArray = array();
$pos = 1;
foreach ($opponentTeamsArray as $team => $valArray) {
$games = $valArray[0];
$wins = $valArray[1];
$losses = $valArray[2];
$draws = $valArray[3];
if ($games > 2) {
$valArray[0] = ($wins/$games)*100;
$percArray[$team] = $valArray;
}
}
} else {
$condition = "";
}
}
}
if ($region == "WE9I") {
$sql = "SELECT *, {$winsField}/{$gamesField} as percentage FROM {$playerstable} " . " WHERE approved='yes' AND defaultversion='G' ORDER BY {$sortby}";
} else {
$sql = "SELECT *, {$winsField}/{$gamesField} as percentage FROM {$playerstable} " . "WHERE {$gamesField} > 0 {$condition} AND approved='yes' ORDER BY {$sortby}";
}
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if ($num > 0) {
$columnTitlesArray = array('Pos', 'Player', 'Points', 'W', 'D', 'L', 'Percentage', 'Streak');
$boxTitle = $region . " Single Standings - Season " . $season;
echo getRankBoxTop($boxTitle, $columnTitlesArray);
?>
<?
$cur = 1;
while ($row = mysql_fetch_array($result)) {
$showplayer = true;
$percentage = $row["percentage"];
$name = $row["name"];
$mail = $row["mail"];
$icq = $row["icq"];
$aim = $row["aim"];
$nationality = $row["nationality"];
$approved = $row["approved"];
<? $columnsArray = array('Id', 'Added', 'Player', '', '', 'Result', '', '', 'Player'); ?>
<?
$sql = "SELECT * from $leaguegamestable where league=$id order by id DESC";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$playedGames = " <span style='font-weight:normal;font-size:10px;'>(".$num." games played)</span>";
?>
<a name="games" /><br></td>
<td style="text-align:right;vertical-align:top"><a href="#standings">Standings ↑ </a><br />
<a href="#games">Games ↓ </a></td>
</tr>
<tr>
<td>
<?php
echo getRankBoxTop($leagueShortName . " Games - List " . $status . $playedGames, $columnsArray);
?>
<?
while ($row = mysql_fetch_array($result)) {
$id = $row['id'];
$winteam = $row['winteam'];
$loseteam = $row['loseteam'];
$winresult = $row['winresult'];
$loseresult = $row['loseresult'];
$reportDate = $row['reportDate'];
$dateFormatted = formatLongDate($reportDate);
$winnerImg = getImgForTeam($winteam);
$loserImg = getImgForTeam($loseteam);
$winnerTeamname = getTeamNameForId($winteam);
$loserTeamname = getTeamNameForId($loseteam);
<tr style="height:30px;">
<td><?
echo "<b>$date - $title</b> <span class='grey-small'>(posted by $user)</span>";
?></td>
</tr>
<tr>
<td><?php echo"$news" ?></td>
</tr>
</table>
<?= getBoxBottom() ?>
<?
}
?>
<?= getRankBoxTop("News List", array('View', 'Edit', 'Delete', 'Title')) ?>
<?php
$sortby = "news_id DESC";
$start = "0";
$finish = "100000";
$sql="SELECT * FROM $newstable ORDER BY $sortby LIMIT $start, $finish";
$result=mysql_query($sql,$db);
$num = mysql_num_rows($result);
$cur = 1;
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$date = $row["date"];
$title = $row["title"];
$user = $row['user'];
$read = $row["news_id"];
<tr width="100%">
<td width="90%"><?php
echo $approveMsg;
?>
</td>
<td width="10%" align="right" valign="middle">
<input type="Submit" name="submit" value="Submit" class="width200">
</td>
</tr>
</table>
<?php
echo getBoxBottom();
?>
<?php
echo getRankBoxTop("Unapproved Players", $columnTitlesArray);
?>
<?
$backSpan = 60*60*24*14;
$sql = "SELECT * from $playerstable where approved='no' AND signupSent=0 AND rejected=0 and UNIX_TIMESTAMP() - joindate < $backSpan ".
"ORDER BY joindate ASC limit 0, 20";
$result = mysql_query($sql);
// iterate over players
$count = 0;
while($row = mysql_fetch_array($result)) {
$player_id = $row['player_id'];
}
else if ($show == 'none') {
$sql .= " ORDER BY player_id DESC";
}
else {
$sql .= " ORDER BY player_id DESC LIMIT 0, 100";
}
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if ($num > 0) {
$columnTitlesArray = array('Id', 'Nat.', 'Loc.', 'Versions', 'Name', 'Alias', 'Games', 'Joined');
?>
<?= getRankBoxTop("Players List", $columnTitlesArray) ?>
<?
$cur = 1;
while ($row = mysql_fetch_array($result)) {
$id = $row['player_id'];
$nationality = $row['nationality'];
$country = $row['country'];
$name = $row['name'];
$nameClass = colorNameClass($name, $row['approved']);
$alias = $row['alias'];
$games = $row['totalgames'];
$joined = formatDate($row['joindate']);
$versionsImg = getVersionsImages($row['versions']);
?>
$sql = "SELECT * FROM $playerstable " .
"WHERE totalgames > 0 " .
"$approved " .
"ORDER BY $sortby $limit";
$col2_name = "Player";
}
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$cur = 1;
$columnsArray = array('Position', $col2_name, $col3_name);
?>
<?php
echo getRankBoxTop("", $columnsArray);
?>
<?
if ($offense) {
$entriesArray = array();
while ($row = mysql_fetch_array($result)) {
$name = $row['name'];
$totalgames = $row['totalgames'];
// goals as winner
$games_sql = "SELECT sum(winnerresult) as goals_for ".
"FROM $gamestable " .
"WHERE winner = '$name' AND deleted = 'no'";