Collum value for picture table Collum value for picture table
 

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Main Menu

Collum value for picture table

Started by jan-hillebrand, February 18, 2007, 01:20:30 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jan-hillebrand

Hi.

I'm currently writing a Java application, which makes it possible to create albums, upload and add pictures to the galery remotely.

Everthing works fine so far, but I just couldn't work out, which value to put in the ctime collum of the pictures table. I've already figuered out, that this indicates the time when the picture was added to the galery, but it actually doesn't represent the time in millisecs from 1.1.1970, so I'm wondering, how I get an appropriate value for this row?
Also I guessed, that the total_filesize collum is representing the sum of the size of the original file, the "normal_"-file and the thumbnail, while filesize is just representing the size of the original picture, is that correct?

Thanks!
Jan.

Nibbler

ctime is actually a unix timestamp, and the total_filesize is correct, yes.

jan-hillebrand