public function schedule2() {
        global $get,$config,$settings,$alert,$schedule;


        $stmt = $this->conn->prepare("SELECT * FROM schedule WHERE  day=?  AND deleted='0' ORDER BY length(hour),hour");
        $stmt->execute(array(date('N')));


        if ($stmt->rowCount() == NULL) {
                echo '<div class="content-dj"><b>00:00 - 23:00</b> - Geen DJ</div>';
        } else {
            foreach ($stmt as $row) {
                if ($row['userid2'] == '0') {
                    $returnUsername = data::userInfoRow($row['userid'],'usernameID');
                } else {
                    $returnUsername = data::userInfoRow($row['userid'],'usernameID').' & '.data::userInfoRow($row['userid2'],'usernameID');
                }

                    if ($row['hour'] == '1') {
                        $returnHour = "01";
                    } elseif ($row['hour'] == '2') {
                        $returnHour = "02";
                    } elseif ($row['hour'] == '3') {
                        $returnHour = "03";
                    } elseif ($row['hour'] == '4') {
                        $returnHour = "04";
                    } elseif ($row['hour'] == '5') {
                        $returnHour = "05";
                    } elseif ($row['hour'] == '6') {
                        $returnHour = "06";
                    } elseif ($row['hour'] == '7') {
                        $returnHour = "07";
                    } elseif ($row['hour'] == '8') {
                        $returnHour = "08";
                    } elseif ($row['hour'] == '9') {
                        $returnHour = "09";
                    } else {
                        $returnHour = $row['hour'];
                    }
                    $nu_2 = $returnHour + 1;

                    if ($nu_2 == '1') {
                        $returnHour1 = "01";
                    } elseif ($nu_2 == '2') {
                        $returnHour1 = "02";
                    } elseif ($nu_2 == '3') {
                        $returnHour1 = "03";
                    } elseif ($nu_2 == '4') {
                        $returnHour1 = "04";
                    } elseif ($nu_2 == '5') {
                        $returnHour1 = "05";
                    } elseif ($nu_2 == '6') {
                        $returnHour1 = "06";
                    } elseif ($nu_2 == '7') {
                        $returnHour1 = "07";
                    } elseif ($nu_2 == '8') {
                        $returnHour1 = "08";
                    } elseif ($nu_2 == '9') {
                        $returnHour1 = "09";
                    } else {
                        $returnHour1 = $row['hour'] + 1;
                    }


                echo '<div class="content-dj"><b>'.$returnHour.':00 - '.$returnHour1.':00</b> - '.$returnUsername.'</div>';
            }
        }
    }