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->Posts by zeiram Page: 1  Previous   Next
Message Details
Quoting JMM:
Quote:

I need some help with my index.php file to get phpDVDProfiler to recognize & use dates prior to 31 December 1969.  I know why it does it (Unix timestamp), but I have other scripts that use MySQL & PHP that display dates correctly prior to then, most going back centuries (my genealogy database).  I know... there were no DVDs prior to 1970, you say .  The thing is, I use phpDVDProfiler slightly differently, in that instead of using the DVD release dates, I instead use that field for the dates that the movies were first released.

This isn't as straight-forward as it should be, due to the way phpDVDProfiler stores the dates (as unsigned ints) in the database...

Everything I describe here is untested, so proceed at your own risk!

Spoiler:  (Select to view)

First, you'll need to change the type of the column:
ALTER TABLE dvdprofiler_dvd MODIFY released bigint signed default null;
ALTER TABLE dvdprofiler_dvd MODIFY lastedited bigint signed default null;

(In my personal export, the lastedited field had often a value of 1899-12-30... don't know why, but due to this fact the column also needs to be modified.)

Then you'll have to modify the function my_mktime in the file functions.php. The line 535 should be changed from:
if ($ret === false || $ret < 0) $ret = 0;

to:
if ($ret === false) $ret = 0;

You should then be able to use dates prior to 1970 in the released field.

Side note: this will NOT work with PHP 5.1 under Windows, as there's no support for negative timestamps there.
Posted:
Topic Replies: 60, Topic Views: 20030
Still trying to polish a few things, so here's a new release of phpDVDProfiler. The change list:
  • add the display of dynamic range information (thanks Lowpro)

  • add 4K/UHD profiles and new features support to Pick-a-Flick

  • fix the Pick-a-Flick feature

  • fix the charset encoding in gallery and specific skins

  • remove support of MySQL 4.0


  • If you still need support of MySQL 4.0 because your host doesn't provide you with a newer version, change host! MySQL 4.0's end of support was in December 2008, it really should be left in peace now...

    As in the previous days, you can get the new release either from GitHub or my website.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    By the way, if you want to "profit" from the automatic schema updates when updating the collection, you need to also increase the value for "db_schema_version" in the schema.sql file, and the value of "$code_schema_version" in the global.php file...
    Posted:
    Topic Replies: 60, Topic Views: 20030
    Quoting Lowpro:
    Quote:
    Quoting Lowpro:
    Quote:
    Looks like the "Video Formats\Dynamic Range" options (HDR10, Dolby Vision) have yet to be added.  Will try my hand at adding those tomorrow.  If I'm successful I'll chime back in.

    I updated my website today adding the "Dynamic Range" options.  End result shown below.

    Thanks a lot! I have to admit that I don't own any kind of 4K/UHD movies, so I'm having trouble to see what kind of features are pertinent to be added or not. 

    I'll update the github repository with your proposed changes soonish.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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 )
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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 )
    Posted:
    Topic Replies: 60, Topic Views: 20030
    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.
    Posted:
    Topic Replies: 60, Topic Views: 20030
    @wah_8: Switching the dbtype in your localsiteconfig.php to mysqli should help.

    For the others: I've been working yesterday on making phpDVDProfiler working again with PHP 7.2. I've published the newer version on either my website ( https://mudry.org/blog/post/2019/12/26/phpDVDProfiler-and-PHP-7.2 ) or GitHub ( https://github.com/julmud/phpDVDProfiler )
    Posted:
    Topic Replies: 60, Topic Views: 20030
    Invelos Forums->Posts by zeiram Page: 1  Previous   Next