Quoting Mithi:

Quote:
Only one very small problem remains: the update incorporates the "new" 3D-Audioformats, right? Until now I downgraded all those because of the problem phphDVDProfiler had with them. My test-profile still throws errors but shows the right icons. Is there anything I still have to do to the database?
As said, very minor because of lacking hardware I don't care much about those anyways, would just make the downgrading unnecessary.

I had added only the Dolby Atmos as the 3D audio formats, as it's the only one I had in my database. I'll have a look at it in more details tomorrow and add the Auro-3D one, and see if others are missing too. In the meantime, you can do the modification as proposed by Lowpro (thanks!), it'll work.

Quoting Mithi:

Quote:
Thanks Lowpro, done.
Although I cheated a little and just put it in the global, as Atmos already was. If I understood it corecct, that just means it is not translated, which is fine by me.

/***/ 'Dolby Atmos' => 'Dolby Atmos',
'Auro-3D' => 'Auro',

Quickly bashed together logo is: if anyone is interested. I'm not satisfied with the golden "3D" part, maybe I'll try again tomorrow.

Welcome and nice logo.  I roll a little different though.  Went with text only for a cleaner look.  The only images I'm using (...aside from the cover images of course) are the ones for the review ratings (...the same images seen in DVD Profiler for PC, the "Bars" option) and the icons to the left of each title in the left pane calling out the media type which I customized, a grey dot for DVD, blue dot for Blu-ray, black dot for UHD Blu-ray, green dot for SD Blu-ray, and an iTunes icon for all my iTunes on Blu-ray profiles, i.e. iTunes content that I authored to Blu-ray.

OK, third day in a row with a new release... I wouldn't have thought I'd invest so much time on it. 

Anyway, this one is important. Please update your installations as soon as possible. This fixes some security issues... Hopefully, I haven't broken anything with this update, but it might have. At least, the features I use are still working. At the same time, I've also removed dead links from the navigation menu, and fixed a small PHP notice that was still there.

This newer version is again published on either my website ( https://mudry.org/blog/post/2019/12/26/phpDVDProfiler-and-PHP-7.2 ) or GitHub ( https://github.com/julmud/phpDVDProfiler )

Quoting Mithi:

Quote:
One minor bug:
In the "Features" section the first two letters are missing. 'Scene Access' becomes 'ene Access' respectively if
'Feature Trailers' is the first entry it become 'ature Trailers'

Oops indeed. I don't understand how it could have happened, but it's now corrected on both the Github repository and my website.

Thanks a lot for the bug report!

Edit: I found another small bug with the gallery and boxsets. The code in Github already has the correction for that, I'll update the distribution on my website later.

So, another day, another release... Hopefully, the last one of 2019! 

I've botched a few things in the previous releases, and fixed something that was bothering me for a few years.

Fixed my really bad implementation of the DB schema update

Revamped the rating's logo system

Updated localities.xod file (not sure what it's really used for)

I've always been a bit frustrated with the way phpDVDProfiler displayed the ratings logo for a movie. In Switzerland, we have accented characters in our rating system's name, and I had to match this for the filenames of the logos. Alas, it's always been difficult to get the correct filename on all kind of operating systems.[1] Consequently, I've added a transliteration system which converts the expected file name to simple ASCII and tries to find it. If the logo can't be found, the system falls back to the previous usage of the full rating system name in the expected file name.

As in the previous days, you can get the new release either from GitHub or my website.

[1] UTF-8 in the filenames should have theoretically solved this... but phpDVDProfiler only knows latin-1, so a conversion would be needed anyway.

Quoting DJ Doena:

Quote:
On GitHub is the schema_updater.sql missing 

Yes, it was a mistake: it should never have been committed. phpDvdProfiler already had an auto-update feature for the database schema.

Copying over all updated php files and the schema*.sql files, and then running the incremental update is sufficient to update the database schema too.

There's still an issue for the delta update.

I built the database from scratch with the Dec 29 version. Today I updated to the Jan 07 version.

In both when I add new profiles without checking "full update" I get an error in

mysqli.php on line 457

Either the SQL string is too long or the error output cuts it off but it says:

Quote:

INSERT INTO DVDPROFILER_dvd_common_actor (caid,firstname,middlename,lastname,birthyear,fullname) VALUES (2,'Liam','','Neeson',1952,'Liam Neeson'),(3,'Bradley','','Cooper',1975,'Bradley Cooper'),(4,'Jessica','','Biel',1982,'Jessica Biel'),(5,'Quinton','\'Rampage\'','Jackson',1978,'Quinton \'Rampage\' Jackson'),(6,'Sharlto','','Copley',1973,'Sharlto Copley'),(7,'Patrick','','Wilson',1973,'Patrick Wilson'),(8,'Gerald','','McRaney',1947,'Gerald McRaney'),(9,'Henry','','Czerny',1959,'Henry Czerny'),(10,'Yul','','Vazquez',1485,'Yul Vazquez'),(11,'Brian','','Bloom',1970,'Brian Bloom'),(12,'Maury','','Sterling',1971,'Maury Sterling'),(13,'Terry','','Chen',1975,'Terry Chen'),(14,'Omari','','Hardwick',1974,'Omari Hardwick'),(15,'David','','Hugghins',0,'David Hugghins'),(16,'Jacob','','Blair',1984,'Jacob Blair'),(17,'Rad','','Daly',1966,'Rad Daly'),(18,'Kyle','','Riefsnyder',26173, in /www/htdocs/djdoena/phpdvdprofiler/mysqli.php on line 457

Note how the insert ends abruptly in the middle of a statement:

Quote:

(18,'Kyle','','Riefsnyder',26173,

Additional note: None of these actors were new (i.e. were even in the new profiles). So it seems it tries to insert actors that are already in there without having changed their data (names or birthdates).

I've published today the fix for the incremental, as was reported by DJ Doena. Here the full list of changes:

add support of the Fr4me and Handle case types

fix fast incremental updates

fix the use of temporary tables in incremental updates and CleanCommon script

fix the French translation of the countries

fix the displayed flag for language Rumantsch

fix the RSS feed after our adding the support of 4K/UHD profiles

cleanup some small notices / bugs for better maintainability

As in the previous days, you can get the new release either from GitHub or my website.