<?php
backup('notecms', 'root');
function backup($name, $user, $pass = NULL) {
  $filename='/note_db_backup_'.date('G_a_m_d_y').'.sql';
  if ($pass == NULL) {
    $result=exec('mysqldump notecms --single-transaction --user='. $user .' -r '. $filename . ' 2>&1', $output, $return_var);
  }
  else {
    $result=exec('mysqldump notecms --single-transaction --user='. $user .' -p='. $pass .' -r '. $filename . ' 2>&1', $output, $return_var);
  }
  if($return_var == 0){
    //return 0;
    if (!chmod($filename, 0600)) {
      die('could not change backup permissions');
    }
    deleteold();
  }
  else {
    print_r($output);
    global $backup_output;
    $backup_output = $output;
    //return 1;
  }
}

function deleteold() {
  $filecount = count(scandir("../backup/")) - 2;
  if ($filecount > 5) {
    $files = glob( '../backup/*' );
    array_multisort(
    array_map( 'filemtime', $files ),
    SORT_NUMERIC,
    SORT_ASC,
    $files
    );
    unlink($files[0]);
  }
}
?>