Timelord funtion

[Vacendak]

Hi all,

i've really been missing the Timelord-Plugin from E-Who-Shall-Not-Be-Named. This Plugin could change the "Date added" of an Episode or Movie to the "Release Date", so when you add older Movies or TV-Shows, it would not clutter up the New-Episodes/Movie lists. My SQL-Skills are pretty much non-existent, but i managed to figure out how to do it (outside jellyfin, with a stopped server) directly on the sqlite-db:

UPDATE TypedBaseItems SET PremiereDate = NULL WHERE PremiereDate = "0001-01-01 00:00:00Z";
UPDATE TypedBaseItems SET DateCreated = PremiereDate WHERE type = "MediaBrowser.Controller.Entities.Movies.Movie" AND PremiereDate NOT NULL;
UPDATE TypedBaseItems SET DateCreated = PremiereDate WHERE type like "MediaBrowser.Controller.Entities.TV.%" AND PremiereDate NOT NULL;
VACUUM;

(the first line: I had about 5% Items without a PremiereDate that where "0001-01-01 00:00:00Z", the rest where NULL, so i assume that this is a mistake from broken Metadata in files etc)

This works fine for the webui, but the kodi-addon does not pick it up. I assume, that i have to update a timestamp so the kodi-addon notices that an entry was changed...? Can someone with a bit more understanding tell me which one (there are several other Dates beside PremiereDate and DateCreated)...?

Regards,

/V

[jimmyjammy]

This is certainly not ideal but I just select the "Watched" checkmark on older Movies/Tv-Shows that I add & refresh the page. This makes them disappear from the New-Episodes/Movie lists on the Home page