Joomla! Discussion Forums

<?
    include("mysql.php");
    connectbdd();

//Populate Categories
echo "<br />Populating Categories...<br />";
$query="TRUNCATE TABLE jos_sb_categories";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());

// Import the main categories
$query="INSERT INTO jos_sb_categories (id,parent,name,cat_emoticon,locked,alert_admin,moderated,moderators,pub_access,pub_recurse,admin_access,admin_recurse,ordering,future2,published,checked_out,checked_out_time,review,hits,description) SELECT ID_CAT + 500, 0, name, 0, 0, 0, 0, NULL, 0, 0, 0, 0, catOrder, 0, 1, 0, '0000-00-00 00:00:00', 0, 0, '' FROM smf_categories ORDER BY catOrder";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());

// Import the forums
$query="INSERT INTO jos_sb_categories (id,parent,name,ordering,description,pub_access,pub_recurse,published) SELECT ID_BOARD, ID_CAT + 500, name, boardOrder, description, 0, 0, 1 FROM smf_boards";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());

echo "<br />OK...categories and boards imported successfully!<br />";

//Populate Users Table
echo "<br />Populating Users Table...<br />";

$query="TRUNCATE TABLE jos_sb_users";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());

// Get the group id:s for regular users and administrators in Mambo.
$query = "SELECT group_id FROM jos_core_acl_aro_groups WHERE name='Registered' OR name='Super Administrator' ORDER BY name ASC";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());
$admingid = mysql_result( $result, 0, 0 );
$usergid = mysql_result( $result, 1, 0 );

// Read all users from SMF
$query="SELECT * FROM smf_members WHERE ID_MEMBER > 0 ORDER BY ID_MEMBER";
$result = mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());

while ( $row = mysql_fetch_object( $result ) ) {

$id_query="SELECT id FROM jos_users WHERE username = '$row->memberName'";
$id_result = mysql_query($id_query) or die("<br />Invalid query:<br />$id_query<br />" . mysql_error());
$row2 = mysql_fetch_object($id_result);
$jos_id = $row2->id;

if ( $jos_id <> 0 ) {
   // Convert date for last visit and register date.
   $registerDate = date( "Y-m-d H:i:s", $joindate );
   $lastvisitDate = date( "Y-m-d H:i:s", $lastlog );

   // Set user type and group id
   if ( $row->ID_GROUP == "1" ) {
      $usertype = "administrator";
      $gid = $admingid;
   } else {
      $usertype = "user";
      $gid = "0";
   }

   print "$row->username, ";

   // Add the user to the simpleboard usertable
   $query = "INSERT INTO `jos_sb_users` (userid, posts, signature) VALUES ('$jos_id', '$row->posts', '$row->signature')";
   mysql_query($query) or die("<br />Invalid query:<br />$query<br />" . mysql_error());
   $did++;
   }
   $total++;
}

echo "<br />Total users " . $total . ", Inserted " . $did . ' of the users...<br><br>(NOTE: If inserted is less than actual, it is due to the user having made a post but has since deleted their account.  The post will still show up as usual though...)<br />';

echo 'User import into JoomlaBoard successful!!<br />';

    $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;

    //
    // Populate Messages into JoomlaBoard
    echo 'Populating ' . mysql_num_rows( $bigr ) . ' messages into JoomlaBoard. <br />';
    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;

        //
        // Get the name of the board
        $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 jos_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'];
        }

        //
        // Get the ID of the message poster
        $r = mysql_query( "SELECT id FROM jos_users where username='$posterName'") or die(mysql_error());
        if (mysql_num_rows($r) == 0 )
            $userid = '-1';
        else
        {
            $result = mysql_fetch_array($r);
            $userid = $result['id'];
        }

        $query = "INSERT INTO jos_sb_messages VALUES ('', '$parent', '$thread', '$catid', '$posterName', '$userid', '
$posterEmail', '$subject', '$posterTime', '$posterIP', '0', '0', '0', '0', '0', '0' )";
        mysql_query( $query ) or die ("$query" . "<br />" . mysql_error());

        $r = mysql_query( "SELECT id FROM jos_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 jos_sb_messages SET thread = '$threadupdate' WHERE id='$prec_sb_id'") or die(mysql_error());

        //
        // Insert Message Text into JoomlaBoard
        $query = "INSERT INTO jos_sb_messages_text VALUES ('$prec_sb_id', '$body')";
        mysql_query($query) or die ("$query" . "<br />" . mysql_error());

        $prec_smf_topic = $id_topic;
    }
    echo "<br />Message import Successful!<br /><br /><br />Conversion completed successfully!!!<br /><br />You may now verify the installation was successful and then delete your SMF files and data.<br /><br />Enjoy JoomlaBoard!";
?>

// Get the group id:s for regular users and administrators in Mambo.

mysql_connect("name_of_the_database", "username_for_the_database", "password")
and
mysql_select_db("name_of_the_database")

<?php

function connectbdd()
{
    if( false == mysql_connect("LOCATION_OF_DB", "USERNAME", "PASSWORD") )  /// FILL with your connections details
        die("Error");
   
    if( false == mysql_select_db("DB_NAME") ) // FILL with your database name
        die("Error.");
}

?>

$ php index.php