Welcome to mirror list, hosted at ThFree Co, Russian Federation.

github.com/phpmyadmin/phpmyadmin.git - Unnamed repository; edit this file 'description' to name the repository.
summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorSebastian Mendel <cybot_tm@users.sourceforge.net>2005-12-08 15:39:59 +0300
committerSebastian Mendel <cybot_tm@users.sourceforge.net>2005-12-08 15:39:59 +0300
commit388e2364fb2433c14bfd9a8e6c85c09a0dd82a08 (patch)
treed008dbdf4e1cd86ee73e62a20f9d0d2e6ca4e11f /tbl_rename.php
parentfe8553fa7b8423f428edeec5c01589e5f90f39d2 (diff)
removed, deprecated by function PMA_table_rename()
Diffstat (limited to 'tbl_rename.php')
-rw-r--r--tbl_rename.php109
1 files changed, 0 insertions, 109 deletions
diff --git a/tbl_rename.php b/tbl_rename.php
deleted file mode 100644
index 1e9d0006cf..0000000000
--- a/tbl_rename.php
+++ /dev/null
@@ -1,109 +0,0 @@
-<?php
-/* $Id$ */
-// vim: expandtab sw=4 ts=4 sts=4:
-
-
-/**
- * Gets some core libraries
- */
-require_once('./libraries/common.lib.php');
-
-$js_to_run = 'functions.js';
-PMA_checkParameters(array('db','table'));
-
-/**
- * Defines the url to return to in case of error in a sql statement
- */
-$err_url = 'tbl_properties.php?' . PMA_generate_common_url($db, $table);
-
-
-/**
- * A new name has been submitted -> do the work
- */
-if (isset($new_name) && trim($new_name) != '' && strpos($new_name,'.') === FALSE) {
- $old_name = $table;
- $table = $new_name;
-
- // Ensure the target is valid
- if (count($dblist) > 0 && PMA_isInto($db, $dblist) == -1) {
- exit();
- }
-
- require_once('./libraries/header.inc.php');
- PMA_DBI_select_db($db);
- $sql_query = 'ALTER TABLE ' . PMA_backquote($old_name) . ' RENAME ' . PMA_backquote($new_name) . ';';
- $result = PMA_DBI_query($sql_query);
- $message = sprintf($strRenameTableOK, htmlspecialchars($old_name), htmlspecialchars($table));
- $reload = 1;
-
- // garvin: Move old entries from comments to new table
- require_once('./libraries/relation.lib.php');
- $cfgRelation = PMA_getRelationsParam();
- if ($cfgRelation['commwork']) {
- $remove_query = 'UPDATE ' . PMA_backquote($cfgRelation['column_info'])
- . ' SET table_name = \'' . PMA_sqlAddslashes($table) . '\''
- . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
- . ' AND table_name = \'' . PMA_sqlAddslashes($old_name) . '\'';
- $rmv_rs = PMA_query_as_cu($remove_query);
- unset($rmv_query);
- }
-
- if ($cfgRelation['displaywork']) {
- $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['table_info'])
- . ' SET table_name = \'' . PMA_sqlAddslashes($table) . '\''
- . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
- . ' AND table_name = \'' . PMA_sqlAddslashes($old_name) . '\'';
- $tb_rs = PMA_query_as_cu($table_query);
- unset($table_query);
- unset($tb_rs);
- }
-
- if ($cfgRelation['relwork']) {
- $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['relation'])
- . ' SET foreign_table = \'' . PMA_sqlAddslashes($table) . '\''
- . ' WHERE foreign_db = \'' . PMA_sqlAddslashes($db) . '\''
- . ' AND foreign_table = \'' . PMA_sqlAddslashes($old_name) . '\'';
- $tb_rs = PMA_query_as_cu($table_query);
- unset($table_query);
- unset($tb_rs);
-
- $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['relation'])
- . ' SET master_table = \'' . PMA_sqlAddslashes($table) . '\''
- . ' WHERE master_db = \'' . PMA_sqlAddslashes($db) . '\''
- . ' AND master_table = \'' . PMA_sqlAddslashes($old_name) . '\'';
- $tb_rs = PMA_query_as_cu($table_query);
- unset($table_query);
- unset($tb_rs);
- }
-
- if ($cfgRelation['pdfwork']) {
- $table_query = 'UPDATE ' . PMA_backquote($cfgRelation['table_coords'])
- . ' SET table_name = \'' . PMA_sqlAddslashes($table) . '\''
- . ' WHERE db_name = \'' . PMA_sqlAddslashes($db) . '\''
- . ' AND table_name = \'' . PMA_sqlAddslashes($old_name) . '\'';
- $tb_rs = PMA_query_as_cu($table_query);
- unset($table_query);
- unset($tb_rs);
- }
-
-}
-
-
-/**
- * No new name for the table!
- */
-else {
- require_once('./libraries/header.inc.php');
- if (strpos($new_name,'.') === FALSE) {
- PMA_mysqlDie($strTableEmpty, '', '', $err_url);
- } else {
- PMA_mysqlDie($strError . ': ' . $new_name, '', '', $err_url);
- }
-}
-
-
-/**
- * Back to the calling script
- */
-require('./tbl_properties_operations.php');
-?>