PayPal subscription (Verify + Success/Cancel site + Insert into MySQL db)

General information for the website: Subscription / donation site for a multigaming community
Kind of development: Customization of existing website
Num. of web pages/modules: 4
Description of every page/module: --- Default page

Exactly like in my example on [ http://4future.biz/pp/ ]

Field Steam ID and GUID will be replaced later with the Steam login API and will have
the Steam ID and GUID in the back-end (in PHP as variable). Buyer cant edit those two.

Steam ID and GUID should be send to PayPal (as hidden HTML field) as description of
the payment. Additionally 1 line of text is needed. It should look like this on PayPal site:
(line 1) A random text I will edit later
(line 2) Steam ID
(line 3) GUID

Buyer can switch between 1, 2, 3 or 6 month of subscription.
He has a choice between "recurring" or "non-recurring" also.
By default the "recurring" checkbox is checked and the buyer
has to switch the state that the subscription is non-recurring.


--- Success page

If the PayPal process ended successfully the buyer will be redirected to my website
and should land on a different site for example let's call it: success.php

On that landing site I will insert my informations later the buy was successful.
You can place a 'echo "Payment was successful"' there. I will expand that later.

IN THE BACKGROUND ON THAT SITE:

After redirection from PayPal to that site, everything important needs to be saved
into a MySQL table. Important for example are buyer name, email, payment type,
payment period also Steam ID, GUID, expire date and everything I can get from PayPal.

( good programmers: times/dates as PHP timestamp, please )


--- Cancel page

If the buyer cancled the payment in PayPal or PayPal said he cant buy it, he should also
been redirected to my website on another landing page let's call that: error.php

On that landing site the buyer will see the from PayPal (in the background) recived error
why this payment got cancelt. For example: Not enough money, buy canceled and so on.

In that case NOTHING will be insert into the database.


--- BACKGROUND MODUL

This last modul will run in the background only as Cronjob or Windows tasks and will be
repeated every 12 hours.

What it does is to SELECT all saved subscriptions in the database look which subscription
is expired and check out via. PayPal API this subscription is REALLY outdated or maybe got
expanded by the buyer.

MORE DETAILS:

> Follow my example

A buyer buyed 3 month recurring subscription.
There will be an entry in the database with all informations about the payment, like 3 month (period), recurring and so on.
The buyer desides to resign the subscription in PayPal account in the second month.
Cause he already buyed 3 month the payment will stop after 3 month.

The database cant know the buyer resigned the subscription.
In the database the entry still say 3 month - RECURRING.

- So I need a several PHP script which I will run as tasks which checks all expired payments they
got expanded or their really outdated. AND this script needs to UPDATE the database if something
changed with the payment at all.
Description of requirements/features: You can code that however you want.
I would feel good if you could use the PayPal REST/SOAP API.

But it is not a requirement to get this job.
CMS and Admin requirements: Everything which is needed to be set in the code, for example like the followring fields...

< input type="hidden" name="cmd" value="_xclick-subscriptions"
< input type="hidden" name="business" value="me@mybusiness.com"
< input type="hidden" name="currency_code" value="USD"
< input type="hidden" name="no_shipping" value="1"
< input type="hidden" name="item_name" value="VIP Reserved slots for our servers"

Replace are needed values, like recipient email, currency code and so one with a PHP
define and I will set them later by my own.
Extra services needed: Customization, Security
Similar urls: http://4future.biz/pp/
Extra notes: We're talking about 4 modules (sites).

No admin area, no login area - nothing.

Only those 4 sites (files) and of cause the PayPal API files.

- - -

HAVE A LOOK AT THE SOURCE CODE FROM MY TEST EXAMPLE.
USE THAT TO UNDERSTAND WHAT I NEED IF MY TEXT IS NOT DETAILED ENOUGH!

http://4future.biz/pp/