Today a odds file is being imported into mysql database.
It contains odds change information for each second of the match (and before)
To lines with data (one for each player) is imported as one entry
Doing import with an option that do not update an entry if it is same odds as previous one, i found an error.
line2->player2/time:22:10:05/backodds:1.4/layodds:[url removed, login to view]
---->this line is updated correctly into database in one entry for:
time:22:10:05/backodds_player1:3/backodds_player2:1.4/layodds_player1:3.1/layodds_player2:[url removed, login to view]
line4->player2/time:22:10:06/backodds:1.4/layodds:[url removed, login to view]
---->this line is not updated because odds is same
line6->player2/time:22:10:07/backodds:[url removed, login to view]:1.5
---->this line is wrong updated (player2 data is updated from line4, not line6)
time:22:10:07/backodds_player1:3/backodds_player2:1.4/layodds_player1:3.1/layodds_player2:[url removed, login to view]
should have been
time:22:10:07/backodds_player1:3/backodds_player2:[url removed, login to view]:3.1/layodds_player2:1.5