phpBB.de

Code: Alles auswählen

## PNFORUM TO PHPBB CONVERTER v1.0
## 2006 by Christian Leuenberg aka Nebulous
## nebulous@n-revolution.de
##
## This script uses data from the following PostNuke tables:
## nuke_pnforum_categories
## nuke_pnforum_forums
## nuke_pnforum_posts
## nuke_pnforum_posts_text
## nuke_pnforum_topics
## nuke_pnforum_users
## nuke_users

##
## IMPORT CATEGORIES:
##
INSERT INTO phpbb_categories (
	cat_id,
	cat_title,
	cat_order
)
SELECT
	cat_id,
	cat_title,
	cat_order
FROM nuke_pnforum_categories;

##
## IMPORT FORUMS:
##
INSERT INTO phpbb_forums (
	forum_id,
	cat_id,
	forum_name,
	forum_desc,
	forum_order,
	forum_posts,
	forum_topics,
	forum_last_post_id
)
SELECT 
	forum_id,
	cat_id,
	forum_name,
	forum_desc,
	forum_order,
	forum_posts,
	forum_topics,
	forum_last_post_id
FROM nuke_pnforum_forums;

##
## IMPORT POSTS:
##
INSERT INTO phpbb_posts (
	post_id,
	topic_id,
	forum_id,
	poster_id,
	post_time,
	poster_ip
)
SELECT 
	post_id,
	topic_id,
	forum_id,
	poster_id,
	UNIX_TIMESTAMP(post_time),
	poster_ip
FROM nuke_pnforum_posts;

##
## IMPORT POSTS-TEXT:
##
INSERT INTO phpbb_posts_text (
	post_id,
	post_text 
)
SELECT 
	post_id,
	post_text
FROM nuke_pnforum_posts_text;

##
## IMPORT TOPICS:
##
INSERT INTO phpbb_topics (
	topic_id,
	forum_id,
	topic_title,
	topic_poster,
	topic_time,
	topic_views,
	topic_replies,
	topic_status,
	topic_first_post_id,
	topic_last_post_id
)
SELECT 
	topic_id,
	forum_id,
	topic_title,
	topic_poster,
	UNIX_TIMESTAMP(topic_time),
	topic_views,
	topic_replies,
	topic_status,
	topic_last_post_id,
	topic_last_post_id
FROM nuke_pnforum_topics;

##
## IMPORT USER-DATA FROM PNFORUM AND POSTNUKE:
## NOTE: user_id > 2 because anonymous and administrator should already been set within phpBB-installation
## If you wish to export all users you should truncate phpbb_users first and delete 'AND nuke_pnforum_users.user_id > 2'
##
INSERT INTO phpbb_users (
	user_id,
	user_posts,
	user_rank,
	user_level,
	user_lastvisit,
	username,
	user_password,
	user_regdate,
	user_timezone,
	user_avatar,
	user_email,
	user_icq,
	user_website,
	user_from,
	user_sig,
	user_aim,
	user_yim,
	user_msnm,
	user_interests
)
SELECT 
	nuke_pnforum_users.user_id,
	nuke_pnforum_users.user_posts,
	nuke_pnforum_users.user_rank,
	nuke_pnforum_users.user_level,
	nuke_pnforum_users.user_lastvisit,
	nuke_users.pn_uname,
	nuke_users.pn_pass,
	nuke_users.pn_user_regdate,
	nuke_users.pn_timezone_offset,
	nuke_users.pn_user_avatar,
	nuke_users.pn_email,
	nuke_users.pn_user_icq,
	nuke_users.pn_url,
	nuke_users.pn_user_from,
	nuke_users.pn_user_sig,
	nuke_users.pn_user_aim,
	nuke_users.pn_user_yim,
	nuke_users.pn_user_msnm,
	nuke_users.pn_user_intrest
FROM nuke_pnforum_users,nuke_users WHERE nuke_pnforum_users.user_id = nuke_users.pn_uid AND nuke_pnforum_users.user_id > 2;

Code: Alles auswählen

UNIX_TIMESTAMP(post_time),

Code: Alles auswählen

post_time,