<h1>Igényelt karakterek listája</h1>

<table class="table" id="myTable2">
    <?php
        echo'<tr style = "border: 2px white solid;">';
            echo '<th onclick="sortTable(0)">ID</th>';
            echo '<th onclick="sortTable(1)">Dátum</th>';
            echo '<th onclick="sortTable(2)">Játékos név</th>';
            echo '<th onclick="sortTable(3)">UCP név</th>';
            echo '<th onclick="sortTable(4)">IP cím</th>';
            echo '<th onclick="sortTable(5)">Régió</th>';
            echo '<th colspan="2">Döntés</th>';
        echo '</tr>';

    $i=1;
    $sql = "SELECT * FROM players WHERE active = 0";
    $result = mysqli_query($GLOBALS["db"], $sql);
    if( mysqli_num_rows($result) > 0){
        while ($row = mysqli_fetch_assoc($result)){
            echo '<tr>';
                echo '<td style="border-left: 2px white solid;">', $i,'</td>';
                echo '<td>', $row["last_login"],'</td>';
                echo '<td>', get_character_name_by_id($row["id"]),'</td>';
                echo '<td>', get_ucp_name_by_character($row["name"]), '</td>';
                echo '<td>', $row["last_ip"], '</td>';
                echo '<td><a href="http://ip-api.com/#', $row["last_ip"], '" style="text-decoration:underline;">', get_ip_countryCode($row["last_ip"]), '</a></td>';
                echo '<td><a href="?o=activator&id=', $row["id"], '&do=accept">Elfogad</a></td>';
                echo '<td style = "border-right: 2px white solid;"><a href="?o=activator&id=', $row["id"], '&do=reject">Elutasít</a></td>';
            echo '</tr>';
            $i++;
        }
    }
    ?>
</table>


<?php
if(isset($_GET["o"]) && $_GET["o"] != "")
{
    $o = $_GET["o"];
    if(file_exists("inc/".$o.".php"))
    {
        include_once("inc/".$o.".php");
    }
    else
    {
        include_once "inc/404.php";
    }
}
else
{
    include_once ("inc/main.php");

}
?>

<script>
    function sortTable(n) {
        var table, rows, switching, i, x, y, shouldSwitch, dir, switchcount = 0;
        table = document.getElementById("myTable2");
        switching = true;
        // Set the sorting direction to ascending:
        dir = "asc";
        /* Make a loop that will continue until
        no switching has been done: */
        while (switching) {
            // Start by saying: no switching is done:
            switching = false;
            rows = table.rows;
            /* Loop through all table rows (except the
            first, which contains table headers): */
            for (i = 1; i < (rows.length - 1); i++) {
                // Start by saying there should be no switching:
                shouldSwitch = false;
                /* Get the two elements you want to compare,
                one from current row and one from the next: */
                x = rows[i].getElementsByTagName("TD")[n];
                y = rows[i + 1].getElementsByTagName("TD")[n];
                /* Check if the two rows should switch place,
                based on the direction, asc or desc: */
                if (dir == "asc") {
                    if (x.innerHTML.toLowerCase() > y.innerHTML.toLowerCase()) {
                        // If so, mark as a switch and break the loop:
                        shouldSwitch = true;
                        break;
                    }
                } else if (dir == "desc") {
                    if (x.innerHTML.toLowerCase() < y.innerHTML.toLowerCase()) {
                        // If so, mark as a switch and break the loop:
                        shouldSwitch = true;
                        break;
                    }
                }
            }
            if (shouldSwitch) {
                /* If a switch has been marked, make the switch
                and mark that a switch has been done: */
                rows[i].parentNode.insertBefore(rows[i + 1], rows[i]);
                switching = true;
                // Each time a switch is done, increase this count by 1:
                switchcount ++;
            } else {
                /* If no switching has been done AND the direction is "asc",
                set the direction to "desc" and run the while loop again. */
                if (switchcount == 0 && dir == "asc") {
                    dir = "desc";
                    switching = true;
                }
            }
        }
    }
</script>