</div> <tr> <th><a href="<?php print getLinkWithGet(array('orderBy' => 'name', 'desc' => revString(issetGetValue('desc', '1'))), $_SERVER['PHP_SELF'], $_GET); ?> ">Name</a></th> <th><a href="<?php print getLinkWithGet(array('orderBy' => 'rank', 'desc' => revString(issetGetValue('desc', '1'))), $_SERVER['PHP_SELF'], $_GET); ?> ">Rank</a></th> <th><a href="<?php print getLinkWithGet(array('orderBy' => 'lastMatch', 'desc' => revString(issetGetValue('desc', '1'))), $_SERVER['PHP_SELF'], $_GET); ?> ">Last Match</a></th> <th><a href="<?php print getLinkWithGet(array('orderBy' => 'teamCount', 'desc' => revString(issetGetValue('desc', '1'))), $_SERVER['PHP_SELF'], $_GET); ?> ">Teams</a></th> <th><a>Hidden</a></th> </tr> </thead> <tbody> <?php $query = $dbConn->prepare("SELECT `id`, `name`, `hidden`, `rank`, `lastMatch`, `teamCount`, `team1`, `team2`, `team3`, `team4`, `team5`" . "FROM `player_information`" . $conditions . "ORDER BY {$orderByVal} {$orderByOrder} " . "LIMIT {$lowerLimit}, {$upperLimit}"); $query->execute(); $result = $query->get_result(); while ($row = $result->fetch_assoc()) { print "<tr class=\"tableRow\" id=\"tableRow{$row['id']}\">"; print '<td>' . "<a target=\"_blank\" href=\"http://lan.op.gg/summoner/userName={$row['name']}\">" . $row['name'] . '</td>'; print '<td>' . $row['rank'] . '</td>'; ?>
?> </ul> </div> <br /> </caption> <thead> <div class="text-center"> <ul id="paginationId" class="pagination pagination-sm"></ul> </div> <tr> <th><a href="<?php print getLinkWithGet(array('orderBy' => 'name', 'desc' => revString(issetGetValue('desc', '1'))), $_SERVER['PHP_SELF'], $_GET); ?> ">Name</a></th> <th><a href="<?php print getLinkWithGet(array('orderBy' => 'processed', 'desc' => revString(issetGetValue('desc', '-1'))), $_SERVER['PHP_SELF'], $_GET); ?> ">Processed</a></th> </tr> </thead> <tbody> <?php $query = $dbConn->prepare("SELECT `name`, `processed`" . "FROM `player_queue`" . $conditions . "ORDER BY {$orderByVal} {$orderByOrder} " . "LIMIT {$lowerLimit}, {$upperLimit}"); $query->execute(); $result = $query->get_result(); while ($row = $result->fetch_assoc()) { print "<tr class=\"tableRow\">"; print '<td>' . $row['name'] . '</td>'; print '<td>' . (intval($row['processed']) == '0' ? 'False' : 'True') . '</td>'; print '</tr>'; }