public static function generalDBConnection()
{
if (!isset(self::$uniqueSQLCon)) {
$sql = new \sDb(SystemConfig::DB_HOST, SystemConfig::DB_USER, SystemConfig::DB_PASS, SystemConfig::DB_NAME);
self::$uniqueSQLCon = $sql;
}
return self::$uniqueSQLCon;
}
private function deleteSeries()
{
$series_id = $_REQUEST['seriesid'];
$sql = SingeltonDB::generalDBConnection();
$query = " DELETE\n `Series`,\n `Episodes`\n FROM\n `Series`,\n `Episodes`\n WHERE\n `Series`.`SeriesID` = [series_id]\n AND\n `Episodes`.`SeriesID` = [series_id]\n ";
$sql->query($query, ["series_id" => $series_id]);
}
public function insertEpisodes($seriesId, $thetvdbSeriesId)
{
$data = $this->xml2array('http://thetvdb.com/api/74C646F2A4937AE5/series/' . $thetvdbSeriesId . '/all/en.xml');
$sql = SingeltonDB::generalDBConnection();
$query = "UPDATE\n `Series`\n SET\n `SeriesBanner` = [banner]\n WHERE\n `SeriesID` = [seriesId]\n ";
$sql->query($query, ['banner' => $data['Data']['Series']['banner'], 'seriesId' => $seriesId]);
$selectQuery = "SELECT CONCAT (`Season`, `EpisodeNr`) AS `SeasonEp`\n FROM `Episodes`\n WHERE `SeriesID` = [seriesId]\n ";
$sql->query($selectQuery, ['seriesId' => $seriesId]);
$existing_episodes = $sql->vResultArray();
$existingSeasonEp = [];
foreach ($existing_episodes as $key => $value) {
$existingSeasonEp[] = $value['SeasonEp'];
}
$insertQuery = " INSERT INTO\n `Episodes`\n SET\n `Title` = [EpisodeName],\n `Season` = [SeasonNumber],\n `EpisodeNr`= [EpisodeNumber],\n `AirDate` = [FirstAired],\n `SeriesID` = [series_id],\n `Description` = [Overview]\n ";
$updateQuery = " UPDATE `Episodes`\n SET\n `Title` = [EpisodeName],\n `AirDate` = [FirstAired],\n `Description` = [Overview]\n WHERE\n `SeriesID` = [series_id]\n AND\n `Season` = [SeasonNumber]\n AND\n `EpisodeNr` = [EpisodeNumber]\n ";
foreach ($data['Data']['Episode'] as $episode) {
$TVDBSeasonEp = $episode['SeasonNumber'] . $episode['EpisodeNumber'];
$episode['series_id'] = $seriesId;
if (!in_array($TVDBSeasonEp, $existingSeasonEp)) {
$sql->query($insertQuery, $episode);
} elseif (in_array($TVDBSeasonEp, $existingSeasonEp)) {
$sql->query($updateQuery, $episode);
}
}
}