public function insertQueueToLivmediaByVideoID($tv_play, $op, $column_id, $now_column, $pub_time, $video_id = '')
{
$sql = "SELECT * FROM " . DB_PREFIX . "tv_episode WHERE tv_play_id = '" . $tv_play['id'] . "'";
if (!$video_id) {
$sql .= " AND expand_id = 0";
} else {
$sql .= " AND video_id = {$video_id}";
}
$q = $this->db->query($sql);
$video_id_arr = array();
$ep_info = array();
while ($r = $this->db->fetch_array($q)) {
$ep_info[] = $r;
$video_id_arr[] = $r['video_id'];
}
if (!empty($video_id_arr)) {
$video_ids = implode(',', $video_id_arr);
}
if ($video_ids) {
//发布剧集
if (!empty($ep_info)) {
foreach ($ep_info as $k => $v) {
publish_insert_query($v, 'insert', $column_id, 1);
}
}
//触发视频发布
include_once ROOT_PATH . 'lib/class/livmedia.class.php';
$livmedia = new livmedia();
$livmedia->insertQueueToLivmedia($video_ids, $op, implode(',', $column_id), $now_column, $pub_time);
}
}
public function insertQueueToLivmediaByVideoID($tv_play_id, $video_id, $op, $column_id, $now_column, $pub_time)
{
/*$sql = "SELECT * FROM " .DB_PREFIX. "tv_episode WHERE tv_play_id = '" .$tv_play['id']. "' AND expand_id = 0 ";
$q = $this->db->query($sql);
$video_id_arr = array();
while ($r = $this->db->fetch_array($q))
{
$video_id_arr[] = $r['video_id'];
}*/
if ($video_id && $tv_play_id) {
//查询剧集信息
$sql = "SELECT * FROM " . DB_PREFIX . "tv_episode WHERE tv_play_id = {$tv_play_id} AND video_id = {$video_id}";
$ep_info = $this->db->query_first($sql);
publish_insert_query($ep_info, 'insert', $column_id, 1);
include_once ROOT_PATH . 'lib/class/livmedia.class.php';
$livmedia = new livmedia();
$livmedia->insertQueueToLivmedia($video_id, $op, implode(',', $column_id), $now_column, $pub_time);
}
}
