MySQL backup mod for sNews

My newest mod is a solution to back-up your sNews MySQL database from directly within your sNews administration interface. Rather than just spit out a backup in raw .sql, this mod allows you to compress the file using gzip, bzip2, or even in a password protected zip file, and will email the file to your site administration email address if you choose. You can also view existing backups within your local backup folder, and delete them if you so choose.

This will not work with PHP in safe mode.

Here's a preview (partially obfuscated 'cause I'm paranoid, lol) of what the interface looks like;

Now download the mod file below;

Extract the zip file, and modify the $backup_path in mod.backup.php file to point to the directory you want to use on your server for your backups. Now upload mod.backup.php to the same folder as your snews.php file.

Now lets BACK-UP your snews.php file and work off of a copy.

1. Find the hard coded link items;

$l['cat_listSEF'] = 'archive,contact,sitemap,login,administration,admin_category,admin_article,article_new,extra_new,page_new,snews_categories,snews_articles,extra_contents,snews_pages,snews_settings,snews_files,logout,groupings,admin_groupings';

now we need to add the "snews_backups" page, as in the highlighted code;

$l['cat_listSEF'] = 'archive,contact,sitemap,login,administration,admin_category,admin_article,article_new,extra_new,page_new,snews_backups,snews_categories,snews_articles,extra_contents,snews_pages,snews_settings,snews_files,logout,groupings,admin_groupings';

2. now in the function center, add the following highlighted code, near the end of the function;

case 'snews_files':
    files(); return; break;
case 'snews_backups':
     backups(); return; break;
case 'process':
     processing(); return; break;

3. now in the function administration, add the following highlighted code;

echo '<p><a href="snews_settings/">'.l('settings').'</a></p>
      <p><a href="snews_files/">'.l('files').'</a></p>
      <p><a href="snews_backups/">'.l('backups').'</a></p>
      </fieldset></div>
      <div class="adminpanel">';

4. now copy this backups() function into your snews.php file, just above the closing php tag;

// BACKUPS
function backups() {
    if (file_exists('mod.backup.php')) {
        include_once('mod.backup.php');
        dobackup();
    } else {
        echo "<h2>Oops!</h2><p>I couldn't find the mod file!</p>";
    }
}

5. now open your language file (EN.php in the lang folder), and add the following code block;

#MySQL Backup mod
$l['backups'] = 'Manage MySQL backups';
$l['snews_backups'] = 'MySQL Backups';
$l['create_backup'] = 'Create a Backup';
$l['comp_options'] = 'Compression options:';
$l['comp_zip'] = 'zip';
$l['comp_bzip2'] = 'bzip2';
$l['comp_gzip'] = 'gzip';
$l['comp_none'] = 'none';
$l['backup_password'] = 'Add a password to the zip file';
$l['backup_password2'] = 'Please verify the password';
$l['password_mismatch'] = 'Passwords don\'t match!';
$l['view_backups'] = 'Your local backups in ';
$l['email_backup'] = 'Email a copy of this backup to ';
$l['backup'] = 'Create Backup';
$l['backup_success'] = ' success!';
$l['comp_attempt'] = 'Attempting to compress database file with';
$l['comp_failure'] = ' compression failed!';
$l['email_attempt'] = 'Attempting to email backup file to ';
$l['email_failure'] = ' failed to email file';
$l['email_subject'] = 'Your backup file from ';
$l['operation_time'] = 'operation completed in ';
$l['no_backups'] = 'No backups exist yet';

6. now open your stylesheet and add the following code;

.highlight {background:#ffff88}

7. That's all, now upload your modified language file, stylesheet, and then your snews.php file. Now access the admin section of your sNews installation and you should have the option to manage your mysql database backups. I recommend using the zip option with a strong (non-dictionary) password if you're going to email yourself the files, just in case someone intercepts the file.