public function updata_video_state()
{
$sql = "SELECT serve_id FROM " . DB_PREFIX . "video WHERE state = 0 ORDER BY id DESC";
$r = $this->db->query($sql);
$nums = $this->db->num_rows($r);
if ($nums > 0) {
echo $nums . ' videos need update.';
$serve_id = array();
while ($row = $this->db->fetch_array($r)) {
$serve_id[] = $row['serve_id'];
}
require ROOT_DIR . 'api/video/video_api.php';
//导入流媒体API
$tvie_video_api = new TVie_video_api($this->config);
//$video_info = $tvie_video_api->find_video_by_id(697);
foreach ($serve_id as $k => $v) {
$video_info = $tvie_video_api->find_video_by_id($v);
//获取服务器上该视频信息
if ($video_info->job_status != 'done') {
continue;
}
$id = $video_info->id;
//服务器ID
$media_addr = $video_info->files[0]->url;
//流媒体地址
$job_status = $video_info->job_status;
//转码状态
$thumbnail_url = $video_info->thumbnail_url;
//视频缩略图
$bthumbnail_url = $video_info->video_still_url;
//视频大图
$duration = ceil($video_info->files[0]->duration);
//视频时长(返回秒数)
$time = time();
//更新时间
//更新数据库
$sql = "UPDATE " . DB_PREFIX . "video \r\n\t\t\t\t\t\tSET schematic = '" . $thumbnail_url . "' , \r\n\t\t\t\t\t\t\tbschematic = '" . $bthumbnail_url . "' ,\r\n\t\t\t\t\t\t\tstreaming_media = '" . $media_addr . "' , \r\n\t\t\t\t\t\t\ttoff = " . $duration . " ,\r\n\t\t\t\t\t\t\tupdate_time = " . $time . " , \r\n\t\t\t\t\t\t\tstate = 1 \t\t\t\t\t\t\t\r\n\t\t\t\t\t\tWHERE serve_id = " . $id;
$this->db->query($sql);
$this->handle($id, $bthumbnail_url);
}
return true;
} else {
echo 'No video need update.';
}
}
public function rebuild_data()
{
$id = intval($this->input['id']);
//获取视频在流媒体服务器上的ID
include ROOT_DIR . 'lib/video/video.class.php';
$video = new video();
$video_info = $video->get_single_video($id);
$serve_id = $video_info['serve_id'];
if (!$serve_id) {
echo 0;
exit;
}
include ROOT_DIR . 'api/video/video_api.php';
//导入流媒体API
$tvie_video_api = new TVie_video_api($this->config);
$serve_video_info = $tvie_video_api->find_video_by_id($serve_id);
$duration = ceil($serve_video_info->files[0]->duration);
//视频时长(返回秒数)
$thumbnail_url = $serve_video_info->thumbnail_url;
//视频缩略图
$bthumbnail_url = $serve_video_info->video_still_url;
//视频大图
$media_addr = $serve_video_info->files[0]->url;
//流媒体地址
//更新本地缩略图
$sql = "UPDATE " . DB_PREFIX . "video \r\n\t\t\t\tSET toff = " . $duration . " , \r\n\t\t\t\t\tschematic = '" . $thumbnail_url . "' , \r\n\t\t\t\t\tbschematic = '" . $bthumbnail_url . "' , \r\n\t\t\t\t\tstreaming_media = '" . $media_addr . "' \r\n\t\t\t\tWHERE id = " . $id;
$r = $this->db->query($sql);
if ($r) {
echo 1;
} else {
echo 0;
}
}
