From: dpavlin <dpavlin@8392b6e1-25fa-0310-8288-cc32f8e212ea>
Date: Mon, 11 Jul 2005 14:58:54 +0000 (+0000)
Subject: fixed join with backups to show just increments
X-Git-Url: http://git.rot13.org/?p=BackupPC.git;a=commitdiff_plain;h=dfad38566876d713adf6356759d6739a0f4d176e

fixed join with backups to show just increments


git-svn-id: svn+ssh://llin/home/dpavlin/private/svn/BackupPC/trunk@20 8392b6e1-25fa-0310-8288-cc32f8e212ea
---

diff --git a/lib/BackupPC/SearchLib.pm b/lib/BackupPC/SearchLib.pm
index 8334075..06ae268 100644
--- a/lib/BackupPC/SearchLib.pm
+++ b/lib/BackupPC/SearchLib.pm
@@ -87,7 +87,7 @@ sub getFiles($$)
 		FROM files 
 			INNER JOIN shares	ON files.shareID=shares.ID
 			INNER JOIN hosts	ON hosts.ID = shares.hostID
-			INNER JOIN backups	ON backups.num = files.backupNum
+			INNER JOIN backups	ON backups.num = files.backupNum and backups.hostID = hosts.ID
 			LEFT  JOIN dvds		ON dvds.ID = files.dvdid
 	  };