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); } } }