TP-Docs
HTML5 Icon HTML5 Icon HTML5 Icon
TP on Social Media

Recent

Welcome to TinyPortal. Please login or sign up.

April 30, 2024, 06:59:16 AM

Login with username, password and session length
Members
  • Total Members: 3,885
  • Latest: Growner
Stats
  • Total Posts: 195,174
  • Total Topics: 21,220
  • Online today: 147
  • Online ever: 3,540 (September 03, 2022, 01:38:54 AM)
Users Online
  • Users: 0
  • Guests: 100
  • Total: 100

Xoops 2.2.4 and cbb 3.04 to smf conversion

Started by Svaha, August 21, 2006, 08:12:03 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Svaha

I don't know if this is the right place to post this, but I really like tp and wanted to convert my forum to tp and found no conversion for this.
So I did it myself.

Ok, I managed to convert the forum, 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