此法需要添加一个标签,找到phpcms/modules/content/classes/content_tag.class.php,可以在最后添加这个function。
- /**
- * sitehits站点点击排行
- * @param $data
- */
- function sitehits($data){
- if(emptyempty($data['siteid'])) $data['siteid']=1;
- $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=',';
- }
- }
- $sql='catid in('.$catid.')';
- if(isset($data['day'])) {
- $updatetime = SYS_TIME-intval($data['day'])*86400;
- $sql .= " AND updatetime>'$updatetime'";
- }
- //获取点击排行
- $r = $this->hits_db->select($sql,'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))); //开源软件:Vevb.com
- }
- return $return;
- }
这样就好了,下面看看调用的代码吧.
- {pc:content action="sitehits" siteid="1" num="10" day="7" order="views DESC" cache="3600"}
- {loop $data $r}
- < li><a href="{$r[url]}" target="_blank">{$r[title]}</a></li>
- {/loop}
- {/pc}
- < /ul>
OK,就这样结束了在phpcms v9中全站点击排行调用,而且可以指定日间范围.
新闻热点
疑难解答