Project Detail

Description

I have a membership script which takes payment via paypal and allows access to member to members area and keep charging them subscription fees everymonth and this paypal ipn script will update the my database automatically checking paypal account..

now what the current script is doing....

whenever a member subscribes... it takes payment connect to paypal and log the data into database in 1 ROW like

start_date(04-26-2006) and end_date(12-31-2012) yes 12-31-2012

and when the subscription occurs next month it will update that row like

start_date(05-26-2006) and end_date(12-31-2012)

It works perfectly... no problem with the script... because if user cancels his subscription the end_date will automatically gets changed to y'day date and he will not be allowed to members area....

BUT what i want is... with every subscription update there should be a new row... which

here is what i want

start_date-------end_date-------paid-----status
06-30-2006------07-30-2006-------$10-----active
05-30-2006------06-30-2006-------$10-----expired
04-30-2006------05-30-2006-------$10-----expired

like this...

If you are completely aware how IPN works and if you are 100% sure you will be able to do it... then only bid... i have urgent requirement so please do not waste your time on doing trial n error after bidding... IF you want to get the script and try yourself first before bidding... go to amember.com and download their free 30 days trial install on your server and let me know...

BUT YOU NEED TO HURRY... I want to get this script ready by 10th June