phpBB3 - Paid subscribers Mod
We have 2 levels on our phpbb3 forum, Premium & regular users. I need a mod that will allow a registered user to upgrade themself through to paid service.
So they login to phpBB3, goto [login to view URL] -> click a link that says Upgrade me.
Then they goto paypal's site.. pay the money..
(in the background, paypal tells our site their membership has been upgraded)
Paypal sends them back to our site.. Their Membership is upgraded.
The membership will renew every year.. We will need a process that will check to make sure everyone is up to date on their membership.
The upgrade function in phpBB is pretty easy; all you have to do is add the user to a special group. They should be removed from the group when the user cancels or their membership expires.
We also need an admin page to manage the list of users.
I created the table to store the data :
CREATE TABLE `phpbb3_premium_users` (
`user_id` int(11) NOT NULL,
`user_premium_member` int(11) default NULL,
`user_premium_since` int(11) default NULL,
`user_premium_renewal` int(11) default NULL,
`user_premium_next_bill` int(11) default NULL,
PRIMARY KEY (`user_id`)
)
The mod must follow the phpBB3 Mod's guidelines ([login to view URL])