40
I'm going to use all of you as a sounding board for building the base of this. That way, anything that I miss is caught early.
Two screens: user and admin
ADMIN
PayPal account: ______________
Text to display for thanking user: _________________
Subscription option 1 name: _______________
Subscription option 1 description: _______________
Subscription option 1 price: ______________
Length of subscription option 1: number units (days, months, etc.)
Which group will the member be promoted to: {Drop-down with groups}
USER
(some configurable text thanking the user for choosing to subscribe)
{Drop-down box box with subscription options}
Check box for auto-renew
The databases that will support this module will be:
MEMBERS
uid - integer; foreign key to XOOPS uid
subscription_type - integer; foreign key to subscriptions DB
start_date - timestamp of this subscription being approved
expiry_date - timestamp of when this subscription will end
auto_renew - integer; 0 for no, 1 for yes
SUBSCRIPTIONS
subscription_type - integer; autoincrement
subscription_name - varchar(80); name of subscription
subscription_description - text
subscription_length_number - integer
subscription_length_units - choice of days, weeks, months, years
ACCOUNTS
vendor - choice of PayPal, NoChex, etc.
account - varchar (80)
password - encrypted password field
That's where I am right now. All comments, suggestions, and criticisms are welcome.
One question I had while doing this post: where do I store the "thank you" text? Is it worth another table just for that or am I missing a more obvious answer, like a simple text file?