Collum value for picture table Collum value for picture table
 

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

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 2 Guests 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