#!/usr/bin/php
<?php

/*
 * Author: Robert Dege
 * Date  : 2003-11-22
 * Function:
 * The purpose of this script is to extrapolate xmltv data that mythtv
 * dumps into it's database (via mythfilldatabase), and reformat it
 * so that tvtime can use it.
 *
 * This serves 2 purposes:
 *   1) Prevents additional download time so that both programs can
 *	provide TV listings
 *   2) Lowers the hit count on zap2it.com
 *
 * Since mythfilldatabase only retains certain data from the xmltv grab,
 * the following fields were omitted from tvtime's xmltv grab:
 *
 * rating (and sub fields), second category field, language, and episode-num
 *
 */


// Global Variables
$db_host = 'localhost';
$db_username='mythtv';
$db_password='mythtv';
$cur_date= date(YmdHis);
$cur_timezone= date(T);


// Setup connection to MythTV DB
$connection = mysql_connect($db_host, $db_username, $db_password)
		or die("Cannot establish a connection with the Database server");
mysql_select_db("mythconverg", $connection);

$channel = mysql_query("SELECT chanid,name,channum,icon FROM channel", $connection)
		or die("unable to run select query");
$program = mysql_query("SELECT chanid,starttime,endtime,title,subtitle,description,category,airdate,stars,previouslyshown FROM program", $connection);


// File Header
echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<!DOCTYPE tv SYSTEM \"xmltv.dtd\">\n";
echo "<tv date=\"$cur_date\" source-info-url=\"http://www.zap2it.com\" source-info-name=\"Zap2It\" generator-info-name=\"$argv[0]\" generator-info-url=\"http://sourceforge.net/projects/xmltv\">\n";


// Process Channel Information
while ($chnl = mysql_fetch_row($channel))
{
   echo "  <channel id=\"$chnl[0]\">\n";
   echo "    <display-name>$chnl[1]</display-name>\n";
   echo "    <display-name>$chnl[2]</display-name>\n";
   
   if ($chnl[3] != NULL) echo "    <icon src=\"$chnl[3]\" />\n";
   
   echo "  </channel>\n";
}


// Process Program information
while ($prgm = mysql_fetch_row($program))
{
   echo "  <programme start=\"$prgm[1] $cur_timezone\" stop=\"$prgm[2] $cur_timezone\" channel=\"$prgm[0]\">\n";
   echo "      <title>", htmlspecialchars($prgm[3]), "</title>\n";

   if ($prgm[4] != NULL) echo "      <sub-title>", htmlspecialchars($prgm[4]), "</sub-title>\n";

   echo "      <desc>", htmlspecialchars($prgm[5]), "</desc>\n";

   if ($prgm[7] != NULL) echo "      <date>$prgm[7]</date>\n";

   echo "      <category>$prgm[6]</category>\n";
   echo "      <audio>\n        <stereo>stereo</stereo>\n      </audio>\n";

   if ($prgm[8] != 0) {
     $star = $prgm[8] * 4;
     echo "      <star-rating>\n        <value>$star/4</value>\n      </star-rating>\n";
   }

   if ($prgm[9]==1) echo "      <previously-shown />\n";

   echo "  </programme>\n";
}


// File Footer
echo "</tv>\n";