<?php
require_once 'config.php';

$file = $argv[1];
$a_data = explode("\n",file_get_contents($file));

foreach($a_data as $data){

	echo "BACKUP DB ".$data.PHP_EOL;
	$file_backup_db_raw = $data."_diff_";
	$file_backup_db = $temp_dir."\\".$file_backup_db_raw.time();

	unlink($file_backup_db.'.bak');

	$sql = "BACKUP DATABASE [".$data."] TO DISK = '".$file_backup_db.".bak' WITH FORMAT, DIFFERENTIAL, INIT, COMPRESSION";

	$cmd = 'sqlcmd -S '.$db_host.','.$db_port.' -U '.$db_user.' -P '.$db_pass.' -Q "'.$sql.'"';

	passthru($cmd);

	$cmd = 'pscp -P '.escapeshellarg($ssh_port).' -pw '.escapeshellarg($ssh_pass).' '.escapeshellarg($file_backup_db.'.bak').' '.escapeshellarg($ssh_user).'@'.escapeshellarg($ssh_host).':'.escapeshellarg($ssh_dir);
	passthru($cmd);

	unlink($file_backup_db.'.bak');


	// hapus data yang di server yang lama2

	$cmd = 'plink -P '.$ssh_port.' -ssh -batch -pw '.$ssh_pass.' '.$ssh_user.'@'.$ssh_host.' "ls '.$ssh_dir.'/'.$file_backup_db_raw.'*"';
	//echo $cmd.PHP_EOL;

	exec($cmd, $output, $return_var);

	if($return_var === 0){
		rsort($output);
		$iterator = 0;
		foreach($output as $file){
			$iterator++;
			
			if($iterator > $max_file_full){
				echo "menghapus ".$file.PHP_EOL;
				$cmd = 'plink -P '.$ssh_port.' -ssh -batch -pw '.$ssh_pass.' '.$ssh_user.'@'.$ssh_host.' "rm '.$file.'"';
				passthru($cmd);
			}
		}
	}else{
		var_dump($output);
		die();
	}

	unset($return_var);
	unset($output);
	
}

unlink($file);