from phpbb2 +category hierarchy TO SMF 1.1 RC3 until 1.1.10

[romaruss]

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

[Oldiesmann]

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.

[romaruss]

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 [nofollow]

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

Code Select Expand

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]

[romaruss]

EUREKA

i've resolved my problem

as written in THIS 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

[Oldiesmann]

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.

[Oldiesmann]

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.

[romaruss]

Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks Thanks

tomorrow i'll try and tell you how it goes

[romaruss]

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

Code Select Expand

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

Code Select Expand


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

[Oldiesmann]

What error do you get with the new one?

[romaruss]

ok

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

Code Select Expand


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:

Code Select Expand


/******************************************************************************/
--- 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:

Code Select Expand

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

[Oldiesmann]

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 for current converter

[romaruss]

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:

Code Select Expand


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 [nofollow] (the phpbb forum)
http://mad.ilbello.com/forum_smf [nofollow] (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... ]

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

[Oldiesmann]

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.

[romaruss]

ok.

the dump of the two table you said are below

Code Select Expand


-- 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?

[Oldiesmann]

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.

[Oldiesmann]

Ok. Try this one.

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

[romaruss]

YEAH

it work almost fine.

only an error found in this query

Code Select Expand


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.

[Oldiesmann]

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.

[romaruss]

great.

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

for my applications it would better....

[Oldiesmann]

Yeah, I'll see what I can do.