<style>
    body {
        background-size: cover;
        background-position: center;
        background-attachment: fixed;
        /* background-image: url(<?php echo $url; ?>/img/bg_juegos.jpg); */
        background-color: #939597;
    }
</style>



<div class="col-md-12">

    <div class="container">

        <?php echo $rersp; ?>

        <div class="row">

            <div class="col-md-12" align="center">
                <h1 style="color: #ffffff;">RANKING</h1>

            </div>

            <div class="col-md-6" align="center" style="color: #ffffff;">

                <h3>Crucigrama</h3>
                <hr>

                <table class="table table-bordered" style="color: #ffffff">
                    <tr>
                        <th scope="col">Posición</th>
                        <th scope="col">Participante</th>
                        <th scope="col">Puntaje</th>
                    </tr>
                    <?php
                    $arrayRanking = array();

                    $count = 1;
                    $queryR1 = mysqli_query($connect, "SELECT SUM(porcentaje), SUM(tiempo), id_asistente  FROM Retos WHERE tipo_juego = 1 GROUP BY id_asistente  ");
                    while ($dataR1 = mysqli_fetch_array($queryR1)) {

                        $queryAsi = mysqli_query($connect, "SELECT * FROM Asistentes WHERE id = '" . $dataR1['id_asistente'] . "' ");
                        $dataAsi = mysqli_fetch_array($queryAsi);

                        $puntaje = ($dataR1["SUM(porcentaje)"] * 20 / ($dataR1["SUM(tiempo)"] / 3));

                        array_push($arrayRanking, array(
                            "id_asistente" => $dataR1['id_asistente'],
                            "asistente" => ($dataAsi["nombre"] . ' ' . $dataAsi["apellidos"]),
                            "puntaje" => $puntaje

                        ));

                        $count++;
                    }


                    usort($arrayRanking, 'sort_by_orden');
                    function sort_by_orden($a, $b)
                    {
                        return $b['puntaje'] - $a['puntaje'];
                    }

                    $count = 1;
                    foreach ($arrayRanking as $ranking) {
                        echo '
                            <tr>
                                <td>' . $count . '</td>
                                <td>' . $ranking["asistente"] . '</td>
                                <td>' . round($ranking["puntaje"]) . ' pts.</td>
                            <tr>
                            ';
                        $count++;
                    }

                    ?>

                </table>




            </div>

            <div class="col-md-6" align="center" style="color: #ffffff;">

                <h3>Encuentre la frase</h3>
                <hr>

                <table class="table table-bordered" style="color: #ffffff">
                    <tr>
                        <th scope="col">Posición</th>
                        <th scope="col">Participante</th>
                        <th scope="col">Puntaje</th>
                    </tr>
                    <?php
                    $arrayRanking = array();

                    $count = 1;
                    $queryR1 = mysqli_query($connect, "SELECT SUM(porcentaje), SUM(tiempo), id_asistente  FROM Retos WHERE tipo_juego = 2 GROUP BY id_asistente  ");
                    while ($dataR1 = mysqli_fetch_array($queryR1)) {

                        $queryAsi = mysqli_query($connect, "SELECT * FROM Asistentes WHERE id = '" . $dataR1['id_asistente'] . "' ");
                        $dataAsi = mysqli_fetch_array($queryAsi);

                        $puntaje = ($dataR1["SUM(porcentaje)"] * 10 / ($dataR1["SUM(tiempo)"] / 3));

                        array_push($arrayRanking, array(
                            "id_asistente" => $dataR1['id_asistente'],
                            "asistente" => ($dataAsi["nombre"] . ' ' . $dataAsi["apellidos"]),
                            "puntaje" => $puntaje

                        ));

                        $count++;
                    }


                    usort($arrayRanking, 'sort_by_orden');


                    $count = 1;
                    foreach ($arrayRanking as $ranking) {
                        echo '
                            <tr>
                                <td>' . $count . '</td>
                                <td>' . $ranking["asistente"] . '</td>
                                <td>' . round($ranking["puntaje"]) . ' pts.</td>
                            <tr>
                            ';
                        $count++;
                    }

                    ?>

                </table>


            </div>




        </div>

    </div>

</div>