2 /* vim: set expandtab sw=4 ts=4 sts=4: */
6 * @package phpMyAdmin-Designer
12 include_once 'pmd_common.php';
13 if (! isset($scale)) {
15 include_once 'pmd_save_pos.php';
17 require_once './libraries/relation.lib.php';
19 if (isset($scale) && ! isset($createpage)) {
20 if (empty($pdf_page_number)) {
21 die("<script>alert('Pages not found!');history.go(-2);</script>");
24 $pmd_table = PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($GLOBALS['cfgRelation']['designer_coords']);
25 $pma_table = PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']);
26 $scale_q = PMA_sqlAddslashes($scale);
27 $pdf_page_number_q = PMA_sqlAddslashes($pdf_page_number);
31 $sql = "REPLACE INTO " . $pma_table . " (db_name, table_name, pdf_page_number, x, y) SELECT db_name, table_name, " . $pdf_page_number_q . ", ROUND(x/" . $scale_q . ") , ROUND(y/" . $scale_q . ") y FROM " . $pmd_table . " WHERE db_name = '" . PMA_sqlAddslashes($db) . "'";
33 PMA_query_as_cu($sql,TRUE,PMA_DBI_QUERY_STORE
);
38 'UPDATE ' . $pma_table . ',' . $pmd_table .
39 ' SET ' . $pmd_table . '.`x`= ' . $pma_table . '.`x` * '. $scale_q . ',
40 ' . $pmd_table . '.`y`= ' . $pma_table . '.`y` * '.$scale_q.'
42 ' . $pmd_table . '.`db_name`=' . $pma_table . '.`db_name`
44 ' . $pmd_table . '.`table_name` = ' . $pma_table . '.`table_name`
46 ' . $pmd_table . '.`db_name`=\'' . PMA_sqlAddslashes($db) .'\'
47 AND pdf_page_number = ' . $pdf_page_number_q . ';',TRUE,PMA_DBI_QUERY_STORE
); }
49 die("<script>alert('$strModifications');history.go(-2);</script>");
51 if (isset($createpage)) {
55 $query_default_option = PMA_DBI_QUERY_STORE
;
57 $pdf_page_number = PMA_REL_create_page($newpage, $cfgRelation, $db, $query_default_option);
59 // no need to use pmd/styles
60 require_once './libraries/header_meta_style.inc.php';
66 <form name
="form1" method
="post" action
="pmd_pdf.php">
67 <?php
echo PMA_generate_common_hidden_inputs($db); ?
>
69 <fieldset
><legend
><?php
echo $GLOBALS['strExport'] . '/' . $GLOBALS['strImport']; ?
></legend
>
70 <p
><?php
echo $strExportImportToScale; ?
>:
72 <option value
="1">1:1</option
>
73 <option value
="2">1:2</option
>
74 <option value
="3" selected
>1:3 (<?php
echo $strRecommended; ?
>)</option
>
75 <option value
="4">1:4</option
>
76 <option value
="5">1:5</option
>
79 <p
><?php
echo $strToFromPage; ?
>:
81 <select name
="pdf_page_number">
83 $table_info_result = PMA_query_as_cu('SELECT * FROM '.PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['pdf_pages']).'
84 WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'');
85 while($page = PMA_DBI_fetch_assoc($table_info_result))
88 <option value
="<?php echo $page['page_nr'] ?>"><?php
echo htmlspecialchars($page['page_descr']) ?
></option
>
93 <input type
="submit" name
="exp" value
="<?php echo $strExport; ?>">
94 <input type
="submit" name
="imp" value
="<?php echo $strImport; ?>">
98 <fieldset
><legend
><?php
echo $GLOBALS['strCreatePage']; ?
></legend
>
99 <input type
="text" name
="newpage" />
100 <input type
="submit" name
="createpage" value
="<?php echo $strGo; ?>">