Ticket #1574: handler.php

<?php
/**
 * View MythVideo files
 *
 * @url         $URL$
 * @date        $Date: 2006-01-25 21:45:37 -0500 (Wed, 25 Jan 2006) $
 * @version     $Revision: 8727 $
 * @author      $Author: xris $
 *
 * @package     MythWeb
 * @subpackage  Video
 *
/**/

/**
 * This points to the local filesystem path where MythVideo has been told to
 * look for videos.
 *
 * @global  string   $GLOBALS['mythvideo_dir']
 * @name    $mythvideo_dir
/**/
    global $mythvideo_dir;
    $mythvideo_dir = $db->query_col('SELECT data
                                       FROM settings
                                      WHERE value="VideoStartupDir" AND hostname=?',
                                    hostname
                                    );

// Make sure the video directory exists
    if (file_exists('data/video')) {
    // File is not a directory or a symlink
        if (!is_dir('data/video') && !is_link('data/video')) {
            $Error = 'An invalid file exists at data/video.  Please remove it in'
                    .' order to use the video portions of MythWeb.';
            require_once 'templates/_error.php';
        }
    }
// Create the symlink, if possible.
//
// NOTE:  Errors have been disabled because if I turn them on, people hosting
//        MythWeb on Windows machines will have issues.  I will turn the errors
//        back on when I find a clean way to do so.
//
    else {
        if ($mythvideo_dir) {
            $ret = @symlink($mythvideo_dir, 'data/video');
            if (!$ret) {
                #$Error = "Could not create a symlink to $mythvideo_dir, the local MythVideo"
                #        .' directory for this hostname ('.hostname.').  Please create a
                #        .' symlink to your MythVideo directory at data/video in order to
                #        .' use the video portions of MythWeb.';
                #require_once 'templates/_error.php';
            }
        }
        else {
            #$Error = 'Could not find a value in the database for the MythVideo directory'
            #        .' for this hostname ('.hostname.').  Please create a symlink to your'
            #        .' MythVideo directory at data/video in order to use the video'
            #        .' portions of MythWeb.';
            #require_once 'templates/_error.php';
        }
    }

// Editing?
    if ($Path[1] == 'edit') {
        require_once 'modules/video/edit.php';
        exit;
    }

// Load the sorting routines
    require_once "includes/sorting.php";

// Queries for a specific program title
    isset($_GET['title']) or $_GET['title'] = $_POST['title'];

// Get the video categories on the system
    $Category_String = array();
    $Total_Categories = 0;
    $sh = $db->query('SELECT * FROM videocategory');
    while ($row = $sh->fetch_assoc()) {
        $Category_String[$row['intid']] = $row['category'];
        $Total_Categories++;
    }
    $sh->finish();
    $Category_String[0] = 'Uncategorized';

// ADDED 
// Get the video genres on the system
    $Genre_String = array();
    $Total_Genres = 0;
    $sh = $db->query('SELECT * FROM videogenre');
    while ($row = $sh->fetch_assoc()) {
        $Genre_String[$row['intid']] = $row['genre'];
        $Total_Genres++;
    }
    $sh->finish();
    $Genre_String[0] = 'No Genre';

// Parse the list
// Filter_Category of -1 means All, 0 mean uncategorized
    $Total_Programs = 0;
    $All_Shows      = array();
    if( isset($_GET['category']) ) {
        $Filter_Category = $_GET['category'];
        if( $Filter_Category != -1)
           $where = ' AND category='.$db->escape($Filter_Category);
    } else {
        $Filter_Category = -1;
    }
    
    if( isset($_GET['genre']) ) {
        $Filter_Genre = $_GET['genre'];
        if( $Filter_Genre != -1)
            $where .= ' AND idgenre='.$db->escape($Filter_Genre);
    }
    else {
        $Filter_Genre = -1;
    }
    
    if( isset($_GET['browse']) ) {
        $Filter_Browse = $_GET['browse'];
        if( $Filter_Browse != -1)
            $where .= ' AND browse='.$db->escape($Filter_Browse);
    }
    else {      
        $Filter_Browse = -1;
    }
    
    if( isset($_GET['search']) ) {
        $Filter_Search = $_GET['search'];
        if( strlen($Filter_Search) != 0)
            $where .= ' AND title LIKE '.$db->escape("%".$Filter_Search."%");
    }
    else {      
        $Filter_Search = "";
    }
    
    if ($where) { $where = 'WHERE '.substr($where, 4); }
   
    #$sh = $db->query('SELECT * FROM videometadata ' . $where . ' ORDER BY title');
    $sql = 'SELECT * FROM videometadata LEFT JOIN videometadatagenre ON videometadata.intid=videometadatagenre.idvideo ' . $where . ' GROUP BY intid ORDER BY title';
    $sh = $db->query($sql);

    while ($row = $sh->fetch_assoc()) {
    // Create a new show object
        $All_Shows[] = new Video($row);
    }
    $sh->finish();

// Set sorting
    if (!is_array($_SESSION['video_sortby']))
        $_SESSION['video_sortby'] = array(array('field'   => 'title',
                                                'reverse' => false));

// Sort the programs
    if (count($All_Shows))
        sort_programs($All_Shows, 'video_sortby');

// Load the class for this page
    require_once theme_dir.'video/video.php';

// Exit
    exit;



class Video {

    var $intid;
    var $plot;
    var $category;
    var $rating;    // this should be a reference to the $Channel array value

    var $title;
    var $director;
    var $inetref;
    var $year;
    var $userrating;
    var $length;            // css class, based on category and/or category_type
    var $showlevel;
    var $filename;
    var $coverfile;
    var $childid;
    var $url;

    function Video($program_data) {
        global $mythvideo_dir;
        $this->intid      = $program_data['intid'];
        $this->plot       = $program_data['plot'];
        $this->category   = $program_data['category'];
        $this->rating     = $program_data['rating'];
        $this->title      = $program_data['title'];
        $this->director   = $program_data['director'];
        $this->inetref    = $program_data['inetref'];
        $this->year       = $program_data['year']       ? $program_data['year']       : 'Unknown';
        $this->userrating = $program_data['userrating'] ? $program_data['userrating'] : 'Unknown';
        $this->length     = $program_data['length'];
        $this->showlevel  = $program_data['showlevel'];
        $this->filename   = $program_data['filename'];
        $this->coverfile  = $program_data['coverfile'];
        $this->childid    = $program_data['childid'];
    // Figure out the URL
        $this->url = '#';
        if (file_exists('data/video/')) {
            $this->url = root . implode('/', array_map('rawurlencode',
                                             array_map('utf8tolocal',
                                             explode('/',
                                             'data/video/' . preg_replace('#^'.$mythvideo_dir.'/?#', '', $this->filename)
                                       ))));
        }
    }
}