I need a php script that will get a [url removed, login to view] .ZIP file from an outside url at [url removed, login to view] containing a 10 MB XML feed with approximately 10,000 items, unzip the file contents (1 .xml file and 1 .dtd file) and convert the data to and populate a MySQl table with all data and import the categories and subcategories.
This script will be run daily in CRON so no user intervention is allowed. It has to be fully automatic.
Please make sure to have error-checking in the script, so if something goes wrong, the database is not emptied, but an e-mail is sent warning something went wrong.
The database will be repopulated entirely each time the script is run.
Find the clickbank xml feed zip file at [url removed, login to view]