/[BackupPC]/trunk/lib/BackupPC/SearchLib.pm
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /trunk/lib/BackupPC/SearchLib.pm

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 165 by dpavlin, Mon Oct 10 13:39:13 2005 UTC revision 166 by dpavlin, Mon Oct 10 14:04:49 2005 UTC
# Line 343  sub getBackupsNotBurned() { Line 343  sub getBackupsNotBurned() {
343                  INNER JOIN shares       ON backups.shareID=shares.ID                  INNER JOIN shares       ON backups.shareID=shares.ID
344                  INNER JOIN hosts        ON backups.hostID = hosts.ID                  INNER JOIN hosts        ON backups.hostID = hosts.ID
345                  LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id                  LEFT OUTER JOIN archive_backup ON archive_backup.backup_id = backups.id
346                  WHERE backups.size > 0 AND backups.inc_size > 0 AND archive_backup.backup_id IS NULL                  WHERE backups.size > 0 AND backups.inc_size > 0 AND backups.inc_deleted is false AND archive_backup.backup_id IS NULL
347                  GROUP BY                  GROUP BY
348                          backups.hostID,                          backups.hostID,
349                          hosts.name,                          hosts.name,
# Line 366  sub getBackupsNotBurned() { Line 366  sub getBackupsNotBurned() {
366                  $row->{'size'} = sprintf("%0.2f", $row->{'size'} / 1024 / 1024);                  $row->{'size'} = sprintf("%0.2f", $row->{'size'} / 1024 / 1024);
367    
368                  # do some cluster calculation (approximate) and convert to kB                  # do some cluster calculation (approximate) and convert to kB
369                  $row->{'inc_size'} = int($row->{'inc_size'} / ( 2 * 1024) * 2);                  $row->{'inc_size'} = int(($row->{'inc_size'} + 1023 ) / ( 2 * 1024 ) * 2);
370                  push @ret, $row;                  push @ret, $row;
371          }          }
372                
Legend:
Removed from v.165  
changed lines
  Added in v.166
  ViewVC Help
Powered by ViewVC 1.1.26