$db = new LibDatabase($dbs);
$options = new LibOptions();
# 3RD PARTY MODULE SETUP: TVDB #####################################
define('TVDB_URL', $options->get('tvdb_url'));
define('TVDB_API_KEY', $options->get('tvdb_api_key'));
include __DIR__ . '/../3rd_party/Moinax/TvDb/CurlException.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Client.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Serie.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Banner.php';
include __DIR__ . '/../3rd_party/Moinax/TvDb/Episode.php';
use Moinax\TvDb\Client;
$tvdb = new Client(TVDB_URL, TVDB_API_KEY);
$serverTime = $tvdb->getServerTime();
#####################################################################
$shows = $db->load_all_objects('tv_shows');
foreach ($shows as $show) {
$data = $tvdb->getSerieEpisodes($show['tvdb_id'], 'de');
foreach ($data['episodes'] as $episode) {
$db_episode = $db->load_episode($show['id'], $episode->season, $episode->number);
if (!$db_episode) {
$new_episode = array();
$new_episode['show_id'] = $show['id'];
$new_episode['season_num'] = $episode->season;
$new_episode['episode_num'] = $episode->number;
$new_episode['episode_name'] = $episode->name;
$new_episode['airdate'] = $episode->firstAired;
$db->insert($new_episode, 'tv_files');
echo ".";
}
}
}
$media_obj = $db->load_object_by_column('tv_shows', 'show_name', $show_name);
$file['show_id'] = $media_obj['id'];
if (!$media_obj) {
$data = $tvdb->getSeries($show_name, 'de');
if (empty($data)) {
# NOT FOUND, SET TO -1 AND CONTINUE
$file['show_id'] = -1;
$db->update($file, 'tv_files');
continue;
}
# ADD SHOW, UPDATE MEDIA-OBJECT
$tvshow['id'] = $db->get_new_table_id('tv_shows');
$tvshow['show_name'] = $data[0]->name;
if ($data[0]->firstAired) {
$tvshow['date'] = $data[0]->firstAired->format('Y-m-d');
}
$tvshow['tvdb_id'] = $data[0]->id;
$tvshow['imdb_id'] = $data[0]->imdbId;
$tvshow['banner'] = $data[0]->banner;
$tvshow['synopsis'] = $data[0]->overview;
$db->insert($tvshow, 'tv_shows');
$file['show_id'] = $tvshow['id'];
}
# UPDATE MEDIA-OBJECT
$db->update($file, 'tv_files');
echo ".";
if ($i % 50 == 0) {
echo $i . "\n";
}
$i++;
}
