DeDecms教程

{dede:arclist limit='0,1' row='10' titlelen=28 typeid='2' channelid='3' addfields='officialurl'}
<li><a href="[field:arcurl/]" title="[field:fulltitle/]">[field:title/]</a></li>
{/dede:arclist}

[field:pubdate function="MyDate('Y-m-d',@me)"/]
[field:pubdate function="MyDate('m-d',@me)"/]

[field:id runphp='yes'] $aid = @me;
 $row = $GLOBALS['dsql']->GetOne("Select body From `_addonarticle` where aid='$aid' "); 
@me = cn_substr(html2text("{$row['body']}"),820);
[/field:id]

{dede:php}
        if(preg_match("#Y#", $cfg_open))
        {
        echo '
        <div class="customer" id="followDiv">
        <div class="float_close"><span onClick="followDiv.style.visibility='hidden'">close</span>
        </div>
        <div class="float_ad"><img src="'.$cfg_cmspath.'/templets/default/images/ads.gif" /></div> 
</div>
        ';
        }
 {/dede:php}

{dede:field.control runphp='yes'}if(empty(@me)) @me = '';else @me = '
          <div class="detail_gamekey">
            <ul>
              <li>'.@me.'</li>
            </ul>
          </div>
  ';{/dede:field.control}

[field:endtime runphp="yes"]  if(time()> @me){@me='已结束';}  else {@me='进行中';} 
[/field:endtime]

{dede:productimagelist}
                 <li><a href="javascript:ChangePic('[field:imgsrc/]', '#bigpicimg');" title="[field:text/]" rel="facebox"><img src="[field:imgsrc/]" width="120" height="90" /></a></li>
  {/dede:productimagelist}

[field:description function='cn_substr(@me,80)'/]

function="(str_replace(array('<li>','</li>'),'',@me))"

//替换作者
update dede_archives set writer='新作者名称'  WHERE writer='旧作者名称';
//来源替换
update dede_archives set source='新来源'  where source='旧来源';
//批量替换某个字段变量(例子:把所有点击设置为1)
update dede_archives set click = '1';
//也可以按制定栏目
update dede_archives set click='1' where typeid=栏目ID;
//或者范围内替换
update dede_archives set click='1' where typeid between 开始栏目ID and 结束栏目ID;
//查找(删除)标题含有某些字符
查找：select * from dede_archives where title like "%字符%";
删除：delete * from dede_archives where title like "%字符%";
//替换标题中的指定字符
update dede_archives set title=replace(title,'旧字符',' 新字符');
//删除标题中的某些字符
update dede_archives set title=replace(title,'旧字符','  ');
//只替换某个栏目内文章标题的某个字符
update dede_archives set title=replace(title,'旧字符',' 新字符') where typeid=栏目ID;

update dede_archives set typeid=1 where typeid =10;
update dede_addonarticle  set typeid=1 where  typeid =10;
update dede_arctiny  set typeid=1 where typeid =10;

update dede_addonarticle set body=replace(body,'src="http://baidu.com/img/','src="http://baidu.com/p_w_picpath/');