Auto Certification Rating Conversion (US -> UK) (2 Viewers)

TheBatfink

MP Donator
  • Premium Supporter
  • June 11, 2007
    1,288
    221
    Nottingham
    Home Country
    United Kingdom United Kingdom
    I noticed with a lot of the scraper scripts there was still a lot of missing certification information and in some cases, the US rating was being imported even when the UK rating option was selected (imdb+). In most instances, the site being scraped simply does not have the UK rating available.

    This small app will allow you to load up your MovingPictures database file and search and convert certificate ratings based on your preferences. It is also possible to search for movies with missing certifications and populate them manually.

    Screenshot1.png Screenshot2.png

    To use, simply download the attached zip file, extract the two files to any location and run the DBCertRenamer.exe. All changes are displayed for review before having to commit to the change so you can see what is actually going to be edited (and cancel if the results are not as expected) and a backup of the database is taken before every update.

    UK BBFC Certification Logos (including higher res images) can be found here - BBFC Certs

    Changelog
    1.0.2
    - Added option to blanket rename 12 certs to 12A or 12A certs to 12 (UK Cinema ratings are always 12A. 12 Only exists for Home Video - I prefer the cinema ratings)
    - Added changes previews so all updates can be reviewed before committing to the update (with the option to cancel the update)
    - Fixed the movie counts at the bottom of the preview windows

    1.0.1
    - Tided up the UI and auto populated the selections to make it quicker to use
    - Added an option to retrieve and display all movie entries with no certification and allow them to be edited and saved manually
    - Time stamped the backups

    1.0.0
    - First release
     

    Attachments

    • DBCertRenamer.zip
      461.8 KB
    Last edited:

    fforde

    Community Plugin Dev
    June 7, 2007
    2,667
    1,702
    43
    Texas
    Home Country
    United States of America United States of America
    Sorry there is no official way to do this. If you are tech savy you can access the database directly with a program like SQLiteMan. Certification is stored in the movie_info table. This query is untested but you would want to do something like this:

    Code:
    update movie_info set certification='18' where certification='R';
     

    TheBatfink

    MP Donator
  • Premium Supporter
  • June 11, 2007
    1,288
    221
    Nottingham
    Home Country
    United Kingdom United Kingdom
    Hi fforde, thanks for the reply. I guess I could just knock up an ADO connection with ODBC provider and pass it the sql then. I'll have a play.
     

    TheBatfink

    MP Donator
  • Premium Supporter
  • June 11, 2007
    1,288
    221
    Nottingham
    Home Country
    United Kingdom United Kingdom
    Oh wow.. I must of spent the last three hours trying to make VB2010 work with SQLite.. MSSQL!!! lol.

    So.. can I assume these are the US certifications and the UK equivilents? I guess your as good a source to ask as anyone from being from the US :)

    G = U
    PG = PG
    PG-13 = 12A
    R = 15
    NC-17 = 18
    X = 18

    Is R a lower rating than NC-17 or have I got that mixed up? Thanks!
     

    TheBatfink

    MP Donator
  • Premium Supporter
  • June 11, 2007
    1,288
    221
    Nottingham
    Home Country
    United Kingdom United Kingdom
    Ok, so I made a little tool for doing the converting on the existing entries in the database. It seems to work ok, but it is a little basic.

    I've attached it for anyone else that wants to do the same thing, but just be warned you use it at your own risk so make sure to make a backup of the database file prior to doing any renaming (it does make a backup but better to be safe than sorry).

    Extract to a folder and run the .exe then select what you want renaming and what you want them renaming to. should be self explainatory.

    screenshot.png

    Thanks
     
    Last edited:

    TheBatfink

    MP Donator
  • Premium Supporter
  • June 11, 2007
    1,288
    221
    Nottingham
    Home Country
    United Kingdom United Kingdom
    Glad its of some use! Incidently I'm currently using a newer version I made as I noticed quite a few of my movies without any certification information at all (theres probably an easy way of filtering for them in MovPics config, but I didn't spot it). So this allows you to add some in.. I'd rather guess them than have them blank.

    - Tided up the UI and auto populated the selections to make it quicker to use
    - Added an option to retrieve and display all movie entries with no certification and allow them to be edited and saved manually
    - Time stamped the backups

    New version attached.

    screen1.png screen2.png

    Theres still some things bugging me which I'll probably add an option for soon. Namely, movies with certificates 12 and 12A. Officially, in the cinema, only 12A exists. Once they are released to DVD they become 12 as 12A does not exist for DVD's. I'd like them to be all the same in the database too :)
    Might add a review view of entries to be updated before commiting to the conversion so you can see whats going to change rather than just relying on it being correct.
     
    Last edited:

    Atomic7431

    Portal Pro
    June 17, 2011
    497
    71
    Home Country
    United Kingdom United Kingdom
    did you add an option to change 12a to 12 as i agree this is wrong, am about to test this out as i have some that need changing and just wanted to see if you made a newer version yet as it sounds very good little program to have :)
     

    TheBatfink

    MP Donator
  • Premium Supporter
  • June 11, 2007
    1,288
    221
    Nottingham
    Home Country
    United Kingdom United Kingdom
    I haven't made a new one yet, it was a quick job to add really but I lost the most recent version in a HDD death. I'll re-write it and add the option, hopefully be tomorrow, the 12A thing bugs me too :)
     
    Last edited:

    Users who are viewing this thread


    Write your reply...
    Top Bottom