impleri

i have gotten a couple of emails from people wanting to know how to uninstall the phpBB and Joomla/Mambo integration from me. Here’s the basics:

1. Backup your database
2. Duplicate mos_users (or jos_users) as phpbb_users (in phpMyAdmin, this can be done by going to the mos_users table and under the “operations” tab, there is the option of “copy table to…”)
3. DROP mos_session (or jos_session)
4. Using installation/sql/schema.sql (from a Mambo/Joomla package), re-create the mos_session (or jos_session) table (see below for latest)
5. Using install/sql/mysql_schema.sql (from phpBB package), recreate phpbb_sessions (see below for latest)
6. In mos_users (or jos_users)
   • RENAME user_email to email, user_password to password, user_id to id, user_active to block, and user_actkey to activation
   • REMOVE any other user_* fields;
   • UPDATE mos_users SET block = NOT block;
   • DELETE FROM mos_users WHERE id = -1;
7. In phpbb_users, REMOVE name, gid, registerDate, lastvisitDate, usertype, sendEmail, and params
8. Overwrite Mambo/Joomla files being used with “original” files from Mambo/Joomla package (you can just upgrade here to the latest Mambo/Joomla)
9. Either overwrite phpBB files with a clean package, or remove the changes that are noted in the phpbb files (can be found from the docs/mod_phpbb.txt file in the mosplus and heimdal packages). Each modification for phpBB is noted in the file by the usage of:
   // mod: Heimdal ------------
....
// fin mod: Heimdal -----------

For quick reference, here are the session tables’ structures:

-- Table structure for table `jos_session`
CREATE TABLE `jos_session` (
`username` varchar(50) default '',
`time` varchar(14) default '',
`session_id` varchar(200) NOT NULL default '0',
`guest` tinyint(4) default '1',
`userid` int(11) default '0',
`usertype` varchar(50) default '',
`gid` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`session_id`),
KEY `whosonline` (`guest`,`usertype`)
) TYPE=MyISAM;

-- Table structure for table `phpbb_sessions`
CREATE TABLE phpbb_sessions (
session_id char(32) DEFAULT '' NOT NULL,
session_user_id mediumint(8) DEFAULT '0' NOT NULL,
session_start int(11) DEFAULT '0' NOT NULL,
session_time int(11) DEFAULT '0' NOT NULL,
session_ip char(8) DEFAULT '0' NOT NULL,
session_page int(11) DEFAULT '0' NOT NULL,
session_logged_in tinyint(1) DEFAULT '0' NOT NULL,
session_admin tinyint(2) DEFAULT '0' NOT NULL,
PRIMARY KEY (session_id),
KEY session_user_id (session_user_id),
KEY session_id_ip_user_id (session_id, session_ip, session_user_id)
);