<script>
        /* AJAX request to checker */
        function check(){
            $.ajax({
                type: 'POST',
                url: 'checker.php',
                dataType: 'json'
            }).done(function( response ) {
               $('#message-list').html(response.news);
            });
        }
        setInterval(check,4000);
</script>

<?php
require('config/mysql.php');

    $data['news'] .= $db->get_oczekujace();

echo json_encode($data);

    function get_oczekujace(){
        
    $result = $this->db->query('SELECT *, (SELECT SUM(liczba_wejsc) FROM lots_user WHERE loteria=lots.id) AS wszystkie_wejscia,
                              (SELECT user FROM lots_user WHERE loteria=lots.id AND status=1) AS id_wygranego,
                              (SELECT user.login FROM user WHERE id=id_wygranego) AS login        
                               FROM lots WHERE status=1 ORDER BY data_rozpoczecia');

                $czas_do_rozpoczecia = array();
                while($r = $result->fetch_array()){

                $czas_do_rozpoczecia[] = strtotime($r["data_rozpoczecia"]);        
                $wejscie = $r["wejscie"];
                $w_wejscia = $r["wszystkie_wejscia"];
                
                if ($r["login"] == ''){
                    $r["login"] = "------";
                }
                $cena_przedmiotu = number_format($w_wejscia * $wejscie, 0, ',', '.');

                if ($r["premium"] == 1){    
                    $return .= '<div class="box premium_zapisany">';    
                }else{
                    $return .= '<div class="box zapisany">';    
                }        
                    $return .= '<a href="aukcja-{$lots_nowe[i].id}.html"><p>'.$r["nazwa"]." (".$r["id"].')</p></a>';    
                    $return .= '<a href="aukcja-{$lots_nowe[i].id}.html"><img width="160" height="160" style="border: 2px solid #ECECEC;" src="../images/nagrody/'.$r["zdjecie"].'" /></a>';    
                    $return .= '<div class="col-lg-12">
                                       <span class="czas_do_rozpoczecia"></span>
                                </div>';     
                if ($r["premium"] == 1){
                    $return .=  '<div class="col-lg-12 box-pasek-premium">';
                }else{
                    $return .=  '<div class="col-lg-12 box-pasek">';
                }
                    $return .= '<span style=" font-size:18px;">
                                        <a href="aukcje">
                                        <span class="glyphicon glyphicon-refresh"></span>
                                     </a> Wejście: '.$r["wejscie"].'<img class="waluta-b" src="../images/mini-coin.png" />
                                </span>';
                    $return .= '</div>';
                    $return .= '<a class="btn btn-success" href="index.php?site=aukcje&przebij='.$r["id"].'">
                                    Przebij!
                                </a>
                                <a class="btn btn-primary" href="#">
                                    Kup teraz!
                                </a>';
                    $return .= "<p>".$cena_przedmiotu.'<img class="waluta-b" src="../images/mini-coin.png" /></p>';
                if ($r["premium"] == 1){
                    $return .= '<div class="col-lg-12 box-pasek-premium">';
                }else{
                    $return .= '<div class="col-lg-12 box-pasek">';
                }
                    $return .= 'Wygrywa: <span class="glyphicon glyphicon-user"></span> '.$r["login"].'
                        </div> ';
            
                                
                    $return .= '</div>';
                                    
            }
            
///// po dodaniu pliku z licznikiem odliczającym czas nie działa dynamiczne odświeżanie treści! ////////
            
                //include("scripts/lots_oczekujace.php"); // skrypt js

            return $return;

        }

<script>
var czas_do_rozpoczecia = <?php echo json_encode($czas_do_rozpoczecia); ?>;

$(document).ready( function() {
    $('span.czas_do_rozpoczecia').each(function(index) {
        wstaw_czas(this, index);
    });    
});

function wstaw_czas(obj, index) {
    var do_konca = czas_do_rozpoczecia[index] - Math.round((new Date()).getTime() / 1000);

    if (do_konca <= 0) {
        //location.reload();
        $(obj).html('00:00:00');
    } else {
        var hours = Math.floor(do_konca/3600);
        var minutes = Math.floor((do_konca - hours*3600)/60);
        var seconds = Math.floor(do_konca - hours*3600 - minutes*60);

        if (hours < 10) hours = "0"+hours;
        if (minutes < 10) minutes = "0"+minutes;
        if (seconds < 10) seconds = "0"+seconds;
    
        // will display time in 10:30:23 format
        var formattedTime = hours + ':' + minutes + ':' + seconds;
    
        $(obj).html(formattedTime);
    
        setTimeout(function() { wstaw_czas(obj, index); }, 1000);
    }
}

</script>