Topic: Convert phorum --> punbb

Hi,
Does-it possible to convert phorum (5) to punbb ?
Thanks for your help

Simon.

Re: Convert phorum --> punbb

ok..... it looks like we are bad luck. There is no... and i dont think it will ever be. Phorum is getting less and less popular. I think punbb totaly bangged in its popularity while phorum got stuck to some fixed mind ideas. Pity i  choosed phorum when i set up my site's board.

And know i dont feel like writing a corvertor script as. That would be a lot of hard work and wouldnt be used by so many ppl as phorum is being used by a few resistent guys only ( like me ).
Besides, as far as i know phorum documentation doesnt even has a table reference. It's not critical i know, but i myself prefer to develop whatever it is suported by good documentation.

So... i think its left for phorum users to open a new punbb board.

I think i will insert the existing users in my new punbb forum and leave my phorum instalation read only;

Re: Convert phorum --> punbb

If phorum has a database structure that is somewhat similar to what PunBB has (forums, topics, posts, users etc), it shouldn't be too much work to migrate it manually (if you know some SQL).

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Re: Convert phorum --> punbb

Here it goes, i think its beter not to use the [ code ] tag to avoid the scroll.
now let me have a look on punbb structure.

BTW... how are these converters usualy made?
i would use simple

select whatever from phorum

followed by

insert pun_whatever in punbb

and loop that in a php script.

is it the recomended way? or should one make a .sql file find and replace or something?


--
-- Database: 'phorumstruct'
--

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

--
-- Table structure for table 'phorum_banlists'
--

