I have a bulletin board with 240,000 members and over 5 million posts. I need someone to move all posts, users, etc (migrate everything) to VBulletin 4.0. They have custom software that will actually migrate all this for you.
The only problem is we use a paypal mod script with phpbb2 and you have to write custom code to import all subs to vbulletin.
I also want the entire site to keep the same look so the person who migrates this should also setup the look, permissions, groups, etc so they match the older forum.
This is the information on our current paypal subs.
The table, where all the paypal log is stored:
CREATE TABLE `phpbb_account_hist` (
`user_id` mediumint(8) DEFAULT ‘0’,
`lw_post_id` mediumint(8) DEFAULT ‘0’,
`lw_money` float DEFAULT ‘0’,
`lw_plus_minus` smallint(5) DEFAULT ‘0’,
`MNY_CURRENCY` varchar(8) DEFAULT ”,
`lw_date` int(11) DEFAULT ‘0’,
`comment` varchar(255) DEFAULT ”,
`status` varchar(64) DEFAULT ”,
`txn_id` varchar(64) DEFAULT ”,
`lw_site` varchar(10) DEFAULT ”
) ENGINE=MyISAM DEFAULT CHARSET=latin1
The extended phpbb user table with the two additional fields “ug_expire_date” and “ug_active_date”.
ug_expire_date stores the unix timestamp of the expiration date
for the payment that has been made, ug_active_date is used for
sloppy payments I think (echecks and stuff like that) or when
you use trial days, but you’d have to consult the php code to
really find out what it’s good for.
+—————-+————–+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+—————-+————–+——+—–+———+——-+
| group_id | mediumint(8) | NO | MUL | 0 | |
| user_id | mediumint(8) | NO | MUL | 0 | |
| user_pending | tinyint(1) | YES | | NULL | |
| ug_expire_date | int(11) | YES | | 0 | |
| ug_active_date | int(11) | YES | | 0 | |
+—————-+————–+——+—–+———+——-+
