Import users from phpbb to phorum He with limited skills is looking for some assistance in importing the phpbb users table into phorum. I've got over 800 users and am looking to shift across. any short cuts other than a lot of find replace would be great. ======= phpbb users table ======== 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_calendar_perm` tinyint(1) unsigned NOT NULL default '0', `firstname` varchar(32) NOT NULL default '', `lastname` varchar(32) NOT NULL default '', `perms` varchar(9) NOT NULL default '', `rooms` varchar(128) NOT NULL default '', `gender` tinyint(1) NOT NULL default '0', `latin1` tinyint(1) NOT NULL default '0', `ip` varchar(16) NOT NULL default '', `name` varchar(32) NOT NULL default '', `chat_joined` int(10) NOT NULL default '0', `language` varchar(32) NOT NULL default '', `website` varchar(32) NOT NULL default '', `email` varchar(32) NOT NULL default '', `hide_email` varchar(32) NOT NULL default '', PRIMARY KEY (`user_id`), KEY `user_session_time` (`user_session_time`) ) TYPE=MyISAM; https://www.phorum.org/support/read.php?7,47230,47230#msg-47230 Thu, 15 Oct 2026 06:41:25 -0500 Phorum 6.0.4 https://www.phorum.org/support/read.php?7,47230,47230#msg-47230 Import users from phpbb to phorum https://www.phorum.org/support/read.php?7,47230,47230#msg-47230
I've got over 800 users and am looking to shift across.

any short cuts other than a lot of find replace would be great.
======= phpbb users table ========

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_calendar_perm` tinyint(1) unsigned NOT NULL default '0',
`firstname` varchar(32) NOT NULL default '',
`lastname` varchar(32) NOT NULL default '',
`perms` varchar(9) NOT NULL default '',
`rooms` varchar(128) NOT NULL default '',
`gender` tinyint(1) NOT NULL default '0',
`latin1` tinyint(1) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`name` varchar(32) NOT NULL default '',
`chat_joined` int(10) NOT NULL default '0',
`language` varchar(32) NOT NULL default '',
`website` varchar(32) NOT NULL default '',
`email` varchar(32) NOT NULL default '',
`hide_email` varchar(32) NOT NULL default '',
PRIMARY KEY (`user_id`),
KEY `user_session_time` (`user_session_time`)
) TYPE=MyISAM;

]]> Andrew Mod Requests and Suggestions (READ ONLY) Sun, 11 Jul 2004 02:32:39 -0500