X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=blobdiff_plain;f=lib%2FBackupPC%2FCGI%2FBurnMedia.pm;fp=lib%2FBackupPC%2FCGI%2FBurnMedia.pm;h=6b2870b52ef8afe5b9ab9b0ea760a6a478ed88be;hp=c24a5308eb06df2c8b0dcb9eff35f7922ab50df6;hb=488bb662f6d144d42376b3d14e9b1e438e00e6f8;hpb=2b50910bc8361e7a9ba99fe1e98b71f6be8dac6b;ds=sidebyside diff --git a/lib/BackupPC/CGI/BurnMedia.pm b/lib/BackupPC/CGI/BurnMedia.pm index c24a530..6b2870b 100644 --- a/lib/BackupPC/CGI/BurnMedia.pm +++ b/lib/BackupPC/CGI/BurnMedia.pm @@ -106,10 +106,9 @@ EOF select filename, part_nr, - TIMESTAMP 'epoch' + a.date * INTERVAL '1 second' as date, + TIMESTAMP 'epoch' + date * INTERVAL '1 second' as date, size - from archive_backup_parts a - join archive on archive_id = archive.id + from archive_backup_parts where dvd_nr = ? order by backup_part_id });