$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);