Changes to scripts

Firstly I need to have my script changed to insert into different tables with it's specific parameters rather than just all into 1 table. Secondly I want to change from using a mysql trigger from 1 table to another to filter inserts, instead I just want to filter entries directly in the script just by comparing the value against a value in a table with the same parameters. I need to have logic added to the script to update a column showing the remaining time left or if it's no longer available determine what happened to it. The script currently scrapes data from a json feed similar to this [login to view URL] It will need to compare the table entries by auc id against the new json feed with the same parameters and on duplicate entries it will update the timeleft column with the remaining time (VERY LONG, LONG, MEDIUM or SHORT) and if there's no entry in the new json feed with the same auc id and still has one of the time strings it will need to determine what happened to that entry by using this logic [login to view URL] and update the column with SOLD, CANCELED or EXPIRED. - Scraping experience is required. - Knowledge of World of Warcraft is highly preferred.