2 PHP scripts I need to extend functionality(repost)

Hi there, I have 2 scripts that need a bit of extending. The general objective is to get data from different providers (slightly different formats) and output it in the same format, doing some string substitutions in between to unify them. There are two scripts, one that uploads the data into DB and another that downloads them. Both need some modifications but have the basic funtionality that uploads the file, unzip them, upload into DB, download from DB and place into a text file and does the basic cleaning operations. In the detailed section I have put numbers to all things I need the scripts to do in top of the current functionality. Apart from this, I will need some more scripts created that will form part of a third project. Let me know if you have any questions and how much is your bid for the above as well as how much time you think you´ll need to complete this. Many thanks, Jaio ? ## Deliverables 1.- The first script upload the data into the DB As it is, we upload a protected ZIP file containing several CSV files with the records. The script read each line from each file, recognises the source file (NAV_COREG, NAV_WEBMAILS, etc... ) and do the appropriate formating actions. These are all simple, like adding a comma, or replacing some strings. The problem is that the dates are not working correctly at the moment, some come form American format ? ? MM/DD/YYYY and others are English. Some use YYYY, others YY and that´s not getting picked up properly. Also we are working with a higher number of providers, so would like to add those into the script to automate them. ? So things to do? 1.1.- Fix the date problem so it recognises the format and inputs it into the database all as ? dd/mm/yy. Depending on the NAV_sourcecode ? the date format will have to be ? changed accordingly. 1.2.- Some profanities get cleaned from the text but there´s a town called "scunthorpe" that gets picked up and would like the script to excluded. So ? all ? "cunt" will be marked as profanity and therefore not cleaned, except "scunthorpe" 1.3.- The script adds the data as well to a monthly table called "mmmyy" (ex. Mar10), but it´s not working properly, as it seems to delete the exisiting data rather than accumulate it all in the month. The date of each record determines in which table the data gets imported, so if a file contains records from February and March, I want the script to import the relevant recoreds in Feb10 and the others in Mar10. 1.4.- The script at the moment deletes SPOWER contents, and I need to stop this happening as from now on it´s gonna accumulate. 2.- The second script downloads the data from the DB. At the moment, it just downloads anything marked as "clean" in the table "spower" but I want to change functionality. I would like the future script to 2.1.- Show the number of records in table "spower" 2.2.- Form with 1 question to let the user choose how many records to download from table "spower" 2.3.- Select the first X records (as selected by user), and place them in a text file (this is done already) 2.4.-? Update with numeric code based in date (ddmmyy), copy records into another table called "spower2" and delete downloaded records from table "spower" 2.5.- The file to be downloaded needs to have the filename as ? "ScottishPower_(DATE)_(NUMBER OF RECORDS)[login to view URL]" ? example ? ? [login to view URL] ? ? ? ? 2.6.- The file to be dowloaded has to be zipped, password protect this file with static password that will be provided in the code, name as below. [login to view URL] I also need a third script created, it´s a modification from first one, in which we upload a CSV file with records that has 3 fields email_address ? (string) type ? ? (int) reason ? ? (string - 50) The script will try to find the email addresses from the file in the tables from current and previous months, so in this case ? ? Mar10 ? and ? Feb10 If the record is there, it updates the table with "type" and "reason" If it´s not there, it adds it to a table ? NOT_FOUND with all the 3 fields. I´ll create and ammend DB tables as neccessary. Also I´ll attach the curent script so you can see the programming style and functionality. Thanks, Jaio