Kodi Community Forum
Solved How can I display UK certifications - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Skins Support (https://forum.kodi.tv/forumdisplay.php?fid=67)
+---- Forum: Aeon Nox: Silvo (https://forum.kodi.tv/forumdisplay.php?fid=142)
+---- Thread: Solved How can I display UK certifications (/showthread.php?tid=355002)

Pages: 1 2

RE: How can I display UK certifications - Jbev01 - 2020-07-04

@Karellen

Aeon Nox Silvo

RE: How can I display UK certifications - craigey1 - 2020-10-27

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')


RE: How can I display UK certifications - kikassridec2 - 2021-04-08

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

RE: How can I display UK certifications - RayzaEFC - 2023-01-30

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

RE: How can I display UK certifications - robbie599 - 2023-02-01

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

RE: How can I display UK certifications - kikassridec2 - 2023-02-02

(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