zujixie分散帖子

–将指定人的帖子时间分散,authorid=2是 uid=2的用户 create table `zjx_forum_thread_tmp` (td_id int, dateline int); insert into `zjx_forum_thread_tmp` select tid,((select max(dateline) from `zjx_forum_thread`)+ROUND(RAND() *1000000000)%(UNIX_TIMESTAMP()-(select max(t2.dateline) from `zjx_forum_thread` t2))) from `zjx_forum_thread` WHERE authorid=57; update `zjx_forum_thread` set dateline=(select dateline from `zjx_forum_thread_tmp` t where t.td_id= tid) where authorid=57; drop table `zjx_forum_thread_tmp`; update `zjx_forum_thread` set lastpost=dateline WHERE authorid=57; //将指定人的帖子的作者分散,authorid=2是 uid=2的用户 update zjx_forum_thread set `authorid` = ROUND(RAND() *10000)%(select max(uid) from zjx_common_member) where authorid=57; //下面这句是将不在用户表中的authorid,重新生成。要反复执行多次，直到反更新的条目为0， update zjx_forum_thread set `authorid` = ROUND(RAND() *10000)%(select max(uid) from zjx_common_member) WHERE `authorid` not in (select uid from zjx_common_member); //根据authorid重新生成author和lastposter update `zjx_forum_thread` set author=(select username from zjx_common_member where uid=authorid), lastposter=(select username from zjx_common_member where uid=authorid); //更新forum_post，使author、authorid、dateline与forum_thread一致 update `zjx_forum_post` p set author=(select author from `zjx_forum_thread` t where t.tid=p.tid), authorid=(select authorid from `zjx_forum_thread` t where t.tid=p.tid), dateline=(select dateline from `zjx_forum_thread` t where t.tid=p.tid); ===================================================== yahewan