Kodi Community Forum

@Karellen

Aeon Nox Silvo

Hi - I had issues with my ratings for the UK too, so every so often did a few minor updates to the database directly:

You can use SQLiteSpy (or another db editor that can read SQLite3 files) & open the kodi db
%AppData%\Roaming\Kodi\userdata\Database

sql:


UPDATE movie SET C12 = replace(C12, 'Rated ', 'UK:' ) WHERE c12 LIKE 'Rated%';

UPDATE tvshow SET C13 = replace(C13, 'Rated ', 'UK:' ) WHERE c13 LIKE 'Rated%';

UPDATE movie SET C12 = '' where c12='Rated';

UPDATE tvshow SET C13 = 'UK:PG' WHERE c13 = 'TV-PG';

UPDATE tvshow SET C13 = 'UK:12' WHERE c13 = 'TV-14';

UPDATE tvshow SET C13 = 'UK:15' WHERE c13 = 'TV-MA';

UPDATE tvshow SET C13 = 'UK:PG' WHERE c13 = 'TV-G';

UPDATE tvshow SET C13 = 'UK:U' WHERE c13 = 'TV-Y';

UPDATE tvshow SET C13 = 'UK:U' WHERE c13 = 'TV-Y7';

Then I just check for any others that didn't match & might need updating manually by running these:

sql:


select idmovie,idfile,c00,c09,c12 from movie where c12 not in ('UK:U','UK:PG','UK:12','UK:12A','UK:15','UK:18')

select idshow,c00,c13 from tvshow where c13 NOT in ('UK:U','UK:PG','UK:12','UK:12A','UK:15','UK:18')

Im also having probs using gb as country and all i get is NR any possiblilty of a quick demo video showing what needs to go where and how to input the values please?

Update solved many thanks

Hi can you let me know what you did to solve the issue? Thanks

What works for me is to use the following options
Preferred certification country  gb
Certification Prefix  UK:

in the configuration for instance of
The Movie Database Python
The MovieDBHelper
TMDb TV Shows

(2023-02-01, 21:22)robbie599 Wrote: [ -> ]What works for me is to use the following options
Preferred certification country gb
Certification Prefix UK:

in the configuration for instance of
The Movie Database Python
The MovieDBHelper
TMDb TV Shows

Same for me thats the method I use