Hi,
I have been setting up myphpadmin following the guie from
http://internetmaster.com/installtutorial/
When I try and run the myphpadmin bit I get the message:-
"Warning: Cannot modify header information - headers already sent by (output started at c:\web\phpmyadmin\config.inc.php:664) in c:\web\phpmyadmin\index.php on line 45"
Can anyone tell me how to fix this?
Ta
Rapier503
myphpadminsetup
Moderator: General Moderators
-
d3ad1ysp0rk
- Forum Donator
- Posts: 1661
- Joined: Mon Oct 20, 2003 8:31 pm
- Location: Maine, USA
http://www.devnetwork.net/forums/viewtopic.php?t=1157
everything's explained there
*I just noticed your problem is with MODIFYING header info, the link i provided is on ADDING header information.. it's a good read anyways, and it may be the same problem..*
everything's explained there
*I just noticed your problem is with MODIFYING header info, the link i provided is on ADDING header information.. it's a good read anyways, and it may be the same problem..*
Last edited by d3ad1ysp0rk on Wed Oct 29, 2003 6:22 pm, edited 1 time in total.
Index.php line 45
index.php
config.inc.php line 664
Hmm..line664 is a blank link
config.inc.php
Hope someone can advise,
Cheers,
Rapier503
Code: Select all
header('Content-Type: text/html; charset=' . $GLOBALSї'charset']);Code: Select all
<?php
/* $Id: index.php,v 1.52 2003/05/29 14:07:37 garvinhicking Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* Gets core libraries and defines some variables
*/
require('./libraries/grab_globals.lib.php');
require('./libraries/common.lib.php');
// Gets the default font sizes
PMA_setFontSizes();
// Gets the host name
// loic1 - 2001/25/11: use the new globals arrays defined with php 4.1+
if (empty($HTTP_HOST)) {
if (!empty($_ENV) && isset($_ENVї'HTTP_HOST'])) {
$HTTP_HOST = $_ENVї'HTTP_HOST'];
}
else if (!empty($HTTP_ENV_VARS) && isset($HTTP_ENV_VARSї'HTTP_HOST'])) {
$HTTP_HOST = $HTTP_ENV_VARSї'HTTP_HOST'];
}
else if (@getenv('HTTP_HOST')) {
$HTTP_HOST = getenv('HTTP_HOST');
}
else {
$HTTP_HOST = '';
}
}
/**
* Defines the frameset
*/
// loic1: If left light mode -> urldecode the db name
if (isset($lightm_db)) {
// no longer urlencoded because of html entities in the db name
// $db = urldecode($lightm_db);
$db = $lightm_db;
unset($lightm_db);
}
$url_query = PMA_generate_common_url(isset($db) ? $db : '');
header('Content-Type: text/html; charset=' . $GLOBALSї'charset']);
require('./libraries/relation.lib.php');
$cfgRelation = PMA_getRelationsParam();
if ($cfgї'QueryHistoryDB'] && $cfgRelationї'historywork']) {
PMA_purgeHistory($cfgї'Server']ї'user']);
}
$phpmain_hash = md5($cfgї'PmaAbsoluteUri']);
$phpmain_hash_js = time();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Frameset//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-frameset.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $available_languagesї$lang]ї2]; ?>" lang="<?php echo $available_languagesї$lang]ї2]; ?>" dir="<?php echo $text_dir; ?>">
<head>
<title>phpMyAdmin <?php echo PMA_VERSION; ?> - <?php echo $HTTP_HOST; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo $charset; ?>" />
<link rel="stylesheet" type="text/css" href="./css/phpmyadmin.css.php?lang=<?php echo $lang; ?>&js_frame=right" />
</head>
<?php
if ($cfgї'QueryFrame']) {
if ($cfgї'QueryFrameJS']) {
echo '<script type="text/javascript">' . "\n";
echo '<!--' . "\n";
echo ' document.writeln(''<frameset cols="' . $cfgї'LeftWidth'] . ',*" rows="*" border="1" frameborder="1" framespacing="0">'');' . "\n";
echo ' document.writeln('' <frameset rows="*, 50" framespacing="0" frameborder="0" border="0">'');' . "\n";
echo ' document.writeln('' <frame src="left.php?' . $url_query . '&hash=' . $phpmain_hash . $phpmain_hash_js . '" name="nav" frameborder="0" />'');' . "\n";
echo ' document.writeln('' <frame src="queryframe.php?' . $url_query . '&hash=' . $phpmain_hash . $phpmain_hash_js . '" name="queryframe" frameborder="0" />'');' . "\n";
echo ' document.writeln('' </frameset>'');' . "\n";
echo ' document.writeln('' <frame src="' . (empty($db) ? 'main.php' : $cfgї'DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . $phpmain_hash_js . '" border="0" frameborder="0" />'');' . "\n";
echo ' document.writeln('' <noframes>'');' . "\n";
echo ' document.writeln('' <body bgcolor="#FFFFFF">'');' . "\n";
echo ' document.writeln('' <p>' . str_replace("'", "''", $strNoFrames) . '</p>'');' . "\n";
echo ' document.writeln('' </body>'');' . "\n";
echo ' document.writeln('' </noframes>'');' . "\n";
echo ' document.writeln(''</frameset>'');' . "\n";
echo '//-->' . "\n";
echo '</script>' . "\n";
echo "\n";
echo '<noscript>' . "\n";
}
echo '<frameset cols="' . $cfgї'LeftWidth'] . ',*" rows="*" border="1" frameborder="1" framespacing="0">' . "\n";
echo ' <frameset rows="*, 50" framespacing="0" frameborder="0" border="0">' . "\n";
echo ' <frame src="left.php?' . $url_query . '&hash=' . $phpmain_hash . '" name="nav" frameborder="0" />' . "\n";
echo ' <frame src="queryframe.php?' . $url_query . '&hash=' . $phpmain_hash . '" name="queryframe" frameborder="0" />' . "\n";
echo ' </frameset>' . "\n";
echo ' <frame src="' . (empty($db) ? 'main.php' : $cfgї'DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . '" frameborder="0" />' . "\n";
} else {
echo '<frameset cols="' . $cfgї'LeftWidth'] . ',*" rows="*" border="1" frameborder="1" framespacing="0">' . "\n";
echo ' <frame src="left.php?' . $url_query . '&hash=' . $phpmain_hash . '" name="nav" frameborder="0" />' . "\n";
echo ' <frame src="' . (empty($db) ? 'main.php' : $cfgї'DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . '" frameborder="1" />' . "\n";
}
?>
<noframes>
<body bgcolor="#FFFFFF">
<p><?php echo $strNoFrames; ?></p>
</body>
</noframes>
</frameset>
<?php
if ($cfgї'QueryFrame'] && $cfgї'QueryFrameJS']) {
echo '</noscript>' . "\n";
}
?>
</html>config.inc.php line 664
Hmm..line664 is a blank link
config.inc.php
Code: Select all
<?php
/* $Id: config.inc.php,v 1.182 2003/06/01 21:50:19 nijel Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:
/**
* phpMyAdmin Configuration File
*
* All directives are explained in Documentation.html
*/
/**
* Sets the php error reporting - Please do not change this line!
*/
if (!isset($old_error_reporting)) {
error_reporting(E_ALL);
@ini_set('display_errors', '1');
}
/**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/
*
* It must contain characters that are valid for a URL, and the path is
* case sensitive on some Web servers, for example Unix-based servers.
*
* In most cases you can leave this variable empty, as the correct value
* will be detected automatically. However, we recommend that you do
* test to see that the auto-detection code works in your system. A good
* test is to browse a table, then edit a row and save it. There will be
* an error message if phpMyAdmin cannot auto-detect the correct value.
*
* If the auto-detection code does work properly, you can set to TRUE the
* $cfgї'PmaAbsoluteUri_DisableWarning'] variable below.
*/
$cfgї'PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
/**
* Disable the default warning about $cfgї'PmaAbsoluteUri'] not being set
* You should use this if and ONLY if the PmaAbsoluteUri auto-detection
* works perfectly.
*/
$cfgї'PmaAbsoluteUri_DisableWarning'] = FALSE;
/**
* Disable the default warning that is displayed on the DB Details Structure page if
* any of the required Tables for the relationfeatures could not be found
*/
$cfgї'PmaNoRelation_DisableWarning'] = FALSE;
/**
* Server(s) configuration
*/
$i = 0;
// The $cfgї'Servers'] array starts with $cfgї'Servers']ї1]. Do not use $cfgї'Servers']ї0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfgї'Servers']ї$i]ї'host'] = 'localhost'; // MySQL hostname
$cfgї'Servers']ї$i]ї'port'] = '3306'; // MySQL port - leave blank for default port
$cfgї'Servers']ї$i]ї'socket'] = ''; // Path to the socket - leave blank for default socket
$cfgї'Servers']ї$i]ї'connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfgї'Servers']ї$i]ї'compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfgї'Servers']ї$i]ї'controluser'] = ''; // MySQL control user settings
// (this user must have read-only
$cfgї'Servers']ї$i]ї'controlpass'] = ''; // access to the "mysql/user"
// and "mysql/db" tables)
$cfgї'Servers']ї$i]ї'auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfgї'Servers']ї$i]ї'user'] = 'root'; // MySQL user
$cfgї'Servers']ї$i]ї'password'] = '@@@@@@@@'; // MySQL password (only needed
// with 'config' auth_type)
$cfgї'Servers']ї$i]ї'only_db'] = ''; // If set to a db-name, only
// this db is displayed
// at left frame
// It may also be an array
// of db-names
$cfgї'Servers']ї$i]ї'verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgї'Servers']ї$i]ї'pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features
// (see scripts/create_tables.sql)
// - leave blank for no support
// DEFAULT: 'phpmyadmin'
$cfgї'Servers']ї$i]ї'bookmarktable'] = ''; // Bookmark table
// - leave blank for no bookmark support
// DEFAULT: 'PMA_bookmark'
$cfgї'Servers']ї$i]ї'relation'] = ''; // table to describe the relation between links (see doc)
// - leave blank for no relation-links support
// DEFAULT: 'PMA_relation'
$cfgї'Servers']ї$i]ї'table_info'] = ''; // table to describe the display fields
// - leave blank for no display fields support
// DEFAULT: 'PMA_table_info'
$cfgї'Servers']ї$i]ї'table_coords'] = ''; // table to describe the tables position for the PDF schema
// - leave blank for no PDF schema support
// DEFAULT: 'PMA_table_coords'
$cfgї'Servers']ї$i]ї'pdf_pages'] = ''; // table to describe pages of relationpdf
// - leave blank if you don't want to use this
// DEFAULT: 'PMA_pdf_pages'
$cfgї'Servers']ї$i]ї'column_info'] = ''; // table to store column information
// - leave blank for no column comments/mime types
// DEFAULT: 'PMA_column_info'
$cfgї'Servers']ї$i]ї'history'] = ''; // table to store SQL history
// - leave blank for no SQL query history
// DEFAULT: 'PMA_history'
$cfgї'Servers']ї$i]ї'verbose_check'] = TRUE; // set to FALSE if you know that your PMA_* tables
// are up to date. This prevents compatibility
// checks and thereby increases performance.
$cfgї'Servers']ї$i]ї'AllowDeny']ї'order'] // Host authentication order, leave blank to not use
= '';
$cfgї'Servers']ї$i]ї'AllowDeny']ї'rules'] // Host authentication rules, leave blank for defaults
= array();
$i++;
$cfgї'Servers']ї$i]ї'host'] = '';
$cfgї'Servers']ї$i]ї'port'] = '';
$cfgї'Servers']ї$i]ї'socket'] = '';
$cfgї'Servers']ї$i]ї'connect_type'] = 'tcp';
$cfgї'Servers']ї$i]ї'compress'] = FALSE;
$cfgї'Servers']ї$i]ї'controluser'] = '';
$cfgї'Servers']ї$i]ї'controlpass'] = '';
$cfgї'Servers']ї$i]ї'auth_type'] = 'config';
$cfgї'Servers']ї$i]ї'user'] = 'root';
$cfgї'Servers']ї$i]ї'password'] = '';
$cfgї'Servers']ї$i]ї'only_db'] = '';
$cfgї'Servers']ї$i]ї'verbose'] = '';
$cfgї'Servers']ї$i]ї'pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$cfgї'Servers']ї$i]ї'bookmarktable'] = ''; // 'PMA_bookmark'
$cfgї'Servers']ї$i]ї'relation'] = ''; // 'PMA_relation'
$cfgї'Servers']ї$i]ї'table_info'] = ''; // 'PMA_table_info'
$cfgї'Servers']ї$i]ї'table_coords'] = ''; // 'PMA_table_coords'
$cfgї'Servers']ї$i]ї'pdf_pages'] = ''; // 'PMA_pdf_page'
$cfgї'Servers']ї$i]ї'column_info'] = ''; // 'PMA_column_info'
$cfgї'Servers']ї$i]ї'history'] = ''; // 'PMA_history'
$cfgї'Servers']ї$i]ї'verbose_check'] = TRUE;
$cfgї'Servers']ї$i]ї'AllowDeny']ї'order']
= '';
$cfgї'Servers']ї$i]ї'AllowDeny']ї'rules']
= array();
$i++;
$cfgї'Servers']ї$i]ї'host'] = '';
$cfgї'Servers']ї$i]ї'port'] = '';
$cfgї'Servers']ї$i]ї'socket'] = '';
$cfgї'Servers']ї$i]ї'connect_type'] = 'tcp';
$cfgї'Servers']ї$i]ї'compress'] = FALSE;
$cfgї'Servers']ї$i]ї'controluser'] = '';
$cfgї'Servers']ї$i]ї'controlpass'] = '';
$cfgї'Servers']ї$i]ї'auth_type'] = 'config';
$cfgї'Servers']ї$i]ї'user'] = 'root';
$cfgї'Servers']ї$i]ї'password'] = '';
$cfgї'Servers']ї$i]ї'only_db'] = '';
$cfgї'Servers']ї$i]ї'verbose'] = '';
$cfgї'Servers']ї$i]ї'pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$cfgї'Servers']ї$i]ї'bookmarktable'] = ''; // 'PMA_bookmark'
$cfgї'Servers']ї$i]ї'relation'] = ''; // 'PMA_relation'
$cfgї'Servers']ї$i]ї'table_info'] = ''; // 'PMA_table_info'
$cfgї'Servers']ї$i]ї'table_coords'] = ''; // 'PMA_table_coords'
$cfgї'Servers']ї$i]ї'pdf_pages'] = ''; // 'PMA_pdf_page'
$cfgї'Servers']ї$i]ї'column_info'] = ''; // 'PMA_column_info'
$cfgї'Servers']ї$i]ї'history'] = ''; // 'PMA_history'
$cfgї'Servers']ї$i]ї'verbose_check'] = TRUE;
$cfgї'Servers']ї$i]ї'AllowDeny']ї'order']
= '';
$cfgї'Servers']ї$i]ї'AllowDeny']ї'rules']
= array();
// If you have more than one server configured, you can set $cfgї'ServerDefault']
// to any one of them to autoconnect to that server when phpMyAdmin is started,
// or set it to 0 to be given a list of servers without logging in
// If you have only one server configured, $cfgї'ServerDefault'] *MUST* be
// set to that server.
$cfgї'ServerDefault'] = 1; // Default server (0 = no default server)
$cfgї'Server'] = '';
unset($cfgї'Servers']ї0]);
/**
* Other core phpMyAdmin settings
*/
$cfgї'OBGzip'] = TRUE; // use GZIP output buffering if possible
$cfgї'PersistentConnections'] = FALSE; // use persistent connections to MySQL database
$cfgї'ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit)
$cfgї'SkipLockedTables'] = FALSE; // mark used tables, make possible to show
// locked tables (since MySQL 3.23.30)
$cfgї'ShowSQL'] = TRUE; // show SQL queries as run
$cfgї'AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users
$cfgї'Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE'
$cfgї'LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not
$cfgї'UseDbSearch'] = TRUE; // whether to enable the "database search" feature
// or not
// Left frame setup
$cfgї'LeftFrameLight'] = TRUE; // use a select-based menu and display only the
// current tables in the left frame.
$cfgї'LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes
// to split tables into multiple categories
$cfgї'LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting
// up tables by the above Separator
$cfgї'ShowTooltip'] = TRUE; // display table comment as tooltip in left frame
$cfgї'ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments
$cfgї'ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of
// table/db names
$cfgї'LeftDisplayLogo'] = TRUE; // display logo at top of left frame
// In the main frame, at startup...
$cfgї'ShowStats'] = TRUE; // allow to display statistics and space usage in
// the pages about database details and table
// properties
$cfgї'ShowMysqlInfo'] = FALSE; // whether to display the "MySQL runtime
$cfgї'ShowMysqlVars'] = FALSE; // information", "MySQL system variables", "PHP
$cfgї'ShowPhpInfo'] = FALSE; // information" and "change password" links for
$cfgї'ShowChgPassword'] = FALSE; // simple users or not
$cfgї'SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty)
// In browse mode...
$cfgї'ShowBlob'] = FALSE; // display blob field contents
$cfgї'NavigationBarIconic'] = TRUE; // do not display text inside navigation bar buttons
$cfgї'ShowAll'] = FALSE; // allows to display all the rows
$cfgї'MaxRows'] = 30; // maximum number of rows to display
$cfgї'Order'] = 'ASC'; // default for 'ORDER BY' clause (valid
// values are 'ASC', 'DESC' or 'SMART' -ie
// descending order for fields of type
// TIME, DATE, DATETIME & TIMESTAMP,
// ascending order else-)
// In edit mode...
$cfgї'ProtectBinary'] = 'blob'; // disallow editing of binary fields
// valid values are:
// FALSE allow editing
// 'blob' allow editing except for BLOB fields
// 'all' disallow editing
$cfgї'ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode
$cfgї'CharEditing'] = 'input';
// Which editor should be used for CHAR/VARCHAR fields:
// input - allows limiting of input length
// textarea - allows newlines in fields
// For the export features...
$cfgї'ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip
$cfgї'GZipDump'] = TRUE; // compression for
$cfgї'BZipDump'] = TRUE; // dump files
// Tabs display settings
$cfgї'LightTabs'] = FALSE; // use graphically less intense menu tabs
$cfgї'DefaultTabServer'] = 'main.php';
// Possible values:
// 'main.php' = the welcome page
// (recommended for multiuser setups)
// 'server_databases.php' = list of databases
// 'server_status.php' = runtime information
// 'server_variables.php' = MySQL server variables
// 'server_privileges.php' = user management
// 'server_processlist.php' = process list
$cfgї'DefaultTabDatabase'] = 'db_details_structure.php';
// Possible values:
// 'db_details_structure.php' = tables list
// 'db_details.php' = sql form
// 'db_search.php' = search query
$cfgї'DefaultTabTable'] = 'tbl_properties_structure.php';
// Possible values:
// 'tbl_properties_structure.php' = fields list
// 'tbl_properties.php' = sql form
// 'tbl_select.php = select page
// 'tbl_change.php = insert row page
/**
* Link to the official MySQL documentation.
* Be sure to include no trailing slash on the path.
* See http://www.mysql.com/documentation/index.html for more information
* about MySQL manuals and their types.
*/
$cfgї'MySQLManualBase'] = 'http://www.mysql.com/doc/en';
/**
* Type of MySQL documentation:
* old - old style used in phpMyAdmin 2.3.0 and sooner
* searchable - "Searchable, with user comments"
* chapters - "HTML, one page per chapter"
* big - "HTML, all on one page"
* none - do not show documentation links
*/
$cfgї'MySQLManualType'] = 'searchable';
/**
* Language and charset conversion settings
*/
// Default language to use, if not browser-defined or user-defined
$cfgї'DefaultLang'] = 'en-iso-8859-1';
// Force: always use this language - must be defined in
// libraries/select_lang.lib.php
// $cfgї'Lang'] = 'en-iso-8859-1';
// Default charset to use for recoding of MySQL queries, does not take
// any effect when charsets recoding is switched off by
// $cfgї'AllowAnywhereRecoding'] or in language file
// (see $cfgї'AvailableCharsets'] to possible choices, you can add your own)
$cfgї'DefaultCharset'] = 'iso-8859-1';
// Allow charset recoding of MySQL queries, must be also enabled in language
// file to make harder using other language files than unicode.
// Default value is FALSE to avoid problems on servers without the iconv
// extension and where dl() is not supported
$cfgї'AllowAnywhereRecoding'] = FALSE;
// You can select here which functions will be used for charset conversion.
// Possible values are:
// auto - automatically use available one (first is tested iconv, then
// recode)
// iconv - use iconv or libiconv functions
// recode - use recode_string function
$cfgї'RecodingEngine'] = 'auto';
// Specify some parameters for iconv used in charset conversion. See iconv
// documentation for details:
// http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
$cfgї'IconvExtraParams'] = '';
// Available charsets for MySQL conversion. currently contains all which could
// be found in lang/* files and few more.
// Charsets will be shown in same order as here listed, so if you frequently
// use some of these move them to the top.
$cfgї'AvailableCharsets'] = array(
'iso-8859-1',
'iso-8859-2',
'iso-8859-3',
'iso-8859-4',
'iso-8859-5',
'iso-8859-6',
'iso-8859-7',
'iso-8859-8',
'iso-8859-9',
'iso-8859-10',
'iso-8859-11',
'iso-8859-12',
'iso-8859-13',
'iso-8859-14',
'iso-8859-15',
'windows-1250',
'windows-1251',
'windows-1252',
'windows-1257',
'koi8-r',
'big5',
'gb2312',
'utf-8',
'utf-7',
'x-user-defined',
'euc-jp',
'ks_c_5601-1987',
'tis-620',
'SHIFT_JIS'
);
// Loads language file
require('./libraries/select_lang.lib.php');
/**
* Customization & design
*/
$cfgї'LeftWidth'] = 150; // left frame width
$cfgї'LeftBgColor'] = '#D0DCE0'; // background color for the left frame
$cfgї'RightBgColor'] = '#F5F5F5'; // background color for the right frame
$cfgї'RightBgImage'] = ''; // path to a background image for the right frame
// (leave blank for no background image)
$cfgї'LeftPointerColor'] = '#CCFFCC'; // color of the pointer in left frame
// (blank for no pointer)
$cfgї'Border'] = 0; // border width on tables
$cfgї'ThBgcolor'] = '#D3DCE3'; // table header row colour
$cfgї'BgcolorOne'] = '#CCCCCC'; // table data row colour
$cfgї'BgcolorTwo'] = '#DDDDDD'; // table data row colour, alternate
$cfgї'BrowsePointerColor'] = '#CCFFCC'; // color of the pointer in browse mode
// (blank for no pointer)
$cfgї'BrowseMarkerColor'] = '#FFCC99'; // color of the marker (visually marks row
// by clicking on it) in browse mode
// (blank for no marker)
$cfgї'TextareaCols'] = 40; // textarea size (columns) in edit mode
// (this value will be emphasized (*2) for sql
// query textareas and (*1.25) for query window)
$cfgї'TextareaRows'] = 7; // textarea size (rows) in edit mode
$cfgї'LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields
$cfgї'TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox
$cfgї'CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR
$cfgї'CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR
$cfgї'CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing?
$cfgї'LimitChars'] = 50; // For text and blobs, max field data length in browse mode
$cfgї'ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse
// (or at the top with vertical browse)
$cfgї'ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse
// (or at the bottom with vertical browse)
$cfgї'DefaultDisplay'] = 'horizontal'; // default display direction
// (horizontal|vertical|horizontalflipped)
$cfgї'DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/
// creating columns (tbl_properties)
// (horizontal|vertical)
$cfgї'HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake)
// NOTE: CSS only works in IE browsers!
$cfgї'ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode.
$cfgї'ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode.
$cfgї'RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate)
$cfgї'QueryFrame'] = TRUE; // displays a new frame where a link to a querybox is always displayed.
$cfgї'QueryFrameJS'] = TRUE; // whether to use JavaScript functions for opening a new window for SQL commands.
// if set to 'false', the target of the querybox is always the right frame.
$cfgї'QueryFrameDebug'] = FALSE; // display JS debugging link (DEVELOPERS only)
$cfgї'QueryWindowWidth'] = 550; // Width of Query window
$cfgї'QueryWindowHeight'] = 310; // Height of Query window
$cfgї'QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history.
// If FALSE, this utilizes JS-routines to display
// query history (lost by window close)
$cfgї'QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup
// (sql|files|history|full)
$cfgї'QueryHistoryMax'] = 25; // When using DB-based query history, how many entries
// should be kept?
$cfgї'BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for
$cfgї'MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for
// table rows.
/**
* SQL Query box settings
* These are the links display in all of the SQL Query boxes
*/
$cfgї'SQLQuery']ї'Edit'] = TRUE; // Edit link to change a query
$cfgї'SQLQuery']ї'Explain'] = TRUE; // EXPLAIN on SELECT queries
$cfgї'SQLQuery']ї'ShowAsPHP'] = TRUE; // Wrap a query in PHP
$cfgї'SQLQuery']ї'Validate'] = FALSE; // Validate a query (see $cfgї'SQLValidator'] as well)
/**
* web-server upload directory
*/
$cfgї'UploadDir'] = ''; // for example, './upload/'; you must end it with
// a slash, and you leave it empty for no upload
// directory
$cfgї'SaveDir'] = ''; // for example, './save/'; you must end it with
// a slash, and you leave it empty for no save
// directory
/**
* Misc. settings
*/
$cfgї'GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto'
// does autodetection, which is a bit expensive for
// php < 4.3.0, but it is the only safe vay how to
// determine GD version.
/**
* SQL Parser Settings
*/
$cfgї'SQP']ї'fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none)
$cfgї'SQP']ї'fmtInd'] = '1'; // Amount to indent each level (floats ok)
$cfgї'SQP']ї'fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt})
$cfgї'SQP']ї'fmtColor'] = array( // Syntax colouring data
'comment' => '#808000',
'comment_mysql' => '',
'comment_ansi' => '',
'comment_c' => '',
'digit' => '',
'digit_hex' => 'teal',
'digit_integer' => 'teal',
'digit_float' => 'aqua',
'punct' => 'fuchsia',
'alpha' => '',
'alpha_columnType' => '#FF9900',
'alpha_columnAttrib' => '#0000FF',
'alpha_reservedWord' => '#990099',
'alpha_functionName' => '#FF0000',
'alpha_identifier' => 'black',
'alpha_variable' => '#800000',
'quote' => '#008000',
'quote_double' => '',
'quote_single' => '',
'quote_backtick' => ''
);
/**
* If you wish to use the SQL Validator service, you should be
* aware of the following:
* All SQL statements are stored anonymously for statistical purposes.
* Mimer SQL Validator, Copyright 2002 Upright Database Technology.
* All rights reserved.
*/
$cfgї'SQLValidator']ї'use'] = FALSE; // Make the SQL Validator available
$cfgї'SQLValidator']ї'username'] = ''; // If you have a custom username, specify it here (defaults to anonymous)
$cfgї'SQLValidator']ї'password'] = ''; // Password for username
/**
* Developers ONLY!
* To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
*/
$cfgї'DBG']ї'enable'] = FALSE; // Make the DBG stuff available
$cfgї'DBG']ї'profile']ї'enable'] = FALSE; // Produce profiling results of PHP
$cfgї'DBG']ї'profile']ї'threshold'] = 0.5; // Threshold of long running code to display
// Anything below the threshold is not displayed
/**
* MySQL settings
*/
// Column types;
// varchar, tinyint, text and date are listed first, based on estimated popularity
$cfgї'ColumnTypes'] = array(
'VARCHAR',
'TINYINT',
'TEXT',
'DATE',
'SMALLINT',
'MEDIUMINT',
'INT',
'BIGINT',
'FLOAT',
'DOUBLE',
'DECIMAL',
'DATETIME',
'TIMESTAMP',
'TIME',
'YEAR',
'CHAR',
'TINYBLOB',
'TINYTEXT',
'BLOB',
'MEDIUMBLOB',
'MEDIUMTEXT',
'LONGBLOB',
'LONGTEXT',
'ENUM',
'SET'
);
// Atributes
$cfgї'AttributeTypes'] = array(
'',
'BINARY',
'UNSIGNED',
'UNSIGNED ZEROFILL'
);
// Available functions
if ($cfgї'ShowFunctionFields']) {
$cfgї'Functions'] = array(
'ASCII',
'CHAR',
'SOUNDEX',
'LCASE',
'UCASE',
'NOW',
'PASSWORD',
'MD5',
'ENCRYPT',
'RAND',
'LAST_INSERT_ID',
'COUNT',
'AVG',
'SUM',
'CURDATE',
'CURTIME',
'FROM_DAYS',
'FROM_UNIXTIME',
'PERIOD_ADD',
'PERIOD_DIFF',
'TO_DAYS',
'UNIX_TIMESTAMP',
'USER',
'WEEKDAY',
'CONCAT'
);
// Which column types will be mapped to which Group?
$cfgї'RestrictColumnTypes'] = array(
'VARCHAR' => 'FUNC_CHAR',
'TINYINT' => 'FUNC_NUMBER',
'TEXT' => 'FUNC_CHAR',
'DATE' => 'FUNC_DATE',
'SMALLINT' => 'FUNC_NUMBER',
'MEDIUMINT' => 'FUNC_NUMBER',
'INT' => 'FUNC_NUMBER',
'BIGINT' => 'FUNC_NUMBER',
'FLOAT' => 'FUNC_NUMBER',
'DOUBLE' => 'FUNC_NUMBER',
'DECIMAL' => 'FUNC_NUMBER',
'DATETIME' => 'FUNC_DATE',
'TIMESTAMP' => 'FUNC_DATE',
'TIME' => 'FUNC_DATE',
'YEAR' => 'FUNC_DATE',
'CHAR' => 'FUNC_CHAR',
'TINYBLOB' => 'FUNC_CHAR',
'TINYTEXT' => 'FUNC_CHAR',
'BLOB' => 'FUNC_CHAR',
'MEDIUMBLOB' => 'FUNC_CHAR',
'MEDIUMTEXT' => 'FUNC_CHAR',
'LONGBLOB' => 'FUNC_CHAR',
'LONGTEXT' => 'FUNC_CHAR',
'ENUM' => '',
'SET' => ''
);
// Map above defined groups to any function
$cfgї'RestrictFunctions'] = array(
'FUNC_CHAR' => array(
'ASCII',
'CHAR',
'SOUNDEX',
'LCASE',
'UCASE',
'PASSWORD',
'MD5',
'ENCRYPT',
'LAST_INSERT_ID',
'USER',
'CONCAT'
),
'FUNC_DATE' => array(
'NOW',
'CURDATE',
'CURTIME',
'FROM_DAYS',
'FROM_UNIXTIME',
'PERIOD_ADD',
'PERIOD_DIFF',
'TO_DAYS',
'UNIX_TIMESTAMP',
'WEEKDAY'
),
'FUNC_NUMBER' => array(
'ASCII',
'CHAR',
'MD5',
'ENCRYPT',
'RAND',
'LAST_INSERT_ID',
'COUNT',
'AVG',
'SUM'
)
);
} // end if
/**
* Unset magic_quotes_runtime - do not change!
*/
set_magic_quotes_runtime(0);
/**
* File Revision - do not change either!
*/
$cfgї'FileRevision'] = '$Revision: 1.182 $';
?>Cheers,
Rapier503