[MOD] Simple MySQL Backup v0.1 (no system calls)

Information:
MOD name: Simple MySQL Backup v.01 (no system calls)
sNews version: v1.6

Function: With this mod you can create a compressed file backup of your current database from your administration panel by one click. The system ask to you a valid email address to send to you a copy of a compressed dabatase file. The backup of the database include database structure and data, all ready to be uploaded into your website if you get a disaster.

Updates:
- Fixed step 2. Thanks to Philmoz!
- Added info to chmod 777 database folder.
- Fixed, in the step 6, an error related to e-mail to user.

Quote

This is my second version of this mod (without system calls, my previous one are in the sNews 1.5.31 mod section).

Important note:

Quote

If your hosting provider don't support gZip compression your database backup will be saved in a plain text.

So... let's go!

Step #1:
Create a backup of your snews.php file... as you know! Wink

Next, make a folder into the root of your sNews installation to store your database backups and chmod it to 777, in this mod, I've named it as _backups_ but I recommend to you to use a better name folder with alphanumerical / upper and lower case characters like: M1b4ckUp2007 for example and put inside of this folder an empty index.html file to list protection. (hey! this is not a great protection in any case, but is a minimal option for protect your folder).

Create a set of language variables used in this mod:

Quote

//MOD START: DBBackup by bramsyuur
 $l['t_dbbackup'] = 'Database Backup';
 $l['t_dbbackup_info'] = 'Please, first, provide a \' backup name\' for the database and, next, verify or moddify the e-mail that your want to be used to get the database backup file.
';
 $l['t_dbbackup_name'] = 'Database name';
 $l['t_dbbackup_email'] = 'E-mail to send your created backup';
 $l['t_backup'] = 'Backup now';
 $l['t_system_mail'] = 'System DB-Backup <admin@your.domain.com>'; // <--- Please, check this e-mail address to meet your needs!!
 $l['t_dbb_subject'] = 'MySQL Backup';
 $l['t_dbb_message'] = 'MySQL Backup created successfully.';
 $l['db_backup_directory'] = 'Currently Backup Files';
 $l['db_no_files_found'] = 'No files found!';
 //MOD END

Step #2:
Into "#SYSTEM VARIABLES (not to be translated)" locate:

Code:

$l['cat_listSEF'] = $l['home_sef'].',archive,contact,sitemap,rss-articles,rss-pages,rss-comments,login,administration,admin_category,admin_article,article_new,extra_new,page_new,categories,articles,extra_contents,pages,settings,files,logout'; //SEF links of the hardcoded categories

and replace with:

Code:

Step #3:
Inside the "function center()" locate "case 'settings': settings(); return; break;" and just next to it, put:

Quote

//MOD START: DBBackup by bramsyuur
case 'dbbackup': dbbackup(); return; break;
//MOD END

Step #4:
Find, inside "function administration()" this line:

Quote

echo '<a href="settings/" title="'.l('settings').'">'.l('settings').'</a>';

And add next to it, this:

Quote

//MOD START: DBBackup by bramsyuur
echo '<a href="dbbackup/" title="'.l('t_dbbackup').'">'.l('t_dbbackup').'</a>';
//MOD END

Step #5:
Next, few lines down, under the same function (function administration()) locate "}}" and, next to it, add:
Remember: Change _backups_ with your created backup folder!!!!

Code:

//MOD START: DBBackup by bramsyuur
function dbbackup() {
echo html_input('form', '', '', '', '', '', '', '', '', '', '', '', 'post', 'index.php?action=process&task=dbbackup_start', '');
echo html_input('fieldset', '', '', '', '', '', '', '', '', '', '', '', '', '','<a title="'.l('t_dbbackup').'">'.l('t_dbbackup').'</a>');
echo l('t_dbbackup_info');
echo html_input('text', 't_dbbackup_name', 't_dbbackup_name', db('dbname'), l('t_dbbackup_name'), '', '', '', '', '', '', '', '', '', '');
echo html_input('text', 't_dbbackup_email', 'tdbm', s('website_email'), l('t_dbbackup_email'), '', '', '', '', '', '', '', '', '', '');
echo '
';
echo html_input('submit', 'do_backup', 'do_backup', l('t_backup'), '', 'button', '', '', '', '', '', '', '', '', '');
echo '

'.l('db_backup_directory').':';
 dbbackup_files("_backups_"); // REMEMBER: Change _backups_ with your created backup folder!!!!
echo '</fieldset></form>';
}

