Bellow SQL converts ccBoard 1.2RC Posts to Kunena. It does not convert categories, as I didn't need it.
Code:
INSERT INTO jos_kunena_messages
SELECT
cp.id AS id,
IF(ct.start_post_id=cp.id,0,ct.start_post_id) AS parent,
ct.start_post_id AS thread,
cp.forum_id AS catid,
cp.post_username AS name,
cp.post_user AS userid,
COALESCE(u.email,'') AS email,
cp.post_subject AS subject,
cp.post_time AS time,
cp.ip AS ip,
IF(ct.start_post_id=cp.id,ct.topic_emoticon,0) AS topic_emoticon,
IF(ct.start_post_id=cp.id,ct.locked,0) AS locked,
cp.hold AS hold,
0 AS ordering,
IF(ct.start_post_id=cp.id,ct.hits,0) AS hits,
0 AS moved,
cp.modified_by AS modified_by,
cp.modified_time AS modified_time,
cp.modified_reason AS modified_reason
FROM jos_ccb_posts AS cp
JOIN jos_ccb_topics AS ct ON ct.id = cp.topic_id
LEFT JOIN jos_users AS u ON u.id=cp.post_user;
INSERT INTO jos_kunena_messages_text
SELECT
cp.id AS messid,
cp.post_text AS message
FROM jos_ccb_posts AS cp;
