Hi,
I need 3 scripts completed that will work with [login to view URL] Publisher IPN...which you can read about here:
[login to view URL]
1st script ([login to view URL]):
Clickbank will POST to this script...
First check if the secret key is valid, if not don't do anything. If it's valid continue on to:
When there is a new customer, add them to the MySQL database of customers with the Date/time in EST, their email, receipt, full name, product title, and "ACTIVE".
When there is a refund or chargeback, find the customer in the same MySQL database and update "ACTIVE" to "INACTIVE".
2nd script ([login to view URL]):
Will be called with GET parameters, "[login to view URL];receipt=GHSH24"
If the email and receipt are both in the MySQL database from the first script with the status "ACTIVE", return "verified".
If the email and receipt is in the database with "INACTIVE" or not in the database at all, return nothing.
The email and receipt MUST MATCH and the status MUST be "ACTIVE" to return "verified". If any of these are false, return nothing.
3rd script ([login to view URL]):
This will allow me to search the database by name(first or last name only, or both), email, receipt, product title, status (ACTIVE/INACTIVE).
I need the queries to MySQL for all scripts to be optimized so there is no problem when the database becomes larger over time. (Should grow by 3000-5000 customers per month).
Project must be completed by October 30, 2009. If you can't meet this deadline please do not bid.