function email_att ($from , $to, $subject, $message, $attachment){
$fileatt = $attachment;
$fileatt_type = "application/octet-stream";
 $start= strrpos($attachment, '/') == -1 ? strrpos($attachment, '//') : strrpos($attachment, '/')+1;
$fileatt_name = substr($attachment, $start, strlen($attachment));
$email_from = $from;
$email_subject = $subject;
$email_txt = $message;
$email_to = $to;
$headers = "From: ".$email_from;
$file = fopen($fileatt,'rb');
$data = fread($file,filesize($fileatt));
fclose($file);
$msg_txt="\n\n";
$semi_rand = md5(time());
$mime_boundary = "==Multipart_Boundary_x{$semi_rand}x";
$headers .= "\nMIME-Version: 1.0\n" .
 "Content-Type: multipart/mixed;\n" .
 " boundary=\"{$mime_boundary}\"";
$email_txt .= $msg_txt;
$email_message .= "This is a multi-part message in MIME format.\n\n" .
 "--{$mime_boundary}\n" .
 "Content-Type:text/html; charset=\"iso-8859-1\"\n" .
 "Content-Transfer-Encoding: 7bit\n\n" .
$email_txt . "\n\n";
$data = chunk_split(base64_encode($data));
$email_message .= "--{$mime_boundary}\n" .
 "Content-Type: {$fileatt_type};\n" .
 " name=\"{$fileatt_name}\"\n" .
 "Content-Transfer-Encoding: base64\n\n" .
 $data . "\n\n" .
 "--{$mime_boundary}--\n";
$ok = @mail($email_to, $email_subject, $email_message, $headers);
if($ok) {
} else {
die("Sorry but the email could not be sent. Please go back and try again!");
}
}

function PrintOut($output,$tbl,$stats) {
 $output = "--\n-- Table structure for `$tbl`\n--\n\nCREATE TABLE `$tbl` ( ";
 $res = mysql_query("SHOW CREATE TABLE $tbl");
 while($al = mysql_fetch_assoc($res)) {
$str = str_replace("CREATE TABLE `$tbl` (", "", $al['Create Table']);
$str = str_replace(",", ",", $str);
$str2 = str_replace("`) ) TYPE=MyISAM ", "`)\n ) TYPE=MyISAM ", $str);
if ($stats) $str2 = $str2." AUTO_INCREMENT=".$stats;
$output .= $str2.";\n\n";
}
$output .= "-- \n-- Dumping data for table `".$tbl."`\n-- \n\n";
 $data = mysql_query("SELECT * FROM $tbl");
 while($dt = mysql_fetch_row($data)) {
$output .= "INSERT INTO `$tbl` VALUES('$dt[0]'";
for($i=1; $i<sizeof($dt); $i++) {
$dt[$i] = mysql_real_escape_string($dt[$i]);
$output .= ", '$dt[$i]'";
}
$output .= ");\n";
 }
 $output .= "\n-- --------------------------------------------------------\n\n";
 return $output;
}

function dbbackup_files($path) {
 $ignore = array('index.html', 'index.htm', 'index.php', 'cgi-bin', '.htaccess', '.', '..', 'Thumbs.db');
 $extension = array('.sql', '.sql.gz');
 $dh = @opendir($path);
 if (count(glob("$path".'/*.gz')) === 0) { echo ''.l('db_no_files_found').''; }
 while (false !== ($file = readdir($dh))) {
 if(!in_array($file, $ignore) && !in_array(substr($file, -4), $extension)) {
 echo '· <a href="'.db('website').$path.'/'.$file.'">'.$file.'</a> ';
 }
 }
 closedir($dh);
}
//MOD END: DBBackup by bramsyuur

