Help attaching file

BostonDan · May 5, 2013

Is anyone aware of a script that sends a file located in a subdirectory and then delete the file. I won't know the name of the file ahead of time, but it is the only file located in a specified directory.

My end goal is to couple two scripts back to back. Run the vTigerCRM backup process every day at 1:30am, placing the backup file in a specified directory and then run the PHP mailer script at 2:00am that mails the file and then deletes it off the server. I've looked at Backup2Mail as a code base to start from, but I know only enough PHP to follow the logic of other people's code, but not enough to author it myself. I can't figure out how to modify this to upload a file when I don't know the file name ahead of time.

Below is Backup2Mail licensed under the GNU GPL. In advance, I appreciate any thoughts on modifying this or finding another solution that achieves my goal.

<?php

$label = '

/***************************************************

Backup2Mail v0.18, 30. 06. 2010.

by Marko Dugonjic, http://www.backup2mail.com/

****************************************************/

';

/***************************************************

Database settings

****************************************************/

$db_server = 'localhost'; // Database server, usually "localhost",

// on (mt) servers something like internal-db.s12345.gridserver.com

$db_name = 'database'; // Database name, leave empty for 'all databases'

$db_user = 'username'; // Database username

$db_pass = 'password'; // Database password

/***************************************************

E-mail settings

****************************************************/

$website = 'backup2mail.com'; // Your site's domain (without www. part)

$send_to = 'you@gmail.com'; // backup file will be sent to?

$from = 'real.address@' . $website; // some hosting providers won’t let you send backups from invalid e-mail address

/***************************************************

Misc options

****************************************************/

$full_path = '/home/username/public_html';

// Full path to folder where you are running the script, usually "/home/username/public_html"

// (mt) servers have something like "/nfs/c01/h01/mnt/12345/domains/yourdomain.mobi/html/tools/backup2mail"

$delete_backup = true;

// delete gziped database from server after sending?

$send_log = true;

// send follow-up report?

// - true = send log file to an e-mail after each backup transfer

// - false = don't send log file, just leave it on the server

/***************************************************

If everything goes well, you shouldn't

modify anything below.

****************************************************/

error_reporting(E_ALL);

echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Backup2mail status [' . $website . ']</title>

</head>

<body>';

function date_stamp() {

global $html_output;

$backup_date = date('Y-m-d-H-i');

echo 'Database backup date: ' . $backup_date . '<br />';

return $backup_date;

}

function backup_filename() {

global $db_name, $date_stamp, $html_output;

$db_backup_filename = ($db_name == '' ? 'all_databases' : $db_name) . '_' . $date_stamp . '.sql.gz';

echo 'Database backup file: ' . $db_backup_filename . '<br />';

return $db_backup_filename;

}

function db_dump() {

global $db_server, $db_name, $db_user, $db_pass, $backup_filename, $html_output;

$cmd = 'mysqldump -u ' . $db_user . ' -h ' . $db_server . ' --password=' . $db_pass . ' ' . ($db_name == '' ? '--all-databases' : $db_name) . ' | gzip > ' . $backup_filename;

$dump_status = (passthru($cmd) === false) ? 'No' : 'Yes';

echo 'Command: ' . $cmd . '<br />';

echo 'Command executed? ' . $dump_status . '<br />';

return $dump_status;

}

function send_attachment($file, $file_is_db = true) {

global $send_to, $from, $website, $delete_backup, $html_output;

$sent = 'No';

$subject = 'MySQL backup - ' . ($file_is_db ? 'db dump' : 'report') . ' [' . $website . ']';

$boundary = md5(uniqid(time()));

$mailer = 'Sent by Backup2Mail © Marko Dugonjic, www.maratz.com, 2005-2009.';

$body = 'Database backup file:' . "\n" . ' - ' . $file . "\n\n";

$body .= '---' . "\n" . $mailer;

$headers = 'From: ' . $from . "\n";

$headers .= 'MIME-Version: 1.0' . "\n";

$headers .= 'Content-type: multipart/mixed; boundary="' . $boundary . '";' . "\n";

$headers .= 'This is a multi-part message in MIME format. ';

$headers .= 'If you are reading this, then your e-mail client probably doesn\'t support MIME.' . "\n";

$headers .= $mailer . "\n";

$headers .= '--' . $boundary . "\n";

$headers .= 'Content-Type: text/plain; charset="iso-8859-1"' . "\n";

$headers .= 'Content-Transfer-Encoding: 7bit' . "\n";

$headers .= $body . "\n";

$headers .= '--' . $boundary . "\n";

$headers .= 'Content-Disposition: attachment;' . "\n";

$headers .= 'Content-Type: Application/Octet-Stream; name="' . $file . "\"\n";

$headers .= 'Content-Transfer-Encoding: base64' . "\n\n";

$headers .= chunk_split(base64_encode(implode('', file($file)))) . "\n";

$headers .= '--' . $boundary . '--' . "\n";

if (mail($send_to, $subject, $body, $headers)) {

$sent = 'Yes';

echo ($file_is_db ? 'Backup file' : 'Report') . ' sent to ' . $send_to . '.<br />';

if ($file_is_db) {

if ($delete_backup) {

unlink($file);

echo 'Backup file REMOVED from disk.<br />';

} else {

echo 'Backup file LEFT on disk.<br />';

}

} else {

echo '<span style="color: #f00;">' . ($file_is_db ? 'Database' : 'Report') . ' not sent! Please check your mail settings.</span><br />';

}

echo 'Sent? ' . $sent;

return $sent;

}

function write_log() {

global $backup_filename, $date_stamp, $send_log, $label, $full_path;

$log_file = $full_path . '/backup_log.txt';

if (!$handle = fopen($log_file, 'a+')) exit;

if (chmod($log_file, 0644) && is_writable($log_file)) {

echo '<h2>Mysqldump...</h2>';

$dumped = db_dump();

echo '<h2>Sending db...</h2>';

$log_content = "\n" . $date_stamp . "\t\t\t" . $dumped . "\t\t\t" . send_attachment($backup_filename);

echo '<h2>Writing log...</h2>';

$log_header = '';

if (filesize($log_file) == '0') {

$log_header .= $label . "\n\n";

$log_header .= 'Backup log' . "\n";

$log_header .= '----------------------------------------------' . "\n";

$log_header .= 'DATESTAMP: DUMPED MAILED' . "\n";

$log_header .= '----------------------------------------------';

if (fwrite($handle, $log_header) === false) exit;

}

echo 'Log header written: ';

if (fwrite($handle, $log_header) === false) {

echo 'no<br />' . "\n";

exit;

} else {

echo 'yes<br />' . "\n";

}

echo 'Log status written: ';

if (fwrite($handle, $log_content) === false) {

echo 'no<br />' . "\n";

exit;

} else {

echo 'yes<br />' . "\n";

}

fclose($handle);

if ($send_log) {

echo '<h2>Sending log...</h2>';

send_attachment($log_file, false);

}

echo '<h2>Setup</h2>';

$date_stamp = date_stamp();

$backup_filename = backup_filename();

$init = write_log();

echo '<br /><br />...<br /><br />If all letters are green and you received the files, you\'re good to go!<br />Remove '#' from this folder’s .htaccess file NOW.</body></html>';

?>

Sign In

Help attaching file

Recommended Posts

BostonDan

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information