diff options
Diffstat (limited to 'hugo/pmd_pdf.php')
| -rw-r--r-- | hugo/pmd_pdf.php | 163 |
1 files changed, 163 insertions, 0 deletions
diff --git a/hugo/pmd_pdf.php b/hugo/pmd_pdf.php new file mode 100644 index 0000000..47144de --- /dev/null +++ b/hugo/pmd_pdf.php @@ -0,0 +1,163 @@ +<?php +/* vim: set expandtab sw=4 ts=4 sts=4: */ +/** + * + * @package PhpMyAdmin-Designer + */ + +require_once './libraries/common.inc.php'; +require_once 'libraries/pmd_common.php'; + +/** + * Validate vulnerable POST parameters + */ +if (isset($_POST['scale']) && ! PMA_isValid($_POST['scale'], 'numeric')) { + die('Attack stopped'); +} + +/** + * Sets globals from $_POST + */ +$post_params = array( + 'db', + 'mode', + 'newpage', + 'pdf_page_number', + 'scale' +); + +foreach ($post_params as $one_post_param) { + if (isset($_POST[$one_post_param])) { + $GLOBALS[$one_post_param] = $_POST[$one_post_param]; + } +} + +/** + * If called directly from the designer, first save the positions + */ +if (! isset($scale)) { + $no_die_save_pos = 1; + include_once 'pmd_save_pos.php'; +} + +if (isset($mode)) { + if ('create_export' != $mode && empty($pdf_page_number)) { + die("<script>alert('Pages not found!');history.go(-2);</script>"); + } + + $pmd_table = PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.' + . PMA_Util::backquote($GLOBALS['cfgRelation']['designer_coords']); + $pma_table = PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.' + . PMA_Util::backquote($cfgRelation['table_coords']); + $scale_q = PMA_Util::sqlAddSlashes($scale); + + if ('create_export' == $mode) { + $pdf_page_number = PMA_REL_createPage($newpage, $cfgRelation, $db); + if ($pdf_page_number > 0) { + $message = PMA_Message::success(__('Page has been created')); + $mode = 'export'; + } else { + $message = PMA_Message::error(__('Page creation failed')); + } + } + + $pdf_page_number_q = PMA_Util::sqlAddSlashes($pdf_page_number); + + if ('export' == $mode) { + $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_Util::sqlAddSlashes($db) . "'"; + + PMA_queryAsControlUser($sql, true, PMA_DBI_QUERY_STORE); + } + + if ('import' == $mode) { + PMA_queryAsControlUser( + 'UPDATE ' . $pma_table . ',' . $pmd_table . + ' SET ' . $pmd_table . '.`x`= ' . $pma_table . '.`x` * '. $scale_q . ', + ' . $pmd_table . '.`y`= ' . $pma_table . '.`y` * '. $scale_q .' + WHERE + ' . $pmd_table . '.`db_name`=' . $pma_table . '.`db_name` + AND + ' . $pmd_table . '.`table_name` = ' . $pma_table . '.`table_name` + AND + ' . $pmd_table . '.`db_name`=\''. PMA_Util::sqlAddSlashes($db) . '\' + AND pdf_page_number = ' . $pdf_page_number_q . ';', + true, PMA_DBI_QUERY_STORE + ); + } +} + +$response = PMA_Response::getInstance(); +$response->getFooter()->setMinimal(); + +?> +<br/> +<div> +<?php +if (! empty($message)) { + $message->display(); +} +?> + <form name="form1" method="post" action="pmd_pdf.php"> +<?php +echo PMA_generate_common_hidden_inputs($db); +echo '<div>'; +echo '<fieldset><legend>' . __('Import/Export coordinates for PDF schema') . '</legend>'; + +$choices = array(); + +$table_info_result = PMA_queryAsControlUser( + 'SELECT * FROM ' . PMA_Util::backquote($GLOBALS['cfgRelation']['db']) + . '.' . PMA_Util::backquote($cfgRelation['pdf_pages']) + . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\'' +); + +if (PMA_DBI_num_rows($table_info_result) > 0) { + echo '<p>' . __('Page') . ':'; + echo '<select name="pdf_page_number">'; + + while ($page = PMA_DBI_fetch_assoc($table_info_result)) { + echo '<option value="' . $page['page_nr'] . '">'; + echo htmlspecialchars($page['page_descr']); + echo '</option>'; + } + echo '</select>'; + echo '</p>'; + $choices['import'] = __('Import from selected page'); + $choices['export'] = __('Export to selected page'); +} +$choices['create_export'] = __('Create a page and export to it'); + +if (1 == count($choices)) { + echo $choices['create_export']; + echo '<input type="hidden" name="mode" value="create_export" />'; +} else { + echo PMA_Util::getRadioFields( + 'mode', $choices, $checked_choice = '', $line_break = true, + $escape_label = false, $class = '' + ); +} +echo '<br />'; +echo '<label for="newpage">' . __('New page name: ') . '</label>'; +echo '<input id="newpage" type="text" name="newpage" />'; + +echo '<p>' . __('Export/Import to scale') . ':'; +?> + <select name="scale"> + <option value="1">1:1</option> + <option value="2">1:2</option> + <option value="3" selected="selected">1:3 (<?php echo __('recommended'); ?>)</option> + <option value="4">1:4</option> + <option value="5">1:5</option> + </select> + </p> + <input type="submit" value="<?php echo __('Go'); ?>"/> + </fieldset> + </div> + </form> +</div> + |