PageRenderTime 55ms CodeModel.GetById 20ms RepoModel.GetById 0ms app.codeStats 0ms

/download/cache.php

https://github.com/markhoney/nzxmltv
PHP | 2059 lines | 1623 code | 145 blank | 291 comment | 229 complexity | 42c0c722c880a2dbc835193e5baf8bc0 MD5 | raw file
Possible License(s): GPL-3.0

Large files files are truncated, but you can click here to view the full file

    

  1. <?php
    2. 

  2. 

  3. /*
    4. 

  4.     This file is part of NZ XMLTV Listings.
    5. 

    6. 

  6.     NZ XMLTV Listings is free software: you can redistribute it and/or modify
    7. 

  7.     it under the terms of the GNU General Public License as published by
    8. 

  8.     the Free Software Foundation, either version 3 of the License, or
    9. 

  9.     (at your option) any later version.
    10. 

    11. 

  11.     NZ XMLTV Listings is distributed in the hope that it will be useful,
    12. 

  12.     but WITHOUT ANY WARRANTY; without even the implied warranty of
    13. 

  13.     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
    14. 

  14.     GNU General Public License for more details.
    15. 

    16. 

  16.     You should have received a copy of the GNU General Public License
    17. 

  17.     along with NZ XMLTV Listings.  If not, see <http://www.gnu.org/licenses/>.
    18. 

  18. */
    19. 

  19. 

  20. include '../libs/nzxmltv.php';
    21. 

  21. 

  22. ob_start();
    23. 

  23. 

  24. connectToDB();
    25. 

  25. 

  26. DeclareConstants;
    27. 

  27. 

  28. 

  29. /* Generic Functions */
    30. 

  30. 

  31. function echoIfNotSilent($string)
    32. 

  32. {
    33. 

  33.  echo (runSilently != 'yes' ? $string : NULL);
    34. 

  34.  ob_flush();
    35. 

  35.  flush();
    36. 

  36. }
    37. 

  37. 

  38. function sqlOR($orarray, $fieldName)
    39. 

  39. {
    40. 

  40.  foreach ($orarray as $or)
    41. 

  41.  {
    42. 

  42.   $sqlStatement = $sqlStatement . $fieldName . "='" . $or . "' OR ";
    43. 

  43.  }
    44. 

  44.  return substr($sqlStatement, 0, -4);
    45. 

  45. }
    46. 

  46. 

  47. function GetPage($url, $saveTo = NULL, $saveFilename = NULL, $minimumFileSize = 2048) //Get a page of data, either from the local filesystem or a website
    48. 

  48. {
    49. 

  49.  if ($saveTo == '' OR $saveTo == NULL)
    50. 

  50.  {
    51. 

  51.   unset($saveTo);
    52. 

  52.  }
    53. 

  53.  if ($saveFilename == '' OR $saveFilename == NULL)
    54. 

  54.  {
    55. 

  55.   $localFilename = $saveTo . basename($url);
    56. 

  56.  }
    57. 

  57.  else
    58. 

  58.  {
    59. 

  59.   $localFilename = $saveTo . $saveFilename;
    60. 

  60.  }
    61. 

  61.  $fileType = strtolower(pathinfo($localFilename, PATHINFO_EXTENSION));
    62. 

  62.  if (isset($saveTo) AND file_exists($localFilename)) //If the file already exists locally
    63. 

  63.  {
    64. 

  64.   $url = $localFilename; // Change the URL to point to the local version
    65. 

  65.  }
    66. 

  66.  $datapage = file_get_contents($url); //Get the page content
    67. 

  67.  if ($datapage <> '' AND $datapage <> FALSE AND strlen($datapage) > $minimumFileSize) //If the page isn't empty
    68. 

  68.  {
    69. 

  69.   if (isset($saveTo) AND !file_exists($localFilename))
    70. 

  70.   {
    71. 

  71.    if (!file_exists($saveTo)) //If the folder doesn't exist
    72. 

  72.    {
    73. 

  73.     mkdir($saveTo, 0777, true); //Recursively make the folder
    74. 

  74.    }
    75. 

  75.    file_put_contents($localFilename, $datapage); //Save a copy
    76. 

  76.    if (verboseOutput == 'yes')
    77. 

  77.    {
    78. 

  78.     echoIfNotSilent('Cached file ' . $localFilename . '<br />' . "\n");
    79. 

  79.    }
    80. 

  80.   }
    81. 

  81.   if ($fileType <> 'jpg' AND $fileType <> 'jpeg' AND $fileType <> 'gif' AND $fileType <> 'png')
    82. 

  82.   {
    83. 

  83.    $datapage = FixBadCharacters(stripslashes($datapage));
    84. 

  84.   }
    85. 

  85.   return $datapage; //Return the contents of the page
    86. 

  86.  }
    87. 

  87. }
    88. 

  88. 

  89. function DBInsert($table, $sqlArray, $verbose = FALSE)
    90. 

  90. {
    91. 

  91.  foreach ($sqlArray as $insert => $value)
    92. 

  92.  {
    93. 

  93.   $inserts = $inserts . $insert . ",";
    94. 

  94.   $values = $values . ((is_null($value) OR trim($value)=='') ? "NULL" : "'" . mysql_real_escape_string(trim(html_entity_decode(stripslashes($value)))) . "'") . ",";
    95. 

  95.  }
    96. 

  96.  $sqlQuery = "REPLACE INTO " . $table . " (" . rtrim($inserts, ",") . ") VALUES (" . rtrim($values, ",") . ")";
    97. 

  97.  if ($verbose)
    98. 

  98.  {
    99. 

  99.   //print_r($sqlArray);
    100. 

  100.   //echoIfNotSilent($sqlQuery . "<br />\r\n");
    101. 

  101.  }
    102. 

  102.  mysql_query($sqlQuery) or die(mysql_error());
    103. 

  103. }
    104. 

  104. 

  105. function DBUpdate($table, $sqlArray, $whereArray)
    106. 

  106. {
    107. 

  107.  foreach ($sqlArray as $column => $value)
    108. 

  108.  {
    109. 

  109.   $values = $values . $column . "=" . ((is_null($value) OR trim($value)=='') ? 'NULL' : "'" . mysql_real_escape_string(trim(html_entity_decode(stripslashes($value)))) . "'") . ",";
    110. 

  110.  }
    111. 

  111.  foreach ($whereArray as $column => $value)
    112. 

  112.  {
    113. 

  113.   $wheres = $wheres . $column . "=" . ((is_null($value) OR trim($value)=='') ? 'NULL' : "'" . mysql_real_escape_string($value) . "'") . " AND ";
    114. 

  114.  }
    115. 

  115.  $sqlQuery = "UPDATE " . $table . " SET " . rtrim($values, ",") . " WHERE " . substr($wheres, 0, -5) . ")";
    116. 

  116.  //echoIfNotSilent($sqlQuery . "<br />\r\n");
    117. 

  117.  mysql_query($sqlQuery) or die(mysql_error());
    118. 

  118. }
    119. 

  119. 

  120. function CreateList($inputArray, $element, $separator)
    121. 

  121. {
    122. 

  122.  if (is_array($inputArray))
    123. 

  123.  {
    124. 

  124.   foreach ($inputArray as $arrayElement)
    125. 

  125.   {
    126. 

  126.    if (($element = "") or (empty($element)))
    127. 

  127.    {
    128. 

  128.     $item = $arrayElement;
    129. 

  129.    }
    130. 

  130.    else
    131. 

  131.    {
    132. 

  132.     $item = $arrayElement->$element;
    133. 

  133.    }
    134. 

  134.    if (is_string($item))
    135. 

  135.    {
    136. 

  136.     if (trim($item) <> "")
    137. 

  137.     {
    138. 

  138.      $outputList = $outputList . trim($arrayElement->$element) . $separator;
    139. 

  139.     }
    140. 

  140.    }
    141. 

  141.   }
    142. 

  142.   return rtrim($outputList, ",");
    143. 

  143.  }
    144. 

  144. }
    145. 

  145. 

  146. function BlankValue($value, $nullvalue)
    147. 

  147. {
    148. 

  148.  $return = (($value == $nullvalue OR trim($value) == "") ? "" : $value);
    149. 

  149.  return $return;
    150. 

  150. }
    151. 

  151. 

  152. 

  153. 

  154. 

  155. 

  156. 

  157. 

  158. /* Data scraping */
    159. 

  159. 

  160. function TelstraGetListings($datadate, $hours, $package) //Get TV listings for a specified date and number of hours
    161. 

  161. {
    162. 

  162.  return GetPage(telstraDataURL . 'tvg-gridlist-base.cfm?v=l&c=' . $package . '&h=1&f=' . $hours . '&d=' . $datadate, listingsFolder); //Return the page for relevant day and number of hours (v = view, c = channels, h = hour start, f = number of hours, d = date )
    163. 

  163. }
    164. 

  164. 

  165. 

  166. /* Channels */
    167. 

  167. 

  168. function TelstraGrabChannelPackages()
    169. 

  169. {
    170. 

  170.  $optionsURL = telstraDataURL . "tvg-grid-top.cfm";
    171. 

  171.  preg_match_all('~<option value="pkg-' .
    172. 

  172. 				'(?P<package>.*?)' .
    173. 

  173. 				'">~ism',
    174. 

  174. 				GetPage($optionsURL /*, listingsFolder */), $packages, PREG_SET_ORDER);
    175. 

  175.  foreach ($packages as $package)
    176. 

  176.  {
    177. 

  177.   preg_match_all('~<td rowspan="1000" align="center" valign="top"><img src="' .
    178. 

  178. 				'(?P<url>.*?)' . //Channel Image URL
    179. 

  179. 				'" alt="' .
    180. 

  180. 				'(?P<name>.*?)' . //Name of channel
    181. 

  181. 				'"~ism',
    182. 

  182. 				TelstraGetListings(currentDate, 24, 'pkg-' . urlencode($package[package])), $programs, PREG_SET_ORDER); //1 = URL of channel image, 2 = Name of channel, 4 = Details URL for first programme
    183. 

  183.   $packageChannels = '';
    184. 

  184.   foreach ($programs as $program)
    185. 

  185.   {
    186. 

  186.    $result = mysql_query("Select TC_id FROM xmltvChannels WHERE display_name='$program[name]'") or die(mysql_error());
    187. 

  187.    $row = mysql_fetch_assoc($result);
    188. 

  188.    $packageChannels .= $row[TC_id] . ",";
    189. 

  189.   }
    190. 

  190.   $packageChannels = rtrim($packageChannels, ",");
    191. 

  191.   if ($packageChannels <> "")
    192. 

  192.   {
    193. 

  193.    mysql_query("INSERT INTO ChannelPackages (provider,package,channels) VALUES('Telstra','$package[url]','$packageChannels')") or die(mysql_error());
    194. 

  194.   }
    195. 

  195.  }
    196. 

  196. }
    197. 

  197. 

  198. function MergeChannelsTables($source) //Merge data from the Channels table (manually updated) into the Channels table (auto-generated).
    199. 

  199. {
    200. 

  200.  global $availableSources;
    201. 

  201.  $availableNumbers = array('Sky', 'Freeview', 'Analogue', 'All');
    202. 

  202.  $channels = mysql_query("SELECT * FROM Channels WHERE " . $source . "_id IS NOT NULL");
    203. 

  203.  while ($channel = mysql_fetch_assoc($channels))
    204. 

  204.  {
    205. 

  205.   $channel = CleanQuoteArray($channel);
    206. 

  206.   $saveSources = "";
    207. 

  207.   foreach ($availableSources as $availableSource)
    208. 

  208.   {
    209. 

  209.    $saveSources .= ", " . $availableSource . "_id=" . $channel[$availableSource . '_id'];
    210. 

  210.   }
    211. 

  211.   $saveNumbers = "";
    212. 

  212.   foreach ($availableNumbers as $number)
    213. 

  213.   {
    214. 

  214.    $saveNumbers .= ", " . $number . "_number=" . $channel[$number . '_number'];
    215. 

  215.   }
    216. 

  216.   mysql_query("UPDATE xmltvChannels SET display_name=" . $channel['display_name'] . $saveSources . $saveNumbers . ", large_icon=" . $channel[large_icon] . ", url=" . $channel['url'] . " WHERE " . $source . "_id=" . $channel[$source . '_id']); // or die(mysql_error());
    217. 

  217.   foreach(array('small_icon','genre') as $field)
    218. 

  218.   {
    219. 

  219.    if ($channel[$field] <> 'NULL')
    220. 

  220.    {
    221. 

  221.     mysql_query("UPDATE xmltvChannels SET " . $field . "=" . $channel[$field] . " WHERE " . $source . "_id=" . $channel[$source . '_id']); // or die(mysql_error());
    222. 

  222.    }
    223. 

  223.   }
    224. 

  224.  }
    225. 

  225. }
    226. 

  226. 

  227. function UpdateChannelsTable($display_name, $source, $channel_id, $genre = NULL, $small_icon = NULL)
    228. 

  228. {
    229. 

  229.  mysql_query("UPDATE xmltvChannels SET display_name='$display_name' WHERE " . $source . "_id='" . $source . "-" . $channel_id . "'"); // or die(mysql_error());
    230. 

  230.  mysql_query("UPDATE xmltvChannels SET " . $source . "_id='" . $source . "-" . $channel_id . "' WHERE display_name='$display_name'"); // or die(mysql_error());
    231. 

  231.  if ($genre <> NULL)
    232. 

  232.  {
    233. 

  233.   $extraFields = ',genre,small_icon';
    234. 

  234.   $extraFieldValues = ",'" . $genre  . "','" . $small_icon . "'";
    235. 

  235.  }
    236. 

  236.  mysql_query("INSERT INTO xmltvChannels (" . $source . "_id,display_name" . $extraFields . ") VALUES('" . $source . "-" . $channel_id . "','$display_name'" . $extraFieldValues . ")"); // or die(mysql_error());
    237. 

  237. }
    238. 

  238. 

  239. function TelstraGrabChannelList()
    240. 

  240. {
    241. 

  241.  $source = 'TC';
    242. 

  242.  $provider = 'Telstra';
    243. 

  243.  $genresURL = telstraDataURL . "tvg-grid-top.cfm";
    244. 

  244.  $channelsURL = telstraDataURL . "tvg-channel-favourites.cfm?v=ga&mf=1";
    245. 

  245.  echoIfNotSilent('<p>');
    246. 

  246.  preg_match_all('~<option value="genre-(?P<code>.*?)">(?P<name>.*?)</option>~ism', GetPage($genresURL, listingsFolder), $genres, PREG_SET_ORDER);
    247. 

  247.  foreach ($genres as &$genre)
    248. 

  248.  {
    249. 

  249.   $genrelist[$genre[code]] = $genre[name];
    250. 

  250.  }
    251. 

  251.  preg_match_all('~\'\)"><img src="' .
    252. 

  252. 				'(?P<image>.*?)' .
    253. 

  253. 				'" alt="' .
    254. 

  254. 				'(?P<id>.*?)' .
    255. 

  255. 				'" width="47" height="47" vspace="4" border="0"><a></a><br>' .
    256. 

  256. 				'.*?' .
    257. 

  257. 				'value="' .
    258. 

  258. 				'(?P<name>.*?)' .
    259. 

  259. 				'" genre="' .
    260. 

  260. 				'(?P<genre>.*?)' .
    261. 

  261. 				'"~ism',
    262. 

  262. 				GetPage($channelsURL, listingsFolder), $channels, PREG_SET_ORDER);
    263. 

  263.  foreach ($channels as $channel)
    264. 

  264.  {
    265. 

  265.   $genre = $genrelist[ltrim($channel[genre], "g")];
    266. 

  266.   mysql_query("UPDATE xmltvChannels SET Telstra_genre='" . $genre . "' WHERE " . $source . "_id='" . $source . "-" . $channel[id] . "'");
    267. 

  267.   UpdateChannelsTable($channel[id], $source, $channel[name], $genre, mysql_real_escape_string($channel[image]));
    268. 

  268.   $channelList[$channel[name]] = Array("source" => $source, "name" => $channel[id], "genre" => $genre, "image" => mysql_real_escape_string($channel[image]));
    269. 

  269.   echoIfNotSilent('Added ' . $provider . ' channel ' . $channel[name] . '<br />' . "\n");
    270. 

  270.  }
    271. 

  271.  preg_match_all('~<td rowspan="1000" align="center" valign="top"><img src="' .
    272. 

  272. 				'(?P<image>.*?)' . //Channel Image URL
    273. 

  273. 				'" alt="' .
    274. 

  274. 				'(?P<name>.*?)' . //Name of channel
    275. 

  275. 				'" width="47" height="47">' .
    276. 

  276. 				'.*?' .
    277. 

  277. 				'openBrWindow\(\'' .
    278. 

  278. 				'(?P<url>.*?)' . //Details URL for first programme
    279. 

  279. 				'\',~ism',
    280. 

  280. 				TelstraGetListings(currentDate, 1, 'all'), $programs, PREG_SET_ORDER); //1 = URL of channel image, 2 = Name of channel, 4 = Details URL for first programme
    281. 

  281.  foreach ($programs as $program)
    282. 

  282.  {
    283. 

  283.   preg_match('~<strong>Channel: </strong></td>' .
    284. 

  284. 			'.*?' .
    285. 

  285. 			'<strong>' .
    286. 

  286. 			'(?P<name>.*?)' . //Channel Name
    287. 

  287. 			' \(' .
    288. 

  288. 			'(Channel|Digital|Analogue) ' .
    289. 

  289. 			'(?P<number>.*?)' . //Channel Number
    290. 

  290. 			'\) </strong></td>~ism',
    291. 

  291. 			GetPage(telstraDataURL . $program[url], programsFolder), $channelNumber);
    292. 

  292.   mysql_query("UPDATE xmltvChannels SET " . $provider . "_number='" . $channelNumber[number] . "' WHERE " . $source . "_id='" . $source . "-" . GrabTelstraID($program[4]) . "'");
    293. 

  293.   $channelList[GrabTelstraID($program[url])]["number"] = $channelNumber[number];
    294. 

  294.  }
    295. 

  295.  MergeChannelsTables($source);
    296. 

  296.  echoIfNotSilent('</p>' . "\n");
    297. 

  297.  return $channelList;
    298. 

  298. }
    299. 

  299. 

  300. function YahooGrabChannelList($channelSet)
    301. 

  301. {
    302. 

  302.  $source = 'YH';
    303. 

  303.  $provider = 'Yahoo';
    304. 

  304.  echoIfNotSilent('<p>');
    305. 

  305.  $channelsURL = "http://nz.tv.yahoo.com/tv-guide/?hour=00&min=00&date=" . date('d') . "&mon=" . date('m') . "&year=" . date('Y') . "&tvrg=" . $channelSet;
    306. 

  306.  //echo $channelsURL . "<br />\r\n";
    307. 

  307.  preg_match_all('~<div class="lt-listing-wrapper"><a href="http://nz.tv.yahoo.com/tv-guide/search/index.html\?venue=' .
    308. 

  308. 				'(?P<id>.*?)' .
    309. 

  309. 				'&now=' .
    310. 

  310. 				'.*?' .
    311. 

  311. 				'">' .
    312. 

  312. 				'(?P<name>.*?)' .
    313. 

  313. 				'</a></div>~ism',
    314. 

  314. 				GetPage($channelsURL, listingsFolder), $matches, PREG_SET_ORDER);
    315. 

  315.  foreach ($matches as $match)
    316. 

  316.  {
    317. 

  317.   if ($channelSet . "-" . $match[id] <> "2-20") //If the channel's not a duplicate of TAB Trackside
    318. 

  318.   {
    319. 

  319.    UpdateChannelsTable($match[name], $source, $channelSet . "-" . $match[id]);
    320. 

  320.    $channelList[$channelSet . "-" . $match[is]] = Array("source" => $source, "name" => $match[name]);
    321. 

  321.    echoIfNotSilent('Added ' . $provider . ' channel ' . $match[name] . '<br />' . "\n");
    322. 

  322.   }
    323. 

  323.  }
    324. 

  324.  MergeChannelsTables($source);
    325. 

  325.  echoIfNotSilent('</p>' . "\n");
    326. 

  326. }
    327. 

  327. 

  328. function FreeViewGrabChannelList()
    329. 

  329. {
    330. 

  330.  $source = 'FV';
    331. 

  331.  $provider = 'Freeview';
    332. 

  332.  echoIfNotSilent('<p>');
    333. 

  333.  $pageXML = new SimpleXMLElement(GetPage('http://freeviewnz.tv/epg_data.php', listingsFolder));
    334. 

  334.  foreach ($pageXML->item as $channel)
    335. 

  335.  {
    336. 

  336.   preg_match('~http://listings.tvnz.co.nz/freeview/(?P<id>.*?)_7days.xml~ism', $channel->url, $tvnzidArray);
    337. 

  337.   /*if ($channel->name == 'TV3 PLUS 1')
    338. 

  338.   {
    339. 

  339.    $tvnzidArray[id] = 'tv3plus1';
    340. 

  340.   }*/
    341. 

  341.   UpdateChannelsTable($channel->name, $source, $tvnzidArray[id]);
    342. 

  342.   echoIfNotSilent('Added ' . $provider . ' channel ' . $channel->name . '<br />' . "\n");
    343. 

  343.  }
    344. 

  344.  MergeChannelsTables($source);
    345. 

  345.  echoIfNotSilent('</p>' . "\n");
    346. 

  346. }
    347. 

  347. 

  348. function SatelliteGrabChannelList()
    349. 

  349. {
    350. 

  350. 

  351. }
    352. 

  352. 

  353. function GrabIcons()
    354. 

  354. {
    355. 

  355.  echoIfNotSilent('<h1>Caching Icons...</h1>' . "\n" . '<p>' . "\n");
    356. 

  356.  foreach (array('small', 'large') as $iconSize)
    357. 

  357.  {
    358. 

  358.   $result = mysql_query("SELECT " . $iconSize . "_icon FROM xmltvChannels WHERE " . $iconSize . "_icon IS NOT NULL");
    359. 

  359.   while ($row = mysql_fetch_assoc($result))
    360. 

  360.   {
    361. 

  361.    GetPage($row[$iconSize . '_icon'], iconsFolder . $iconSize . '/');
    362. 

  362.   }
    363. 

  363.  }
    364. 

  364.  $result = mysql_query("SELECT icon FROM ProgramRatings WHERE icon IS NOT NULL");
    365. 

  365.  while ($row = mysql_fetch_assoc($result))
    366. 

  366.  {
    367. 

  367.   GetPage($row[icon], ratingsFolder);
    368. 

  368.  }
    369. 

  369.  echoIfNotSilent('</p>' . "\n");
    370. 

  370. }
    371. 

  371. 

  372. 

  373. /* Programs */
    374. 

  374. 

  375. function TelstraGrabProgramList($day)
    376. 

  376. {
    377. 

  377.  $dataDate = date('Y-m-d', strtotime(currentDateSQL . " +" . $day . " days"));
    378. 

  378.  if (preg_match_all('~<td valign="top" class="tvgtime">' .
    379. 

  379. 				    '(?P<startalt>.*?)' . //Start Time
    380. 

  380. 				    '</td>' .
    381. 

  381. 				    '.*?' .
    382. 

  382. 				    'onmouseover="return escape\(\'' .
    383. 

  383. 				    '(?P<genres>.*?)' . //Genre(s)
    384. 

  384. 				    '<br><b>' .
    385. 

  385. 				    '(?P<title>.*?)' . //Title
    386. 

  386. 				    '</b><br><b>' .
    387. 

  387. 				    '(?P<channel>.*?)' . //Channel
    388. 

  388. 				    '</b><br><b>' .
    389. 

  389. 				    '(?P<start>.*?)' . //Start Time
    390. 

  390. 				    '-' .
    391. 

  391. 				    '(?P<end>.*?)' . //End Time
    392. 

  392. 				    '</b>' .
    393. 

  393. 				    '.*?' .
    394. 

  394. 				    'openBrWindow\(\'' .
    395. 

  395. 				    '(?P<url>.*?)' . //Details URL
    396. 

  396. 				    '\',' .
    397. 

  397. 				    '.*?' .
    398. 

  398. 				    //'<span class="tvgclassification">\(' .
    399. 

  399. 					'</a>' .
    400. 

  400. 				    '(?P<rating>.*?)' . //Age Classification
    401. 

  401. 				    //'\)</span>~ism',
    402. 

  402. 					'</td>~ism',
    403. 

  403. 				    TelstraGetListings($dataDate, 24, 'all'), $programs, PREG_SET_ORDER) > 0) // 1 = Start Time, 2 = Genre(s), comma delimited, 3 = Title, 4 = Channel, 5 = Start Time, 6 = End Time, 7 = Details URL, 8 = Age Classification
    404. 

  404.  {
    405. 

  405.   foreach ($programs as $program)
    406. 

  406.   {
    407. 

  407.    unset($listing);
    408. 

  408.    $listing['file'] = trim($program[url]);
    409. 

  409.    $programResult = mysql_query("SELECT file FROM xmltvSourcePrograms WHERE file='" . $listing['file'] . "'") or die(mysql_error());
    410. 

  410.    if (mysql_num_rows($programResult) < 1)
    411. 

  411.    {
    412. 

  412.     //$listing['date'] = $dataDate;
    413. 

  413.     preg_match('~&ds=(?P<date>.*?)&st=~ism', $listing['file'], $dateArray);
    414. 

  414.     $startdate = $dateArray[date];
    415. 

  415.     $startTime = FixTime(trim($program[start]));
    416. 

  416.     $stopTime = FixTime(trim($program[end]));
    417. 

  417.     $listing['title'] = trim(htmlspecialchars_decode($program[title]));
    418. 

  418.     $listing['start'] = date('Y-m-d H:i:s', strtotime($startdate . ' ' . $startTime));
    419. 

  419.     //$listing['stop'] = date('Y-m-d H:i:s', strtotime($startdate . ' ' . $stopTime));
    420. 

  420.     $stopDate = $startdate;
    421. 

  421.     if (strtotime($startTime) >= strtotime($stopTime))
    422. 

  422.     {
    423. 

  423.      $stopDate = date('Y-m-d', strtotime($startdate . " +1 day"));;
    424. 

  424.     }
    425. 

  425.     $listing['stop'] = date('Y-m-d H:i:s', strtotime($stopDate . ' ' . $stopTime));
    426. 

  426.     $listing['channel_id'] = "TC-" . GrabTelstraID($listing['file']);
    427. 

  427. 	$channelnameresult = mysql_query("SELECT All_id FROM xmltvChannels WHERE  TC_id = '" . $listing['channel_id'] . "'") or die(mysql_error());
    428. 

  428. 	$channelnamerow = mysql_fetch_assoc($channelnameresult);
    429. 

  429. 	$listing['channel'] = $channelnamerow['All_id'];
    430. 

  430.     //$listing['rating'] = trim($program[8]);
    431. 

  431. 	preg_match('~<span class="tvgclassification">\((?P<rating>.*?)\)</span>~ism', trim($program[rating]), $ratingArray);
    432. 

  432. 	$listing['rating'] = $ratingArray[rating];
    433. 

  433.     if (preg_match('~<td valign="top"><span class="tvbluesml"><strong class="tvhdrpurple"> <br>' . "\r" .
    434. 

  434. 			       '(?P<title>.*?)' . // Title
    435. 

  435. 			       '</strong></span>' .
    436. 

  436. 			       '.*?' .
    437. 

  437. 			       '<strong class="tvhdrpurple"><img src="' .
    438. 

  438. 			       telstraImagesURL .
    439. 

  439. 			       '(?P<image>.*?)' . // TV Channel Image
    440. 

  440. 			       '" alt="Logo" width="47" height="47"' .
    441. 

  441. 			       '.*?' .
    442. 

  442. 			       '<strong>Channel: </strong></td>' .
    443. 

  443. 			       '.*?' .
    444. 

  444. 			       '<strong>' .
    445. 

  445. 			       '(?P<channel>.*?)' . //Channel Name
    446. 

  446. 			       ' \(' .
    447. 

  447. 			       '(Channel|Digital|Analogue) ' .
    448. 

  448. 			       '(?P<number>.*?)' . //Channel Number
    449. 

  449. 			       '\) </strong></td>' .
    450. 

  450. 			       '.*?' .
    451. 

  451. 			       '<strong>Playing: </strong></td>' .
    452. 

  452. 			       '.*?' .
    453. 

  453. 			       '<td><strong class="tvbluesml">' .
    454. 

  454. 			       '(?P<day>.*?)' . //Broadcast Day
    455. 

  455. 			       ' at ' .
    456. 

  456. 			       '(?P<time>.*?)' . //Broadcast time
    457. 

  457. 			       '<!---' .
    458. 

  458. 			       '.*?' .
    459. 

  459. 			       '---></strong></td>' .
    460. 

  460. 			       '.*' .
    461. 

  461. 			       '<strong>Duration: </strong>' .
    462. 

  462. 			       '.*?' .
    463. 

  463. 			       '<td class="tvbluesml">' .
    464. 

  464. 			       '(?P<duration>.*?)' . //Duration in minutes
    465. 

  465. 			       ' Minutes</td>' .
    466. 

  466. 			       '.*?' .
    467. 

  467. 			       '<strong>Genre: </strong>' .
    468. 

  468. 			       '.*?' .
    469. 

  469. 			       '<td class="tvbluesml">' .
    470. 

  470. 			       '(?P<genre>.*?)' . //Genre
    471. 

  471. 			       '</td>' .
    472. 

  472. 			       '.*?' .
    473. 

  473. 			       '</table>' .
    474. 

  474. 			       '(?P<description>.*?)' . //Description
    475. 

  475. 			       '<br>~ism',
    476. 

  476. 			       GetPage(telstraDataURL . $listing['file'], programsFolder), $details) <> 0) // 1 = Title, 2 = Channel ID, 3 = Channel Name, 4 = Channel Number, 5 = Broadcast Day, 6 = Broadcast time, 7 = Duration in Minutes, 8 = Genre, 9 = Description
    477. 

  477.     {
    478. 

  478. 	 //$listing['title'] = trim($details[title]);
    479. 

  479.      if (substr($listing['title'], strlen($listing['title']) - 8, 8) == '&laquo; ') { $listing['title'] = substr($listing['title'], 8, strlen($listing['title']) - 8); }
    480. 

  480.      if (substr($listing['title'], 0, 8) == ' &raquo;') { $listing['title'] = substr($listing['title'], 0, strlen($listing['title']) - 8); }
    481. 

  481.      /*preg_match('~ \((.*?)\)$~ism', $listing['title'], $rating);
    482. 

  482.      if (isset($rating[1]))
    483. 

  483.      {
    484. 

  484.       $listing['rating'] = trim($rating[1]);
    485. 

  485.      }*/
    486. 

  486.      //$listing['day'] = trim($details[day]);
    487. 

  487.      //$listing['duration'] = trim($details[duration]);
    488. 

  488.      $listing['category'] = trim($details[genre]);
    489. 

  489.      /*
    490. 

  490. 	 if ($listing['category'] == 'undefined, default value')
    491. 

  491.      {
    492. 

  492.       unset($listing['category']);
    493. 

  493.      }
    494. 

  494. 	 */
    495. 

  495.      $listing['description'] = trim(htmlspecialchars_decode($details[description]));
    496. 

  496.      /*
    497. 

  497. 	 if ($listing['category'] <> "Radio")
    498. 

  498. 	 {
    499. 

  499. 	  //$listing['quality'] = 'SD';
    500. 

  500. 	 }
    501. 

  501. 	 */
    502. 

  502.      /*
    503. 

  503. 	 foreach ($listing as $insert => $value)
    504. 

  504.      {
    505. 

  505.       $inserts = $inserts . $insert . ",";
    506. 

  506.       $values = $values . $value . ",";
    507. 

  507.      }
    508. 

  508. 	 mysql_query("INSERT INTO xmltvSourcePrograms (" . rtrim($inserts, ",") . ") VALUES(" . rtrim($values, ",") . ")") or die(mysql_error());
    509. 

  509.      */
    510. 

  510. 	 DBInsert("xmltvSourcePrograms", $listing);
    511. 

  511. 	 if (verboseOutput == 'yes')
    512. 

  512.      {
    513. 

  513.       echoIfNotSilent('Grabbed program ' . $listing['file'] . '<br />' . "\n");
    514. 

  514.      }
    515. 

  515.     }
    516. 

  516.     else
    517. 

  517.     {
    518. 

  518.      if (verboseOutput == 'yes')
    519. 

  519.      {
    520. 

  520.       echoIfNotSilent('Failed to grab program ' . $listing['file'] . '<br />' . "\n");
    521. 

  521.      }
    522. 

  522.     }
    523. 

  523.    }
    524. 

  524.    else
    525. 

  525.    {
    526. 

  526.     if (verboseOutput == 'yes')
    527. 

  527.     {
    528. 

  528.      echoIfNotSilent('Already grabbed program ' . $listing['file'] . '<br />' . "\n");
    529. 

  529.     }
    530. 

  530.    }
    531. 

  531.   }
    532. 

  532.  }
    533. 

  533.  else
    534. 

  534.  {
    535. 

  535.   if (verboseOutput == 'yes')
    536. 

  536.   {
    537. 

  537.    echoIfNotSilent('Failed to grab any program listings for day ' . $day . '<br />' . "\n");
    538. 

  538.   }
    539. 

  539.  }
    540. 

  540. }
    541. 

  541. 

  542. function YahooGrabProgramList($day)
    543. 

  543. {
    544. 

  544.  foreach (array('0', '2') as $channelSet)
    545. 

  545.  {
    546. 

  546.   for ( $hour = 00; $hour <= 23; $hour += 1)
    547. 

  547.   {
    548. 

  548.    $programsURL = "http://nz.tv.yahoo.com/tv-guide/1/" . $channelSet . "/" . $day . "/" . $hour . "/";
    549. 

  549.    //echoIfNotSilent('<a href="' . $programsURL . '">' . $programsURL . "</a><br />\r\n");
    550. 

  550.    preg_match('~<input type="hidden" id="tvguide-form-start" value="' .
    551. 

  551. 				'(?P<time>.*?)' .
    552. 

  552. 				'"><input value="' .
    553. 

  553. 				'(?P<offset>.*?)' .
    554. 

  554. 				'" type="hidden" id="tvguide-form-offset">~ism',
    555. 

  555. 				GetPage($programsURL, listingsFolder, $channelSet . "-" . $day . "-" . $hour . ".html", 25000), $programlist);
    556. 

  556.    //echoIfNotSilent($programlist['time'] . "<br />\r\n");
    557. 

  557.    $yesterday = date('Y-m-d', strtotime(date('Y-m-d', $programlist['time'] + ($programlist['offset'] * 60)) . " +" . strval($day - 1) . " days"));
    558. 

  558.    $today = date('Y-m-d', strtotime(date('Y-m-d', $programlist['time'] + ($programlist['offset'] * 60)) . " +" . strval($day) . " days"));
    559. 

  559.    $tomorrow = date('Y-m-d', strtotime(date('Y-m-d', $programlist['time'] + ($programlist['offset'] * 60)) . " +" . strval($day + 1) . " days"));
    560. 

  560.    preg_match_all('~<h3><a href="/tv-guide/channel/' .
    561. 

  561. 				  '(?P<id>.*?)' .
    562. 

  562. 				  '/">' .
    563. 

  563. 				  '(?P<details>.*?)' .
    564. 

  564. 				  '</ul></div>~ism',
    565. 

  565. 				  GetPage($programsURL, listingsFolder, $channelSet . "-" . $day . "-" . $hour . ".html"), $channels, PREG_SET_ORDER);
    566. 

  566.    foreach ($channels as $channel)
    567. 

  567.    {
    568. 

  568.     //echoIfNotSilent($channel['id'] . "<br />\r\n");
    569. 

  569. 	//echoIfNotSilent(strlen($channel['details']) . "<br />\r\n");
    570. 

  570. 	preg_match_all('~<h4 class="title"><a href="/tv-guide/search/' .
    571. 

  571. 				   '.*?' .
    572. 

  572. 				   '/">' .
    573. 

  573. 				   '(?P<title>.*?)' .
    574. 

  574. 				   '</a></h4>' .
    575. 

  575. 				   '.*?' .
    576. 

  576. 				   '<span class="stamp">' .
    577. 

  577. 				   '(?P<start>.*?)' .
    578. 

  578. 				   ' - ' .
    579. 

  579. 				   '(?P<stop>.*?)' .
    580. 

  580. 				   '</span>' .
    581. 

  581. 				   '.*?' .
    582. 

  582. 				   '<dl class="info">' .
    583. 

  583. 				   '(?P<info>.*?)' .
    584. 

  584. 				   '</dl>' .
    585. 

  585. 				   '.*?' .
    586. 

  586. 				   '<p class="abstract">' .
    587. 

  587. 				   '(?P<description>.*?)' .
    588. 

  588. 				   '</p>~ism',
    589. 

  589. 				   $channel['details'], $programs, PREG_SET_ORDER);
    590. 

  590. 	foreach ($programs as $programDetails)
    591. 

  591.     {
    592. 

  592. 	 unset($sqlArray);
    593. 

  593. 	 $sqlArray['channel_id'] = "YH-" . $channelSet . "-" . $channel['id'];
    594. 

  594. 	 $sqlArray['file'] = $sqlArray['channel_id'] . " " . $day . " " . $programDetails[start];
    595. 

  595. 	 //echoIfNotSilent($sqlArray['file'] . "<br />\r\n");
    596. 

  596. 	 $channeldetails = mysql_query("SELECT All_id FROM xmltvChannels WHERE  YH_id = '" . $sqlArray['channel_id'] . "'") or die(mysql_error());
    597. 

  597. 	 $channeldetailsrow = mysql_fetch_assoc($channeldetails);
    598. 

  598. 	 preg_match_all('~<dt>' .
    599. 

  599. 					'(?P<item>.*?)' .
    600. 

  600. 					':</dt>' .
    601. 

  601. 					'.*?' .
    602. 

  602. 					'<dd>' .
    603. 

  603. 					'(?P<content>.*?)' .
    604. 

  604. 					'</dd>~ism',
    605. 

  605. 				    $programDetails[info], $info, PREG_SET_ORDER);
    606. 

  606. 	 foreach ($info as $infoitem) //Classified, Genre
    607. 

  607. 	 {
    608. 

  608. 	  $infoarray[$infoitem[item]] = $infoitem[content];
    609. 

  609. 	 }
    610. 

  610. 	 $sqlArray['title'] = $programDetails['title'];
    611. 

  611. 	 $sqlArray['description'] = $programDetails['description'];
    612. 

  612. 	 $sqlArray['category'] = $infoarray['Genre'];
    613. 

  613. 	 $sqlArray['channel'] = $channeldetailsrow['All_id'];
    614. 

  614. 	 $startday = $today;
    615. 

  615. 	 $stopday = $today;
    616. 

  616. 	 /*
    617. 

  617. 	 if (strtotime($programDetails['stop']) < strtotime($programDetails['start']))
    618. 

  618. 	 {
    619. 

  619. 	  if ($hour <= 12)
    620. 

  620. 	  {
    621. 

  621. 	   $startday = $yesterday;
    622. 

  622. 	  }
    623. 

  623. 	  else
    624. 

  624. 	  {
    625. 

  625. 	   $stopday = $tomorrow;
    626. 

  626. 	  }
    627. 

  627. 	 }
    628. 

  628. 	 elseif (strtotime($programDetails['start']) < strtotime(strval($hour) . ":00:00 am"))
    629. 

  629. 	 {
    630. 

  630. 	  $startday = $tomorrow;
    631. 

  631. 	  $stopday = $tomorrow;
    632. 

  632. 	 }
    633. 

  633. 	 */
    634. 

  634. 	 if ($hour > 12)
    635. 

  635. 	 {
    636. 

  636. 	  if (strtotime($programDetails['start']) < strtotime("12:00:00"))
    637. 

  637. 	  {
    638. 

  638. 	   //echoIfNotSilent("Start: " . strtotime($programDetails['start']) . " < " . strtotime("02:00:00") . "<br />\r\n");
    639. 

  639. 	   $startday = $tomorrow;
    640. 

  640. 	  }
    641. 

  641. 	  if (strtotime($programDetails['stop']) < strtotime("12:00:00"))
    642. 

  642. 	  {
    643. 

  643. 	   //echoIfNotSilent("Stop: " . strtotime($programDetails['stop']) . " < " . strtotime("04:00:00") . "<br />\r\n");
    644. 

  644. 	   $stopday = $tomorrow;
    645. 

  645. 	  }
    646. 

  646. 	 }
    647. 

  647. 	 elseif ($hour < 12)
    648. 

  648. 	 {
    649. 

  649. 	  if (strtotime($programDetails['start']) > strtotime("12:00:00"))
    650. 

  650. 	  {
    651. 

  651. 	   //echoIfNotSilent("Start: " . strtotime($programDetails['start']) . " > " . strtotime("20:00:00") . "<br />\r\n");
    652. 

  652. 	   $startday = $yesterday;
    653. 

  653. 	  }
    654. 

  654. 	  if (strtotime($programDetails['stop']) > strtotime("12:00:00"))
    655. 

  655. 	  {
    656. 

  656. 	   //echoIfNotSilent("Stop: " . strtotime($programDetails['stop']) . " > " . strtotime("22:00:00") . "<br />\r\n");
    657. 

  657. 	   $stopday = $yesterday;
    658. 

  658. 	  }
    659. 

  659. 	 }
    660. 

  660. 	 $sqlArray['start'] = date('Y-m-d H:i:s', strtotime($startday . " " . $programDetails['start']));
    661. 

  661. 	 $sqlArray['stop'] = date('Y-m-d H:i:s', strtotime($stopday . " " . $programDetails['stop']));
    662. 

  662. 	 //echoIfNotSilent($sqlArray['start'] . " - " . $sqlArray['stop'] . "<br />\r\n");
    663. 

  663. 	 $sqlArray['rating'] = $infoarray['Classified'];
    664. 

  664. 	 DBInsert("xmltvSourcePrograms", $sqlArray);
    665. 

  665. 	 if (verboseOutput == 'yes')
    666. 

  666.      {
    667. 

  667.       echoIfNotSilent('Grabbed program ' . $filename . '<br />' . "\n");
    668. 

  668.      }
    669. 

  669. 	}
    670. 

  670.    }
    671. 

  671.   }
    672. 

  672.  }
    673. 

  673. }
    674. 

  674. 

  675. function FreeViewGrabProgramList()
    676. 

  676. {
    677. 

  677.  $result = mysql_query("SELECT FV_id, All_id FROM xmltvChannels WHERE FV_id IS NOT NULL") or die(mysql_error());
    678. 

  678.  while ($row = mysql_fetch_assoc($result))
    679. 

  679.  {
    680. 

  680.   $tvnzArray = explode("-", $row[FV_id]);
    681. 

  681.   if ($tvnzArray[1] <> '' AND $tvnzArray[1] <> NULL)
    682. 

  682.   {
    683. 

  683.    $programsURL = "http://listings.tvnz.co.nz/freeview/" . $tvnzArray[1] . "_7days.xml";
    684. 

  684.    /*if ($tvnzArray[1] == 'tv3plus1')
    685. 

  685.    {
    686. 

  686.     $programsURL = "http://listings.tvnz.co.nz/freeview/tv3_7days.xml";
    687. 

  687.    }*/
    688. 

  688.    $freeviewPage = "";
    689. 

  689.    $freeviewPage = GetPage($programsURL, listingsFolder);
    690. 

  690.    if ($freeviewPage <> "")
    691. 

  691.    {
    692. 

  692.     $pageXML = new SimpleXMLElement($freeviewPage);
    693. 

  693.     foreach ($pageXML->channel->programmes->programme as $program)
    694. 

  694.     {
    695. 

  695.      $filename = CleanString($tvnzArray[1] . ' ' . $program['datetime_start']);
    696. 

  696. 	 $programResult = mysql_query("SELECT file FROM xmltvSourcePrograms WHERE file='" . $filename . "'") or die(mysql_error());
    697. 

  697.      if (mysql_num_rows($programResult) < 1)
    698. 

  698.      {
    699. 

  699.       /*
    700. 

  700. 	  mysql_query("INSERT INTO xmltvSourcePrograms (file,title,description,channel,start,stop,rating,quality,subtitles,url) VALUES('" . $filename . "','" . CleanString($program->title) . "'," . NullQuoteString(CleanString($program->synopsis)) . ",'" . $row[FV_id] . "','" . FreeViewToSQLTime($program['datetime_start']) . "','" . FreeViewToSQLTime($program['datetime_end']) . "'," . NullQuoteString($program['classification']) . ","  . ($program['hd'] == 'Y' ? "'HDTV'" : "NULL") . ","  . ($program['captioned'] == 'Y' ? "'teletext'" : "NULL") . "," . NullQuoteString(trim($program['website'])) . ")"); //or die(mysql_error());
    701. 

  701.       if ($tvnzArray[1] == 'tv3plus1')
    702. 

  702. 	  {
    703. 

  703. 	   mysql_query("UPDATE xmltvSourcePrograms SET start=start + INTERVAL 1 HOUR, stop=stop + INTERVAL 1 HOUR WHERE file='" . $filename . "'") or die(mysql_error());
    704. 

  704. 	  }
    705. 

  705. 	  */
    706. 

  706. 	  $freeViewStartTime = FreeViewToSQLTime($program['datetime_start']);
    707. 

  707. 	  $freeViewEndTime = FreeViewToSQLTime($program['datetime_end']);
    708. 

  708. 	  /*if ($tvnzArray[1] == 'tv3plus1')
    709. 

  709. 	  {
    710. 

  710. 	   $freeViewStartTime = date('Y-m-d H:i:s', strtotime($freeViewStartTime . ' +1 hour'));
    711. 

  711. 	   $freeViewEndTime = date('Y-m-d H:i:s', strtotime($freeViewEndTime . ' +1 hour'));
    712. 

  712. 	  }*/
    713. 

  713. 	  $sqlArray['file'] = $filename;
    714. 

  714. 	  $sqlArray['title'] = $program->title;
    715. 

  715. 	  $sqlArray['description'] = $program->synopsis;
    716. 

  716. 	  $sqlArray['channel_id'] = $row['FV_id'];
    717. 

  717. 	  $sqlArray['channel'] = $row['All_id'];
    718. 

  718. 	  $sqlArray['start'] = $freeViewStartTime;
    719. 

  719. 	  $sqlArray['stop'] = $freeViewEndTime;
    720. 

  720. 	  $sqlArray['rating'] = $program['classification'];
    721. 

  721. 	  $sqlArray['quality'] = ($program['hd'] == 'Y' ? "'HD'":"");
    722. 

  722. 	  $sqlArray['subtitles'] = ($program['captioned'] == 'Y' ? "'teletext'":"");
    723. 

  723. 	  $sqlArray['url'] = $program['website'];
    724. 

  724. 	  DBInsert("xmltvSourcePrograms", $sqlArray);
    725. 

  725. 	  //mysql_query("INSERT INTO xmltvSourcePrograms (file,title,description,channel_id,channel,start,stop,rating,quality,subtitles,url) VALUES('" . $filename . "','" . CleanString($program->title) . "'," . NullQuoteString(CleanString($program->synopsis)) . ",'" . $row['FV_id'] . "','" . $row['All_id'] . "','" . $freeViewStartTime . "','" . $freeViewEndTime . "'," . NullQuoteString($program['classification']) . ","  . ($program['hd'] == 'Y' ? "'HD'" : "NULL") . ","  . ($program['captioned'] == 'Y' ? "'teletext'" : "NULL") . "," . NullQuoteString(trim($program['website'])) . ")"); //or die(mysql_error());
    726. 

  726. 	  //
    727. 

  727. 	  if (verboseOutput == 'yes')
    728. 

  728.       {
    729. 

  729.        echoIfNotSilent('Grabbed program ' . $filename . '<br />' . "\n");
    730. 

  730.       }
    731. 

  731. 	 }
    732. 

  732. 	 else
    733. 

  733. 	 {
    734. 

  734. 	  if (verboseOutput == 'yes')
    735. 

  735.       {
    736. 

  736. 	   echoIfNotSilent('Already grabbed program ' . $filename . '<br />' . "\n");
    737. 

  737. 	  }
    738. 

  738.      }
    739. 

  739. 	}
    740. 

  740.    }
    741. 

  741.   }
    742. 

  742.   echoIfNotSilent('<h2>Grabbed Freeview data for channel ' . $tvnzArray[1] . '</h2>' . "\n");
    743. 

  743.  }
    744. 

  744. }
    745. 

  745. 

  746. function GeekNZGrabProgramList()
    747. 

  747. {
    748. 

  748.  //GetPage('http://epg.pvr.geek.nz/epg/listings-all.xml.gz', listingsFolder);
    749. 

  749.  //$fp = gzopen(listingsFolder . 'listings-all.xml.gz', "r");
    750. 

  750.  $fp = gzopen('http://epg.pvr.geek.nz/epg/listings-all.xml.gz', "r");
    751. 

  751.  $contents = gzread($fp, 100000000);
    752. 

  752.  $pageXML = new SimpleXMLElement($contents);
    753. 

  753.  foreach ($pageXML->programme as $program)
    754. 

  754.  {
    755. 

  755.   $start = substr($program['start'], 0, -6);
    756. 

  756.   $stop = substr($program['stop'], 0, -6);
    757. 

  757.   mysql_query("INSERT INTO xmltvSourcePrograms (file,title,description,channel,channel_id,start,stop,url) VALUES('" . $program['channel'] . "-" . $start . "','" . CleanString($program->title) . "'," . NullQuoteString(CleanString($program->desc)) . ",'" . $channel . "','" . $program['channel'] . "','" . $start . "','" . $stop . "'," . NullQuoteString(trim($program->url)) . ")"); //or die(mysql_error());
    758. 

  758.   if (verboseOutput == 'yes')
    759. 

  759.   {
    760. 

  760.    echoIfNotSilent('Grabbed program ' . $program['channel'] . "-" . $start . '<br />' . "\n");
    761. 

  761.   }
    762. 

  762.  }
    763. 

  763.  $channelNames = mysql_query("SELECT All_id,geeksky_id FROM xmltvChannels WHERE geeksky_id IS NOT NULL"); //or die(mysql_error());
    764. 

  764.  while ($channelName = mysql_fetch_assoc($channelNames))
    765. 

  765.  {
    766. 

  766.   mysql_query("UPDATE xmltvSourcePrograms SET channel='" . $channelName['All_id'] . "' WHERE channel_id='" . $channelName['geeksky_id'] . ".sky.co.nz'"); //or die(mysql_error());
    767. 

  767.  }
    768. 

  768.  $channelNames = mysql_query("SELECT All_id,geekfv_id FROM xmltvChannels WHERE geekfv_id IS NOT NULL"); //or die(mysql_error());
    769. 

  769.  while ($channelName = mysql_fetch_assoc($channelNames))
    770. 

  770.  {
    771. 

  771.   mysql_query("UPDATE xmltvSourcePrograms SET channel='" . $channelName['All_id'] . "' WHERE channel_id='" . $channelName['geekfv_id'] . ".freeviewnz.tv'"); //or die(mysql_error());
    772. 

  772.  }
    773. 

  773. }
    774. 

  774. 

  775. function SatellitePerlGrabProgramList()
    776. 

  776. {
    777. 

  777.  $pageXML = new SimpleXMLElement(GetPage('TVGuide.xml', '/home/administrator/D2XMLTV/'));
    778. 

  778.  foreach ($pageXML->programme as $program)
    779. 

  779.  {
    780. 

  780.   /*if ($current_channel <> $program['channel'])
    781. 

  781.   {
    782. 

  782.    $channelrow = mysql_query("SELECT All_id FROM xmltvChannels WHERE satellite_id='" . $program['channel'] . "'");
    783. 

  783.    $channel_id = mysql_fetch_assoc($channelrow);
    784. 

  784.    $channel = $channel_id['All_id'];
    785. 

  785.   }
    786. 

  786.   $current_channel = $program['channel'];*/
    787. 

  787.   mysql_query("INSERT INTO xmltvSourcePrograms (file,title,description,channel,channel_id,start,stop,url) VALUES('" . $program['channel'] . "-" . $program['start'] . "','" . CleanString($program->title) . "'," . NullQuoteString(CleanString($program->desc)) . ",'" . $channel . "','" . $program['channel'] . "','" . $program['start'] . "','" . $program['stop'] . "'," . NullQuoteString(trim($program->url)) . ")"); //or die(mysql_error());
    788. 

  788.   if (verboseOutput == 'yes')
    789. 

  789.   {
    790. 

  790.    echoIfNotSilent('Grabbed program ' . $program['channel'] . "-" . $program['start'] . '<br />' . "\n");
    791. 

  791.   }
    792. 

  792.  }
    793. 

  793.  $channelNames = mysql_query("SELECT All_id,satellite_id FROM xmltvChannels WHERE satellite_id IS NOT NULL"); //or die(mysql_error());
    794. 

  794.  while ($channelName = mysql_fetch_assoc($channelNames))
    795. 

  795.  {
    796. 

  796.   mysql_query("UPDATE xmltvSourcePrograms SET channel='" . $channelName['All_id'] . "' WHERE channel_id='" . $channelName['satellite_id'] . "'"); //or die(mysql_error());
    797. 

  797.  }
    798. 

  798. }
    799. 

  799. 

  800. function AvenardGrabProgramList()
    801. 

  801. {
    802. 

  802.  //http://www.avenard.org/iptv/tpg-guide.php
    803. 

  803. }
    804. 

  804. 

  805. 

  806. 

  807. 

  808. 

  809. 

  810. 

  811. /* Fixes */
    812. 

  812. 

  813. function FreeViewFixRNZNTimes()
    814. 

  814. {
    815. 

  815.  $rnznresult = mysql_query("SELECT file, start, stop FROM tempSourcePrograms WHERE channel = 'national'"); //or die(mysql_error());
    816. 

  816.  while ($rnznrow = mysql_fetch_assoc($rnznresult))
    817. 

  817.  {
    818. 

  818.   $changedTime = FALSE;
    819. 

  819.   $roundedstart = date('Y-m-d H:i:s', round(strtotime($rnznrow['start']) / (60 * 5)) * 60 * 5);
    820. 

  820.   if ($rnznrow['start'] <> $roundedstart)
    821. 

  821.   {
    822. 

  822.    $rnznrow['start'] = $roundedstart;
    823. 

  823.    $changedTime = TRUE;
    824. 

  824.   }
    825. 

  825.   $roundedstop = date('Y-m-d H:i:s', round(strtotime($rnznrow['stop']) / (60 * 5)) * 60 * 5);
    826. 

  826.   if ($rnznrow['stop'] <> $roundedstop)
    827. 

  827.   {
    828. 

  828.    $rnznrow['stop'] = $roundedstop;
    829. 

  829.    $changedTime = TRUE;
    830. 

  830.   }
    831. 

  831.   if ($changedTime == TRUE)
    832. 

  832.   {
    833. 

  833.    mysql_query("UPDATE tempSourcePrograms SET start = '" . $rnznrow['start'] . "', stop = '" . $rnznrow['stop'] . "' WHERE file = '" . $rnznrow['file'] . "'") or die(mysql_error());
    834. 

  834.    if (verboseOutput == 'yes')
    835. 

  835.    {
    836. 

  836.     echoIfNotSilent('Fixed time for Radio NZ National program ' . $rnznrow['file'] . '<br />' . "\n");
    837. 

  837.    }
    838. 

  838.   }
    839. 

  839.  }
    840. 

  840. }
    841. 

  841. 

  842. function ReplaceTV1BBCWorld()
    843. 

  843. {
    844. 

  844.  $channel = 'tv1';
    845. 

  845.  $idsresult = mysql_query("SELECT TC_id, YH_id, FV_id FROM xmltvChannels WHERE All_id = '" . $channel . "'") or die(mysql_error());
    846. 

  846.  $row = mysql_fetch_assoc($idsresult);
    847. 

  847.  $availableSources = array('TC', 'YH', 'FV');
    848. 

  848.  $bbcSource = "TC-BBCV";
    849. 

  849.  foreach ($availableSources as $source)
    850. 

  850.  {
    851. 

  851.   //$channelnameresult = mysql_query("SELECT id FROM xmltvChannels WHERE " . $source . "_id = '" . $row[$source . '_id'] . "'") or die(mysql_error());
    852. 

  852.   //$channelnamerow = mysql_fetch_assoc($channelnameresult);
    853. 

  853.   //$channelid = $channelnamerow['id'];
    854. 

  854.   $bbcresult = mysql_query("SELECT file, start, stop FROM tempSourcePrograms WHERE channel_id = '" . $row[$source . '_id'] . "' AND title LIKE 'BBC World%'"); //or die(mysql_error());
    855. 

  855.   while ($bbcrow = mysql_fetch_assoc($bbcresult))
    856. 

  856.   {
    857. 

  857.    mysql_query("DELETE FROM tempSourcePrograms WHERE file = '" . $bbcrow[file] . "'") or die(mysql_error());
    858. 

  858.    $programsresult = mysql_query("SELECT * FROM tempSourcePrograms WHERE channel_id = '" . $bbcSource . "' AND stop > '" . $bbcrow[start] . "' AND start < '" . $bbcrow[stop] . "' ORDER BY start") or die(mysql_error());
    859. 

  859.    unset($programArray);
    860. 

  860.    while ($programrow = mysql_fetch_assoc($programsresult))
    861. 

  861.    {
    862. 

  862.     $programArray[] = $programrow;
    863. 

  863.    }
    864. 

  864.    if (count($programArray) >= 1)
    865. 

  865.    {
    866. 

  866.     $programArray[0][start] = $bbcrow[start];
    867. 

  867.     if (count($programArray) >= 2)
    868. 

  868.     {
    869. 

  869.      $programArray[count($programArray) - 1][stop] = $bbcrow[stop];
    870. 

  870.     }
    871. 

  871. 	foreach ($programArray as $program)
    872. 

  872. 	{
    873. 

  873. 	 $program[file] = $row[$source . '_id'] . " " . $program[start];
    874. 

  874. 	 $program[channel] = $row[$source . '_id'];
    875. 

  875. 	 $program = CleanArray($program);
    876. 

  876. 	 mysql_query("INSERT INTO tempSourcePrograms (file,title,description,channel_id,channel,start,stop,category,rating) VALUES('" . $program[file] . "', '" . $program[title] . "', " . NullQuoteString($program[description]) . ", '" . $program[channel] . "', '" . $channel . "', '" . $program[start] . "', '" . $program[stop] . "', " . NullQuoteString($program[category]) . ", " . NullQuoteString($program[rating]) . ")"); //or die(mysql_error());
    877. 

  877. 	 if (verboseOutput == 'yes')
    878. 

  878.      {
    879. 

  879.       echoIfNotSilent('Inserted BBC Program ' . $program[file] . '<br />' . "\n");
    880. 

  880.      }
    881. 

  881. 	}
    882. 

  882.    }
    883. 

  883.   }
    884. 

  884.  }
    885. 

  885. }
    886. 

  886. 

  887. function FixTitles()
    888. 

  888. {
    889. 

  889.  $fixesresult = mysql_query("SELECT * FROM ProgramTitleFixes") or die(mysql_error());
    890. 

  890.  while ($fix = mysql_fetch_assoc($fixesresult))
    891. 

  891.  {
    892. 

  892.   mysql_query("UPDATE tempSourcePrograms SET title=$fix[title] WHERE title REGEXP $fix[regex]") or die(mysql_error());
    893. 

  893.  }
    894. 

  894. }
    895. 

  895. 

  896. function FixProblemChannelTimes()
    897. 

  897. {
    898. 

  898.  //$channelsArray[] = "ctv2";
    899. 

  899.  //$channelsArray[] = "ctv3";
    900. 

  900.  //$channelsArray[] = "discovery";
    901. 

  901.  $channels = mysql_query("SELECT All_id FROM xmltvChannels WHERE fix_times = '1'"); //or die(mysql_error());
    902. 

  902.  while ($channel = mysql_fetch_assoc($channels))
    903. 

  903.  {
    904. 

  904.   FixTimes($channel['All_id']);
    905. 

  905.  }
    906. 

  906. }
    907. 

  907. 

  908. function FixTimes($channel_id)
    909. 

  909. {
    910. 

  910.  $programsresult = mysql_query("SELECT file, start, stop FROM tempSourcePrograms WHERE channel_id = '" . $channel_id . "' ORDER BY start"); //or die(mysql_error());
    911. 

  911.  while ($program = mysql_fetch_assoc($programsresult))
    912. 

  912.  {
    913. 

  913.   $programdata[] = $program;
    914. 

  914.  }
    915. 

  915.  for ($i = 0; $i < count($programdata) - 1; $i++)
    916. 

  916.  {
    917. 

  917.   //if ($programdata[$i]['start'] == date('Y-m-d H:i:s', strtotime($programdata[$i]['stop'] . " -1 minute")) AND $programdata[$i]['stop'] <> $programdata[$i + 1]['start'])
    918. 

  918.   if ($programdata[$i]['stop'] < $programdata[$i + 1]['start'])
    919. 

  919.   {
    920. 

  920.    mysql_query("UPDATE tempSourcePrograms SET stop = '" . $programdata[$i + 1]['start'] . "' WHERE file = '" . $programdata[$i]['file'] . "'") or die(mysql_error());
    921. 

  921.    if (verboseOutput == 'yes')
    922. 

  922.    {
    923. 

  923.     echoIfNotSilent('Fixed time for program ' . $programdata[$i]['file'] . '<br />' . "\n");
    924. 

  924.    }
    925. 

  925.   }
    926. 

  926.   if ($programdata[$i]['stop'] > $programdata[$i + 1]['start']) //If start and stop are one minute apart
    927. 

  927.   {
    928. 

  928.    mysql_query("UPDATE tempSourcePrograms SET stop = '" . $programdata[$i + 1]['start'] . "' WHERE file = '" . $programdata[$i]['file'] . "'") or die(mysql_error());
    929. 

  929.    if (verboseOutput == 'yes')
    930. 

  930.    {
    931. 

  931.     echoIfNotSilent('Fixed time for program ' . $programdata[$i]['file'] . '<br />' . "\n");
    932. 

  932.    }
    933. 

  933.   }
    934. 

  934.  }
    935. 

  935. }
    936. 

  936. 

  937. function FixBadCharacters($text)
    938. 

  938. {
    939. 

  939.  /*
    940. 

  940.  $characters['“'] = '"'; // left side double smart quote
    941. 

  941.  $characters['”'] = '"'; // right side double smart quote
    942. 

  942.  $characters['‘'] = "'"; // left side single smart quote
    943. 

  943.  $characters['’'] = "'"; // right side single smart quote
    944. 

  944.  $characters['…'] = "..."; // elipsis
    945. 

  945.  $characters['—'] = "-"; // em dash
    946. 

  946.  $characters['–'] = "-"; // en dash
    947. 

  947.  */
    948. 

  948.  $find = array('‘', '’', '“', '”', '…', '—', '–');
    949. 

  949.  //$find2 = array('‘', '’', '“', '”', '…', '—', '–');
    950. 

  950.  //$find3 = array('‘', '’', '“', '”', '…', '—', '–');
    951. 

  951.  $find2 = array("\\xe2\\x80\\x98", "\\xe2\\x80\\x99", "\\xe2\\x80\\x9c", "\\xe2\\x80\\x9d", "\\xe2\\x80\\xa6", "\\xe2\\x80\\x94", "\\xe2\\x80\\x93");
    952. 

  952.  //é = e acute
    953. 

  953.  $replace = array("'", "'", '"', '"', "...", "-", "-");
    954. 

  954.  return str_replace($find, $replace, str_replace($find2, $replace, $text));
    955. 

  955.  //return str_replace($find, $replace, str_replace($find2, $replace, str_replace($find3, $replace, $text)));
    956. 

  956. }
    957. 

  957. 

  958. function FixDBBadCharacters()
    959. 

  959. {
    960. 

  960.  /*
    961. 

  961.  $characters['â€Â'] = "â€";
    962. 

  962.  $characters['“'] = '"'; // left side double smart quote
    963. 

  963.  $characters['”'] = '"'; // right side double smart quote
    964. 

  964.  $characters['‘'] = "'"; // left side single smart quote
    965. 

  965.  $characters['’'] = "'"; // right side single smart quote
    966. 

  966.  $characters['…'] = "..."; // elipsis
    967. 

  967.  $characters['—'] = "-"; // em dash
    968. 

  968.  $characters['–'] = "-"; // en dash
    969. 

  969.  */
    970. 

  970.  /*
    971. 

  971.  $characters['’'] = "'";
    972. 

  972.  $characters['‘'] = "'";
    973. 

  973.  $characters['“'] = '"';
    974. 

  974.  $characters['”'] = '"';
    975. 

  975.  $characters['…'] = "...";
    976. 

  976.  $characters['–'] = "-";
    977. 

  977.  $characters['—'] = "-";
    978. 

  978.  print_r($characters);
    979. 

  979.  unset($characters);
    980. 

  980.  */
    981. 

  981.  
    982. 

  982.  $characters[] = '‘';
    983. 

  983.  $characters[] = '’';
    984. 

  984.  $characters[] = '“';
    985. 

  985.  $characters[] = '”';
    986. 

  986.  $characters[] = '…';
    987. 

  987.  $characters[] = '—';
    988. 

  988.  $characters[] = '–';
    989. 

  989.  foreach (array("title", "description") as $field)
    990. 

  990.  {
    991. 

  991.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '‘', '\'') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    992. 

  992.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '’', '\'') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    993. 

  993.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '“', '\"') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    994. 

  994.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '”', '\"') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    995. 

  995.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '…', '...') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    996. 

  996.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '—', '-') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    997. 

  997.   mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '–', '-') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    998. 

  998.  
    999. 

  999.   foreach ($characters as $find => $replace)
    1000. 

  1000.   {
    1001. 

  1001.    //echo "123";
    1002. 

  1002.    //mysql_query("UPDATE tempSourcePrograms SET " . $field . "=REPLACE(" . $field . ", '" . $find . "', '" . $replace . "') WHERE " . $field . " LIKE '%€%'") or die(mysql_error());
    1003. 

  1003.   }
    1004. 

  1004.  }
    1005. 

  1005. }
    1006. 

  1006. 

  1007. function RemoveGenericTitles()
    1008. 

  1008. {
    1009. 

  1009.  $channels = mysql_query("SELECT All_id, remove_generic FROM xmltvChannels WHERE remove_generic IS NOT NULL"); //or die(mysql_error());
    1010. 

  1010.  while ($channel = mysql_fetch_assoc($channels))
    1011. 

  1011.  {
    1012. 

  1012.   RemoveProgram($channel['All_id'], $channel['remove_generic']);
    1013. 

  1013.  }
    1014. 

  1014. }
    1015. 

  1015. 

  1016. function RemoveProgram($channel, $title)
    1017. 

  1017. {
    1018. 

  1018.  $deleteresult = mysql_query("DELETE FROM tempSourcePrograms WHERE channel = '" . $channel . "' AND title='" . $title . "'") or die(mysql_error());
    1019. 

  1019.  if (verboseOutput == 'yes')
    1020. 

  1020.  {
    1021. 

  1021.   echoIfNotSilent($deleteresult . '<br />' . "\n");
    1022. 

  1022.  }
    1023. 

  1023. 

  1024. }
    1025. 

  1025. 

  1026. function CleanNullValues()
    1027. 

  1027. {
    1028. 

  1028.  $replacearray[] = "For details please refer to www.wtv.co.nz";
    1029. 

  1029.  $replacearray[] = "No Description Available";
    1030. 

  1030.  $replacearray[] = "C42 plays back-to-back alternative music 24-hours a day.";
    1031. 

  1031.  $replacearray[] = "CCTV International offers a Chinese perspective on international and national events. Available globally, presenting News with in-depth reports, expert analysis and features.";
    1032. 

  1032.  $replacearray[] = "Direct feed from CCTV4";
    1033. 

  1033.  $replacearray[] = "Direct feed from MBC";
    1034. 

  1034.  $replacearray[] = "Direct feed from NHK";
    1035. 

  1035.  $replacearray[] = "For all the latest sports news from New Zealand and around the world, catch Sport 365 Headlines.";
    1036. 

  1036.  $replacearray[] = "Programme to be determined.";
    1037. 

  1037.  $replacearray[] = "STAR PLUS the flagship channel of the STAR network is the undisputed king of Hindi general entertainment in India. Over 65 million viewers tune-in to India's No 1 channel. More info www.startv.com";
    1038. 

  1038.  $replacearray[] = "Phone the studio on 09 360 4444 or email the dj studio@georgefm.co.nz   Visit www.georgefm.co.nz for show schedules.";
    1039. 

  1039.  $replacearray[] = "100% New Zealand Music";
    1040. 

  1040.  $replacearray[] = "TBN is the world's largest religious network and America's most watched faith channel. TBN offers 24 hours of commercial-free inspirational programming that appeal to people in a wide variety of Protestant, Catholic and Messianic Jewish denominations.";
    1041. 

  1041.  $replacearray[] = "Direct feed from MBC";
    1042. 

  1042.  $replacearray[] = "Wild TV ceased broadcast on July 1st.  We apologise for any inconvenience.";
    1043. 

  1043.  $replacearray[] = "For full programme schedules visit: http://www.dw-world.de/";
    1044. 

  1044.  $replacearray[] = "What's happening with the weather in your neck of the woods?  We bring you the latest in weather information with regular updates from Metservice.";
    1045. 

  1045.  $replacearray[] = "Your tourism guide to Canterbury. 24 hours a day, 7 days a week.";
    1046. 

  1046.  //Remove all descriptions where
    1047. 

  1047.  foreach ($replacearray as $replace)
    1048. 

  1048.  {
    1049. 

  1049.   mysql_query("UPDATE tempSourcePrograms SET description=NULL WHERE description= '" . mysql_real_escape_string($replace) . "'") or die(mysql_error());
    1050. 

  1050.  }
    1051. 

  1051.  mysql_query("UPDATE tempSourcePrograms SET description=NULL WHERE title = 'Song listings on skytv.co.nz'") or die(mysql_error());
    1052. 

  1052.  mysql_query("UPDATE tempSourcePrograms SET category=NULL WHERE category = 'undefined, default value'") or die(mysql_error());
    1053. 

  1053.  mysql_query("UPDATE tempSourcePrograms SET category='Special Interest' WHERE category = 'Special Interest   '") or die(mysql_error());
    1054. 

  1054. }
    1055. 

  1055. 

  1056. function FixEmptyTVNZSportExtra()
    1057. 

  1057. {
    1058. 

  1058.  $sportresult = mysql_query("SELECT * FROM tempSourcePrograms WHERE channel = 'FV-tvnzsportextra'"); //or die(mysql_error());
    1059. 

  1059.  if (mysql_num_rows($sportresult) < 1)
    1060. 

  1060.  {
    1061. 

  1061. 

  1062.  }
    1063. 

  1063. }
    1064. 

  1064. 

  1065. function FixTitleSuffixes()
    1066. 

  1066. {
    1067. 

  1067.  foreach (Array("The", "A") as $prefix)
    1068. 

  1068.  {
    1069. 

  1069.   $sqlQuery = "UPDATE tempSourcePrograms SET title=TRIM(CONCAT('" . $prefix . " ', SUBSTR(title, 0, " . strval(0 - (strlen($prefix) + 2)) . "))) WHERE title LIKE '%, " . $prefix . "'";
    1070. 

  1070.   //echoIfNotSilent($sqlQuery . "<br />\r\n");
    1071. 

  1071.   mysql_query($sqlQuery) or die(mysql_error());
    1072. 

  1072.  }
    1073. 

  1073. }
    1074. 

  1074. 

  1075. function FixMoviePrefixes()
    1076. 

  1076. {
    1077. 

  1077.  foreach (Array("Popcorn Sessions:", "MTV Movie:", "World Cinema:", "Short Film:", "British Theatre:", "Classic Film:", "Real View:", "MOVIE:", "Rialto Premiere:") as $prefix)
    1078. 

  1078.  {
    1079. 

  1079.   $sqlQuery = "UPDATE tempSourcePrograms SET title=TRIM(SUBSTR(title, " .  strval(strlen($prefix) + 1) . ")), category='Movies' WHERE title LIKE '" . mysql_real_escape_string($prefix) . "%'";
    1080. 

  1080.   //echoIfNotSilent($sqlQuery . "<br />\r\n");
    1081. 

  1081.   mysql_query($sqlQuery) or die(mysql_error());
    1082. 

  1082.  }
    1083. 

  1083. }
    1084. 

  1084. 

  1085. function GetProgramMetadataRepeated()
    1086. 

  1086. {
    1087. 

  1087.  $metadataSuffix[0]['searchValue'] = " HD";
    1088. 

  1088.  $metadataSuffix[0]['metadataField'] = "quality";
    1089. 

  1089.  $metadataSuffix[0]['metadataValue'] = "HD";
    1090. 

  1090. 

  1091.  $metadataSuffix[1]['searchValue'] = " (WS)";
    1092. 

  1092.  $metadataSuffix[1]['metadataField'] = "aspect";
    1093. 

  1093.  $metadataSuffix[1]['metadataValue'] = "16:9";
    1094. 

  1094. 

  1095.  foreach (Array("title", "description") as $sourceField)
    1096. 

  1096.  {
    1097. 

  1097.   foreach ($metadataSuffix as $dataset)
    1098. 

  1098.   {
    1099. 

  1099.    foreach (Array("", ".") as $valueEnd)
    1100. 

  1100.    {
    1101. 

  1101.     mysql_query("UPDATE tempSourcePrograms SET " . $dataset['metadataField'] . "='" . $dataset['metadataValue'] . "' WHERE " . $sourceField . " LIKE '%" . $dataset['searchValue'] . $valueEnd . "' AND " . $dataset['metadataField'] . " IS NULL") or die(mysql_error());
    1102. 

  1102.     mysql_query("UPDATE tempSourcePrograms SET " . $sourceField . "=TRIM(LEFT(" . $sourceField . ", LENGTH(" . $sourceField . ") " . strval(0 - strlen($dataset['searchValue'])) . ")) WHERE " . $sourceField . " LIKE '%" . $dataset['searchValue'] . $valueEnd . "'") or die(mysql_error());
    1103. 

  1103.    }
    1104. 

  1104.   }
    1105. 

  1105.  }
    1106. 

  1106.  $metadataPrefix[0]['searchValue'] = "All New ";
    1107. 

  1107.  $metadataPrefix[0]['metadataField'] = "premiere";
    1108. 

  1108.  $metadataPrefix[0]['metadataValue'] = "1";
    1109. 

  1109.  foreach ($metadataPrefix as $dataset)
    1110. 

  1110.  {
    1111. 

  1111.   foreach (Array("", ".") as $valueEnd)
    1112. 

  1112.   {
    1113. 

  1113.    mysql_query("UPDATE tempSourcePrograms SET " . $dataset['metadataField'] . "='" . $dataset['metadataValue'] . "' WHERE " . $sourceField . " LIKE '" . $dataset['searchValue'] . $valueEnd . "%' AND " . $dataset['metadataField'] . " IS NULL") or die(mysql_error());
    1114. 

  1114.    mysql_query("UPDATE tempSourcePrograms SET " . $sourceField . "=TRIM(RIGHT(" . $sourceField . ", LENGTH(" . $sourceField . ") " . strval(0 - strlen($dataset['searchValue'])) . ")) WHERE " . $sourceField . " LIKE '" . $dataset['searchValue'] . $valueEnd . "%'") or die(mysql_error());
    1115. 

  1115.   }
    1116. 

  1116.  }
    1117. 

  1117.  $sqlQuery = "UPDATE tempSourcePrograms SET year=RIGHT(description, 4), description=TRIM(LEFT(description, LENGTH(description) - 4)) WHERE description RLIKE '(19|20)[0-9]{2}$'";
    1118. 

  1118.  //echoIfNotSilent($sqlQuery . "<br />\r\n");
    1119. 

  1119.  mysql_query($sqlQuery) or die(mysql_error());
    1120. 

  1120.  foreach (Array(".", "") as $yearend)
    1121. 

  1121.  {
    1122. 

  1122.   $sqlQuery = "UPDATE tempSourcePrograms SET year=CONVERT(SUBSTRING(description, LENGTH(description) " . strval(0 - strlen("1948)" . $yearend) + 2) . ", 4), UNSIGNED INTEGER), description=TRIM(LEFT(description, LENGTH(description) " . strval(0 - strlen("(1984)" . $yearend)) . ")) WHERE description RLIKE '(19|20)[0-9]{2}" . $yearend . "$'";
    1123. 

  1123.   //echoIfNotSilent($sqlQuery . "<br />\r\n");
    1124. 

  1124.   mysql_query($sqlQuery) or die(mysql_error());
    1125. 

  1125.  }
    1126. 

  1126. 

  1127.  foreach (Array("Starring:", "Starring ", "Stars:") as $starringtext)
    1128. 

  1128.  {
    1129. 

  1129.   $programs = mysql_query("SELECT file, description FROM tempSourcePrograms WHERE description RLIKE '" . $starringtext . "[[:alpha:][.space.][.comma.][.hyphen.][.apostrophe.]]+[[.period.]]{0,1}$'") or die(mysql_error());
    1130. 

  1130.   while ($program = mysql_fetch_assoc($programs))
    1131. 

  1131.   {
    1132. 

  1132.    preg_match("~" . $starringtext . "(?P<actors>[a-zA-Z ,\-\']+\.{0,1})$~ism", $program['description'], $result);
    1133. 

  1133.    if (!is_null($result))
    1134. 

  1134.    {
    1135. 

  1135. 	$sqlQuery = "UPDATE tempSourcePrograms SET actors='" . mysql_real_escape_string(trim(rtrim(str_replace(", ", ",", $result['actors']), "."))) . "', description=TRIM(LEFT(description, LENGTH(description) " . strval(0 - strlen($starringtext . $result['actors'] . ".")) . ")) WHERE file='" . mysql_real_escape_string($program['file']) . "'";
    1136. 

  1136. 	//echoIfNotSilent($sqlQuery . "<br />\r\n");
    1137. 

  1137.     mysql_query($sqlQuery) or die(mysql_error());
    1138. 

  1138.    }
    1139. 

  1139.   }
    1140. 

  1140.  }
    1141. 

  1141.  foreach (Array("Director:", "Dir:", "Directed by ") as $directortext)
    1142. 

  1142.  {
    1143. 

  1143.   $programs = mysql_query("SELECT file, description FROM tempSourcePrograms WHERE description RLIKE '" . $directortext . "[[:alpha:][.space.][.comma.][.hyphen.][.apostrophe.]]+[[.period.]]{0,1}$'") or die(mysql_error());
    1144. 

  1144.   while ($program = mysql_fetch_assoc($programs))
    1145. 

  1145.   {
    1146. 

  1146.    preg_match("~" . $directortext . "(?P<directors>[a-zA-Z ,\-\']+\.{0,1})$~ism", $program['description'], $result);
    1147. 

  1147.    if (!is_null($result))
    1148. 

  1148.    {
    1149. 

  1149.     $sqlQuery = "UPDATE tempSourcePrograms SET directors='" . mysql_real_escape_string(trim(rtrim(str_replace(", ", ",", $result['directors']), "."))) . "', description=TRIM(LEFT(description, LENGTH(description) " . strval(0 - strlen($directortext . $result['directors'] . ".")) . ")) WHERE file='" . mysql_real_escape_string($program['file']) . "'";
    1150. 

  1150.     //echoIfNotSilent($sqlQuery . "<br />\r\n");
    1151. 

  1151.     mysql_query($sqlQuery) or die(mysql_error());
    1152. 

  1152.    }
    1153. 

  1153.   }
    1154. 

  1154.  }
    1155. 

  1155. 

  1156.  //Description starting with:
    1157. 

  1157.  //FV  - 'Jack's Back'.
    1158. 

  1158.  //mgm on YH - 2001: or 2001. for films
    1159. 

  1159.  //Drama: for YH films
    1160. 

  1160.  //Part x:
    1161. 

  1161.  //Pt x.
    1162. 

  1162.  //Pt 3 of 3. Time:
    1163. 

  1163. 

  1164.  //Description ending with:
    1165. 

  1165.  // Starring: Julia Roberts. (WS). HD.
    1166. 

  1166.  // (2007)
    1167. 

  1167.  // Starring: Sean Connery, Michelle Pfeiffer.
    1168. 

  1168.  // Starring: Julia Roberts.
    1169. 

  1169. 

  1170.  //Thriller: 1988: A jaded New Yorker thinks she has found tranquility in a suburban Arizona town but starts to suspect her husband may be a vicious serial killer as he tries to prove his innocence. Starring: David Keith, Cathy Moriarty
    1171. 

  1171. }
    1172. 

  1172. 

  1173. function GetProgramMetadata()
    1174. 

  1174. {
    1175. 

  1175.  $advertArray = Array("Infomercials", "Infomercials.", "Infomercials for your shop at home pleasure.");
    1176. 

  1176.  mysql_query("UPDATE tempSourcePrograms SET category='Shopping', description=NULL WHERE " . sqlOR($advertArray, "description")) or die(mysql_error());
    1177. 

  1177.  $advertArray = Array("Infomercials", "Home Shopping", "Infomercial 2003");
    1178. 

  1178.  mysql_query("UPDATE tempSourcePrograms SET category='Shopping', description=NULL WHERE " . sqlOR($advertArray, "title")) or die(mysql_error());
    1179. 

  1179.  foreach (Array(":", ".", " ") as $subtitleend)
    1180. 

  1180.  {
    1181. 

  1181.   $programs = mysql_query("SELECT file, description FROM tempSourcePrograms WHERE description LIKE '\'%\'" . $subtitleend . "%' AND sub_title IS NULL") or die(mysql_error());
    1182. 

  1182.   while ($program = mysql_fetch_assoc($programs))
    1183. 

  1183.   {
    1184. 

  1184.    preg_match("~^'(?P<subtitle>.*?)'" . $subtitleend . "~ism", $program['description'], $result);
    1185. 

  1185.    if (!is_null($result))
    1186. 

  1186.    {
    1187. 

  1187.     mysql_query("UPDATE tempSourcePrograms SET sub_title='" . mysql_real_escape_string(trim($result['subtitle'])) . "', descr…
    1188.

Large files files are truncated, but you can click here to view the full file