$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'";