Simple Machines Community Forum

Hi, i'd like to convert my forum  with installed phpbb2 + the mod category hierarchy.

i read something in this forum but i dont understand all.

which conversion file i have to use?

thanks

There isn't one on the downloads page. However, I do have two different modified versions that I made for someone else a while back. Both of those are for older versions of SMF though, so if you can tell me which version of the hack you're using, I'll update the appropriate one and post it here for you.

it is a long story.

initially i've installed the phbb 1.17

after i applyied the MOD category hierarchy (i dont remember which version) by hand, changing row by row the code..

now. i tryed to update the forum at the latest version but it give a lot of problems.

now.

how can i know the versione of the 2 software installed? ( forum, MOD)?

the forum is http://mad.ilbello.com

EDIT:
i've just read another topic[url] about conversion from phpbb2 to SMF and i've found the same error.

now i've tryed whit the script of J J Williams, i don't have the preview errore but another one

(http://www.simplemachines.org/community/index.php?topic=118748.0)Converting ranks... Successful.
Converting groups... Successful.
Converting smileys...
Fatal error: Call to undefined function copy_dir() in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 13

this is giving ALL 0777 Chmod; whitout it errors are more than 10

my mysql server is "MySQL - 5.0.22-standard"

[Sorry for my english]

EUREKA

i've resolved my problem

as written in THIS (http://www.simplemachines.org/community/index.php?topic=107868.0) topic the function copy_dir must by in the begin of the file ;)

if you want to fix the problem and re-upload the correctr file...

[it works also with the mod Category hierarchy but it don't care of subforum and al forums and subforums goes in forums (and not subforum). if there is a script that do it  just give me the link]

Thanks to all support

I do have scripts laying around here that will convert with the categories hierarchy mod installed. I'll go dig them up and update the 1.1 RC3 converter (the one that actually works - not the one on the download page) accordingly.

Ok. Try these. The first one works with the most recent version of the hack. The second one works with an older version of the hack. If neither one of these works, send me a copy of your table structure and I'll try to fix things for you.

EDIT: See http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058 for current converter.

tomorrow i'll try and tell you how it goes ;)

I could'nt wait till tomorrow.

i've tryed now but it doesen't work fine

both of the file you given me answer with an error

:the "older" file

Converting boards... Unsuccessful!
This query:

    SELECT
    f.forum_id AS ID_BOARD, f.forum_order AS boardOrder, f.forum_posts AS numPosts,
    f.forum_last_post_id AS ID_LAST_MSG, SUBSTRING(f.forum_name, 1, 255) AS name,
    SUBSTRING(f.forum_desc, 1, 65534) AS description, f.forum_topics AS numTopics,
    IF((f.main_type IS NULL) OR f.main_type = 'c', f.cat_id, fp.cat_id) AS ID_CAT,
    IF(f.main_type = 'f', f.id_cat, f.id_forum) AS ID_PARENT,
    CASE auth_read
    WHEN 0 THEN '-1,0,2'
    WHEN 1 THEN '0,2'
    WHEN 3 THEN '2'
    ELSE ''
    END AS memberGroups
    FROM `_mad`.phpbb_forums AS f, `_mad`.phpbb_forums AS fp
    WHERE f.forum_id = fp.cat_id
    AND f.forum_id > 0
    AND f.main_type = 'f'
    LIMIT 0, 500;

Caused the error:

    Unknown column 'f.main_type' in 'field list'

the other gives a similar error in the category conversion.

i've exported the phpbb_ tables in this file


-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 12 Ott, 2006 at 11:10 AM
-- Versione MySQL: 5.0.22
-- Versione PHP: 5.1.6
--
-- Database: `_mad`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_categories`
--

CREATE TABLE `phpbb_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_config`
--

CREATE TABLE `phpbb_config` (
  `config_name` varchar(255) NOT NULL default '',
  `config_value` varchar(255) NOT NULL default '',
  `config_static` smallint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`config_name`),
  KEY `config_static` (`config_static`),
  KEY `config_static_2` (`config_static`),
  KEY `config_static_3` (`config_static`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_confirm`
--

CREATE TABLE `phpbb_confirm` (
  `confirm_id` char(32) NOT NULL default '',
  `session_id` char(32) NOT NULL default '',
  `code` char(6) NOT NULL default '',
  PRIMARY KEY  (`session_id`,`confirm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_cp_fields`
--

CREATE TABLE `phpbb_cp_fields` (
  `field_id` mediumint(8) unsigned NOT NULL auto_increment,
  `field_name` varchar(50) NOT NULL default '',
  `panel_id` mediumint(8) unsigned NOT NULL default '0',
  `field_order` mediumint(8) unsigned NOT NULL default '0',
  `field_attr` text NOT NULL,
  PRIMARY KEY  (`field_id`),
  KEY `panel_id` (`panel_id`,`field_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_cp_panels`
--

CREATE TABLE `phpbb_cp_panels` (
  `panel_id` mediumint(8) unsigned NOT NULL auto_increment,
  `panel_shortcut` varchar(30) NOT NULL default '',
  `panel_name` varchar(50) NOT NULL default '',
  `panel_main` mediumint(8) unsigned NOT NULL default '0',
  `panel_order` mediumint(8) unsigned NOT NULL default '0',
  `panel_file` varchar(50) NOT NULL default '',
  `panel_auth_type` char(1) character set latin1 collate latin1_bin NOT NULL default '',
  `panel_auth_name` varchar(50) NOT NULL default '',
  `panel_hidden` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`panel_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_cp_patches`
--

CREATE TABLE `phpbb_cp_patches` (
  `patch_id` mediumint(8) unsigned NOT NULL auto_increment,
  `patch_file` varchar(255) NOT NULL default '',
  `patch_time` int(11) NOT NULL default '0',
  `patch_version` varchar(25) NOT NULL default '',
  `patch_date` varchar(8) NOT NULL default '',
  `patch_ref` varchar(255) NOT NULL default '',
  `patch_author` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`patch_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_disallow`
--

CREATE TABLE `phpbb_disallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL auto_increment,
  `disallow_username` varchar(25) NOT NULL default '',
  PRIMARY KEY  (`disallow_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_forum_prune`
--

CREATE TABLE `phpbb_forum_prune` (
  `prune_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `prune_days` smallint(5) unsigned NOT NULL default '0',
  `prune_freq` smallint(5) unsigned NOT NULL default '0',
  PRIMARY KEY  (`prune_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_forums`
--

CREATE TABLE `phpbb_forums` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_main` smallint(5) unsigned NOT NULL,
  `forum_type` char(1) character set latin1 collate latin1_bin NOT NULL default 'f',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_global_announce` tinyint(2) NOT NULL,
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  `forum_last_title` varchar(255) default NULL,
  `forum_last_poster` mediumint(8) NOT NULL,
  `forum_last_username` varchar(25) default NULL,
  `forum_last_time` int(11) NOT NULL,
  `forum_link` varchar(255) default NULL,
  `forum_link_hit_count` tinyint(1) NOT NULL,
  `forum_link_hit` bigint(20) unsigned NOT NULL,
  `forum_link_start` int(11) NOT NULL,
  `forum_style` tinyint(4) NOT NULL,
  `forum_nav_icon` varchar(255) default NULL,
  `forum_icon` varchar(255) default NULL,
  `forum_topics_ppage` tinyint(2) NOT NULL,
  `forum_topics_sort` varchar(25) default NULL,
  `forum_topics_order` varchar(4) default NULL,
  `forum_index_pack` tinyint(1) NOT NULL,
  `forum_index_split` tinyint(1) NOT NULL,
  `forum_board_box` tinyint(1) NOT NULL,
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_groups`
--

CREATE TABLE `phpbb_groups` (
  `group_id` mediumint(8) NOT NULL auto_increment,
  `group_type` tinyint(4) NOT NULL default '1',
  `group_name` varchar(40) NOT NULL default '',
  `group_description` varchar(255) NOT NULL default '',
  `group_moderator` mediumint(8) NOT NULL default '0',
  `group_single_user` tinyint(1) NOT NULL default '1',
  `group_status` tinyint(2) NOT NULL,
  `group_user_id` mediumint(8) NOT NULL default '0',
  `group_user_list` text NOT NULL,
  PRIMARY KEY  (`group_id`),
  KEY `group_single_user` (`group_single_user`),
  KEY `group_user_id` (`group_user_id`),
  KEY `group_user_id_2` (`group_user_id`),
  KEY `group_user_id_3` (`group_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1312 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_icons`
--

CREATE TABLE `phpbb_icons` (
  `icon_id` mediumint(3) NOT NULL auto_increment,
  `icon_name` varchar(50) NOT NULL default '',
  `icon_url` varchar(255) NOT NULL default '',
  `icon_acl` tinyint(2) NOT NULL default '0',
  `icon_types` varchar(255) default NULL,
  `icon_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`icon_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=23 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_posts`
--

CREATE TABLE `phpbb_posts` (
  `post_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `poster_id` mediumint(8) NOT NULL default '0',
  `post_time` int(11) NOT NULL default '0',
  `poster_ip` varchar(8) NOT NULL default '',
  `post_username` varchar(25) default NULL,
  `enable_bbcode` tinyint(1) NOT NULL default '1',
  `enable_html` tinyint(1) NOT NULL default '0',
  `enable_smilies` tinyint(1) NOT NULL default '1',
  `enable_sig` tinyint(1) NOT NULL default '1',
  `post_edit_time` int(11) default NULL,
  `post_edit_count` smallint(5) unsigned NOT NULL default '0',
  `post_icon` smallint(3) unsigned NOT NULL,
  PRIMARY KEY  (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`),
  KEY `post_icon` (`post_icon`),
  KEY `post_icon_2` (`post_icon`),
  KEY `post_icon_3` (`post_icon`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22124 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_posts_text`
--

CREATE TABLE `phpbb_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `bbcode_uid` varchar(10) NOT NULL default '',
  `post_subject` varchar(255) default NULL,
  `post_text` text,
  `post_sub_title` varchar(255) default NULL,
  PRIMARY KEY  (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_presets`
--

CREATE TABLE `phpbb_presets` (
  `preset_id` mediumint(5) unsigned NOT NULL auto_increment,
  `preset_type` varchar(5) NOT NULL default '',
  `preset_name` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`preset_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_presets_data`
--

CREATE TABLE `phpbb_presets_data` (
  `preset_id` mediumint(5) unsigned NOT NULL default '0',
  `preset_auth` varchar(50) NOT NULL default '',
  `preset_value` tinyint(1) default NULL,
  PRIMARY KEY  (`preset_id`,`preset_auth`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_privmsgs`
--

CREATE TABLE `phpbb_privmsgs` (
  `privmsgs_id` mediumint(8) unsigned NOT NULL auto_increment,
  `privmsgs_type` tinyint(4) NOT NULL default '0',
  `privmsgs_subject` varchar(255) NOT NULL default '0',
  `privmsgs_from_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_to_userid` mediumint(8) NOT NULL default '0',
  `privmsgs_date` int(11) NOT NULL default '0',
  `privmsgs_ip` varchar(8) NOT NULL default '',
  `privmsgs_enable_bbcode` tinyint(1) NOT NULL default '1',
  `privmsgs_enable_html` tinyint(1) NOT NULL default '0',
  `privmsgs_enable_smilies` tinyint(1) NOT NULL default '1',
  `privmsgs_attach_sig` tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (`privmsgs_id`),
  KEY `privmsgs_from_userid` (`privmsgs_from_userid`),
  KEY `privmsgs_to_userid` (`privmsgs_to_userid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4320 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_privmsgs_text`
--

CREATE TABLE `phpbb_privmsgs_text` (
  `privmsgs_text_id` mediumint(8) unsigned NOT NULL default '0',
  `privmsgs_bbcode_uid` varchar(10) NOT NULL default '0',
  `privmsgs_text` text,
  PRIMARY KEY  (`privmsgs_text_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_ranks`
--

CREATE TABLE `phpbb_ranks` (
  `rank_id` smallint(5) unsigned NOT NULL auto_increment,
  `rank_title` varchar(50) NOT NULL default '',
  `rank_min` mediumint(8) NOT NULL default '0',
  `rank_special` tinyint(1) default '0',
  `rank_image` varchar(255) default NULL,
  PRIMARY KEY  (`rank_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_search_results`
--

CREATE TABLE `phpbb_search_results` (
  `search_id` int(11) unsigned NOT NULL default '0',
  `session_id` varchar(32) NOT NULL default '',
  `search_array` text NOT NULL,
  `search_time` int(11) NOT NULL default '0',
  PRIMARY KEY  (`search_id`),
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_search_wordlist`
--

CREATE TABLE `phpbb_search_wordlist` (
  `word_text` varchar(50) character set latin1 collate latin1_bin NOT NULL default '',
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word_common` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`word_text`),
  KEY `word_id` (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=159079 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_search_wordmatch`
--

CREATE TABLE `phpbb_search_wordmatch` (
  `post_id` mediumint(8) unsigned NOT NULL default '0',
  `word_id` mediumint(8) unsigned NOT NULL default '0',
  `title_match` tinyint(1) NOT NULL default '0',
  KEY `post_id` (`post_id`),
  KEY `word_id` (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_sessions`
--

CREATE TABLE `phpbb_sessions` (
  `session_id` char(32) NOT NULL default '',
  `session_user_id` mediumint(8) NOT NULL default '0',
  `session_start` int(11) NOT NULL default '0',
  `session_time` int(11) NOT NULL default '0',
  `session_ip` char(8) NOT NULL default '0',
  `session_page` int(11) NOT NULL default '0',
  `session_logged_in` tinyint(1) NOT NULL default '0',
  `session_admin` tinyint(2) NOT NULL default '0',
  PRIMARY KEY  (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_id_ip_user_id` (`session_id`,`session_ip`,`session_user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_sessions_keys`
--

CREATE TABLE `phpbb_sessions_keys` (
  `key_id` varchar(32) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `last_ip` varchar(8) NOT NULL default '0',
  `last_login` int(11) NOT NULL default '0',
  PRIMARY KEY  (`key_id`,`user_id`),
  KEY `last_login` (`last_login`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_smilies`
--

CREATE TABLE `phpbb_smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL auto_increment,
  `code` varchar(50) default NULL,
  `smile_url` varchar(100) default NULL,
  `emoticon` varchar(75) default NULL,
  PRIMARY KEY  (`smilies_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=100 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_themes`
--

CREATE TABLE `phpbb_themes` (
  `themes_id` mediumint(8) unsigned NOT NULL auto_increment,
  `template_name` varchar(30) NOT NULL default '',
  `style_name` varchar(30) NOT NULL default '',
  `images_pack` varchar(100) NOT NULL,
  `custom_tpls` varchar(100) NOT NULL,
  `head_stylesheet` varchar(100) default NULL,
  `body_background` varchar(100) default NULL,
  `body_bgcolor` varchar(6) default NULL,
  `body_text` varchar(6) default NULL,
  `body_link` varchar(6) default NULL,
  `body_vlink` varchar(6) default NULL,
  `body_alink` varchar(6) default NULL,
  `body_hlink` varchar(6) default NULL,
  `tr_color1` varchar(6) default NULL,
  `tr_color2` varchar(6) default NULL,
  `tr_color3` varchar(6) default NULL,
  `tr_class1` varchar(25) default NULL,
  `tr_class2` varchar(25) default NULL,
  `tr_class3` varchar(25) default NULL,
  `th_color1` varchar(6) default NULL,
  `th_color2` varchar(6) default NULL,
  `th_color3` varchar(6) default NULL,
  `th_class1` varchar(25) default NULL,
  `th_class2` varchar(25) default NULL,
  `th_class3` varchar(25) default NULL,
  `td_color1` varchar(6) default NULL,
  `td_color2` varchar(6) default NULL,
  `td_color3` varchar(6) default NULL,
  `td_class1` varchar(25) default NULL,
  `td_class2` varchar(25) default NULL,
  `td_class3` varchar(25) default NULL,
  `fontface1` varchar(50) default NULL,
  `fontface2` varchar(50) default NULL,
  `fontface3` varchar(50) default NULL,
  `fontsize1` tinyint(4) default NULL,
  `fontsize2` tinyint(4) default NULL,
  `fontsize3` tinyint(4) default NULL,
  `fontcolor1` varchar(6) default NULL,
  `fontcolor2` varchar(6) default NULL,
  `fontcolor3` varchar(6) default NULL,
  `span_class1` varchar(25) default NULL,
  `span_class2` varchar(25) default NULL,
  `span_class3` varchar(25) default NULL,
  `img_size_poll` smallint(5) unsigned default NULL,
  `img_size_privmsg` smallint(5) unsigned default NULL,
  PRIMARY KEY  (`themes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_themes_name`
--

CREATE TABLE `phpbb_themes_name` (
  `themes_id` smallint(5) unsigned NOT NULL default '0',
  `tr_color1_name` char(50) default NULL,
  `tr_color2_name` char(50) default NULL,
  `tr_color3_name` char(50) default NULL,
  `tr_class1_name` char(50) default NULL,
  `tr_class2_name` char(50) default NULL,
  `tr_class3_name` char(50) default NULL,
  `th_color1_name` char(50) default NULL,
  `th_color2_name` char(50) default NULL,
  `th_color3_name` char(50) default NULL,
  `th_class1_name` char(50) default NULL,
  `th_class2_name` char(50) default NULL,
  `th_class3_name` char(50) default NULL,
  `td_color1_name` char(50) default NULL,
  `td_color2_name` char(50) default NULL,
  `td_color3_name` char(50) default NULL,
  `td_class1_name` char(50) default NULL,
  `td_class2_name` char(50) default NULL,
  `td_class3_name` char(50) default NULL,
  `fontface1_name` char(50) default NULL,
  `fontface2_name` char(50) default NULL,
  `fontface3_name` char(50) default NULL,
  `fontsize1_name` char(50) default NULL,
  `fontsize2_name` char(50) default NULL,
  `fontsize3_name` char(50) default NULL,
  `fontcolor1_name` char(50) default NULL,
  `fontcolor2_name` char(50) default NULL,
  `fontcolor3_name` char(50) default NULL,
  `span_class1_name` char(50) default NULL,
  `span_class2_name` char(50) default NULL,
  `span_class3_name` char(50) default NULL,
  PRIMARY KEY  (`themes_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_topics`
--

CREATE TABLE `phpbb_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL auto_increment,
  `forum_id` smallint(8) unsigned NOT NULL default '0',
  `topic_title` varchar(255) NOT NULL,
  `topic_poster` mediumint(8) NOT NULL default '0',
  `topic_time` int(11) NOT NULL default '0',
  `topic_views` mediumint(8) unsigned NOT NULL default '0',
  `topic_replies` mediumint(8) unsigned NOT NULL default '0',
  `topic_status` tinyint(3) NOT NULL default '0',
  `topic_vote` tinyint(1) NOT NULL default '0',
  `topic_type` tinyint(3) NOT NULL default '0',
  `topic_first_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_moved_id` mediumint(8) unsigned NOT NULL default '0',
  `topic_sub_title` varchar(255) default NULL,
  `topic_first_username` varchar(25) default NULL,
  `topic_last_poster` mediumint(8) NOT NULL,
  `topic_last_username` varchar(25) default NULL,
  `topic_last_time` int(11) NOT NULL,
  `topic_icon` smallint(3) unsigned NOT NULL,
  `topic_duration` int(11) NOT NULL,
  PRIMARY KEY  (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`),
  KEY `topic_last_time` (`topic_last_time`),
  KEY `topic_last_time_2` (`topic_last_time`),
  KEY `topic_last_time_3` (`topic_last_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4801 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_topics_watch`
--

CREATE TABLE `phpbb_topics_watch` (
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `notify_status` tinyint(1) NOT NULL default '0',
  KEY `topic_id` (`topic_id`),
  KEY `user_id` (`user_id`),
  KEY `notify_status` (`notify_status`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_user_group`
--

CREATE TABLE `phpbb_user_group` (
  `group_id` mediumint(8) NOT NULL default '0',
  `user_id` mediumint(8) NOT NULL default '0',
  `user_pending` tinyint(1) default NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_users`
--

CREATE TABLE `phpbb_users` (
  `user_id` mediumint(8) NOT NULL default '0',
  `user_active` tinyint(1) default '1',
  `username` varchar(25) NOT NULL default '',
  `user_password` varchar(32) NOT NULL default '',
  `user_session_time` int(11) NOT NULL default '0',
  `user_session_page` smallint(5) NOT NULL default '0',
  `user_lastvisit` int(11) NOT NULL default '0',
  `user_regdate` int(11) NOT NULL default '0',
  `user_level` tinyint(4) default '0',
  `user_posts` mediumint(8) unsigned NOT NULL default '0',
  `user_timezone` decimal(5,2) NOT NULL default '0.00',
  `user_style` tinyint(4) default NULL,
  `user_lang` varchar(255) default NULL,
  `user_dateformat` varchar(14) NOT NULL default 'd M Y H:i',
  `user_new_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_unread_privmsg` smallint(5) unsigned NOT NULL default '0',
  `user_last_privmsg` int(11) NOT NULL default '0',
  `user_emailtime` int(11) default NULL,
  `user_viewemail` tinyint(1) default NULL,
  `user_attachsig` tinyint(1) default NULL,
  `user_allowhtml` tinyint(1) default '1',
  `user_allowbbcode` tinyint(1) default '1',
  `user_allowsmile` tinyint(1) default '1',
  `user_allowavatar` tinyint(1) NOT NULL default '1',
  `user_allow_pm` tinyint(1) NOT NULL default '1',
  `user_allow_viewonline` tinyint(1) NOT NULL default '1',
  `user_notify` tinyint(1) NOT NULL default '1',
  `user_notify_pm` tinyint(1) NOT NULL default '0',
  `user_popup_pm` tinyint(1) NOT NULL default '0',
  `user_rank` int(11) default '0',
  `user_avatar` varchar(100) default NULL,
  `user_avatar_type` tinyint(4) NOT NULL default '0',
  `user_email` varchar(255) default NULL,
  `user_icq` varchar(15) default NULL,
  `user_website` varchar(100) default NULL,
  `user_from` varchar(100) default NULL,
  `user_sig` text,
  `user_sig_bbcode_uid` varchar(10) default NULL,
  `user_aim` varchar(255) default NULL,
  `user_yim` varchar(255) default NULL,
  `user_msnm` varchar(255) default NULL,
  `user_occ` varchar(100) default NULL,
  `user_interests` varchar(255) default NULL,
  `user_actkey` varchar(32) default NULL,
  `user_newpasswd` varchar(32) default NULL,
  `user_unread_date` int(11) NOT NULL,
  `user_unread_topics` text,
  `user_keep_unreads` tinyint(1) NOT NULL,
  `user_topics_sort` varchar(25) NOT NULL,
  `user_topics_order` varchar(4) NOT NULL,
  `user_smart_date` tinyint(1) NOT NULL,
  `user_board_box` tinyint(1) NOT NULL,
  `user_index_pack` tinyint(1) NOT NULL,
  `user_index_split` tinyint(1) NOT NULL,
  `user_session_logged` tinyint(1) NOT NULL,
  `user_login_tries` smallint(5) unsigned NOT NULL default '0',
  `user_last_login_try` int(11) NOT NULL default '0',
  PRIMARY KEY  (`user_id`),
  KEY `user_session_time` (`user_session_time`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_users_cache`
--

CREATE TABLE `phpbb_users_cache` (
  `user_id` mediumint(8) NOT NULL,
  `cache_id` varchar(5) NOT NULL,
  `cache_data` text,
  `cache_time` int(11) default NULL,
  PRIMARY KEY  (`user_id`,`cache_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_vote_desc`
--

CREATE TABLE `phpbb_vote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topic_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_text` text NOT NULL,
  `vote_start` int(11) NOT NULL default '0',
  `vote_length` int(11) NOT NULL default '0',
  PRIMARY KEY  (`vote_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_vote_results`
--

CREATE TABLE `phpbb_vote_results` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_option_id` tinyint(4) unsigned NOT NULL default '0',
  `vote_option_text` varchar(255) NOT NULL default '',
  `vote_result` int(11) NOT NULL default '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_vote_voters`
--

CREATE TABLE `phpbb_vote_voters` (
  `vote_id` mediumint(8) unsigned NOT NULL default '0',
  `vote_user_id` mediumint(8) NOT NULL default '0',
  `vote_user_ip` char(8) NOT NULL default '',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_words`
--

CREATE TABLE `phpbb_words` (
  `word_id` mediumint(8) unsigned NOT NULL auto_increment,
  `word` char(100) NOT NULL default '',
  `replacement` char(100) NOT NULL default '',
  PRIMARY KEY  (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

-- --------------------------------------------------------

--
-- Struttura della tabella `shoutbox`
--

CREATE TABLE `shoutbox` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `shouttext` varchar(255) NOT NULL default '',
  `shoutdate` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;


i think that it is you need.
if not tell me how to hel you ;)

What error do you get with the new one?

ok

if i try to use the first one the error is this.


Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys...
Fatal error: Call to undefined function copy_dir() in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 13

but after this error i understand that this is a common error that almost all who try to use this converter have.

so, i copy the "copy_dir()" function at the begin of sql file.

so, the first pow in file where i can paste the function is after the simle conversion:


/******************************************************************************/
--- Converting smileys...
/******************************************************************************/


TRUNCATE {$to_prefix}smileys;

---# Copying over smilies directory...
---{
function copy_smilies($source, $dest)
{
if (!is_dir($source) || !($dir = opendir($source)))
return;

while ($file = readdir($dir))
{
if ($file == '.' || $file == '..')
continue;

// If we have a directory create it on the destination and copy contents into it!
if (is_dir($source . '/' . $file))
{
@mkdir($dest . '/' . $file, 0777);
copy_dir($source . '/' . $file, $dest . '/' . $file);
}
else
copy($source . '/' . $file, $dest . '/' . $file);
}
closedir($dir);
}

function copy_dir($source, $dest)
{
if (!is_dir($source) || !($dir = opendir($source)))
return;

while ($file = readdir($dir))
{
if ($file == '.' || $file == '..')
continue;

// If we have a directory create it on the destination and copy contents into it!
if (is_dir($source . '/' . $file))
{
@mkdir($dest . '/' . $file, 0777);
copy_dir($source . '/' . $file, $dest . '/' . $file);
}
else
copy($source . '/' . $file, $dest . '/' . $file);
}
closedir($dir);
}



but howaver i have these errors:

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys...
Warning: copy() [function.copy]: SAFE MODE Restriction in effect. The script whose uid is 1032 is not allowed to access /home/hosting/MAD/forum_smf/Smileys/default/smiles/001.gif owned by uid 33 in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 35

Warning: copy(/home/hosting/MAD/forum_smf/Smileys/default/smiles/001.gif) [function.copy]: failed to open stream: Success in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 35

[***other similar messages***]

Warning: copy(/home/hosting/MAD/forum_smf/Smileys/default/smiles/fenforcer.gif) [function.copy]: failed to open stream: Success in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 35

Warning: copy() [function.copy]: SAFE MODE Restriction in effect. The script whose uid is 1032 is not allowed to access /home/hosting/MAD/forum_smf/Smileys/default/smiles/fflak.gif owned by uid 33 in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 35

Warning: copy(/home/hosting/MAD/forum_smf/Smileys/default/smiles/fflak.gif) [function.copy]: failed to open stream: Success in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 35
Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Unsuccessful!
This query:

    SELECT
    forum_id AS ID_CAT, forum_title AS name, forum_order AS catOrder
    FROM `_mad`.phpbb_forums
    WHERE forum_main = '0'
    LIMIT 0, 500;

Caused the error:

    Unknown column 'forum_title' in 'field list'

so, if you want we can try to solve the problem by msn so we can work in real time.

i've added you in my contact list. if you want to accept me... ;)

thanks for the attention

The errors with copy simply mean that your host has safe mode enabled, which prevents scripts from accessing files and folders they don't own. It looks like the smileys were successfully copied, but the script can't touch them after they've been copied because they're now owned by the server and not by you. I strongly suggest either trying to convince your host to use open_basedir instead or switching to a host that doesn't use safe mode. Some things in SMF won't work properly with Safe Mode enabled (namely the package manager).

The other issue is simply a typo - I had "forum_title" in the query to convert categories instead of forum_name. The attached version should work (this one also has copy_dir at the beginning of the SQL file instead of where it was).

EDIT: Please see http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058 (http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058) for current converter

ok.

i've tryed your script.

it has some problems.

1-the copy_dir() function is in the wrong place (or better, on my server doesen't work)
    I've tryed to fix the problem and it seams working fine now.

2-the copy_dir() can't be MOVED from the end of the file to the begin but must be COPYied
   I think i've fixed also this.

3- in the end, the script works but the result is the same of the other script (not for category hierarchy) and subforums are listed all in the first page.

I thank you for your help. i suggest to public the new working version of the script.

this is the report that the conversion give now:


Converting...
Converting posts (this may take some time)... Successful.
Converting polls... Successful.
Converting poll options... Successful.
Converting poll votes... Successful.
Converting personal messages (step 1)... Successful.
Converting personal messages (step 2)... Successful.
Converting topic notifications... Successful.
Converting board access... Successful.
Converting group access... Successful.
Converting moderators... Successful.
Converting avatar gallery images...
Warning: copy() [function.copy]: SAFE MODE Restriction in effect. The script whose uid is 1032 is not allowed to access /home/hosting/MAD/forum_smf/avatars/gallery/index.htm owned by uid 33 in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 16

Warning: copy(/home/hosting/MAD/forum_smf/avatars/gallery/index.htm) [function.copy]: failed to open stream: Success in /home/hosting/MAD/forum_smf/convert.php(653) : eval()'d code on line 16
Successful.
Converting censored words... Successful.
Converting reserved names... Successful.
Converting banned users... Successful.
Converting settings... Successful.
Converting attachment mod (if installed)... Successful.
Recalculating forum statistics... Successful.
Conversion Complete
Congratulations, the conversion has completed sucessfully. If you have or had any problems with this converter, or need help using SMF, please feel free to look to us for support.
Now that everything is converted over, your SMF installation should have all the posts, boards, and members from the phpBB2 with Categories Hierarchy installation.

We hope you had a smooth transition!

the forum is at this link

http://MAD.ilbello.com (the phpbb forum)
http://MAD.ilbello.com/forum_smf (the smf just installed forum)

some subforum ar not visible at guests, but is the same for other topics.

i include my version of the script just tested ;)
[Damn i can't include files... :P]

Here the link.
http://z02.zupload.com/download.php?file=getfile&filepath=8846

The copy functions won't work on your server because of safe mode. It's a pain, but there's no real way to get around it. The copy_dir function can be fixed more easily by just moving it to the end of convert.php. I just moved it to the beginning of the sql file because that's what you said you did...

If you can send me a copy of the data from the phpbb_categories and phpbb_forums tables, I will be glad to see what I can do to make this work for you. It's hard to make one version that will work for everyone because not everyone will be using the most recent version of the hack. This is one of those things that I basically have to do on a case-by-case basis - modify it for each person as needed.

ok.

the dump of the two table you said are below


-- phpMyAdmin SQL Dump
-- version 2.8.2.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generato il: 13 Ott, 2006 at 07:43 PM
-- Versione MySQL: 5.0.22
-- Versione PHP: 5.1.6
--
-- Database: `_mad`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_categories`
--

CREATE TABLE `phpbb_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL auto_increment,
  `cat_title` varchar(100) default NULL,
  `cat_order` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ;

--
-- Dump dei dati per la tabella `phpbb_categories`
--

INSERT INTO `phpbb_categories` VALUES (6, 'MAD Story', 0);
INSERT INTO `phpbb_categories` VALUES (7, 'Aiuto e Informazioni', 0);
INSERT INTO `phpbb_categories` VALUES (8, 'Area diplomatica', 0);
INSERT INTO `phpbb_categories` VALUES (9, 'Consiglio di Guerra', 0);
INSERT INTO `phpbb_categories` VALUES (10, 'Rapporti di Spionaggio e Battaglia', 0);
INSERT INTO `phpbb_categories` VALUES (17, 'Wolfestein - Enemy Terrytory', 0);
INSERT INTO `phpbb_categories` VALUES (15, 'Guerra NIGO/LEGRA/RDL/W.L.F./C.U.Me./SW/Elaborar/2112/I.S.O./r0x [Uni 4]', 0);

-- --------------------------------------------------------

--
-- Struttura della tabella `phpbb_forums`
--

CREATE TABLE `phpbb_forums` (
  `forum_id` smallint(5) unsigned NOT NULL default '0',
  `cat_id` mediumint(8) unsigned NOT NULL default '0',
  `forum_name` varchar(150) default NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) NOT NULL default '0',
  `forum_main` smallint(5) unsigned NOT NULL,
  `forum_type` char(1) character set latin1 collate latin1_bin NOT NULL default 'f',
  `forum_order` mediumint(8) unsigned NOT NULL default '1',
  `forum_posts` mediumint(8) unsigned NOT NULL default '0',
  `forum_topics` mediumint(8) unsigned NOT NULL default '0',
  `forum_last_post_id` mediumint(8) unsigned NOT NULL default '0',
  `prune_next` int(11) default NULL,
  `prune_enable` tinyint(1) NOT NULL default '0',
  `auth_view` tinyint(2) NOT NULL default '0',
  `auth_read` tinyint(2) NOT NULL default '0',
  `auth_post` tinyint(2) NOT NULL default '0',
  `auth_reply` tinyint(2) NOT NULL default '0',
  `auth_edit` tinyint(2) NOT NULL default '0',
  `auth_delete` tinyint(2) NOT NULL default '0',
  `auth_sticky` tinyint(2) NOT NULL default '0',
  `auth_announce` tinyint(2) NOT NULL default '0',
  `auth_global_announce` tinyint(2) NOT NULL,
  `auth_vote` tinyint(2) NOT NULL default '0',
  `auth_pollcreate` tinyint(2) NOT NULL default '0',
  `auth_attachments` tinyint(2) NOT NULL default '0',
  `forum_last_title` varchar(255) default NULL,
  `forum_last_poster` mediumint(8) NOT NULL,
  `forum_last_username` varchar(25) default NULL,
  `forum_last_time` int(11) NOT NULL,
  `forum_link` varchar(255) default NULL,
  `forum_link_hit_count` tinyint(1) NOT NULL,
  `forum_link_hit` bigint(20) unsigned NOT NULL,
  `forum_link_start` int(11) NOT NULL,
  `forum_style` tinyint(4) NOT NULL,
  `forum_nav_icon` varchar(255) default NULL,
  `forum_icon` varchar(255) default NULL,
  `forum_topics_ppage` tinyint(2) NOT NULL,
  `forum_topics_sort` varchar(25) default NULL,
  `forum_topics_order` varchar(4) default NULL,
  `forum_index_pack` tinyint(1) NOT NULL,
  `forum_index_split` tinyint(1) NOT NULL,
  `forum_board_box` tinyint(1) NOT NULL,
  PRIMARY KEY  (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dump dei dati per la tabella `phpbb_forums`
--

INSERT INTO `phpbb_forums` VALUES (30, 9, 'Sala delle Medaglie', 'Qua vengono insigniti delle giuste onoreficenze i notri alleati più valorosi\r\n(Privato utenti registrati)', 0, 81, 0x66, 720, 194, 23, 20771, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'cr di guerra - da 5% al 19%', 124, 'crystalct', 1152011855, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (28, 9, 'Richieste di aiuto', 'Postate qui le vostre richieste di aiuto ai sergenti\r\n(Privato tutti gli universi)', 0, 81, 0x66, 730, 1564, 249, 21872, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'informazioni su alivatto', 771, 'ludo', 1158822225, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (32, 10, 'Richieste di spionaggio', 'Postare qua richieste di spionaggio specificando nel titolo del post [Universo *] e almeno la galassia\r\n(Privato tutti gli universi)', 0, 82, 0x66, 870, 254, 72, 20682, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '1:341:12', 970, 'merlyno10', 1151677538, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (29, 7, 'Universo 4', 'In questa sezione potete inserire le vostre richieste e offerte di materiale creando un vero e proprio "mercato delle risorse"<br />(Privato utenti registrati)', 0, 188, 0x66, 250, 6, 4, 21995, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Vendo 1kk di deuterio', 509, 'Zelgadis', 1159529179, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (25, 7, 'Circolo Ufficiali', 'Area di relax... e di SPAM<br />(Privato utenti registrati)', 0, 81, 0x66, 300, 1935, 276, 22138, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'INNO DELLA MAD', 771, 'ludo', 1160683169, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (27, 6, 'L''inizio di un grande forum', '(Privato utenti registrati)', 0, 77, 0x66, 100, 247, 34, 21691, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'un saluto a tutti', 1230, 'perpico', 1157390914, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (13, 6, 'I Sottoufficiali', 'Area dedicata alle presentazioni di tutti i membri dell''alleanza<br />(Privato utenti registrati)', 0, 11, 0x66, 130, 593, 105, 21094, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'ciauuu', 412, 'Leto II', 1153136134, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (11, 6, 'La MAD, ISO, Sez31, CO', 'Area in cui raccontiamo le origini dell''alleanza<br />(Privato utenti registrati)', 0, 77, 0x66, 110, 123, 4, 16064, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Vi presento la MAD di oggi', 11, 'dynamo', 1143152405, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (12, 6, 'Gli Ufficiali', 'Area dedicata alle presentazioni degli Ufficiali<br />(Privato utenti registrati)', 0, 11, 0x66, 120, 80, 10, 21289, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Leto II A.S.', 756, 'fium', 1154031509, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (15, 8, 'Universo 4', 'Area nella quale si possono discutere i patti proposti, proporre nuovi patti, criticare quelli esistenti e discutere della diplomazia<br />(Privato nascosto universo 4)', 0, 128, 0x66, 170, 268, 39, 14211, NULL, 0, 3, 3, 3, 3, 3, 3, 3, 3, 2, 3, 3, 0, 'Mad school??', 384, 'davpal3', 1138385327, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (16, 7, 'Accademia', 'Qua puoi chiedere tutto quello che vuoi sapere su Ogame e MAD<br />(Privato tutti gli universi)', 0, 80, 0x66, 220, 1868, 260, 22105, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'SKIN EvolutionX', 11, 'dynamo', 1160235424, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (17, 7, 'Estratti utili del regolamento', 'Qua potrai trovare estratti del regolamento o parti di discussioni che riguardano le norme da rispettare in OGame<br />(Privato utenti registrati)', 0, 80, 0x66, 230, 21, 19, 15201, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Tabella costi infrastrutture,ricerche,navi', 543, 'fuffy', 1140716740, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (22, 10, 'Universo 4', 'Area in cui inserire i rapporti delle proprie battaglie per poterli analizzare e discutere<br />(Privato tutti gli universi)', 0, 114, 0x66, 800, 1954, 471, 22134, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Fuffy vs Gaisselick', 543, 'fuffy', 1160681599, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (23, 9, 'Gran Consiglio', 'Area privata agli ufficiali di grado elevato per discutere dell''amministrazione dell''alleanza\r\n(Privato Alti Ufficiali e Consiglieri)', 0, 81, 0x66, 310, 108, 10, 19212, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Un saluto da un vecchio Mad in pensione!', 45, 'aragon1', 1148630100, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (24, 9, 'Universo 4', 'Area nella quale si possono discutere le tattiche per la gestione dell''alleanza, le tattiche di guerra e organizzare eventuali attacchi relativi all''Universo 4<br />(Privato nascosto universo 4)', 0, 84, 0x66, 410, 1829, 198, 21590, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'meno 495 posizioni', 5, 'Romaruss', 1155158114, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (88, 0, 'Ogame', 'OGame è un gioco strategico ambientato nello spazio, con migliaia di giocatori che giocano contemporaneamente<br />Prima di giocare sei pregato di leggerti le regole. Tutto quello di cui hai bisogno per giocare è un normale web browser.', 0, 0, 0x6c, 50, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, 'http://mad.ilbello.com/forum/index.php?f=97', 1, 4219, 1137057899, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (37, 9, 'Universo 6', 'Area nella quale si possono discutere le tattiche per la gestione dell''alleanza, le tattiche di guerra e organizzare eventuali attacchi relativi all''Universo 6<br />(Privato nascosto universo 6)', 0, 84, 0x66, 420, 456, 68, 15348, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Fusione con la DEFAL', 253, 'compor', 1141164868, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (40, 10, 'Universo 4', 'Banca dati dei rapporti di spionaggio che riguardano pianeti dell''universo 4<br />(Privato nascosto universo 4)', 0, 87, 0x66, 890, 1126, 647, 22131, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Oudeis [SETI]', 384, 'davpal3', 1160678168, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (42, 10, 'Universo 6', 'Banca dati dei rapporti di spionaggio che riguardano pianeti dell''universo 6<br />(Privato nascosto universo 6)', 0, 87, 0x66, 900, 224, 155, 12805, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Alexmax [Psicofor] gal. 3', 184, 'Kung Fu Monkey', 1136134276, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (44, 10, 'Universo 8', 'Banca dati dei rapporti di spionaggio che riguardano pianeti dell''universo 8 (Privato nascosto universo 8)', 0, 87, 0x66, 910, 1, 1, 5504, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Modalità inserimento topic', 185, 'dibex', 1123770441, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (45, 9, 'Universo 8', 'Area nella quale si possono discutere le tattiche per la gestione dell''alleanza, le tattiche di guerra e organizzare eventuali attacchi relativi all''Universo 8 (Privato nascosto universo 8)', 0, 84, 0x66, 430, 6, 4, 7260, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'occupatevi di questo se è di vostra competenza', 5, 'Romaruss', 1126003746, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (46, 8, 'Universo 6', 'Area nella quale si possono discutere i patti proposti, proporre nuovi patti, criticare quelli esistenti e discutere della diplomazia (Privato nascosto universo 6)', 0, 128, 0x66, 180, 243, 34, 13114, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Accordi con le altre alleanze', 237, 'Jimmy', 1136720405, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (75, 9, 'Universo 12', 'Area nella quale si possono discutere le tattiche per la gestione dell''alleanza, le tattiche di guerra e organizzare eventuali attacchi relativi all''Universo 12 (Privato nascosto universo 12)', 0, 84, 0x66, 440, 188, 26, 21383, NULL, 0, 3, 3, 3, 3, 3, 3, 3, 3, 2, 3, 3, 0, 'GalaxyTool: che bella invenzione!', 8, 'UomoPerfetto', 1154330913, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (76, 10, 'Universo 12', 'Banca dati dei rapporti di spionaggio che riguardano pianeti dell''universo 12 (Privato nascosto universo 12)', 0, 87, 0x66, 920, 10, 1, 19743, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'spiata', 831, 'GiuKi0', 1149530682, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (91, 0, 'Ogame nascosto', '', 0, 0, 0x63, 70, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, '', 1, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (53, 15, 'Confidential', 'privato solo alcuni', 0, 79, 0x66, 150, 293, 46, 21465, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Incontro a milano', 11, 'dynamo', 1154538296, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (71, 17, 'Introduzione al gioco', 'introduzione all''uso del gioco e della sua filosofia', 0, 78, 0x66, 970, 7, 6, 13557, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Covert Ops', 8, 'UomoPerfetto', 1137404573, NULL, 0, 0, 0, 0, '', '', 0, '', '', 2, 0, 0);
INSERT INTO `phpbb_forums` VALUES (72, 17, 'Problemi e aiuto', 'Per chiedere supporto per Enemy Territory', 0, 78, 0x66, 980, 4, 1, 10217, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Problemi riguardanti il gioco sigh...', 463, 'binladen', 1129198809, NULL, 0, 0, 0, 0, NULL, NULL, 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (73, 17, 'Coordinamento', 'Qua vengono scritti gli appuntamenti per giocare insieme', 0, 78, 0x66, 990, 11, 5, 14309, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '28 - 01 - 2006', 5, 'Romaruss', 1138565427, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (74, 10, 'Universo 6', 'Area in cui inserire i rapporti delle proprie battaglie per poterli analizzare e discutere (Privato nascosto universo 6)', 0, 114, 0x66, 820, 135, 46, 15183, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, 'Lord Totus vs RAFC radisc', 543, 'fuffy', 1140652230, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (77, 0, 'MAD Story', '', 0, 97, 0x63, 90, 0, 0, 0, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (78, 0, 'Wolfestein - Enemy Terrytory', '', 0, 96, 0x63, 960, 0, 0, 0, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (79, 0, 'Area diplomatica', '', 0, 97, 0x63, 140, 0, 0, 0, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (80, 0, 'Aiuto e Informazioni', '', 0, 97, 0x63, 210, 0, 0, 0, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (81, 0, 'Consiglio di Guerra', '', 0, 97, 0x63, 290, 0, 0, 0, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (82, 0, 'Rapporti di Spionaggio e Battaglia', '', 0, 97, 0x63, 740, 0, 0, 0, NULL, 0, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 2, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (90, 0, 'Wolfenstein - Enemy territory', 'Sparatutto strategico dedicato esclusivamente al multiplayer, che vi metterà nei panni di un soldato, appartenete all'esercito dell'Asse o a quello Alleato, della Seconda Guerra Mondiale.', 0, 0, 0x6c, 60, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, 'http://mad.ilbello.com/forum/index.php?f=78', 1, 121, 1137058615, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (84, 0, 'Consiglio dei graduati', 'Area nella quale si possono discutere le tattiche per la gestione dell''alleanza, le tattiche di guerra e organizzare eventuali attacchi relativi ad ogni universo (Privato Ogni universo)', 0, 81, 0x63, 400, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (85, 0, 'Vecchi Post', '', 0, 97, 0x63, 940, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (86, 0, 'problemi TECNICI relativi al forum', 'Scrivere qua per problemi che insorgono sicuramente in questa fase transitoria', 0, 99, 0x66, 30, 46, 13, 21617, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Private message', 5, 'Romaruss', 1156189263, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (87, 0, 'Rapporti di spionaggio', '', 0, 82, 0x63, 880, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (96, 0, 'Wolfenstein nascosto', '', 0, 0, 0x63, 950, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, '', 1, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (97, 0, 'Ogame', '', 0, 91, 0x63, 80, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (117, 0, 'Aula studio', 'Dedicata a dynamo e le sue farneticazioni :d', 0, 114, 0x66, 790, 82, 19, 21547, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Flotta', 11, 'dynamo', 1154965272, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (98, 0, 'Benvenuto Ospite', '', 0, 0, 0x66, 10, 18, 12, 22123, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'What search engine provides you with most relevant results?', -1, 'Andrew Wilson', 1160611288, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (99, 0, 'Benvenuto Utente Registrato', '', 0, 0, 0x66, 20, 16, 6, 20274, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ciao', 953, '******3dBra1n aka NastyBit', 1150316583, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (115, 0, 'Le nostre lune', '', 0, 82, 0x66, 750, 1, 1, 14242, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'REGOLE', 11, 'dynamo', 1138466314, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (114, 0, 'Rapporti di Battaglia', '', 0, 82, 0x63, 780, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (116, 0, 'Universo 4', '', 0, 115, 0x66, 760, 57, 19, 18961, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '[UNI 4] Gig 4:126:6', 108, 'Gig', 1148302624, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (118, 0, 'Universo 12', 'Area in cui inserire i rapporti delle proprie battaglie per poterli analizzare e discutere (Privato universo 12)', 0, 114, 0x66, 830, 142, 46, 21748, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Megatron m''ha rotto il ... BIP', 11, 'dynamo', 1158132772, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (140, 0, 'Diplomazia', 'Forum aperto a tutti che permette di discutere dei rapporti diplomatici', 0, 141, 0x66, 480, 12, 4, 20553, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'buco', 843, 'el cid', 1151082060, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (132, 0, 'Galassia 4', 'Reparto di coordinamento Compagnia Aria', 0, 129, 0x66, 360, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (126, 0, 'Galassia 1', 'Reparto di coordinamento della compagnia Acqua', 0, 129, 0x66, 330, 3, 1, 14937, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Ciao!', 688, 'Kollo', 1140040758, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (127, 0, 'Galassia 2', 'Reparto di coordinamento Compagnia Fuoco', 0, 129, 0x66, 340, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 1, 0, 0);
INSERT INTO `phpbb_forums` VALUES (128, 0, 'Rapporti diplomatici', 'Area Pubblica in cui gli ospiti possono fare le loro richieste. Contiene poi  le aree private di ogni universo.', 0, 79, 0x66, 160, 677, 114, 19353, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'proposta patto di non belligeranza', 5, 'Romaruss', 1148893466, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (129, 0, 'Universo 4', '', 0, 23, 0x63, 320, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (130, 0, 'Area Comune e pubblica', 'Area di relax in cui si può discutere del più e del meno...', 0, 0, 0x6c, 40, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, 'http://mad.ilbello.com/forum/index.php?f=135', 1, 579, 1138814863, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (131, 0, 'Galassia 3', 'Reparto di coordinamento Compagnia Terra', 0, 129, 0x66, 350, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (133, 0, 'Galassie lontane', 'Reparto coordinamento altre compagnie', 0, 129, 0x66, 370, 22, 1, 16887, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'slaura', 11, 'dynamo', 1145264828, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (134, 0, 'Area Pubblica', '', 0, 0, 0x63, 1000, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (135, 0, 'Area Pubblica', '', 0, 134, 0x63, 1010, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (136, 0, 'Bacheca pubblica', 'Qua possono leggere e scrivere tutti', 0, 135, 0x66, 1020, 41, 12, 21682, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'salutino', 1239, 'Polly2', 1157148681, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (137, 0, 'Scambio Account', '', 0, 29, 0x66, 260, 6, 3, 14979, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Regole', 384, 'davpal3', 1140097093, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (138, 0, 'HOF 20% Universo 4', 'Beh, penso che il titolo dica tutto!<br />(Privato universo 4)', 0, 114, 0x66, 810, 1593, 243, 22142, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'fuffy vs rocky0987 [ACME]', 384, 'davpal3', 1160740516, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (139, 0, 'Bzz', '', 0, 136, 0x66, 1030, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (141, 0, 'Area Aperta a tutti', '', 0, 75, 0x63, 450, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (142, 0, 'Commercio', 'Area aperta a tutti nella quale inserire gli annunci di scambio', 0, 141, 0x66, 460, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (143, 0, 'Presentazione', 'Area aperta atutti in cui ci si presenta e si saluta', 0, 141, 0x66, 470, 2, 1, 20512, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'ciao info', 5, 'Romaruss', 1151013666, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (144, 0, 'Utenti registrati', 'Area Che raccoglie tuttii forum riservati ai membri registrati', 0, 75, 0x63, 490, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (145, 0, 'Rischiesta accessi speciali', '', 0, 144, 0x66, 500, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (146, 0, 'Spam Bar', 'Il bar degli spammer :D', 0, 144, 0x66, 510, 335, 29, 21031, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saluti a tutti', 831, 'GiuKi0', 1152887467, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (147, 0, 'Ogame Life', '', 0, 144, 0x63, 520, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (148, 0, 'Regolamenti e Statuto', '', 0, 147, 0x66, 530, 7, 2, 18884, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Galaxytool nuove funzioni', 862, 'cassandra', 1148134343, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (149, 0, 'Presonal CR', '', 0, 147, 0x66, 540, 225, 40, 20909, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Non voglio + fare il miner...', 904, 'Maverick', 1152456887, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (150, 0, 'Sala di comando', '', 0, 147, 0x66, 550, 25, 6, 19226, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'TOP INFO SUI CRICRU', 638, 'theuncle', 1148650653, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (151, 0, 'Hall of Fame', '', 0, 147, 0x66, 560, 156, 32, 20896, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'La mia prima luna fatta!!!', 710, 'Vinicius', 1152419913, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (152, 0, 'Commerce room', '', 0, 144, 0x63, 570, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (153, 0, 'Offerta', '', 0, 152, 0x66, 580, 17, 9, 20688, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'G1 vs ALL [Vendo 1000k di Deuterio]', 831, 'GiuKi0', 1151754553, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (154, 0, 'Domanda', '', 0, 152, 0x66, 590, 9, 3, 20674, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'CERCO METALLO E CRISTALLO', 615, 'Icelele', 1151652765, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (155, 0, 'Miner Space', '', 0, 152, 0x66, 600, 43, 8, 20920, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Cristallo Swarosky con Certificato di Garanzia', 865, 'PeterPan', 1152539771, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (156, 0, 'Combat Rum', '', 0, 144, 0x63, 610, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, NULL, NULL, 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (157, 0, 'Target: Player', '', 0, 156, 0x66, 620, 56, 10, 20658, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'ci si mette anke cereal killer ora!!', 837, 'KINGALBI', 1151513837, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (158, 0, 'Targe: Ally', '', 0, 156, 0x66, 630, 144, 8, 20558, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'RISOLUZIONE GUERRA CONTRO I CRICETI', 833, 'LAYO', 1151088446, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (159, 0, 'Assault Squad: Requests', '', 0, 156, 0x66, 640, 3, 2, 20509, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Peccato!', 865, 'PeterPan', 1151009777, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (160, 0, 'Assault Squad Organization Room', '', 0, 156, 0x66, 650, 2, 2, 18830, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Harlock', 815, 'Harlock', 1148062191, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (161, 0, 'Spy Rum', '', 0, 144, 0x63, 660, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (162, 0, 'Target: player', '', 0, 161, 0x66, 670, 13, 6, 19900, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'spiata GALASSIA 3 ... ha cominciato lui :P', 8, 'UomoPerfetto', 1149694971, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (163, 0, 'Target: Ally', '', 0, 161, 0x66, 680, 18, 5, 19561, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'MAPPATURA TOPAZZI', 615, 'Icelele', 1149169292, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (164, 0, 'Galaxytool report', '', 0, 161, 0x66, 690, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (165, 0, 'Requests', '', 0, 161, 0x66, 700, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (166, 0, 'HOF 20% Universo 12', 'Beh, penso che il titolo dica tutto!<br />(Privato universo 12)', 0, 114, 0x66, 840, 17, 5, 22132, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'TheGame[B.I] 34° VS JoseCuervo [BAD] 134°', 543, 'fuffy', 1160678401, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (190, 0, 'Universo 12', '', 0, 23, 0x66, 380, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (187, 0, 'Universo 12', 'Area nella quale si possono discutere i patti proposti, proporre nuovi patti, criticare quelli esistenti e discutere della diplomazia (Privato nascosto universo 12)', 0, 128, 0x66, 190, 7, 1, 20609, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Dichirzione diplomtic d prte dei CpntoRpnto', 865, 'PeterPan', 1151227068, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (188, 0, 'Commercio', 'Comprende tutte le richieste di compra-vendita di materiale', 0, 80, 0x63, 240, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (189, 0, 'Uiverso 12', 'In questa sezione potete inserire le vostre richieste e offerte di materiale creando un vero e proprio "mercato delle risorse"<br />(Privato alleati universo 12)', 0, 188, 0x66, 270, 4, 2, 21268, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Milioni di benzina', 865, 'PeterPan', 1153985934, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (191, 0, 'Universo 17', 'Area in cui inserire i rapporti delle proprie battaglie per poterli analizzare e discutere', 0, 114, 0x66, 850, 30, 15, 21636, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'UomoPerfetto vs tai-pan [WoT]', 8, 'UomoPerfetto', 1156678553, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (192, 0, 'HOF 20% Universo 17', 'Beh, penso che il titolo dica tutto!', 0, 114, 0x66, 860, 9, 4, 21674, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'UomoPerfetto vs drago [CeC]', 272, 'Lord ToTuS', 1157067524, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (193, 0, 'Universo 17', 'Area nella quale si possono discutere i patti proposti, proporre nuovi patti, criticare quelli esistenti e discutere della diplomazia', 0, 128, 0x66, 200, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, '', 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (194, 0, 'Universo 17', 'In questa sezione potete inserire le vostre richieste e offerte di materiale creando un vero e proprio "mercato delle risorse"<br />(Privato utenti registrati)', 0, 188, 0x66, 280, 1, 1, 21151, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'scambio cristallo per deuterio fatevi sotto', 1131, 'v11sport', 1153496930, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (195, 0, 'Universo 17', '', 0, 23, 0x66, 390, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (196, 0, 'Universo 17', 'Area nella quale si possono discutere le tattiche per la gestione dell''alleanza, le tattiche di guerra e organizzare eventuali attacchi relativi all''Universo 17', 0, 84, 0x66, 710, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (197, 0, 'Universo 17', '', 0, 115, 0x66, 770, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, 0, NULL, 0, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);
INSERT INTO `phpbb_forums` VALUES (198, 0, 'Universo 17', 'Banca dati dei rapporti di spionaggio che riguardano pianeti dell''universo 17', 0, 87, 0x66, 930, 1, 1, 21430, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Magico_vento [4:26:9]', 8, 'UomoPerfetto', 1154391750, NULL, 0, 0, 0, 0, '', '', 0, '', '', 0, 0, 0);


Howaver im Happy for the conversion as it is now.... scure if also sub-forum will be converted correctly i'll be MORE Happy, but it's not important ;)

if you want we can meet in messenger... not?

That helps. I've figured out how it works now - you've got sub-boards AND sub-categories... The "forum_type" is c for categories and f for forums; forum_main is the ID of the parent board/category and is 0 for top-level boards and categories.

Since SMF doesn't support sub-categories, I'll just make them all real categories.

I'll work on this when I get home in a bit.

Ok. Try this one.

EDIT: Converter now located at http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058 (http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058)

YEAH

it work almost fine.

only an error found in this query


SELECT
f.forum_id AS ID_BOARD, f.forum_order AS boardOrder, f.forum_posts AS numPosts,
f.forum_last_post_id AS ID_LAST_MSG, SUBSTRING(f.forum_name, 1, 255) AS name,
SUBSTRING(f.forum_desc, 1, 65534) AS description, f.forum_topics AS numTopics,
IF(fp.forum_type = 'c', f.forum_main, 0) AS ID_CAT,
IF(fp.forum_type = 'f', f.forum_main, 0) AS ID_PARENT,
CASE auth_read
WHEN 0 THEN '-1,0,2'
WHEN 1 THEN '0,2'
WHEN 3 THEN '2'
ELSE ''
END AS memberGroups
FROM {$from_prefix}forums AS f, {$from_prefix}forums AS fp
WHERE f.forum_type = 'f'
AND fp.forum_id = f.forum_main;

it says "column auth_read" ambiguos.

so i changed that field forum auth_read TO f.auth_read.

it seams work but i absolutly don't know if it is a correct change or not. please conferm the change....

However it seams be converted almost correctly.

some little errors are in the conversion of the category and sub forums.

I undertstand that is  beacause in phpbb it is possible that category are SUB-category (for example "commercio" is a category but is son of "Aiuto e informazioni" but the conversion interprets that as first level category .

;) THANKS

it is really good work.

you can make stik this topic to help other users whith this problems.

Yes, it should have been f.auth_read and not auth_read. Sorry about that.

In SMF you can only have sub-boards, and not sub-categories. I thought it would be better to convert the sub-categories to regular categories instead of making them empty sub-boards.

great.

is it easy make canges that make sub-category as empty sub forums?

for my applications it would better....

Yeah, I'll see what I can do.

Ok... Try this one... Top-level categories (ie those with a "forum_main" of 0) are converted to regular categories. The rest are converted to boards.

EDIT: See this post (http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058) for current converter.

some board are missed.

i.e.
"consiglio dei graduati"
"Consiglio di guerra"
...

that are sub-category

Try this...

EDIT: Converter located at msg1089058 (http://www.simplemachines.org/community/index.php?topic=118416.msg1089058#msg1089058)

worse than before, now neither mai categories are converted...

I see what I did. I forgot to remove the restriction to only pull those with "forum_type" of f.

While I'm at it, I'm going to fix a few other things for you to make things easier:

1. Handle the main (top-level) boards first. Since the query won't find anything for items with a "forum_main" of 0, I need to make sure all this stuff gets converted first so the rest will work a bit better.

2. Handle the linked boards - just noticed these. I'll convert them to top-level boards since SMF doesn't have built-in redirection boards (there is a mod for this, and I'm pushing developers to put it in the next version after 1.1...)

3. Properly update ID_CAT, ID_PARENT and childLevel values - these are important since they let SMF know where things are :)

It'll be a little while before I get this done, but I'll post the modified converter when I do finish.

you are my Hero  ;) ;)

thanks

Alright. Try this one.

over all it give an error.

Converting...
Converting ranks... Successful.
Converting groups... Successful.
Converting smileys... Successful.
Converting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards (part 1)... Unsuccessful!
This query:

    SELECT
    forum_id AS ID_BOARD, forum_order AS boardOrder, forum_posts AS numPosts,
    forum_last_post_id AS ID_LAST_MSG, SUBSTRING(forum_name, 1, 255) AS name,
    SUBSTRING(forum_desc, 1, 65534) AS description, forum_topics AS numTopics,
    1 AS ID_CAT, forum_main AS ID_PARENT,
    CASE f.auth_read
    WHEN 0 THEN '-1,0,2'
    WHEN 1 THEN '0,2'
    WHEN 3 THEN '2'
    ELSE ''
    END AS memberGroups
    FROM `_mad`.phpbb_forums
    WHERE forum_main = 0 AND forum_type != 'c'
    LIMIT 0, 500;

Caused the error:

    Unknown column 'f.auth_read' in 'field list'

So i tryed to change that row from f.auth_read ... to auth_read

i really don't know what it mean ( :'() but after that modify it apparently works fine.

This version is better than previously.

now as i see all category are converted. but only main categories are converted as category (ok), sub categories are converted as forum (ok) but these are empty and they could have sub forums.

you can look the two version of the forum http://mad.ilbello.com and http://mad.ilbello.com/forum_smf

thanks.

ps. sometimes i think i'm boring, I repet if you are bored from my forum tell me and i stop ask you things.

Yes, that was another typo. Sorry about that.

The sub-categories that are converted to boards are supposed to have sub-boards... I'll take another look at my code later on and see if I can track down the problem.

Thanks for your patience and feedback :)

Try this one. I fixed the "f.auth_read" issue, and I think I've fixed the other one as well, although I'm not sure.

the auth_read fix works, but unfortunately the other one not.

the only sub-forum converted correctly is "problemi TECNICI relativi al forum".

after, sub-categories and sub-forums that have other sub-forums are missed.

i hope my indications are usefull for your work.

[i'm happy if i can be usefull for developing something, i'd like to know more things of php and mysql to be more usefull...]

I see what's going on now - sometimes a sub-sub-board's information is updated before its parent board's information is updated, thereby leaving you with a sub-sub-board in the wrong category.

The easiest way to solve this is to let SMF do it:
Admin -> Forum Maintenance
Click on "Find and Repair Any Errors"
SMF should find a bunch of boards that are in the wrong category. Telling SMF to fix these errors should solve the problem.

i tried to do what you said but, however the procedure find 100+ errors and i fix them, the sub-category and sob forum problem remain.



Elenco degli errori del forum
I seguenti errori si sono verificati nel forum:
Il topic #90 contiene (attualmente) nessun messaggio.
Il topic #858 contiene (attualmente) nessun messaggio.
Il topic #860 contiene (attualmente) nessun messaggio.
Il topic #861 contiene (attualmente) nessun messaggio.
Il topic #873 contiene (attualmente) nessun messaggio.
Il topic #877 contiene (attualmente) nessun messaggio.
Il topic #878 contiene (attualmente) nessun messaggio.
Il topic #949 contiene (attualmente) nessun messaggio.
Il topic #1371 contiene (attualmente) nessun messaggio.
Il topic #2338 contiene (attualmente) nessun messaggio.
Il topic #2865 contiene (attualmente) nessun messaggio.
Il topic #3808 contiene (attualmente) nessun messaggio.
Il topic #4434 contiene (attualmente) nessun messaggio.
Il topic #4586 contiene (attualmente) nessun messaggio.
Il topic #90 ha l'ID del primo messaggio 299, che non è corretta.
Il topic #90 ha l'ID dell'ultimo messaggio 416, che non è corretta.
Il topic #90 ha un errato numero di risposte, 3.
Il topic #858 ha l'ID del primo messaggio 3034, che non è corretta.
Il topic #858 ha l'ID dell'ultimo messaggio 3117, che non è corretta.
Il topic #858 ha un errato numero di risposte, 6.
Il topic #860 ha l'ID del primo messaggio 3004, che non è corretta.
Il topic #860 ha l'ID dell'ultimo messaggio 3015, che non è corretta.
Il topic #860 ha un errato numero di risposte, 1.
Il topic #861 ha l'ID del primo messaggio 2980, che non è corretta.
Il topic #861 ha l'ID dell'ultimo messaggio 2980, che non è corretta.
Il topic #861 ha un errato numero di risposte, 0.
Il topic #873 ha l'ID del primo messaggio 2535, che non è corretta.
Il topic #873 ha l'ID dell'ultimo messaggio 2641, che non è corretta.
Il topic #873 ha un errato numero di risposte, 14.
Il topic #877 ha l'ID del primo messaggio 3226, che non è corretta.
Il topic #877 ha l'ID dell'ultimo messaggio 3266, che non è corretta.
Il topic #877 ha un errato numero di risposte, 3.
Il topic #878 ha l'ID del primo messaggio 3230, che non è corretta.
Il topic #878 ha l'ID dell'ultimo messaggio 3268, che non è corretta.
Il topic #878 ha un errato numero di risposte, 1.
Il topic #949 ha l'ID del primo messaggio 3573, che non è corretta.
Il topic #949 ha l'ID dell'ultimo messaggio 3651, che non è corretta.
Il topic #949 ha un errato numero di risposte, 2.
Il topic #1371 ha l'ID del primo messaggio 5160, che non è corretta.
Il topic #1371 ha l'ID dell'ultimo messaggio 5273, che non è corretta.
Il topic #1371 ha un errato numero di risposte, 4.
Il topic #2338 ha l'ID del primo messaggio 8991, che non è corretta.
Il topic #2338 ha l'ID dell'ultimo messaggio 9018, che non è corretta.
Il topic #2338 ha un errato numero di risposte, 3.
Il topic #2865 ha l'ID del primo messaggio 11072, che non è corretta.
Il topic #2865 ha l'ID dell'ultimo messaggio 11072, che non è corretta.
Il topic #2865 ha un errato numero di risposte, 0.
Il topic #3808 ha l'ID del primo messaggio 16285, che non è corretta.
Il topic #3808 ha l'ID dell'ultimo messaggio 16288, che non è corretta.
Il topic #3808 ha un errato numero di risposte, 2.
Il topic #4434 ha l'ID del primo messaggio 20209, che non è corretta.
Il topic #4434 ha l'ID dell'ultimo messaggio 20211, che non è corretta.
Il topic #4434 ha un errato numero di risposte, 1.
Il topic #4586 ha l'ID del primo messaggio 20799, che non è corretta.
Il topic #4586 ha l'ID dell'ultimo messaggio 20835, che non è corretta.
Il topic #4586 ha un errato numero di risposte, 15.
Il topic #2865 è nella board #62, che è mancante.
L'oggetto del topic #2 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #5 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #6 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #7 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #9 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #12 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #15 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #16 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #17 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #18 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #19 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #21 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #23 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #24 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #25 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #26 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #27 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #28 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #29 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #33 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #34 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #35 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #37 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #38 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #40 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #41 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #42 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #43 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #44 non è attualmente memorizzato nella cache dell'oggetto.
[***]
L'oggetto del topic #4808 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4809 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4810 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4811 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4812 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4813 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4815 non è attualmente memorizzato nella cache dell'oggetto.
L'oggetto del topic #4816 non è attualmente memorizzato nella cache dell'oggetto.
La parola memorizzata 'benvenuto' è collegata ad un topic che non esiste.
La parola memorizzata 'in' è collegata ad un topic che non esiste.
La parola memorizzata 'smf' è collegata ad un topic che non esiste.

Vuoi correggere questi errori?
Si - No
Powered by MySQL Powered by PHP Powered by SMF 1.1 RC3 | SMF © 2001-2006, Lewis Media
Traduzione Italiana a cura di SMItalia XHTML 1.0 Valido! CSS Valido!
Caricando...


Try running this script from your forum directory:

<?php
include_once('SSI.php');

// Get all the top-level boards...
$query = db_query("SELECT ID_BOARD, ID_CAT FROM {$db_prefix}boards WHERE ID_PARENT = 0 AND childLevel = 0", __FILE__, __LINE__);

// Update things...
while($results = mysql_fetch_assoc($query))
{
    // Find all the sub-boards of this board
    $query2 = db_query("SELECT ID_BOARD FROM {$db_prefix}boards WHERE ID_PARENT = $results[ID_BOARD]", __FILE__, __LINE__);

    // Update sub-boards and sub-sub-boards at the same time...
    while($results2 = mysql_fetch_assoc($query2))
    {
        $query3 = db_query("UPDATE {$db_prefix}boards SET ID_CAT = $results[ID_CAT] WHERE ID_PARENT = $results[ID_BOARD] OR ID_PARENT = $results2[ID_BOARD]", __FILE__, __LINE__);
    }
    // Done with this
    mysql_free_result($query2);
}

// Done with this as well
mysql_free_result($query);

// Now get all the boards we just updated
$query = db_query("SELECT ID_BOARD, ID_CAT FROM {$db_prefix}boards WHERE childLevel = 2", __FILE__, __LINE__);

// Update sub-sub-sub-boards and sub-sub-sub-sub-boards (if there are any)...
while($results = mysql_fetch_assoc($query))
{
    // Any sub-sub-sub-boards?
    $query2 = db_query("SELECT ID_BOARD FROM {$db_prefix}boards WHERE ID_PARENT = $results[ID_BOARD]", __FILE__, __LINE__);

    if(db_num_rows($query2) > 0)
    {
        while($results2 = mysql_fetch_assoc($query2))
        {
            $query3 = db_query("UPDATE {$db_prefix}boards SET ID_CAT = $results[ID_CAT] WHERE ID_PARENT = $results[ID_BOARD] OR ID_PARENT = $results2[ID_BOARD]", __FILE__, __LINE__);
        }
    }
    else
    {
        $query3 = db_query("UPDATE {$db_prefix}boards SET ID_CAT = $results[ID_CAT] WHERE ID_PARENT = $results[ID_BOARD]", __FILE__, __LINE__);
    }
}
?>

That should fix everything, unless you have boards that are nested more than 4 levels deep (which I don't think you do).

sorry, but i try also the script... and it don't change anything.

i tryied also to re-convert the board and apply the scritp and LATER by forum admin repair the forum.

the result is always the same.


:(

If you run this query in phpMyAdmin, what does it return?

SELECT COUNT(ID_BOARD) FROM smf_boards WHERE childLevel > 1;

Since it seems that those are the boards that are missing, that should at least return something (other than 0).

If that still doesn't return anything, I'll have to take a look at the converter again and see if I can figure out what's causing the issue. As far as I can tell the ID_PARENT value should always be correct since we know what board each one is a child of - we just don't always know what category they belong to.

uhm...

can I do something to hel you?

Run the query from my last post in phpMyAdmin and let me know what results you get.

ok sorry i didn't understand.

i run the query and the result is 0

Quote

COUNT(ID_BOARD)
0

Weird... It either didn't convert any sub-sub-boards or it messed up the childLevel values. I'll take a look at it later and see if I can figure out what's going on.

i wait for your answer:D

thanks

Hi oldies.

Could it be possible to update the converter for phpbb 2.0.22 with category hierarchy 2.1.6d please? (that's the last stable version available...)

you can find a preinstalled version here to test:

http://ptifo.clanmckeen.com/download/cat-categories_hierarchy_v2.1.6/cat-_installation/mod-CH_216_installed.zip

it will be a great thing for me, thanks for advance if you can...

Sure, I can update it for you. Can you send me a database dump?

complete database?

hi oldiesmann. ;)

could we look this together please? to can update your converter script for this version?

Big thanks

GravuTrad

Quote from: Oldiesmann on October 18, 2006, 11:50:52 AM
Try this one. I fixed the "f.auth_read" issue, and I think I've fixed the other one as well, although I'm not sure.

I'm running phpbb 2.0.21 with categories hierarchy 2.1.6   I installed smf 1.1.2 and tried running the converter from the quoted post.  This resulted in a quite a lengthy list of errors (attached).  The end result was no transfer of any information.  Any advice would be greatly appreciated!  Thank you.

why do you not upgrade your forum?

I don't understand, I'm trying to upgrade my forums to SMF...

yes, but last version of phpbb premodded ch is phpbb 2.0.22 with ch 2.1.6d, not 2.0.21....

it will be better to oldiesmann to work on the last version...

That's not going to make any difference GravuTrad - there were no database changes from 2.0.21 to 2.0.22 (or at least nothing significant enough that it would break the converter).

Let me go download the latest version of that hack and see what I can come up with.

Can you try this one to see if it works at all?

This was the most recent version of the converter, except I changed something that (I think) will make the part that updates ID_PARENT, ID_CAT, etc. work properly.

As far as I can tell, the structure and setup of the "forums" table in phpBB hasn't changed at all in this version of the categories hierarchy mod.

EDIT: Keep reading for the current version of this converter...

QuoteConverting members... Successful.
Converting additional member groups... Successful.
Converting categories... Successful.
Converting boards (part 1)... Successful.
Converting boards (part 2)... Successful.
Fixing IDs... Unsuccessful!
This query:

    UPDATE `testsmf`.smf_boards
    SET ID_PARENT = 7, ID_CAT = 22, childLevel = 1
    WHERE ID_BOARD =;

Caused the error:

    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3

Try this.

seems to be good, only some permissions sections are not well ok (not well configured, some sections are seen instead of they were not to be seen by certains groups and the inverse, maybe it's adjustable in your script? i don't know...) but if we reconfiguring it, it will be ok.

you can retire the term "older" of your version script lol....

Quote from: Oldiesmann on May 11, 2007, 07:19:23 PM
Try this.

Yay!  Appears to have worked perfectly!  My hero!

Hmm, one question though.  Does my forums database now require BOTH the SMF tables AND the phpbb tables, or can I safely delete one set or the other?

Quote from: Oldiesmann on May 11, 2007, 07:19:23 PM
Try this.

Worked just WONDERFUL!

Everything seems perfect to me with just one exception: Attachments.

My PhpBB + CH 2.1.6d has Attachments Mod installed (the one adapted by ptirhiik for using on CH mod - Link here http://ptifo.clanmckeen.com/download.php?pack=6 ), the conversion programs says it's all ok, Attachments have been ported, but checking in the posts or in Administrative interface, I have NO attachments transferred to my SMF board.

Can you help me to adapt your script to manage Attach mod for CH?
Have I miss to do something in my conversion?

I will look at it in a bit and see what I can find. That converter is based on the one for SMF 1.1 RC3, so I will compare it with the current phpBB converter and see what I can find. I'll also modify the current phpBB converter to include the changes in this one and add it to the downloads page so other people can find it easier. Glad to know it worked properly though :)

Quote from: Oldiesmann on May 15, 2007, 10:28:31 AM
I will look at it in a bit and see what I can find. That converter is based on the one for SMF 1.1 RC3, so I will compare it with the current phpBB converter and see what I can find. I'll also modify the current phpBB converter to include the changes in this one and add it to the downloads page so other people can find it easier. Glad to know it worked properly though :)

While waiting for replies, I tried to work out with something by myself.
I have no experience with SMF (I am currently using a heavily modded phpbb+CH2.1.6d on my board, but I'm writing here 'cause I WILL pass to SMF), but I tried to understand how the conversion script works.
So I opened yours and tried to modify.
I succeeded to transfer attachments but I have no idea on how create thumbnails of attached images (I NEED to do this).

Anyway, here's the code. Please feel free to comment and/or delete :D
/* MARCO */

$result = convert_query("
SHOW TABLES FROM " . preg_replace('~`\..*$~', '', $from_prefix) . "`
LIKE '%_att_%'");
list ($tableExists) = mysql_fetch_row($result);
mysql_free_result($result);

// Doesn't exist?
if (!$tableExists)
return;


if (!isset($ID_ATTACH))
{
$result = convert_query("
SELECT MAX(ID_ATTACH) + 1
FROM {$to_prefix}attachments");
list ($ID_ATTACH) = mysql_fetch_row($result);
mysql_free_result($result);

$result = convert_query("
SELECT value
FROM {$to_prefix}settings
WHERE variable = 'attachmentUploadDir'
LIMIT 1");
list ($attachmentUploadDir) = mysql_fetch_row($result);
mysql_free_result($result);

// Get the original path... we'll copy it over for them!
$result = convert_query("
SELECT config_value
FROM {$from_prefix}att_config
WHERE config_name = 'upload_dir'
LIMIT 1");
list ($oldAttachmentDir) = mysql_fetch_row($result);
mysql_free_result($result);

if (substr($oldAttachmentDir, 0, 2) == '..')
$oldAttachmentDir = $_POST['path_from'] . '/' . $oldAttachmentDir;
elseif (substr($oldAttachmentDir, 0, 1) != '/')
$oldAttachmentDir = $_POST['path_from'] . '/' . $oldAttachmentDir;
if (empty($oldAttachmentDir) || !file_exists($oldAttachmentDir))
$oldAttachmentDir = $_POST['path_from'] . '/files';
}

if (empty($ID_ATTACH))
$ID_ATTACH = 1;

while (true)
{
pastTime($substep);


There is only one thing left: in phpbb it is possible to comment any attachments using a specific field in db table. I use it to enter Copyright notices. I have no idea how to migrate that infos.

Any ideas?

i didn't see this, well saw marco, i will test too...

if you need something like structure export of a forum up to date in production oldiesmann, tell me. ;)

to all people, well look for images to your ftp between the two after conversion, to keep well all the images, like smilies, avatars etc...

Ok, oldies, the script is not good, cause when i do the maintenance, search of errors give me:

- some posts with empty messages
- near all posts with no subjects
- some posts with incorrect answers number
- some posts with last message with incorrect ID
- some words in cache attached to an inexistant post

Is it normal?

and when i click for repair i have blank page with this error:

Quote
Warning: Unterminated comment starting line 29 in /Sources/Calendar.php on line 29

Fatal error: Call to undefined function: calendarholidayarray() in /Sources/Subs.php on line 486

Little up for oldiesmann.

oldiesmann, have you a little time for that?

Just one thing remaining.
I have successfully migrated my PHPBB + CH forum about a month ago, but during conversion I was not able to recreate thumbnails of my attachments.

Do anyone of you know how can I recreate thumbs? It would be an enormous help for me, I have a space related forum so image thumbnails are very spectacular and useful for our users.

Of course, inserting new attachments I have thumbs automatically created. I just want to create the ones for old attachments.

yes, that's one of things i noted. Oldies can you look the converter please? (i've done one and result some missing things...i can give you links by pm)

Please oldiesmann, i up this pb cause our conversion is only blocked by the missing enounced more up....
Can you look it please? :(

Hi, i tried to convert phpBB2.0.21 + CH mod and i got this error:

QuoteRecalculating forum statistics... Unsuccessful!
This query:

    SELECT ID_BOARD, memberGroups
    FROM `smf`.smf_boards
    WHERE FIND_IN_SET(0, memberGroups);

Caused the error:

    Illegal mix of collations (latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation 'find_in_set'

Both DB, and phpBB and SMF are utf-8, but non-English characters  are missing.
There isn't atin1_swedish_ci collations in my DB.

Can somebody help, please.
Thaks.

please oldiesmann think about us, conversion can't correctly be done for the moment for all sites with this special configuration....

Big up for this post.

i saw this:

http://www.simplemachines.org/community/index.php?topic=197760.0 (http://www.simplemachines.org/community/index.php?topic=197760.0)

but for the reasons said above, the converter is, i believe, incomplete. Can anyone help me please? thanks.

Sure, I can help you.. the easiest way would be modifiing our current phpbb2 converter (this one is allmost perfect) and add the category heirarchy features (hopefully not thousands of major changes to the phpbb database layout)...

Any change to get a full database dumb, GravuTrad?

yes, without problem. what do you need exactly?

I would need a full database dump (please upload it to your webspace and PM me a link) including the CREATE TABLE statements..

ok, i prepare this and give it like said. Thanks for advance TE. ;)

Done. PM sent.

Thanks for advance of your help TE. ;)

Great job. It works so.

http://www.forum.trad-fr.com/

Big thanks TE. ;)

A guide about reconfigure the permissions correctly and for don't forget to use the maintenance for correcting after conversion would be useful too...

i see maybe one thing that the converter hasn't keeped: the connexion time by user...0 after conversion... :(

Quote from: GravuTrad on August 27, 2009, 12:30:08 PM
i see may be one thing that the converted hasn't keeped: the connexion time by user...0 after conversion... :(

I'm not sure about this one.. do you mean the "online time" from users? I believe I could fix this, but that's only suitable if you can re-convert your phpBB..