|
|
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 5 Previous Next
|
phpDVDProfiler |
|
|
|
Author |
Message |
Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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. |
| Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | 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 --- DVD-Profiler Mini-Wiki | | | Last edited: by Mithi |
| Registered: March 14, 2007 | Reputation: | Posts: 299 |
| Posted: | | | | 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 |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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 ) |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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 |
| Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | 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 Mini-Wiki |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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 |
| Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | 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 Mini-Wiki |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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 updateRevamped the rating's logo systemUpdated 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. |
| Registered: March 14, 2007 | Reputation: | Posts: 6,742 |
| | Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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. |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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" pagefix the database schema creation script for compatibility with MySQL 5.7add support for MySQL 8switch back to zip files for the "official" distribution as it was the format used beforefix small behind the scenes stuff for better code in the futureAs in the previous days, you can get the new release either from GitHub or my website. |
| Registered: March 14, 2007 | Reputation: | Posts: 6,742 |
| Posted: | | | | 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
| | | Last edited: by DJ Doena |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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. |
| Registered: April 16, 2007 | Reputation: | Posts: 30 |
| Posted: | | | | 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 typesfix fast incremental updatesfix the use of temporary tables in incremental updates and CleanCommon scriptfix the French translation of the countriesfix the displayed flag for language Rumantschfix the RSS feed after our adding the support of 4K/UHD profilescleanup some small notices / bugs for better maintainabilityAs in the previous days, you can get the new release either from GitHub or my website. |
| Registered: March 14, 2007 | Reputation: | Posts: 6,742 |
| Posted: | | | | 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
|
|
|
Invelos Forums->DVD Profiler: Plugins |
Page:
1 2 3 4 5 Previous Next
|
|
|
|
|
|
|
|
|