5 make a weekly cronjob (/etc/cron.weekly/filltv)
7 /usr/bin/php /path/to/application/Tv.php /path/to/application/hongkong.ini > /tmp/hongkong.xml
8 /usr/bin/mythfilldatabase --file 1 1 /tmp/hongkong.xml
10 make sure the filltv file is chmod +x
14 Quick hack to generate xmltv listings from TVxb style .ini files.
19 if (!extension_loaded('mbstring')) {
23 define ('QUOTE', '"');
26 var $config; // configuration array.
27 var $date; // date we are fetching
28 var $channels; // details on the channels.
34 require_once 'JSON.php';
35 $j = new Services_JSON();
36 $conf = (array)($j->decode(file_get_contents($ini)));
37 //$conf = (array)json_decode(file_get_contents($ini));
39 foreach($conf as $k=>$v) {
40 $conf[$k] = (array)$v;
42 $this->channels = $conf;
43 $this->config = $conf['global'];
44 unset($this->channels['global']);
45 //print_r($this->channels);
50 foreach($this->channels as $k=>$v) {
52 for ($i=0;$i< (isset($v['days']) ? $v['days'] : $conf['days']);$i++) {
53 $this->grabChannel($k,$i);
66 function grabChannel($k,$dayoffset)
68 $cinfo = $this->channels[$k];
72 $date = $this->date + ($dayoffset * 24 * 60 * 60 );
74 $url = strftime( $cinfo['url'], $date);
77 $data = @file_get_contents($url);
79 $this->debug("NO DATA");
81 // something went wrong..
87 array("0x22", "0x09", "0x0a"),
88 array('"', "\t", "\n")
92 $hs = $cinfo['htmlstart'] === false ? false : str_replace($map[0],$map[1],$cinfo['htmlstart']);
94 $he= str_replace($map[0],$map[1],$cinfo['htmlend']);
97 list( , $data) = explode($hs,$data);
101 list($data,) = explode($he ,$data);
105 //$this->debug("DATA:".$data);
107 $method = 'parse'.$cinfo['htmlparsetype'];
109 $chid = isset($cinfo['id']) ? $cinfo['id'] : $k;
110 // for multiday html layout of atv:
111 if (!empty($cinfo['htmldaysep'])) {
112 $days = explode($cinfo['htmldaysep'], $data);
113 // kludge. = first monday of current week..
114 // loook for... <BR>2007-12-31 Mon
115 $start = preg_match('/<BR>([0-9]{4}-[0-9]{2}-[0-9]{2}) Mon/i', $odata, $matches);
116 $start = $matches[1]; // first monday..
119 foreach($days as $i=>$ddata) {
123 $cols = explode(',',$cinfo['htmlcols']);
124 $dn = strtotime($start) + (($i * $use_cols) * 24 * 60 * 60 );
125 $res = $this->$method($ddata,$cols,date('Y-m-d',$dn));
126 if (is_string($res)) {
131 $this->schedule[$chid][strtotime($start) + (($i * $use_cols ) * 24 * 60 * 60 )] = $res;
138 $cols = explode(',',$cinfo['htmlcols']);
140 //print_r(array($data,$cols));
142 $this->schedule[$k][$this->date + ($dayoffset * 24 * 60 * 60 )] = $this->$method($data,$cols);
143 //print_r($this->schedule);
146 function parseTable($data,$colnames)
148 $rows = preg_split('/<tr[^>]*>/i', $data);
149 // print_r($rows);exit;
153 foreach($rows as $r) {
155 $cols = preg_split('/\<td[^>]*\>/i', trim($r));
158 //var_dump(count(array_values($cols)));
160 // print_r($cols);exit;
162 foreach($cols as $i=>$c) {
163 if (count(array_values($cols)) != count(array_values($colnames))) {
166 if (preg_match('/<table/i', $c)) {
170 $c = str_ireplace('<br>',' ', $c);
171 $c = str_ireplace(' ',' ', $c);
172 $c = str_replace("\n",' ', $c);
173 $c = str_replace("\r",' ', $c);
175 $rdata[$colnames[$i]] = trim(strip_tags($c));
179 if (count(array_values($rdata)) != count(array_values($colnames))) {
186 $this->debug(print_r($ret,true));
193 function parseJade($data, $colnames)
196 $rows = preg_split('#</li>#i', $data);
199 foreach($rows as $r) {
200 $r = str_ireplace(' ',' ', $r);
203 list($time,$r) = explode('</span>', $r, 2);
205 $rdata['hour'] = trim(strip_tags($time));
206 if (!strlen($rdata['hour'])) {
209 //list($title,$r) = explode('</em>', $r, 2);
210 list($title,$r) = explode('</p>', $r, 2);
211 $rdata['description'] = trim(strip_tags($title));
212 $rdata['description2'] = trim(strip_tags($r));
213 $rdata['day'] = $day;
221 function parseatv($data,$colnames, $day)
224 // if it's a day row..
226 $lines = explode("\n", trim($data));
227 //var_dump($lines[1]);
229 if (preg_match('/<div/', trim($lines[1]))) {
231 preg_match('/<BR>([0-9]{4}-[0-9]{2}-[0-9]{2})/i', $lines[1], $matches);
235 $rows = preg_split('/<tr[^>]*>/i', $data);
236 if ($day == '2011-10-29') {
237 $this->debug(print_r($rows,true));
239 //$this->debug($day);
240 //$this->debug(print_r($rows,true));
246 foreach($rows as $r) {
248 $cols = preg_split('/<td[^>]*>/i', $r);
256 if (!preg_match('/^[0-9]+:[0-9]+/', $c)) {
259 //$this->debug("GOT HOUR: $c");
260 $rdata['hour'] = trim(array_shift(explode('<', $c)));
263 $kv = preg_split('/<br>/',$c);
266 $c = str_ireplace('<br>',' ', $c);
267 $c = str_ireplace(' ',' ', $c);
268 $c = str_replace("\n",' ', $c);
269 $c = str_replace("\r",' ', $c);
270 $c = preg_replace('/\<[^>]+\>/', ' ', $c);
271 $rdata['description2'] = trim($c);
276 $c = str_ireplace('<br>',' ', $c);
277 $c = str_ireplace(' ',' ', $c);
278 $c = str_replace("\n",' ', $c);
279 $c = str_replace("\r",' ', $c);
280 $c = preg_replace('/\<[^>]+\>/', ' ', $c);
281 $rdata['description'] = trim($c);
284 $rdata['day'] = $day;
290 //print_r($ret); exit;
298 function parseTableCells($data,$colnames, $day)
300 $rows = preg_split('/<tr[^>]*>/i', $data);
301 //$this->debug(print_r($rows,true));
308 foreach($rows as $r) {
310 $cols = preg_split('/<td[^>]*>/i', $r);
315 if (!preg_match('/^[0-9]+:[0-9]+\s/', $c)) {
319 $c = str_ireplace('<br>',' ', $c);
320 $c = str_ireplace(' ',' ', $c);
321 $c = str_replace("\n",' ', $c);
322 $c = str_replace("\r",' ', $c);
325 $c = preg_replace('/\<[^>]+\>/', ' ', $c);
327 $kv = preg_split("/\s+/", $c, 2);
329 $rdata[$colnames[0]] = trim($kv[0]);
330 $rdata[$colnames[1]] = trim($kv[1]);
334 if (count(array_values($rdata)) != count(array_values($colnames))) {
337 $rdata['day'] = $day;
348 <tv generator-info-name="tv_grab_uk">
349 <channel id="bbc2.bbc.co.uk">
350 <display-name lang="en">BBC2</display-name>
352 <channel id="channel4.com">
353 <display-name lang="en">Channel 4</display-name>
356 <programme channel="bbc2.bbc.co.uk" start="20010829000500 +0100">
357 <title lang="en">The Phil Silvers Show</title>
359 Bilko claims he's had a close encounter with an alien in order
360 to be given some compassionate leave so he can visit an old
365 <programme channel="channel4.com" start="20010829095500 +0100">
366 <title lang="en">King of the Hill</title>
367 <sub-title lang="en">Meet the Propaniacs</sub-title>
369 Bobby tours with a comedy troupe who specialize in
370 propane-related mirth.
373 <actor>Mike Judge</actor>
374 <actor>Lane Smith</actor>
376 <category lang="en">animation</category>
384 //print_r($this->schedule);
385 $doc = new DomDocument('1.0', 'UTF-8');
386 $tv = $doc->createElement('tv');
387 $tv->setAttribute( 'generator-info-name','akpear_xml_tv');
388 $doc->appendChild($tv);
391 //$out = '<'.'?xml version="1.0" encoding="UTF-8"?.'>'."\n" .
392 // '<!DOCTYPE tv SYSTEM "xmltv.dtd">'."\n" ."\n" .
393 /// '<tv generator-info-name="akpear_xml_tv">'."\n";
395 foreach($this->channels as $k => $v) {
397 $chid = isset($v['id']) ? $v['id'] : $k;
398 if (isset($donec[$chid])) {
401 $donec[$chid] = true;
402 $ch = $doc->createElement('channel');
403 $ch->setAttribute('id', $chid);
404 $disp = $doc->createElement('display-name');
405 $disp->setAttribute('lang', 'en');
406 $disp->appendChild($doc->createTextNode($v['name']));
407 $ch->appendChild($disp);
408 $tv->appendChild($ch);
410 // '<channel id="'. $k .'">
411 // <display-name lang="en">'. $v['name'] .'</display-name>
414 //print_r($this->schedule);
415 foreach($this->schedule as $chan => $scheds) {
417 foreach($scheds as $day => $sched) {
424 foreach($sched as $item) {
427 $bits = explode(':', $item['hour']);
428 if ($bits[0] < $last) {
433 //var_dump($bits[0] + $hoffset);
434 $start = mktime(/*hmsmdy */
442 if ($start < strtotime(date("Y-m-d 00:00:00", strtotime('NOW - 1 DAY')))) {
445 $item['hoffset'] = $hoffset;
446 $item['hoffset_ar'] = $bits;
448 $this->debug(print_r($item, true));
449 $start_str = date('YmdHis',$start) . ' ' . $this->config['gmtoffset'];
450 //var_dump($start_str);
451 //var_dump($this->channels);
452 $description = iconv($this->channels[$chan]['encoding'], 'UTF-8',$item['description'] .
453 (isset($item['description2']) ? (' ' . $item['description2']) : ''));
455 $this->debug(date("Y-m-d H:i - ", $start). $description);
458 $pg = $doc->createElement('programme');
460 $pg->setAttribute('channel', $chan);
461 $pg->setAttribute('start', $start_str);
463 $title = $doc->createElement('title');
464 $title->setAttribute('lang', 'zh');
465 $title->appendChild($doc->createTextNode($this->toTitle($description,$chan)));
466 $pg->appendChild($title);
468 $title = $doc->createElement('desc');
469 $title->setAttribute('lang', 'zh');
470 $title->appendChild($doc->createTextNode($description));
471 $pg->appendChild($title);
473 $tv->appendChild($pg);
474 //$out.= '<programme channel="'.$chan. '" start="'.$start_str. '">
475 // <title lang="zh">'. $this->toTitle($description) .'</title>
476 // <desc lang="zh">'. $description .'</desc>
477 // </programme>'."\n";
482 $doc->formatOutput = true;
486 return $doc->saveXML();
490 function toTitle($description, $chan)
492 // remove sponsor message.
494 list($title, $fuldesc) = explode(">>",$description);
498 if (preg_match('/Followed\s*By/i', $title)) {
499 $bits = preg_split('/Followed\s*By/i', $title);
500 $title_pre = $bits[0] . ' Followed By ';
503 $title = preg_replace('#countdown to[a-z0-9 ]+#i', '' , $title); # NICAM Language
504 $title = preg_replace('#^(solar x|Samsung Digital)\s*#i', '' , $title); # known sponsors..
506 $title = preg_replace('#[a-z0-9 ]+(presents|special|blockbuster|movie of the month|showtime)\s*:\s*#i', '', $title);
508 $title = preg_replace('#\([a-z]+/[a-z]+\s*(|bilingual)\)#i', '' , $title); # NICAM Language
509 $title = preg_replace('#\(live\)#i', '' , $title); # live
510 $title = preg_replace('#\((s|c|l|e|cs|es|ecs|can|ce)[*]*\)#i', '' , $title); # Subtitle
511 $title = preg_replace('#\((pg\d*\w*)\)#i', '' , $title); # Adult
512 $title = preg_replace('#\(r\)#i', '' , $title); # Repeated
513 $title = trim($title, '/');
514 $title = trim($title);
516 $ret = $title_pre . $title;
518 // if (!strlen($ret)) {
519 // die("got $description : nothing to return");
521 if (in_array($chan, array('tvbpearl.hk', 'english.atvworld.hk'))) {
522 $enonly = preg_replace('#^[^a-z0-9]+#i', '', $title);
523 if (strlen($enonly) > 10) {
529 return $title_pre . $title;
536 if (empty($this->config['debug'])) {
548 $x->start($_SERVER['argv'][1]);