One of my sites is a forum, I want my moderators to do the job when I'm not ' there', but this moderator 'thing' is not (yet) handled well in cbb, so I looked for another forum, found smf with tiny portal, but no conversion from XOOPS 2.2.4 and cbb to smf.
So I found it out for myself.


Here is what I did.

I used downgrade.php to downgrade XOOPS 2.2.4 to 2.0.x
I made one change in this file, I added :

//Set uname as name
$sql = "UPDATE ".$xoopsDB->prefix("users")." SET name=uname";
if (!$xoopsDB->query($sql)) {
$log[] = "Could not set name to uname value, check MySQL log for details";
}

Just before :

//Set loginname as uname
$sql = "UPDATE ".$xoopsDB->prefix("users")." SET uname=loginname";
if (!$xoopsDB->query($sql)) {
$log[] = "Could not set uname to loginname value, check MySQL log for details";
}

This way the display names of the users are filled in the 'name' field of xoops, and after conversion this becomes the displayname of smf.


I did not follow the instructions for downgrade.php, just hit the buttons and downgraded the database (that's all I needed for the conversion)

For the conversion I used the convert.php and xoops_to_smf.sql that can be found on smf forum.
I had to make some changes in the sql file because cbb is different from newbb.

nosmiley changed to dosmiley
bb_forum_mods to bb_moderates and also here user_id to mod_id.

I had to comment out the line where the converter is looking for forum_access, I don't know how this is accomplished in cbb.

When you run the converter don't touch any buttons when it's converting the posts because then the conversion will not complete errorfree.

Now you can login to your converted forum and all you have to do now is setting the permissions of the boards.

That's all
hth