<?php
/**
Backup the database of a given WordPress site.
*/

$site_url = 'http://yoursite.com'; //The URL of the online wordpress site
$username = 'admin'; // Admin username
$password = 'not_my_password'; // Admin password

$sync_with_local = false; // If you have a local server running and a copy of your site in it, your can use this script to automatically sync the online version with the local one. Set this to true if you want that. If this is set to false, it will just create and download the backup
// The following configuration options are needed only if $sync_with_local is set to true
$local_url = 'http://localhost/your_local_site'; //The url of the local site
$local_db_server = 'localhost'; // Mysql database server
$local_db_username = 'root'; // Mysql username
$local_db_password = ''; // Mysql password
$local_db = 'site_database_name'; // The database name for the local wordpress.

////////////// Stop Editing ////////////////////

// Login to wordpress
print "Logging into WordPress ... ";
$result = load($site_url."/wp-login.php?log=$username&pwd=" . urlencode($password) ."&wp-submit=Log In&testcookie=1", array('method'=>'post','return_info'=>true, 'curl_handle'=>false));

if(!$result['body']) { // The returned page was empty
	file_put_contents('Debug/login.html', $result['body']);
	print "WordPress not found at the specified location($site_url) - exiting...\n";
	exit;
}
if($result['info']['url'] != $site_url . '/wp-admin/') { //The redirection was not proper.
	file_put_contents('Debug/login.html', $result['body']);
	print "Invalid Username or Password given for $site_url. Please correct it.\n";
	exit;
}

print "done. Creating a backup ... \n";
$backup = load($site_url.'/wp-admin/edit.php?page=remote-database-backup/backup.php&exclude-spam[]=wp_comments&action=Backup', array('method'=>'get','return_info'=>true, 'curl_handle'=>$result['curl_handle'])); //Create a backup of the core tables
curl_close($backup['curl_handle']);

if(preg_match('/id="download-url" href="([^"]+)">/', $backup['body'], $download_url)) {
	print "Done. Downloading $download_url[1] ...\n";
} else { // Backup file's Download link was not found.
	file_put_contents('Debug/backup.html', $backup['body']);
	print "Download file not found - exiting...\n";
	exit;
}

$database_dump = load($download_url[1]); //Download the backup file.
$parts = array_reverse(explode('/', $download_url[1]));
$file_name = $parts[0]; //Gets the last part - we reversed the array.

print "Done. Saving it to file ... ";
file_put_contents($file_name, $database_dump); //Save it to file
print "Done\n";

if($sync_with_local) {
	print "Syncing with Local database ... ";
	`gzip -cd $file_name > tmp.sql`;
	`mysql -h $local_db_server -u $local_db_username $local_db_password $local_db < tmp.sql`;
	unlink('tmp.sql');
	rename($file_name, "Dumps/$file_name");
	
	mysql_connect($local_db_server,$local_db_username,$local_db_password);
	mysql_select_db($local_db);
	mysql_query("UPDATE wp_options SET option_value='$local_url' WHERE option_name='siteurl'");
	mysql_query("UPDATE wp_options SET option_value='$local_url' WHERE option_name='home'");
	mysql_query("UPDATE wp_users SET user_pass=MD5('admin') WHERE user_login='admin'");
	print "Done\n";
}
print "All Done\n";


/////////////////// Library Functions //////////////////////////
/**
 * Link: http://www.bin-co.com/php/scripts/load/
 * Version : 2.00.A
 */
