调用全站48小时点击排行:
{pc:get sql="SELECT h.`dayviews`,n.`title`,n.`url`,n.`style` FROM `phpcms_hits` AS h,`qybi_news` AS n WHERE substring_index(h.`hitsid`, '-', -1)=n.`id` AND n.`status`=99 ORDER
BY h.`dayviews` DESC" num="10" cache="3600" day="2"}
{loop $data $v}
<LI><A href="{$v[url]}" target=_blank>{str_cut($v[title],33,'')}</A></LI>
{/loop}
{/pc}
调用全站7天点击排行:
{pc:get sql="SELECT h.`weekviews`,n.`title`,n.`url`,n.`style` FROM `phpcms_hits` AS h,`qybi_news` AS n WHERE substring_index(h.`hitsid`, '-', -1)=n.`id` AND n.`status`=99 ORDER
BY h.`weekviews` DESC" num="10" cache="3600" day="7"}
{loop $data $v}
<LI><A href="{$v[url]}" target=_blank>{str_cut($v[title],33,'')}</A></LI>
{/loop}
{/pc}
调用全站30天点击排行:
{pc:get sql="SELECT h.`monthviews`,n.`title`,n.`url`,n.`style` FROM `phpcms_hits` AS h,`qybi_news` AS n WHERE substring_index(h.`hitsid`, '-', -1)=n.`id` AND n.`status`=99 ORDER
BY h.`monthviews` DESC" num="10" cache="3600" day="30"}
{loop $data $v}
<LI><A href="{$v['url']}" target=_blank>{str_cut($v['title'],33,'')}</A></LI>
{/loop}
{/pc}
还没有评论,来说两句吧...