Discuz 采集帖子后，分散作者，时间

有些Discuz站长为了丰富站点内容，会从其它站点抓取帖子。比如使用火车头程序等。这样做会有两个问题，发布的时间十分接近，发布作者一样。导致浏览站点的人一看便知，数据是从别处抓取的。为了分散时间与作者，在采集完数据后，可在数据库中执行下列SQL,可将数据分散。 //将指定人的帖子时间分散,authorid=2是 uid=2的用户 update `yhw_forum_thread` set dateline=(1284744665+ROUND(RAND() *1000000000)%97701546) WHERE authorid=2; update `yhw_forum_thread` set lastpost=dateline WHERE authorid=2; //将指定人的帖子的作者分散,authorid=2是 uid=2的用户 update yhw_forum_thread set `authorid` = ROUND(RAND() *10000)%(select max(uid) from yhw_common_member) where authorid=2; //下面这句是将不在用户表中的authorid,重新生成。要反复执行多次，直到反更新的条目为0， update yhw_forum_thread set `authorid` = ROUND(RAND() *10000)%(select max(uid) from yhw_common_member) WHERE `authorid` not in (select uid from yhw_common_member); //根据authorid重新生成author和lastposter update `yhw_forum_thread` set author=(select username from yhw_common_member where uid=authorid), lastposter=(select username from yhw_common_member where uid=authorid); //更新forum_post，使author、authorid、dateline与forum_thread一致 update `yhw_forum_post` p set author=(select author from `yhw_forum_thread` t where t.tid=p.tid), authorid=(select authorid from `yhw_forum_thread` t where t.tid=p.tid), dateline=(select dateline from `yhw_forum_thread` t where t.tid=p.tid);