function load($url,$options=array()) {
	if(!isset($options['method'])) $options['method'] = 'get';
	if(!isset($options['return_info'])) $options['return_info'] = false;
	if(!isset($options['cache'])) $options['cache'] = false;

    $url_parts = parse_url($url);
    $ch = false;
    $info = array(//Currently only supported by curl.
        'http_code'    => 200
    );
    $response = '';
    
    $send_header = array(
        'Accept' => 'text/*',
        'User-Agent' => 'BinGet/1.00.A (http://www.bin-co.com/php/scripts/load/)'
    );
    
    if($options['cache']) {
    	$cache_folder = '/tmp/php-load-function/';
    	if(!file_exists($cache_folder)) mkdir($cache_folder, 0777);
    	if(isset($options['cache_folder'])) $cache_folder = $options['cache_folder'];
    	
    	$cache_file_name = str_replace(array('http://', 'https://'),'', $url);
    	$cache_file_name = str_replace(
    		array('/','\\',':','?','&','='), 
    		array('_','_','-','.','-','_'), $cache_file_name);
    	$cache_file = joinPath($cache_folder, $cache_file_name); //Don't change the variable name - used at the end of the function.
    	
    	if(file_exists($cache_file)) { // Cached file exists - return that.
    		if(!$options['return_info']) return file_get_contents($cache_file);
    		else return array('headers' => array('cached'=>true), 'body' => file_get_contents($cache_file), 'info' => array('cached'=>true));
    	}
    }

    ///////////////////////////// Curl /////////////////////////////////////
    //If curl is available, use curl to get the data.
    if(function_exists("curl_init") 
                and (!(isset($options['use']) and $options['use'] == 'fsocketopen'))) { //Don't use curl if it is specifically stated to use fsocketopen in the options
        
        if(isset($options['post_data'])) { //There is an option to specify some data to be posted.
        	$page = $url;
        	$options['method'] = 'post';
        	
        	if(is_array($options['post_data'])) { //The data is in array format.
				$post_data = array();
				foreach($options['post_data'] as $key=>$value) {
					$post_data[] = "$key=" . urlencode($value);
				}
				$url_parts['query'] = implode('&', $post_data);
			
			} else { //Its a string
	        	$url_parts['query'] = $options['post_data'];
			}
        } else {
			if(isset($options['method']) and $options['method'] == 'post') {
				$page = $url_parts['scheme'] . '://' . $url_parts['host'] . $url_parts['path'];
			} else {
				$page = $url;
			}
		}

        if(!isset($options['curl_handle']) or !$options['curl_handle']) $ch = curl_init($url_parts['host']);
        else $ch = $options['curl_handle'];
        
        curl_setopt($ch, CURLOPT_URL, $page) or die("Invalid cURL Handle Resouce");
        curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); //Just return the data - not print the whole thing.
        curl_setopt($ch, CURLOPT_HEADER, true); //We need the headers
        curl_setopt($ch, CURLOPT_NOBODY, false); //The content - if true, will not download the contents
        if(isset($options['method']) and $options['method'] == 'post' and isset($url_parts['query'])) {
            curl_setopt($ch, CURLOPT_POST, true);
            curl_setopt($ch, CURLOPT_POSTFIELDS, $url_parts['query']);
        }
        //Set the headers our spiders sends
        curl_setopt($ch, CURLOPT_USERAGENT, $send_header['User-Agent']); //The Name of the UserAgent we will be using ;)
        $custom_headers = array("Accept: " . $send_header['Accept'] );
        if(isset($options['modified_since']))
            array_push($custom_headers,"If-Modified-Since: ".gmdate('D, d M Y H:i:s \G\M\T',strtotime($options['modified_since'])));
        curl_setopt($ch, CURLOPT_HTTPHEADER, $custom_headers);

        curl_setopt($ch, CURLOPT_COOKIEJAR, "/tmp/binget-cookie.txt"); //If ever needed...
        curl_setopt($ch, CURLOPT_FOLLOWLOCATION, 1);
        curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, FALSE);

        if(isset($url_parts['user']) and isset($url_parts['pass'])) {
            $custom_headers = array("Authorization: Basic ".base64_encode($url_parts['user'].':'.$url_parts['pass']));
            curl_setopt($ch, CURLOPT_HTTPHEADER, $custom_headers);
        }

        $response = curl_exec($ch);
        $info = curl_getinfo($ch); //Some information on the fetch
        if(!isset($options['curl_handle'])) curl_close($ch); //Dont close the curl session if the curl handle is passed. We may need it later.

    //////////////////////////////////////////// FSockOpen //////////////////////////////
    } else { //If there is no curl
    	print "Curl not installed - this script needs curl to work.\n";
    	exit;
    }

    //Get the headers in an associative array
    $headers = array();

    if($info['http_code'] == 404) {
        $body = "";
        $headers['Status'] = 404;
    } else {
        //Seperate header and content
        $separator_position = strpos($response,"\r\n\r\n");
        $header_text = substr($response,0,$separator_position);
        $body = substr($response,$separator_position+4);
        
        foreach(explode("\n",$header_text) as $line) {
            $parts = explode(": ",$line);
            if(count($parts) == 2) $headers[$parts[0]] = chop($parts[1]);
        }
    }
    
    if(isset($cache_file)) { //Should we cache the URL?
    	file_put_contents($cache_file, $body);
    }

    if($options['return_info']) return array('headers' => $headers, 'body' => $body, 'info' => $info, 'curl_handle'=>$ch);
    return $body;
}