Esempio n. 1
0
                    </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>';
    ?>
Esempio n. 2
0
?>
                            </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>';
}