$result = $db->query('SELECT * FROM `calendar` ORDER BY `time` ASC');
while($show = $result->fetch_object()) {
/* Uppdatera med namn på avsnittet om det inte finns fyra dagar innan avsnittet kommer på TV */
if($show->title == 'TBA' && $show->time <= strtotime('today + 4 days')) {
$seasons = json_decode(file_get_contents('http://api.trakt.tv/show/seasons.json/f39376525e09e58245a7900...' . str_replace(' ', '-', strtolower($show->show)) . '/'));
$episodes = json_decode(file_get_contents('http://api.trakt.tv/show/season.json/f39376525e09e58245a79003...' . str_replace(' ', '-', strtolower($show->show)) . '/' . $seasons[0]->season . '/'));
foreach($episodes as $episode) {
if($episode->episode == $show->episode) {
$db->query('UPDATE `calendar` SET `title` = "' . $db->real_escape_string($episode->title) . '" WHERE `id` = "' . $show->id . '" LIMIT 1;');
$show->title = $episode->title;
break;
}
}
}
/* Om avsnittet är på TV idag eller var på TV igår, visa en ringklocka */
if(date('Y-m-d', $show->time) == date('Y-m-d', strtotime('today')) || date('Y-m-d', $show->time) == date('Y-m-d', strtotime('today - 1 day'))) {
$show->today = true;
}
/* Uppdatera till nästa avsnitt 2 dagar efter avsnittet varit på TV */
if(date('Y-m-d', $show->time) == date('Y-m-d', strtotime('today - 2 days'))) {
$seasons = json_decode(file_get_contents('http://api.trakt.tv/show/seasons.json/f39376525e09e58245a7900...' . str_replace(' ', '-', strtolower($show->show)) . '/'));
$episodes = json_decode(file_get_contents('http://api.trakt.tv/show/season.json/f39376525e09e58245a79003...' . str_replace(' ', '-', strtolower($show->show)) . '/' . $seasons[0]->season . '/'));
foreach($episodes as $episode) {
if($episode->first_aired > time()) {
$db->query('UPDATE `calendar` SET `season` = "'. $db->real_escape_string($episode->season) .'", `episode` = "'. $db->real_escape_string($episode->episode) .'", `title` = "'. $db->real_escape_string($episode->title) .'", `time` = "'. $db->real_escape_string($episode->first_aired) .'" WHERE `id` = "'. $show->id .'" LIMIT 1;');
$show->season = $episode->season;
$show->episode = $episode->episode;
$show->title = $episode->title;
$show->time = $episode->first_aired;
break;
}
}
}
$shows[] = $show;
}
/* Sortera avsnitten efter tid */
$time = array();
foreach($shows as $key => $value)
$time[$key] = $value->time;
array_multisort($time, SORT_ASC, $shows);
foreach($shows as $show) {
echo('<li>' . (isset($show->today) ? '<img src="/static/important.png" alt="Important" />' : '') . '<a href="https://www.sceneaccess.eu/browse?search=' . str_replace(' ', '+', strtolower($show->show)) . '+s' . str_pad($show->season, 2, '0', STR_PAD_LEFT) . 'e' . str_pad($show->episode, 2, '0', STR_PAD_LEFT) . '&method=2&c22=22&c27=27" target="_blank">' . $show->show . ' S' . str_pad($show->season, 2, '0', STR_PAD_LEFT) . 'E' . str_pad($show->episode, 2, '0', STR_PAD_LEFT) . ' "' . $show->title . '"</a>: ' . str_replace(array('January', 'February', 'March', 'April', 'May', 'June', 'July', 'August', 'September', 'October', 'November', 'December'), array('Januari', 'Februari', 'Mars', 'April', 'Maj', 'Juni', 'Juli', 'Augusti', 'September', 'Oktober', 'November', 'December'), date('j F', $show->time)) . '</li>');
}