include("mysql.php");
   
    connectbdd();
   
    $query = "SELECT * FROM smf_messages order by ID_TOPIC ASC, posterTime ASC";
    $bigr = mysql_query( $query ) or die(mysql_error());
   
    $prec_sb_id = 0;
    $prec_smf_topic = 0;
    $parent        = 0;
    $thread        = 0;
    $threadupdate  = 1;
   
    echo mysql_num_rows( $bigr );
    //
    // Pour chaque message...
    while( $row = mysql_fetch_array( $bigr ))
    {
        $id            = $row['ID_MSG'];
        $id_topic      = $row['ID_TOPIC'];
        $id_board      = $row['ID_BOARD'];
        $posterTime    = $row['posterTime'];
        $subject        = $row['subject'];
        $posterName    = $row['posterName'];
        $posterEmail    = $row['posterEmail'];
        $posterIP      = $row['posterIP'];
        $body          = $row['body'];
       
        $subject = addslashes($subject);
        $body    = addslashes($body);
       
        if( $id_topic == $prec_smf_topic )
            $parent = $prec_sb_id;
        else
            $parent = 0;
           
        $thread = $threadupdate;
       
        //
        // On récupere le nom du board et on trouve la correspondance avec Joomlaboard
        $r = mysql_query( "SELECT name from smf_boards where ID_BOARD='$id_board'") or die(mysql_error());
        $result = mysql_fetch_array($r);
       
        $boardname = $result['name'];
       
        $r = mysql_query( "SELECT id FROM mos_sb_categories where name='$boardname'") or die(mysql_error());
        if( mysql_num_rows($r) == 0 )
            die ("CATEGORIE $boardname INEXISTANTE DANS LA BASE MAMBO!!!");
        else
        {
            $result = mysql_fetch_array($r);
            $catid =  $result['id'];
        }
       
        //
        // On récupere maintenant l'id de l'auteur du message
        $r = mysql_query( "SELECT id FROM mos_users where username='$posterName'") or die(mysql_error());
        if (mysql_num_rows($r) == 0 )
            die( "UTILISATEUR $posterName inexistant dans la base MAMBO!!!");
        else
        {
            $result = mysql_fetch_array($r);
            $userid = $result['id'];
        }
       
        //
        // INSERTION DANS LA BASE DE JB
        $query = "INSERT INTO mos_sb_messages VALUES ('', '$parent', '$thread', '$catid', '$posterName', '$userid', '
$posterEmail', '$subject', '$posterTime', '$posterIP', '0', '0', '0', '0', '0', '0' )";
        mysql_query( $query ) or die ("$query" . "
" . mysql_error());
       
        //
        // On choppe l'id du dernier enregistrement
        $r = mysql_query( "SELECT id FROM mos_sb_messages order by id DESC limit 1" ) or die (mysql_error());
            $result = mysql_fetch_array( $r );
            $prec_sb_id = $result['id'];
       
        if( $parent == 0 )
            $threadupdate = $prec_sb_id;
       
        mysql_query( "UPDATE mos_sb_messages SET thread = '$threadupdate' WHERE id='$prec_sb_id'") or die(mysql_error());
       
        //
        // Et maintenant faut inserer le texte dans la base de sb aussi....
        $query = "INSERT INTO mos_sb_messages_text VALUES ('$prec_sb_id', '$body')";
        mysql_query($query) or die ("$query" . "
" . mysql_error());
       
        $prec_smf_topic = $id_topic;
    }
    echo "done";
?>

    include("mysql.php");

...I miss SMF.... 

PS.. SMF forum (link posted above) don't longer exist on my site.. so don't search for...

Why do you miss SMF?

Excuse my "newbieness" here but where do you have to run the script from to do the conversion? Also, I assume that the connection details and database in the mysql.php file is for the SMF database? Is this right?
Thanks.

...and... there's another important reason that makes me change my mind about SMF...

It's called Mambelfish (actual Joomfish)

Read this post carefully to the end.  He found a way to integrate SMF's language switching in with Joomfish.

That's right.
Place both files in the SMF root and launch the convertor one.
Don't forget to backup, first !!! 

So, for the converter to work do the Joomla and SMF tables have to be in the same database?

Maxdg, have you managed to get a conversion working for smf 1.1. rc2 to joomlaboard and can you reproduce this?

Hi,
I am new at Joomla and are preparing a site that has multilanguage support (Joomfish) together with Joomlaboard and I saw that maxdg's site had that, so my question is how do I do this?