dedecms的各种参数统计功能

免费电子图书馆

DEDECMS小技巧：JS方式调用评论总数！

一些简单实现的DEDE V5常用统计SQL标签

大 | 中 | 小

[

2008/08/20 22:11 | by mlzy ]

{dede:loop table='dede_member' sort='pageshow' row='8' if=''}
·<a href='/member/index.php?uid=[field:userid/]' target='_blank'>[field:uname/]</a>
[field:c1/]/[field:pageshow/] 
{/dede:loop}

{dede:loop table='dede_addonarticle' sort='aid' row='1' if=''}·共有文章：[field:aid /] 篇 {/dede:loop}

这是推荐会员调用：
加入if='matt'

{dede:loop table='dede_member' sort='pageshow' row='8' if='matt'}
·<a href='/member/index.php?uid=[field:userid/]' target='_blank'>[field:userid/]</a> 昵称：[field:uname/] 积分：[field:scores/]</a> 
{/dede:loop}

增加5楼一位兄弟的调用代码

<li>·共有文章：{dede:field name='ID' runphp='yes'}
$dsql = new dedesql();
$dsql -> SetQuery("select count(*) as c From #@__archives");
$row = $dsql -> getone();
@me=$row['c'];
{/dede:field}篇 </li>
<li> ·共有评论：{dede:field name='ID' runphp='yes'}
$dsql = new dedesql();
$dsql -> SetQuery("select count(*) as c From #@__feedback");
$row = $dsql -> getone();
@me=$row['c'];
{/dede:field} 条 </li>
<li> ·共有留言：{dede:field name='ID' runphp='yes'}
$dsql = new dedesql();
$dsql -> SetQuery("select count(*) as c From #@__guestbook");
$row = $dsql -> getone();
@me=$row['c'];
{/dede:field} 条 </li>
<li> ·共有会员：{dede:field name='ID' runphp='yes'}
$dsql = new dedesql();
$dsql -> SetQuery("select count(*) as c From #@__member");
$row = $dsql -> getone();
@me=$row['c'];
{/dede:field} 名 </li>
<li> ·共有咨询：{dede:field name='ID' runphp='yes'}
$dsql = new dedesql();
$dsql -> SetQuery("select count(*) as c From #@__ask");
$row = $dsql -> getone();
@me=$row['c'];
{/dede:field} 条 </li>