} 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;
while ($num >= $cur) {
$row = mysql_fetch_array($result);
$name = $row["name"];
$approved = $row["approved"];
$id = $row['player_id'];
$nameClass = colorNameClass($name, $approved);
$alias = $row["alias"];
$forum = $row["forum"];
$versions = $row["versions"];
$joined = FormatDate($row["joindate"]);
if ($forum == "[none]") {
$forum = "";
}
$mail = $row["mail"];
if ($mail == "n/a" || empty($mail)) {
$mailaddress = "n/a";
$mailpic = "";
}
<?php
$sql = "SELECT six_profiles.points, six_profiles.name as profileName, six_profiles.id AS profileId, six_profiles.rank, " . "weblm_players.name AS playerName, weblm_players.nationality, weblm_players.approved FROM six_profiles " . "LEFT JOIN weblm_players ON weblm_players.player_id=six_profiles.user_id " . "WHERE weblm_players.approved='yes' " . "ORDER BY six_profiles.points DESC, playerName ASC LIMIT 0,10";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
$compteur = 1;
$col = "color:#555555";
$oldPoints = -1;
while (10 >= $compteur) {
$row = mysql_fetch_array($result);
if (!empty($row["nationality"])) {
$nationality = $row["nationality"];
} else {
$nationality = 'No country';
}
$name = $row['playerName'];
$nameClass = colorNameClass($name, $row['approved']);
$points = $row['points'];
$profileId = $row['profileId'];
$wins = GetSixserverWins($profileId);
$losses = GetSixserverLosses($profileId);
$draws = GetSixserverDraws($profileId);
$pos = "";
if ($oldPoints != $points) {
$pos = $compteur;
$oldPoints = $points;
}
echo "<tr style='height:19px;'>";
if (!empty($row)) {
echo "<td style='text-align:right;cursor:hand;'>" . $pos . ".</td>";
echo "<td><img src='{$directory}/flags/{$nationality}.bmp' width='18' height='15' border='1'></td>";
echo "<td width='180' {$nameClass} style='white-space:nowrap;'><a href='{$directory}/profile.php?name={$name}' title='view profile'>{$name}</a> <span style='cursor:help;' class='darkgrey-small' title='server profile'>(" . $row['profileName'] . ")</span></td>";
<td width="50%" align="center" valign="top">
<?php
echo getBoxTop("Hall of Fame", "", false, null);
?>
<table><tr><td>
<table>
<?
arsort($overall);
$cur = 1;
$pos = 1;
$oldpoints = "";
foreach ($overall as $currentname => $player_array) {
$player_sql = "SELECT approved from $playerstable where name = '$currentname'";
$player_row = mysql_fetch_array(mysql_query($player_sql));
$nameClass = colorNameClass($name, $player_row['approved']);
$points = $player_array['points'];
$seasonpos = $player_array['seasonpos'];
if ($points != $oldpoints) {
$pos = $cur;
}
else {
$pos = "";
}
$oldpoints = $points;
$cur++;
$points = $player_array['points'];
if ($points == 1) {
$pts = "pt";
}
else {
function GetBottomLine($isSixserver) {
require('variables.php');
require('variablesdb.php');
$players = "";
$type = "";
if ($isSixserver) {
$sql = "SELECT season FROM six_stats";
$row = mysql_fetch_array(mysql_query($sql));
$sixSeason = $row[0];
$oldseason = $sixSeason-1;
$type = "Sixserver";
$sql = "SELECT wp.name as player_name FROM six_history sh ".
"LEFT JOIN weblm_players wp ON sh.playerId=wp.player_id ".
"where sh.season=". $oldseason ." AND sh.position=1";
} else {
$oldseason = $season-1;
$type = "Ladder";
$sql = "SELECT player_name from $historytable where season=". $oldseason ." AND position=1";
}
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$name = $row['player_name'];
$sql = "select approved from $playerstable where name = '$name'";
$playerresult = mysql_query($sql);
$playerrow = mysql_fetch_array($playerresult);
$approved = $playerrow["approved"];
$nameClass = colorNameClass($name, $approved);
}
$players .= "$type Season $oldseason: <span $nameClass><a style='text-decoration: none;' href='$directory/profile.php?name=$name' title='view profile'>$name</a></span>";
// team ladder - player
$sql = "SELECT playerId from $teamladdertable where type='player' ORDER BY timestamp DESC LIMIT 0, 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$playerIdSaved = $row["playerId"];
$playerName = getPlayerNameForId($playerIdSaved);
}
$players .= " - Team Standings leader: ".getPlayerLinkId($playerName, $playerIdSaved);
// team ladder - team
$sql = "SELECT playerId, playerId2 from $teamladdertable where type='team' ORDER BY timestamp DESC LIMIT 0, 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$playerIdSaved = $row["playerId"];
$playerName = getPlayerNameForId($playerIdSaved);
$playerId2Saved = $row["playerId2"];
$player2Name = getPlayerNameForId($playerId2Saved);
}
$players .= " - Best Team: ".getPlayerLinkId($playerName, $playerIdSaved);
$players .= '<span class="grey-small">–</span>';
$players .= getPlayerLinkId($player2Name, $playerId2Saved);
if ($oldseason > 0) {
$title_left = '<span style="font-size:10px;color:#000000">'.
"<a style='text-decoration:none;font-weight:bold' href='champions.php'>Champions</a> - ".
"<span style='font-size:10px;font-weight:normal;text-decoration: none;'>". $players.
"</span></span>";
}
return $title_left;
}
$msg .= "<br>";
}
$rowDonator = mysql_fetch_array($result);
$donatorName = $rowDonator['name'];
$donatedAgo = formatAgoSpan($rowDonator['lastUpdatedTS']);
$sql = "SELECT player_id from weblm_players WHERE name='" . $donatorName . "'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
$donatorName = '<a href="/profile.php?name=' . $rowDonator['name'] . '">' . $rowDonator['name'] . "</a>";
} else {
$donatorName = '<b>' . $rowDonator['name'] . "</b>";
}
$msg .= '<table align="center"><tr>' . '<td><img style="vertical-align:middle;" src="/gfx/awards/donator.gif" /></td>' . '<td class="darkgrey-small"><a href="/donate.php">Latest donation</a> by <b>' . $donatorName . '</b> (' . $donatedAgo . ' ago)</td>' . '</tr></table>';
}
$approved = $row['approved'];
$nameClass = colorNameClass($cookie_name, $approved);
if ($approved == 'no') {
$inactive = true;
$sql = "SELECT * FROM {$playerstatustable} WHERE type = 'B' and active = 'Y' and userName = '******'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0) {
$inactiveAndBanned = true;
}
}
$sql = "SELECT * FROM {$donationstable} WHERE name='{$cookie_name}'";
$result = mysql_query($sql);
if (mysql_num_rows($result) > 0 || $cookie_name == 'Ike') {
$donator = true;
}
$time = time();
$sql = "INSERT INTO {$logtable} (user, ip, accesstime, logType) VALUES ('{$cookie_name}', '{$visitorIP}', '{$time}', 'W')";
<?
$joinLinksArray[] = array('./players.php', 'show_players', 'show all players');
echo getBoxTop("New Players", $boxheight, false, $joinLinksArray); ?>
<table>
<?
$sql="SELECT * FROM $playerstable where approved ='yes' ORDER BY joindate DESC LIMIT 0, 10";
$result = mysql_query($sql);
$compteur = 1;
while (10 >= $compteur) {
$row = mysql_fetch_array($result);
$name = $row["name"];
$alias = $row["alias"];
$platform = $row["platform"];
$approved = $row["approved"];
$nameClass = colorNameClass($name, $approved, $platform);
if (!empty($row["nationality"])) {
$nationality = $row["nationality"];
} else {
$nationality = 'No country';
}
$joined = formatDate($row['joindate']);
echo "<tr>";
echo "<td nowrap><span class='size11'>".$joined."</span> </td>";
echo "<td nowrap><img src='$directory/flags/$nationality.bmp' border='1' title='$nationality'></td>";
if (!empty($alias)) {
$showalias = " (aka $alias)";
}
