phpcms发布新闻到数据库_phpcms 调用全站最新发布数据

/**

* 全站最热

* @param $data

*/

public function CountLists($data) {

$this->db->table_name = 'v9_news';

$catid = intval($data['catid']);

if(isset($data['where'])){

$sql = $data['where'];

}else{

$thumb = intval($data['thumb']) ? " AND thumb != ''" : '';

if(!empty($catid)) {

if(!$this->set_modelid($catid)) return false;

if($this->category[$catid]['child']) {

$catids_str = $this->category[$catid]['arrchildid'];

$pos = strpos($catids_str,',')+1;

$catids_str = substr($catids_str, $pos);

$sql = "status=99 AND catid IN ($catids_str)".$thumb;

} else {

$sql = "status=99 AND catid='$catid'".$thumb;

}

}

else {

$sql = "status=99".$thumb;

}

}

$order = $data['order'];

$return = $this->db->select($sql, '*', $data['limit'], $order, '', 'id');

//调用副表的数据

if (isset($data['moreinfo']) && intval($data['moreinfo']) == 1) {

$ids = array();

foreach ($return as $v) {

if (isset($v['id']) && !empty($v['id'])) {

$ids[] = $v['id'];

} else {

continue;

}

}

if (!empty($ids)) {

$this->db->table_name = $this->db->table_name.'_data';

$ids = implode('\',\'', $ids);

$r = $this->db->select("`id` IN ('$ids')", '*', '', '', '', 'id');

if (!empty($r)) {

foreach ($r as $k=>$v) {

if (isset($return[$k])) $return[$k] = array_merge($v, $return[$k]);

}

}

}

}

return $return;

}

因为指定了

$this->db->table_name = 'v9_news';

所以只有默认的文章模型可以用，其他模型暂时不行

调用方式为

{pc:content action="CountLists" num="5" order="id DESC"}