public function getTime()
{
return Utilities::convertToHMS($this->getTimestamp());
}
public function getSearchResults($query)
{
$search_results = array();
if (!empty($query)) {
$search_query = $this->_connection->prepare("SELECT `Episode`, `Timestamp`, `Value` FROM `timestamps` WHERE REPLACE(`Value`, :Replace, '') LIKE :Value");
$search_query->bindValue(":Replace", "'");
$search_query->bindValue(":Value", "%" . str_replace("'", "", trim($query) . "%"));
$search_query->execute();
foreach ($search_query->fetchAll() as $result) {
$timestamp_data = array();
$timestamp_data["Timestamp"] = $result["Timestamp"];
$timestamp_data["Value"] = $result["Value"];
$timestamp_data["HMS"] = Utilities::convertToHMS($result["Timestamp"]);
$search_results[$result["Episode"]][] = $timestamp_data;
}
} else {
$search_query = $this->_connection->prepare("SELECT * FROM `episodes`");
$search_query->execute();
foreach ($search_query->fetchAll() as $result) {
$search_results[] = $result["Identifier"];
}
}
return $search_results;
}
public function getRecentYouTubeVideos()
{
if ($this->getYouTube() != "") {
$youtube_results = @file_get_contents("https://gdata.youtube.com/feeds/users/" . $this->getYouTube() . "/uploads?alt=json&max-results=6");
if ($youtube_results === false) {
return array();
} else {
$youtube_json = json_decode($youtube_results, true);
if (isset($youtube_json["feed"]["entry"])) {
$youtube_videos = array();
foreach ($youtube_json["feed"]["entry"] as $video_result) {
$youtube_video = array();
$youtube_video["Title"] = $video_result["title"]["\$t"];
$youtube_video["Link"] = $video_result["link"][0]["href"];
if (isset($video_result["gd\$comments"])) {
$youtube_video["Comments"] = $video_result["gd\$comments"]["gd\$feedLink"]["countHint"];
} else {
$youtube_video["Comments"] = "0";
}
$youtube_video["Thumbnail"] = $video_result["media\$group"]["media\$thumbnail"][0]["url"];
$youtube_video["Duration"] = Utilities::convertToHMS($video_result["media\$group"]["yt\$duration"]["seconds"]);
$youtube_videos[] = $youtube_video;
}
return $youtube_videos;
} else {
return array();
}
}
} else {
return array();
}
}