No audio available for today
';
}
?>
$row) {
// all the files with {audio_type_id = 7} go in the OTHER folder.
$audio_id = $row['audio_id'];
$filepath = $row['file'];
$fixture_id = $row['fixture_id'];
/*
* Lineups: 3 - No score
* Half Time: 4 - Keep score
* Full Time: 5 - Keep score
* Preview: 2 - ?
* Update: 7 - Lose score
*/
if ($row['audio_type_id'] == 4) {
$ht_query = 'SELECT CONCAT(fe.team_one_score,"-",fe.team_two_score) AS score_ht FROM fixture_event fe WHERE fixture_id='.$fixture_id.' AND event_type=2';
$ht_stmt = $mdb2->query($ht_query);
if (PEAR::isError($ht_stmt)) { die($ht_stmt->getMessage()); }
while($ht_result = $ht_stmt -> fetchrow()) {
$score = $ht_result['score_ht'];
}
//
} else {
$score = $row['score'];
}
if ($row['audio_type_id'] == 3 || $row['audio_type_id'] == 2 || $row['audio_type_id'] == 7) {
$score = " ";
}
if ($row['audio_type_id'] == 7) {
$localfilepath = str_replace('D:\\Audio\\Match\\','../../audio/other/', $filepath);
} else {
$localfilepath = str_replace('D:\\Audio\\Match\\','../../audio/match/', $filepath);
}
?>
Info:
League:
Audio duration: seconds
