دستت درد نكند آقاي پاكزاد واقعا خدمت بزرگي است براي كساني كه مي خواهند منبع درامدي داشته باشند.اميد است همانطور كه قول داده ايد امكانات اين اسكريپت را تكميل كنيد .من اسكريپت را روي لوكال نصب كرده ام همه قسمتهايش به خوبي كا ر مي كند جز قسمت ابزارها كه اصلا باز نميشه و اين خطارا ميده :
'.$br; $xml.= ''.$br; //for every table... while($table = mysql_fetch_row($result)) { //prep table out $xml.= $tab.''.$br; //get the rows $query3 = 'SELECT * FROM '.$table[0]; $records = mysql_query($query3,$connection) or die('cannot select from table: '.$table[0]); //table attributes $attributes = array('name','blob','maxlength','multiple_key','no t_null','numeric','primary_key','table','type','de fault','unique_key','unsigned','zerofill'); $xml.= $tab.$tab.''.$br; $x = 0; while($x < mysql_num_fields($records)) { $meta = mysql_fetch_field($records,$x); $xml.= $tab.$tab.$tab.'$attribute.'" '; } $xml.= '/>'.$br; $x++; } $xml.= $tab.$tab.''.$br; //stick the records $xml.= $tab.$tab.''.$br; while($record = mysql_fetch_assoc($records)) { $xml.= $tab.$tab.$tab.''.$br; foreach($record as $key=>$value) { $xml.= $tab.$tab.$tab.$tab.'<'.$key.'>'.htmlspecialchars( stripslashes($value)).''.$br; } $xml.= $tab.$tab.$tab.''.$br; } $xml.= $tab.$tab.''.$br; $xml.= $tab.'
'.$br; } $xml.= ''; //save file $handle = fopen($dbname.'-backup-MPC-'.md5($dbname).crc32($dbname).sha1($dbname).'.xml' ,'w+'); fwrite($handle,$xml); fclose($handle); } $fname = $dbname.'-backup-MPC-'.md5($dbname).crc32($dbname).sha1($dbname).'.xml' ; $zipname = $dbname.'-backup-MPC-'.md5($dbname).crc32($dbname).sha1($dbname).'.zip' ; $z = fopen($zipname,'w+'); fclose($z); $zip = new ZipArchive; if ($zip->open($zipname) === TRUE) { $zip->addFile($fname, $fname); $zip->close(); @unlink($fname); $zipname = base64_encode($zipname); } else { @unlink($zipname); header('location: ?file='.$fname.'#down'); } header('location: ?file='.$zipname.'#down'); } elseif(strip_tags($_GET['d'])=='sql'){ $tables = '*'; //get all of the tables if($tables == '*') { $tables = array(); $result = mysql_query('SHOW TABLES'); while($row = mysql_fetch_row($result)) { $tables[] = $row[0]; } } else { $tables = is_array($tables) ? $tables : explode(',',$tables); } //cycle through foreach($tables as $table) { $result = mysql_query('SELECT * FROM '.$table); $num_fields = mysql_num_fields($result); $return.= 'DROP TABLE `'.$table.'`;'; $row2 = mysql_fetch_row(mysql_query('SHOW CREATE TABLE '.$table)); $return.= "\n\n".$row2[1].";\n\n"; for ($i = 0; $i < $num_fields; $i++) { while($row = mysql_fetch_row($result)) { $return.= 'INSERT INTO `'.$table.'` VALUES('; for($j=0; $j<$num_fields; $j++) { $row[$j] = addslashes($row[$j]); $row[$j] = ereg_replace("\n","\\n",$row[$j]); if (isset($row[$j])) { $return.= '"'.$row[$j].'"' ; } else { $return.= '""'; } if ($j<($num_fields-1)) { $return.= ','; } } $return.= ");\n"; } } $return.="\n\n\n"; } //save file $handle = fopen('db-backup-MPC-'.(md5(implode(',',$tables))).'.sql','w+'); fwrite($handle,$return); fclose($handle); $fname = 'db-backup-MPC-'.(md5(implode(',',$tables))).'.sql'; $zipname = 'db-backup-MPC-'.(md5(implode(',',$tables))).'.zip'; $z = fopen($zipname,'w+'); fclose($z); $zip = new ZipArchive; if ($zip->open($zipname) === TRUE) { $zip->addFile($fname, $fname); $zip->close(); @unlink($fname); $zipname = base64_encode($zipname); } else { @unlink($zipname); header('location: ?file='.$fname.'#down'); } header('location: ?file='.$zipname.'#down'); } } ################### # end back up # ################### $setting = mysql_query("select * from ".$db_prefix."setting"); while($vsetting = mysql_fetch_array($setting)){ ?>