fquery("SELECT 1 FROM custom_schedule WHERE userid=? AND attending=1 AND sessionid=?", $userid, $_GET['id']); $t = $db->squery("SELECT s.*, IFNULL(t.name, '') AS track FROM sessions s LEFT JOIN tracks t ON t.trackid=s.trackid WHERE s.sessionid=? GROUP BY s.sessionid", $_GET['id']); if (!$t) exit(); $speakers = $db->aquery("SELECT sp.name, IF(u.twitter != '', u.twitter, sp.twitter) AS twitter, u.company, u.bio, u.photo_path, sp.gravatar_hash FROM session_speakers ssp JOIN speakers sp ON sp.speakerid=ssp.speakerid LEFT JOIN cfp_openwest_org.users u ON u.id=sp.cfp_speakerid WHERE ssp.sessionid=? ORDER BY sp.name", $_GET['id']); if (preg_match('/^([A-Z0-9-]+) - (.+)$/', $t['track'], $regs)) { $room = $regs[1]; $track = $regs[2]; } else { $track = "General"; if ($t['type'] == "Keynote") { $room = "EH1"; } else { $room = false; } } ?>

0) { echo "
\n"; foreach ($speakers as $s) { if ($s['photo_path']) { $photo = "https://cfp.openwest.org/uploads/".$s['photo_path']; } else if ($s['gravatar_hash']) { $photo = "https://www.gravatar.com/avatar/".$s['gravatar_hash'].".jpg?r=g&s=120"; } else { $photo = false; } $bio = MarkdownExtra::defaultTransform($s['bio']); ?>

@

\n"; } ?> -12:00am