$seasonSel = "";
$sql = "SELECT season FROM six_stats";
$row = mysql_fetch_array(mysql_query($sql));
$sixSeason = $row[0];
$seasonLadder = 0;
if (isset($_POST['seasonLadder'])) {
$seasonLadder = mysql_real_escape_string($_POST['seasonLadder']);
} elseif (isset($_GET['seasonLadder'])) {
$seasonLadder = mysql_real_escape_string($_GET['seasonLadder']);
} else {
$seasonLadder = $sixSeason-1;
}
?>
<?= getOuterBoxTop($subNavText.getRaquo().getSubNavigation($subpage, null), "") ?>
<table width="80%">
<tr><td>
<table class="formtable"><tr><td nowrap>
<form method="post" action="<?= $_SERVER['PHP_SELF'] ?>">
<select class="width250" name="seasonLadder">
<option value="">[Select Season]</option>
<?= $seperator ?>
<?
$sql= "SELECT * from six_seasons WHERE season < $sixSeason ORDER BY season DESC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$beginDate = $row['begindate'];
$endDate = $row['enddate'];
$seasonCurrent = $row['season'];
$rowspan2 = 'rowspan="2"';
$box1Img = "8.jpg";
$box1Align = "left bottom";
$box2Img = "2.jpg";
$box2Align = "left bottom";
$box3Img = "5.jpg";
$box3Align = "left center";
$box4Img = "9.jpg";
$box4Align = "left center";
$sql = "SELECT six_seasons.begindate, six_seasons.enddate, six_stats.season from six_seasons LEFT JOIN six_stats ON six_seasons.season=six_stats.season " . "WHERE six_seasons.season=six_stats.season";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$begindate = $row['begindate'];
$enddate = $row['enddate'];
$sixSeason = $row['season'];
$left = $subNavText . getRaquo() . getSubNavigation($subpage, null);
$right = '<span class="black-small">Sixserver Season ' . $sixSeason . ' (' . $begindate . ' - ' . $enddate . ')</span>';
$sql = "SELECT * FROM {$newstable} ORDER BY news_id DESC LIMIT 0, 1";
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$news = $row["news"];
$news = nl2br($news);
$news = SmileyConvert($news, $directory);
$date = $row["date"];
$title = $row["title"];
$user = $row["user"];
$parsedTime = strtotime($date);
?>
<?php
echo getOuterBoxTop($left, $right);
<?php
header("Cache-Control: no-cache");
header("Pragma: no-cache");
$page = "players";
$subpage = "streaks";
require '../variables.php';
require '../variablesdb.php';
require '../functions.php';
require '../top.php';
$boxImg = "8.jpg";
$boxAlign = "left bottom";
$name = mysql_real_escape_string($_GET['name']);
echo getOuterBoxTop($subNavText . getRaquo() . getSubNavigation($subpage, $name), "");
?>
<?
$sql = "select name from $playerstable where name = '$name'";
$result = mysql_query($sql);
if (empty($name)) {
echo "<p>No player specified!</p>";
} else if (mysql_num_rows($result) == 0) {
echo "<p>The player <b>$name</b> could not be found in the database.</p>";
} else {
$row = mysql_fetch_array($result);
$name = $row['name'];
?>
<table width="100%">
<tr>
if (!empty($gameId)) {
$sql = "Select count(*) from $gamestable where game_id > $gameId";
$result = mysql_query($sql);
if (@mysql_num_rows($result) > 0) {
$row = mysql_fetch_array($result);
$count = $row[0];
$pageGameId = floor($count/$numgamespage);
$startplayed = $numgamespage*$pageGameId;
$type = "against";
$selectname = "all";
$opponent = "all";
}
}
?>
<?= getOuterBoxTop($subNavText.getRaquo().getSubNavigation($subpage, null), $gamesToday) ?>
<table width="100%"><tr><td style="text-align:left;">
<form method="post" name="formGames" action="<?php echo"$directory"?>/games.php?startplayed=0&finishplayed=<?php echo"$numgamespage"?>">
<select class="width150" name="gameType">
<option value="0"<? if (strcmp($gameType, "0") == 0) echo $selected; ?>>All games</option>
<option value="1"<? if (strcmp($gameType, "1") == 0) echo $selected; ?>>Single games</option>
<option value="2"<? if (strcmp($gameType, "2") == 0) echo $selected; ?>>Team games</option>
</select>
<span style="vertical-align:middle"> of </span>
<select class="width150" name="selectname">
<?php
$sortby = "name ASC";
$sql="SELECT name FROM $playerstable ORDER BY $sortby";
$result = mysql_query($sql,$db);
$num = mysql_num_rows($result);
