public function video_record()
{
$site = $this->input['site'];
if (!$site || !is_array($site)) {
$this->errorOutput('NO_SITE_IDS');
}
$video_record = $content_id = $content_data = array();
foreach ($site as $k => $v) {
$sql = "SELECT * FROM " . DB_PREFIX . "content_video_record WHERE site_id=" . $v['site_id'] . " ORDER BY id DESC LIMIT " . $v['video_record_count'];
$info = $this->db->query($sql);
while ($row = $this->db->fetch_array($info)) {
$video_record[$row['site_id']][] = $row;
$content_data_detail = $row['content_data'] ? unserialize($row['content_data']) : array();
$content_data_detail['site_id'] = $row['site_id'];
$content_data_detail['column_id'] = $row['column_id'];
$content_data_detail['struct_id'] = $row['struct_id'];
$content_data_detail['id'] = $row['relation_id'];
$content_data_detail['op'] = $row['opration'];
$content_data[$row['relation_id']] = $content_data_detail;
$column_ids[$row['column_id']] = $row['column_id'];
$site_ids[$row['site_id']] = $row['site_id'];
}
}
if ($content_data) {
include_once CUR_CONF_PATH . 'lib/column.class.php';
$column_obj = new column();
if ($column_ids) {
$column_datas = $column_obj->get_column_by_id(' id,name,childdomain,column_dir,site_id,relate_dir,father_domain ', implode(',', $column_ids), 'id');
}
if ($site_ids) {
$site_datas = $column_obj->get_site(' id,site_name,weburl,sub_weburl ', ' AND id in(' . implode(',', $site_ids) . ')', 'id');
}
foreach ($content_data as $k => $v) {
$content_data[$k]['content_url'] = mk_content_url($site_datas[$v['site_id']], $column_datas[$v['column_id']], $v);
}
}
$result['video_record'] = $video_record;
$result['content_data'] = $content_data;
$this->addItem($result);
$this->output();
}
