We are working on devising a better way to edit the TV releases manually. Will update when we know more. The ONLY downside to the way we do things now, is if a release isn't matched against an external DB, it will never have season/episode/airdate/seriesfull information. Bart and I have discussed creating a manual edit popup that will allow you to select the desired show via manual search from the nZEDb implemented API of your choice. Still, we feel that our way is much, much better than the old way. I have way more TV matches than I did before. Out of 1.5 Million TV show releases, I have 1.1M matched to real, accurate data. But I digress.
The Video and Episode IDs of the releases are localized. They do not directly correlate to any external site. There are number of ways to lookup what you want, but it's all MySQL intensive. I will provide some examples.
Let's say you know the tvdb/tvmaze/tmdb/imdb/tvrage ID and want to find the video/episode IDs for Season 4 Episode 3. Simply run:
SELECT v.id AS video, tve.id AS episode FROM videos v INNER JOIN tv_episodes tve ON v.id = tve.videos_id WHERE v.tvdb = 1234 AND tve.series = 4 AND tve.episode = 3;
Plug these two numbers into the appropriate spots in the edit fields and you're all done. This is all that is needed to be a match.
For air by date shows, the query is a little more simple.
SELECT v.id AS video, tve.id AS episode FROM videos v INNER JOIN tv_episodes tve ON v.id = tve.videos_id WHERE v.tvmaze = 1234 AND tve.firstaired = '2010-01-28';
Alternatively, let's say you know the local Video ID. You might know this if you can readily identify the show, and you have selected it from the TV Series list within your nZEDb installation. If you look at the URL for the series, you'll see something like
http://serverroot//series/106226. 106226 is the local Video ID. So your query should be:
SELECT v.id AS video, tve.id AS episode FROM videos v INNER JOIN tv_episodes tve ON v.id = tve.videos_id WHERE v.id = 106226 AND tve.series = 4 AND tve.episode = 3;
For the most part, you can do any combination of these queries if you're clever enough. For example, the way Sonarr works is it sends a request with all possible site IDs and requests ANY matches be returned. So the query ends up looking like:
WHERE (v.tvdb = 1234 OR v.tvmaze = 2345 OR v.tvrage = 3456) AND tve.series = 4 AND tve.episode = 3;
So as long as we have one of the site IDs listed above stored with the Video entry, it will return the video/episode IDs if we also have a season/episode match. Any questions?