The job is to write a PayPal IPN script for our website that will:
1.) Send out an e-mail if a sale happens. Here you have to read a out a license key from a mysql database, where the flag "used" is "False". after reading the key, set the flag "used" to "True" in the database.
2.) Write all data into a PayPal table in mysql database. Include the license key here if a sale happen.
Only send e-mail with real purchases. Not refunds, claims or open payments.
To Do:
- Make a PHP Script
- Make a MYSQL script to create license key table.
- Make a MYSQL script to create PayPal table
- Little Admin PHP page where we can see all listings from PayPal table. (25 each page). With navigation. Find function on this page to find with license key or e-mail. Secured by login.
- Little script to submit a textfile with license keys to the license key table.
PHP script will run on a Windows Server.