想把Discuz里某一版面的文章，转到home
最后的一步没有弄好。求高手相助
1
insert into uchome_blog (uid,username,subject,classid,viewnum,replynum,tracenum,dateline,pic,picflag,noreply,friend)(select authorid,author,subject,'0',views,replies,'0',dateline,'0','0','0','0' from cdb_threads where fid=3) 插入文章标题等信息到uchome主题表
2
2 insert into uchome_blogfield (blogid,uid,message,postip,related,target_ids)(select blogid,uid,'0','0','0','0' from uchome_blog where blogid>3204)
uchome内容表。先把uchome_blogfield表的blogid跟uchome_blog主题blogid对应创建
3 uchome内容表里手工创建subject段
4 对应导入subject 文章标题
update uchome_blogfield set subject = (select subject from uchome_blog where uchome_blog.blogid = uchome_blogfield.blogid)
5 想导入bbs主题的 内容message 根据bbs和home 两个表的 subject 文章标题相等。
update uchome_blogfield set message = (select message from cdb_posts where uchome_blogfield.subject=cdb_posts.subject(select subject from uchome_blogfield) and fid=3)
第五步这里，执行时候，一直在执行。直到死机。。。。请高手解决。。。。。 |
楼主