Project Detail

Description

Hi,

I need 3 scripts completed that will work with Clickbank.com Publisher IPN...which you can read about here:

http://www.clickbank.com/help/account-help/account-tools/instant-notification-service/

1st script (cbipn.php):

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 (verify.php):

Will be called with GET parameters, "http://www.blah.com/verify.php?email=emailHere&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 (search.php):

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.