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:
However, which file do I make the 1st suggestion changes in, for altering that table?

You need to execute them directly on the database, using a tool like phpMyAdmin for example. Please note that this action might well break the database auto-update feature from future releases.

If you'd prefer a more easier and turn-key solution, you can open an issue here, and I'll see if I can devote some time for a proper solution. But I can't promise you anything (either regarding the time frame, or if it'll indeed end up in the code base...)
Posted:
Topic Replies: 61, Topic Views: 22951
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: 61, Topic Views: 22951
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: 61, Topic Views: 22951
    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: 61, Topic Views: 22951
    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: 61, Topic Views: 22951
    Invelos Forums->Posts by zeiram Page: 1  Previous   Next