Changeset 748 for trunk/app/controllers

Timestamp:

09/02/08 17:38:47 (3 months ago)

Author:

aarkerio

Message:

backups scripts

Location:

trunk/app/controllers

Files:

• treasures_controller.php (modified) (2 diffs)
• users_controller.php (modified) (2 diffs)

trunk/app/controllers/treasures_controller.php

@@ -27 +27 @@
  *
  */
- 
  public function chksw()
  {
@@ -107 +106 @@
   $this->layout    = $this->Edublog->layout($data['Treasure']['user_id']);
       
-  $this->pageTitle = 'Treasure Hunt';
+  $this->pageTitle = __('Scavengers hunts', true);
       
   $this->Edublog->blog($data['Treasure']['user_id']); // blogger elements

trunk/app/controllers/users_controller.php

@@ -540 +540 @@
     $this->set('data', $this->User->findAll($conditions));       
  }
+
  /**
  *
@@ -547 +548 @@
  public function admin_backup() 
  {
-     
-   $output_file = sprintf($DB_NAME."_%s.db", date("Ymd-hi"));
-   $DB_EXPORT_PATH ='';
-   system("pg_dump -u ".$DB_NAME." < ".AUTH_USER_FILE_PATH." > ".DB_EXPORT_PATH.$output_file);
+   $DB_NAME = (string) 'DBKARAMELO';
+   $DB_USER = (string) 'postgres';
+   $output_file = sprintf($DB_NAME."_%s.sql", date("Ymd-hi"));
+   $DB_EXPORT_PATH ='/tmp';
+   $command = (string) "pg_dump ".$DB_NAME." -O -U ".$DB_USER." -f ".$DB_EXPORT_PATH.'/'.$output_file; 
+   //die($command);
+   exec($command);
+   $karamelo_path = (string) '/var/chipotle/sites/karamelo/sugus/webroot';
+   $tar_file = sprintf('KARAMELO_'."_%s.tar", date("Ymd-hi"));
+   $command = (string) 'tar -rvf '. $DB_EXPORT_PATH .'/'. $tar_file .' '.$karamelo_path;
+   exec($command);
+   
+   $command = (string) 'tar -rvf '. $DB_EXPORT_PATH .'/'. $tar_file . ' '. $DB_EXPORT_PATH.'/'.$output_file;
+   exec($command);
+   $tgz_file = $tar_file.'.gz';
+   $command = (string) 'tar -czvf '.$DB_EXPORT_PATH .'/'.$tgz_file.' '.$DB_EXPORT_PATH.'/'.$tar_file; 
+   exec($command);
+   unlink($DB_EXPORT_PATH.'/'.$output_file);
+   unlink($DB_EXPORT_PATH.'/'.$tar_file);
+   //die($tgz_file);
    $this->autoRender = false;
    Configure::write('debug', 0);
-   header("Content-disposition: attachment; filename=".$output_file);
-   header("Content-type: application/octet-stream; name=".$output_file);
-   $result = file_get_contents(DB_EXPORT_PATH.$output_file);
-   print($result);
+   header('Content-type: application/x-compressed');
+   header("Content-disposition: attachment; filename=".$tgz_file);
+   header("Content-type: force-download; name=".$tgz_file);
+   header("Content-Transfer-Encoding: binary");
+   header("Cache-Control: no-cache, must-revalidate");
+   header("Pragma: no-cache");
+   
+   readfile($DB_EXPORT_PATH .'/'.$tgz_file);
+   //$file=fopen($DB_EXPORT_PATH .'/'.$tgz_file,”r”);
+   //fpassthru($file);
+   //fclose($file);
+
+   //delete temporary files
+   //unlink($DB_EXPORT_PATH.'/'.$tgz_file);
+
    return true;
  }