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:
authorMarc Delisle <marc@infomarc.info>2007-07-18 19:54:09 +0400
committerMarc Delisle <marc@infomarc.info>2007-07-18 19:54:09 +0400
commite2599e32c51deb6c38dfb2d40bc8eb7b8603c226 (patch)
tree4b825dc642cb6eb9a060e54bf8d69288fbee4904 /scripts
parent6147b3565e8a6adb345e2fb9e44bc99f61294947 (diff)
start QA_2_11
Diffstat (limited to 'scripts')
-rw-r--r--scripts/check_lang.php61
-rwxr-xr-xscripts/convertcfg.pl19
-rwxr-xr-xscripts/create-release.sh288
-rw-r--r--scripts/create_tables.sql159
-rw-r--r--scripts/create_tables_mysql_4_1_2+.sql179
-rw-r--r--scripts/decode_bug.php105
-rwxr-xr-xscripts/find_unused_messages.sh31
-rwxr-xr-xscripts/lang-cleanup.sh76
-rwxr-xr-xscripts/remove_control_m.sh23
-rw-r--r--scripts/setup.php2042
-rw-r--r--scripts/signon.php56
-rwxr-xr-xscripts/upgrade.pl223
-rw-r--r--scripts/upgrade_tables_mysql_4_1_2+.sql164
13 files changed, 0 insertions, 3426 deletions
diff --git a/scripts/check_lang.php b/scripts/check_lang.php
deleted file mode 100644
index 4ecf9070b0..0000000000
--- a/scripts/check_lang.php
+++ /dev/null
@@ -1,61 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * This test script checks all the language files to ensure there is no errors
- * inside and nothing is displayed on screen (eg no extra no blank line).
- *
- * @version $Id$
- * @package phpMyAdmin-test
- */
-
-/**
- *
- */
-$failed = array();
-$passed = array();
-
-// 1. Do check
-$languageDirectory = dir('../lang');
-while ($name = $languageDirectory->read()) {
- if (strpos($name, '.inc.php')) {
- // 1.1 Checks parse errors and extra blank line
- include '../lang/' . $name;
- header('X-Ping: pong');
- // 1.1 Checks "^M"
- $content = fread(fopen('../lang/' . $name, 'r'), filesize('../lang/' . $name));
- if ($pos = strpos(' ' . $content, "\015")) {
- $failed[] = $name;
- } else {
- $passed[] = $name;
- }
- } // end if
-} // end while
-$languageDirectory->close();
-
-// 2. Checking results
-$start = '';
-$failed_cnt = count($failed);
-sort($failed);
-$passed_cnt = count($passed);
-sort($passed);
-echo ($failed_cnt + $passed_cnt) . ' language files were checked.<br /><br />' . "\n";
-if ($failed_cnt) {
- echo '&nbsp;&nbsp;1.&nbsp;' . $failed_cnt . ' contain(s) some "^M":<br />' . "\n";
- for ($i = 0; $i < $failed_cnt; $i++) {
- echo '&nbsp;&nbsp;&nbsp;&nbsp;-&nbsp;' . $failed[$i] . '<br />' . "\n";
- } // end for
- if ($passed_cnt) {
- echo '<br />' . "\n";
- echo '&nbsp;&nbsp;2.&nbsp;' . $passed_cnt . ' seems right:<br />' . "\n";
- $start = '&nbsp;&nbsp;';
- }
-} // end if
-if ($passed_cnt) {
- if (!$failed_cnt) {
- echo 'They all passed checkings:<br />' . "\n";
- }
- for ($i = 0; $i < $passed_cnt; $i++) {
- echo $start . '&nbsp;&nbsp;-&nbsp;' . $passed[$i] . '<br />' . "\n";
- } // end for
-} // end if
-?>
diff --git a/scripts/convertcfg.pl b/scripts/convertcfg.pl
deleted file mode 100755
index 1b636a161e..0000000000
--- a/scripts/convertcfg.pl
+++ /dev/null
@@ -1,19 +0,0 @@
-#!/usr/bin/perl
-#
-# $Id$
-#
-# Configuration converter
-# Converts from old-style (Pre-2.3) configuration files to new format found in PMA-2.3
-#
-# Takes input from STDIN, sends output to STDOUT
-#
-# By Robin Johnson robbat2@users.sourceforge.net
-# Many thanks to Patrick Lougheed pat@tfsb.org
-#
-
-while(<>)
-{ s/\$cfg(\w+)/\$cfg\[\'$1\'\]/g;
- print;
- }
-
-
diff --git a/scripts/create-release.sh b/scripts/create-release.sh
deleted file mode 100755
index e47f1873f7..0000000000
--- a/scripts/create-release.sh
+++ /dev/null
@@ -1,288 +0,0 @@
-#!/bin/sh
-#
-# $Id$
-# vim: expandtab sw=4 ts=4 sts=4:
-#
-# 2005-09-13, lem9@users.sourceforge.net
-# - no longer create a config.default.php from config.inc.php
-#
-# 2005-06-12, lem9@users.sourceforge.net
-# - cvs server name changed to cvs, because cvs1 no longer works from
-# shell.sourceforge.net
-#
-# 2003-08-23, nijel@users.sourceforge.net:
-# - support for creating snapshots outside sourceforge:
-# * cvs server name can be read from environment variable cvsserver
-# * do not change to directories as used on sourceforge if $2 is local
-#
-# 2003-08-13, nijel@users.sourceforge.net:
-# - config.default -> config.default.php
-#
-# 2004-08-09, lem9@users.sourceforge.net:
-# - remember to create a new bug tracking group
-#
-# 2004-06-07 rabus@users.sourceforge.net
-# - create backup config file
-#
-# 2004-04-29, lem9@users.sourceforge.net:
-# - keep only the previous cvs directory created
-#
-# 2004-04-16, lem9@users.sourceforge.net:
-# - daily snapshot when called with first parameter "snapshot"
-# - remove directory used for the checkout
-#
-# 2003-11-18, nijel@users.sourceforge.net:
-# - switch php3 -> php
-#
-# 2003-10-10, nijel@users.sourceforge.net:
-# - cvsserver set on just one place to ease testing
-# - echoes md5 sums to include on download page
-#
-# 2003-06-22, robbat2@users.sourceforge.net:
-# - Moved to using updatedocs.sh for updating documentation
-# - Make tarring faster by re-arranging ops
-#
-# 2003-01-17, rabus@users.sourceforge.net:
-# - Changed the CVS hostname to cvs1 because cvs1.sourceforge.net is now blocked
-# for the SF shell servers, too. Note: The script now works on the SF shell
-# servers ONLY!
-#
-# 2002-11-22, rabus@users.sourceforge.net:
-# - changed the CVS server dns to cvs1.sourceforge.net
-# (cvs.phpmyadmin.sourceforge.net does not work at the SF shell anymore).
-#
-# 2002-10-03, rabus@users.sourceforge.net:
-# - more detailed instructions
-#
-# 2002-09-08, robbat2@users.sourceforge.net:
-# - Tweaked final instruction list
-#
-# 2002-06-17, lem9@users.sourceforge.net:
-# - I option to tar for bzip2 is deprecated, use j
-#
-# 2002-27-04, loic@phpmyadmin.net:
-# - added the cvs branch feature
-#
-# 2001-08-08, swix@users.sourceforge.net:
-# - created script
-# - added release todo list
-#
-
-KITS="all-languages-utf-8-only all-languages english"
-COMPRESSIONS="zip-7z tbz tgz 7z"
-
-if [ $# = 0 ]
-then
- echo "Usages:"
- echo " create-release.sh <version> [from_branch]"
- echo " create-release.sh snapshot [sf]"
- echo " (no spaces allowed!)"
- echo ""
- echo "Examples:"
- echo " create-release.sh 2.9.0-rc1 branches/QA_2_9"
- echo " create-release.sh 2.9.0 tags/RELEASE_2_9_0"
- exit 65
-fi
-
-branch='trunk'
-
-if [ "$1" = "snapshot" ] ; then
- mode="snapshot"
- date_snapshot=`date +%Y%m%d-%H%M%S`
- target=$date_snapshot
-else
- if [ "$#" -ge 2 ] ; then
- branch="$2"
- fi
- target="$1"
- cat <<END
-
-Please ensure you have:
- 1. incremented rc count or version in subversion :
- - in libraries/Config.class.php PMA_Config::__constructor() the line
- " \$this->set( 'PMA_VERSION', '$1' ); "
- - in Documentation.html the 2 lines
- " <title>phpMyAdmin $1 - Documentation</title> "
- " <h1>phpMyAdmin $1 Documentation</h1> "
- - in translators.html
- - in README
- 2. synchronized the language files:
- cd lang
- ./sync_lang.sh
- and checked all language files are valid (use
- the "./scripts/check_lang.php" script to do it).
-
-Continue (y/n)?
-END
- read do_release
-
- if [ "$do_release" != 'y' ]; then
- exit
- fi
-fi
-
-if [ "$mode" = "snapshot" -a "$2" = "sf" ] ; then
- # Goto project dir
- cd /home/groups/p/ph/phpmyadmin/htdocs
-
- # Keep one previous version of the cvs directory
- if [ -e svn-prev ] ; then
- rm -rf svn-prev
- fi
- mv svn svn-prev
-fi
-
-# Do SVNcheckout
-mkdir -p ./svn
-cd svn
-
-echo "Exporting repository from subversion"
-
-svn export -q https://phpmyadmin.svn.sourceforge.net/svnroot/phpmyadmin/$branch/phpMyAdmin
-
-if [ $? -ne 0 ] ; then
- echo "Subversion checkout failed, bailing out"
- exit 2
-fi
-
-# Cleanup release dir
-LC_ALL=C date -u > phpMyAdmin/RELEASE-DATE-${target}
-
-# Building Documentation.txt
-LC_ALL=C w3m -dump phpMyAdmin/Documentation.html > phpMyAdmin/Documentation.txt
-
-# Renaming directory
-mv phpMyAdmin phpMyAdmin-$target
-
-# Prepare all kits
-for kit in $KITS ; do
- # Copy all files
- name=phpMyAdmin-$target-$kit
- cp -r phpMyAdmin-$target $name
-
- # Cleanup translations
- cd phpMyAdmin-$target-$kit
- scripts/lang-cleanup.sh $kit
- cd ..
-
- # Prepare distributions
- for comp in $COMPRESSIONS ; do
- case $comp in
- tbz|tgz)
- echo "Creating $name.tar"
- tar cf $name.tar $name
- if [ $comp = tbz ] ; then
- echo "Creating $name.tar.bz2"
- bzip2 -9k $name.tar
- fi
- if [ $comp = tgz ] ; then
- echo "Creating $name.tar.gz"
- gzip -9c $name.tar > $name.tar.gz
- fi
- rm $name.tar
- ;;
- zip)
- echo "Creating $name.zip"
- zip -q -9 -r $name.zip $name
- ;;
- zip-7z)
- echo "Creating $name.zip"
- 7za a -bd -tzip $name.zip $name > /dev/null
- ;;
- 7z)
- echo "Creating $name.7z"
- 7za a -bd $name.7z $name > /dev/null
- ;;
- *)
- echo "WARNING: ignoring compression '$comp', not known!"
- ;;
- esac
- done
-
- # Remove directory with current dist set
- rm -rf $name
-done
-
-# Cleanup
-rm -rf phpMyAdmin-${target}
-
-if [ "$mode" != "snapshot" ]
-then
-
-
-echo ""
-echo ""
-echo ""
-echo "Files:"
-echo "------"
-
-ls -la *.gz *.zip *.bz2 *.7z
-
-echo
-echo "MD5 sums:"
-echo "--------"
-
-md5sum *.{gz,zip,bz2,7z} | sed "s/\([^ ]*\)[ ]*\([^ ]*\)/\$md5sum['\2'] = '\1';/"
-
-echo
-echo "Sizes:"
-echo "------"
-
-ls -l --block-size=k *.{gz,zip,bz2,7z} | sed -r "s/[a-z-]+[[:space:]]+[0-9]+[[:space:]]+[^[:space:]]+[[:space:]]+[^[:space:]]+[[:space:]]+([0-9]*)K.*[[:space:]]([^[:space:]]+)\$/\$size['\2'] = \1;/"
-
-echo
-echo "Add these to /home/groups/p/ph/phpmyadmin/htdocs/home_page/files.inc.php on sf"
-
-cat <<END
-
-
-Todo now:
----------
- 1. tag the subversion tree with the new revision number for a plain release
- or a release candidate:
- version 2.7.0 gets two tags: RELEASE_2_7_0 and STABLE
- version 2.7.1-rc1 gets RELEASE_2_7_1RC1 and TESTING
-
- 2. upload the files to SF:
- ftp upload.sourceforge.net
- cd incoming
- binary
- mput svn/*.gz *.zip *.bz2
- 3. add files to SF files page (cut and paste changelog since last release)
- 4. add SF news item to phpMyAdmin project
- 5. update web page:
- - add MD5s and file sizes to /home/groups/p/ph/phpmyadmin/htdocs/home_page/includes/list_files.inc.php
- - add release to /home/groups/p/ph/phpmyadmin/htdocs/home_page/includes/list_release.inc.php
- 6. announce release on freshmeat (http://freshmeat.net/projects/phpmyadmin/)
- 7. send a short mail (with list of major changes) to
- phpmyadmin-devel@lists.sourceforge.net
- phpmyadmin-news@lists.sourceforge.net
- phpmyadmin-users@lists.sourceforge.net
-
- Don't forget to update the Description section in the announcement,
- based on Documentation.html.
-
- 8. increment rc count or version in subversion :
- - in libraries/Config.class.php PMA_Config::__constructor() the line
- " $this->set( 'PMA_VERSION', '2.7.1-dev' ); "
- - in Documentation.html the 2 lines
- " <title>phpMyAdmin 2.2.2-rc1 - Documentation</title> "
- " <h1>phpMyAdmin 2.2.2-rc1 Documentation</h1> "
- - in translators.html
-
- 9. add a group for bug tracking this new version, at
- https://sourceforge.net/tracker/admin/index.php?group_id=23067&atid=377408&add_group=1
-
-10. Visit http://phpmyadmin.net/home_page/version.php then copy the results to /home/groups/p/ph/phpmyadmin/htdocs/latest.txt. This is needed for users of the pre-2.8.0 scripts/upgrade.pl.
-
-11. the end :-)
-
-END
-
-fi
-
-# Removed due to not needed thanks to clever scripting by Robbat2
-# 9. update the demo subdirectory:
-# - in htdocs, cvs update phpMyAdmin
-# - and don't forget to give write rights for the updated scripts to the
-# whole group
diff --git a/scripts/create_tables.sql b/scripts/create_tables.sql
deleted file mode 100644
index 7fca18cf18..0000000000
--- a/scripts/create_tables.sql
+++ /dev/null
@@ -1,159 +0,0 @@
--- --------------------------------------------------------
--- SQL Commands to set up the pmadb as described in Documentation.html.
---
--- DON'T RUN THIS SCRIPT ON MySQL 4.1.2 AND ABOVE!
--- Instead, please run create_tables_mysql_4_1_2+.sql.
---
--- This script expects the user pma to already be existing. If we would put a
--- line here to create him too many users might just use this script and end
--- up with having the same password for the controluser.
---
--- This user "pma" must be defined in config.inc.php (controluser/controlpass)
---
--- Please don't forget to set up the tablenames in config.inc.php
---
--- $Id$
-
--- --------------------------------------------------------
-
---
--- Database : `phpmyadmin`
---
-DROP DATABASE IF EXISTS `phpmyadmin`;
-CREATE DATABASE `phpmyadmin`;
-USE phpmyadmin;
-
--- --------------------------------------------------------
-
---
--- Privileges
---
-GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
- 'pma'@localhost;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_bookmark`
---
-
-CREATE TABLE `pma_bookmark` (
- `id` int(11) NOT NULL auto_increment,
- `dbase` varchar(255) NOT NULL default '',
- `user` varchar(255) NOT NULL default '',
- `label` varchar(255) NOT NULL default '',
- `query` text NOT NULL,
- PRIMARY KEY (`id`)
-) TYPE=MyISAM COMMENT='Bookmarks';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_column_info`
---
-
-CREATE TABLE `pma_column_info` (
- `id` int(5) unsigned NOT NULL auto_increment,
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `column_name` varchar(64) NOT NULL default '',
- `comment` varchar(255) NOT NULL default '',
- `mimetype` varchar(255) NOT NULL default '',
- `transformation` varchar(255) NOT NULL default '',
- `transformation_options` varchar(255) NOT NULL default '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
-) TYPE=MyISAM COMMENT='Column information for phpMyAdmin';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_history`
---
-
-CREATE TABLE `pma_history` (
- `id` bigint(20) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `db` varchar(64) NOT NULL default '',
- `table` varchar(64) NOT NULL default '',
- `timevalue` timestamp(14) NOT NULL,
- `sqlquery` text NOT NULL,
- PRIMARY KEY (`id`),
- KEY `username` (`username`,`db`,`table`,`timevalue`)
-) TYPE=MyISAM COMMENT='SQL history for phpMyAdmin';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_pdf_pages`
---
-
-CREATE TABLE `pma_pdf_pages` (
- `db_name` varchar(64) NOT NULL default '',
- `page_nr` int(10) unsigned NOT NULL auto_increment,
- `page_descr` varchar(50) NOT NULL default '',
- PRIMARY KEY (`page_nr`),
- KEY `db_name` (`db_name`)
-) TYPE=MyISAM COMMENT='PDF relation pages for phpMyAdmin';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_relation`
---
-
-CREATE TABLE `pma_relation` (
- `master_db` varchar(64) NOT NULL default '',
- `master_table` varchar(64) NOT NULL default '',
- `master_field` varchar(64) NOT NULL default '',
- `foreign_db` varchar(64) NOT NULL default '',
- `foreign_table` varchar(64) NOT NULL default '',
- `foreign_field` varchar(64) NOT NULL default '',
- PRIMARY KEY (`master_db`,`master_table`,`master_field`),
- KEY `foreign_field` (`foreign_db`,`foreign_table`)
-) TYPE=MyISAM COMMENT='Relation table';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_table_coords`
---
-
-CREATE TABLE `pma_table_coords` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `pdf_page_number` int(11) NOT NULL default '0',
- `x` float unsigned NOT NULL default '0',
- `y` float unsigned NOT NULL default '0',
- PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
-) TYPE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_table_info`
---
-
-CREATE TABLE `pma_table_info` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `display_field` varchar(64) NOT NULL default '',
- PRIMARY KEY (`db_name`,`table_name`)
-) TYPE=MyISAM COMMENT='Table information for phpMyAdmin';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_designer_coords`
---
-
-CREATE TABLE `pma_designer_coords` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `x` INT(11) default NULL,
- `y` INT(11) default NULL,
- `v` TINYINT(4) default NULL,
- `h` TINYINT(4) default NULL,
- PRIMARY KEY (`db_name`,`table_name`)
-) TYPE=MyISAM COMMENT='Table coordinates for Designer'
-
diff --git a/scripts/create_tables_mysql_4_1_2+.sql b/scripts/create_tables_mysql_4_1_2+.sql
deleted file mode 100644
index c2032efc26..0000000000
--- a/scripts/create_tables_mysql_4_1_2+.sql
+++ /dev/null
@@ -1,179 +0,0 @@
--- --------------------------------------------------------
--- SQL Commands to set up the pmadb as described in Documentation.html.
---
--- This file is meant for use with MySQL 4.1.2 and above!
--- For older MySQL releases, please use create_tables.sql
---
--- If you are running one MySQL 4.1.0 or 4.1.1, please create the tables using
--- create_tables.sql and upgrade their collation settings according to our
--- manual.
---
--- This script expects the user pma to already be existing. If we would put a
--- line here to create him too many users might just use this script and end
--- up with having the same password for the controluser.
---
--- This user "pma" must be defined in config.inc.php (controluser/controlpass)
---
--- Please don't forget to set up the tablenames in config.inc.php
---
--- $Id$
-
--- --------------------------------------------------------
-
---
--- Database : `phpmyadmin`
---
-CREATE DATABASE IF NOT EXISTS `phpmyadmin`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-USE phpmyadmin;
-
--- --------------------------------------------------------
-
---
--- Privileges
---
--- (activate this statement if necessary)
--- GRANT SELECT, INSERT, DELETE, UPDATE ON `phpmyadmin`.* TO
--- 'pma'@localhost;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_bookmark`
---
-
-CREATE TABLE IF NOT EXISTS `pma_bookmark` (
- `id` int(11) NOT NULL auto_increment,
- `dbase` varchar(255) NOT NULL default '',
- `user` varchar(255) NOT NULL default '',
- `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
- `query` text NOT NULL,
- PRIMARY KEY (`id`)
-)
- ENGINE=MyISAM COMMENT='Bookmarks'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_column_info`
---
-
-CREATE TABLE IF NOT EXISTS `pma_column_info` (
- `id` int(5) unsigned NOT NULL auto_increment,
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `column_name` varchar(64) NOT NULL default '',
- `comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
- `mimetype` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
- `transformation` varchar(255) NOT NULL default '',
- `transformation_options` varchar(255) NOT NULL default '',
- PRIMARY KEY (`id`),
- UNIQUE KEY `db_name` (`db_name`,`table_name`,`column_name`)
-)
- ENGINE=MyISAM COMMENT='Column information for phpMyAdmin'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_history`
---
-
-CREATE TABLE IF NOT EXISTS `pma_history` (
- `id` bigint(20) unsigned NOT NULL auto_increment,
- `username` varchar(64) NOT NULL default '',
- `db` varchar(64) NOT NULL default '',
- `table` varchar(64) NOT NULL default '',
- `timevalue` timestamp(14) NOT NULL,
- `sqlquery` text NOT NULL,
- PRIMARY KEY (`id`),
- KEY `username` (`username`,`db`,`table`,`timevalue`)
-)
- ENGINE=MyISAM COMMENT='SQL history for phpMyAdmin'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_pdf_pages`
---
-
-CREATE TABLE IF NOT EXISTS `pma_pdf_pages` (
- `db_name` varchar(64) NOT NULL default '',
- `page_nr` int(10) unsigned NOT NULL auto_increment,
- `page_descr` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
- PRIMARY KEY (`page_nr`),
- KEY `db_name` (`db_name`)
-)
- ENGINE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_relation`
---
-
-CREATE TABLE IF NOT EXISTS `pma_relation` (
- `master_db` varchar(64) NOT NULL default '',
- `master_table` varchar(64) NOT NULL default '',
- `master_field` varchar(64) NOT NULL default '',
- `foreign_db` varchar(64) NOT NULL default '',
- `foreign_table` varchar(64) NOT NULL default '',
- `foreign_field` varchar(64) NOT NULL default '',
- PRIMARY KEY (`master_db`,`master_table`,`master_field`),
- KEY `foreign_field` (`foreign_db`,`foreign_table`)
-)
- ENGINE=MyISAM COMMENT='Relation table'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_table_coords`
---
-
-CREATE TABLE IF NOT EXISTS `pma_table_coords` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `pdf_page_number` int(11) NOT NULL default '0',
- `x` float unsigned NOT NULL default '0',
- `y` float unsigned NOT NULL default '0',
- PRIMARY KEY (`db_name`,`table_name`,`pdf_page_number`)
-)
- ENGINE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_table_info`
---
-
-CREATE TABLE IF NOT EXISTS `pma_table_info` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `display_field` varchar(64) NOT NULL default '',
- PRIMARY KEY (`db_name`,`table_name`)
-)
- ENGINE=MyISAM COMMENT='Table information for phpMyAdmin'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_designer_coords`
---
-
-CREATE TABLE IF NOT EXISTS `pma_designer_coords` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `x` INT,
- `y` INT,
- `v` TINYINT,
- `h` TINYINT,
- PRIMARY KEY (`db_name`,`table_name`)
-)
- ENGINE=MyISAM COMMENT='Table coordinates for Designer'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
diff --git a/scripts/decode_bug.php b/scripts/decode_bug.php
deleted file mode 100644
index 7dea1e249b..0000000000
--- a/scripts/decode_bug.php
+++ /dev/null
@@ -1,105 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * Parser BUG decoder
- *
- * This is the parser bug decoder system
- * Throw the bug data in teh query box, and hit submit for output.
- *
- * Copyright 2002 Robin Johnson <robbat2@users.sourceforge.net>
- *
- * @version $Id$
- * @package phpMyAdmin-debug
- */
-
-/**
- * Displays the form
- */
-?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-US" lang="en-US">
-
-<head>
- <link rel="icon" href="./favicon.ico" type="image/x-icon" />
- <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" />
- <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
- <title>phpMyAdmin - Parser BUG decoder</title>
- <style type="text/css">
- <!--
- body, p {
- font-family: Arial, Helvetica, sans-serif;
- font-size: medium;
- }
- h1 {
- font-family: Verdana, Arial, Helvetica, sans-serif;
- font-size: large;
- font-weight: bold;
- color: #000066;
- }
- //-->
- </style>
-</head>
-
-
-<body bgcolor="#FFFFFF">
-<h1>Parser BUG decoder</h1>
-<br />
-
-<form method="post" action="./decode_bug.php">
- <input type="hidden" name="bar" value="<?php echo rand(); ?>" />
- Encoded bug report:<br />
- <textarea name="bug_encoded" cols="72" rows="10"></textarea>
- <br /><br />
- <input type="submit" />
-</form>
-<hr />
-
-<?php
-/**
- * If the form has been submitted -> decodes the bug report
- */
-
-/**
- * Display the decoded bug report in ASCII format
- *
- * @param string the text data
- *
- * @return string the text enclosed by "<pre>...</pre>" tags
- *
- * @access public
- */
-function PMA_printDecodedBug($textdata)
-{
- return '<pre>' . htmlspecialchars($textdata) . '</pre><br />';
-} // end of the "PMA_printDecodedBug()" function
-
-
-if (!empty($_POST) && isset($_POST['bug_encoded'])) {
- $bug_encoded = $_POST['bug_encoded'];
-}
-
-if (!empty($bug_encoded)) {
- if (function_exists('get_magic_quotes_gpc') && get_magic_quotes_gpc()) {
- $bug_encoded = stripslashes($bug_encoded);
- }
-
- $bug_encoded = ereg_replace('[[:space:]]', '', $bug_encoded);
- $bug_decoded = base64_decode($bug_encoded);
- if (substr($bug_encoded, 0, 2) == 'eN') {
- if (function_exists('gzuncompress')) {
- $result = PMA_printDecodedBug(gzuncompress($bug_decoded));
- } else {
- $result = 'Error: &quot;gzuncompress()&quot; is unavailable!' . "\n";
- }
- } else {
- $result = PMA_printDecodedBug($bug_decoded);
- } // end if... else...
-
- echo '<p>Decoded:</p>' . "\n"
- . $result . "\n";
-} // end if
-?>
-</body>
-
-</html>
diff --git a/scripts/find_unused_messages.sh b/scripts/find_unused_messages.sh
deleted file mode 100755
index b0fd26eb18..0000000000
--- a/scripts/find_unused_messages.sh
+++ /dev/null
@@ -1,31 +0,0 @@
-#!/bin/sh
-
-# Simple script to find unused message strings by Michal Čihař
-
-tmp1=`mktemp`
-tmp2=`mktemp`
-grep -o '\<str[A-Z][a-zA-Z0-9_]*\>' lang/english-iso-8859-1.inc.php \
- | grep -Ev '^str(Transformation_|ShowStatus)' | sort -u > $tmp1
-grep -ho '\<str[A-Z][a-zA-Z0-9_]*\>' `find . -type f -a -name '*.php' -a -not -path '*/lang/*'` \
- | grep -Ev '^str(Transformation_|ShowStatus)' | sort -u > $tmp2
-
-echo Please note that you need to check results of this script, it doesn\'t
-echo understand PHP, it only tries to find what looks like message name.
-
-echo
-echo Used messages not present in english language file:
-echo '(this contains generated messages and composed message names, so these'
-echo 'are not necessary a errors!)'
-echo
-
-# filter out known false positives
-diff $tmp1 $tmp2 | awk '/^>/ {print $2}' | grep -Ev '(strEncto|strXkana|strDBLink|strPrivDesc|strPrivDescProcess|strTableListOptions|strMissingParameter|strAttribute|strDoSelectAll)'
-
-echo
-echo Not used messages present in english language file:
-echo
-
-diff $tmp1 $tmp2 | awk '/^</ {print $2}'
-
-
-rm -f $tmp1 $tmp2
diff --git a/scripts/lang-cleanup.sh b/scripts/lang-cleanup.sh
deleted file mode 100755
index d8688e9cd5..0000000000
--- a/scripts/lang-cleanup.sh
+++ /dev/null
@@ -1,76 +0,0 @@
-#!/bin/sh
-#
-# $Id$
-# vim: expandtab sw=4 ts=4 sts=4:
-#
-# Script for removing language selection from phpMyAdmin
-
-if [ $# -lt 1 ] ; then
- echo "Usage: lang-cleanup.sh type ..."
- echo "Type can be one of:"
- echo " all-languages - nothing will be done"
- echo " all-languages-utf-8-only - non utf-8 languages will be deleted"
- echo " language - keeps utf-8 version of language"
- echo " language-charset - keeps this exact language"
- echo
- echo "Types can be entered multiple times, all matched languages will be kept"
- exit 1
-fi
-
-# Construct expressions for find
-match=""
-for type in "$@" ; do
- case $type in
- all-languages)
- match="$match -and -false"
- ;;
- all-languages-utf-8-only)
- match="$match -and -not -name *-utf-8.inc.php"
- ;;
- *)
- if [ -f lang/$type-utf-8.inc.php ] ; then
- match="$match -and -not -name $type-utf-8.inc.php"
- elif [ -f lang/$type.inc.php ] ; then
- match="$match -and -not -name $type.inc.php"
- else
- echo "ERROR: $type seems to be wrong!"
- exit 2
- fi
- ;;
- esac
-done
-
-# Delete unvanted languages
-find lang -name \*.inc.php $match -print0 | xargs -0r rm
-
-# Cleanup libraries/select_lang.lib.php
-
-# Find languages we have
-langmatch="$(awk -F, \
- 'BEGIN { pr = 1 } ;
- /^\);/ { pr = 1 } ;
- {if(!pr) print $2;};
- /^\$available_languages/ { pr = 0 };' \
- libraries/select_lang.lib.php \
- | tr -d \' \
- | while read lng ; do if [ -f lang/$lng.inc.php ] ; then echo $lng ; fi ; done \
- | tr '\n' '|' \
- | sed 's/|$//' \
- )"
-
-# Prepare working copy
-tmp=`mktemp libraries/select_lang.lib.php.XXXX`
-cat libraries/select_lang.lib.php > $tmp
-
-# Remove languages we don't have
-awk -F, \
- 'BEGIN { pr = 1 } ;
- /^\);/ { pr = 1 } ;
- {if(pr) print $0;};
- /'$langmatch'/ {if (!pr) print $0;};
- /^\$available_languages/ { pr = 0 };' \
- $tmp > libraries/select_lang.lib.php
-
-# Final cleanup
-rm -f $tmp
-
diff --git a/scripts/remove_control_m.sh b/scripts/remove_control_m.sh
deleted file mode 100755
index 432c149c7a..0000000000
--- a/scripts/remove_control_m.sh
+++ /dev/null
@@ -1,23 +0,0 @@
-#!/bin/sh
-#
-# $Id$
-#
-# Script to remove ^M from files for DOS <-> UNIX conversions
-#
-
-if [ $# != 1 ]
-then
- echo "Usage: remove_control_m.sh <extension of files>"
- echo ""
- echo "Example: remove_control_m.sh php3"
- exit
-fi
-
-for i in `find . -name "*.$1"`
- do
- echo $i
- tr -d '\015' < $i > ${i}.new
- rm $i
- mv ${i}.new $i
- done;
-
diff --git a/scripts/setup.php b/scripts/setup.php
deleted file mode 100644
index 4fe4971544..0000000000
--- a/scripts/setup.php
+++ /dev/null
@@ -1,2042 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * phpMyAdmin setup script
- *
- * PHP versions 4 and 5
- *
- * @category Setup
- * @package phpMyAdmin-setup
- * @author Michal Čihař <michal@cihar.com>
- * @copyright 2006 Michal Čihař <michal@cihar.com>
- * @license http://www.gnu.org/licenses/gpl.html GNU GPL 2.0
- * @version $Id$
- */
-
-// Grab phpMyAdmin version and PMA_dl function
-define('PMA_MINIMUM_COMMON', TRUE);
-define('PMA_SETUP', TRUE);
-chdir('..');
-require_once './libraries/common.inc.php';
-
-// Grab configuration defaults
-// Do not use $PMA_Config, it interferes with the one in $_SESSION
-// on servers with register_globals enabled
-$PMA_Config_Setup = new PMA_Config();
-
-// Script information
-$script_info = 'phpMyAdmin ' . $PMA_Config_Setup->get('PMA_VERSION') . ' setup script by Michal Čihař <michal@cihar.com>';
-$script_version = '$Id$';
-
-// Grab action
-if (isset($_POST['action'])) {
- $action = $_POST['action'];
-} else {
- $action = '';
-}
-
-// Grab wanted CRLF type
-if (isset($_POST['eoltype'])) {
- $eoltype = $_POST['eoltype'];
-} else {
- if (PMA_USR_OS == 'Win') {
- $eoltype = 'dos';
- } else {
- $eoltype = 'unix';
- }
-}
-
-// Detect which CRLF to use
-if ($eoltype == 'dos') {
- $crlf = "\r\n";
-} elseif ($eoltype == 'mac') {
- $crlf = "\r";
-} else {
- $crlf = "\n";
-}
-
-if (isset($_POST['configuration']) && $action != 'clear') {
- // Grab previous configuration, if it should not be cleared
- $configuration = unserialize($_POST['configuration']);
-} else {
- // Start with empty configuration
- $configuration = array();
-}
-
-// We rely on Servers array to exist, so create it here
-if (!isset($configuration['Servers']) || !is_array($configuration['Servers'])) {
- $configuration['Servers'] = array();
-}
-
-// Used later
-$now = gmdate('D, d M Y H:i:s') . ' GMT';
-
-// General header for no caching
-header('Expires: ' . $now); // rfc2616 - Section 14.21
-header('Last-Modified: ' . $now);
-header('Cache-Control: no-store, no-cache, must-revalidate, pre-check=0, post-check=0, max-age=0'); // HTTP/1.1
-header('Pragma: no-cache'); // HTTP/1.0
-
-// whether to show html header?
-if ($action != 'download') {
-
-// Define the charset to be used
-header('Content-Type: text/html; charset=utf-8');
-
-// this needs to be echoed otherwise php with short tags complains
-echo '<?xml version="1.0" encoding="utf-8"?>' . "\n";
-?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
-<head>
- <link rel="icon" href="../favicon.ico" type="image/x-icon" />
- <link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
- <title>phpMyAdmin <?php echo $PMA_Config_Setup->get('PMA_VERSION'); ?> setup</title>
- <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
-
- <script type="text/javascript">
- //<![CDATA[
- // show this window in top frame
- if (top != self) {
- window.top.location.href=location;
- }
- //]]>
- </script>
- <style type="text/css">
- /* message boxes: warning, error, stolen from original theme */
- div.notice {
- color: #000000;
- background-color: #FFFFDD;
- }
- h1.notice,
- div.notice {
- margin: 0.5em 0 0.5em 0;
- border: 0.1em solid #FFD700;
- background-image: url(../<?php echo $GLOBALS['cfg']['ThemePath']; ?>/original/img/s_notice.png);
- background-repeat: no-repeat;
- background-position: 10px 50%;
- padding: 10px 10px 10px 36px;
- }
- div.notice h1 {
- border-bottom: 0.1em solid #FFD700;
- font-weight: bold;
- font-size: large;
- text-align: left;
- margin: 0 0 0.2em 0;
- }
-
- div.warning {
- color: #CC0000;
- background-color: #FFFFCC;
- }
- h1.warning,
- div.warning {
- margin: 0.5em 0 0.5em 0;
- border: 0.1em solid #CC0000;
- background-image: url(../<?php echo $GLOBALS['cfg']['ThemePath']; ?>/original/img/s_warn.png);
- background-repeat: no-repeat;
- background-position: 10px 50%;
- padding: 10px 10px 10px 36px;
- }
- div.warning h1 {
- border-bottom: 0.1em solid #cc0000;
- font-weight: bold;
- text-align: left;
- font-size: large;
- margin: 0 0 0.2em 0;
- }
-
- div.error {
- background-color: #FFFFCC;
- color: #ff0000;
- }
- h1.error,
- div.error {
- margin: 0.5em 0 0.5em 0;
- border: 0.1em solid #ff0000;
- background-image: url(../<?php echo $GLOBALS['cfg']['ThemePath']; ?>/original/img/s_error.png);
- background-repeat: no-repeat;
- background-position: 10px 50%;
- padding: 10px 10px 10px 36px;
- }
- div.error h1 {
- border-bottom: 0.1em solid #ff0000;
- font-weight: bold;
- text-align: left;
- font-size: large;
- margin: 0 0 0.2em 0;
- }
-
- fieldset.toolbar form.action {
- display: block;
- width: auto;
- clear: none;
- float: left;
- margin: 0;
- padding: 0;
- border-right: 1px solid black;
- }
- fieldset.toolbar form.action input, fieldset.toolbar form.action select {
- margin: 0.7em;
- padding: 0.1em;
- }
-
- fieldset.toolbar {
- display: block;
- width: 100%;
- background-color: #dddddd;
- padding: 0;
- }
- fieldset.optbox {
- padding: 0;
- background-color: #FFFFDD;
- }
- div.buttons, div.opts, fieldset.optbox p, fieldset.overview div.row {
- clear: both;
- padding: 0.5em;
- margin: 0;
- background-color: white;
- }
- div.opts, fieldset.optbox p, fieldset.overview div.row {
- border-bottom: 1px dotted black;
- }
- fieldset.overview {
- display: block;
- width: 100%;
- padding: 0;
- }
- fieldset.optbox p {
- background-color: #FFFFDD;
- }
- div.buttons {
- background-color: #dddddd;
- }
- div.buttons input {
- margin: 0 1em 0 1em;
- }
- div.buttons form {
- display: inline;
- margin: 0;
- padding: 0;
- }
- input.save {
- color: green;
- font-weight: bolder;
- }
- input.cancel {
- color: red;
- font-weight: bolder;
- }
- div.desc, label.desc, fieldset.overview div.desc {
- float: left;
- width: 27em;
- max-width: 60%;
- }
- code:before, code:after {
- content: '"';
- }
- span.doc {
- margin: 0 1em 0 1em;
- }
- span.doc a {
- margin: 0 0.1em 0 0.1em;
- }
- span.doc a img {
- border: none;
- }
- </style>
-</head>
-
-<body>
-<h1>phpMyAdmin <?php echo $PMA_Config_Setup->get('PMA_VERSION'); ?> setup</h1>
-<?php
-} // end show html header
-
-/**
- * Calculates numerical equivalent of phpMyAdmin version string
- *
- * @param string version
- *
- * @return mixed FALSE on failure, integer on success
- */
-function version_to_int($version) {
- if (!preg_match('/^(\d+)\.(\d+)\.(\d+)((\.|-(pl|rc|dev|beta|alpha))(\d+)?)?$/', $version, $matches)) {
- return FALSE;
- }
- if (!empty($matches[6])) {
- switch ($matches[6]) {
- case 'pl':
- $added = 60;
- break;
- case 'rc':
- $added = 30;
- break;
- case 'beta':
- $added = 20;
- break;
- case 'alpha':
- $added = 10;
- break;
- case 'dev':
- $added = 0;
- break;
- default:
- message('notice', 'Unknown version part: ' . htmlspecialchars($matches[5]));
- $added = 0;
- break;
- }
- } else {
- $added = 50; // for final
- }
- if (!empty($matches[7])) {
- $added = $added + $matches[7];
- }
- return $matches[1] * 1000000 + $matches[2] * 10000 + $matches[3] * 100 + $added;
-}
-
-/**
- * Returns link to documentation of some configuration directive
- *
- * @param string confguration directive name
- *
- * @return string HTML link to documentation
- */
-function get_cfg_doc($anchor) {
- /* Link for wiki */
- $wiki = $anchor;
- if (strncmp($anchor, 'Servers_', 8) == 0) {
- $wiki = substr($anchor, 8);
- }
- return
- '<span class="doc">' .
- '<a href="../Documentation.html#cfg_' . $anchor . '" target="pma_doc" class="doc">' .
- '<img class="icon" src="../' . $GLOBALS['cfg']['ThemePath'] . '/original/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" />' .
- '</a>' .
- '<a href="http://wiki.cihar.com/pma/Config#' . $wiki . '" target="pma_doc" class="doc">' .
- '<img class="icon" src="../' . $GLOBALS['cfg']['ThemePath'] . '/original/img/b_info.png" width="11" height="11" alt="Wiki" title="Wiki" />' .
- '</a>' .
- '</span>'
- ;
-}
-
-/**
- * Displays message
- *
- * @param string type of message (notice/warning/error)
- * @param string text of message
- * @param title optional title of message
- *
- * @return nothing
- */
-function message($type, $text, $title = '') {
- echo '<div class="' . $type . '">' . "\n";
- if (!empty($title)) {
- echo '<h1>';
- echo $title;
- echo '</h1>' . "\n";
- }
- echo $text . "\n";
- echo '</div>' . "\n";
-}
-
-/**
- * Creates hidden input required for keeping current configuraion
- *
- * @return string HTML with hidden inputs
- */
-function get_hidden_cfg() {
- global $configuration, $eoltype;
-
- $ret = '<input type="hidden" name="configuration" value="' . htmlspecialchars(serialize($configuration)) . '" />' . "\n";
- $ret .= '<input type="hidden" name="eoltype" value="' . htmlspecialchars($eoltype) . '" />' . "\n";
-
- return $ret;
-}
-
-/**
- * Returns needed hidden input for forms.
- *
- * @return string HTML with hidden inputs
- */
-function get_hidden_inputs() {
- return '<input type="hidden" name="token" value="' . $_SESSION[' PMA_token '] . '" />';
-}
-
-/**
- * Creates form for some action
- *
- * @param string action name
- * @param string form title
- * @param string optional additional inputs
- *
- * @return string HTML with form
- */
-function get_action($name, $title, $added = '', $enabled = TRUE) {
- $ret = '';
- $ret .= '<form class="action" method="post" action="">';
- $ret .= get_hidden_inputs();
- $ret .= '<input type="hidden" name="action" value="' . $name . '" />';
- $ret .= $added;
- $ret .= '<input type="submit" value="' . $title . '"';
- if (!$enabled) {
- $ret .= ' disabled="disabled"';
- }
- $ret .= ' />';
- $ret .= get_hidden_cfg();
- $ret .= '</form>';
- $ret .= "\n";
- return $ret;
-}
-
-/**
- * Creates form for going to some url
- *
- * @param string URL where to go
- * @param string form title
- * @param string optional array of parameters
- *
- * @return string HTML with form
- */
-function get_url_action($url, $title, $params = array()) {
- $ret = '';
- $ret .= '<form class="action" method="get" action="' . $url . '" target="_blank">';
- $ret .= get_hidden_inputs();
- foreach ($params as $key => $val) {
- $ret .= '<input type="hidden" name="' . $key . '" value="' . $val . '" />';
- }
- $ret .= '<input type="submit" value="' . $title . '" />';
- $ret .= '</form>';
- $ret .= "\n";
- return $ret;
-}
-
-/**
- * Terminates script and ends HTML
- *
- * @return nothing
- */
-function footer() {
- echo '</body>';
- echo '</html>';
- exit;
-}
-
-/**
- * Creates string describing server authentication method
- *
- * @param array server configuration
- *
- * @return string authentication method description
- */
-function get_server_auth($val) {
- global $PMA_Config_Setup;
-
- if (isset($val['auth_type'])) {
- $auth = $val['auth_type'];
- } else {
- $auth = $PMA_Config_Setup->default_server['auth_type'];
- }
- $ret = $auth;
- if ($auth == 'config') {
- if (isset($val['user'])) {
- $ret .= ':' . $val['user'];
- } else {
- $ret .= ':' . $PMA_Config_Setup->default_server['user'];
- }
- }
- return $ret;
-}
-
-/**
- * Creates nice string with server name
- *
- * @param array server configuration
- * @param int optional server id
- *
- * @return string fancy server name
- */
-function get_server_name($val, $id = FALSE, $escape = true) {
- if (!empty($val['verbose'])) {
- $ret = $val['verbose'];
- } else {
- $ret = $val['host'];
- }
- $ret .= ' (' . get_server_auth($val) . ')';
- if ($id !== FALSE) {
- $ret .= ' [' . ($id + 1) . ']' ;
- }
- if ($escape) {
- return htmlspecialchars($ret);
- } else {
- return $ret;
- }
-}
-
-
-/**
- * Exports variable to PHP code, very limited version of var_export
- *
- * @param string data to export
- *
- * @see var_export
- *
- * @return string PHP code containing variable value
- */
-function PMA_var_export($input) {
- global $crlf;
-
- $output = '';
- if (is_null($input)) {
- $output .= 'NULL';
- } elseif (is_array($input)) {
- $output .= 'array (' . $crlf;
- foreach($input as $key => $value) {
- $output .= PMA_var_export($key) . ' => ' . PMA_var_export($value);
- $output .= ',' . $crlf;
- }
- $output .= ')';
- } elseif (is_string($input)) {
- $output .= '\'' . addslashes($input) . '\'';
- } elseif (is_int($input) || is_double($input)) {
- $output .= (string) $input;
- } elseif (is_bool($input)) {
- $output .= $input ? 'true' : 'false';
- } else {
- die('Unknown type for PMA_var_export: ' . $input);
- }
- return $output;
-}
-
-/**
- * Creates configuration code for one variable
- *
- * @param string variable name
- * @param mixed configuration
- *
- * @return string PHP code containing configuration
- */
-function get_cfg_val($name, $val) {
- global $crlf;
-
- $ret = '';
- if (is_array($val)) {
- $ret .= $crlf;
- foreach ($val as $k => $v) {
- if (!isset($type)) {
- if (is_string($k)) {
- $type = 'string';
- } elseif (is_int($k)) {
- $type = 'int';
- $ret .= $name . ' = array(' . $crlf;
- } else {
- // Something unknown...
- $ret .= $name. ' = ' . PMA_var_export($val) . ';' . $crlf;
- break;
- }
- }
- if ($type == 'string') {
- $ret .= get_cfg_val($name . "['$k']", $v);
- } elseif ($type == 'int') {
- $ret .= ' ' . PMA_var_export($v) . ',' . $crlf;
- }
- }
- if (!isset($type)) {
- /* Empty array */
- $ret .= $name . ' = array();' . $crlf;
- } elseif ($type == 'int') {
- $ret .= ');' . $crlf;
- }
- $ret .= $crlf;
- unset($type);
- } else {
- $ret .= $name . ' = ' . PMA_var_export($val) . ';' . $crlf;
- }
- return $ret;
-}
-
-/**
- * Creates configuration PHP code
- *
- * @param array configuration
- *
- * @return string PHP code containing configuration
- */
-function get_cfg_string($cfg) {
- global $script_info, $script_version, $now, $crlf;
-
- $c = $cfg;
- $ret = "<?php$crlf/*$crlf * Generated configuration file$crlf * Generated by: $script_info$crlf * Version: $script_version$crlf * Date: " . $now . $crlf . ' */' . $crlf . $crlf;
-
- if (count($c['Servers']) > 0) {
- $ret .= "/* Servers configuration */$crlf\$i = 0;" . $crlf;
- foreach ($c['Servers'] as $cnt => $srv) {
- $ret .= $crlf . '/* Server ' . strtr(get_server_name($srv, $cnt, false), '*', '-') . " */$crlf\$i++;" . $crlf;
- foreach ($srv as $key => $val) {
- $ret .= get_cfg_val("\$cfg['Servers'][\$i]['$key']", $val);
- }
- }
- $ret .= $crlf . '/* End of servers configuration */' . $crlf . $crlf;
- }
- unset($c['Servers']);
-
- foreach ($c as $key => $val) {
- $ret .= get_cfg_val("\$cfg['$key']", $val);
- }
-
- $ret .= '?>' . $crlf;
- return $ret;
-}
-
-/**
- * Compresses server configuration to be indexed from 0 and contain no gaps
- *
- * @param array configuration
- *
- * @return nothing
- */
-function compress_servers(&$cfg) {
- $ns = array();
- foreach ($cfg['Servers'] as $val) {
- if (!empty($val['host'])) {
- $ns[] = $val;
- }
- }
- $cfg['Servers'] = $ns;
-}
-
-/**
- * Grabs values from POST
- *
- * @param string list of values to grab, values are separated by ";",
- * each can have defined type separated by ":", if no type
- * is defined, string is assumed. Possible types: bool -
- * boolean value, serialized - serialized value, int -
- * integer, tristate - "TRUE"/"FALSE" converted to bool,
- * other strings are kept.
- *
- * @return array array with grabbed values
- */
-function grab_values($list)
-{
- $a = split(';', $list);
- $res = array();
- foreach ($a as $val) {
- $v = split(':', $val);
- if (!isset($v[1])) {
- $v[1] = '';
- }
- switch($v[1]) {
- case 'bool':
- $res[$v[0]] = isset($_POST[$v[0]]);
- break;
- case 'serialized':
- if (isset($_POST[$v[0]]) && strlen($_POST[$v[0]]) > 0) {
- $res[$v[0]] = unserialize($_POST[$v[0]]);
- }
- break;
- case 'int':
- if (isset($_POST[$v[0]]) && strlen($_POST[$v[0]]) > 0) {
- $res[$v[0]] = (int)$_POST[$v[0]];
- }
- break;
- case 'tristate':
- if (isset($_POST[$v[0]]) && strlen($_POST[$v[0]]) > 0) {
- $cur = $_POST[$v[0]];
- if ($cur == 'TRUE') {
- $res[$v[0]] = TRUE;
- } elseif ($cur == 'FALSE') {
- $res[$v[0]] = FALSE;
- } else {
- $res[$v[0]] = $cur;
- }
- }
- break;
- case 'string':
- default:
- if (isset($_POST[$v[0]]) && strlen($_POST[$v[0]]) > 0) {
- $res[$v[0]] = $_POST[$v[0]];
- }
- break;
- }
- }
- return $res;
-}
-
-/**
- * Displays overview
- *
- * @param string title of oveview
- * @param array list of values to display (each element is array of two
- * values - name and value)
- * @param string optional buttons to be displayed
- *
- * @return nothing
- */
-function show_overview($title, $list, $buttons = '') {
- echo '<fieldset class="overview">' . "\n";
- echo '<legend>' . $title . '</legend>' . "\n";
- foreach ($list as $val) {
- echo '<div class="row">';
- echo '<div class="desc">';
- echo $val[0];
- echo '</div>';
- echo '<div class="data">';
- echo $val[1];
- echo '</div>';
- echo '</div>' . "\n";
- }
- if (!empty($buttons)) {
- echo '<div class="buttons">';
- echo '<div class="desc">Actions:</div>';
- echo $buttons;
- echo '</div>' . "\n";
- }
- echo '</fieldset>' . "\n";
- echo "\n";
-}
-
-/**
- * Displays configuration, fallback defaults are taken from global $PMA_Config_Setup
- *
- * @param array list of values to display (each element is array of two or
- * three values - desription, name and optional type
- * indicator). Type is determined by type of this parameter,
- * array means select and array elements are items,
- * 'password' means password input.
- * @param string title of configuration
- * @param string help string for this configuration
- * @param array optional first level defaults
- * @param string optional title for save button
- * @param string optional prefix for documentation links
- *
- * @return nothing
- */
-function show_config_form($list, $legend, $help, $defaults = array(), $save = '', $prefix = '') {
- global $PMA_Config_Setup;
-
- if (empty($save)) {
- $save = 'Update';
- }
-
- echo '<fieldset class="optbox">' . "\n";
- echo '<legend>' . $legend . '</legend>' . "\n";
- echo '<p>' . $help . '</p>' . "\n";
- foreach ($list as $val) {
- echo '<div class="opts">';
- $type = 'text';
- if (isset($val[3])) {
- if (is_array($val[3])) {
- $type = 'select';
- } elseif (is_bool($val[3])) {
- $type = 'check';
- } elseif ($val[3] == 'password') {
- $type = 'password';
- }
- }
- switch ($type) {
- case 'text':
- case 'password':
- echo '<label for="text_' . $val[1] . '" class="desc" title="' . $val[2] . '">' . $val[0] . get_cfg_doc($prefix . $val[1]) . '</label>';
- echo '<input type="' . $type . '" name="' . $val[1] . '" id="text_' . $val[1] . '" title="' . $val[2] . '" size="50"';
- if (isset($defaults[$val[1]])) {
- echo ' value="' . htmlspecialchars($defaults[$val[1]]) . '"';
- } else {
- echo ' value="' . htmlspecialchars($PMA_Config_Setup->get($val[1])) . '"';
- }
- echo ' />';
- break;
- case 'check':
- echo '<input type="checkbox" name="' . $val[1] . '" value="something" id="checkbox_' . $val[1] . '" title="' . $val[2] . '"';
- if (isset($defaults[$val[1]])) {
- if ($defaults[$val[1]]) {
- echo ' checked="checked"';
- }
- } else {
- if ($PMA_Config_Setup->get($val[1])) {
- echo ' checked="checked"';
- }
- }
- echo ' />';
- echo '<label for="checkbox_' . $val[1] . '" title="' . $val[2] . '">' . $val[0] . get_cfg_doc($prefix . $val[1]) . '</label>';
- break;
- case 'select':
- echo '<label for="select_' . $val[1] . '" class="desc" title="' . $val[2] . '">' . $val[0] . get_cfg_doc($prefix . $val[1]) . '</label>';
- echo '<select name="' . $val[1] . '" id="select_' . $val[1] . '" ' . ' title="' . $val[2] . '">';
- foreach ($val[3] as $opt) {
- echo '<option value="' . $opt . '"';
- if (isset($defaults[$val[1]])) {
- if (is_bool($defaults[$val[1]])) {
- if (($defaults[$val[1]] && $opt == 'TRUE') || (!$defaults[$val[1]] && $opt == 'FALSE')) {
- echo ' selected="selected"';
- }
- } else {
- if ($defaults[$val[1]] == $opt) {
- echo ' selected="selected"';
- }
- }
- } else {
- $def_val = $PMA_Config_Setup->get($val[1]);
- if (is_bool($val)) {
- if (($def_val && $opt == 'TRUE') || (!$def_val && $opt == 'FALSE')) {
- echo ' selected="selected"';
- }
- } else {
- if ($def_val == $opt) {
- echo ' selected="selected"';
- }
- }
- unset($def_val);
- }
- echo '>' . $opt . '</option>';
- }
- echo '</select>';
- break;
- }
- echo '</div>' . "\n";
- }
- echo '<div class="buttons">';
- echo '<div class="desc">Actions:</div>';
- echo '<input type="submit" name="submit_save" value="' . $save .'" class="save" />';
- echo '<input type="submit" name="submit_ignore" value="Cancel" class="cancel" />';
- echo '</div>' . "\n";
- echo '</fieldset>' . "\n";
- echo "\n";
-}
-
-/**
- * Shows security options configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_security_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="feat_security_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Blowfish secret', 'blowfish_secret', 'Secret passphrase used for encrypting cookies'),
- array('Force SSL connection', 'ForceSSL', 'Whether to force using secured connection while using phpMyAdmin', FALSE),
- array('Show phpinfo output', 'ShowPhpInfo', 'Whether to allow users to see phpinfo() output', FALSE),
- array('Show password change form', 'ShowChgPassword', 'Whether to show form for changing password, this does not limit ability to execute the same command directly', FALSE),
- array('Allow login to any MySQL server', 'AllowArbitraryServer', 'If enabled user can enter any MySQL server in login form for cookie auth.', FALSE),
- array('Recall user name', 'LoginCookieRecall', 'Whether to recall user name on log in prompt while using cookie auth.', TRUE),
- array('Login cookie validity', 'LoginCookieValidity', 'How long is login valid without performing any action.'),
- ),
- 'Configure security features',
- 'Please note that phpMyAdmin is just a user interface and it\'s features do not limit MySQL.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows MySQL manual configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_manual_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="feat_manual_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Type of MySQL documentation', 'MySQLManualType', 'These types are same as listed on MySQL download page', array('viewable', 'chapters', 'big', 'none')),
- array('Base URL of MySQL documentation', 'MySQLManualBase', 'Where is MySQL documentation placed, this is usually top level directory.'),
- ),
- 'Configure MySQL manual links',
- 'If you have local copy of MySQL documentation, you might want to use it in documentation links. Otherwise use <code>viewable</code> type and <code>http://dev.mysql.com/doc/refman</code> as manual base URL.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows charset options configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_charset_form($defaults = array()) {
- global $PMA_Config_Setup;
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="feat_charset_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Allow charset conversion', 'AllowAnywhereRecoding', 'If you want to use such functions.', FALSE),
- array('Default charset', 'DefaultCharset', 'Default charset for conversion.', $PMA_Config_Setup->get('AvailableCharsets')),
- array('Recoding engine', 'RecodingEngine', 'PHP can contain iconv and/or recode, select which one to use or keep autodetection.', array('auto', 'iconv', 'recode')),
- array('Extra params for iconv', 'IconvExtraParams', 'Iconv can get some extra parameters for conversion see man iconv_open.'),
- ),
- 'Configure charset conversions',
- 'phpMyAdmin can perform charset conversions so that you can import and export in any charset you want.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows PHP extensions configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_extensions_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="feat_extensions_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('GD 2 is available', 'GD2Available', 'Whether you have GD 2 or newer installed', array('auto', 'yes', 'no')),
- ),
- 'Configure extensions',
- 'phpMyAdmin can use several extensions, however here are configured only those that didn\'t fit elsewhere. MySQL extension is configured within server, charset conversion one on separate charsets page.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows MIME/relation/history configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_relation_form($defaults = array()) {
- global $PMA_Config_Setup;
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="feat_relation_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Permanent query history', 'QueryHistoryDB', 'Store history into database.', FALSE),
- array('Maximal history size', 'QueryHistoryMax', 'How many queries are kept in history.'),
- array('Use MIME transformations', 'BrowseMIME', 'Use MIME transformations while browsing.', TRUE),
- array('PDF default page size', 'PDFDefaultPageSize', 'Default page size for PDF, you can change this while creating page.', $PMA_Config_Setup->get('PDFPageSizes')),
- ),
- 'Configure MIME/relation/history',
- 'phpMyAdmin can provide additional features like MIME transformation, internal relations, permanent history and PDF pages generation. You have to configure the database and tables that will store this information on the server page. Behaviour of those functions is configured here.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows upload/save configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_upload_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="feat_upload_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Upload directory', 'UploadDir', 'Directory on server where you can upload files for import'),
- array('Save directory', 'SaveDir', 'Directory where exports can be saved on server'),
- ),
- 'Configure upload/save directories',
- 'Enter directories, either absolute path or relative to phpMyAdmin top level directory.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows server configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_server_form($defaults = array(), $number = FALSE) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="addserver_real" />
- <?php
- echo get_hidden_cfg();
- if (!($number === FALSE)) {
- echo '<input type="hidden" name="server" value="' . $number . '" />';
- }
- $hi = array ('bookmarktable', 'relation', 'table_info', 'table_coords', 'pdf_pages', 'column_info', 'designer_coords', 'history', 'AllowDeny');
- foreach ($hi as $k) {
- if (isset($defaults[$k]) && (!is_string($defaults[$k]) || strlen($defaults[$k]) > 0)) {
- echo '<input type="hidden" name="' . $k . '" value="' . htmlspecialchars(serialize($defaults[$k])) . '" />';
- }
- }
- show_config_form(array(
- array('Server hostname', 'host', 'Hostname where MySQL server is running'),
- array('Server port', 'port', 'Port on which MySQL server is listening, leave empty for default'),
- array('Server socket', 'socket', 'Socket on which MySQL server is listening, leave empty for default'),
- array('Connection type', 'connect_type', 'How to connect to server, keep tcp if unsure', array('tcp', 'socket')),
- array('PHP extension to use', 'extension', 'What PHP extension to use, use mysqli if supported', array('mysql', 'mysqli')),
- array('Compress connection', 'compress', 'Whether to compress connection to MySQL server', FALSE),
- array('Authentication type', 'auth_type', 'Authentication method to use', array('cookie', 'http', 'config', 'signon')),
- array('User for config auth', 'user', 'Leave empty if not using config auth'),
- array('Password for config auth', 'password', 'Leave empty if not using config auth', 'password'),
- array('Only database to show', 'only_db', 'Limit listing of databases in left frame to this one'),
- array('Verbose name of this server', 'verbose', 'Name to display in server selection'),
- array('phpMyAdmin control user', 'controluser', 'User which phpMyAdmin can use for various actions'),
- array('phpMyAdmin control user password', 'controlpass', 'Password for user which phpMyAdmin can use for various actions', 'password'),
- array('phpMyAdmin database for advanced features', 'pmadb', 'phpMyAdmin will allow much more when you enable this. Table names are filled in automatically.'),
- array('Session name for signon auth', 'SignonSession', 'Leave empty if not using signon auth'),
- array('Login URL for signon auth', 'SignonURL', 'Leave empty if not using signon auth'),
- array('Logout URL', 'LogoutURL', 'Where to redirect user after logout'),
- ),
- 'Configure server',
- ($number === FALSE) ? 'Enter new server connection parameters.' : 'Editing server ' . get_server_name($defaults, $number),
- $defaults, $number === FALSE ? 'Add' : '', 'Servers_');
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows left frame configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_left_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="lay_navigation_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Use light version', 'LeftFrameLight', 'Disable this if you want to see all databases at one time.', TRUE),
- array('Display databases in tree', 'LeftFrameDBTree', 'Whether to display databases in tree (determined by separator defined lower)', TRUE),
- array('Databases tree separator', 'LeftFrameDBSeparator', 'String that separates databases into different tree level'),
- array('Table tree separator', 'LeftFrameTableSeparator', 'String that separates tables into different tree level'),
- array('Maximum table tree nesting', 'LeftFrameTableLevel', 'Maximum number of children in table tree'),
- array('Show logo', 'LeftDisplayLogo', 'Whether to show logo in left frame', TRUE),
- array('Display servers selection', 'LeftDisplayServers', 'Whether to show server selection in left frame', FALSE),
- array('Display servers as list', 'DisplayServersList', 'Whether to show server listing as list instead of drop down', FALSE),
- array('Display databases as list', 'DisplayDatabasesList', 'Whether to show database listing in navigation as list instead of drop down', array('auto', 'yes', 'no')),
- array('Enable pointer highlighting', 'LeftPointerEnable', 'Whether you want to highlight server under mouse', TRUE),
- ),
- 'Configure navigation frame',
- 'Customize the appears of the navigation frame.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows tabs configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_tabs_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="lay_tabs_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Default tab for server', 'DefaultTabServer', 'Tab that is displayed when entering server', array('main.php', 'server_databases.php', 'server_status.php', 'server_variables.php', 'server_privileges.php', 'server_processlist.php')),
- array('Default tab for database', 'DefaultTabDatabase', 'Tab that is displayed when entering database', array('db_structure.php', 'db_sql.php', 'db_search.php', 'db_operations.php')),
- array('Default tab for table', 'DefaultTabTable', 'Tab that is displayed when entering table', array('tbl_structure.php', 'sql.php', 'tbl_sql.php', 'tbl_select.php', 'tbl_change.php')),
- array('Use lighter tabs', 'LightTabs', 'If you want simpler tabs enable this', FALSE),
- ),
- 'Configure tabs',
- 'Choose how you want tabs to work.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows icons configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_icons_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="lay_icons_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Icons on errors', 'ErrorIconic', 'Whether to use icons in error messages.', TRUE),
- array('Icons on main page', 'MainPageIconic', 'Whether to use icons on main page.', TRUE),
- array('Icons as help links', 'ReplaceHelpImg', 'Whether to use icons as help links.', TRUE),
- array('Navigation with icons', 'NavigationBarIconic', 'Whether to display navigation (eg. tabs) with icons.', array('TRUE', 'FALSE', 'both')),
- array('Properties pages with icons', 'PropertiesIconic', 'Whether to display properties (eg. table lists and structure) with icons.', array('TRUE', 'FALSE', 'both')),
- ),
- 'Configure icons',
- 'Select whether you prefer text or icons. Both means that text and icons will be displayed.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows browsing configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_browse_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="lay_browse_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Display of values', 'DefaultDisplay', 'How to list values while browsing', array('horizontal', 'vertical', 'horizontalflipped')),
- array('Hightlight pointer', 'BrowsePointerEnable', 'Whether to highlight row under mouse.', TRUE),
- array('Use row marker', 'BrowseMarkerEnable', 'Whether to highlight selected row.', TRUE),
- array('Action buttons on left', 'ModifyDeleteAtLeft', 'Show action buttons on left side of listing?', TRUE),
- array('Action buttons on right', 'ModifyDeleteAtRight', 'Show action buttons on right side of listing?', FALSE),
- array('Repeat heading', 'RepeatCells', 'After how many rows heading should be repeated.'),
- ),
- 'Configure browsing',
- 'Select desired browsing look and feel.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows editing options configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_edit_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="lay_edit_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Display of properties while editing', 'DefaultPropDisplay', 'How to list properties (table structure or values) while editing', array('horizontal', 'vertical')),
- array('Number of inserted rows', 'InsertRows', 'How many rows can be inserted at once'),
- array('Move using Ctrl+arrows', 'CtrlArrowsMoving', 'Whether to enable moving using Ctrl+Arrows', TRUE),
- array('Autoselect text in textarea', 'TextareaAutoSelect', 'Whether to automatically select text in textarea on focus.', TRUE),
- array('Textarea columns', 'TextareaCols', 'Number of columns in textarea while editing TEXT fields'),
- array('Textarea rows', 'TextareaRows', 'Number of rows in textarea while editing TEXT fields'),
- array('Double textarea for LONGTEXT', 'LongtextDoubleTextarea', 'Whether to double textarea size for LONGTEXT fields', TRUE),
- array('Edit CHAR fields in textarea', 'CharEditing', 'Whether to edit CHAR fields in textarea', array('input', 'textarea')),
- array('CHAR textarea columns', 'CharTextareaCols', 'Number of columns in textarea while editing CHAR fields (must be enabled above)'),
- array('CHAR textarea rows', 'CharTextareaRows', 'Number of rows in textarea while editing CHAR fields (must be enabled above)'),
- ),
- 'Configure editing',
- 'Select desired editing look and feel.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Shows query window configuration form
- *
- * @param array optional defaults
- *
- * @return nothing
- */
-function show_window_form($defaults = array()) {
- ?>
-<form method="post" action="">
- <?php echo get_hidden_inputs();?>
- <input type="hidden" name="action" value="lay_window_real" />
- <?php
- echo get_hidden_cfg();
- show_config_form(array(
- array('Edit SQL in window', 'EditInWindow', 'Whether edit links will edit in query window.', TRUE),
- array('Query window height', 'QueryWindowHeight', 'Height of query window'),
- array('Query window width', 'QueryWindowWidth', 'Width of query window'),
- array('Default tab', 'QueryWindowDefTab', 'Default tab on query window', array('sql', 'files', 'history', 'full')),
- ),
- 'Configure query window',
- 'Select desired query window look and feel.',
- $defaults);
- ?>
-</form>
- <?php
-}
-
-/**
- * Creates selection with servers
- *
- * @param array configuraion
- *
- * @return string HTML for server selection
- */
-function get_server_selection($cfg) {
- if (count($cfg['Servers']) == 0) {
- return '';
- }
- $ret = '<select name="server">';
- foreach ($cfg['Servers'] as $key => $val) {
- $ret .= '<option value="' . $key . '">' . get_server_name($val, $key) . '</option>';
- }
- $ret .= '</select>';
- return $ret;
-}
-
-/**
- * Loads configuration from file
- *
- * @param string filename
- *
- * @return mixed FALSE on failure, new config array on success
- */
-function load_config($config_file) {
- if (file_exists($config_file)) {
- $success_apply_user_config = FALSE;
- $old_error_reporting = error_reporting(0);
- if (function_exists('file_get_contents')) {
- $success_apply_user_config = eval('?>' . trim(file_get_contents($config_file)));
- } else {
- $success_apply_user_config =
- eval('?>' . trim(implode("\n", file($config_file))));
- }
- error_reporting($old_error_reporting);
- unset($old_error_reporting);
- if ($success_apply_user_config === FALSE) {
- message('error', 'Error while parsing configuration file!');
- } elseif (!isset($cfg) || count($cfg) == 0) {
- message('error', 'Config file seems to contain no configuration!');
- } else {
- // This must be set
- if (!isset($cfg['Servers'])) {
- $cfg['Servers'] = array();
- }
- message('notice', 'Configuration loaded');
- compress_servers($cfg);
- return $cfg;
- }
- } else {
- message('error', 'Configuration file not found!');
- }
- return FALSE;
-}
-
-if ($action != 'download') {
- // Check whether we can write to configuration
- $fail_dir = FALSE;
- $fail_dir = $fail_dir || !is_dir('./config/');
- $fail_dir = $fail_dir || !is_writable('./config/');
- $fail_dir = $fail_dir || (file_exists('./config/config.inc.php') && !is_writable('./config/config.inc.php'));
- $config = @fopen('./config/config.inc.php', 'a');
- $fail_dir = $fail_dir || ($config === FALSE);
- @fclose($config);
-}
-
-/**
- * @var boolean whether to show configuration overview
- */
-$show_info = FALSE;
-
-// Do the main work depending on selected action
-switch ($action) {
- case 'download':
- header('Content-Type: text/plain');
- header('Content-Disposition: attachment; filename="config.inc.php"');
-
- echo get_cfg_string($configuration);
- exit;
- break;
- case 'display':
- echo '<form method="none" action=""><textarea name="config" cols="50" rows="20" id="textconfig" wrap="off">' . "\n";
- echo htmlspecialchars(get_cfg_string($configuration));
- echo '</textarea></form>' . "\n";
- ?>
-<script type="text/javascript">
-//<![CDATA[
- var bodyWidth=null; var bodyHeight=null;
- if (document.getElementById('textconfig')) {
- bodyWidth = self.innerWidth;
- bodyHeight = self.innerHeight;
- if(!bodyWidth && !bodyHeight){
- if (document.compatMode && document.compatMode == "BackCompat") {
- bodyWidth = document.body.clientWidth;
- bodyHeight = document.body.clientHeight;
- } else if (document.compatMode && document.compatMode == "CSS1Compat") {
- bodyWidth = document.documentElement.clientWidth;
- bodyHeight = document.documentElement.clientHeight;
- }
- }
- document.getElementById('textconfig').style.width=(bodyWidth-50) + 'px';
- document.getElementById('textconfig').style.height=(bodyHeight-100) + 'px';
- }
-//]]>
-</script>
- <?php
- break;
- case 'save':
- $config = @fopen('./config/config.inc.php', 'w');
- if ($config === FALSE) {
- message('error', 'Could not open config file for writing! Bad permissions?');
- break;
- }
- $s = get_cfg_string($configuration);
- $r = fwrite($config, $s);
- if (!$r || $r != strlen($s)) {
- message('error', 'Could not write to config file! Not enough space?');
- break;
- } else {
- message('notice', 'Configuration saved to file config/config.inc.php in phpMyAdmin top level directory, copy it to top level one and delete directory config to use it.', 'File saved');
- }
- unset($r, $s);
- fclose($config);
- break;
- case 'load':
- if ($fail_dir) {
- message('error', 'Reading of configuration disabled because of permissions.');
- break;
- }
- $new_cfg = load_config('./config/config.inc.php');
- if (!($new_cfg === FALSE)) {
- $configuration = $new_cfg;
- }
- $show_info = TRUE;
- break;
-
- case 'addserver_real':
- if (isset($_POST['submit_save'])) {
- $new_server = grab_values('host;extension;port;socket;connect_type;compress:bool;controluser;controlpass;auth_type;user;password;only_db;verbose;pmadb;bookmarktable:serialized;relation:serialized;table_info:serialized;table_coords:serialized;pdf_pages:serialized;column_info:serialized;designer_coords:serialized;history:serialized;AllowDeny:serialized;SignonSession;SignonURL;LogoutURL');
- $err = FALSE;
- if (empty($new_server['host'])) {
- message('error', 'Empty hostname!');
- $err = TRUE;
- }
- if ($new_server['auth_type'] == 'config' && empty($new_server['user'])) {
- message('error', 'Empty username while using config authentication method!');
- $err = TRUE;
- }
- if ($new_server['auth_type'] == 'signon' && empty($new_server['SignonSession'])) {
- message('error', 'Empty signon session name while using signon authentication method!');
- $err = TRUE;
- }
- if ($new_server['auth_type'] == 'signon' && empty($new_server['SignonURL'])) {
- message('error', 'Empty signon URL while using signon authentication method!');
- $err = TRUE;
- }
- if (isset($new_server['pmadb']) && strlen($new_server['pmadb'])) {
- // Just use defaults, should be okay for most users
- $pmadb = array();
- $pmadb['bookmarktable'] = 'pma_bookmark';
- $pmadb['relation'] = 'pma_relation';
- $pmadb['table_info'] = 'pma_table_info';
- $pmadb['table_coords'] = 'pma_table_coords';
- $pmadb['pdf_pages'] = 'pma_pdf_pages';
- $pmadb['column_info'] = 'pma_column_info';
- $pmadb['designer_coords'] = 'pma_designer_coords';
- $pmadb['history'] = 'pma_history';
-
- $new_server = array_merge($pmadb, $new_server);
- unset($pmadb);
- if (empty($new_server['controluser'])) {
- message('error', 'Empty phpMyAdmin control user while using pmadb!');
- $err = TRUE;
- }
- if (empty($new_server['controlpass'])) {
- message('error', 'Empty phpMyAdmin control user password while using pmadb!');
- $err = TRUE;
- }
- /* Check whether we can connect as control user */
- if (!empty($new_server['controluser']) && !empty($new_server['controlpass'])) {
- if ($new_server['extension'] == 'mysql') {
- $socket = empty($new_server['socket']) || $new_server['connect_type'] == 'tcp' ? '' : ':' . $new_server['socket'];
- $port = empty($new_server['port']) || $new_server['connect_type'] == 'socket' ? '' : ':' . $new_server['port'];
- $conn = @mysql_connect($new_server['host'] . $socket . $port, $new_server['controluser'], $new_server['controlpass']);
- if ($conn === FALSE) {
- message('error', 'Could not connect as control user!');
- $err = TRUE;
- } else {
- mysql_close($conn);
- }
- } else {
- $socket = empty($new_server['socket']) || $new_server['connect_type'] == 'tcp' ? NULL : $new_server['socket'];
- $port = empty($new_server['port']) || $new_server['connect_type'] == 'socket' ? NULL : $new_server['port'];
- $conn = @mysqli_connect($new_server['host'], $new_server['controluser'], $new_server['controlpass'], NULL, $port, $socket);
- if ($conn === FALSE) {
- message('error', 'Could not connect as control user!');
- $err = TRUE;
- } else {
- mysqli_close($conn);
- }
- }
- }
- } else {
- message('warning', 'You didn\'t set phpMyAdmin database, so you can not use all phpMyAdmin features.');
- }
- if ($new_server['auth_type'] == 'config') {
- message('warning', 'Remember to protect your installation while using config authentication method!');
- } else {
- // Not needed:
- unset($new_server['user']);
- unset($new_server['password']);
- }
- if ($err) {
- show_server_form($new_server, isset($_POST['server']) ? $_POST['server'] : FALSE);
- } else {
- if (isset($_POST['server'])) {
- $configuration['Servers'][$_POST['server']] = $new_server;
- message('notice', 'Changed server ' . get_server_name($new_server, $_POST['server']));
- } else {
- $configuration['Servers'][] = $new_server;
- message('notice', 'New server added');
- }
- $show_info = TRUE;
- if ($new_server['auth_type'] == 'cookie' && empty($configuration['blowfish_secret'])) {
- message('notice', 'You did not have configured blowfish secret and you want to use cookie authentication so I generated blowfish secret for you. It is used to encrypt cookies.', 'Blowfish secret generated');
- $configuration['blowfish_secret'] = uniqid('', TRUE);
- }
- }
- unset($new_server);
- } else {
- $show_info = TRUE;
- }
- break;
- case 'addserver':
- if (count($configuration['Servers']) == 0) {
- // First server will use defaults as in config.default.php
- $defaults = $PMA_Config_Setup->default_server;
- unset($defaults['AllowDeny']); // Ignore this for now
- } else {
- $defaults = array();
- }
-
- // Guess MySQL extension to use, prefer mysqli
- if (!function_exists('mysql_get_client_info')) {
- PMA_dl('mysql');
- }
- if (!function_exists('mysqli_get_client_info')) {
- PMA_dl('mysqli');
- }
- if (function_exists('mysqli_get_client_info')) {
- $defaults['extension'] = 'mysqli';
- } elseif (function_exists('mysql_get_client_info')) {
- $defaults['extension'] = 'mysql';
- } else {
- message('warning', 'Could not load either mysql or mysqli extension, you might not be able to use phpMyAdmin! Check your PHP configuration.');
- }
- if (isset($defaults['extension'])) {
- message('notice', 'Autodetected MySQL extension to use: ' . $defaults['extension']);
- }
-
- // Display form
- show_server_form($defaults);
- break;
- case 'editserver':
- if (!isset($_POST['server'])) {
- footer();
- }
- show_server_form($configuration['Servers'][$_POST['server']], $_POST['server']);
- break;
- case 'deleteserver':
- if (!isset($_POST['server'])) {
- footer();
- }
- message('notice', 'Deleted server ' . get_server_name($configuration['Servers'][$_POST['server']], $_POST['server']));
- unset($configuration['Servers'][$_POST['server']]);
- compress_servers($configuration);
- $show_info = TRUE;
- break;
- case 'servers':
- if (count($configuration['Servers']) == 0) {
- message('notice', 'No servers defined, so none can be shown');
- } else {
- foreach ($configuration['Servers'] as $i => $srv) {
- $data = array();
- if (!empty($srv['verbose'])) {
- $data[] = array('Verbose name', $srv['verbose']);
- }
- $data[] = array('Host', $srv['host']);
- $data[] = array('MySQL extension', isset($srv['extension']) ? $srv['extension'] : $PMA_Config_Setup->default_server['extension']);
- $data[] = array('Authentication type', get_server_auth($srv));
- $data[] = array('phpMyAdmin advanced features', empty($srv['pmadb']) || empty($srv['controluser']) || empty($srv['controlpass']) ? 'disabled' : 'enabled, db: ' . $srv['pmadb'] . ', user: ' . $srv['controluser']);
- $buttons =
- get_action('deleteserver', 'Delete', '<input type="hidden" name="server" value="' . $i . '" />') .
- get_action('editserver', 'Edit', '<input type="hidden" name="server" value="' . $i . '" />');
- show_overview('Server ' . get_server_name($srv, $i), $data, $buttons);
- }
- }
- break;
-
- case 'feat_upload_real':
- if (isset($_POST['submit_save'])) {
- $dirs = grab_values('UploadDir;SaveDir');
- $err = FALSE;
- if (!empty($dirs['UploadDir']) && !is_dir($dirs['UploadDir'])) {
- message('error', 'Upload directory ' . htmlspecialchars($dirs['UploadDir']) . ' does not exist!');
- $err = TRUE;
- }
- if (!empty($dirs['SaveDir']) && !is_dir($dirs['SaveDir'])) {
- message('error', 'Save directory ' . htmlspecialchars($dirs['SaveDir']) . ' does not exist!');
- $err = TRUE;
- }
- if ($err) {
- show_upload_form($dirs);
- } else {
- $configuration = array_merge($configuration, $dirs);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'feat_upload':
- show_upload_form($configuration);
- break;
-
- case 'feat_security_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('blowfish_secret;ForceSSL:bool;ShowPhpInfo:bool;ShowChgPassword:bool;AllowArbitraryServer:bool;LoginCookieRecall:book;LoginCookieValidity:int');
- $err = FALSE;
- if (empty($vals['blowfish_secret'])) {
- message('warning', 'Blowfish secret is empty, you will not be able to use cookie authentication.');
- }
- if ($vals['AllowArbitraryServer']) {
- message('warning', 'Arbitrary server connection might be dangerous as it might allow access to internal servers that are not reachable from outside.');
- }
- if (isset($vals['LoginCookieValidity']) && $vals['LoginCookieValidity'] < 1) {
- message('error', 'Invalid cookie validity time');
- $err = TRUE;
- }
- if ($err) {
- show_security_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'feat_security':
- show_security_form($configuration);
- break;
-
- case 'feat_manual_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('MySQLManualBase;MySQLManualType');
- $err = FALSE;
- if ($vals['MySQLManualType'] != 'none' && empty($vals['MySQLManualBase'])) {
- message('error', 'You need to set manual base URL or choose type \'none\'.');
- $err = TRUE;
- }
- if ($err) {
- show_manual_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'feat_manual':
- show_manual_form($configuration);
- break;
-
- case 'feat_charset_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('AllowAnywhereRecoding:bool;DefaultCharset;RecodingEngine;IconvExtraParams');
- $err = FALSE;
- if ($err) {
- show_charset_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'feat_charset':
- $d = $configuration;
- if (!isset($d['RecodingEngine'])) {
- if (@extension_loaded('iconv')) {
- $d['RecodingEngine'] = 'iconv';
- } elseif (@extension_loaded('recode')) {
- $d['RecodingEngine'] = 'recode';
- } else {
- PMA_dl('iconv');
- if (!@extension_loaded('iconv')) {
- PMA_dl('recode');
- if (!@extension_loaded('recode')) {
- message('warning', 'Neither recode nor iconv could be loaded so charset conversion will most likely not work.');
- } else {
- $d['RecodingEngine'] = 'recode';
- }
- } else {
- $d['RecodingEngine'] = 'iconv';
- }
- }
- if (isset($d['RecodingEngine'])) {
- message('notice', 'Autodetected recoding engine: ' . $d['RecodingEngine']);
- }
- }
- show_charset_form($d);
- unset($d);
- break;
-
- case 'feat_extensions_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('GD2Available');
- $err = FALSE;
- if ($err) {
- show_extensions_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'feat_extensions':
- $d = $configuration;
- if (!@extension_loaded('mbstring')) {
- PMA_dl('mbstring');
- }
- if (!@extension_loaded('mbstring')) {
- message('warning', 'Could not load <code>mbstring</code> extension, which is required for work with multibyte strings like UTF-8 ones. Please consider installing it.');
- }
- if (!isset($d['GD2Available'])) {
- if (PMA_IS_GD2 == 1) {
- message('notice', 'GD 2 or newer found.');
- $d['GD2Available'] = 'yes';
- } else {
- message('warning', 'GD 2 or newer is not present.');
- $d['GD2Available'] = 'no';
- }
- }
- show_extensions_form($d);
- unset($d);
- break;
-
- case 'feat_relation_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('QueryHistoryDB:bool;QueryHistoryMax:int;BrowseMIME:bool;PDFDefaultPageSize');
- $err = FALSE;
- if (isset($vals['QueryHistoryMax']) && $vals['QueryHistoryMax'] < 1) {
- message('error', 'Invalid value for query maximum history size!');
- $err = TRUE;
- }
- if ($err) {
- show_relation_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'feat_relation':
- show_relation_form($configuration);
- break;
-
- case 'lay_navigation_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('LeftFrameLight:bool;LeftFrameDBTree:bool;LeftFrameDBSeparator;LeftFrameTableSeparator;LeftFrameTableLevel:int;LeftDisplayLogo:bool;LeftDisplayServers:bool;DisplayServersList:bool;DisplayDatabasesList;LeftPointerEnable:bool');
- $err = FALSE;
- if (isset($vals['DisplayDatabasesList'])) {
- if ($vals['DisplayDatabasesList'] == 'yes') {
- $vals['DisplayDatabasesList'] = true;
- } elseif ($vals['DisplayDatabasesList'] == 'no') {
- $vals['DisplayDatabasesList'] = false;
- }
- }
- if (isset($vals['LeftFrameTableLevel']) && $vals['LeftFrameTableLevel'] < 1) {
- message('error', 'Invalid value for maximum table nesting level!');
- $err = TRUE;
- }
- if ($err) {
- show_left_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'lay_navigation':
- show_left_form($configuration);
- break;
-
- case 'lay_tabs_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('DefaultTabServer;DefaultTabDatabase;DefaultTabTable;LightTabs:bool');
- $err = FALSE;
- if ($err) {
- show_tabs_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'lay_tabs':
- show_tabs_form($configuration);
- break;
-
- case 'lay_icons_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('ErrorIconic:bool;MainPageIconic:bool;ReplaceHelpImg:bool;NavigationBarIconic:tristate;PropertiesIconic:tristate');
- $err = FALSE;
- if ($err) {
- show_icons_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'lay_icons':
- show_icons_form($configuration);
- break;
-
- case 'lay_browse_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('BrowsePointerEnable:bool;BrowseMarkerEnable:bool;ModifyDeleteAtRight:bool;ModifyDeleteAtLeft:bool;RepeatCells:int;DefaultDisplay');
- $err = FALSE;
- if (isset($vals['RepeatCells']) && $vals['RepeatCells'] < 1) {
- message('error', 'Invalid value for header repeating!');
- $err = TRUE;
- }
- if (!$vals['ModifyDeleteAtLeft'] && !$vals['ModifyDeleteAtRight']) {
- message('error', 'No action buttons enabled!');
- $err = TRUE;
- }
- if ($err) {
- show_browse_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'lay_browse':
- show_browse_form($configuration);
- break;
-
- case 'lay_edit_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('TextareaCols:int;TextareaRows:int;LongtextDoubleTextarea:bool;TextareaAutoSelect:bool;CharEditing;CharTextareaCols:int;CharTextareaRows:int;CtrlArrowsMoving:bool;DefaultPropDisplay;InsertRows:int');
- $err = FALSE;
- if (isset($vals['TextareaCols']) && $vals['TextareaCols'] < 1) {
- message('error', 'Invalid value for textarea columns!');
- $err = TRUE;
- }
- if (isset($vals['TextareaRows']) && $vals['TextareaRows'] < 1) {
- message('error', 'Invalid value for textarea rows!');
- $err = TRUE;
- }
- if (isset($vals['CharTextareaCols']) && $vals['CharTextareaCols'] < 1) {
- message('error', 'Invalid value for CHAR textarea columns!');
- $err = TRUE;
- }
- if (isset($vals['CharTextareaRows']) && $vals['CharTextareaRows'] < 1) {
- message('error', 'Invalid value for CHAR textarea rows!');
- $err = TRUE;
- }
- if (isset($vals['InsertRows']) && $vals['InsertRows'] < 1) {
- message('error', 'Invalid value for inserted rows count!');
- $err = TRUE;
- }
- if ($err) {
- show_edit_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'lay_edit':
- show_edit_form($configuration);
- break;
-
- case 'lay_window_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('EditInWindow:bool;QueryWindowHeight:int;QueryWindowWidth:int;QueryWindowDefTab');
- $err = FALSE;
- if (isset($vals['QueryWindowWidth']) && $vals['QueryWindowWidth'] < 1) {
- message('error', 'Invalid value for query window width!');
- $err = TRUE;
- }
- if (isset($vals['QueryWindowHeight']) && $vals['QueryWindowHeight'] < 1) {
- message('error', 'Invalid value for query window height');
- $err = TRUE;
- }
- if ($err) {
- show_window_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'lay_window':
- show_window_form($configuration);
- break;
-
-/* Template for new actions:
- case 'blah_real':
- if (isset($_POST['submit_save'])) {
- $vals = grab_values('value1:bool;value2');
- $err = FALSE;
- if (somechekcfails) {
- message('error', 'Invalid value for blah!');
- $err = TRUE;
- }
- if ($err) {
- show_blah_form($vals);
- } else {
- $configuration = array_merge($configuration, $vals);
- message('notice', 'Configuration changed');
- $show_info = TRUE;
- }
- } else {
- $show_info = TRUE;
- }
- break;
- case 'blah':
- show_blah_form($configuration);
- break;
-*/
- case 'versioncheck': // Check for latest available version
- PMA_dl('curl');
- $url = 'http://phpmyadmin.net/home_page/version.php';
- $data = '';
- $f = @fopen($url, 'r');
- if ($f === FALSE) {
- if (!function_exists('curl_init')) {
- message('error', 'Neither URL wrappers nor CURL are available. Version check is not possible.');
- break;
- }
- } else {
- $data = fread($f, 20);
- fclose($f);
- }
- if (empty($data) && function_exists('curl_init')) {
- $ch = curl_init($url);
- curl_setopt($ch, CURLOPT_HEADER, FALSE);
- curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE);
- $data = curl_exec($ch);
- curl_close($ch);
- }
- if (empty($data)) {
- message('error', 'Reading of version failed. Maybe you\'re offline or the upgrade server does not respond.');
- break;
- }
-
- /* Format: version\ndate\n(download\n)* */
- $data_list = split("\n", $data);
-
- if (count($data_list) > 0) {
- $version = $data_list[0];
- } else {
- $version = '';
- }
-
- $version_upstream = version_to_int($version);
- if ($version_upstream === FALSE) {
- message('error', 'Got invalid version string from server.');
- break;
- }
-
- $version_local = version_to_int($PMA_Config_Setup->get('PMA_VERSION'));
- if ($version_local === FALSE) {
- message('error', 'Unparsable version string.');
- break;
- }
-
- if ($version_upstream > $version_local) {
- message('notice', 'New version of phpMyAdmin is available, you should consider upgrade. New version is ' . htmlspecialchars($version) . '.');
- } else {
- if ($version_local % 100 == 0) {
- message('notice', 'You are using subversion version, run <code>svn update</code> :-). However latest released version is ' . htmlspecialchars($version) . '.');
- } else {
- message('notice', 'No newer stable version is available.');
- }
- }
- break;
-
- case 'seteol':
- $eoltype = $_POST['neweol'];
- message('notice', 'End of line format changed.');
- case 'clear': // Actual clearing is done on beginning of this script
- case 'main':
- $show_info = TRUE;
- break;
-
- case '':
- message('notice', 'You want to configure phpMyAdmin using web interface. Please note that this only allows basic setup, please read <a href="../Documentation.html#config">documentation</a> to see full description of all configuration directives.', 'Welcome');
-
- if ($PMA_Config_Setup->get('PMA_PHP_INT_VERSION') < 40100) {
- message('warning', 'Please upgrade to PHP 4.1.0, it is required for phpMyAdmin.', 'Too old PHP');
- }
-
- if ($fail_dir) {
- message('warning', 'Please create web server writable folder config in phpMyAdmin toplevel directory as described in <a href="../Documentation.html#setup_script">documentation</a>. Otherwise you will be only able to download or display it.', 'Can not load or save configuration');
- }
-
- if (empty($_SERVER['HTTPS']) || strtolower($_SERVER['HTTPS']) == 'off') {
- if (empty($_SERVER['REQUEST_URI']) || empty($_SERVER['HTTP_HOST'])) {
- $redir = '';
- } else {
- $redir = ' If your server is also configured to accept HTTPS request follow <a href="https://' . $_SERVER['HTTP_HOST'] . $_SERVER['REQUEST_URI'] . '">this link</a> to use secure connection.';
- }
- message('warning', 'You are not using secure connection, all data (including sensitive, like passwords) are transfered unencrypted!' . $redir, 'Not secure connection');
- }
- break;
-}
-
-// Should we show information?
-if ($show_info) {
- $servers = 'none';
- $servers_text = 'Servers';
- if (count($configuration['Servers']) == 0) {
- message('warning', 'No servers defined, you probably want to add one.');
- } else {
- $servers = '';
- $servers_text = 'Servers (' . count($configuration['Servers']) . ')';
-
- $sep = '';
- foreach ($configuration['Servers'] as $key => $val) {
- $servers .= $sep;
- $sep = ', ';
- $servers .= get_server_name($val, $key);
- }
- unset($sep);
- }
- show_overview('Current configuration overview',
- array(
- array($servers_text, $servers),
- array('SQL files upload', empty($configuration['UploadDir']) ? 'disabled' : 'enabled'),
- array('Exported files on server', empty($configuration['SaveDir']) ? 'disabled' : 'enabled'),
- array('Charset conversion', isset($configuration['AllowAnywhereRecoding']) && $configuration['AllowAnywhereRecoding'] ? 'enabled' : 'disabled'),
- ));
- unset($servers_text, $servers);
-}
-
-// And finally display all actions:
-echo '<p>Available global actions (please note that these will delete any changes you could have done above):</p>';
-
-echo '<fieldset class="toolbar"><legend>Servers</legend>' . "\n";
-echo get_action('addserver', 'Add');
-$servers = get_server_selection($configuration);
-if (!empty($servers)) {
- echo get_action('servers', 'List');
- echo get_action('deleteserver', 'Delete', $servers);
- echo get_action('editserver', 'Edit', $servers);
-}
-echo '</fieldset>' . "\n\n";
-
-echo '<fieldset class="toolbar"><legend>Layout</legend>' . "\n";
-echo get_action('lay_navigation', 'Navigation frame');
-echo get_action('lay_tabs', 'Tabs');
-echo get_action('lay_icons', 'Icons');
-echo get_action('lay_browse', 'Browsing');
-echo get_action('lay_edit', 'Editing');
-echo get_action('lay_window', 'Query window');
-echo '</fieldset>' . "\n\n";
-
-echo '<fieldset class="toolbar"><legend>Features</legend>' . "\n";
-echo get_action('feat_upload', 'Upload/Download');
-echo get_action('feat_security', 'Security');
-echo get_action('feat_manual', 'MySQL manual');
-echo get_action('feat_charset', 'Charsets');
-echo get_action('feat_extensions', 'Extensions');
-echo get_action('feat_relation', 'MIME/Relation/History');
-echo '</fieldset>' . "\n\n";
-
-echo '<fieldset class="toolbar"><legend>Configuration</legend>' . "\n";
-echo get_action('main', 'Overview');
-echo get_action('display', 'Display');
-echo get_action('download', 'Download');
-echo get_action('save', 'Save', '', !$fail_dir);
-echo get_action('load', 'Load', '', !$fail_dir);
-echo get_action('clear', 'Clear');
-echo get_action('seteol', 'Change end of line',
- '<select name="neweol">' .
- '<option value="unix" ' . ($eoltype == 'unix' ? ' selected="selected"' : '') . '>UNIX/Linux (\\n)</option>' .
- '<option value="dos" ' . ($eoltype == 'dos' ? ' selected="selected"' : '') . '>DOS/Windows (\\r\\n)</option>' .
- '<option value="mac" ' . ($eoltype == 'mac' ? ' selected="selected"' : '') . '>Macintosh (\\r)</option>' . '
- </select>');
-echo '</fieldset>' . "\n\n";
-
-echo '<fieldset class="toolbar"><legend>Other actions</legend>' . "\n";
-echo get_action('versioncheck', 'Check for latest version');
-echo get_url_action('http://www.phpmyadmin.net/', 'Go to homepage');
-echo get_url_action('https://sourceforge.net/donate/index.php', 'Donate to phpMyAdmin', array('group_id' => 23067));
-echo '</fieldset>' . "\n\n";
-
-footer();
-?>
diff --git a/scripts/signon.php b/scripts/signon.php
deleted file mode 100644
index 6e7b61912b..0000000000
--- a/scripts/signon.php
+++ /dev/null
@@ -1,56 +0,0 @@
-<?php
-/* vim: set expandtab sw=4 ts=4 sts=4: */
-/**
- * Single signon for phpMyAdmin
- *
- * This is just example how to use single signon with phpMyAdmin, it is
- * not intended to be perfect code and look, only shows how you can
- * integrate this functionality in your application.
- *
- * @version $Id$
- * @package phpMyAdmin
- * @subpacke Example
- */
-
-/* Was data posted? */
-if (isset($_POST['user'])) {
- /* Need to have cookie visible from parent directory */
- session_set_cookie_params(0, '/', '', 0);
- /* Create signon session */
- $session_name = 'SignonSession';
- session_name($session_name);
- session_start();
- /* Store there credentials */
- $_SESSION['PMA_single_signon_user'] = $_POST['user'];
- $_SESSION['PMA_single_signon_password'] = $_POST['password'];
- $_SESSION['PMA_single_signon_host'] = $_POST['host'];
- $id = session_id();
- /* Close that session */
- session_write_close();
- /* Redirect to phpMyAdmin (should use absolute URL here!) */
- header('Location: ../index.php');
-} else {
- /* Show simple form */
- header('Content-Type: text/html; charset=utf-8');
- echo '<?xml version="1.0" encoding="utf-8"?>' . "\n";
- ?>
-<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
-<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr">
-<head>
- <link rel="icon" href="../favicon.ico" type="image/x-icon" />
- <link rel="shortcut icon" href="../favicon.ico" type="image/x-icon" />
- <title>phpMyAdmin single signon example</title>
-<html>
-<body>
-<form action="signon.php" method="post">
-Username: <input type="text" name="user" /><br />
-Password: <input type="password" name="password" /><br />
-Host: (will use the one from config.inc.php by default) <input type="text" name="host" /><br />
-<input type="submit" />
-</form>
-</body>
-</html>
-<?php
-}
-?>
diff --git a/scripts/upgrade.pl b/scripts/upgrade.pl
deleted file mode 100755
index c9e625e16c..0000000000
--- a/scripts/upgrade.pl
+++ /dev/null
@@ -1,223 +0,0 @@
-#!/usr/bin/perl
-#
-# $Id$
-#
-# upgrade.pl - automatic phpmyadmin upgrader
-#
-#
-# 2005-05-08, swix@users.sourceforge.net:
-# - created script
-#
-# 2005-10-29 swix@users.sourceforge.net:
-# - some fixes & improvements
-#
-
-use strict;
-my $source_url = "http://phpmyadmin.net/home_page/version.php";
-
-
-#
-# usage
-#
-
-if (!$ARGV[0] || (($ARGV[0] eq "--force") && !$ARGV[1])) {
- print "\n";
- print "usage: $0 [--force] <target_directory>\n\n";
- print " The location specified by <target_directory> will be backed up and replaced\n";
- print " by the latest stable version of phpMyAdmin.\n";
- print " Your config.inc.php file will be preserved.\n\n";
- exit(0);
-}
-
-my $forced;
-my $targetdirectory;
-
-if ($ARGV[0] eq "--force") {
- $forced = 1;
- $targetdirectory = $ARGV[1];
-} else {
- $forced = 0;
- $targetdirectory = $ARGV[0];
-}
-
-if ($targetdirectory =~ /^(.*)\/$/) {
- # remove trailing slash, if any
- $targetdirectory = $1;
-}
-
-if (!-d $targetdirectory) {
- print "error: target directory ($targetdirectory) does not exists\n";
- exit(0);
-}
-
-if (!-f "$targetdirectory/config.inc.php") {
- print "error: target directory doesn't seem to contain phpMyAdmin\n";
- exit(0);
-}
-
-
-#
-# get current release information
-#
-
-my $version;
-my $filename;
-my $directory;
-my $releasedate;
-my @urls;
-my @today;
-my $installedversion;
-
-if (open(LATEST, "wget -o /dev/null -O - $source_url|")) {
-
- $version = <LATEST>; chomp($version);
- $releasedate = <LATEST>; chomp($releasedate);
- $filename = "phpMyAdmin-" . $version . "-all-languages.tar.gz";
- $directory = "phpMyAdmin-" . $version . "-all-languages";
-
- my $i = 0;
-
- while (my $line = <LATEST>) {
- chomp($line);
- if ($line =~ /http/) {
- $urls[$i++] = $line;
- }
- }
-
- close(LATEST);
-
-} else {
-
- print "error: open of $source_url failed.\n";
- exit(0);
-
-}
-
-
-if (-d $directory) {
- print "error: target directory ($directory) already exists, exiting\n";
- exit(0);
-}
-
-#
-# check the installed version
-#
-
-if (open(DEFINES, $targetdirectory .'/libraries/Config.class.php')) {
- my $versionStatus = 0;
- $installedversion = "unknownversion";
-
- while (my $line = <DEFINES>) {
-
- next unless $line =~ /'PMA_VERSION',\ '(.*)?'\);$/;
- $installedversion = $1;
-
- # take care of "pl", "rc" and "dev": dev < rc < pl
-
- my $converted_installedversion = $installedversion;
- $converted_installedversion =~ s/dev/aaa/g;
- $converted_installedversion =~ s/rc/bbb/g;
- $converted_installedversion =~ s/pl/ccc/g;
-
- my $converted_version = $version;
- $converted_version =~ s/dev/aaa/g;
- $converted_version =~ s/rc/bbb/g;
- $converted_version =~ s/pl/ccc/g;
-
- if ($converted_installedversion gt $converted_version && !$forced) {
- print "Local version ($installedversion) newer than latest stable release ($version), not updating. (use \"--force\")\n";
- exit(0);
-
- } elsif ($installedversion eq $version && !$forced) {
- print "Local version ($version) already up to date, not updating (you can use \"--force\")\n";
- exit(0);
-
- } else {
- $versionStatus = 1;
- }
- }
- if (!$versionStatus && !$forced) {
- print "Old version could not be identified, not updating (use \"--force\" if you are sure) \n";
- exit(0);
- }
-}
-
-#
-# ask for confirmation
-#
-
-print "\n";
-print "phpMyAdmin upgrade summary:\n";
-print "---------------------------\n";
-print " phpMyAdmin Path: $targetdirectory\n";
-print " Installed version: $installedversion\n";
-print " Upgraded version: $version\n\n";
-print "Proceed with upgrade? [Y/n] ";
-my $kbdinput = <STDIN>; chomp($kbdinput);
-if (lc(substr($kbdinput,0,1)) ne "y" && length($kbdinput) >= 1) {
- print "Aborting.\n";
- exit(0);
-} else {
- print "Proceeding...\n\n";
-}
-
-
-#
-# get file
-#
-
-if (!-f $filename) {
-
- print "getting phpMyAdmin $version\n";
- foreach my $url (@urls) {
-
- print "trying $url...\n";
- system("wget -o /dev/null $url");
- if (-f $filename) {
- print "-> ok\n";
- last;
- }
- }
-} else {
- print "already got $filename, not downloading\n";
-}
-
-
-if (!-f $filename) {
- print "error: $filename download failed\n";
- exit(0);
-}
-
-
-
-#
-# setup
-#
-
-print "installing...\n";
-
-system("tar xzf $filename");
-if (!$directory) {
- print "error: $directory still not exists after untar...\n";
- exit(0);
-}
-
-@today = localtime(time); $today[4]++; $today[5]+=1900;
-my $timestamp = sprintf("%04d%02d%02d%02d%02d", $today[5], $today[4], $today[3], $today[2], $today[1]);
-
-my $backupdir = $targetdirectory . "-" . $timestamp . "-" . $installedversion;
-print "- backup directory: $backupdir\n";
-
-system("cp $directory/config.inc.php $directory/config.inc-dist.php");
-print "- original distribution config.inc.php renamed to config.inc-dist.php\n";
-
-system("cp $targetdirectory/config.inc.php $directory/config.inc.php");
-print "- previous config.inc.php copied to the new setup\n";
-
-system("mv $targetdirectory $backupdir");
-system("mv $directory $targetdirectory");
-system("rm $filename");
-
-print "\ndone! phpMyAdmin $version installed in $targetdirectory\n";
-print "backup of your old installation in $backupdir\n";
-print "Enjoy! :-)\n\n";
diff --git a/scripts/upgrade_tables_mysql_4_1_2+.sql b/scripts/upgrade_tables_mysql_4_1_2+.sql
deleted file mode 100644
index 3ab0e7401a..0000000000
--- a/scripts/upgrade_tables_mysql_4_1_2+.sql
+++ /dev/null
@@ -1,164 +0,0 @@
--- -------------------------------------------------------------
--- SQL Commands to upgrade pmadb for normal phpMyAdmin operation
--- with MySQL 4.1.2 and above.
---
--- This file is meant for use with MySQL 4.1.2 and above!
--- For older MySQL releases, please use create_tables.sql
---
--- If you are running one MySQL 4.1.0 or 4.1.1, please create the tables using
--- create_tables.sql, then use this script.
---
--- Please don't forget to set up the tablenames in config.inc.php
---
--- $Id$
-
--- --------------------------------------------------------
-
---
--- Database : `phpmyadmin`
---
-ALTER DATABASE `phpmyadmin`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-USE phpmyadmin;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_bookmark`
---
-ALTER TABLE `pma_bookmark`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_bookmark`
- CHANGE `dbase` `dbase` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_bookmark`
- CHANGE `user` `user` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_bookmark`
- CHANGE `label` `label` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
-ALTER TABLE `pma_bookmark`
- CHANGE `query` `query` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_column_info`
---
-
-ALTER TABLE `pma_column_info`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_column_info`
- CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_column_info`
- CHANGE `table_name` `table_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_column_info`
- CHANGE `column_name` `column_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_column_info`
- CHANGE `comment` `comment` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
-ALTER TABLE `pma_column_info`
- CHANGE `mimetype` `mimetype` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';
-ALTER TABLE `pma_column_info`
- CHANGE `transformation` `transformation` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_column_info`
- CHANGE `transformation_options` `transformation_options` VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_history`
---
-ALTER TABLE `pma_history`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_history`
- CHANGE `username` `username` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_history`
- CHANGE `db` `db` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_history`
- CHANGE `table` `table` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_history`
- CHANGE `sqlquery` `sqlquery` TEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_pdf_pages`
---
-
-ALTER TABLE `pma_pdf_pages`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_pdf_pages`
- CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_pdf_pages`
- CHANGE `page_descr` `page_descr` VARCHAR(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_relation`
---
-ALTER TABLE `pma_relation`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_relation`
- CHANGE `master_db` `master_db` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_relation`
- CHANGE `master_table` `master_table` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_relation`
- CHANGE `master_field` `master_field` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_relation`
- CHANGE `foreign_db` `foreign_db` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_relation`
- CHANGE `foreign_table` `foreign_table` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_relation`
- CHANGE `foreign_field` `foreign_field` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_table_coords`
---
-
-ALTER TABLE `pma_table_coords`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_table_coords`
- CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_table_coords`
- CHANGE `table_name` `table_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_table_info`
---
-
-ALTER TABLE `pma_table_info`
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-
-ALTER TABLE `pma_table_info`
- CHANGE `db_name` `db_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_table_info`
- CHANGE `table_name` `table_name` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-ALTER TABLE `pma_table_info`
- CHANGE `display_field` `display_field` VARCHAR(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
-
--- --------------------------------------------------------
-
---
--- Table structure for table `pma_designer_coords`
---
-
-CREATE TABLE IF NOT EXISTS `pma_designer_coords` (
- `db_name` varchar(64) NOT NULL default '',
- `table_name` varchar(64) NOT NULL default '',
- `x` INT,
- `y` INT,
- `v` TINYINT,
- `h` TINYINT,
- PRIMARY KEY (`db_name`,`table_name`)
-)
- ENGINE=MyISAM COMMENT='Table coordinates for Designer'
- DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
-