In Development whilst airing


gazza911 wrote 10 years ago: 1

I wasn't sure whether to put this in bugs or not, but it's possible that a show will be In Development even after the first episode has aired as it requires manually changing - as can be seen in this image. Shouldn't it just automatically update the status after the first episode has aired?

A fairly simple way to achieve this is to run a query daily, i.e something similar to this (MySQL syntax where there's a separate table for shows and episodes) :

UPDATE shows INNER JOIN episodes ON shows.showID = episodes.showID SET status = 'Running' WHERE shows.status = 'In Development' AND episodeID = 1 AND CURDATE() > airDate;

deleted wrote 10 years ago: 1

gazza911 wrote:
I wasn't sure whether to put this in bugs or not, but it's possible that a show will be In Development even after the first episode has aired as it requires manually changing - as can be seen in this image. Shouldn't it just automatically update the status after the first episode has aired?
A fairly simple way to achievie this is to run a query daily, i.e something similar to this (MySQL syntax where there's a separate table for shows and episodes) :
UPDATE shows INNER JOIN episodes ON shows.showID = episodes.showID SET status = 'Running' WHERE shows.status = 'In Development' AND episodeID = 1 AND CURDATE() > airDate;

For now it has to be set manually, however it might not be a bad idea if it could be done automatically indeed.


david wrote 10 years ago: 1

Yeah, I'm moving this to suggestions as I can't say that it's a bug.

But it would indeed be a nice addition to prevent cases like this that don't make any sense. Will look at this in the future :)

Gadfly wrote 10 years ago: 1

gazza911 wrote:
I wasn't sure whether to put this in bugs or not, but it's possible that a show will be In Development even after the first episode has aired as it

Could you give a few examples of shows that are In Development after the first episode officially aired?


gazza911 wrote 10 years ago: 1

There's not really a list of them (that would require going through each one or database access), but like I said;

Until I changed it for Full Frontal with Samantha Bee, it displayed as In Development even though it aired on February 8th, as can be seen here

Gadfly wrote 10 years ago: 1

Ah, I see. I thought you were specifying the other way around.

Most contribution-based systems don't automate that kind of thing. It would be convenient if it would, but then you'd have to lock out contributors who might have a legitimate reason to revert it back to In Development. It depends on how "official" an episode release is. If a network releases an episode on its website a month before it airs on the network broadcast channel, which date should be listed? And is the Internet broadcast "official"? And if you're going to go by the Internet broadcast, is that one-month period mean the show is still In development?

That's the only potentially legitimate circumstance I can think of where you might get some overlap. There could be others.


gazza911 wrote 10 years ago: 1

You can only realistically (without AI) automate logic based processes.

From FAQ - Episodes

If a show premieres on a web channel like Netflix and is aired on a TV network later on, the Netflix premiere dates must be used. Only sources available to the general public are considered for premiere dates.

From FAQ - Shows

In Development: for new shows currently in development, when a pilot has not yet aired

.

According to TVMaze, as soon as that pilot airs publicly, it's no longer in development, but running - therefore if the correct airdate for the pilot has been used (whether that be the Web Channel if consistent enough or the Network), by definition the status needs changing to Running after the episode's airdate.

Gadfly wrote 10 years ago: 1

But what if the web channel isn't available to the general public?


gazza911 wrote 10 years ago: 1

Gadfly wrote:
But what if the web channel isn't available to the general public?

Then that airdate would not be added to TVMaze and there wouldn't be a problem - it would update to running only after the pilot has aired on the network. I'm not really sure where you're going with all this; all I'm saying should be done is using the current data that we have on TVMaze, set the show to Running if the current date is later than the airdate that has already been added to TVMaze.

deleted wrote 10 years ago: 1

Gadfly wrote:
But what if the web channel isn't available to the general public?

Gazza is 100% correct about this matter. If a series premieres on a Web channel, which could be accessed by the general public, the Web channel will get priority over network, but if access is only allowed to a selective group such as critics, we stick to networks.

Not entirely sure why you are doubting about it as Gazza did a good job explaining it.

Try 30 days of free premium.