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