Page 1 of 1

myphpadminsetup

Posted: Wed Oct 29, 2003 6:05 pm
by Rapier503
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

Posted: Wed Oct 29, 2003 6:21 pm
by d3ad1ysp0rk
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..*

Posted: Wed Oct 29, 2003 6:21 pm
by JAM
index.php Line 45 and config.inc.php line 664 reads... ?

Read this

Posted: Wed Oct 29, 2003 7:10 pm
by Modem56k
http://us4.php.net/install.windows

Run Php as a Module.... that works for phpmyAdmin

Posted: Wed Oct 29, 2003 7:47 pm
by Rapier503
Index.php line 45

Code: Select all

header('Content-Type: text/html; charset=' . $GLOBALSї'charset']);
index.php

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)) &#123;
    if (!empty($_ENV) && isset($_ENV&#1111;'HTTP_HOST'])) &#123;
        $HTTP_HOST = $_ENV&#1111;'HTTP_HOST'];
    &#125;
    else if (!empty($HTTP_ENV_VARS) && isset($HTTP_ENV_VARS&#1111;'HTTP_HOST'])) &#123;
        $HTTP_HOST = $HTTP_ENV_VARS&#1111;'HTTP_HOST'];
    &#125;
    else if (@getenv('HTTP_HOST')) &#123;
        $HTTP_HOST = getenv('HTTP_HOST');
    &#125;
    else &#123;
        $HTTP_HOST = '';
    &#125;
&#125;


/**
 * Defines the frameset
 */
// loic1: If left light mode -> urldecode the db name
if (isset($lightm_db)) &#123;
// no longer urlencoded because of html entities in the db name
//    $db    = urldecode($lightm_db);
    $db    = $lightm_db;
    unset($lightm_db);
&#125;
$url_query = PMA_generate_common_url(isset($db) ? $db : '');

header('Content-Type: text/html; charset=' . $GLOBALS&#1111;'charset']);

require('./libraries/relation.lib.php');
$cfgRelation = PMA_getRelationsParam();

if ($cfg&#1111;'QueryHistoryDB'] && $cfgRelation&#1111;'historywork']) &#123;
    PMA_purgeHistory($cfg&#1111;'Server']&#1111;'user']);
&#125;

$phpmain_hash = md5($cfg&#1111;'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&#1111;$lang]&#1111;2]; ?>" lang="<?php echo $available_languages&#1111;$lang]&#1111;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&#1111;'QueryFrame']) &#123;

    if ($cfg&#1111;'QueryFrameJS']) &#123;
        echo '<script type="text/javascript">' . "\n";
        echo '<!--' . "\n";
        echo '    document.writeln(''<frameset cols="' . $cfg&#1111;'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&#1111;'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";
    &#125;

    echo '<frameset cols="' . $cfg&#1111;'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&#1111;'DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . '" frameborder="0" />' . "\n";

&#125; else &#123;
    
    echo '<frameset cols="' . $cfg&#1111;'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&#1111;'DefaultTabDatabase']) . '?' . $url_query . '" name="phpmain' . $phpmain_hash . '" frameborder="1" />' . "\n";

&#125;
?>

    <noframes>
        <body bgcolor="#FFFFFF">
            <p><?php echo $strNoFrames; ?></p>
        </body>
    </noframes>
</frameset>
<?php
if ($cfg&#1111;'QueryFrame'] && $cfg&#1111;'QueryFrameJS']) &#123;
    echo '</noscript>' . "\n";
&#125;
?>

</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)) &#123;
    error_reporting(E_ALL);
    @ini_set('display_errors', '1');
&#125;


/**
 * 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&#1111;'PmaAbsoluteUri_DisableWarning'] variable below.
 */
$cfg&#1111;'PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';


/**
 * Disable the default warning about $cfg&#1111;'PmaAbsoluteUri'] not being set
 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
 * works perfectly.
 */
$cfg&#1111;'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&#1111;'PmaNoRelation_DisableWarning']  = FALSE;


/**
 * Server(s) configuration
 */
$i = 0;
// The $cfg&#1111;'Servers'] array starts with $cfg&#1111;'Servers']&#1111;1].  Do not use $cfg&#1111;'Servers']&#1111;0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'host']          = 'localhost'; // MySQL hostname
$cfg&#1111;'Servers']&#1111;$i]&#1111;'port']          = '3306';      // MySQL port - leave blank for default port
$cfg&#1111;'Servers']&#1111;$i]&#1111;'socket']        = '';          // Path to the socket - leave blank for default socket
$cfg&#1111;'Servers']&#1111;$i]&#1111;'connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
$cfg&#1111;'Servers']&#1111;$i]&#1111;'compress']      = FALSE;       // Use compressed protocol for the MySQL connection
                                                    // (requires PHP >= 4.3.0)
$cfg&#1111;'Servers']&#1111;$i]&#1111;'controluser']   = '';          // MySQL control user settings
                                                    // (this user must have read-only
$cfg&#1111;'Servers']&#1111;$i]&#1111;'controlpass']   = '';          // access to the "mysql/user"
                                                    // and "mysql/db" tables)
$cfg&#1111;'Servers']&#1111;$i]&#1111;'auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
$cfg&#1111;'Servers']&#1111;$i]&#1111;'user']          = 'root';      // MySQL user
$cfg&#1111;'Servers']&#1111;$i]&#1111;'password']      = '@@@@@@@@'; // MySQL password (only needed
                                                    // with 'config' auth_type)
$cfg&#1111;'Servers']&#1111;$i]&#1111;'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&#1111;'Servers']&#1111;$i]&#1111;'verbose']       = '';          // Verbose name for this host - leave blank to show the hostname

$cfg&#1111;'Servers']&#1111;$i]&#1111;'pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
                                                    // (see scripts/create_tables.sql)
                                                    //   - leave blank for no support
                                                    //     DEFAULT: 'phpmyadmin'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'bookmarktable'] = '';          // Bookmark table
                                                    //   - leave blank for no bookmark support
                                                    //     DEFAULT: 'PMA_bookmark'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'relation']      = '';          // table to describe the relation between links (see doc)
                                                    //   - leave blank for no relation-links support
                                                    //     DEFAULT: 'PMA_relation'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'table_info']    = '';          // table to describe the display fields
                                                    //   - leave blank for no display fields support
                                                    //     DEFAULT: 'PMA_table_info'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'table_coords']  = '';          // table to describe the tables position for the PDF schema
                                                    //   - leave blank for no PDF schema support
                                                    //     DEFAULT: 'PMA_table_coords'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'pdf_pages']     = '';          // table to describe pages of relationpdf
                                                    //   - leave blank if you don't want to use this
                                                    //     DEFAULT: 'PMA_pdf_pages'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'column_info']   = '';          // table to store column information
                                                    //   - leave blank for no column comments/mime types
                                                    //     DEFAULT: 'PMA_column_info'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'history']       = '';          // table to store SQL history
                                                    //   - leave blank for no SQL query history
                                                    //     DEFAULT: 'PMA_history'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'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&#1111;'Servers']&#1111;$i]&#1111;'AllowDeny']&#1111;'order']           // Host authentication order, leave blank to not use
                                     = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'AllowDeny']&#1111;'rules']           // Host authentication rules, leave blank for defaults
                                     = array();


$i++;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'host']            = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'port']            = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'socket']          = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'connect_type']    = 'tcp';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'compress']        = FALSE;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'controluser']     = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'controlpass']     = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'auth_type']       = 'config';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'user']            = 'root';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'password']        = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'only_db']         = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'verbose']         = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$cfg&#1111;'Servers']&#1111;$i]&#1111;'bookmarktable']   = ''; // 'PMA_bookmark'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'relation']        = ''; // 'PMA_relation'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'table_info']      = ''; // 'PMA_table_info'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'table_coords']    = ''; // 'PMA_table_coords'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'pdf_pages']       = ''; // 'PMA_pdf_page'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'column_info']     = ''; // 'PMA_column_info'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'history']         = ''; // 'PMA_history'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'verbose_check']   = TRUE;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'AllowDeny']&#1111;'order']
                                       = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'AllowDeny']&#1111;'rules']
                                       = array();

