皮皮网的空间

日志文章

(12-06-24 11:22)

（这是2010年的教程，看完后完全可以用在最新版的织梦上）首先找到需要修改的地方，先从会员发布文章开始，找到 member/article_add.php

找到以下代码

//保存到主表

$inQuery = "INSERT INTO `cz_archives`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle, color,writer,source,litpic,pubdate,senddate,mid,deｓｃｒｉｐｔion,keywords,mtype)
VALUES ('$arcID','$typeid','$sortrank','$flag','$ismake','$channelid','$arcrank','0','$money','$title','$shorttitle',
'$color','$writer','$source','$litpic','$pubdate','$senddate','$mid','$deｓｃｒｉｐｔion','$keywords','$mtypesid'); ";

更改为

//保存到主表

$inQuery = "INSERT INTO `cz_archives`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle, color,writer,source,litpic,pubdate,senddate,mid,deｓｃｒｉｐｔion,keywords,mtype)
VALUES ('$arcID','$typeid','$sortrank','$flag','-1','$channelid','$arcrank','0','$money','$title','$shorttitle',
'$color','$writer','$source','$litpic','$pubdate','$senddate','$mid','$deｓｃｒｉｐｔion','$keywords','$mtypesid'); ";

实际就是将2中的$ismake改为-1

保存后上传至空间覆盖即可，以后会员发表的文章只需要审核，不需要再一处一处的修改了。

接下来是采集，同上，找到你的后台目录/co_export.php

找到以下代码

//基本信息主表

$mainSqlTemplate = "INSERT INTO `$maintable`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle,color,writer,source,litpic,pubdate,senddate,mid,deｓｃｒｉｐｔion,keywords)
VALUES ('@aid@','@typeid@','@sortrank@','@flag@','0','$channelid','$arcrank','0','0','@title@','','','@writer@','@source@','@litpic@','@pubdate@','@senddate@','$adminid','@deｓｃｒｉｐｔion@','@keywords@'); ";

替换为

//基本信息主表

$mainSqlTemplate = "INSERT INTO `$maintable`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle,color,writer,source,litpic,pubdate,senddate,mid,deｓｃｒｉｐｔion,keywords)
VALUES ('@aid@','@typeid@','@sortrank@','@flag@','-1','$channelid','$arcrank','0','0','@title@','','','@writer@','@source@','@litpic@','@pubdate@','@senddate@','$adminid','@deｓｃｒｉｐｔion@','@keywords@'); ";

实际就是将2中的第一个0改为-1

OK，大功告成。以后不用再麻烦的修改了。