Step #6:
Finally, locate under "function processing()" the last "break;" at the end and next to it, add:
Remember: Change _backups_ with your created backup folder!!!!

Code:

//MOD START: DBBackup by bramsyuur
case 'dbbackup_start':
if (isset($_POST['do_backup'])) {
$mdb = db('dbname');
$mhost = db('dbhost');
$muser = db('dbuname');
$mpass = db('dbpass');
$dbackup_name = $_POST['t_dbbackup_name'];
$tables = array();
$pathname = "_backups_"; // REMEMBER: Change _backups_ with your created backup folder!!!!
$timestamp = '.'.date('d-m-Y');
$absolute_path = dirname(__FILE__).DIRECTORY_SEPARATOR.$pathname.DIRECTORY_SEPARATOR;
$filename = $dbackup_name.$timestamp.".sql.gz";
$temp = $dbackup_name.".sql.gz";
$gz = (bool) function_exists('gzopen');
if(!is_dir($pathname) || substr(sprintf('%o', fileperms($pathname)), -4) !="0777") {
echo "Directory '".$pathname."' either doesn't exist or you need to chmod it to 777";
exit;
}
$fileheader = "# mySQL backup ".$today."\n# Server: ".$_SERVER['SERVER_NAME']."\n# Database: ".$mdb."\n\n";
ob_start();
flush();
unset($backup);
$backup = "";
$tab_status = mysql_query("SHOW TABLE STATUS");
if (!$tab_status) {
   echo "Error: Could not show table status! \n";
   echo 'MySQL Error: ' . mysql_error();
   exit;
}
while($all = mysql_fetch_assoc($tab_status)) {
   $tbl_stat[$all['Name']] = $all['Auto_increment'];
}
if(count($tables) == 0) {
$tables = mysql_query("SHOW TABLES FROM $mdb");
if (!$tables) {
echo "Error: Could not list tables! \n";
echo "MySQL Error: " . mysql_error();
exit;
}
while($tabs = mysql_fetch_row($tables)) {
$backup .= PrintOut($backup,$tabs[0],$tbl_stat[$tabs[0]]);
}
} else {
foreach($tables as $table) {
$show_query ="SHOW TABLE STATUS FROM $mdb LIKE '$table'";
$show = mysql_query($show_query);
if (!$show) {
echo "Error: Could not show ".$table." \n";
echo "MySQL Error: ". mysql_error()."\n";
exit;
}
while($tabs = mysql_fetch_row($show)) {
$backup .= PrintOut($backup,$tabs[0],$tbl_stat[$tabs[0]]);
}
}
}
if (($gz && ($zp = gzopen($absolute_path.$temp, 'wb'))) || (!$gz && ($fp = fopen($absolute_path.$temp, 'wb')))) {
if ($gz) gzwrite($zp, $fileheader, strlen($fileheader));
else fwrite($fp, $fileheader, strlen($fileheader));
}
if ($gz) {
gzwrite($zp, $backup);
gzwrite($zp, "\n\n--\n-- Backup complete! --\n--\n");
gzclose($zp);
} else {
fwrite($fp, $backup);
fwrite($fp, "\n\n--\n-- Backup complete! --\n--\n");
fclose($fp);
}
$final = $absolute_path.$filename;
@unlink($final);
rename($absolute_path.$temp, $final);
if (strtoupper(substr(PHP_OS, 0, 3)) != 'WIN') touch($final);
$dbb_to = $_POST['t_dbbackup_email'];
$dbb_from = l('t_system_mail');
$dbb_subject = l('t_dbb_subject');
$dbb_message = l('t_dbb_message');
$dbb_attachment = $absolute_path . $filename;
email_att ($dbb_from , $dbb_to, $dbb_subject, $dbb_message, $dbb_attachment);
ob_end_flush();
echo notification(0,'','administration');
}
break;
//MOD END

And this is all!

If you want, you can test it here: (user and password: test
http://snews.vietbee.net/demos/sNews16/
And here's an example image:

Thanks for using it!