WB 2.08.x

<?php

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

* SVN Version information:

*

* $Id$

*

*****************************************************************************

*

*****************************************************************************

*                          WebsiteBaker

*

* WebsiteBaker Project <http://www.websitebaker2.org/>

* Copyright (C) 2009, Website Baker Org. e.V.

*         http://start.websitebaker2.org/impressum-datenschutz.php

* Copyright (C) 2004-2009, Ryan Djurovich

*

*                        About WebsiteBaker

*

* Website Baker is a PHP-based Content Management System (CMS)

* designed with one goal in mind: to enable its users to produce websites

* with ease.

*

*****************************************************************************

*

*****************************************************************************

*                   WebsiteBaker Extra Information (where needed)

*

*

*

*****************************************************************************

*

*****************************************************************************

*                        LICENSE INFORMATION

*

* WebsiteBaker is free software; you can redistribute it and/or

* modify it under the terms of the GNU General Public License

* as published by the Free Software Foundation; either version 2

* of the License, or (at your option) any later version.

*

* WebsiteBaker is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

* See the GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with this program; if not, write to the Free Software

* Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.

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

/**

 *

 * @category     modules

 * @package      backup

 * @author       Ryan Djurovich

 * @copyright    2004-2009, Ryan Djurovich

 * @copyright    2009, Website Baker Org. e.V.

 * @version      $Id$

 * @platform     WebsiteBaker 2.8.x

 * @requirements >= PHP 4.3.4

 * @license      http://www.gnu.org/licenses/gpl.html

 *

 *

 */

// Filename to use

$filename = $_SERVER['HTTP_HOST'].'-backup-'.gmdate('Y-m-d', time()+TIMEZONE).'.sql';

// Check if user clicked on the backup button

if(!isset($_POST['backup'])){

	header('Location: ../');

	exit(0);

}

// Include config

require_once('../../config.php');

// Begin output var

$output = "".

"#\n".

"# Website Baker ".WB_VERSION." Database Backup\n".

"# ".WB_URL."\n".

"# ".gmdate(DATE_FORMAT, time()+TIMEZONE).", ".gmdate(TIME_FORMAT, time()+TIMEZONE)."\n".

"#".

"\n";

// Get table names

// Use this one for ALL tables in DB

$query  = "SHOW TABLES";

if ($_POST['tables']=='WB') {

	// Or use this to get ONLY wb tables

	$prefix=str_replace('_','\_',TABLE_PREFIX);

	$query = "SHOW TABLES LIKE '".$prefix."%'";

}

$result = $database->query($query);

// Loop through tables

while($row = $result->fetchRow()) {

	//show sql query to rebuild the query

	$sql = 'SHOW CREATE TABLE '.$row[0].'';

	$query2 = $database->query($sql);

	// Start creating sql-backup

	$sql_backup ="\r\n# Create table ".$row[0]."\r\n\r\n";

	$out = $query2->fetchRow();

	$sql_backup.=$out['Create Table'].";\r\n\r\n";

	$sql_backup.="# Dump data for ".$row[0]."\r\n\r\n";

	// Select everything

	$out = $database->query('SELECT * FROM '.$row[0]);

	$sql_code = '';

	// Loop through all collumns

	while($code = $out->fetchRow()) {

		$sql_code .= "INSERT INTO ".$row[0]." SET ";

		$numeral = 0;

		foreach($code as $insert => $value) {

			// Loosing the numerals in array -> mysql_fetch_array($result, MYSQL_ASSOC) WB hasn't?

			if($numeral==1) {

				$sql_code.=$insert ."='".addslashes($value)."',";

			}

			$numeral = 1 - $numeral;

		}

		$sql_code = substr($sql_code, 0, -1);

		$sql_code.= ";\r\n";

	}

	$output .= $sql_backup.$sql_code;

}

// Output file

header('Content-Type: text/html');

header('Content-Disposition: attachment; filename='.$filename);

echo $output;