帝国CMS统计今日文章数,昨日文章数,总文章数,会员数,最新会员
<?php$members=$empire->gettotal("select count(*) as total from phome_enewsmember");$newmember=$empire->fetch1("select userid,username from phome_enewsmember order by userid desc limit 1");$tzcount=$em……
<?php$members=$empire->gettotal("select count(*) as total from phome_enewsmember");$newmember=$empire->fetch1("select userid,username from phome_enewsmember order by userid desc limit 1");$tzcount=$empire->gettotal("select count(*) as total from phome_ecms_news");$plnum=$empire->gettotal("select count(*) as total from {$dbtbpre}enewspl");$pltzcont=$tzcount+$plnum;?><div class="forumstatus">今日: <em class="numeric">[totaldata]'news',2,1[/totaldata]</em> ,昨日: <em class="numeric">[ztotal]栏目ID[/ztotal]</em> ,主题: <em class="numeric"><?=$tzcount?></em> ,帖子: <em class="numeric"><?=$pltzcont?></em> ,用户: <em class="numeric"><?=$members?></em>,最新会员: <em class="numeric"><?=$newmember[username]?></em></div>
- 上一篇
帝国CMS列表内容模板(list.var)调用会员头像会员名会员积分
列表内容模板(list.var)代码:$uid=$empire->fetch1("select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]}");$usql=$empire->fetch1("select * from {$dbtbpre}enewsmember where userid = {$r['userid
- 下一篇
帝国CMS 批量修改字段内容sql语句
在后台系统-执行sql语句update phome_ecms_download set titleurl=replace(titleurl,'http://www.daixiao360.cn','http://127.0.0.1');update phome_ecms_download set titlepic=replace(titlepic,'http://www.daixi