示例#1
0
 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;
 }