'; $textDropEmpty=null; } echo Show_Drop_Tables_DBMan($textDropEmpty); echo '

'; } else { echo ''; if(isset($_POST['selected_dbtab']) && ($_POST['selected_dbtab']=="DBMan_SQLTab")) { echo '

Based on WP-DBManager 2.05 © 2006 Lester Chan.
Modified and expanded for Pixelpost © 2008, Dennis Mooibroek || Check for update || If you like this addon you might want to buy me a coffee or another beverage.

'; } //******************************************************************************************************************* // FORM ACTION FUNCTIONS //******************************************************************************************************************* function DBMan_action_DropFields(){ $emptydrop = $_POST['emptydrop']; if (isset($_POST['fieldstable'])){ $drop_fields_table = $_POST['fieldstable']; } $drop_fields = array(); $empty_fields = array(); if(!empty($emptydrop)) { foreach($emptydrop as $key => $value) { if($value == 'empty') { $empty_fields[] = $key; } elseif($value == 'drop') { $drop_fields[] = $key; } } } else { $text = 'No Fields Selected'; } if(!empty($empty_fields)) { foreach($empty_fields as $empty_field) { // get information about the field $info_query = "SHOW FULL COLUMNS FROM `{$drop_fields_table}`"; $result_info_query = mysql_query($info_query); while($row = mysql_fetch_array($result_info_query)){ if ($row['Field']==$empty_field){ $type = $row['Type']; if (strtolower($row['Null'])=='no'){ $isnull="NOT NULL"; } else { $isnull="NULL"; } if (strtolower($row['Extra'])=='auto_increment'){ $extra="AUTO_INCREMENT"; } else { $extra=NULL; } if ($row['Default']=='') { $default=''; } else { $default="DEFAULT '".$row['Default']."'"; } if (strtolower($row['Key'])=='pri'){ $key_query="ALTER TABLE `{$drop_fields_table}` ADD PRIMARY KEY ( `{$empty_field}` )"; } elseif (strtolower($row['Key'])=='mul') { $key_query="ALTER TABLE `{$drop_fields_table}` ADD INDEX ( `{$empty_field}` )"; } elseif (strtolower($row['Key'])=='UNI') { $key_query="ALTER TABLE `{$drop_fields_table}` ADD UNIQUE ( `{$empty_field}` )"; } else { $key_query=NULL; } } } $drop_query = "ALTER TABLE `{$drop_fields_table}` DROP `{$empty_field}`"; mysql_query($drop_query) or die(mysql_error()); $restore_query = "ALTER TABLE `{$drop_fields_table}` ADD `{$empty_field}` {$type} {$isnull} {$extra} {$default}"; mysql_query($restore_query) or die(mysql_error()); if ($key_query != NULL){ mysql_query($key_query) or die(mysql_error()); } $text .= "Field '$empty_field' from '$drop_fields_table' Emptied
"; } } if(!empty($drop_fields)) { foreach($drop_fields as $drop_field) { $query = "ALTER TABLE `{$drop_fields_table}` DROP `{$drop_field}`"; $empty_query = mysql_query($query); $text .= "Field '$drop_field' from '$drop_fields_table' Dropped
"; } } return $text; } function DBMan_action_DropEmpty(){ // Lets Prepare The Variables $emptydrop = $_POST['emptydrop']; $empty_tables = array(); if(!empty($emptydrop)) { foreach($emptydrop as $key => $value) { if($value == 'empty') { $empty_tables[] = $key; } elseif($value == 'drop') { $drop_tables .= ', '.$key; } } } else { $text = 'No Tables Selected'; } $drop_tables = substr($drop_tables, 2); if(!empty($empty_tables)) { foreach($empty_tables as $empty_table) { $query = "TRUNCATE {$empty_table}"; $empty_query = mysql_query($query); $text .= "Table '$empty_table' Emptied
"; } } if(!empty($drop_tables)) { $query = "DROP TABLE {$drop_tables}"; $drop_query = mysql_query($query); $text = "Table(s) '$drop_tables' Dropped"; } return $text; } function DBMan_action_SQL(){ $sql_queries2 = trim($_POST['sql_query']); $totalquerycount = 0; $successquery = 0; if($sql_queries2) { $sql_queries = array(); $sql_queries2 = explode("\n", $sql_queries2); foreach($sql_queries2 as $sql_query2) { $sql_query2 = trim(stripslashes($sql_query2)); $sql_query2 = preg_replace("/[\r\n]+/", '', $sql_query2); if(!empty($sql_query2)) { $sql_queries[] = $sql_query2; } } if($sql_queries) { foreach($sql_queries as $sql_query) { if (preg_match("/^\\s*(insert|update|replace|delete|create|alter) /i",$sql_query)) { $run_query = mysql_query($sql_query); if(!$run_query) { $text .= "$sql_query
"; } else { $successquery++; $text .= "$sql_query
"; } $totalquerycount++; } elseif (preg_match("/^\\s*(select|drop|show|grant) /i",$sql_query)) { $text .= "$sql_query
"; $totalquerycount++; } } $text .= "$successquery/$totalquerycount Query(s) Executed Successfully"; } else { $text = "Empty Query"; } } else { $text = "Empty Query"; } return $text; } function DBMan_action_ManagerMail(){ global $cfgrow; $database_file = trim($_POST['database_file']); $backup['path'] = trim($_POST['backup_path']); $nice_file_date = gmdate('l, jS F Y @ H:i', filemtime($backup['path'].'/'.$database_file)+(3600*$cfgrow['timezone'])); if(!empty($database_file)) { // Get And Read The Database Backup File $file_path = $backup['path'].'/'.$database_file; $file_size = format_size(filesize($file_path)); $file_date = gmdate('l, jS F Y @ H:i', filemtime($backup['path'].'/'.$database_file)+(3600*$cfgrow['timezone'])); $file = fopen($file_path,'rb'); $file_data = fread($file,filesize($file_path)); fclose($file); $file_data = chunk_split(base64_encode($file_data)); // Create Mail To, Mail Subject And Mail Header if(!empty($_POST['email_to'])) { $mail_to = trim($_POST['email_to']); } else { //$mail_to = get_settings('admin_email'); } $mail_subject = ' Database Backup File For '.$file_date; $mail_header = 'From: Pixelpost DB-Manager <'.$cfgrow['email'].'>'; // MIME Boundary $random_time = md5(time()); $mime_boundary = "==WP-DBManager- $random_time"; // Create Mail Header And Mail Message $mail_header .= "\nMIME-Version: 1.0\n" . "Content-Type: multipart/mixed;\n" . " boundary=\"{$mime_boundary}\""; $mail_message = "Website Name: ".$cfgrow['sitetitle']."\nWebsite URL: ".$cfgrow['siteurl']."\nBackup File Name: $database_file\nBackup File Date: $file_date\nBackup File Size: $file_size\n\nWith Regards,\nYour Pixelpost DBManager Addon\n".$cfgrow['siteurl']; $mail_message = "This is a multi-part message in MIME format.\n\n" . "--{$mime_boundary}\n" . "Content-Type: text/plain; charset=\"utf-8\"\n" . "Content-Transfer-Encoding: 7bit\n\n".$mail_message."\n\n"; $mail_message .= "--{$mime_boundary}\n" . "Content-Type: application/octet-stream;\n" . " name=\"$database_file\"\n" . "Content-Disposition: attachment;\n" . " filename=\"$database_file\"\n" . "Content-Transfer-Encoding: base64\n\n" . $file_data."\n\n--{$mime_boundary}--\n"; if(mail($mail_to, $mail_subject, $mail_message, $mail_header)) { $text .= "Database Backup File For '$file_date' Successfully E-Mailed To '$mail_to'
"; } else { $text = "Unable To E-Mail Database Backup File For '$file_date' To '$mail_to'"; } } else { $text = 'No Backup Database File Selected'; } return $text; } function DBMan_action_ManagerRestore() { global $pixelpost_db_host, $pixelpost_db_pixelpost, $pixelpost_db_user, $pixelpost_db_prefix, $pixelpost_db_pass; $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $drop_database = $DBMan_backup['drop_database']; $database_file = trim($_POST['database_file']); $backup['path'] = trim($_POST['backup_path']); $nice_file_date = gmdate('l, jS F Y @ H:i', filemtime($backup['path'].'/'.$database_file)+(3600*$cfgrow['timezone'])); if(!empty($database_file)) { if (stristr($database_file, 'SQL_backup_')) { if(stristr($database_file, '.zip')) { $text = "Database On '$nice_file_date' Failed To Restore: ZIP files are not supported yet."; } else { // drop all tables if drop is set $query = mysql_query('SHOW TABLE STATUS FROM `'.$pixelpost_db_pixelpost.'`'); while($row = mysql_fetch_array($query)){ foreach($row AS $name => $value){ if(!is_numeric($name)){ $data[$i][$name] = $value; } } $i++; } // put the name of the tabels in the array '$tables' $tables = array(); foreach($data AS $i => $XXX){ $tables[] = $data[$i]['Name']; } foreach($tables AS $key => $tablename){ if ($drop_database=='y'){ $query = "DROP TABLE `".$tablename."`"; mysql_query($query) or die(mysql_error()); } } // execute SQL $f = fopen($backup['path'].'/'.$database_file, 'r'); if ($f) { $sql = ''; while (!feof($f)){ $read = fgets($f); if (!preg_match('/^[#-]/', $read)) { $sql .= $read; if (preg_match('/;[\r\n]*$/', $sql)){ if ($sql[strlen($sql)-1]=='='){ $sql=$sql."1"; } mysql_query(preg_replace('/;[\r\n]*$/', '', $sql)) or die(mysql_error()); $sql = ''; } } } fclose($f); $text = "Database On '$nice_file_date' Restored Successfully"; } else { $text = "Database On '$nice_file_date' Failed To Restore: Unable to read specified file.".$getquery; } } } else { if(stristr($database_file, '.gz')) { $backup['command'] = 'gunzip < '.$backup['path'].'/'.$database_file.' | '.$backup['mysqlpath'].' --host='.$pixelpost_db_host.' --user='.$pixelpost_db_user.' --password='.$pixelpost_db_pass.' '.$pixelpost_db_pixelpost; } else { $backup['command'] = $backup['mysqlpath'].' --host='.$pixelpost_db_host.' --user='.$pixelpost_db_user.' --password='.$pixelpost_db_pass.' '.$pixelpost_db_pixelpost.' < '.$backup['path'].'/'.$database_file; } passthru($backup['command'], $error); if($error) { $text = "Database On '$nice_file_date' Failed To Restore"; } else { $text = "Database On '$nice_file_date' Restored Successfully"; } } } else { $text = 'No Backup Database File Selected'; } return $text; } function DBMan_action_ManagerDelete(){ $database_file = trim($_POST['database_file']); $backup['path'] = trim($_POST['backup_path']); $nice_file_date = gmdate('l, jS F Y @ H:i', filemtime($backup['path'].'/'.$database_file)+(3600*$cfgrow['timezone'])); if(!empty($database_file)) { $nice_file_date = gmdate('l, jS F Y @ H:i', filemtime($backup['path'].'/'.$database_file)+(3600*$cfgrow['timezone'])); if(is_file($backup['path'].'/'.$database_file)) { if(!unlink($backup['path'].'/'.$database_file)) { $text .= "Unable To Delete Database Backup File On '$nice_file_date'
"; } else { $text .= "Database Backup File On '$nice_file_date' Deleted Successfully
"; } } else { $text = "Invalid Database Backup File On '$nice_file_date'"; } } else { $text = 'No Backup Database File Selected'; } return $text; } function DBMan_action_UpdateOptions() { global $pixelpost_db_prefix; if (isset($_POST['db_mysqldumppath'])){ $mysqldumppath = trim($_POST['db_mysqldumppath']); $mysqlpath = trim($_POST['db_mysqlpath']); $additional_query = "mysqldump_path='$mysqldumppath', mysql_path='$mysqlpath',"; } else {$additional_query=null;} $path = trim($_POST['db_path']); $adv_backup=$_POST['db_adv_backup']; $drop_database=$_POST['db_drop_database']; $empty_tables=$_POST['db_empty_tables']; $del_sql=$_POST['db_del_sql']; $ftpserver = trim($_POST['db_ftpserver']); $ftpuser=trim($_POST['db_ftpuser']); $ftppath=trim($_POST['db_ftppath']); $ftppassive=$_POST['db_ftppassive']; $query = "UPDATE {$pixelpost_db_prefix}DBManager SET ".$additional_query." backup_path='$path', del_sql='$del_sql', adv_backup='$adv_backup',drop_database='$drop_database', empty_tables = '$empty_tables', ftpserver='$ftpserver', ftpuser='$ftpuser', ftppath='$ftppath', ftppassive='$ftppassive' LIMIT 1"; $update_db_options = mysql_query($query) or die(mysql_error() ) ; if($update_db_options) { $text = 'Options Updated Successfully
'; } if(empty($text)) { $text = 'Unable To Update Options
'; } return $text; } function DBMan_action_Backup_Advanced() { global $cfgrow, $pixelpost_db_host, $pixelpost_db_pixelpost, $pixelpost_db_user, $pixelpost_db_prefix, $pixelpost_db_pass; $tz = $cfgrow["timezone"]; $current_date_time = gmdate($cfgrow['dateformat'],time() + (3600 * $tz)); $current_date_time = str_replace(" ","_",$current_date_time); $current_date_time = str_replace(":",".",$current_date_time); $gzip = intval($_POST['gzip']); $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $backup['mysqlpath'] = $DBMan_backup['mysql_path']; $backup['mysqldumppath'] = $DBMan_backup['mysqldump_path']; $backup['path'] = $DBMan_backup['backup_path']; if($gzip == 1) { $backup['filename'] = $current_date_time.'_-_'.$pixelpost_db_pixelpost.'.sql.gz'; $backup['filepath'] = $backup['path'].'/'.$backup['filename']; $backup['command'] = $backup['mysqldumppath'].' --host='.$pixelpost_db_host.' --user='.$pixelpost_db_user.' --password='.$pixelpost_db_pass.' --add-drop-table '.$pixelpost_db_pixelpost.' | gzip > '.$backup['filepath']; } else { $backup['filename'] = $current_date_time.'_-_'.$pixelpost_db_pixelpost.'.sql'; $backup['filepath'] = $backup['path'].'/'.$backup['filename']; $backup['command'] = $backup['mysqldumppath'].' --host='.$pixelpost_db_host.' --user='.$pixelpost_db_user.' --password='.$pixelpost_db_pass.' --add-drop-table '.$pixelpost_db_pixelpost.' > '.$backup['filepath']; } passthru($backup['command'], $error); if(!is_writable($backup['path'])) { $text = "Database Failed To Backup On '$current_date_time'. Backup Folder Not Writable."; } elseif(filesize($backup['filepath']) == 0) { unlink($backup['filepath']); $text = "Database Failed To Backup On '$current_date_time'. Backup File Size Is 0KB."; } elseif(!is_file($backup['filepath'])) { $text = "Database Failed To Backup On '$current_date_time'. Invalid Backup File Path."; } elseif($error) { $text = "Database Failed To Backup On '$current_date_time'."; } else { $text = "Database Backed Up Successfully On '$current_date_time'."; } return $text; } function DBMan_action_Backup() { global $cfgrow, $pixelpost_db_host, $pixelpost_db_pixelpost, $pixelpost_db_user, $pixelpost_db_prefix, $pixelpost_db_pass; $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $backup['path'] = $DBMan_backup['backup_path']; $backup['del_sql'] = $DBMan_backup['del_sql']; $zip = intval($_POST['zip']); $filearray = CreateSQLfile($backup['path']."/", $pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass, $pixelpost_db_pixelpost); $text = "Backup Succesfull!"; if($zip == 1) { //Create the zipfile containing data $zipname = "SQL_backup_".date("Y-m-d_H.i.s").".zip"; $text = $text."
"; $text.= CreateZipFile($zipname, $filearray, $backup['path']."/"); if ($backup['del_sql']=='y'){ foreach ($filearray as $deletefile) { if (file_exists($backup['path'].'/'.$deletefile)) { if(!unlink($backup['path'].'/'.$deletefile)) { $text .= "
Unable To Delete '".$deletefile."'"; } else { $text .= "
'".$deletefile."' Deleted Successfully"; } } } } } return $text; } function DBMan_action_ManagerFTP(){ global $pixelpost_db_prefix; $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $ftp_host = $DBMan_backup['ftpserver']; $ftp_user_name = $DBMan_backup['ftpuser']; $ftp_user_pass = $_POST['db_ftppass']; $ftp_path = $DBMan_backup['ftppath']; $ftp_passive = $DBMan_backup['ftppassive']; $file = trim($_POST['database_file']); $filepath = trim($_POST['backup_path']); $file_to_upload = $filepath."/".$file; // connect to the FTP server $conn_id = ftp_connect($ftp_host); // login on the FTP server $login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass); if ((!$conn_id) || (!$login_result)) { // if the connection failes, put an error in the correct array $text="FTP connection to '".$ftp_host."' failed!"; }else{ if ($ftp_passive=='y'){ // use passive mode ftp_pasv($conn_id, true); } // upload the ZIP file the the FTP server $upload = ftp_put($conn_id, $ftp_path.$file, $file_to_upload, FTP_BINARY); if (!$upload) { // if the uploading failed, put an error in the correct array $text="Uploading of '".$file."' to '".$ftp_host."' failed!"; } else { $text="Uploaded '".$file."' to '".$ftp_host."'"; } $ftp_filelisting = ftp_nlist($conn_id, $ftp_path); if(!$ftp_filelisting){ // if getting the filename(s) failed, put an error in the correct array $text.="
Could not get the filename(s) on the FTP server."; } } // close FTP connection ftp_close($conn_id); return $text; } //******************************************************************************************************************* // MISCELLANEOUS FUNCTIONS //******************************************************************************************************************* ### Format Bytes Into KB/MB function format_size($rawSize) { if($rawSize / 1073741824 > 1) return round($rawSize/1048576, 1) . ' GB'; else if ($rawSize / 1048576 > 1) return round($rawSize/1048576, 1) . ' MB'; else if ($rawSize / 1024 > 1) return round($rawSize/1024, 1) . ' KB'; else return round($rawSize, 1) . ' bytes'; } ### Get File Extension function file_ext($file_name) { return substr(strrchr($file_name, '.'), 1); } ### Check Folder Whether There Is Any File Inside function is_emtpy_folder($folder){ if(is_dir($folder) ){ $handle = opendir($folder); while( (gettype( $name = readdir($handle)) != 'boolean')){ $name_array[] = $name; } foreach($name_array as $temp) $folder_content .= $temp; if($folder_content == '...') return true; else return false; closedir($handle); } else return true; // folder doesnt exist } class zipfile { var $datasec = array(); var $ctrl_dir = array(); var $eof_ctrl_dir = "\x50\x4b\x05\x06\x00\x00\x00\x00"; var $old_offset = 0; function add_dir($name) { $fr = "\x50\x4b\x03\x04"; $fr .= "\x0a\x00"; $fr .= "\x00\x00"; $fr .= "\x00\x00"; $fr .= "\x00\x00\x00\x00"; $fr .= pack("V",0); $fr .= pack("V",0); $fr .= pack("V",0); $fr .= pack("v", strlen($name) ); $fr .= pack("v", 0 ); $fr .= $name; $fr .= pack("V", 0); $fr .= pack("V", 0); $fr .= pack("V", 0); $this -> datasec[] = $fr; $new_offset = strlen(implode("", $this->datasec)); $cdrec = "\x50\x4b\x01\x02"; $cdrec .="\x00\x00"; $cdrec .="\x0a\x00"; $cdrec .="\x00\x00"; $cdrec .="\x00\x00"; $cdrec .="\x00\x00\x00\x00"; $cdrec .= pack("V",0); $cdrec .= pack("V",0); $cdrec .= pack("V",0); $cdrec .= pack("v", strlen($name) ); $cdrec .= pack("v", 0 ); $cdrec .= pack("v", 0 ); $cdrec .= pack("v", 0 ); $cdrec .= pack("v", 0 ); $ext = "\x00\x00\x10\x00"; $ext = "\xff\xff\xff\xff"; $cdrec .= pack("V", 16 ); $cdrec .= pack("V", $this -> old_offset ); $cdrec .= $name; $this -> ctrl_dir[] = $cdrec; $this -> old_offset = $new_offset; return; } function add_file($data, $name) { $fp = fopen($data,"r"); $data = fread($fp,filesize($data)); fclose($fp); $name = str_replace("\\", "/", $name); $unc_len = strlen($data); $crc = crc32($data); $zdata = gzcompress($data); $zdata = substr ($zdata, 2, -4); $c_len = strlen($zdata); $fr = "\x50\x4b\x03\x04"; $fr .= "\x14\x00"; $fr .= "\x00\x00"; $fr .= "\x08\x00"; $fr .= "\x00\x00\x00\x00"; $fr .= pack("V",$crc); $fr .= pack("V",$c_len); $fr .= pack("V",$unc_len); $fr .= pack("v", strlen($name) ); $fr .= pack("v", 0 ); $fr .= $name; $fr .= $zdata; $fr .= pack("V",$crc); $fr .= pack("V",$c_len); $fr .= pack("V",$unc_len); $this -> datasec[] = $fr; $new_offset = strlen(implode("", $this->datasec)); $cdrec = "\x50\x4b\x01\x02"; $cdrec .="\x00\x00"; $cdrec .="\x14\x00"; $cdrec .="\x00\x00"; $cdrec .="\x08\x00"; $cdrec .="\x00\x00\x00\x00"; $cdrec .= pack("V",$crc); $cdrec .= pack("V",$c_len); $cdrec .= pack("V",$unc_len); $cdrec .= pack("v", strlen($name) ); $cdrec .= pack("v", 0 ); $cdrec .= pack("v", 0 ); $cdrec .= pack("v", 0 ); $cdrec .= pack("v", 0 ); $cdrec .= pack("V", 32 ); $cdrec .= pack("V", $this -> old_offset ); $this -> old_offset = $new_offset; $cdrec .= $name; $this -> ctrl_dir[] = $cdrec; } function file() { $data = implode("", $this -> datasec); $ctrldir = implode("", $this -> ctrl_dir); return $data . $ctrldir . $this -> eof_ctrl_dir . pack("v", sizeof($this -> ctrl_dir)) . pack("v", sizeof($this -> ctrl_dir)) . pack("V", strlen($ctrldir)) . pack("V", strlen($data)) . "\x00\x00"; } } function CreateSQLfile($SQLsavepath, $pixelpost_db_host, $pixelpost_db_user, $pixelpost_db_pass, $pixelpost_db_pixelpost){ global $pixelpost_db_prefix; $DBMan_backup=sql_array("select * from {$pixelpost_db_prefix}DBManager LIMIT 1"); $drop_database = $DBMan_backup['drop_database']; $empty_tables = $DBMan_backup['empty_tables']; // set Standard header if ($drop_database=='y'){ $alloutput = "# PIXELPOST SQL dump\r\n#\r\n#Timestamp : " .date("Y-m-d H:i:s") . "\r\n# Database : `".$pixelpost_db_pixelpost."`\r\n#\r\n# --------------------------------------------------------;"; } else { $alloutput = "# PIXELPOST SQL dump\r\n#\r\n#Timestamp : " .date("Y-m-d H:i:s") . "\r\n# Database : `".$pixelpost_db_pixelpost."`\r\n#\r\n# --------------------------------------------------------"; } $i = 0; $query = mysql_query('SHOW TABLE STATUS FROM `'.$pixelpost_db_pixelpost.'`'); while($row = mysql_fetch_array($query)){ foreach($row AS $name => $value){ if(!is_numeric($name)){ $data[$i][$name] = $value; } } $i++; } // put the name of the tabels in the array '$tables' $tables = array(); foreach($data AS $i => $XXX){ $tables[] = $data[$i]['Name']; } // tabel names are in $tables[], and I've a database name... let's start ! // search for $search and replace them for $replace $search = array("\x00", "\x0a", "\x0d", "\x1a"); $replace = array('\0', '\n', '\r', '\Z'); // repeat this foreach tablename foreach($tables AS $key => $tablename){ $i = 0; if ($drop_database=='y'){ $query3 = mysql_query("SHOW TABLE STATUS LIKE '".$tablename."'"); $tableinfo = mysql_fetch_array($query3); if (!$tableinfo['Auto_increment']){ $id=1; } else { $id = $tableinfo['Auto_increment']; } $query4 = mysql_query('SHOW CREATE TABLE ' . $tablename . ''); while($SQLDump = mysql_fetch_row($query4)){ $alloutput .= "\r\n\r\n#\r\n# Table structure for table `". $tablename . "`\r\n#\r\n\r\n"; $alloutput .= "DROP TABLE IF EXISTS `".$tablename."`;\r\n\r\n"; $alloutput .= $SQLDump[1]." AUTO_INCREMENT=".$id.";\r\n"; } } // Get the values out of the table $query = mysql_query('SELECT * FROM ' . $tablename . ''); if ($empty_tables=='y'){ $alloutput .= "\r\n\r\n#\r\n# Data for table `". $tablename . "`\r\n#\r\n\r\nTRUNCATE `".$tablename."`;\r\n\r\n"; } else { $alloutput .= "\r\n\r\n#\r\n# Data for table `". $tablename . "`\r\n#\r\n\r\n"; } while($row = mysql_fetch_assoc($query)){ // a bit output for the SQL file $alloutput .= 'INSERT INTO ' . $tablename . ' VALUES ('; // get the rownames $query2 = mysql_query('SHOW FIELDS FROM ' . $tablename . ''); $i = 0; while($row2 = mysql_fetch_assoc($query2)){ if($i != 0){ $alloutput .= ','; } if($row[$row2['Field']] == '\'\''){ $alloutput .= '\'\''; } elseif(strpos($row2['Type'],'text') !== FALSE OR strpos($row2['Type'],'blob') !== FALSE) { // replace $search for $replace. if (!get_magic_quotes_gpc()) { $alloutput .= '\'' . str_replace($search, $replace, addslashes($row[$row2['Field']])) . '\''; } else { $alloutput .= '\'' . str_replace($search, $replace, addslashes($row[$row2['Field']])) . '\''; } } else { if (!get_magic_quotes_gpc()) { $alloutput .= '\'' . addslashes($row[$row2['Field']]) . '\''; } else { $alloutput .= '\'' . addslashes($row[$row2['Field']]) . '\''; } } $i++; } // end of a 'INSERT'. Close it with a ");\r\n $alloutput .= ");\r\n"; } // This tabel is ready, stop or start a new one... add two brakes (\r\n\r\n) $alloutput .= "\r\n\r\n"; } // Closing footer $alloutput .= "\r\n# --------------------------------------------------------\r\n#Dump complete"; // write SQL file $allshortsqlname = "SQL_backup_".date("Y-m-d_H.i.s").".sql"; $allsqlname = $SQLsavepath . $allshortsqlname; // Create the SQL file $handle = fopen($allsqlname, 'w'); fwrite($handle, $alloutput); fclose($handle); return array($allshortsqlname); } function CreateZipFile($zipname, $filearray, $SQLsavepath){ $shortzipname = $zipname; $zipname = $SQLsavepath . $shortzipname; $oZipfile = new zipfile(); foreach ($filearray as $addfile) { if (file_exists($SQLsavepath.$addfile)) { if($oZipfile->add_file($SQLsavepath.$addfile, $addfile) == TRUE) // if it goes wrong { // put an error in the correct array $Msg="Could not place the .sql file in the .zip file."; } else { $Msg="Zip file succesfully created!."; } }else{ //if the zip file exist, put an error in the correct array $Msg="The file (".$addfile.") could not be found!."; } } // Create the zip file $fp = fopen($zipname, 'wb'); $out = fwrite($fp, $oZipfile->file()); fclose ($fp); return $Msg; } function array_datesort($a, $b) { if ($a['date'] == $b['date']) { return 0; } return ($a['date'] < $b['date']) ? -1 : 1; } function detect_mysql() { $paths = array('mysql' => '', 'mysqldump' => ''); if(substr(PHP_OS,0,3) == 'WIN') { $query = mysql_query("SHOW VARIABLES LIKE 'basedir'"); while($row = mysql_fetch_assoc($query)){ $basedir=$row['Value']; } if($basedir!="") { $install_path = str_replace('\\', '/', $basedir); $paths['mysql'] = $install_path.'bin/mysql.exe'; $paths['mysqldump'] = $install_path.'bin/mysqldump.exe'; } else { $paths['mysql'] = 'mysql.exe'; $paths['mysqldump'] = 'mysqldump.exe'; } } else { if(function_exists('exec')) { $paths['mysql'] = exec('which mysql'); $paths['mysqldump'] = exec('which mysqldump'); } else { $paths['mysql'] = 'mysql'; $paths['mysqldump'] = 'mysqldump'; } } return $paths; } ?>