SMF v1.0.x -> XOOPS 2.3.X/CBB 3.08
-----------------------------


Requirements:
- SMF 1.0.X (tested with SMF 1.07)
- XOOPS 2.3.X and CBB 3.08
- MySQL 4.X or higher
- 15 free minutes

The scripts do tranfer the user signatures as well, but the images in there aren't allways shown right. Inform your users to alter them or hack the scripts so you won't transfere them.
Avatars are not transfered due to Xoops's odd way of handling them, get your users to upload them again.

How to import
-------------
Step -10000:

ALLWAYS MAKE A BACKUP OF YOUR XOOPS INSTALLATION AND DATABASE.

Step 1:

First you have to do a clean installation of XOOPS 2.3.x and the
CBB 3.08 module. Make sure you don't create aditional users, else delete them in the XOOPS database with "delete from prefix_users where uid > 1" because it won't transfer the first user from SMF as that is the first user and normaly the admin user, the scripts do however transfer the topics and posts created by this user.

Step 2:

Empty these tables:
-prefix_bb_categories
-prefix_bb_forums
-prefix_bb_posts
-prefix_bb_posts_text
-prefix_bb_topics
-prefix_bb_reads_forum
-prefix_bb_reads_topic

Don't delete them, only empty :).

Step 3:

Now you have to make proper changes in config.php file (database name,
username, password, table's names).

Step 4:

Run:
-members.php
-categories.php
-forums.php
-topics.php
-posts.php

Step 5:

SMF uses a different password encryption level based on SHA1, XOOPS uses MD5 encryption.
To have XOOPS use the SMF SHA1 hash some core files have to be hacked.
Becarefull you can ruin a lot in these files so only do whats in this file.

edit /xoopsdir/kernel/member.php
Find the function &loginUserMd5

Add this function above or below it.

/**
* Logs in a user with a SHA1 SMF password
*/

function &loginUserSha1($uname, $pwd)
{
$smf_hash = sha1(strtolower($uname) . $pwd);
$criteria = new CriteriaCompo(new Criteria('uname', $uname)); $criteria->add(new Criteria('pass', $smf_hash));
$user = $this->_uHandler->getObjects($criteria, false); if (!$user || count($user) != 1) {
$user = false;
return $user;
}
return $user[0];
}

Save the file and close it.

Next edit /xoopsdir/class/auth/auth_xoops.php

Replace:

function authenticate($uname, $pwd = null) {
$member_handler =& xoops_gethandler('member');
$user =& $member_handler->loginUser($uname, $pwd);
if ($user == false) {
$this->setErrors(1, _US_INCORRECTLOGIN);
}
return ($user);
}

With:

function authenticate($uname, $pwd = null) {
$member_handler =& xoops_gethandler('member');
$usermd5 =& $member_handler->loginUser($uname, $pwd);
$usersha1 =& $member_handler->loginUserSha1($uname, $pwd);

if ($usermd5 == false OR $usersha1 == false) {
$this->setErrors(1, _US_INCORRECTLOGIN);
}


if ($usermd5 == true) {
$user = $usermd5;
}

if ($usersha1 == true) {
$user = $usersha1;
}


return ($user);
}


Safe the file and exit.

Step 6:

Empty the caches in the folders:

xoops_data/caches/smarty_cache
xoops_data/caches/smarty_compile
xoops_data/caches/xoops_cache

Don't delete the .htaccess files in there and the index.html files.

Step 7:

Actually, that's all!
.

TOPICS.PHP i get this error
RULES
MySQL error on query BR> INSERT INTO xoopys_bb_topics VALUES ( 2, 'RULES', 2, '1247741220', 816, 0, 2, 4, 1, 0, 1, 0, 0, 1, '', 0, 0, 0, 0, '');
mysql_errno = 1136
mysql_error = Column count doesn't match value count at row 1