public function get_all_content_by_relationid($id, $need_process = false) { include_once CUR_CONF_PATH . 'lib/column.class.php'; $column = new column(); $sql = "SELECT c.*,r.*,c.id as cid,c.column_id as main_column_id,r.site_id,r.column_id,r.column_name,r.id as id,r.order_id,r.weight,r.file_name,r.file_domain,r.file_dir,r.file_custom_filename,r.publish_time,r.status FROM " . DB_PREFIX . "content_relation r LEFT JOIN " . DB_PREFIX . "content c ON r.content_id=c.id WHERE r.id =" . $id; $info = $this->db->query_first($sql); if ($info['indexpic']) { $info['indexpic'] = unserialize($info['indexpic']); } if ($info['video']) { $info['video'] = unserialize($info['video']); } if ($info['childs_data']) { $info['childs_data'] = unserialize($info['childs_data']); } if ($info['catalog']) { $info['catalog'] = unserialize($info['catalog']); } if ($need_process) { if ($info) { $column_data = $column->get_site_column_first(' id,name,site_id,fid,childdomain,father_domain,column_dir,relate_dir,col_con_maketype ', $info['column_id']); $site_data = $column_data['site_data']; unset($column_data['site_data']); $info['column_info'] = $column_data; if ($info['use_maincolumn']) { $column_data = $column->get_site_column_first(' id,name,site_id,fid,childdomain,father_domain,column_dir,relate_dir,col_con_maketype ', $info['main_column_id']); $site_data = $column_data['site_data']; $info['content_url'] = $info['outlink'] ? $info['outlink'] : mk_content_url($site_data, $column_data, array('column_id' => $info['main_column_id']) + $info); unset($column_data['site_data']); $info['main_column_info'] = $column_data; } else { $info['content_url'] = $info['outlink'] ? $info['outlink'] : mk_content_url($site_data, $column_data, $info); } } } unset($info['keywords_unicode'], $info['title_unicode'], $info['title_pinyin']); return $info; }