Przedszkolak
Postów: 7
Data rejestracji: 15.01.2007 22:19
|
Dziekuje za Wasze starania .Sorki ze tak niewyraznie sie wyrazilem wersja php-fusion-6.01.2 znalazlem Twoj post w szukajce :) otworzylem db_backups.php niestety nie moge znalesc $dbbackupdir = ADMIN.$settings['db_backup_folder'];
Tak wyglada moj db_backups.php
<title>$dbbackupdir = "db_backups/"; </title>
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------+
| Database Backup developed by CrappoMan
| email:
+----------------------------------------------------*/
require_once "../maincore.php";
if (!checkrights("DB") || !defined("iAUTH") || $aid != iAUTH) fallback("../index.php");
if(isset($_POST['btn_create_backup'])){
$user_password = md5($_POST['user_password']);
if ($user_password != $userdata['user_password']) fallback(FUSION_SELF.$aidlink);
$db_tables = $_POST['db_tables'];
if(count($db_tables)>0){
$crlf = "\n";
ob_start();
@ob_implicit_flush(0);
echo "#----------------------------------------------------------".$crlf;
echo "# PHP-Fusion SQL Data Dump".$crlf;
echo "# Database Name: `$db_name`".$crlf;
echo "# Table Prefix: `".$db_prefix."`".$crlf;
echo "# Date: `".date("d/m/Y H:i")."`".$crlf;
echo "#----------------------------------------------------------".$crlf;
dbquery('SET SQL_QUOTE_SHOW_CREATE=1');
foreach($db_tables as $table){
@set_time_limit(1200);
dbquery("OPTIMIZE TABLE $table");
echo $crlf."#".$crlf."# Structure for Table `".$table."`".$crlf."#".$crlf;
echo "DROP TABLE IF EXISTS `$table`;$crlf";
$row=dbarraynum(dbquery("SHOW CREATE TABLE $table"));
echo $row[1].";".$crlf;
$result=dbquery("SELECT * FROM $table");
if($result&&dbrows($result)){
echo $crlf."#".$crlf."# Table Data for `".$table."`".$crlf."#".$crlf;
$column_list="";
$num_fields=mysql_num_fields($result);
for($i=0;$i<$num_fields;$i++){
$column_list.=(($column_list!="")?", ":"")."`".mysql_field_name($result,$i)."`";
}
}
while($row=dbarraynum($result)){
$dump="INSERT INTO `$table` ($column_list) VALUES (";
for($i=0;$i<$num_fields;$i++){
$dump.=($i>0)?", ":"";
if(!isset($row[$i])){
$dump.="NULL";
}elseif($row[$i]=="0"||$row[$i]!=""){
$type=mysql_field_type($result,$i);
if($type=="tinyint"||$type=="smallint"||$type=="mediumint"||$type=="int"||$type=="bigint"||$type=="timestamp"){
$dump.=$row[$i];
}else{
$search_array=array('\\','\'',"\x00","\x0a","\x0d","\x1a");
$replace_array=array('\\\\','\\\'','\0','\n','\r','\Z');
$row[$i]=str_replace($search_array,$replace_array,$row[$i]);
$dump.="'$row[$i]'";
}
}else{
$dump.="''";
}
}
$dump.=');';
echo $dump.$crlf;
}
}
$contents = ob_get_contents();
ob_end_clean();
mt_srand((double)microtime()*1000000);
$backup_rand = rand(1000000, 9999999);
$backup_hash = substr(md5($backup_rand), 8, 8);
$file = stripinput($_POST['backup_filename']).".sql";
require_once INCLUDES."class.httpdownload.php";
$dl = new httpdownload;
$dl->use_resume = false;
if ($_POST['backup_type'] == ".gz") {
$dl->set_mime("application/x-gzip gz tgz");
$dl->set_bydata(gzencode($contents,9));
$dl->set_filename($file.".gz");
} else {
$dl->set_mime("text/plain");
$dl->set_bydata($contents);
$dl->set_filename($file);
}
$dl->download();
exit;
}
fallback(FUSION_SELF.$aidlink);
}
require_once BASEDIR."subheader.php";
require_once ADMIN."navigation.php";
include LOCALE.LOCALESET."admin/db-backup.php";
if (!isset($action)) $action = "";
if (!isset($_POST['btn_do_restore']) && $action != "restore") {
@unlink(ADMIN."/db_backups/temp.txt");
}
if (isset($_POST['btn_cancel'])) {
@unlink(ADMIN."/db_backups/temp.txt");
redirect(FUSION_SELF.$aidlink);
}
if (isset($_POST['btn_do_restore'])) {
$user_password = md5($_POST['user_password']);
if ($user_password != $userdata['user_password']) {
fallback(FUSION_SELF.$aidlink);
}
$result = gzfile(ADMIN."/db_backups/temp.txt");
if((preg_match("/# Database Name: `(.+?)`/i", $result[2], $tmp1)<>0)&&(preg_match("/# Table Prefix: `(.+?)`/i", $result[3], $tmp2)<>0)){
$inf_dbname = $tmp1[1];
$inf_tblpre = $tmp2[1];
$result = array_slice($result,7);
$results = preg_split("/;$/m",implode("",$result));
if (count($list_tbl) > 0) {
foreach($results as $result){
$result = html_entity_decode($result, ENT_QUOTES);
if (preg_match("/^DROP TABLE IF EXISTS `(.*?)`/im",$result,$tmp) <> 0) {
$tbl = $tmp[1];
if (in_array($tbl, $list_tbl)) {
$result = preg_replace("/^DROP TABLE IF EXISTS `$inf_tblpre(.*?)`/im","DROP TABLE IF EXISTS `$restore_tblpre\\1`",$result);
mysql_unbuffered_query($result);
}
}
if (preg_match("/^CREATE TABLE `(.*?)`/im",$result,$tmp) <> 0) {
$tbl = $tmp[1];
if (in_array($tbl, $list_tbl)) {
$result = preg_replace("/^CREATE TABLE `$inf_tblpre(.*?)`/im","CREATE TABLE `$restore_tblpre\\1`",$result);
mysql_unbuffered_query($result);
}
}
}
}
if (count($list_ins) > 0) {
foreach($results as $result){
if (preg_match("/INSERT INTO `(.*?)`/i",$result,$tmp) <> 0) {
$ins = $tmp[1];
if (in_array($ins, $list_ins)) {
$result = preg_replace("/INSERT INTO `$inf_tblpre(.*?)`/i","INSERT INTO `$restore_tblpre\\1`",$result);
mysql_unbuffered_query($result);
}
}
}
}
@unlink(ADMIN."/db_backups/temp.txt");
redirect(FUSION_SELF.$aidlink);
}else{
opentable($locale['400']);
echo "<center>".$locale['401']."<br><br>".$locale['402']."<br><br>";
echo "<form action='".FUSION_SELF.$aidlink."' name='frm_info' method='post'>";
echo "<input class='button' type='submit' name='btn_cancel' style='width:100px;' value='".$locale['403']."'></td></tr>";
echo "</form></center>";
closetable();
}
} elseif ($action=="restore") {
if (is_uploaded_file($_FILES['upload_backup_file']['tmp_name'])) {
$backup_name = $_FILES['upload_backup_file']['name'];
move_uploaded_file($_FILES['upload_backup_file']['tmp_name'], ADMIN."/db_backups/temp.txt");
$backup_data = gzfile(ADMIN."/db_backups/temp.txt");
} else {
fallback(FUSION_SELF.$aidlink);
}
$info_tbls=array();
$info_ins_cnt=array();
$info_inserts=array();
foreach($backup_data as $resultline){
if(preg_match_all("/^# Database Name: `(.*?)`/", $resultline, $resultinfo)<>0){ $info_dbname=$resultinfo[1][0]; }
if(preg_match_all("/^# Table Prefix: `(.*?)`/", $resultline, $resultinfo)<>0){ $info_tblpref=$resultinfo[1][0]; }
if(preg_match_all("/^# Date: `(.*?)`/", $resultline, $resultinfo)<>0){ $info_date=$resultinfo[1][0]; }
if(preg_match_all("/^CREATE TABLE `(.+?)`/i", $resultline, $resultinfo)<>0){ $info_tbls[]=$resultinfo[1][0]; }
if(preg_match_all("/^INSERT INTO `(.+?)`/i", $resultline, $resultinfo)<>0){
if(!in_array($resultinfo[1][0], $info_inserts)) { $info_inserts[]=$resultinfo[1][0]; }
$info_ins_cnt[]=$resultinfo[1][0];
}
}
$table_opt_list="";
sort($info_tbls);
foreach($info_tbls as $key=>$info_tbl){
$table_opt_list.="<option value='$info_tbl' selected>$info_tbl</option>";
}
$insert_ins_cnt=array_count_values($info_ins_cnt);
$insert_opt_list="";
sort($info_inserts);
foreach($info_inserts as $key=>$info_insert){
$insert_opt_list.="<option value='$info_insert' selected>$info_insert (".$insert_ins_cnt[$info_insert].")</option>";
}
$maxrows=max(count($info_tbls),count($info_inserts));
opentable($locale['400']);
echo "<script type='text/javascript'>
<!--
function tableSelectAll(){for(i=0;i<document.restoreform.elements['list_tbl[]'].length;i++){document.restoreform.elements['list_tbl[]'].options[i].selected=true;}}
function tableSelectNone(){for(i=0;i<document.restoreform.elements['list_tbl[]'].length;i++){document.restoreform.elements['list_tbl[]'].options[i].selected=false;}}
function populateSelectAll(){for(i=0;i<document.restoreform.elements['list_ins[]'].length;i++){document.restoreform.elements['list_ins[]'].options[i].selected=true;}}
function populateSelectNone(){for(i=0;i<document.restoreform.elements['list_ins[]'].length;i++){document.restoreform.elements['list_ins[]'].options[i].selected=false;}}
//-->
</script>
<form name='restoreform' method='post' action='".FUSION_SELF.$aidlink."'>
<table align='center' cellspacing='0' cellpadding='0'>
<tr>
<td colspan='2' class='tbl2'>".$locale['430']."</td>
</tr>
<tr>
<td colspan='2' class='tbl'>".$locale['431']." $backup_name</td>
</tr>
<tr>
<td colspan='2' class='tbl'>".$locale['414']." $info_dbname</td>
</tr>
<tr>
<td colspan='2' class='tbl'>".$locale['432']." $info_date</td>
</tr>
<tr>
<td colspan='2' class='tbl'>".$locale['415']."
<input class='textbox' type='text' name='restore_tblpre' value='$info_tblpref' style='width:150px'>
</td>
</tr>
<tr>
<td valign='top' class='tbl'>".$locale['433']."<br>
<select style='width:180px;' class='textbox' id='list_tbl' name='list_tbl[]' size='$maxrows' multiple>".$table_opt_list."</select>
<div align='center'>".$locale['435']." [<a href=\"javascript:void(0)\" onclick=\"javascript:tableSelectAll()\">".$locale['436']."</a>]
[<a href=\"javascript:void(0)\" onclick=\"javascript:tableSelectNone()\">".$locale['437']."</a>]</div></td>
<td valign='top' class='tbl'>".$locale['434']."<br>
<select style='width:180px;' class='textbox' id='list_ins' name='list_ins[]' size='$maxrows' multiple>".$insert_opt_list."</select>
<div align='center'>".$locale['435']." [<a href=\"javascript:void(0)\" onclick=\"javascript:populateSelectAll()\">".$locale['436']."</a>]
[<a href=\"javascript:void(0)\" onclick=\"javascript:populateSelectNone()\">".$locale['437']."</a>]</div></td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'><hr>".$locale['460']."
<input type='password' name='user_password' value='' class='textbox' style='width:150px;'></td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'>
<input class='button' type='submit' name='btn_do_restore' style='width:100px;' value='".$locale['438']."'>
<input class='button' type='submit' name='btn_cancel' style='width:100px;' value='".$locale['439']."'>
</td>
</tr>
</table>
</form>\n";
closetable();
}else{
$table_opt_list="";
$result=dbquery("SHOW tables");
while($row=dbarraynum($result)){
$table_opt_list.="<option value='".$row[0]."'";
if(preg_match("/^".$db_prefix."/i",$row[0])){
$table_opt_list.=" selected";
}
$table_opt_list.=">".$row[0]."</option>\n";
}
opentable($locale['450']);
echo "
<script type='text/javascript'>
<!--
function backupSelectCore(){for(i=0;i<document.backupform.elements['db_tables[]'].length;i++){document.backupform.elements['db_tables[]'].options[i].selected=(document.backupform.elements['db_tables[]'].options[i].text).match(/^$db_prefix/);}}
function backupSelectAll(){for(i=0;i<document.backupform.elements['db_tables[]'].length;i++){document.backupform.elements['db_tables[]'].options[i].selected=true;}}
function backupSelectNone(){for(i=0;i<document.backupform.elements['db_tables[]'].length;i++){document.backupform.elements['db_tables[]'].options[i].selected=false;}}
//-->
</script>
<form action='".FUSION_SELF.$aidlink."' name='backupform' method='post'>
<table align='center' cellspacing='0' cellpadding='0'>
<tr>
<td valign='top'>
<table align='center' cellspacing='0' cellpadding='0'>
<tr>
<td colspan='2' class='tbl2' align='left'>".$locale['451']."</td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['414']."</td>
<td class='tbl'>$db_name</td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['415']."</td>
<td class='tbl'>".$db_prefix."</td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['452']."</td>
<td class='tbl'>".parseByteSize(get_database_size(),2,false)." (".get_table_count()." ".$locale['419'].")</td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['453']."</td>
<td class='tbl'>".parseByteSize(get_database_size($db_prefix),2,false)." (".get_table_count($db_prefix)." ".$locale['419'].")</td>
</tr>
<tr>
<td align='left' colspan='2' class='tbl2'>".$locale['454']."</td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['431']."</td>
<td class='tbl'><input type='text' name='backup_filename' value='backup_".date('Y-m-d-Hi')."' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['455']."</td>
<td class='tbl'><select name='backup_type' class='textbox' style='width:150px;'>
<option value='.gz' selected>.sql.gz ".$locale['456']."</option>
<option value='.sql'>.sql</option>
</select></td>
</tr>
<tr>
<td align='right' class='tbl'>".$locale['460']."</td>
<td class='tbl'><input type='password' name='user_password' value='' class='textbox' style='width:150px;'></td>
</tr>
</table>
</td>
<td valign='top'>
<table border='0' cellpadding='0' cellspacing='0'>
<tr>
<td class='tbl2'>".$locale['457']."</td>
</tr>
<tr>
<td class='tbl'>
<select style='margin:5px 0px' class='textbox' id='tablelist' name='db_tables[]' size='17' multiple>".$table_opt_list."</select>
<div align='center'>".$locale['435']." [<a href=\"javascript:void(0)\" onclick=\"javascript:backupSelectCore()\">".$locale['458']."</a>]
[<a href=\"javascript:void(0)\" onclick=\"javascript:backupSelectAll()\">".$locale['436']."</a>]
[<a href=\"javascript:void(0)\" onclick=\"javascript:backupSelectNone()\">".$locale['437']."</a>]</div>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td align='center' colspan='2' class='tbl'><hr>
<input class='button' type='submit' name='btn_create_backup' style='width:100px;' value='".$locale['459']."'></td>
</tr>
</table>
</form>\n";
closetable();
tablebreak();
opentable($locale['480']);
echo "<form name='restore' method='post' action='".FUSION_SELF.$aidlink."&action=restore' enctype='multipart/form-data'>\n";
echo "<center>".$locale['431']." <input type='file' name='upload_backup_file' class='textbox'><br><br>\n";
echo "<input class='button' type='submit' name='restore' style='width:100px;' value='".$locale['438']."'></center>\n</form>\n";
closetable();
}
function get_database_size($prefix=""){
global $db_name;
$db_size=0;
$result=dbquery("SHOW TABLE STATUS FROM `".$db_name."`");
while($row=dbarray($result)){
if (!isset($row['Type'])) $row['Type'] = "";
if (!isset($row['Engine'])) $row['Engine'] = "";
if((eregi('^(MyISAM|ISAM|HEAP|InnoDB)$',$row['Type'])) || (eregi('^(MyISAM|ISAM|HEAP|InnoDB)$',$row['Engine'])) && (preg_match("/^".$prefix."/",$row['Name']))){
$db_size+=$row['Data_length']+$row['Index_length'];
}
}
return $db_size;
}
function get_table_count($prefix=""){
global $db_name;
$tbl_count=0;
$result=dbquery("SHOW TABLE STATUS FROM `".$db_name."`");
while($row=dbarray($result)){
if (!isset($row['Type'])) $row['Type'] = "";
if (!isset($row['Engine'])) $row['Engine'] = "";
if((eregi('^(MyISAM|ISAM|HEAP|InnoDB)$',$row['Type'])) || (eregi('^(MyISAM|ISAM|HEAP|InnoDB)$',$row['Engine'])) && (preg_match("/^".$prefix."/",$row['Name']))){
$tbl_count++;
}
}
return $tbl_count;
}
function gzcompressfile($source,$level=false){
$dest=$source.'.gz';
$mode='wb'.$level;
$error=false;
if($fp_out=gzopen($dest,$mode)){
if($fp_in=fopen($source,'rb')){
while(!feof($fp_in))
gzputs($fp_out,fread($fp_in,1024*512));
fclose($fp_in);
}else $error=true;
gzclose($fp_out);
}else $error=true;
if($error)return false; else return $dest;
}
echo "</td>\n";
require_once BASEDIR."footer.php";
?>
Czy moglbym prosic o pokazanie gdzie mam to zmienic i gdzie mam szukas starego pliku jezykowego jeszcze raz dziekuje za Wasza pomoc :)
Edytowane przez Pieka dnia 21.01.2007 01:31:09
|
niestety nie moge wykonac Kopii Zapasowej .Prosze o pomoc
v7.02.03
wlodekp
