$ref_ar2 = explode(',', $referees_ar[1]);
$linesman_1 = trim($ref_ar2[0]);
$linesman_2 = isset($ref_ar2[1]) ? trim($ref_ar2[1]) : '';
} else {
$linesman_1 = '';
$linesman_2 = '';
}
}
if (strpos($tr->innertext, 'Diváci') > 0) {
$v_ar = explode(' ', $tr->plaintext);
$visit = str_replace('.', '', $v_ar[1]);
}
}
}
//match
$data = array('match_id' => $match_id, 'date' => $date, 'time' => $time, 'part' => $part, 'home' => $home, 'visitor' => $visitor, 'home_link' => $home_link, 'visitor_link' => $visitor_link, 'result' => $result, 'home_goals' => $result_ar[0], 'visitor_goals' => $result_ar[1], 'result_code' => result_code($result_ar), 'additional_result' => $add_result, 'halftime' => $halftime, 'additional_halftime' => $add_halftime, 'stadium' => $stadium, 'stadium_link' => $stadium_link, 'bet365_1' => isset($bet[0]) ? $bet[0] : '', 'bet365_2' => isset($bet[2]) ? $bet[2] : '', 'bet365_0' => isset($bet[1]) ? $bet[1] : '', 'referee' => $referee, 'linesman_1' => $linesman_1, 'linesman_2' => $linesman_2, 'visit' => $visit, 'league' => $row['league'], 'country' => $row['country'], 'season' => $row['season'], 'link' => $row['link']);
//print_r($data);die();
scraperwiki::save_sqlite(array('match_id'), $data, 'match');
$table = $dom->find('table[class=matchstats]', 0);
if (is_object($table)) {
//goals
$tr = $table->find('tr', 0);
$tds = $tr->find('td');
$goals_home = str2action($tds[0]->innertext, 'home', $match_id);
scraperwiki::save_sqlite(array('match_id', 'home_visitor', 'rank'), $goals_home, 'goal');
$goals_visitor = str2action($tds[2]->innertext, 'visitor', $match_id);
scraperwiki::save_sqlite(array('match_id', 'home_visitor', 'rank'), $goals_visitor, 'goal');
//cards
$tr = $table->find('tr', 1);
$tds = $tr->find('td');
$yellow_home = str2action($tds[0]->innertext, 'home', $match_id, 'yellow');
$data = array();
foreach ($tables as $mkey => $table) {
$trs = $table->find('tr');
foreach ($trs as $tr) {
$date = date2iso($tr->find('td', 0)->plaintext);
$time = $tr->find('td[class=time]', 0)->plaintext;
$teams = explode(' - ', $tr->find('td[class=teams]', 0)->find('div[class=fl]', 0)->innertext);
//echo '**';
$result = $tr->find('td', 3)->plaintext;
//echo $result;
$link = $tr->find('td', 3)->find('a', 0)->href;
if ($result != 'info') {
//it has been played already
$result_ar = explode(':', $result);
$id = trim(end(explode('-', $link)), '/');
$data[] = array('id' => $id, 'country' => $key, 'league' => $league['name'], 'season' => $season, 'part' => isset($h2s[$mkey]) ? $h2s[$mkey]->plaintext : '', 'date' => $date, 'time' => $time == '?' ? '' : $time, 'home' => trim($teams[0]), 'visitor' => trim($teams[1]), 'result' => $result, 'home_goals' => $result_ar[0], 'visitor_goals' => $result_ar[1], 'result_code' => result_code($result_ar), 'link' => $link);
//echo $teams[0].$tr->find('td[class=date]',0)->plaintext;
}
}
}
scraperwiki::save_sqlite(array('id'), $data);
}
}
function result_code($r)
{
if ($r[0] > $r[1]) {
return '1';
} else {
if ($r[1] > $r[0]) {
return '2';
} else {
