thereido
commented
2 years ago The issue38.php script has been tested. It covers movies, tv shows, and tv episodes. Each type (movie/show/episode) is handled in a different way.
Movies:
- Show the duplicates for a given uniqueName.
- Also show the ratings for each of the dups.
- Prompt the user to choose which one to keep.
- Show lists they are in and prompt the user choose which lists for keep.
- Prompt for confirmation from the user
- Apply the changes...
- Link the ratings the film
- Delete the ratings they chose not to keep
- Add the film to the lists they chose
- Delete to other duplicate films
TV Shows:
- Everything for movies
- For episodes for parent that was deleted... re-parent it to the film row that was kept
TV Episodes:
- These "duplicates" are valid items with the wrong uniqueName value. The parent is still valid.
- Get the Show uniqueName from the parent
- Get the correct Episode uniqueName from TMDb API with the show, season number and episode number.
- Update the episode's uniqueName
That means separate titles are using the same "unique" TMDb ID.
SELECT COUNT(film_id), film_source.* FROM film_source WHERE source_name='TMDb' GROUP BY uniqueName HAVING COUNT(film_id) > 1;
-- Step 1 all dups - Get the 2nd film_id SELECT FROM film_source WHERE source_name='TMDb' AND uniqueName='ep1136939' -- Step 2 Get TV Series uniqueName, Season and Episode number SELECT f.id, f.parent_id, f.title, f.season, f.episodeNumber, f.episodeTitle, parentfs.uniqueName parent_un FROM film f, film_source parentfs WHERE f.id=1902 AND f.parent_id=parentfs.film_id AND parentfs.source_name='TMDb'; -- Step 3 Get the correct episode uniqueName https://api.themoviedb.org/3/tv/62823/season/1/episode/1?api_key=b34fb5c8c7ad394135edc8236bbb7b05&language=en-US -- Step 4 Update the correct uniqueName UPDATE film_source SET uniqueName='ep1068354' WHERE film_id=1902 AND source_name='TMDb' AND uniqueName='ep1136939'; -- Step 5 Are there extra film rows for the tv series? SELECT FROM film WHERE title='Glitch' ORDER BY season, episodeNumber