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;
}
