Phpcms V9 点击量、排行调用方法

PhpCms v9 默认只调用当前栏目的文章排行，却没有调用全站文章排行的代码，在网上查找到了以下方法，来实现此功能，备忘如下：

调用代码：

{pc:content action=”sitehits” siteid=”4″ num=”10″ order=”views DESC” cache=”3600″}

{loop $data $r}

{/loop}
{/pc}

{$r[title]}

打开phpcms\modules\content\classes\content_tag.class.php 在里面添加以下代码：

/**

* sitehits站点点击排行
* @param $data
*/
function sitehits($data){
if(empty($data['siteid'])) return false;
$siteid = intval($data['siteid']);
$this->hits_db = pc_base::load_model(‘hits_model’);
$category_content = getcache(‘category_content’,'commons’);
$catid = ”;
//获取站点下所有栏目ID
foreach($category_content as $key=>$val){
if($val==$siteid){
$catid .= $comma.$key;
$comma=’,';
}
}

//获取点击排行
$r = $this->hits_db->select(‘catid in(‘.$catid.’)',’hitsid’,$data['limit'],$data['order']);
$return = array();
$sitemodel_model_db = pc_base::load_model(‘sitemodel_model’);
$this->db_config = pc_base::load_config(‘database’);
$tablepre = $this->db_config['default']['tablepre'];
foreach($r as $key){
preg_match_all(‘/-(\d+)-/’,$key['hitsid'],$modelid);
$id = substr($key['hitsid'],(strpos($key['hitsid'],’-',2)+1));
$tablename = $sitemodel_model_db->get_one(array(‘modelid’=>$modelid[1][0]),’tablename’);
$this->db->table_name = $tablepre.$tablename['tablename'];
$return[] = array_merge($return,$this->db->get_one(array(‘id’=>$id)));
}
return $return;
}

当天帖子点击排行调用方法：

{php $historytime = mktime(0, 0, 0, date('m', TIME), date('d', TIME), date('Y', TIME));}
{get sql="select p.*,t.* from phpcms_content p,phpcms_content_count t where p.contentid=t.contentid and p.status=99 and p.inputtime>=$historytime order by t.hits desc" rows="10" return="v"}
标题及链接：<a herf="{$v[url]}" >{$v[title]}</a>点击数：{$v[hits]} {/get}