| 250 |
kaklik |
1 |
<?php |
|
|
2 |
/* $Id: export.php,v 2.38.2.2 2006/04/14 09:45:23 lem9 Exp $ */ |
|
|
3 |
// vim: expandtab sw=4 ts=4 sts=4: |
|
|
4 |
|
|
|
5 |
/** |
|
|
6 |
* Get the variables sent or posted to this script and a core script |
|
|
7 |
*/ |
|
|
8 |
require_once('./libraries/common.lib.php'); |
|
|
9 |
require_once('./libraries/zip.lib.php'); |
|
|
10 |
|
|
|
11 |
PMA_checkParameters(array('what', 'export_type')); |
|
|
12 |
|
|
|
13 |
// What type of export are we doing? |
|
|
14 |
if ($what == 'excel') { |
|
|
15 |
$type = 'csv'; |
|
|
16 |
} else { |
|
|
17 |
$type = $what; |
|
|
18 |
} |
|
|
19 |
|
|
|
20 |
// Get the functions specific to the export type |
|
|
21 |
require('./libraries/export/' . PMA_securePath($type) . '.php'); |
|
|
22 |
|
|
|
23 |
// Generate error url |
|
|
24 |
if ($export_type == 'server') { |
|
|
25 |
$err_url = 'server_export.php?' . PMA_generate_common_url(); |
|
|
26 |
} elseif ($export_type == 'database' && isset($db) && strlen($db)) { |
|
|
27 |
$err_url = 'db_details_export.php?' . PMA_generate_common_url($db); |
|
|
28 |
} elseif ($export_type == 'table' && isset($db) && strlen($db) && isset($table) && strlen($table)) { |
|
|
29 |
$err_url = 'tbl_properties_export.php?' . PMA_generate_common_url($db, $table); |
|
|
30 |
} else { |
|
|
31 |
die('Bad parameters!'); |
|
|
32 |
} |
|
|
33 |
|
|
|
34 |
/** |
|
|
35 |
* Increase time limit for script execution and initializes some variables |
|
|
36 |
*/ |
|
|
37 |
@set_time_limit($cfg['ExecTimeLimit']); |
|
|
38 |
if (!empty($cfg['MemoryLimit'])) { |
|
|
39 |
@ini_set('memory_limit', $cfg['MemoryLimit']); |
|
|
40 |
} |
|
|
41 |
|
|
|
42 |
// Start with empty buffer |
|
|
43 |
$dump_buffer = ''; |
|
|
44 |
$dump_buffer_len = 0; |
|
|
45 |
|
|
|
46 |
// We send fake headers to avoid browser timeout when buffering |
|
|
47 |
$time_start = time(); |
|
|
48 |
|
|
|
49 |
|
|
|
50 |
/** |
|
|
51 |
* Output handler for all exports, if needed buffering, it stores data into |
|
|
52 |
* $dump_buffer, otherwise it prints thems out. |
|
|
53 |
* |
|
|
54 |
* @param string the insert statement |
|
|
55 |
* |
|
|
56 |
* @return bool Whether output suceeded |
|
|
57 |
*/ |
|
|
58 |
function PMA_exportOutputHandler($line) |
|
|
59 |
{ |
|
|
60 |
global $time_start, $dump_buffer, $dump_buffer_len, $save_filename; |
|
|
61 |
|
|
|
62 |
// Kanji encoding convert feature |
|
|
63 |
if ($GLOBALS['output_kanji_conversion']) { |
|
|
64 |
$line = PMA_kanji_str_conv($line, $GLOBALS['knjenc'], isset($GLOBALS['xkana']) ? $GLOBALS['xkana'] : ''); |
|
|
65 |
} |
|
|
66 |
// If we have to buffer data, we will perform everything at once at the end |
|
|
67 |
if ($GLOBALS['buffer_needed']) { |
|
|
68 |
|
|
|
69 |
$dump_buffer .= $line; |
|
|
70 |
if ($GLOBALS['onfly_compression']) { |
|
|
71 |
|
|
|
72 |
$dump_buffer_len += strlen($line); |
|
|
73 |
|
|
|
74 |
if ($dump_buffer_len > $GLOBALS['memory_limit']) { |
|
|
75 |
if ($GLOBALS['output_charset_conversion']) { |
|
|
76 |
$dump_buffer = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $dump_buffer); |
|
|
77 |
} |
|
|
78 |
// as bzipped |
|
|
79 |
if ($GLOBALS['compression'] == 'bzip' && @function_exists('bzcompress')) { |
|
|
80 |
$dump_buffer = bzcompress($dump_buffer); |
|
|
81 |
} |
|
|
82 |
// as a gzipped file |
|
|
83 |
elseif ($GLOBALS['compression'] == 'gzip' && @function_exists('gzencode')) { |
|
|
84 |
// without the optional parameter level because it bug |
|
|
85 |
$dump_buffer = gzencode($dump_buffer); |
|
|
86 |
} |
|
|
87 |
if ($GLOBALS['save_on_server']) { |
|
|
88 |
$write_result = @fwrite($GLOBALS['file_handle'], $dump_buffer); |
|
|
89 |
if (!$write_result || ($write_result != strlen($dump_buffer))) { |
|
|
90 |
$GLOBALS['message'] = sprintf($GLOBALS['strNoSpace'], htmlspecialchars($save_filename)); |
|
|
91 |
$GLOBALS['show_error_header'] = TRUE; |
|
|
92 |
return FALSE; |
|
|
93 |
} |
|
|
94 |
} else { |
|
|
95 |
echo $dump_buffer; |
|
|
96 |
} |
|
|
97 |
$dump_buffer = ''; |
|
|
98 |
$dump_buffer_len = 0; |
|
|
99 |
} |
|
|
100 |
} else { |
|
|
101 |
$time_now = time(); |
|
|
102 |
if ($time_start >= $time_now + 30) { |
|
|
103 |
$time_start = $time_now; |
|
|
104 |
header('X-pmaPing: Pong'); |
|
|
105 |
} // end if |
|
|
106 |
} |
|
|
107 |
} else { |
|
|
108 |
if ($GLOBALS['asfile']) { |
|
|
109 |
if ($GLOBALS['save_on_server'] && strlen($line) > 0) { |
|
|
110 |
$write_result = @fwrite($GLOBALS['file_handle'], $line); |
|
|
111 |
if (!$write_result || ($write_result != strlen($line))) { |
|
|
112 |
$GLOBALS['message'] = sprintf($GLOBALS['strNoSpace'], htmlspecialchars($save_filename)); |
|
|
113 |
$GLOBALS['show_error_header'] = TRUE; |
|
|
114 |
return FALSE; |
|
|
115 |
} |
|
|
116 |
$time_now = time(); |
|
|
117 |
if ($time_start >= $time_now + 30) { |
|
|
118 |
$time_start = $time_now; |
|
|
119 |
header('X-pmaPing: Pong'); |
|
|
120 |
} // end if |
|
|
121 |
} else { |
|
|
122 |
// We export as file - output normally |
|
|
123 |
if ($GLOBALS['output_charset_conversion']) { |
|
|
124 |
$line = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $line); |
|
|
125 |
} |
|
|
126 |
echo $line; |
|
|
127 |
} |
|
|
128 |
} else { |
|
|
129 |
// We export as html - replace special chars |
|
|
130 |
echo htmlspecialchars($line); |
|
|
131 |
} |
|
|
132 |
} |
|
|
133 |
return TRUE; |
|
|
134 |
} // end of the 'PMA_exportOutputHandler()' function |
|
|
135 |
|
|
|
136 |
// Will we save dump on server? |
|
|
137 |
$save_on_server = isset($cfg['SaveDir']) && !empty($cfg['SaveDir']) && !empty($onserver); |
|
|
138 |
|
|
|
139 |
// Ensure compressed formats are associated with the download feature |
|
|
140 |
if (empty($asfile)) { |
|
|
141 |
if ($save_on_server) { |
|
|
142 |
$asfile = TRUE; |
|
|
143 |
} elseif (isset($compression) && ($compression == 'zip' | $compression == 'gzip' | $compression == 'bzip')) { |
|
|
144 |
$asfile = TRUE; |
|
|
145 |
} else { |
|
|
146 |
$asfile = FALSE; |
|
|
147 |
} |
|
|
148 |
} else { |
|
|
149 |
$asfile = TRUE; |
|
|
150 |
} |
|
|
151 |
|
|
|
152 |
// Defines the default <CR><LF> format. For SQL always use \n as MySQL wants this on all platforms. |
|
|
153 |
if ($what == 'sql') { |
|
|
154 |
$crlf = "\n"; |
|
|
155 |
} else { |
|
|
156 |
$crlf = PMA_whichCrlf(); |
|
|
157 |
} |
|
|
158 |
|
|
|
159 |
$output_kanji_conversion = function_exists('PMA_kanji_str_conv') && $type != 'xls'; |
|
|
160 |
|
|
|
161 |
// Do we need to convert charset? |
|
|
162 |
$output_charset_conversion = $asfile && |
|
|
163 |
$cfg['AllowAnywhereRecoding'] && $allow_recoding |
|
|
164 |
&& isset($charset_of_file) && $charset_of_file != $charset |
|
|
165 |
&& $type != 'xls'; |
|
|
166 |
|
|
|
167 |
// Set whether we will need buffering |
|
|
168 |
$buffer_needed = isset($compression) && ($compression == 'zip' | $compression == 'gzip' | $compression == 'bzip'); |
|
|
169 |
|
|
|
170 |
// Use on fly compression? |
|
|
171 |
$onfly_compression = $GLOBALS['cfg']['CompressOnFly'] && isset($compression) && ($compression == 'gzip' | $compression == 'bzip'); |
|
|
172 |
if ($onfly_compression) { |
|
|
173 |
$memory_limit = trim(@ini_get('memory_limit')); |
|
|
174 |
// 2 MB as default |
|
|
175 |
if (empty($memory_limit)) { |
|
|
176 |
$memory_limit = 2 * 1024 * 1024; |
|
|
177 |
} |
|
|
178 |
|
|
|
179 |
if (strtolower(substr($memory_limit, -1)) == 'm') { |
|
|
180 |
$memory_limit = (int)substr($memory_limit, 0, -1) * 1024 * 1024; |
|
|
181 |
} elseif (strtolower(substr($memory_limit, -1)) == 'k') { |
|
|
182 |
$memory_limit = (int)substr($memory_limit, 0, -1) * 1024; |
|
|
183 |
} elseif (strtolower(substr($memory_limit, -1)) == 'g') { |
|
|
184 |
$memory_limit = (int)substr($memory_limit, 0, -1) * 1024 * 1024 * 1024; |
|
|
185 |
} else { |
|
|
186 |
$memory_limit = (int)$memory_limit; |
|
|
187 |
} |
|
|
188 |
|
|
|
189 |
// Some of memory is needed for other thins and as treshold. |
|
|
190 |
// Nijel: During export I had allocated (see memory_get_usage function) |
|
|
191 |
// approx 1.2MB so this comes from that. |
|
|
192 |
if ($memory_limit > 1500000) { |
|
|
193 |
$memory_limit -= 1500000; |
|
|
194 |
} |
|
|
195 |
|
|
|
196 |
// Some memory is needed for compression, assume 1/3 |
|
|
197 |
$memory_limit *= 2/3; |
|
|
198 |
} |
|
|
199 |
|
|
|
200 |
// Generate filename and mime type if needed |
|
|
201 |
if ($asfile) { |
|
|
202 |
$pma_uri_parts = parse_url($cfg['PmaAbsoluteUri']); |
|
|
203 |
if ($export_type == 'server') { |
|
|
204 |
if (isset($remember_template)) { |
|
|
205 |
setcookie('pma_server_filename_template', $filename_template, 0, $GLOBALS['cookie_path'], '', $GLOBALS['is_https']); |
|
|
206 |
} |
|
|
207 |
$filename = str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template)); |
|
|
208 |
} elseif ($export_type == 'database') { |
|
|
209 |
if (isset($remember_template)) { |
|
|
210 |
setcookie('pma_db_filename_template', $filename_template, 0, $GLOBALS['cookie_path'], '', $GLOBALS['is_https']); |
|
|
211 |
} |
|
|
212 |
$filename = str_replace('__DB__', $db, str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template))); |
|
|
213 |
} else { |
|
|
214 |
if (isset($remember_template)) { |
|
|
215 |
setcookie('pma_table_filename_template', $filename_template, 0, $GLOBALS['cookie_path'], '', $GLOBALS['is_https']); |
|
|
216 |
} |
|
|
217 |
$filename = str_replace('__TABLE__', $table, str_replace('__DB__', $db, str_replace('__SERVER__', $GLOBALS['cfg']['Server']['host'], strftime($filename_template)))); |
|
|
218 |
} |
|
|
219 |
|
|
|
220 |
// convert filename to iso-8859-1, it is safer |
|
|
221 |
if (!(isset($cfg['AllowAnywhereRecoding']) && $cfg['AllowAnywhereRecoding'] && $allow_recoding)) { |
|
|
222 |
$filename = PMA_convert_string($charset, 'iso-8859-1', $filename); |
|
|
223 |
} else { |
|
|
224 |
$filename = PMA_convert_string($convcharset, 'iso-8859-1', $filename); |
|
|
225 |
} |
|
|
226 |
|
|
|
227 |
// Generate basic dump extension |
|
|
228 |
if ($type == 'csv') { |
|
|
229 |
$filename .= '.csv'; |
|
|
230 |
$mime_type = 'text/comma-separated-values'; |
|
|
231 |
} elseif ($type == 'htmlexcel') { |
|
|
232 |
$filename .= '.xls'; |
|
|
233 |
$mime_type = 'application/vnd.ms-excel'; |
|
|
234 |
} elseif ($type == 'htmlword') { |
|
|
235 |
$filename .= '.doc'; |
|
|
236 |
$mime_type = 'application/vnd.ms-word'; |
|
|
237 |
} elseif ($type == 'xls') { |
|
|
238 |
$filename .= '.xls'; |
|
|
239 |
$mime_type = 'application/vnd.ms-excel'; |
|
|
240 |
} elseif ($type == 'xml') { |
|
|
241 |
$filename .= '.xml'; |
|
|
242 |
$mime_type = 'text/xml'; |
|
|
243 |
} elseif ($type == 'latex') { |
|
|
244 |
$filename .= '.tex'; |
|
|
245 |
$mime_type = 'application/x-tex'; |
|
|
246 |
} elseif ($type == 'pdf') { |
|
|
247 |
$filename .= '.pdf'; |
|
|
248 |
$mime_type = 'application/pdf'; |
|
|
249 |
} else { |
|
|
250 |
$filename .= '.sql'; |
|
|
251 |
// text/x-sql is correct MIME type, however safari ignores further |
|
|
252 |
// Content-Disposition header, so we must force it to download it this |
|
|
253 |
// way... |
|
|
254 |
$mime_type = PMA_USR_BROWSER_AGENT == 'SAFARI' |
|
|
255 |
? 'application/octet-stream' |
|
|
256 |
: 'text/x-sql'; |
|
|
257 |
} |
|
|
258 |
|
|
|
259 |
// If dump is going to be compressed, set correct encoding or mime_type and add |
|
|
260 |
// compression to extension |
|
|
261 |
$content_encoding = ''; |
|
|
262 |
if (isset($compression) && $compression == 'bzip') { |
|
|
263 |
$filename .= '.bz2'; |
|
|
264 |
// browsers don't like this: |
|
|
265 |
//$content_encoding = 'x-bzip2'; |
|
|
266 |
$mime_type = 'application/x-bzip2'; |
|
|
267 |
} elseif (isset($compression) && $compression == 'gzip') { |
|
|
268 |
$filename .= '.gz'; |
|
|
269 |
// Needed to avoid recompression by server modules like mod_gzip. |
|
|
270 |
// It seems necessary to check about zlib.output_compression |
|
|
271 |
// to avoid compressing twice |
|
|
272 |
if (!@ini_get('zlib.output_compression')) { |
|
|
273 |
$content_encoding = 'x-gzip'; |
|
|
274 |
$mime_type = 'application/x-gzip'; |
|
|
275 |
} |
|
|
276 |
} elseif (isset($compression) && $compression == 'zip') { |
|
|
277 |
$filename .= '.zip'; |
|
|
278 |
$mime_type = 'application/zip'; |
|
|
279 |
} |
|
|
280 |
} |
|
|
281 |
|
|
|
282 |
// Open file on server if needed |
|
|
283 |
if ($save_on_server) { |
|
|
284 |
$save_filename = PMA_userDir($cfg['SaveDir']) . preg_replace('@[/\\\\]@', '_', $filename); |
|
|
285 |
unset($message); |
|
|
286 |
if (file_exists($save_filename) && empty($onserverover)) { |
|
|
287 |
$message = sprintf($strFileAlreadyExists, htmlspecialchars($save_filename)); |
|
|
288 |
$GLOBALS['show_error_header'] = TRUE; |
|
|
289 |
} else { |
|
|
290 |
if (is_file($save_filename) && !is_writable($save_filename)) { |
|
|
291 |
$message = sprintf($strNoPermission, htmlspecialchars($save_filename)); |
|
|
292 |
$GLOBALS['show_error_header'] = TRUE; |
|
|
293 |
} else { |
|
|
294 |
if (!$file_handle = @fopen($save_filename, 'w')) { |
|
|
295 |
$message = sprintf($strNoPermission, htmlspecialchars($save_filename)); |
|
|
296 |
$GLOBALS['show_error_header'] = TRUE; |
|
|
297 |
} |
|
|
298 |
} |
|
|
299 |
} |
|
|
300 |
if (isset($message)) { |
|
|
301 |
$js_to_run = 'functions.js'; |
|
|
302 |
require_once('./libraries/header.inc.php'); |
|
|
303 |
if ($export_type == 'server') { |
|
|
304 |
$active_page = 'server_export.php'; |
|
|
305 |
require('./server_export.php'); |
|
|
306 |
} elseif ($export_type == 'database') { |
|
|
307 |
$active_page = 'db_details_export.php'; |
|
|
308 |
require('./db_details_export.php'); |
|
|
309 |
} else { |
|
|
310 |
$active_page = 'tbl_properties_export.php'; |
|
|
311 |
require('./tbl_properties_export.php'); |
|
|
312 |
} |
|
|
313 |
exit(); |
|
|
314 |
} |
|
|
315 |
} |
|
|
316 |
|
|
|
317 |
/** |
|
|
318 |
* Send headers depending on whether the user chose to download a dump file |
|
|
319 |
* or not |
|
|
320 |
*/ |
|
|
321 |
if (!$save_on_server) { |
|
|
322 |
if ($asfile ) { |
|
|
323 |
// Download |
|
|
324 |
if (!empty($content_encoding)) { |
|
|
325 |
header('Content-Encoding: ' . $content_encoding); |
|
|
326 |
} |
|
|
327 |
header('Content-Type: ' . $mime_type); |
|
|
328 |
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT'); |
|
|
329 |
// lem9: Tested behavior of |
|
|
330 |
// IE 5.50.4807.2300 |
|
|
331 |
// IE 6.0.2800.1106 (small glitch, asks twice when I click Open) |
|
|
332 |
// IE 6.0.2900.2180 |
|
|
333 |
// Firefox 1.0.6 |
|
|
334 |
// in http and https |
|
|
335 |
header('Content-Disposition: attachment; filename="' . $filename . '"'); |
|
|
336 |
if (PMA_USR_BROWSER_AGENT == 'IE') { |
|
|
337 |
header('Cache-Control: must-revalidate, post-check=0, pre-check=0'); |
|
|
338 |
header('Pragma: public'); |
|
|
339 |
} else { |
|
|
340 |
header('Pragma: no-cache'); |
|
|
341 |
} |
|
|
342 |
} else { |
|
|
343 |
// HTML |
|
|
344 |
$backup_cfgServer = $cfg['Server']; |
|
|
345 |
require_once('./libraries/header.inc.php'); |
|
|
346 |
$cfg['Server'] = $backup_cfgServer; |
|
|
347 |
unset($backup_cfgServer); |
|
|
348 |
echo "\n" . '<div align="' . $cell_align_left . '">' . "\n"; |
|
|
349 |
//echo ' <pre>' . "\n"; |
|
|
350 |
echo ' <form name="nofunction">' . "\n" |
|
|
351 |
// remove auto-select for now: there is no way to select |
|
|
352 |
// only a part of the text; anyway, it should obey |
|
|
353 |
// $cfg['TextareaAutoSelect'] |
|
|
354 |
//. ' <textarea name="sqldump" cols="50" rows="30" onclick="this.select();" id="textSQLDUMP" wrap="OFF">' . "\n"; |
|
|
355 |
. ' <textarea name="sqldump" cols="50" rows="30" id="textSQLDUMP" wrap="OFF">' . "\n"; |
|
|
356 |
} // end download |
|
|
357 |
} |
|
|
358 |
|
|
|
359 |
// Check if we have something to export |
|
|
360 |
if ($export_type == 'database') { |
|
|
361 |
$tables = PMA_DBI_get_tables($db); |
|
|
362 |
$num_tables = count($tables); |
|
|
363 |
if ($num_tables == 0) { |
|
|
364 |
$message = $strNoTablesFound; |
|
|
365 |
$js_to_run = 'functions.js'; |
|
|
366 |
require_once('./libraries/header.inc.php'); |
|
|
367 |
if ($export_type == 'server') { |
|
|
368 |
$active_page = 'server_export.php'; |
|
|
369 |
require('./server_export.php'); |
|
|
370 |
} elseif ($export_type == 'database') { |
|
|
371 |
$active_page = 'db_details_export.php'; |
|
|
372 |
require('./db_details_export.php'); |
|
|
373 |
} else { |
|
|
374 |
$active_page = 'tbl_properties_export.php'; |
|
|
375 |
require('./tbl_properties_export.php'); |
|
|
376 |
} |
|
|
377 |
exit(); |
|
|
378 |
} |
|
|
379 |
} |
|
|
380 |
|
|
|
381 |
// Fake loop just to allow skip of remain of this code by break, I'd really |
|
|
382 |
// need exceptions here :-) |
|
|
383 |
do { |
|
|
384 |
|
|
|
385 |
// Add possibly some comments to export |
|
|
386 |
if (!PMA_exportHeader()) { |
|
|
387 |
break; |
|
|
388 |
} |
|
|
389 |
|
|
|
390 |
// Will we need relation & co. setup? |
|
|
391 |
$do_relation = isset($GLOBALS[$what . '_relation']); |
|
|
392 |
$do_comments = isset($GLOBALS[$what . '_comments']); |
|
|
393 |
$do_mime = isset($GLOBALS[$what . '_mime']); |
|
|
394 |
if ($do_relation || $do_comments || $do_mime) { |
|
|
395 |
require_once('./libraries/relation.lib.php'); |
|
|
396 |
$cfgRelation = PMA_getRelationsParam(); |
|
|
397 |
} |
|
|
398 |
if ($do_mime) { |
|
|
399 |
require_once('./libraries/transformations.lib.php'); |
|
|
400 |
} |
|
|
401 |
|
|
|
402 |
// Include dates in export? |
|
|
403 |
$do_dates = isset($GLOBALS[$what . '_dates']); |
|
|
404 |
|
|
|
405 |
/** |
|
|
406 |
* Builds the dump |
|
|
407 |
*/ |
|
|
408 |
// Gets the number of tables if a dump of a database has been required |
|
|
409 |
if ($export_type == 'server') { |
|
|
410 |
/** |
|
|
411 |
* Gets the databases list - if it has not been built yet |
|
|
412 |
*/ |
|
|
413 |
if ($server > 0 && empty($dblist)) { |
|
|
414 |
PMA_availableDatabases(); |
|
|
415 |
} |
|
|
416 |
|
|
|
417 |
if (isset($db_select)) { |
|
|
418 |
$tmp_select = implode($db_select, '|'); |
|
|
419 |
$tmp_select = '|' . $tmp_select . '|'; |
|
|
420 |
} |
|
|
421 |
// Walk over databases |
|
|
422 |
foreach ($dblist AS $current_db) { |
|
|
423 |
if ((isset($tmp_select) && strpos(' ' . $tmp_select, '|' . $current_db . '|')) |
|
|
424 |
|| !isset($tmp_select)) { |
|
|
425 |
if (!PMA_exportDBHeader($current_db)) { |
|
|
426 |
break 2; |
|
|
427 |
} |
|
|
428 |
if (!PMA_exportDBCreate($current_db)) { |
|
|
429 |
break 2; |
|
|
430 |
} |
|
|
431 |
$tables = PMA_DBI_get_tables($current_db); |
|
|
432 |
$views = array(); |
|
|
433 |
foreach ($tables as $table) { |
|
|
434 |
// if this is a view, collect it for later; views must be exported |
|
|
435 |
// after the tables |
|
|
436 |
if (PMA_tableIsView($current_db, $table)) { |
|
|
437 |
$views[] = $table; |
|
|
438 |
continue; |
|
|
439 |
} |
|
|
440 |
$local_query = 'SELECT * FROM ' . PMA_backquote($current_db) . '.' . PMA_backquote($table); |
|
|
441 |
if (isset($GLOBALS[$what . '_structure'])) { |
|
|
442 |
if (!PMA_exportStructure($current_db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) { |
|
|
443 |
break 3; |
|
|
444 |
} |
|
|
445 |
} |
|
|
446 |
if (isset($GLOBALS[$what . '_data'])) { |
|
|
447 |
if (!PMA_exportData($current_db, $table, $crlf, $err_url, $local_query)) { |
|
|
448 |
break 3; |
|
|
449 |
} |
|
|
450 |
} |
|
|
451 |
} |
|
|
452 |
foreach($views as $view) { |
|
|
453 |
// no data export for a view |
|
|
454 |
if (isset($GLOBALS[$what . '_structure'])) { |
|
|
455 |
if (!PMA_exportStructure($current_db, $view, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) { |
|
|
456 |
break 3; |
|
|
457 |
} |
|
|
458 |
} |
|
|
459 |
} |
|
|
460 |
if (!PMA_exportDBFooter($current_db)) { |
|
|
461 |
break 2; |
|
|
462 |
} |
|
|
463 |
} |
|
|
464 |
} |
|
|
465 |
} elseif ($export_type == 'database') { |
|
|
466 |
if (!PMA_exportDBHeader($db)) { |
|
|
467 |
break; |
|
|
468 |
} |
|
|
469 |
|
|
|
470 |
if (isset($table_select)) { |
|
|
471 |
$tmp_select = implode($table_select, '|'); |
|
|
472 |
$tmp_select = '|' . $tmp_select . '|'; |
|
|
473 |
} |
|
|
474 |
$i = 0; |
|
|
475 |
$views = array(); |
|
|
476 |
foreach ($tables as $table) { |
|
|
477 |
// if this is a view, collect it for later; views must be exported after |
|
|
478 |
// the tables |
|
|
479 |
if (PMA_tableIsView($db, $table)) { |
|
|
480 |
$views[] = $table; |
|
|
481 |
continue; |
|
|
482 |
} |
|
|
483 |
$local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table); |
|
|
484 |
if ((isset($tmp_select) && strpos(' ' . $tmp_select, '|' . $table . '|')) |
|
|
485 |
|| !isset($tmp_select)) { |
|
|
486 |
|
|
|
487 |
if (isset($GLOBALS[$what . '_structure'])) { |
|
|
488 |
if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) { |
|
|
489 |
break 2; |
|
|
490 |
} |
|
|
491 |
} |
|
|
492 |
if (isset($GLOBALS[$what . '_data'])) { |
|
|
493 |
if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) { |
|
|
494 |
break 2; |
|
|
495 |
} |
|
|
496 |
} |
|
|
497 |
} |
|
|
498 |
} |
|
|
499 |
foreach ($views as $view) { |
|
|
500 |
// no data export for a view |
|
|
501 |
if (isset($GLOBALS[$what . '_structure'])) { |
|
|
502 |
if (!PMA_exportStructure($db, $view, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) { |
|
|
503 |
break 2; |
|
|
504 |
} |
|
|
505 |
} |
|
|
506 |
} |
|
|
507 |
if (!PMA_exportDBFooter($db)) { |
|
|
508 |
break; |
|
|
509 |
} |
|
|
510 |
} else { |
|
|
511 |
if (!PMA_exportDBHeader($db)) { |
|
|
512 |
break; |
|
|
513 |
} |
|
|
514 |
// We export just one table |
|
|
515 |
|
|
|
516 |
if ($limit_to > 0 && $limit_from >= 0) { |
|
|
517 |
$add_query = ' LIMIT ' |
|
|
518 |
. (($limit_from > 0) ? $limit_from . ', ' : '') |
|
|
519 |
. $limit_to; |
|
|
520 |
} else { |
|
|
521 |
$add_query = ''; |
|
|
522 |
} |
|
|
523 |
|
|
|
524 |
if (!empty($sql_query)) { |
|
|
525 |
// only preg_replace if needed |
|
|
526 |
if (!empty($add_query)) { |
|
|
527 |
// remove trailing semicolon before adding a LIMIT |
|
|
528 |
$sql_query = preg_replace('%;\s*$%', '', $sql_query); |
|
|
529 |
} |
|
|
530 |
$local_query = $sql_query . $add_query; |
|
|
531 |
PMA_DBI_select_db($db); |
|
|
532 |
} else { |
|
|
533 |
$local_query = 'SELECT * FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table) . $add_query; |
|
|
534 |
} |
|
|
535 |
|
|
|
536 |
if (isset($GLOBALS[$what . '_structure'])) { |
|
|
537 |
if (!PMA_exportStructure($db, $table, $crlf, $err_url, $do_relation, $do_comments, $do_mime, $do_dates)) { |
|
|
538 |
break; |
|
|
539 |
} |
|
|
540 |
} |
|
|
541 |
// I think we have to export data for a single view; for example PDF report |
|
|
542 |
if (isset($GLOBALS[$what . '_data'])) { |
|
|
543 |
if (!PMA_exportData($db, $table, $crlf, $err_url, $local_query)) { |
|
|
544 |
break; |
|
|
545 |
} |
|
|
546 |
} |
|
|
547 |
if (!PMA_exportDBFooter($db)) { |
|
|
548 |
break; |
|
|
549 |
} |
|
|
550 |
} |
|
|
551 |
if (!PMA_exportFooter()) { |
|
|
552 |
break; |
|
|
553 |
} |
|
|
554 |
|
|
|
555 |
} while (FALSE); |
|
|
556 |
// End of fake loop |
|
|
557 |
|
|
|
558 |
if ($save_on_server && isset($message)) { |
|
|
559 |
$js_to_run = 'functions.js'; |
|
|
560 |
require_once('./libraries/header.inc.php'); |
|
|
561 |
if ($export_type == 'server') { |
|
|
562 |
$active_page = 'server_export.php'; |
|
|
563 |
require('./server_export.php'); |
|
|
564 |
} elseif ($export_type == 'database') { |
|
|
565 |
$active_page = 'db_details_export.php'; |
|
|
566 |
require('./db_details_export.php'); |
|
|
567 |
} else { |
|
|
568 |
$active_page = 'tbl_properties_export.php'; |
|
|
569 |
require('./tbl_properties_export.php'); |
|
|
570 |
} |
|
|
571 |
exit(); |
|
|
572 |
} |
|
|
573 |
|
|
|
574 |
/** |
|
|
575 |
* Send the dump as a file... |
|
|
576 |
*/ |
|
|
577 |
if (!empty($asfile)) { |
|
|
578 |
// Convert the charset if required. |
|
|
579 |
if ($output_charset_conversion) { |
|
|
580 |
$dump_buffer = PMA_convert_string($GLOBALS['charset'], $GLOBALS['charset_of_file'], $dump_buffer); |
|
|
581 |
} |
|
|
582 |
|
|
|
583 |
// Do the compression |
|
|
584 |
// 1. as a gzipped file |
|
|
585 |
if (isset($compression) && $compression == 'zip') { |
|
|
586 |
if (@function_exists('gzcompress')) { |
|
|
587 |
$zipfile = new zipfile(); |
|
|
588 |
$zipfile -> addFile($dump_buffer, substr($filename, 0, -4)); |
|
|
589 |
$dump_buffer = $zipfile -> file(); |
|
|
590 |
} |
|
|
591 |
} |
|
|
592 |
// 2. as a bzipped file |
|
|
593 |
elseif (isset($compression) && $compression == 'bzip') { |
|
|
594 |
if (@function_exists('bzcompress')) { |
|
|
595 |
$dump_buffer = bzcompress($dump_buffer); |
|
|
596 |
if ($dump_buffer === -8) { |
|
|
597 |
require_once('./libraries/header.inc.php'); |
|
|
598 |
echo sprintf($strBzError, '<a href="http://bugs.php.net/bug.php?id=17300" target="_blank">17300</a>'); |
|
|
599 |
require_once('./libraries/footer.inc.php'); |
|
|
600 |
} |
|
|
601 |
} |
|
|
602 |
} |
|
|
603 |
// 3. as a gzipped file |
|
|
604 |
elseif (isset($compression) && $compression == 'gzip') { |
|
|
605 |
if (@function_exists('gzencode')) { |
|
|
606 |
// without the optional parameter level because it bug |
|
|
607 |
$dump_buffer = gzencode($dump_buffer); |
|
|
608 |
} |
|
|
609 |
} |
|
|
610 |
|
|
|
611 |
/* If ve saved on server, we have to close file now */ |
|
|
612 |
if ($save_on_server) { |
|
|
613 |
$write_result = @fwrite($file_handle, $dump_buffer); |
|
|
614 |
fclose($file_handle); |
|
|
615 |
if (strlen($dump_buffer) !=0 && (!$write_result || ($write_result != strlen($dump_buffer)))) { |
|
|
616 |
$message = sprintf($strNoSpace, htmlspecialchars($save_filename)); |
|
|
617 |
} else { |
|
|
618 |
$message = sprintf($strDumpSaved, htmlspecialchars($save_filename)); |
|
|
619 |
} |
|
|
620 |
|
|
|
621 |
$js_to_run = 'functions.js'; |
|
|
622 |
require_once('./libraries/header.inc.php'); |
|
|
623 |
if ($export_type == 'server') { |
|
|
624 |
$active_page = 'server_export.php'; |
|
|
625 |
require_once('./server_export.php'); |
|
|
626 |
} elseif ($export_type == 'database') { |
|
|
627 |
$active_page = 'db_details_export.php'; |
|
|
628 |
require_once('./db_details_export.php'); |
|
|
629 |
} else { |
|
|
630 |
$active_page = 'tbl_properties_export.php'; |
|
|
631 |
require_once('./tbl_properties_export.php'); |
|
|
632 |
} |
|
|
633 |
exit(); |
|
|
634 |
} else { |
|
|
635 |
echo $dump_buffer; |
|
|
636 |
} |
|
|
637 |
} |
|
|
638 |
/** |
|
|
639 |
* Displays the dump... |
|
|
640 |
*/ |
|
|
641 |
else { |
|
|
642 |
/** |
|
|
643 |
* Close the html tags and add the footers in dump is displayed on screen |
|
|
644 |
*/ |
|
|
645 |
//echo ' </pre>' . "\n"; |
|
|
646 |
echo '</textarea>' . "\n" |
|
|
647 |
. ' </form>' . "\n"; |
|
|
648 |
echo '</div>' . "\n"; |
|
|
649 |
echo "\n"; |
|
|
650 |
?> |
|
|
651 |
<script type="text/javascript" language="javascript"> |
|
|
652 |
//<![CDATA[ |
|
|
653 |
var bodyWidth=null; var bodyHeight=null; |
|
|
654 |
if (document.getElementById('textSQLDUMP')) { |
|
|
655 |
bodyWidth = self.innerWidth; |
|
|
656 |
bodyHeight = self.innerHeight; |
|
|
657 |
if (!bodyWidth && !bodyHeight) { |
|
|
658 |
if (document.compatMode && document.compatMode == "BackCompat") { |
|
|
659 |
bodyWidth = document.body.clientWidth; |
|
|
660 |
bodyHeight = document.body.clientHeight; |
|
|
661 |
} else if (document.compatMode && document.compatMode == "CSS1Compat") { |
|
|
662 |
bodyWidth = document.documentElement.clientWidth; |
|
|
663 |
bodyHeight = document.documentElement.clientHeight; |
|
|
664 |
} |
|
|
665 |
} |
|
|
666 |
document.getElementById('textSQLDUMP').style.width=(bodyWidth-50) + 'px'; |
|
|
667 |
document.getElementById('textSQLDUMP').style.height=(bodyHeight-100) + 'px'; |
|
|
668 |
} |
|
|
669 |
//]]> |
|
|
670 |
</script> |
|
|
671 |
<?php |
|
|
672 |
require_once('./libraries/footer.inc.php'); |
|
|
673 |
} // end if |
|
|
674 |
?> |