I am looking for someone to parse an XML feed I have (live soccer scores) into a MySQL database on PHP [url removed, login to view] that can be automatically run and updated. It should look something like livescore.com.
For each match, one of the pieces of information I have is the status of the match, i.e. scheduled, first half, halftime, or second half. Unfortunately I do not have the minutes. So I need the coding to start a minute timer when it changes from "scheduled" to "first half," at which point it will reach 45 minutes before it reaches halftime. Then it will pause for halftime but continue from 46 minutes when the second half begins to 90 minutes plus however many minutes of injury time until the match ends (soccer is a game of two 45-minute halves but sometimes injuries will cause the game to go to 93 or 94 minutes, for instance). The same will need to be necessary if there is extra time in the match (overtime) if the teams are tied after the regular period.
Thank you for your time.