home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
IMDb+
IMDb+ Plugin 2.1.0.291 with IMDb+ Scraper v4.9.xxx
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="RoChess" data-source="post: 1268967" data-attributes="member: 18896"><p>Anybody interested in cleaning their collection, I used "SQLite Expert Personal" to have a copy of MovPic dbase open, while MovPic config was also open with the real dbase (to avoid corruption).</p><p></p><p>Queries used:</p><p></p><p style="margin-left: 20px">SELECT [ICODE]certification[/ICODE], COUNT([ICODE]certification[/ICODE]) FROM [ICODE]movie_info[/ICODE]</p> <p style="margin-left: 20px">GROUP BY [ICODE]certification[/ICODE]</p><p></p><p>That gives a quick overview on all the different ratings your collection currently contains.</p><p></p><p style="margin-left: 20px">SELECT [ICODE]title[/ICODE], [ICODE]year[/ICODE], [ICODE]certification[/ICODE] FROM [ICODE]movie_info[/ICODE]</p> <p style="margin-left: 20px">WHERE [ICODE]certification[/ICODE] = 'Not Rated'</p> <p style="margin-left: 20px">ORDER BY [ICODE]title[/ICODE]</p><p></p><p>Which then allows you to narrow it down to each individual rating that seems out of place. Entering the first few letters without any break immediately jumps to that movie when you are inside the "Movie Manager" tab with focus on the movie list.</p><p></p><p>Another option obviously is to copy "NR.png" to "Not Rated.png", but also keep in mind that ratings often update.</p><p></p><p>On a small collection you can always just use the IMDb+ plugin option in GUI to mass-refresh your entire collection while watching a movie. Once I push out a new plugin update I will add more filter options to refresh a large collection in sections. It currently supports refreshing in chunks based on starting letter of the movie, and plan to expand that with Genres, Ratings/Certifications, and other grouping that might be useful.</p><p></p><p>The comedy "Zack and Miri Make a Porno (2008)" was in my collection with an "X" rating from an old import. In most European countries 11-and-older are allowed to watch that, but in prude USA they prefer to freak out over nudity with gore and violence totally fine <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite15" alt=":censored:" title="Censored :censored:" loading="lazy" data-shortname=":censored:" /> It is now refreshed to an R-rating which is more appropriate for that movie, but I wonder if they needed to do a few edits to get reassigned.</p></blockquote><p></p>
[QUOTE="RoChess, post: 1268967, member: 18896"] Anybody interested in cleaning their collection, I used "SQLite Expert Personal" to have a copy of MovPic dbase open, while MovPic config was also open with the real dbase (to avoid corruption). Queries used: [INDENT]SELECT [ICODE]certification[/ICODE], COUNT([ICODE]certification[/ICODE]) FROM [ICODE]movie_info[/ICODE][/INDENT] [INDENT]GROUP BY [ICODE]certification[/ICODE][/INDENT] That gives a quick overview on all the different ratings your collection currently contains. [INDENT]SELECT [ICODE]title[/ICODE], [ICODE]year[/ICODE], [ICODE]certification[/ICODE] FROM [ICODE]movie_info[/ICODE][/INDENT] [INDENT]WHERE [ICODE]certification[/ICODE] = 'Not Rated'[/INDENT] [INDENT]ORDER BY [ICODE]title[/ICODE][/INDENT] Which then allows you to narrow it down to each individual rating that seems out of place. Entering the first few letters without any break immediately jumps to that movie when you are inside the "Movie Manager" tab with focus on the movie list. Another option obviously is to copy "NR.png" to "Not Rated.png", but also keep in mind that ratings often update. On a small collection you can always just use the IMDb+ plugin option in GUI to mass-refresh your entire collection while watching a movie. Once I push out a new plugin update I will add more filter options to refresh a large collection in sections. It currently supports refreshing in chunks based on starting letter of the movie, and plan to expand that with Genres, Ratings/Certifications, and other grouping that might be useful. The comedy "Zack and Miri Make a Porno (2008)" was in my collection with an "X" rating from an old import. In most European countries 11-and-older are allowed to watch that, but in prude USA they prefer to freak out over nudity with gore and violence totally fine :censored: It is now refreshed to an R-rating which is more appropriate for that movie, but I wonder if they needed to do a few edits to get reassigned. [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
MediaPortal 1 Plugins
Popular Plugins
IMDb+
IMDb+ Plugin 2.1.0.291 with IMDb+ Scraper v4.9.xxx
Contact us
RSS
Top
Bottom