function d3forum_import_from_cbb( $mydirname , $import_mid )
{
	$db =& Database::getInstance() ;
	$from_prefix = 'bb' ;

	// get group_ids
	$group_handler =& xoops_gethandler( 'group' ) ;
	$group_objects =& $group_handler->getObjects() ;
	$group_ids = array() ;
	foreach( $group_objects as $group_object ) {
		$group_ids[] = $group_object->getVar('groupid') ;
	}

	// categories
	$table_name = 'categories' ;
	$to_table = $db->prefix( $mydirname.'_'.$table_name ) ;
	$from_table = $db->prefix( $from_prefix.'_'.$table_name ) ;
	$db->query( "DELETE FROM `$to_table`" ) ;
	$irs = $db->query( "INSERT INTO `$to_table` (cat_id,cat_title,cat_weight) SELECT cat_id,cat_title,cat_order FROM `$from_table`" ) ;
	if( ! $irs ) d3forum_import_errordie() ;

	// forums
	$table_name = 'forums' ;
	$to_table = $db->prefix( $mydirname.'_'.$table_name ) ;
	$from_table = $db->prefix( $from_prefix.'_'.$table_name ) ;
	$db->query( "DELETE FROM `$to_table`" ) ;
	$irs = $db->query( "INSERT INTO `$to_table` (forum_id,forum_title,forum_desc,forum_weight,cat_id) SELECT forum_id,forum_name,forum_desc,forum_order,cat_id FROM `$from_table`" ) ;
	if( ! $irs ) d3forum_import_errordie() ;

	// topics
	$table_name = 'topics' ;
	$to_table = $db->prefix( $mydirname.'_'.$table_name ) ;
	$from_table = $db->prefix( $from_prefix.'_'.$table_name ) ;
	$db->query( "DELETE FROM `$to_table`" ) ;
	$irs = $db->query( "INSERT INTO `$to_table` (topic_id,topic_title,topic_views,forum_id,topic_locked,topic_sticky,topic_solved,topic_invisible) SELECT topic_id,topic_title,topic_views,forum_id,topic_status,topic_sticky,1,approved FROM `$from_table`" ) ;
	if( ! $irs ) d3forum_import_errordie() ;

	// posts
	$table_name = 'posts' ;
	$to_table = $db->prefix( $mydirname.'_'.$table_name ) ;
	$from_table = $db->prefix( $from_prefix.'_'.$table_name ) ;
	$from_text_table = $db->prefix( $from_prefix.'_'.'posts_text') ;
	$db->query( "DELETE FROM `$to_table`" ) ;
	$irs = $db->query( "INSERT INTO `$to_table` (post_id,pid,topic_id,post_time,modified_time,uid,poster_ip,modifier_ip,subject,html,smiley,xcode,br,number_entity,special_entity,icon,attachsig,invisible,approval,post_text) SELECT p.post_id,pid,topic_id,post_time,post_time,uid,poster_ip,poster_ip,subject,!nohtml,!nosmiley,1,1,1,1,IF(SUBSTRING(icon,5,1),SUBSTRING(icon,5,1),1),attachsig,0,1,pt.post_text FROM `$from_table` p LEFT JOIN `$from_text_table` pt ON p.post_id=pt.post_id" ) ;
	if( ! $irs ) d3forum_import_errordie() ;
}