} 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)"; }