Need php expert for fixing an import to mysql error
$250-750 USD
Cancelado
Publicado há mais de 12 anos
$250-750 USD
Pago na entrega
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.
example:
line1->player1/time:22:10:05/backodds:3/layodds:3.1
line2->player2/time:22:10:05/backodds:1.4/layodds:1.39
---->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:1.39
line3->player1/time:22:10:06/backodds:3/layodds:3.1
line4->player2/time:22:10:06/backodds:1.4/layodds:1.39
---->this line is not updated because odds is same
line5->player1/time:22:10:07/backodds:3/layodds:3.1
line6->player2/time:22:10:07/backodds:1.49/layodds: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:1.39
should have been
time:22:10:07/backodds_player1:3/backodds_player2:1.49/layodds_player1:3.1/layodds_player2:1.5