CREATE TABLE phorum_banlists (
  id int(11) NOT NULL auto_increment,
  forum_id int(11) NOT NULL default '0',
  `type` tinyint(4) NOT NULL default '0',
  pcre tinyint(4) NOT NULL default '0',
  `string` varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  KEY forum_id (forum_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_files'
--

CREATE TABLE phorum_files (
  file_id int(11) NOT NULL auto_increment,
  user_id int(11) NOT NULL default '0',
  filename varchar(255) NOT NULL default '',
  filesize int(11) NOT NULL default '0',
  file_data mediumtext NOT NULL,
  add_datetime int(10) unsigned NOT NULL default '0',
  message_id int(10) unsigned NOT NULL default '0',
  link varchar(10) NOT NULL default '',
  PRIMARY KEY  (file_id),
  KEY add_datetime (add_datetime),
  KEY message_id_link (message_id,link)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_forum_group_xref'
--

CREATE TABLE phorum_forum_group_xref (
  forum_id int(11) NOT NULL default '0',
  group_id int(11) NOT NULL default '0',
  permission int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (forum_id,group_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_forums'
--

CREATE TABLE phorum_forums (
  forum_id int(10) unsigned NOT NULL auto_increment,
  `name` varchar(50) NOT NULL default '',
  active smallint(6) NOT NULL default '0',
  description text NOT NULL,
  template varchar(50) NOT NULL default '',
  folder_flag tinyint(1) NOT NULL default '0',
  parent_id int(10) unsigned NOT NULL default '0',
  list_length_flat int(10) unsigned NOT NULL default '0',
  list_length_threaded int(10) unsigned NOT NULL default '0',
  moderation int(10) unsigned NOT NULL default '0',
  threaded_list tinyint(4) NOT NULL default '0',
  threaded_read tinyint(4) NOT NULL default '0',
  float_to_top tinyint(4) NOT NULL default '0',
  check_duplicate tinyint(4) NOT NULL default '0',
  allow_attachment_types varchar(100) NOT NULL default '',
  max_attachment_size int(10) unsigned NOT NULL default '0',
  max_totalattachment_size int(10) unsigned NOT NULL default '0',
  max_attachments int(10) unsigned NOT NULL default '0',
  pub_perms int(10) unsigned NOT NULL default '0',
  reg_perms int(10) unsigned NOT NULL default '0',
  display_ip_address smallint(5) unsigned NOT NULL default '1',
  allow_email_notify smallint(5) unsigned NOT NULL default '1',
  `language` varchar(100) NOT NULL default 'english',
  email_moderators tinyint(1) NOT NULL default '0',
  message_count int(10) unsigned NOT NULL default '0',
  sticky_count int(10) unsigned NOT NULL default '0',
  thread_count int(10) unsigned NOT NULL default '0',
  last_post_time int(10) unsigned NOT NULL default '0',
  display_order int(10) unsigned NOT NULL default '0',
  read_length int(10) unsigned NOT NULL default '0',
  vroot int(10) unsigned NOT NULL default '0',
  edit_post tinyint(1) NOT NULL default '1',
  template_settings text NOT NULL,
  count_views tinyint(1) unsigned NOT NULL default '0',
  display_fixed tinyint(1) unsigned NOT NULL default '0',
  reverse_threading tinyint(1) NOT NULL default '0',
  inherit_id int(10) unsigned default NULL,
  PRIMARY KEY  (forum_id),
  KEY `name` (`name`),
  KEY active (active,parent_id),
  KEY group_id (parent_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_groups'
--

CREATE TABLE phorum_groups (
  group_id int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL default '0',
  `open` tinyint(3) NOT NULL default '0',
  PRIMARY KEY  (group_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_messages'
--

CREATE TABLE phorum_messages (
  message_id int(10) unsigned NOT NULL auto_increment,
  forum_id int(10) unsigned NOT NULL default '0',
  thread int(10) unsigned NOT NULL default '0',
  parent_id int(10) unsigned NOT NULL default '0',
  author varchar(37) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  body text NOT NULL,
  email varchar(100) NOT NULL default '',
  ip varchar(255) NOT NULL default '',
  `status` tinyint(4) NOT NULL default '2',
  msgid varchar(100) NOT NULL default '',
  modifystamp int(10) unsigned NOT NULL default '0',
  user_id int(10) unsigned NOT NULL default '0',
  thread_count int(10) unsigned NOT NULL default '0',
  moderator_post tinyint(3) unsigned NOT NULL default '0',
  sort tinyint(4) NOT NULL default '2',
  datestamp int(10) unsigned NOT NULL default '0',
  meta mediumtext NOT NULL,
  viewcount int(10) unsigned NOT NULL default '0',
  closed tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (message_id),
  KEY thread_message (thread,message_id),
  KEY thread_forum (thread,forum_id),
  KEY special_threads (sort,forum_id),
  KEY status_forum (`status`,forum_id),
  KEY list_page_float (forum_id,parent_id,modifystamp),
  KEY list_page_flat (forum_id,parent_id,thread),
  KEY post_count (forum_id,`status`,parent_id),
  KEY dup_check (forum_id,author,`subject`,datestamp),
  KEY forum_max_message (forum_id,message_id,`status`,parent_id),
  KEY last_post_time (forum_id,`status`,modifystamp),
  KEY next_prev_thread (forum_id,`status`,thread),
  KEY user_id (user_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_pm_buddies'
--

CREATE TABLE phorum_pm_buddies (
  pm_buddy_id int(10) unsigned NOT NULL auto_increment,
  user_id int(10) unsigned NOT NULL default '0',
  buddy_user_id int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (pm_buddy_id),
  UNIQUE KEY userids (user_id,buddy_user_id),
  KEY buddy_user_id (buddy_user_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_pm_folders'
--

CREATE TABLE phorum_pm_folders (
  pm_folder_id int(10) unsigned NOT NULL auto_increment,
  user_id int(10) unsigned NOT NULL default '0',
  foldername varchar(20) NOT NULL default '',
  PRIMARY KEY  (pm_folder_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_pm_messages'
--

CREATE TABLE phorum_pm_messages (
  pm_message_id int(10) unsigned NOT NULL auto_increment,
  from_user_id int(10) unsigned NOT NULL default '0',
  from_username varchar(50) NOT NULL default '',
  `subject` varchar(100) NOT NULL default '',
  message text NOT NULL,
  datestamp int(10) unsigned NOT NULL default '0',
  meta mediumtext NOT NULL,
  PRIMARY KEY  (pm_message_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_pm_xref'
--

CREATE TABLE phorum_pm_xref (
  pm_xref_id int(10) unsigned NOT NULL auto_increment,
  user_id int(10) unsigned NOT NULL default '0',
  pm_folder_id int(10) unsigned NOT NULL default '0',
  special_folder varchar(10) default NULL,
  pm_message_id int(10) unsigned NOT NULL default '0',
  read_flag tinyint(1) NOT NULL default '0',
  reply_flag tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (pm_xref_id),
  KEY xref (user_id,pm_folder_id,pm_message_id),
  KEY read_flag (read_flag)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_search'
--

CREATE TABLE phorum_search (
  message_id int(10) unsigned NOT NULL default '0',
  forum_id int(10) unsigned NOT NULL default '0',
  search_text mediumtext NOT NULL,
  PRIMARY KEY  (message_id),
  KEY forum_id (forum_id),
  FULLTEXT KEY search_text (search_text)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_settings'
--

CREATE TABLE phorum_settings (
  `name` varchar(255) NOT NULL default '',
  `type` enum('V','S') NOT NULL default 'V',
  `data` text NOT NULL,
  PRIMARY KEY  (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_subscribers'
--

CREATE TABLE phorum_subscribers (
  user_id int(10) unsigned NOT NULL default '0',
  forum_id int(10) unsigned NOT NULL default '0',
  sub_type int(10) unsigned NOT NULL default '0',
  thread int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,forum_id,thread),
  KEY forum_id (forum_id,thread,sub_type)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_user_custom_fields'
--

CREATE TABLE phorum_user_custom_fields (
  user_id int(11) NOT NULL default '0',
  `type` int(11) NOT NULL default '0',
  `data` text NOT NULL,
  PRIMARY KEY  (user_id,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_user_group_xref'
--

CREATE TABLE phorum_user_group_xref (
  user_id int(11) NOT NULL default '0',
  group_id int(11) NOT NULL default '0',
  `status` tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (user_id,group_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_user_newflags'
--

CREATE TABLE phorum_user_newflags (
  user_id int(11) NOT NULL default '0',
  forum_id int(11) NOT NULL default '0',
  message_id int(11) NOT NULL default '0',
  PRIMARY KEY  (user_id,forum_id,message_id)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_user_permissions'
--

CREATE TABLE phorum_user_permissions (
  user_id int(10) unsigned NOT NULL default '0',
  forum_id int(10) unsigned NOT NULL default '0',
  permission int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (user_id,forum_id),
  KEY forum_id (forum_id,permission)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table 'phorum_users'
--

CREATE TABLE phorum_users (
  user_id int(10) unsigned NOT NULL auto_increment,
  username varchar(50) NOT NULL default '',
  `password` varchar(50) NOT NULL default '',
  cookie_sessid_lt varchar(50) NOT NULL default '',
  sessid_st varchar(50) NOT NULL default '',
  sessid_st_timeout int(10) unsigned NOT NULL default '0',
  password_temp varchar(50) NOT NULL default '',
  email varchar(100) NOT NULL default '',
  email_temp varchar(110) NOT NULL default '',
  hide_email tinyint(1) NOT NULL default '0',
  active tinyint(1) NOT NULL default '0',
  user_data text NOT NULL,
  signature text NOT NULL,
  threaded_list tinyint(4) NOT NULL default '0',
  posts int(10) NOT NULL default '0',
  admin tinyint(1) NOT NULL default '0',
  threaded_read tinyint(4) NOT NULL default '0',
  date_added int(10) unsigned NOT NULL default '0',
  date_last_active int(10) unsigned NOT NULL default '0',
  last_active_forum int(10) unsigned NOT NULL default '0',
  hide_activity tinyint(1) NOT NULL default '0',
  show_signature tinyint(1) NOT NULL default '0',
  email_notify tinyint(1) NOT NULL default '0',
  pm_email_notify tinyint(1) NOT NULL default '1',
  tz_offset tinyint(2) NOT NULL default '-99',
  is_dst tinyint(1) NOT NULL default '0',
  user_language varchar(100) NOT NULL default '',
  user_template varchar(100) NOT NULL default '',
  moderator_data text NOT NULL,
  moderation_email tinyint(2) unsigned NOT NULL default '1',
  PRIMARY KEY  (user_id),
  UNIQUE KEY username (username),
  KEY active (active),
  KEY userpass (username,`password`),
  KEY sessid_st (sessid_st),
  KEY cookie_sessid_lt (cookie_sessid_lt),
  KEY activity (date_last_active,hide_activity,last_active_forum),
  KEY date_added (date_added),
  KEY email_temp (email_temp)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Re: Convert phorum --> punbb

Have a look at the migration tool on the downloads page. Extending it to support phorum shouldn't be all that difficult.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

6 (edited by pedrotuga 2006-10-09 23:31)

Re: Convert phorum --> punbb

lets  check that up.  tack så mycket!

EDIT:mmm... sorry not to contribut with this. I had a look at the other forums migration files and i figured out it would be some work. I cant get into that.

7

Re: Convert phorum --> punbb

I've converted my phpBB2 to PunBB a few days ago. I asked gConverter guys and they did it very well. They can help you to convert Phorum to PunBB as well, it seems they are the only and professional company how solves such a issues, they provide about 60k different from/to convert combinations for all available CMS and Forum Boards.