/** * function update_video_status_from_vms * 视频状态改变接口 * @param array $get 视频信息 */ public function update_video_status_from_vms() { if (is_array($_GET) && !empty($_GET)) { $size = $_GET['size']; $timelen = intval($_GET['timelen']); $status = intval($_GET['ku6status']); $vid = $_GET['vid']; $picpath = format_url($_GET['picpath']); //验证数据 /* 验证vid */ if (!$vid) { return json_encode(array('status' => '101', 'msg' => 'vid not allowed to be empty')); } /* 验证视频大小 */ if ($size < 100) { return json_encode(array('status' => '103', 'msg' => 'size incorrect')); } /* 验证视频时长 */ if ($timelen < 1) { return json_encode(array('status' => '104', 'msg' => 'timelen incorrect')); } $db = pc_base::load_model('video_store_model'); $r = $db->get_one(array('vid' => $vid)); if ($r) { $db->update(array('size' => $size, 'picpath' => $picpath, 'status' => $status), array('vid' => $vid)); if ($status == 21) { $r = $video_store_db->get_one(array('vid' => $vid), 'videoid'); //取出videoid,以便下面操作 $videoid = $r['videoid']; /** * 加载视频内容对应关系数据模型,检索与删除视频相关的内容。 * 在对应关系表中找出对应的内容id,并更新内容的静态页 */ $video_content_db = pc_base::load_model('video_content_model'); $result = $video_content_db->select(array('videoid' => $videoid)); if (is_array($result) && !empty($result)) { //加载更新html类 $html = pc_base::load_app_class('html', 'content'); $content_db = pc_base::load_model('content_model'); $url = pc_base::load_app_class('url', 'content'); foreach ($result as $rs) { $modelid = intval($rs['modelid']); $contentid = intval($rs['contentid']); $content_db->set_model($modelid); $content_db->update(array('status' => 99), array('id' => $contentid)); $table_name = $content_db->table_name; $r1 = $content_db->get_one(array('id' => $contentid)); /** * 判断如果内容页生成了静态页,则更新静态页 */ if (ishtml($r1['catid'])) { $content_db->table_name = $table_name . '_data'; $r2 = $content_db->get_one(array('id' => $contentid)); $r = array_merge($r1, $r2); unset($r1, $r2); if ($r['upgrade']) { $urls[1] = $r['url']; } else { $urls = $url->show($r['id'], '', $r['catid'], $r['inputtime']); } $html->show($urls[1], $r, 0, 'edit'); } else { continue; } } } } elseif ($data['status'] < 0 || $data['status'] == 24) { $r = $video_store_db->get_one(array('vid' => $vid), 'videoid'); //取出videoid,以便下面操作 $videoid = $r['videoid']; //$video_store_db->delete(array('vid'=>$vid)); //删除此视频 /** * 加载视频内容对应关系数据模型,检索与删除视频相关的内容。 * 在对应关系表中解除关系,并更新内容的静态页 */ $video_content_db = pc_base::load_model('video_content_model'); $result = $video_content_db->select(array('videoid' => $videoid)); if (is_array($result) && !empty($result)) { //加载更新html类 $html = pc_base::load_app_class('html', 'content'); $content_db = pc_base::load_model('content_model'); $url = pc_base::load_app_class('url', 'content'); foreach ($result as $rs) { $modelid = intval($rs['modelid']); $contentid = intval($rs['contentid']); $video_content_db->delete(array('videoid' => $videoid, 'contentid' => $contentid, 'modelid' => $modelid)); $content_db->set_model($modelid); $table_name = $content_db->table_name; $r1 = $content_db->get_one(array('id' => $contentid)); /** * 判断如果内容页生成了静态页,则更新静态页 */ if (ishtml($r1['catid'])) { $content_db->table_name = $table_name . '_data'; $r2 = $content_db->get_one(array('id' => $contentid)); $r = array_merge($rs, $r2); unset($r1, $r2); if ($r['upgrade']) { $urls[1] = $r['url']; } else { $urls = $url->show($r['id'], '', $r['catid'], $r['inputtime']); } $html->show($urls[1], $r, 0, 'edit'); } else { continue; } } } } return json_encode(array('status' => '200', 'msg' => 'Success')); } else { return json_encode(array('status' => '107', 'msg' => 'Data is empty!')); } } json_encode(array('status' => '107', 'msg' => 'Data is empty!')); }
/** *@ function public_check_status *@ 手动检查视频状态 */ public function public_check_status() { $id = intval($_GET['id']); if (!$id) { exit('1'); } $r = $this->db->get_one(array('videoid' => $id), 'vid,channelid,status,picpath'); if (!$r) { exit('2'); } $return = $this->ku6api->check_status($r['vid']); if (!$return) { exit('3'); } $status_arr = pc_base::load_config('ku6status_config'); if ($return['ku6status'] != $r['status']) { $this->db->update(array('status' => $return['ku6status'], 'picpath' => $return['picpath']), array('videoid' => $id)); if ($return['ku6status'] == 21) { /** * 加载视频内容对应关系数据模型,检索与删除视频相关的内容。 * 在对应关系表中找出对应的内容id,并更新内容的静态页 */ $video_content_db = pc_base::load_model('video_content_model'); $result = $video_content_db->select(array('videoid' => $id)); if (is_array($result) && !empty($result)) { //加载更新html类 $html = pc_base::load_app_class('html', 'content'); $content_db = pc_base::load_model('content_model'); $content_check_db = pc_base::load_model('content_check_model'); $url = pc_base::load_app_class('url', 'content'); foreach ($result as $rs) { $modelid = intval($rs['modelid']); $contentid = intval($rs['contentid']); $content_db->set_model($modelid); $c_info = $content_db->get_one(array('id' => $contentid), 'thumb'); $where = array('status' => 99); if (!$c_info['thumb']) { $where['thumb'] = $return['picpath']; } $content_db->update($where, array('id' => $contentid)); $checkid = 'c-' . $contentid . '-' . $modelid; $content_check_db->delete(array('checkid' => $checkid)); $table_name = $content_db->table_name; $r1 = $content_db->get_one(array('id' => $contentid)); /** * 判断如果内容页生成了静态页,则更新静态页 */ if (ishtml($r1['catid'])) { $content_db->table_name = $table_name . '_data'; $r2 = $content_db->get_one(array('id' => $contentid)); $r = array_merge($r1, $r2); unset($r1, $r2); if ($r['upgrade']) { $urls[1] = $r['url']; } else { $urls = $url->show($r['id'], '', $r['catid'], $r['inputtime']); } $html->show($urls[1], $r, 0, 'edit'); } else { continue; } } } $msg_r = json_encode(array('change' => 1, 'status' => 21, 'statusname' => iconv(CHARSET, 'UTF-8', $status_arr[$return['ku6status']]))); } else { $msg_r = json_encode(array('change' => 1, 'status' => $return['ku6status'], 'statusname' => iconv(CHARSET, 'UTF-8', $status_arr[$return['ku6status']]))); } } else { if (!$r['picpath'] && $return['picpath']) { $this->db->update(array('picpath' => $return['picpath']), array('videoid' => $id)); $msg_r = json_encode(array('change' => 1, 'status' => $return['ku6status'], 'statusname' => iconv(CHARSET, 'UTF-8', $status_arr[$return['ku6status']]))); } else { $msg_r = json_encode(array('change' => 0)); } } exit($msg_r); }
if (is_array($result) && !empty($result)) { //加载更新html类 $html = pc_base::load_app_class('html', 'content'); $content_db = pc_base::load_model('content_model'); $url = pc_base::load_app_class('url', 'content'); foreach ($result as $rs) { $modelid = intval($rs['modelid']); $contentid = intval($rs['contentid']); $video_content_db->delete(array('videoid' => $videoid, 'contentid' => $contentid, 'modelid' => $modelid)); $content_db->set_model($modelid); $table_name = $content_db->table_name; $r1 = $content_db->get_one(array('id' => $contentid)); /** * 判断如果内容页生成了静态页,则更新静态页 */ if (ishtml($r1['catid'])) { $content_db->table_name = $table_name . '_data'; $r2 = $content_db->get_one(array('id' => $contentid)); $r = array_merge($r1, $r2); unset($r1, $r2); if ($r['upgrade']) { $urls[1] = $r['url']; } else { $urls = $url->show($r['id'], '', $r['catid'], $r['inputtime']); } $html->show($urls[1], $r, 0, 'edit'); } else { continue; } } }