- Remove non-existing backups from web_backup table.

ftimme

2013-09-20 e7e9a52551103099a00de25c0aab6ff68a540c9b

 server/cron_daily.php

@@ -1194,7 +1194,6 @@
            }
            
            $app->system->web_folder_protection($web_path,true);

         }

         /* If backup_interval is set to none and we have a
@@ -1296,6 +1295,19 @@
      unset($clientdb_password);

   }
	
   // remove non-existing backups from database
   $backups = $app->db->queryAllRecords("SELECT * FROM web_backup WHERE server_id = ".$conf['server_id']);
   if(is_array($backups) && !empty($backups)){
      foreach($backups as $backup){
         $backup_file = $backup_dir.'/web'.$backup['parent_domain_id'].'/'.$backup['filename'];
         if(!is_file($backup_file)){
            $sql = "DELETE FROM web_backup WHERE server_id = ".$conf['server_id']." AND parent_domain_id = ".$backup['parent_domain_id']." AND filename = '".$backup['filename']."'";
            $app->db->query($sql);
            if($app->db->dbHost != $app->dbmaster->dbHost) $app->dbmaster->query($sql);
         }
      }
   }
}