'; } else { $unartist_pic = '
'; } $sqlreqch = "SELECT `songID`, `username`, `message` FROM `requests` WHERE `songID`='".$lid."' AND `requested` > NOW() - INTERVAL 3 HOUR LIMIT 1"; $result = mysqli_query($db_conx, $sqlreqch); if (mysqli_num_rows($result) > 0) { while($rinfo = mysqli_fetch_assoc($result)) { $reqsongid = mysqli_real_escape_string($db_conx, $rinfo['songID']); $requsername = mysqli_real_escape_string($db_conx, $rinfo['username']); } } if(!empty($requsername) && ($reqsongid == $lid)){ $reqY = '
'; }else{ $reqY = ''; } $upcoming .= '
'.$unartist_pic.''.$reqY.'
'.$lartist.'
'; } $requsername = ''; $nartist_pic = ''; $reqmsg = ''; $nartist = ''; $ntitle = ''; $sqlnow = "SELECT `ID`, `trackID`, `date_played`, `artist`, `title`, `duration` FROM `history` WHERE `song_type`='0' ORDER BY `date_played` DESC LIMIT 1"; $nqueue = mysqli_query($db_conx, $sqlnow); while($nrow = mysqli_fetch_assoc($nqueue)) { $nsongID = mysqli_real_escape_string($db_conx, $nrow['ID']); $ntrackID = mysqli_real_escape_string($db_conx, $nrow['trackID']); $nartist = mysqli_real_escape_string($db_conx, $nrow['artist']); $ntitle = mysqli_real_escape_string($db_conx, $nrow['title']); $dat = $nrow['date_played']; $nartist = stripslashes($nartist); $ntitle = stripslashes($ntitle); if (file_exists('pictures/'.$nartist.'.jpg') && $nartist != '') { $nartist_pic = '
'; } else { $nartist_pic = '
'; } $sqlreqch = "SELECT `username`, `message` FROM `requests` WHERE `songID`='".$ntrackID."' AND `requested` > NOW() - INTERVAL 2 HOUR LIMIT 1"; $result = mysqli_query($db_conx, $sqlreqch); if (mysqli_num_rows($result) > 0) { while($rinfo = mysqli_fetch_assoc($result)) { $requsername = mysqli_real_escape_string($db_conx, $rinfo['username']); $msg = mysqli_real_escape_string($db_conx, $rinfo['message']); $msg = stripslashes($msg); } $reqmsg = '
Requested by '.$requsername.'
' . $msg . '
'; }else{ $reqmsg = '
Vraag een nummer aan
Wijs het toe aan jouw boodschap hier...
'; } } $nowplay = '
'.$nartist_pic.'
nu op on '.SITE_NAME.'
'.$ntitle.'
'.$nartist.'
'.$reqmsg.'
'.NP_DESC.'
'; $sql_songs = mysqli_query($db_conx, "SELECT `ID` FROM `songs` WHERE `song_type`='0'"); $songs_total = mysqli_num_rows($sql_songs); ?>