Файловый менеджер

Файловый менеджер - Редактировать - C:/xampp/phpMyAdmin/libraries/schema/User_Schema.class.php

Назад
<?php /* vim: set expandtab sw=4 ts=4 sts=4: / /* * * @package phpMyAdmin / /* * This Class interacts with the user to gather the information * about their tables for which they want to export the relational schema * export options are shown to user from they can choose * * @name User_Schema * @copyright * @license / class PMA_User_Schema { public $chosenPage; public $autoLayoutForeign; public $autoLayoutInternal; public $pageNumber; public $c_table_rows; public $action; public function setAction($value) { $this->action = $value; } /* * This function will process the user defined pages * and tables which will be exported as Relational schema * you can set the table positions on the paper via scratchboard * for table positions, put the x,y co-ordinates * * @param string $this->action It tells what the Schema is supposed to do * create and select a page, generate schema etc * @access public / public function processUserChoice() { global $action_choose,$db,$cfgRelation,$cfg,$query_default_option; if (isset($this->action)) { switch ($this->action) { case 'selectpage': $this->chosenPage = $_REQUEST['chpage']; if ($action_choose=="1") { $this->deleteCoordinates($db, $cfgRelation, $this->chosenPage, $query_default_option); $this->deletePages($db, $cfgRelation, $this->chosenPage, $query_default_option); $this->chosenPage = 0; } break; case 'createpage': $this->pageNumber = PMA_REL_create_page($_POST['newpage'], $cfgRelation, $db, $query_default_option); $this->autoLayoutForeign = isset($_POST['auto_layout_foreign']) ? "1":NULL; $this->autoLayoutInternal = isset($_POST['auto_layout_internal']) ? "1":NULL; $this->processRelations($db, $this->pageNumber,$cfgRelation,$query_default_option); break; case 'edcoord': $this->chosenPage = $_POST['chpage']; $this->c_table_rows = $_POST['c_table_rows']; $this->_editCoordinates($db, $cfgRelation,$query_default_option); break; case 'delete_old_references': $this->_deleteTableRows($delrow,$cfgRelation,$db,$this->chosenPage); break; case 'process_export': $this->_processExportSchema(); break; } // end switch } // end if (isset($do)) } /* * shows/displays the HTML FORM to create the page * * @param string db name of the selected database * @return void * @access public / public function showCreatePageDialog($db) { ?> <form method="post" action="schema_edit.php" name="frm_create_page"> <fieldset> <legend> <?php echo __('Create a page') . "\n"; ?> </legend> <?php echo PMA_generate_common_hidden_inputs($db); ?> <input type="hidden" name="do" value="createpage" /> <table> <tr> <td><label for="id_newpage"><?php echo __('Page name'); ?></label></td> <td><input type="text" name="newpage" id="id_newpage" size="20" maxlength="50" /></td> </tr> <tr> <td><?php echo __('Automatic layout based on'); ?></td> <td> <input type="checkbox" name="auto_layout_internal" id="id_auto_layout_internal" /><label for="id_auto_layout_internal"> <?php echo __('Internal relations'); ?></label><br /> <?php / * Check to see whether INNODB and PBXT storage engines are Available in MYSQL PACKAGE * If available, then provide AutoLayout for Foreign Keys in Schema View / if (PMA_StorageEngine::isValid('InnoDB') \|\| PMA_StorageEngine::isValid('PBXT')) { ?> <input type="checkbox" name="auto_layout_foreign" id="id_auto_layout_foreign" /><label for="id_auto_layout_foreign"> <?php echo __('FOREIGN KEY'); ?></label><br /> <?php } ?> </td></tr> </table> </fieldset> <fieldset class="tblFooters"> <input type="submit" value="<?php echo __('Go'); ?>" /> </fieldset> </form> <?php } /* * shows/displays the created page names in a drop down list * User can select any page number and edit it using dashboard etc * * @return void * @access public / public function selectPage() { global $db,$table,$query_default_option,$cfgRelation; $page_query = 'SELECT FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['pdf_pages']) . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''; $page_rs = PMA_query_as_controluser($page_query, FALSE, $query_default_option); if ($page_rs && PMA_DBI_num_rows($page_rs) > 0) { ?> <form method="get" action="schema_edit.php" name="frm_select_page"> <fieldset> <legend> <?php echo __('Please choose a page to edit') . "\n"; ?> </legend> <?php echo PMA_generate_common_hidden_inputs($db, $table); ?> <input type="hidden" name="do" value="selectpage" /> <select name="chpage" id="chpage" onchange="this.form.submit()"> <option value="0"><?php echo __('Select page'); ?></option> <?php while ($curr_page = PMA_DBI_fetch_assoc($page_rs)) { echo "\n" . ' ' . '<option value="' . $curr_page['page_nr'] . '"'; if (isset($this->chosenPage) && $this->chosenPage == $curr_page['page_nr']) { echo ' selected="selected"'; } echo '>' . $curr_page['page_nr'] . ': ' . htmlspecialchars($curr_page['page_descr']) . '</option>'; } // end while echo "\n"; ?> </select> <?php $choices = array( '0' => __('Edit'), '1' => __('Delete') ); PMA_display_html_radio('action_choose', $choices, '0', false); unset($choices); ?> </fieldset> <fieldset class="tblFooters"> <input type="submit" value="<?php echo __('Go'); ?>" /><br /> </fieldset> </form> <?php } // end IF echo "\n"; } // end function /** * A dashboard is displayed to AutoLayout the position of tables * users can drag n drop the tables and change their positions * * @return void * @access public / public function showTableDashBoard() { global $db,$cfgRelation,$table,$cfg,$with_field_names,$query_default_option; / * We will need an array of all tables in this db / $selectboxall = array('--'); $alltab_rs = PMA_DBI_query('SHOW TABLES FROM ' . PMA_backquote($db) . ';', null, PMA_DBI_QUERY_STORE); while ($val = @PMA_DBI_fetch_row($alltab_rs)) { $selectboxall[] = $val[0]; } / * Now if we already have chosen a page number then we should * show the tables involved / if (isset($this->chosenPage) && $this->chosenPage > 0) { echo "\n"; ?> <h2><?php echo __('Select Tables') ;?></h2> <?php $page_query = 'SELECT FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . ' AND pdf_page_number = \'' . PMA_sqlAddslashes($this->chosenPage) . '\''; $page_rs = PMA_query_as_controluser($page_query, FALSE, $query_default_option); $array_sh_page = array(); while ($temp_sh_page = @PMA_DBI_fetch_assoc($page_rs)) { $array_sh_page[] = $temp_sh_page; } /* * Display WYSIWYG parts / if (!isset($_POST['with_field_names']) && !isset($_POST['showwysiwyg'])) { $with_field_names = TRUE; } $this->_displayScratchboardTables($array_sh_page); ?> <form method="post" action="schema_edit.php" name="edcoord"> <?php echo PMA_generate_common_hidden_inputs($db, $table); ?> <input type="hidden" name="chpage" value="<?php echo htmlspecialchars($this->chosenPage); ?>" /> <input type="hidden" name="do" value="edcoord" /> <table border="0"> <tr> <th><?php echo __('Table'); ?></th> <th><?php echo __('Delete'); ?></th> <th>X</th> <th>Y</th> </tr> <?php if (isset($ctable)) { unset($ctable); } $i = 0; $odd_row = true; foreach ($array_sh_page as $dummy_sh_page => $sh_page) { $_mtab = $sh_page['table_name']; $tabExist[$_mtab] = FALSE; echo "\n" . ' <tr class="noclick '; if ($odd_row) { echo 'odd'; } else { echo 'even'; } echo '">'; $odd_row != $odd_row; echo "\n" . ' <td>' . "\n" . ' <select name="c_table_' . $i . '[name]">'; foreach ($selectboxall as $key => $value) { echo "\n" . ' <option value="' . htmlspecialchars($value) . '"'; if ($value == $sh_page['table_name']) { echo ' selected="selected"'; $tabExist[$_mtab] = TRUE; } echo '>' . htmlspecialchars($value) . '</option>'; } echo "\n" . ' </select>' . "\n" . ' </td>'; echo "\n" . ' <td>' . "\n" . ' <input type="checkbox" id="id_c_table_' . $i .'" name="c_table_' . $i . '[delete]" value="y" /><label for="id_c_table_' . $i .'">' . __('Delete') . '</label>'; echo "\n" . ' </td>'; echo "\n" . ' <td>' . "\n" . ' <input type="text" onchange="dragPlace(' . $i . ', \'x\', this.value)" name="c_table_' . $i . '[x]" value="' . $sh_page['x'] . '" />'; echo "\n" . ' </td>'; echo "\n" . ' <td>' . "\n" . ' <input type="text" onchange="dragPlace(' . $i . ', \'y\', this.value)" name="c_table_' . $i . '[y]" value="' . $sh_page['y'] . '" />'; echo "\n" . ' </td>'; echo "\n" . ' </tr>'; $i++; } / * Add one more empty row / echo "\n" . ' <tr class="noclick '; if ($odd_row) { echo 'odd'; } else { echo 'even'; } $odd_row != $odd_row; echo '">'; echo "\n" . ' <td>' . "\n" . ' <select name="c_table_' . $i . '[name]">'; foreach ($selectboxall as $key => $value) { echo "\n" . ' <option value="' . htmlspecialchars($value) . '">' . htmlspecialchars($value) . '</option>'; } echo "\n" . ' </select>' . "\n" . ' </td>'; echo "\n" . ' <td>' . "\n" . ' <input type="checkbox" id="id_c_table_' . $i .'" name="c_table_' . $i . '[delete]" value="y" /><label for="id_c_table_' . $i .'">' . __('Delete') . '</label>'; echo "\n" . ' </td>'; echo "\n" . ' <td>' . "\n" . ' <input type="text" name="c_table_' . $i . '[x]" value="' . (isset($sh_page['x'])?$sh_page['x']:'') . '" />'; echo "\n" . ' </td>'; echo "\n" . ' <td>' . "\n" . ' <input type="text" name="c_table_' . $i . '[y]" value="' . (isset($sh_page['y'])?$sh_page['y']:'') . '" />'; echo "\n" . ' </td>'; echo "\n" . ' </tr>'; echo "\n" . ' </table>' . "\n"; echo "\n" . ' <input type="hidden" name="c_table_rows" value="' . ($i + 1) . '" />'; echo "\n" . ' <input type="hidden" id="showwysiwyg" name="showwysiwyg" value="' . ((isset($showwysiwyg) && $showwysiwyg == '1') ? '1' : '0') . '" />'; echo "\n" . ' <input type="checkbox" name="with_field_names" ' . (isset($with_field_names) ? 'checked="checked"' : ''). ' />' . __('Column names') . '<br />'; echo "\n" . ' <input type="submit" value="' . __('Save') . '" />'; echo "\n" . '</form>' . "\n\n"; } // end if $this->_deleteTables($db, $this->chosenPage, isset($tabExist)); } /* * show Export relational schema generation options * user can select export type of his own choice * and the attributes related to it * * @return void * @access public / public function displaySchemaGenerationOptions() { global $cfg,$pmaThemeImage,$db,$test_rs,$chpage; ?> <form method="post" action="schema_export.php"> <fieldset> <legend> <?php echo PMA_generate_common_hidden_inputs($db); if ($cfg['PropertiesIconic']) { echo '<img class="icon" src="' . $pmaThemeImage . 'b_view.png"' .' alt="" width="16" height="16" />'; } echo __('Display relational schema'); ?>: </legend> <select name="export_type" id="export_type"> <option value="pdf" selected="selected">PDF</option> <option value="svg">SVG</option> <option value="dia">DIA</option> <option value="visio">Visio</option> <option value="eps">EPS</option> </select> <label><?php echo __('Select Export Relational Type');?></label><br /> <?php if (isset($test_rs)) { ?> <label for="pdf_page_number_opt"><?php echo __('Page number:'); ?></label> <select name="pdf_page_number" id="pdf_page_number_opt"> <?php while ($pages = @PMA_DBI_fetch_assoc($test_rs)) { echo ' <option value="' . $pages['page_nr'] . '">' . $pages['page_nr'] . ': ' . htmlspecialchars($pages['page_descr']) . '</option>' . "\n"; } // end while PMA_DBI_free_result($test_rs); unset($test_rs); ?> </select><br /> <?php } else { ?> <input type="hidden" name="pdf_page_number" value="<?php echo htmlspecialchars($this->chosenPage); ?>" /> <?php } ?> <input type="hidden" name="do" value="process_export" /> <input type="hidden" name="chpage" value="<?php echo $chpage; ?>" /> <input type="checkbox" name="show_grid" id="show_grid_opt" /> <label for="show_grid_opt"><?php echo __('Show grid'); ?></label><br /> <input type="checkbox" name="show_color" id="show_color_opt" checked="checked" /> <label for="show_color_opt"><?php echo __('Show color'); ?></label><br /> <input type="checkbox" name="show_table_dimension" id="show_table_dim_opt" /> <label for="show_table_dim_opt"><?php echo __('Show dimension of tables'); ?> </label><br /> <input type="checkbox" name="all_table_same_wide" id="all_table_same_wide" /> <label for="all_table_same_wide"><?php echo __('Display all tables with the same width'); ?> </label><br /> <input type="checkbox" name="with_doc" id="with_doc" checked="checked" /> <label for="with_doc"><?php echo __('Data Dictionary'); ?></label><br /> <input type="checkbox" name="show_keys" id="show_keys" /> <label for="show_keys"><?php echo __('Only show keys'); ?></label><br /> <select name="orientation" id="orientation_opt" onchange="refreshDragOption('pdflayout');" > <option value="L"><?php echo __('Landscape');?></option> <option value="P"><?php echo __('Portrait');?></option> </select> <label for="orientation_opt"><?php echo __('Orientation'); ?></label> <br /> <select name="paper" id="paper_opt" onchange="refreshDragOption('pdflayout');"> <?php foreach ($cfg['PDFPageSizes'] as $key => $val) { echo '<option value="' . $val . '"'; if ($val == $cfg['PDFDefaultPageSize']) { echo ' selected="selected"'; } echo ' >' . $val . '</option>' . "\n"; } ?> </select> <label for="paper_opt"><?php echo __('Paper size'); ?></label> </fieldset> <fieldset class="tblFooters"> <input type="submit" value="<?php echo __('Go'); ?>" /> </fieldset> </form> <?php } /* * Check if there are tables that need to be deleted in dashboard, * if there are, ask the user for allowance * * @param string db name of database selected * @param integer chpage selected page * @param array tabExist * @return void * @access private / private function _deleteTables($db, $chpage, $tabExist) { $_strtrans = ''; $_strname = ''; $shoot = FALSE; if (!empty($tabExist) && is_array($tabExist)) { foreach ($tabExist as $key => $value) { if (!$value) { $_strtrans .= '<input type="hidden" name="delrow[]" value="' . htmlspecialchars($key) . '" />' . "\n"; $_strname .= '<li>' . htmlspecialchars($key) . '</li>' . "\n"; $shoot = TRUE; } } if ($shoot) { echo '<form action="schema_edit.php" method="post">' . "\n" . PMA_generate_common_hidden_inputs($db, $table) . '<input type="hidden" name="do" value="delete_old_references" />' . "\n" . '<input type="hidden" name="chpage" value="' . htmlspecialchars($chpage) . '" />' . "\n" . __('The current page has references to tables that no longer exist. Would you like to delete those references?') . '<ul>' . "\n" . $_strname . '</ul>' . "\n" . $_strtrans . '<input type="submit" value="' . __('Go') . '" />' . "\n" . '</form>'; } } } /* * Check if there are tables that need to be deleted in dashboard, * if there are, ask the user for allowance * * @return void * @access private / private function _displayScratchboardTables($array_sh_page) { global $with_field_names,$cfg,$db; ?> <script type="text/javascript" src="./js/dom-drag.js"></script> <form method="post" action="schema_edit.php" name="dragdrop"> <input type="button" name="dragdrop" value="<?php echo __('Toggle scratchboard'); ?>" onclick="ToggleDragDrop('pdflayout');" /> <input type="button" name="dragdropreset" value="<?php echo __('Reset'); ?>" onclick="resetDrag();" /> </form> <div id="pdflayout" class="pdflayout" style="visibility: hidden;"> <?php $draginit = ''; $draginit2 = ''; $reset_draginit = ''; $i = 0; foreach ($array_sh_page as $key => $temp_sh_page) { $drag_x = $temp_sh_page['x']; $drag_y = $temp_sh_page['y']; $draginit2 .= ' Drag.init(getElement("table_' . $i . '"), null, 0, parseInt(myid.style.width)-2, 0, parseInt(myid.style.height)-5);' . "\n"; $draginit2 .= ' getElement("table_' . $i . '").onDrag = function (x, y) { document.edcoord.elements["c_table_' . $i . '[x]"].value = parseInt(x); document.edcoord.elements["c_table_' . $i . '[y]"].value = parseInt(y) }' . "\n"; $draginit .= ' getElement("table_' . $i . '").style.left = "' . $drag_x . 'px";' . "\n"; $draginit .= ' getElement("table_' . $i . '").style.top = "' . $drag_y . 'px";' . "\n"; $reset_draginit .= ' getElement("table_' . $i . '").style.left = "2px";' . "\n"; $reset_draginit .= ' getElement("table_' . $i . '").style.top = "' . (15 $i) . 'px";' . "\n"; $reset_draginit .= ' document.edcoord.elements["c_table_' . $i . '[x]"].value = "2"' . "\n"; $reset_draginit .= ' document.edcoord.elements["c_table_' . $i . '[y]"].value = "' . (15 * $i) . '"' . "\n"; $local_query = 'SHOW FIELDS FROM ' . PMA_backquote($temp_sh_page['table_name']) . ' FROM ' . PMA_backquote($db); $fields_rs = PMA_DBI_query($local_query); unset($local_query); $fields_cnt = PMA_DBI_num_rows($fields_rs); echo '<div id="table_' . $i . '" class="pdflayout_table"><u>' . $temp_sh_page['table_name'] . '</u>'; if (isset($with_field_names)) { while ($row = PMA_DBI_fetch_assoc($fields_rs)) { echo '<br />' . htmlspecialchars($row['Field']) . "\n"; } } echo '</div>' . "\n"; PMA_DBI_free_result($fields_rs); unset($fields_rs); $i++; } ?> </div> <script type="text/javascript"> //<![CDATA[ function PDFinit() { refreshLayout(); myid = getElement('pdflayout'); <?php echo $draginit; ?> TableDragInit(); } function TableDragInit() { myid = getElement('pdflayout'); <?php echo $draginit2; ?> } function resetDrag() { <?php echo $reset_draginit; ?> } //]]> </script> <?php } /** * delete the table rows with table co-ordinates * * @param int delrow delete selected table from list of tables * @param array cfgRelation relation settings * @param string db database name * @param integer chpage selected page for adding relations etc * @return void * @access private / private function _deleteTableRows($delrow,$cfgRelation,$db,$chpage) { foreach ($delrow as $current_row) { $del_query = 'DELETE FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' ' . "\n" . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . "\n" . ' AND table_name = \'' . PMA_sqlAddslashes($current_row) . '\'' . "\n" . ' AND pdf_page_number = \'' . PMA_sqlAddslashes($chpage) . '\''; echo $del_query; PMA_query_as_controluser($del_query, FALSE, $query_default_option); } } /* * get all the export options and verify * call and include the appropriate Schema Class depending on $export_type * * @return void * @access private / private function _processExportSchema() { /* * Settings for relation stuff / require_once './libraries/transformations.lib.php'; require_once './libraries/Index.class.php'; /* * default is PDF, otherwise validate it's only letters a-z / global $db,$export_type; if (!isset($export_type) \|\| !preg_match('/^[a-zA-Z]+$/', $export_type)) { $export_type = 'pdf'; } PMA_DBI_select_db($db); include("./libraries/schema/".ucfirst($export_type)."_Relation_Schema.class.php"); $obj_schema = eval("new PMA_".ucfirst($export_type)."_Relation_Schema();"); } /* * delete X and Y coordinates * * @param string db The database name * @param array cfgRelation relation settings * @param integer choosePage selected page for adding relations etc * @return void * @access private / public function deleteCoordinates($db, $cfgRelation, $choosePage, $query_default_option) { $query = 'DELETE FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . ' AND pdf_page_number = \'' . PMA_sqlAddslashes($choosePage) . '\''; PMA_query_as_controluser($query, FALSE, $query_default_option); } /* * delete pages * * @param string db The database name * @param array cfgRelation relation settings * @param integer choosePage selected page for adding relations etc * @return void * @access private / public function deletePages($db, $cfgRelation, $choosePage, $query_default_option) { $query = 'DELETE FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['pdf_pages']) . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . ' AND page_nr = \'' . PMA_sqlAddslashes($choosePage) . '\''; PMA_query_as_controluser($query, FALSE, $query_default_option); } /* * process internal and foreign key relations * * @param string db The database name * @param array cfgRelation relation settings * @param integer pageNumber document number/Id * @return void * @access private / public function processRelations($db, $pageNumber, $cfgRelation, $query_default_option) { / * A u t o m a t i c l a y o u t * * There are 2 kinds of relations in PMA * 1) Internal Relations 2) Foreign Key Relations / if (isset($this->autoLayoutInternal) \|\| isset($this->autoLayoutForeign)) { $all_tables = array(); } if (isset($this->autoLayoutForeign)) { / * get the tables list * who support FOREIGN KEY, it's not * important that we group together InnoDB tables * and PBXT tables, as this logic is just to put * the tables on the layout, not to determine relations / $tables = PMA_DBI_get_tables_full($db); $foreignkey_tables = array(); foreach($tables as $table_name => $table_properties) { if (PMA_foreignkey_supported($table_properties['ENGINE'])) { $foreignkey_tables[] = $table_name; } } $all_tables = $foreignkey_tables; / * could be improved by finding the tables which have the * most references keys and placing them at the beginning * of the array (so that they are all center of schema) / unset($tables, $foreignkey_tables); } if (isset($this->autoLayoutInternal)) { / * get the tables list who support Internal Relations; * This type of relations will be created when * you setup the PMA tables correctly / $master_tables = 'SELECT COUNT(master_table), master_table' . ' FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['relation']) . ' WHERE master_db = \'' . $db . '\'' . ' GROUP BY master_table' . ' ORDER BY ' . PMA_backquote('COUNT(master_table)') . ' DESC '; $master_tables_rs = PMA_query_as_controluser($master_tables, FALSE, $query_default_option); if ($master_tables_rs && PMA_DBI_num_rows($master_tables_rs) > 0) { / first put all the master tables at beginning * of the list, so they are near the center of * the schema / while (list(, $master_table) = PMA_DBI_fetch_row($master_tables_rs)) { $all_tables[] = $master_table; } / Now for each master, add its foreigns into an array * of foreign tables, if not already there * (a foreign might be foreign for more than * one table, and might be a master itself) / $foreign_tables = array(); foreach ($all_tables as $master_table) { $foreigners = PMA_getForeigners($db, $master_table); foreach ($foreigners as $foreigner) { if (!in_array($foreigner['foreign_table'], $foreign_tables)) { $foreign_tables[] = $foreigner['foreign_table']; } } } / * Now merge the master and foreign arrays/tables / foreach ($foreign_tables as $foreign_table) { if (!in_array($foreign_table, $all_tables)) { $all_tables[] = $foreign_table; } } } } if (isset($this->autoLayoutInternal) \|\| isset($this->autoLayoutForeign)) { $this->addRelationCoordinates($all_tables,$pageNumber,$db, $cfgRelation,$query_default_option); } $this->chosenPage = $pageNumber; } /* * Add X and Y coordinates for a table * * @param string db The database name * @param array cfgRelation relation settings * @param integer pageNumber document number/Id * @param array all_tables A list of all tables involved * @return void * @access private / public function addRelationCoordinates($all_tables,$pageNumber,$db, $cfgRelation,$query_default_option) { / * Now generate the coordinates for the schema * in a clockwise spiral and add to co-ordinates table / $pos_x = 300; $pos_y = 300; $delta = 110; $delta_mult = 1.10; $direction = "right"; foreach ($all_tables as $current_table) { / * save current table's coordinates / $insert_query = 'INSERT INTO ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' ' . '(db_name, table_name, pdf_page_number, x, y) ' . 'VALUES (\'' . PMA_sqlAddslashes($db) . '\', \'' . PMA_sqlAddslashes($current_table) . '\',' . $pageNumber . ',' . $pos_x . ',' . $pos_y . ')'; PMA_query_as_controluser($insert_query, FALSE, $query_default_option); / * compute for the next table / switch ($direction) { case 'right': $pos_x += $delta; $direction = "down"; $delta = $delta_mult; break; case 'down': $pos_y += $delta; $direction = "left"; $delta = $delta_mult; break; case 'left': $pos_x -= $delta; $direction = "up"; $delta = $delta_mult; break; case 'up': $pos_y -= $delta; $direction = "right"; $delta = $delta_mult; break; } } } /* * update X and Y coordinates for a table * * @param string db The database name * @param array cfgRelation relation settings * @return void * @access private / private function _editCoordinates($db, $cfgRelation,$query_default_option) { for ($i = 0; $i < $this->c_table_rows; $i++) { $arrvalue = 'c_table_' . $i; global $$arrvalue; $arrvalue = $$arrvalue; if (!isset($arrvalue['x']) \|\| $arrvalue['x'] == '') { $arrvalue['x'] = 0; } if (!isset($arrvalue['y']) \|\| $arrvalue['y'] == '') { $arrvalue['y'] = 0; } if (isset($arrvalue['name']) && $arrvalue['name'] != '--') { $test_query = 'SELECT FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . ' AND table_name = \'' . PMA_sqlAddslashes($arrvalue['name']) . '\'' . ' AND pdf_page_number = \'' . PMA_sqlAddslashes($this->chosenPage) . '\''; $test_rs = PMA_query_as_controluser($test_query, FALSE, $query_default_option); //echo $test_query; if ($test_rs && PMA_DBI_num_rows($test_rs) > 0) { if (isset($arrvalue['delete']) && $arrvalue['delete'] == 'y') { $ch_query = 'DELETE FROM ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . ' AND table_name = \'' . PMA_sqlAddslashes($arrvalue['name']) . '\'' . ' AND pdf_page_number = \'' . PMA_sqlAddslashes($this->chosenPage) . '\''; } else { $ch_query = 'UPDATE ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' ' . 'SET x = ' . $arrvalue['x'] . ', y= ' . $arrvalue['y'] . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\'' . ' AND table_name = \'' . PMA_sqlAddslashes($arrvalue['name']) . '\'' . ' AND pdf_page_number = \'' . PMA_sqlAddslashes($this->chosenPage) . '\''; } } else { $ch_query = 'INSERT INTO ' . PMA_backquote($GLOBALS['cfgRelation']['db']) . '.' . PMA_backquote($cfgRelation['table_coords']) . ' ' . '(db_name, table_name, pdf_page_number, x, y) ' . 'VALUES (\'' . PMA_sqlAddslashes($db) . '\', \'' . PMA_sqlAddslashes($arrvalue['name']) . '\', \'' . PMA_sqlAddslashes($this->chosenPage) . '\',' . $arrvalue['x'] . ',' . $arrvalue['y'] . ')'; } //echo $ch_query; PMA_query_as_controluser($ch_query, FALSE, $query_default_option); } // end if } // end for } } ?>

| ver. 1.4 | Github | . | PHP 5.3.8 | Генерация страницы: 0.15 | proxy | phpinfo | Настройка