首先找到需要修改的地方,先从会员发布文章开始,找到 member/article_add.php
# D) W9 o4 g8 A- R) Q找到以下代码! D! m# X }& O$ G2 o# c7 J
//保存到主表
3 B N3 r) C4 w4 u4 D( i, W2 T* y
1 R9 N) P5 U8 r" E. |3 p# K- $inQuery = "INSERT INTO `cz_archives`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle, color,writer,source,litpic,pubdate,senddate,mid,description,keywords,mtype)
- b7 d+ A+ ]5 L1 w. F - VALUES ('$arcID','$typeid','$sortrank','$flag','$ismake','$channelid','$arcrank','0','$money','$title','$shorttitle', 7 }% g J5 B, J! T5 C
- '$color','$writer','$source','$litpic','$pubdate','$senddate','$mid','$description','$keywords','$mtypesid'); ";
9 G1 Q1 t0 g. F/ Y- a0 y* R
| 3 ]! H+ t2 ^3 H. L
更改为
- N- }4 A, z, r3 Z. |; e+ A//保存到主表 % O4 J I7 b' z/ K# G% C5 d( `
3 s; u+ j! c% M9 S7 x+ m- $inQuery = "INSERT INTO `cz_archives`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle, color,writer,source,litpic,pubdate,senddate,mid,description,keywords,mtype)
$ {) }* {8 U: b# N: R - VALUES ('$arcID','$typeid','$sortrank','$flag','-1','$channelid','$arcrank','0','$money','$title','$shorttitle',
( V* G, B8 J5 I" c) e7 C! c - '$color','$writer','$source','$litpic','$pubdate','$senddate','$mid','$description','$keywords','$mtypesid'); ";; y( A: H( w+ O
| , C: b+ r. E3 S5 d$ U9 D. k/ S
保存后上传至空间覆盖即可,以后会员发表的文章只需要审核,不需要再一处一处的修改了。% x% O9 \9 D' x0 W# U r2 X- ^
接下来是采集,同上,找到 你的后台目录/co_export.php
/ ]% R! V& h9 g8 G- v找到以下代码
& c4 @% q, }8 ?& q//基本信息主表 : p7 `5 F( {8 q9 `3 o5 U- Y3 ^7 u
* u# \+ p' d6 K- $mainSqlTemplate = "INSERT INTO `$maintable`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle,color,writer,source,litpic,pubdate,senddate,mid,description,keywords)
: N) w. \- a! o3 I3 X - VALUES ('@aid@','@typeid@','@sortrank@','@flag@','0','$channelid','$arcrank','0','0','@title@','','','@writer@','@source@','@litpic@','@pubdate@','@senddate@','$adminid','@description@','@keywords@'); ";7 F% L) F% M( u% w
|
' z+ }$ Q6 V6 y% b替换为
* |2 X9 Z6 U1 `8 F//基本信息主表
8 V s2 w5 u8 e5 o+ `1 q# V5 K0 Y2 @9 G, Y
- $mainSqlTemplate = "INSERT INTO `$maintable`(id,typeid,sortrank,flag,ismake,channel,arcrank,click,money,title,shorttitle,color,writer,source,litpic,pubdate,senddate,mid,description,keywords) ' o2 U& X; v' t i0 o: I6 g
- VALUES ('@aid@','@typeid@','@sortrank@','@flag@','-1','$channelid','$arcrank','0','0','@title@','','','@writer@','@source@','@litpic@','@pubdate@','@senddate@','$adminid','@description@','@keywords@'); ";
. e$ p( Q$ C0 ^3 @# C | ( J: U+ ]0 B3 z% u, y7 b( ~
OK,大功告成。以后不用再麻烦的修改了。- ^! o% b9 f: z* x0 i# M# B
感谢大家的支持,本文为原创,转载请申明。原文地址:http://www.iii28.com/view-154-1.html
* F& [& Y% a7 D) M$ z A$ g! j1 a 注:相关网站建设技巧阅读请移步到建站教程频道。 |
|