From 2b50910bc8361e7a9ba99fe1e98b71f6be8dac6b Mon Sep 17 00:00:00 2001
From: Dobrica Pavlinusic <dpavlin@rot13.org>
Date: Fri, 28 Jan 2011 20:00:54 +0100
Subject: [PATCH] order by backup_part_id

---
 bin/BackupPC_ASA_SearchUpdate | 1 +
 lib/BackupPC/CGI/BurnMedia.pm | 1 +
 2 files changed, 2 insertions(+)

diff --git a/bin/BackupPC_ASA_SearchUpdate b/bin/BackupPC_ASA_SearchUpdate
index e39ffec..316b335 100755
--- a/bin/BackupPC_ASA_SearchUpdate
+++ b/bin/BackupPC_ASA_SearchUpdate
@@ -722,6 +722,7 @@ CREATE VIEW archive_backup_parts AS
 SELECT
 	backup_parts.backup_id,
 	archive_id,
+	backup_part_id,
 	hosts.name as host,
 	shares.name as share,
 	backups.num as num,
diff --git a/lib/BackupPC/CGI/BurnMedia.pm b/lib/BackupPC/CGI/BurnMedia.pm
index cabd592..c24a530 100644
--- a/lib/BackupPC/CGI/BurnMedia.pm
+++ b/lib/BackupPC/CGI/BurnMedia.pm
@@ -111,6 +111,7 @@ EOF
 				from archive_backup_parts a
 				join archive on archive_id = archive.id
 				where dvd_nr = ?
+				order by backup_part_id
 			});
 			$sth->execute( $dvd_nr );
 			$cont .= '<table border=1>';
-- 
2.20.1