数据库替换常用代码:
栏目信息数据库替换:
update #@_arctype set seotitle=replace(seotitle,'旧','新'); update #@_arctype set keywords=replace(keywords,'旧','新'); update #@_arctype set description=replace(description,'旧','新'); update dede_addonarticle set body=replace(body,'旧','新');
文章相关数据库替换:
update dede_archives set title=replace(title,'旧','新'); update dede_archives set description=replace(description,'旧','新'); update dede_addonarticle set body=replace(body,'旧','新');
SQL调用标签代码:
共有文章:*篇:
{dede:sql sql="select count(*) as c from dede_archives where channel=1"}共有文章:[field:c /]篇{/dede:sql}
共有图集:*个;
{dede:sql sql="select count(*) as c from dede_archives where channel=2"}共有图集:[field:c /]个{/dede:sql}
共有软件:*个:
{dede:sql sql="select count(*) as c from dede_archives where channel=3"}共有软件:[field:c /]个{/dede:sql}
共有评论:*条:
{dede:sql sql="select count(*) as c from dede_feedback"}共有评论:[field:c /]条{/dede:sql}
共有会员:*名:
{dede:sql sql="select count(mid) as c from dede_member"}共有会员:[field:c /]名{/dede:sql}
今日更新:*篇:
{dede:sql sql="SELECT count( * ) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP( CURDATE( ) ) "}今日更新:[field:c /]篇{/dede:sql}
总共留言:*条:
总共留言:{dede:sql sql="select count(*) as cc From dede_guestbook"}[field:cc/]{/dede:sql}条
文章阅读:*人次:
{dede:sql sql="select sum(click) as c from dede_archives"}文章阅读:[field:c /]人次{/dede:sql}
常用SQL语句:
删除所有栏目,新建ID从1开始:
ALTER TABLE `#@_arctype` AUTO_INCREMENT =1;
删除所有文章,新发布文章ID从1开始:
ALTER TABLE `#@_archives` AUTO_INCREMENT =1;
增加文章属性
insert into `dede_arcatt`(sortid,att,attname) values(9,'d','新自定义属性'); alter table `dede_archives` modify `flag` set ('h','c','p','f','s','j','a','b','自定义属性的flag标记') default NULL; 【说明:其中9为增加属性的ID号,d为增加属性的识别标志即flag的值,“新自定义属性”为中文字段说明】