Question Re-Process TMDb Data

[Justme1901]

Hi

Is there any way to Re-Process TMDb Data apart from doing the Content >> Series >> Mass Edit Episodes >> Select Episode >> enable Re-Process TMDb Data

The reason I ask is doing it that way will take for ever, with almost 100,000 episodes that over 95 pages at 1000 entry's per page. Is there a faster way? Maybe a SQL command?

I'm running XCUI with CK Mod 41 installed. I have searched the forum but not found anything.

Thank you

 

[mr_iptv]

Hello
same issue , is there anyone to help us how to update all Movies and Series with any command or way
we have already 10k movies and series
it will appreciated
regards

 

[projetohoron926]

I have a script that does this, DM me

 

[guetteur]

I have a script that does this, DM me

Just share it as resource to help the community

 

[ddmmyy]

Hi

Is there any way to Re-Process TMDb Data apart from doing the Content >> Series >> Mass Edit Episodes >> Select Episode >> enable Re-Process TMDb Data

The reason I ask is doing it that way will take for ever, with almost 100,000 episodes that over 95 pages at 1000 entry's per page. Is there a faster way? Maybe a SQL command?

I'm running XCUI with CK Mod 41 installed. I have searched the forum but not found anything.

Thank you

To avoid going and selecting all Movies or Episodes from Mass Edit we are inserting all IDs to from Movies/Episodes to TMDB_ASYNC directly by this MySQL Command.

To Update Movies use this MySQL Command:
insert into `tmdb_async` (`type`, `stream_id`, `status`) select `type`, `id`, 0 from `streams` where `type`= 2;

To Update Episodes use this MySQL Command:
insert into `tmdb_async` (`type`, `stream_id`, `status`) select `type`, `id`, 0 from `streams` where `type`= 5;

This MySQL Code is only for inserting all Movies/Episodes to database. Then Cronjob will get those inserted ids and make call to TMDB API one by one so if you have 100k Episodes API will call 100K times have fun.

 

[Flagton]

To avoid going and selecting all Movies or Episodes from Mass Edit we are inserting all IDs to from Movies/Episodes to TMDB_ASYNC directly by this MySQL Command.

To Update Movies use this MySQL Command:
insert into `tmdb_async` (`type`, `stream_id`, `status`) select `type`, `id`, 0 from `streams` where `type`= 2;

To Update Episodes use this MySQL Command:
insert into `tmdb_async` (`type`, `stream_id`, `status`) select `type`, `id`, 0 from `streams` where `type`= 5;

This MySQL Code is only for inserting all Movies/Episodes to database. Then Cronjob will get those inserted ids and make call to TMDB API one by one so if you have 100k Episodes API will call 100K times have fun.

Hello can you tell me how to use this command, I inserted it in heidiSQL, but it didn't work, maybe I did something wrong.

 

[Flagton]

I have a script that does this, DM me

hello can you help me with this problem?