Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4  Previous   Next
phpDVDProfiler
Author Message
DVD Profiler Unlimited RegistrantStar Contributorzeiram
Registered: April 16, 2007
Reputation: High Rating
Switzerland Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Great Rating
Germany Posts: 2,165
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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.
Mithi's little XSLT tinkering - the power of XML
 Last edited: by Mithi
DVD Profiler Unlimited RegistrantLowpro
Registered: March 14, 2007
Reputation: High Rating
United States Posts: 221
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
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.
My DVD/Blu-ray Collection
 Last edited: by Lowpro
DVD Profiler Unlimited RegistrantStar Contributorzeiram
Registered: April 16, 2007
Reputation: High Rating
Switzerland Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I've just released a new version, with support for the Auro-3D and DTS-X audio formats, and the "new" DVD Profiler 4 disc features (thanks Lowpro for your script from 2017). The new disc features need a database schema update. You can either delete the whole schema and recreate it with the schema.sql script, or just run the new schema_updater.sql script. I've done limited testing with this updater script, but it should be working on most situations.

If you don't want to update the database, no problems... the only downside you'll encounter is that the new features are not displayed, but everything else should be working flawlessly.

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 )
DVD Profiler Unlimited RegistrantStar Contributorzeiram
Registered: April 16, 2007
Reputation: High Rating
Switzerland Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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 )
 Last edited: by zeiram
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Great Rating
Germany Posts: 2,165
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with 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'
It's in the websource like that, so no rendering error. Across all languages, so the translation is not at fault. And not the database cause 'Feature Trailers' as second item in a Features-list is shown correct.
@zeiram and it is on your DVD-list too, so it is not my webserver.
Mithi's little XSLT tinkering - the power of XML
DVD Profiler Unlimited RegistrantStar Contributorzeiram
Registered: April 16, 2007
Reputation: High Rating
Switzerland Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
 Last edited: by zeiram
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Great Rating
Germany Posts: 2,165
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Again, many thanks, all works as expected.

Good thing phpDVDProfiler has a new lease on life. 
I was already musing how to come to a similar result using the XML-export, and while possible it might have ended up rather inconvenient.
Mithi's little XSLT tinkering - the power of XML
DVD Profiler Unlimited RegistrantStar Contributorzeiram
Registered: April 16, 2007
Reputation: High Rating
Switzerland Posts: 25
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
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.
    DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
    Battle Troll
    Registered: March 14, 2007
    Reputation: Highest Rating
    Germany Posts: 6,436
    Posted:
    PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
    On GitHub is the schema_updater.sql missing 
    Karsten
    DVD Collectors Online
    Amazon Price Observer

    DVD Profiler Unlimited RegistrantStar Contributorzeiram
    Registered: April 16, 2007
    Reputation: High Rating
    Switzerland Posts: 25
    Posted:
    PM this userView this user's DVD collectionDirect link to this postReply with quote
    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.
    DVD Profiler Unlimited RegistrantStar Contributorzeiram
    Registered: April 16, 2007
    Reputation: High Rating
    Switzerland Posts: 25
    Posted:
    PM this userView this user's DVD collectionDirect link to this postReply with quote
    Hello

    For the start of the new year, I offer you a new version of phpDVDProfiler. And thanks to a new contributor (welcome aboard Gavin-John Noonan!), this new version implements a feature that was requested in 2017: support of the 4k/UHD profiles!

    Here's the full list of changes:
  • add support for the 4K/UHD media format (thanks Gavin-John!)

  • fix the character set encoding in the "Watched Statistics" page

  • fix the database schema creation script for compatibility with MySQL 5.7

  • add support for MySQL 8

  • switch back to zip files for the "official" distribution as it was the format used before

  • fix small behind the scenes stuff for better code in the future


  • As in the previous days, you can get the new release either from GitHub or my website.
    DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
    Battle Troll
    Registered: March 14, 2007
    Reputation: Highest Rating
    Germany Posts: 6,436
    Posted:
    PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
    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).
    Karsten
    DVD Collectors Online
    Amazon Price Observer

     Last edited: by DJ Doena
    DVD Profiler Unlimited RegistrantStar Contributorzeiram
    Registered: April 16, 2007
    Reputation: High Rating
    Switzerland Posts: 25
    Posted:
    PM this userView this user's DVD collectionDirect link to this postReply with quote
    Quoting DJ Doena:
    Quote:

    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:

    It's a "feature" of PHP: the error message gets truncated at some point when it's deemed to be too long. And when the fast update is active (that's the default case), phpDVDProfiler builds an in-memory list of all the casts and crews, then does a single insert or update query. So, this request can be very long and the PHP error system isn't helping us in understanding what's wrong.

    I haven't had any problem with the incremental update lately, but I'll look further into this.
    DVD Profiler Unlimited RegistrantStar Contributorzeiram
    Registered: April 16, 2007
    Reputation: High Rating
    Switzerland Posts: 25
    Posted:
    PM this userView this user's DVD collectionDirect link to this postReply with quote
    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.
    DVD Profiler Desktop and Mobile RegistrantStar ContributorDJ Doena
    Battle Troll
    Registered: March 14, 2007
    Reputation: Highest Rating
    Germany Posts: 6,436
    Posted:
    PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
    Quoting zeiram:
    Quote:
    I've published today the fix for the incremental, as was reported by DJ Doena.


    Works like a charm. Thx 
    Karsten
    DVD Collectors Online
    Amazon Price Observer

        Invelos Forums->DVD Profiler: Plugins Page: 1 2 3 4  Previous   Next