query($sql); $sql = 'SELECT playlist_id, room_id, name, start, end, playlists.note FROM playlists LEFT JOIN djs ON playlists.dj_id = djs.dj_id WHERE playlists.event_id ='.$_GET['event_id'].' ORDER BY start, playlist_id'; $result = $db->query($sql); // fix sort for PM and AM while($row = $result->fetch_assoc()) { $row['start'] = timeTo12($row['start']); $row['end'] = timeTo12($row['end']); if(!$row['name']) { $vsdjs[$row['playlist_id']] = array(); $sql = 'SELECT DISTINCT name, vs_tracks.dj_id FROM djs, vs_tracks WHERE vs_tracks.playlist_id ='.$row['playlist_id'].' AND vs_tracks.dj_id = djs.dj_id ORDER BY priority'; $vs = $db->query($sql); $name = ''; while($dj = $vs->fetch_assoc()) { $name .= $dj['name'].' vs. '; //populates array $vsdjs with shortest unique names for($i=1; $i 6 && ((int) substr($playlist['start'], 0, 2)) != 12) { $playlists[] = $playlist; } } foreach($playlists_tmp as $playlist) { if($playlist['start'] != NULL && (((int) substr($playlist['start'], 0, 2)) <= 6 || ((int) substr($playlist['start'], 0, 2)) == 12)) { $playlists[] = $playlist; } } foreach($playlists_tmp as $playlist) { if($playlist['start'] == NULL) { $playlists[] = $playlist; } } } //display data echo ''; echo '
'; echo ''; $rooms->data_seek(0); while($room = $rooms->fetch_assoc()) { $use = false; foreach($playlists as $playlist) { if($room['room_id'] == $playlist['room_id']) { $use = true; break; } } if($use) { echo ''; echo ''; foreach($playlists as $playlist) { if($room['room_id'] == $playlist['room_id']) { echo '' : ''; if($playlist['note']) { echo ''; } // get tracklists if($playlist['vs']) { $sql = 'SELECT artist, title, requested, vs_tracks.dj_id FROM tracks, vs_tracks, djs WHERE tracks.playlist_id='.$playlist['playlist_id'].' AND tracks.track_id = vs_tracks.track_id AND vs_tracks.dj_id = djs.dj_id ORDER BY number'; } else { $sql = 'SELECT artist, title, requested FROM tracks WHERE playlist_id='.$playlist['playlist_id'].' ORDER BY number'; } $result = $db->query($sql); // display playlist if($result->num_rows) { echo ''; if($vs) { echo $playlist['vs'] ? 'artist'; } while($row = $result->fetch_assoc()) { if($row['requested'] == 'yes') { echo ''; //$vsdjs[$playlist['playlist_id']][$row['dj_id']] stores short name for dj_id if($vs) { echo $playlist['vs'] ? ''.$row['artist'].''."\n"; } else { echo ''; if($vs) { echo $playlist['vs'] ? ''.$row['artist'].''."\n"; } } } } } } echo '
'.$room['name'].'
'.$playlist['name']; echo $playlist['vs'] && $playlist['start'] ? '
' : ''; echo $playlist['start'] ? ' '.substr($playlist['start'], 0, 5).'-'.substr($playlist['end'], 0, 5).'
('.$playlist['note'].')
djtitlereq
'.$vsdjs[$playlist['playlist_id']][$row['dj_id']].':'.$row['title'].'x
'.$vsdjs[$playlist['playlist_id']][$row['dj_id']].':'.$row['title'].'
'; echo '
'; // display bottom controls displayControls($current, 'playlists.php', 'bottomctrl'); } else { echo '

>> Playlists <<

'; listPreviousEvents('playlists.php'); } //include bottom include_once('bottom.php'); ?>