pmd_pdf.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin-Designer
   6  */
   7
   8 require_once './libraries/common.inc.php';
   9 require_once 'libraries/pmd_common.php';
  10
  11 /**
  12  * Validate vulnerable POST parameters
  13  */
  14 if (isset($_POST['scale']) && ! PMA_isValid($_POST['scale'], 'numeric')) {
  15     die('Attack stopped');
  16 }
  17
  18 /**
  19   * Sets globals from $_POST
  20   */
  21 $post_params = array(
  22     'db',
  23     'mode',
  24     'newpage',
  25     'pdf_page_number',
  26     'scale'
  27 );
  28
  29 foreach ($post_params as $one_post_param) {
  30     if (isset($_POST[$one_post_param])) {
  31         $GLOBALS[$one_post_param] = $_POST[$one_post_param];
  32     }
  33 }
  34
  35 /**
  36  * If called directly from the designer, first save the positions
  37  */
  38 if (! isset($scale)) {
  39     $no_die_save_pos = 1;
  40     include_once 'pmd_save_pos.php';
  41 }
  42
  43 if (isset($mode)) {
  44     if ('create_export' != $mode && empty($pdf_page_number)) {
  45         die("<script>alert('Pages not found!');history.go(-2);</script>");
  46     }
  47
  48     $pmd_table = PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
  49         . PMA_Util::backquote($GLOBALS['cfgRelation']['designer_coords']);
  50     $pma_table = PMA_Util::backquote($GLOBALS['cfgRelation']['db']) . '.'
  51         . PMA_Util::backquote($cfgRelation['table_coords']);
  52     $scale_q = PMA_Util::sqlAddSlashes($scale);
  53
  54     if ('create_export' == $mode) {
  55         $pdf_page_number = PMA_REL_createPage($newpage, $cfgRelation, $db);
  56         if ($pdf_page_number > 0) {
  57             $message = PMA_Message::success(__('Page has been created'));
  58             $mode = 'export';
  59         } else {
  60             $message = PMA_Message::error(__('Page creation failed'));
  61         }
  62     }
  63
  64     $pdf_page_number_q = PMA_Util::sqlAddSlashes($pdf_page_number);
  65
  66     if ('export' == $mode) {
  67         $sql = "REPLACE INTO " . $pma_table
  68             . " (db_name, table_name, pdf_page_number, x, y)"
  69             . " SELECT db_name, table_name, " . $pdf_page_number_q . ","
  70             . " ROUND(x/" . $scale_q . ") , ROUND(y/" . $scale_q . ") y"
  71             . " FROM " . $pmd_table
  72             . " WHERE db_name = '" . PMA_Util::sqlAddSlashes($db) . "'";
  73
  74         PMA_queryAsControlUser($sql, true, PMA_DBI_QUERY_STORE);
  75     }
  76
  77     if ('import' == $mode) {
  78         PMA_queryAsControlUser(
  79             'UPDATE ' . $pma_table . ',' . $pmd_table .
  80             ' SET ' . $pmd_table . '.`x`= ' . $pma_table . '.`x` * '. $scale_q . ',
  81             ' . $pmd_table . '.`y`= ' . $pma_table . '.`y` * '. $scale_q .'
  82             WHERE
  83             ' . $pmd_table . '.`db_name`=' . $pma_table . '.`db_name`
  84             AND
  85             ' . $pmd_table . '.`table_name` = ' . $pma_table . '.`table_name`
  86             AND
  87             ' . $pmd_table . '.`db_name`=\''. PMA_Util::sqlAddSlashes($db) . '\'
  88             AND pdf_page_number = ' . $pdf_page_number_q . ';',
  89             true, PMA_DBI_QUERY_STORE
  90         );
  91     }
  92 }
  93
  94 $response = PMA_Response::getInstance();
  95 $response->getFooter()->setMinimal();
  96
  97 ?>
  98 <br/>
  99 <div>
 100 <?php
 101 if (! empty($message)) {
 102     $message->display();
 103 }
 104 ?>
 105   <form name="form1" method="post" action="pmd_pdf.php">
 106 <?php
 107 echo PMA_generate_common_hidden_inputs($db);
 108 echo '<div>';
 109 echo '<fieldset><legend>' . __('Import/Export coordinates for PDF schema') . '</legend>';
 110
 111 $choices = array();
 112
 113 $table_info_result = PMA_queryAsControlUser(
 114     'SELECT * FROM ' . PMA_Util::backquote($GLOBALS['cfgRelation']['db'])
 115     . '.' . PMA_Util::backquote($cfgRelation['pdf_pages'])
 116     . ' WHERE db_name = \'' . PMA_Util::sqlAddSlashes($db) . '\''
 117 );
 118
 119 if (PMA_DBI_num_rows($table_info_result) > 0) {
 120     echo '<p>' . __('Page') . ':';
 121     echo '<select name="pdf_page_number">';
 122
 123     while ($page = PMA_DBI_fetch_assoc($table_info_result)) {
 124         echo '<option value="' . $page['page_nr'] . '">';
 125         echo htmlspecialchars($page['page_descr']);
 126         echo '</option>';
 127     }
 128     echo '</select>';
 129     echo '</p>';
 130     $choices['import'] = __('Import from selected page');
 131     $choices['export'] = __('Export to selected page');
 132 }
 133 $choices['create_export'] = __('Create a page and export to it');
 134
 135 if (1 == count($choices)) {
 136     echo $choices['create_export'];
 137     echo '<input type="hidden" name="mode" value="create_export" />';
 138 } else {
 139     echo PMA_Util::getRadioFields(
 140         'mode', $choices, $checked_choice = '', $line_break = true,
 141         $escape_label = false, $class = ''
 142     );
 143 }
 144 echo '<br />';
 145 echo '<label for="newpage">' . __('New page name: ') . '</label>';
 146 echo '<input id="newpage" type="text" name="newpage" />';
 147
 148 echo '<p>' . __('Export/Import to scale') . ':';
 149 ?>
 150       <select name="scale">
 151         <option value="1">1:1</option>
 152         <option value="2">1:2</option>
 153         <option value="3" selected="selected">1:3 (<?php echo __('recommended'); ?>)</option>
 154         <option value="4">1:4</option>
 155         <option value="5">1:5</option>
 156       </select>
 157       </p>
 158       <input type="submit" value="<?php echo __('Go'); ?>"/>
 159     </fieldset>
 160     </div>
 161   </form>
 162 </div>
 163