我只想转换XOOPS的会员到DISCUZ的话,有没有办法?
我在网上找到的XOOPS和PHPBB的会员对应关系,哪位高手给点意见
This script only copy XOOPS_users to PHPBB_ORIGIN_users.
CODE
INSERT INTO `phpbb_users` (`user_id`, `user_active`, `username`, `user_password`, `user_regdate`, `user_posts`, `user_timezone`, `user_viewemail`, `user_attachsig`, `user_rank`, `user_avatar`, `user_email`, `user_icq`, `user_website`, `user_from`, `user_sig`, `user_aim`, `user_yim`, `user_msnm`, `user_occ`, `user_interests`)
SELECT `uid`, `level`, `uname`, `pass`, `user_regdate`, `posts`, `timezone_offset`, `user_viewemail`, `attachsig`, `rank`, `user_avatar`, `email`, `user_icq`, `url`, `user_from`, `user_sig`, `user_aim`, `user_yim`, `user_msnm`, `user_occ`, `user_intrest` FROM xoops_users;
__After transfering users, you can not login as Admin in PHPBB origin board, to do that, you have edit your acct with "user_level"=1;
__This script only works when XOOPS and PHPBB origin use the same DataBase. |
