2014-06-22, 17:06
I believe the issue is that the video db is storing the ratings as 'Rated **' in the columns C12 for movies & C13 for tvshows.
The IncludesVariables.xml will show the UK Flags if the ratings are stored as 'UK:**'
You can either modify the IncludesVariables.xml or update your library using something like:
make sure you backup your DB first!
Alternatively you can use m4x1m's script to update the ratings. See this post for more info
The IncludesVariables.xml will show the UK Flags if the ratings are stored as 'UK:**'
You can either modify the IncludesVariables.xml or update your library using something like:
Code:
UPDATE movies SET C12 = replace(C12, 'Rated ', 'UK:' ) WHERE c12 LIKE 'Rated%';
UPDATE tvshow SET C13 = replace(C13, 'Rated ', 'UK:' ) WHERE c13 LIKE 'Rated%';
Alternatively you can use m4x1m's script to update the ratings. See this post for more info