added dvd_nr to archive_backup_parts

[BackupPC.git] / lib / BackupPC / CGI / BurnMedia.pm

diff --git a/lib/BackupPC/CGI/BurnMedia.pm b/lib/BackupPC/CGI/BurnMedia.pm
index cabd592..6b2870b 100644 (file)
--- a/lib/BackupPC/CGI/BurnMedia.pm
+++ b/lib/BackupPC/CGI/BurnMedia.pm
@@ -106,11 +106,11 @@ 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
                        });
                        $sth->execute( $dvd_nr );
                        $cont .= '<table border=1>';