function video_sidebar($row, $section, $count, $major) { include_once INCLUDESPATH . 'easyparliament/video.php'; $db = new ParlDB; if ($major == 1) { $gid_type = 'debate'; } elseif ($major == 101) { $gid_type = 'lords'; } $vq = $db->query("select id,adate,atime from video_timestamps where gid='uk.org.publicwhip/$gid_type/$row[gid]' and (user_id!=-1 or user_id is null) and deleted=0 order by (user_id is null) limit 1"); $ts_id = $vq->field(0, 'id'); if (!$ts_id) $ts_id='*'; $adate = $vq->field(0, 'adate'); $time = $vq->field(0, 'atime'); $videodb = video_db_connect(); if (!$videodb) return ''; $video = video_from_timestamp($videodb, $adate, $time); $start = $video['offset']; $out = ''; if ($count > 1) { $out .= '<div id="video_wrap"><div style="position:relative">'; if ($row['gid'] != $section['first_gid']) { $out .= '<p style="margin:0">This video starts around ' . ($row['hpos']-$section['hpos']) . ' speeches in (<a href="#g' . gid_to_anchor($row['gid']) . '">move there in text</a>)</p>'; } } $out .= video_object($video['id'], $start, "$gid_type/$row[gid]"); $flashvars = 'gid=' . "$gid_type/$row[gid]" . '&file=' . $video['id'] . '&start=' . $start; $out .= "<br><b>Add this video to another site:</b><br><input readonly onclick='this.focus();this.select();' type='text' name='embed' size='40' value=\"<embed src='http://www.theyworkforyou.com/video/parlvid.swf' width='320' height='230' allowfullscreen='true' allowscriptaccess='always' flashvars='$flashvars'></embed>\"><br><small>(copy and paste the above)</small>"; $out .= "<p style='margin-bottom:0'>Is this not the right video? <a href='mailto:team@theyworkforyou.com?subject=Incorrect%20video,%20id%20$row[gid];$video[id];$ts_id'>Let us know</a></p>"; if ($count > 1) { $out .= '<p style="position:absolute;bottom:0;right:0;margin:0"><a href="" onclick="return showVideo();">Hide</a></p>'; $out .= '</div></div>'; $out .= '<div id="video_show" style="display:none;position:fixed;bottom:5px;right:5px;border:solid 1px #666666; background-color: #eeeeee; padding: 4px;"> <p style="margin:0"><a href="" onclick="return hideVideo();">Show video</a></p></div>'; } return $out; }
<?php include_once "../www/includes/easyparliament/init.php"; include_once INCLUDESPATH . 'easyparliament/video.php'; $db = new ParlDB(); $videodb = video_db_connect(); $q = pg_query($videodb, "\n SELECT id, broadcast_start, broadcast_end\n FROM programmes\n WHERE channel_id = 'BBCParl' AND status = 'available' \n ORDER BY id\n"); while ($row = pg_fetch_array($q)) { date_default_timezone_set('GMT'); $start = strtotime($row['broadcast_start']); $end = strtotime($row['broadcast_end']); date_default_timezone_set('Europe/London'); $start_date = date('Y-m-d', $start); $start_time = date('H:i:s', $start); $end_date = date('Y-m-d', $end); $end_time = date('H:i:s', $end); if ($start_date == $end_date) { $qq = $db->query("update hansard set video_status = video_status | 1\n\t where hdate='{$start_date}' and htime>='{$start_time}' and htime<'{$end_time}' and major=1"); } else { $qq = $db->query("update hansard set video_status = video_status | 1\n\t where ((hdate='{$start_date}' and htime>='{$start_time}')\n\t or (hdate='{$end_date}' and htime<'{$end_time}')) and major=1"); } #print "$start - $end : " . $qq->affected_rows() . "\n"; }
private function video_sidebar($row, $heading_hpos, $count) { include_once INCLUDESPATH . 'easyparliament/video.php'; $db = new \ParlDB(); $gid_type = $this->video_gid_type(); $vq = $db->query("select id,adate,atime from video_timestamps where gid='uk.org.publicwhip/{$gid_type}/{$row['gid']}' and (user_id!=-1 or user_id is null) and deleted=0 order by (user_id is null) limit 1"); $adate = $vq->field(0, 'adate'); $time = $vq->field(0, 'atime'); $videodb = video_db_connect(); if (!$videodb) { return ''; } $video = video_from_timestamp($videodb, $adate, $time); $start = $video['offset']; $out = ''; if ($count > 1) { $out .= '<div class="debate__video" id="video_wrap"><div>'; if ($row['gid'] != $this->first_gid) { $out .= '<p class="video-instructions">This video starts around ' . ($row['hpos'] - $heading_hpos) . ' speeches in (<a href="#g' . gid_to_anchor($row['gid']) . '">move there in text</a>)</p>'; } } $out .= video_object($video['id'], $start, "{$gid_type}/{$row['gid']}"); $flashvars = 'gid=' . "{$gid_type}/{$row['gid']}" . '&file=' . $video['id'] . '&start=' . $start; $out .= "<strong>Embed this video</strong><p class='video-instructions'>Copy and paste this code on your website</p><input readonly onclick='this.focus();this.select();' type='text' name='embed' size='40' value=\"<embed src='http://www.theyworkforyou.com/video/parlvid.swf' width='320' height='230' allowfullscreen='true' allowscriptaccess='always' flashvars='{$flashvars}'></embed>\">"; if ($count > 1) { $out .= '<p class="hide-video"><a href="" onclick="return showVideo();">Hide</a></p>'; $out .= '</div></div>'; $out .= '<div id="video_show" class="show-video" style="display:none;"> <p style="margin:0"><a href="" onclick="return hideVideo();">Show video</a></p></div>'; } return $out; }