本帖最后由 kokkos 于 2009-10-9 11:51 编辑
这是我自己使用的,dz7.0==>uchome2.0
数据库是同一个,直接进行数据操作。用户全部转让uchome,激活,同时把email,积分转过去。本人不在乎其他资料信息,通过有奖活动鼓励用户自己补充即可。
我的站点是基督徒社区的,有兴趣可以来看看。
http://51zanmei.net/bbs]http://51zanmei.net/bbs[/url]
[url=http://51zanmei.net/home
- insert into uchome_member
- (uid,
- username,
- password
- )
- select uid,
- username,
- password
- from uc_members
- where uid not in (
- select uid from uchome_member
- );
- INSERT INTO uchome_space(
- uid,
- credit,
- username,
- dateline,
- updatetime,
- lastlogin,
- experience,
- regip
- )
- SELECT uid, credits, username, regdate, lastpost, lastvisit, credits, regip
- FROM cdb_members
- WHERE uid NOT
- IN (
- SELECT uid
- FROM uchome_space
- );
- insert into `uchome_spacefield`
- (`uid`,sex,`email`)
- select uid, gender,email
- from cdb_members
- where uid not in (select uid from uchome_spacefield);
复制代码 |