$i++;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'host']            = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'port']            = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'socket']          = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'connect_type']    = 'tcp';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'compress']        = FALSE;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'controluser']     = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'controlpass']     = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'auth_type']       = 'config';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'user']            = 'root';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'password']        = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'only_db']         = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'verbose']         = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
$cfg&#1111;'Servers']&#1111;$i]&#1111;'bookmarktable']   = ''; // 'PMA_bookmark'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'relation']        = ''; // 'PMA_relation'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'table_info']      = ''; // 'PMA_table_info'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'table_coords']    = ''; // 'PMA_table_coords'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'pdf_pages']       = ''; // 'PMA_pdf_page'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'column_info']     = ''; // 'PMA_column_info'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'history']         = ''; // 'PMA_history'
$cfg&#1111;'Servers']&#1111;$i]&#1111;'verbose_check']   = TRUE;
$cfg&#1111;'Servers']&#1111;$i]&#1111;'AllowDeny']&#1111;'order']
                                       = '';
$cfg&#1111;'Servers']&#1111;$i]&#1111;'AllowDeny']&#1111;'rules']
                                       = array();

// If you have more than one server configured, you can set $cfg&#1111;'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&#1111;'ServerDefault'] *MUST* be
// set to that server.
$cfg&#1111;'ServerDefault'] = 1;              // Default server (0 = no default server)
$cfg&#1111;'Server']        = '';
unset($cfg&#1111;'Servers']&#1111;0]);


/**
 * Other core phpMyAdmin settings
 */
$cfg&#1111;'OBGzip']                = TRUE;   // use GZIP output buffering if possible
$cfg&#1111;'PersistentConnections'] = FALSE;  // use persistent connections to MySQL database
$cfg&#1111;'ExecTimeLimit']         = 300;    // maximum execution time in seconds (0 for no limit)
$cfg&#1111;'SkipLockedTables']      = FALSE;  // mark used tables, make possible to show
                                        // locked tables (since MySQL 3.23.30)
$cfg&#1111;'ShowSQL']               = TRUE;   // show SQL queries as run
$cfg&#1111;'AllowUserDropDatabase'] = FALSE;  // show a 'Drop database' link to normal users
$cfg&#1111;'Confirm']               = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
$cfg&#1111;'LoginCookieRecall']     = TRUE;   // recall previous login in cookie auth. mode or not
$cfg&#1111;'UseDbSearch']           = TRUE;   // whether to enable the "database search" feature
                                        // or not

// Left frame setup
$cfg&#1111;'LeftFrameLight']        = TRUE;   // use a select-based menu and display only the
                                        // current tables in the left frame.
$cfg&#1111;'LeftFrameTableSeparator']= '__';  // Which string will be used to generate table prefixes
                                        // to split tables into multiple categories
$cfg&#1111;'LeftFrameTableLevel']   = '1';    // How many sublevels should be displayed when splitting
                                        // up tables by the above Separator
$cfg&#1111;'ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
$cfg&#1111;'ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
$cfg&#1111;'ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
                                        // table/db names

$cfg&#1111;'LeftDisplayLogo']       = TRUE;   // display logo at top of left frame

// In the main frame, at startup...
$cfg&#1111;'ShowStats']             = TRUE;   // allow to display statistics and space usage in
                                        // the pages about database details and table
                                        // properties
$cfg&#1111;'ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
$cfg&#1111;'ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
$cfg&#1111;'ShowPhpInfo']           = FALSE;  // information" and "change password" links for
$cfg&#1111;'ShowChgPassword']       = FALSE;  // simple users or not
$cfg&#1111;'SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)

// In browse mode...
$cfg&#1111;'ShowBlob']              = FALSE;  // display blob field contents
$cfg&#1111;'NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
$cfg&#1111;'ShowAll']               = FALSE;  // allows to display all the rows
$cfg&#1111;'MaxRows']               = 30;     // maximum number of rows to display
$cfg&#1111;'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&#1111;'ProtectBinary']         = 'blob'; // disallow editing of binary fields
                                        // valid values are:
                                        //   FALSE  allow editing
                                        //   'blob' allow editing except for BLOB fields
                                        //   'all'  disallow editing
$cfg&#1111;'ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
$cfg&#1111;'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&#1111;'ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
$cfg&#1111;'GZipDump']              = TRUE;   // compression for
$cfg&#1111;'BZipDump']              = TRUE;   // dump files

// Tabs display settings
$cfg&#1111;'LightTabs']             = FALSE;  // use graphically less intense menu tabs
$cfg&#1111;'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&#1111;'DefaultTabDatabase']    = 'db_details_structure.php';
                                   // Possible values:
                                   // 'db_details_structure.php' = tables list
                                   // 'db_details.php' = sql form
                                   // 'db_search.php' = search query
$cfg&#1111;'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&#1111;'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&#1111;'MySQLManualType'] = 'searchable';


/**
 * Language and charset conversion settings
 */
// Default language to use, if not browser-defined or user-defined
$cfg&#1111;'DefaultLang'] = 'en-iso-8859-1';

// Force: always use this language - must be defined in
//        libraries/select_lang.lib.php
// $cfg&#1111;'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&#1111;'AllowAnywhereRecoding'] or in language file
// (see $cfg&#1111;'AvailableCharsets'] to possible choices, you can add your own)
$cfg&#1111;'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&#1111;'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&#1111;'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&#1111;'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&#1111;'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&#1111;'LeftWidth']           = 150;          // left frame width
$cfg&#1111;'LeftBgColor']         = '#D0DCE0';    // background color for the left frame
$cfg&#1111;'RightBgColor']        = '#F5F5F5';    // background color for the right frame
$cfg&#1111;'RightBgImage']        = '';           // path to a background image for the right frame
                                            // (leave blank for no background image)
$cfg&#1111;'LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
                                            // (blank for no pointer)
$cfg&#1111;'Border']              = 0;            // border width on tables
$cfg&#1111;'ThBgcolor']           = '#D3DCE3';    // table header row colour
$cfg&#1111;'BgcolorOne']          = '#CCCCCC';    // table data row colour
$cfg&#1111;'BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
$cfg&#1111;'BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
                                            // (blank for no pointer)
$cfg&#1111;'BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
                                            // by clicking on it) in browse mode
                                            // (blank for no marker)
$cfg&#1111;'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&#1111;'TextareaRows']        = 7;            // textarea size (rows) in edit mode
$cfg&#1111;'LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
$cfg&#1111;'TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
$cfg&#1111;'CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
$cfg&#1111;'CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
$cfg&#1111;'CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
$cfg&#1111;'LimitChars']          = 50;           // For text and blobs, max field data length in browse mode
$cfg&#1111;'ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
                                            // (or at the top with vertical browse)
$cfg&#1111;'ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
                                            // (or at the bottom with vertical browse)
$cfg&#1111;'DefaultDisplay']      = 'horizontal'; // default display direction
                                            // (horizontal|vertical|horizontalflipped)
$cfg&#1111;'DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
                                            // creating columns (tbl_properties)
                                            // (horizontal|vertical)

$cfg&#1111;'HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
                                            // NOTE: CSS only works in IE browsers!
$cfg&#1111;'ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
$cfg&#1111;'ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
$cfg&#1111;'RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)

$cfg&#1111;'QueryFrame']          = TRUE;         // displays a new frame where a link to a querybox is always displayed.
$cfg&#1111;'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&#1111;'QueryFrameDebug']     = FALSE;        // display JS debugging link (DEVELOPERS only)
$cfg&#1111;'QueryWindowWidth']    = 550;          // Width of Query window
$cfg&#1111;'QueryWindowHeight']   = 310;          // Height of Query window
$cfg&#1111;'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&#1111;'QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
                                            // (sql|files|history|full)
$cfg&#1111;'QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
                                            // should be kept?
$cfg&#1111;'BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
$cfg&#1111;'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&#1111;'SQLQuery']&#1111;'Edit']      = TRUE;       // Edit link to change a query
$cfg&#1111;'SQLQuery']&#1111;'Explain']   = TRUE;       // EXPLAIN on SELECT queries
$cfg&#1111;'SQLQuery']&#1111;'ShowAsPHP'] = TRUE;       // Wrap a query in PHP
$cfg&#1111;'SQLQuery']&#1111;'Validate']  = FALSE;      // Validate a query (see $cfg&#1111;'SQLValidator'] as well)


/**
 * web-server upload directory
 */
$cfg&#1111;'UploadDir']             = '';         // for example, './upload/'; you must end it with
                                            // a slash, and you leave it empty for no upload
                                            // directory
$cfg&#1111;'SaveDir']               = '';         // for example, './save/'; you must end it with
                                            // a slash, and you leave it empty for no save
                                            // directory


/**
 * Misc. settings
 */
$cfg&#1111;'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&#1111;'SQP']&#1111;'fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
$cfg&#1111;'SQP']&#1111;'fmtInd']       = '1';          // Amount to indent each level (floats ok)
$cfg&#1111;'SQP']&#1111;'fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - &#123;em,px,pt&#125;)
$cfg&#1111;'SQP']&#1111;'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&#1111;'SQLValidator']&#1111;'use']      = FALSE;   // Make the SQL Validator available
$cfg&#1111;'SQLValidator']&#1111;'username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
$cfg&#1111;'SQLValidator']&#1111;'password'] = '';      // Password for username

/**
 * Developers ONLY!
 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 */
$cfg&#1111;'DBG']&#1111;'enable'] = FALSE;              // Make the DBG stuff available
$cfg&#1111;'DBG']&#1111;'profile']&#1111;'enable'] = FALSE;   // Produce profiling results of PHP
$cfg&#1111;'DBG']&#1111;'profile']&#1111;'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&#1111;'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&#1111;'AttributeTypes'] = array(
   '',
   'BINARY',
   'UNSIGNED',
   'UNSIGNED ZEROFILL'
);

// Available functions
if ($cfg&#1111;'ShowFunctionFields']) &#123;
    $cfg&#1111;'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&#1111;'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&#1111;'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'
        )
    );
    
&#125; // end if


/**
 * Unset magic_quotes_runtime - do not change!
 */
set_magic_quotes_runtime(0);

/**
 * File Revision - do not change either!
 */
$cfg&#1111;'FileRevision'] = '$Revision: 1.182 $';
?>
Hope someone can advise,

Cheers,

Rapier503