Pro VOD And Drupal Intergration

If there was a way to search the VOD database with wildcards, it would be a help. Currently, you can't 'List all' vod files on the web site, but it can be generated under Digital File Management in the Autopilot - but with close to 1000 vods online, we're hitting a wall in easily searching out content.

The web service has an Advanced Show search function. This function has a switch you can set to only return VOD shows. Using this you could search among shows that are VOD with the Advanced Show Search function, or you could retrieve a list of all shows that are VOD and perform more complicated searches among the data set.

-ray

What I would like to See is a PHP file that can go and Grab the data we need. One for each government that we tape. A Static Search page where the End User would not have to input anything lust click on the hyper link for the government they want and all the shows for that government are listed

Hey Nathan...

I just posted this code for another topic, but figured it would work for what you want as well. It requires the nusoap php library.

http://sourceforge.net/projects/nusoap/

Create a category for each specific government that you have and then embed that category number in the code where it says YOURCATEGORYID. Of course put your server in the top where it says YOURSERVERADDRESS

Then it will print a simple html table with all the VOD shows in that category with 'watch now' links.

Its pretty simple, but could be expanded on.

Let me know if you have any questions...

<?php require_once('nusoap.php'); //SOAP function library

$client = new nusoap_client("YOURSERVERADDRESS/CablecastWS/CablecastWS.asmx?WSDL", 'wsdl'); // Creates New SOAP client using WSDL file

$searchDate = date("Y-m-d")."T12:00:00";

// Search for all shows that have an event date less than now that are available for VOD
$result = $client?>call('AdvancedShowSearch', array(
'ChannelID' => 1,
'searchString' => '',
'eventDate' => $searchDate,
'dateComparator' => '<',
'restrictToCategoryID' => YOURCATEGORYID, //This would be the category ID
'restrictToProducerID' => 0,
'restrictToProjectID' => 0,
'displayStreamingShowsOnly' => 1,
'searchOtherSites' => 0,), '', '', false, true);

$resultNumber = count($result['AdvancedShowSearchResult']['SiteSearchResult']['Shows']['ShowInfo']); // of shows for loop
$count = 0; // Set count varaible

if($resultNumber == '0')
{
//There is probably something wrong if this shows up.
echo "There are now Shows currently available for on demand viewing.";
}
// Prints out a table with time and show title with link to show detial page
if($resultNumber >= '1')
{ echo "<table border="0" width="100%"><tr>\n
<th>Program Title</th><th>Link</th></tr>\n";
while ($count <= ($resultNumber -1))
{

echo "<tr><td>".$result['AdvancedShowSearchResult']['SiteSearchResult']['Shows']['ShowInfo'][$count]['Title']."</td><td><a href='".$result['AdvancedShowSearchResult']['SiteSearchResult']['Shows']['ShowInfo'][$count]['StreamingFileURL']."'>Watch Now</td></tr>\n";

$count++;
}
echo "</table>";
}

?>

-ray

hey nathan,

I am on an iPhone, but following that link I just see the php code. Are you sure your server has php installed?

When I get back to the office I will investigate further and email you the code.

-ray

Ray
We have the php code up and working. This is what we needed and you deliverd. Thanks Ray

Glad its working for you Nathan.

I'm trying to figure out where I'm going to post the PHP scripts I have so that everyone can use them, but once I do.. Check for any updates.

Let me know if you have any other issues / questions.

-ray

Ray

This script has been working great and stable. Is there a way to generate a XML Playlist from this.

XML playlist hmmm....

Are you trying to generate a play list for a embeddable flash player?

Anything is possible really.

-ray

I would like to use the playlist with JW Player. I currently have the script you made at http://www.watchictv.net/?q=node/951 but when you click on a video it opens media player in a new window. I would like to use JW wmv Player with pre mid and post role ads. I have the ad system working with other xml playlists butwould like to create a playlist from the vod server.