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 if (preg_match('/<div/', trim($data))) {
227 preg_match('/<BR>([0-9]{4}-[0-9]{2}-[0-9]{2})/i', $data, $matches);
231 $rows = preg_split('/<tr[^>]*>/i', $data);
234 //$this->debug(print_r($rows,true));
240 foreach($rows as $r) {
242 $cols = preg_split('/<td[^>]*>/i', $r);
250 if (!preg_match('/^[0-9]+:[0-9]+/', $c)) {
253 //$this->debug("GOT HOUR: $c");
254 $rdata['hour'] = trim(array_shift(explode('<', $c)));
257 $kv = preg_split('/<br>/',$c);
260 $c = str_ireplace('<br>',' ', $c);
261 $c = str_ireplace(' ',' ', $c);
262 $c = str_replace("\n",' ', $c);
263 $c = str_replace("\r",' ', $c);
264 $c = preg_replace('/\<[^>]+\>/', ' ', $c);
265 $rdata['description2'] = trim($c);
270 $c = str_ireplace('<br>',' ', $c);
271 $c = str_ireplace(' ',' ', $c);
272 $c = str_replace("\n",' ', $c);
273 $c = str_replace("\r",' ', $c);
274 $c = preg_replace('/\<[^>]+\>/', ' ', $c);
275 $rdata['description'] = trim($c);
278 $rdata['day'] = $day;
284 //print_r($ret); exit;
292 function parseTableCells($data,$colnames, $day)
294 $rows = preg_split('/<tr[^>]*>/i', $data);
295 //$this->debug(print_r($rows,true));
302 foreach($rows as $r) {
304 $cols = preg_split('/<td[^>]*>/i', $r);
309 if (!preg_match('/^[0-9]+:[0-9]+\s/', $c)) {
313 $c = str_ireplace('<br>',' ', $c);
314 $c = str_ireplace(' ',' ', $c);
315 $c = str_replace("\n",' ', $c);
316 $c = str_replace("\r",' ', $c);
319 $c = preg_replace('/\<[^>]+\>/', ' ', $c);
321 $kv = preg_split("/\s+/", $c, 2);
323 $rdata[$colnames[0]] = trim($kv[0]);
324 $rdata[$colnames[1]] = trim($kv[1]);
328 if (count(array_values($rdata)) != count(array_values($colnames))) {
331 $rdata['day'] = $day;
342 <tv generator-info-name="tv_grab_uk">
343 <channel id="bbc2.bbc.co.uk">
344 <display-name lang="en">BBC2</display-name>
346 <channel id="channel4.com">
347 <display-name lang="en">Channel 4</display-name>
350 <programme channel="bbc2.bbc.co.uk" start="20010829000500 +0100">
351 <title lang="en">The Phil Silvers Show</title>
353 Bilko claims he's had a close encounter with an alien in order
354 to be given some compassionate leave so he can visit an old
359 <programme channel="channel4.com" start="20010829095500 +0100">
360 <title lang="en">King of the Hill</title>
361 <sub-title lang="en">Meet the Propaniacs</sub-title>
363 Bobby tours with a comedy troupe who specialize in
364 propane-related mirth.
367 <actor>Mike Judge</actor>
368 <actor>Lane Smith</actor>
370 <category lang="en">animation</category>
378 //print_r($this->schedule);
379 $doc = new DomDocument('1.0', 'UTF-8');
380 $tv = $doc->createElement('tv');
381 $tv->setAttribute( 'generator-info-name','akpear_xml_tv');
382 $doc->appendChild($tv);
385 //$out = '<'.'?xml version="1.0" encoding="UTF-8"?.'>'."\n" .
386 // '<!DOCTYPE tv SYSTEM "xmltv.dtd">'."\n" ."\n" .
387 /// '<tv generator-info-name="akpear_xml_tv">'."\n";
389 foreach($this->channels as $k => $v) {
391 $chid = isset($v['id']) ? $v['id'] : $k;
392 if (isset($donec[$chid])) {
395 $donec[$chid] = true;
396 $ch = $doc->createElement('channel');
397 $ch->setAttribute('id', $chid);
398 $disp = $doc->createElement('display-name');
399 $disp->setAttribute('lang', 'en');
400 $disp->appendChild($doc->createTextNode($v['name']));
401 $ch->appendChild($disp);
402 $tv->appendChild($ch);
404 // '<channel id="'. $k .'">
405 // <display-name lang="en">'. $v['name'] .'</display-name>
408 //print_r($this->schedule);
409 foreach($this->schedule as $chan => $scheds) {
411 foreach($scheds as $day => $sched) {
418 foreach($sched as $item) {
421 $bits = explode(':', $item['hour']);
422 if ($bits[0] < $last) {
427 //var_dump($bits[0] + $hoffset);
428 $start = mktime(/*hmsmdy */
436 if ($start < strtotime(date("Y-m-d 00:00:00", strtotime('NOW - 1 DAY')))) {
439 $item['hoffset'] = $hoffset;
440 $item['hoffset_ar'] = $bits;
442 $this->debug(print_r($item, true));
443 $start_str = date('YmdHis',$start) . ' ' . $this->config['gmtoffset'];
444 //var_dump($start_str);
445 //var_dump($this->channels);
446 $description = iconv($this->channels[$chan]['encoding'], 'UTF-8',$item['description'] .
447 (isset($item['description2']) ? (' ' . $item['description2']) : ''));
449 $this->debug(date("Y-m-d H:i - ", $start). $description);
452 $pg = $doc->createElement('programme');
454 $pg->setAttribute('channel', $chan);
455 $pg->setAttribute('start', $start_str);
457 $title = $doc->createElement('title');
458 $title->setAttribute('lang', 'zh');
459 $title->appendChild($doc->createTextNode($this->toTitle($description,$chan)));
460 $pg->appendChild($title);
462 $title = $doc->createElement('desc');
463 $title->setAttribute('lang', 'zh');
464 $title->appendChild($doc->createTextNode($description));
465 $pg->appendChild($title);
467 $tv->appendChild($pg);
468 //$out.= '<programme channel="'.$chan. '" start="'.$start_str. '">
469 // <title lang="zh">'. $this->toTitle($description) .'</title>
470 // <desc lang="zh">'. $description .'</desc>
471 // </programme>'."\n";
476 $doc->formatOutput = true;
480 return $doc->saveXML();
484 function toTitle($description, $chan)
486 // remove sponsor message.
488 list($title, $fuldesc) = explode(">>",$description);
492 if (preg_match('/Followed\s*By/i', $title)) {
493 $bits = preg_split('/Followed\s*By/i', $title);
494 $title_pre = $bits[0] . ' Followed By ';
497 $title = preg_replace('#countdown to[a-z0-9 ]+#i', '' , $title); # NICAM Language
498 $title = preg_replace('#^(solar x|Samsung Digital)\s*#i', '' , $title); # known sponsors..
500 $title = preg_replace('#[a-z0-9 ]+(presents|special|blockbuster|movie of the month|showtime)\s*:\s*#i', '', $title);
502 $title = preg_replace('#\([a-z]+/[a-z]+\s*(|bilingual)\)#i', '' , $title); # NICAM Language
503 $title = preg_replace('#\(live\)#i', '' , $title); # live
504 $title = preg_replace('#\((s|c|l|e|cs|es|ecs|can|ce)[*]*\)#i', '' , $title); # Subtitle
505 $title = preg_replace('#\((pg\d*\w*)\)#i', '' , $title); # Adult
506 $title = preg_replace('#\(r\)#i', '' , $title); # Repeated
507 $title = trim($title, '/');
508 $title = trim($title);
510 $ret = $title_pre . $title;
512 // if (!strlen($ret)) {
513 // die("got $description : nothing to return");
515 if (in_array($chan, array('tvbpearl.hk', 'english.atvworld.hk'))) {
516 $enonly = preg_replace('#^[^a-z0-9]+#i', '', $title);
517 if (strlen($enonly) > 10) {
523 return $title_pre . $title;
530 if (empty($this->config['debug'])) {
542 $x->start($_SERVER['argv'][1]);