TYPO3 3.8.1: typo3_src-3.8.1/typo3/ext/phpmyadmin/modsub/phpMyAdmin-2.6.4-pl3/config.inc.php Source File

00001 <?php
00002 /* $Id: config.inc.php,v 2.65 2005/08/23 23:08:21 lem9 Exp $ */
00003 // vim: expandtab sw=4 ts=4 sts=4:
00004 
00015 if (!isset($old_error_reporting)) {
00016     error_reporting(E_ALL);
00017     @ini_set('display_errors', '1');
00018 }
00019 
00020 
00036 $cfg['PmaAbsoluteUri'] = '';
00037 
00042 $cfg['PmaNoRelation_DisableWarning']  = FALSE;
00043 
00050 $cfg['blowfish_secret'] = '';
00051 
00055 $i = 0;
00056 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
00057 // You can disable a server config entry by setting host to ''.
00058 $i++;
00059 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
00060 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
00061 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
00062 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
00063 $cfg['Servers'][$i]['extension']     = 'mysql';     // The php MySQL extension to use ('mysql' or 'mysqli')
00064 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
00065                                                     // (requires PHP >= 4.3.0)
00066 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
00067                                                     // (this user must have read-only
00068 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
00069                                                     // and "mysql/db" tables).
00070                                                     // The controluser is also
00071                                                     // used for all relational
00072                                                     // features (pmadb)
00073 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
00074 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
00075 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
00076                                                     // with 'config' auth_type)
00077 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
00078                                                     // this db is displayed in left frame
00079                                                     // It may also be an array of db-names, where sorting order is relevant.
00080 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
00081 
00082 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
00083                                                     // (see scripts/create_tables.sql)
00084                                                     //   - leave blank for no support
00085                                                     //     DEFAULT: 'phpmyadmin'
00086 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
00087                                                     //   - leave blank for no bookmark support
00088                                                     //     DEFAULT: 'pma_bookmark'
00089 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
00090                                                     //   - leave blank for no relation-links support
00091                                                     //     DEFAULT: 'pma_relation'
00092 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
00093                                                     //   - leave blank for no display fields support
00094                                                     //     DEFAULT: 'pma_table_info'
00095 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
00096                                                     //   - leave blank for no PDF schema support
00097                                                     //     DEFAULT: 'pma_table_coords'
00098 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
00099                                                     //   - leave blank if you don't want to use this
00100                                                     //     DEFAULT: 'pma_pdf_pages'
00101 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
00102                                                     //   - leave blank for no column comments/mime types
00103                                                     //     DEFAULT: 'pma_column_info'
00104 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
00105                                                     //   - leave blank for no SQL query history
00106                                                     //     DEFAULT: 'pma_history'
00107 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
00108                                                     // are up to date. This prevents compatibility
00109                                                     // checks and thereby increases performance.
00110 $cfg['Servers'][$i]['AllowRoot']     = TRUE;        // whether to allow root login
00111 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
00112                                      = '';
00113 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
00114                                      = array();
00115 
00122 $i++;
00123 $cfg['Servers'][$i]['host']            = '';
00124 $cfg['Servers'][$i]['port']            = '';
00125 $cfg['Servers'][$i]['socket']          = '';
00126 $cfg['Servers'][$i]['connect_type']    = 'tcp';
00127 $cfg['Servers'][$i]['extension']       = 'mysql';
00128 $cfg['Servers'][$i]['compress']        = FALSE;
00129 $cfg['Servers'][$i]['controluser']     = '';
00130 $cfg['Servers'][$i]['controlpass']     = '';
00131 $cfg['Servers'][$i]['auth_type']       = 'config';
00132 $cfg['Servers'][$i]['user']            = 'root';
00133 $cfg['Servers'][$i]['password']        = '';
00134 $cfg['Servers'][$i]['only_db']         = '';
00135 $cfg['Servers'][$i]['verbose']         = '';
00136 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
00137 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'
00138 $cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'
00139 $cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'
00140 $cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'
00141 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'
00142 $cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'
00143 $cfg['Servers'][$i]['history']         = ''; // 'pma_history'
00144 $cfg['Servers'][$i]['verbose_check']   = TRUE;
00145 $cfg['Servers'][$i]['AllowRoot']       = TRUE;
00146 $cfg['Servers'][$i]['AllowDeny']['order']
00147                                        = '';
00148 $cfg['Servers'][$i]['AllowDeny']['rules']
00149                                        = array();
00150 
00155 $i++;
00156 $cfg['Servers'][$i]['host']            = '';
00157 $cfg['Servers'][$i]['port']            = '';
00158 $cfg['Servers'][$i]['socket']          = '';
00159 $cfg['Servers'][$i]['connect_type']    = 'tcp';
00160 $cfg['Servers'][$i]['extension']       = 'mysql';
00161 $cfg['Servers'][$i]['compress']        = FALSE;
00162 $cfg['Servers'][$i]['controluser']     = '';
00163 $cfg['Servers'][$i]['controlpass']     = '';
00164 $cfg['Servers'][$i]['auth_type']       = 'config';
00165 $cfg['Servers'][$i]['user']            = 'root';
00166 $cfg['Servers'][$i]['password']        = '';
00167 $cfg['Servers'][$i]['only_db']         = '';
00168 $cfg['Servers'][$i]['verbose']         = '';
00169 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
00170 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'
00171 $cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'
00172 $cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'
00173 $cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'
00174 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'
00175 $cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'
00176 $cfg['Servers'][$i]['history']         = ''; // 'pma_history'
00177 $cfg['Servers'][$i]['verbose_check']   = TRUE;
00178 $cfg['Servers'][$i]['AllowRoot']       = TRUE;
00179 
00180 $cfg['Servers'][$i]['AllowDeny']['order']
00181                                        = '';
00182 $cfg['Servers'][$i]['AllowDeny']['rules']
00183                                        = array();
00184 
00185 // If you have more than one server configured, you can set $cfg['ServerDefault']
00186 // to any one of them to autoconnect to that server when phpMyAdmin is started,
00187 // or set it to 0 to be given a list of servers without logging in
00188 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
00189 // set to that server.
00190 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
00191 $cfg['Server']        = '';
00192 unset($cfg['Servers'][0]);
00193 
00194 
00198 $cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
00199 $cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database
00200 $cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
00201 $cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
00202                                           // locked tables (since MySQL 3.23.30)
00203 $cfg['ShowSQL']                 = TRUE;   // show SQL queries as run
00204 $cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users
00205 $cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
00206 $cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not
00207 $cfg['LoginCookieValidity']     = 1800;   // validity of cookie login (in seconds)
00208 $cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature
00209                                           // or not
00210 $cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
00211                                           // even if one of the queries failed
00212 $cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on
00213                                           // multiple-statement queries. See the read_dump.php file for hardcoded
00214                                           // defaults on how many queries a statement may contain!
00215 $cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth
00216 
00217 // Left frame setup
00218 $cfg['LeftFrameLight']        = TRUE;    // use a select-based menu and display only the
00219                                          // current tables in the left frame.
00220 $cfg['LeftFrameDBTree']       = TRUE;    // turn the select-based light menu into a tree
00221 $cfg['LeftFrameDBSeparator']  = '_';     // the separator to sub-tree the select-based light menu tree
00222 $cfg['LeftFrameTableSeparator']= '__';   // Which string will be used to generate table prefixes
00223                                          // to split/nest tables into multiple categories
00224 $cfg['LeftFrameTableLevel']   = '1';     // How many sublevels should be displayed when splitting
00225                                          // up tables by the above Separator
00226 $cfg['ShowTooltip']           = TRUE;    // display table comment as tooltip in left frame
00227 $cfg['ShowTooltipAliasDB']    = FALSE;   // if ShowToolTip is enabled, this defines that table/db comments
00228 $cfg['ShowTooltipAliasTB']    = FALSE;   // are shown (in the left menu and db_details_structure) instead of
00229                                          // table/db names. Setting ShowTooltipAliasTB to 'nested' will only
00230                                          // use the Aliases for nested descriptors, not the table itself.
00231 
00232 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
00233 $cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
00234 $cfg['DisplayServersList']    = FALSE;  // server choice as links
00235 
00236 // In the main frame, at startup...
00237 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
00238                                         // the pages about database details and table
00239                                         // properties
00240 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
00241 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
00242 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
00243 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
00244 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
00245 
00246 // In browse mode...
00247 $cfg['ShowBlob']              = FALSE;  // display blob field contents
00248 $cfg['NavigationBarIconic']   = 'both'; // Use icons instead of text for the navigation bar buttons
00249                                         // and on right panel top menu (server db table) (TRUE|FALSE|'both')
00250 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
00251 $cfg['MaxRows']               = 30;     // maximum number of rows to display
00252 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
00253                                         // values are 'ASC', 'DESC' or 'SMART' -ie
00254                                         // descending order for fields of type
00255                                         // TIME, DATE, DATETIME & TIMESTAMP,
00256                                         // ascending order else-)
00257 
00258 // In edit mode...
00259 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
00260                                         // valid values are:
00261                                         //   FALSE  allow editing
00262                                         //   'blob' allow editing except for BLOB fields
00263                                         //   'all'  disallow editing
00264 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
00265 $cfg['CharEditing']           = 'input';
00266                                         // Which editor should be used for CHAR/VARCHAR fields:
00267                                         //  input - allows limiting of input length
00268                                         //  textarea - allows newlines in fields
00269 $cfg['InsertRows']            = 2;      // How many rows can be inserted at one time
00270 
00271 $cfg['ForeignKeyDropdownOrder'] =       // Sort order for items in a foreign-key dropdown box. 
00272     array( 'content-id', 'id-content'); // 'content' is the referenced data, 'id' is the key value.
00273 $cfg['ForeignKeyMaxLimit'] = 100;       // A dropdown will be used if fewer items are present
00274 
00275 
00276 // For the export features...
00277 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
00278 $cfg['GZipDump']              = TRUE;   // compression for
00279 $cfg['BZipDump']              = TRUE;   // dump files
00280 $cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on
00281                                         // fly without need for much memory.
00282                                         // If you encounter problems with
00283                                         // created gzip/bzip2 files disable
00284                                         // this feature.
00285 
00286 // Tabs display settings
00287 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
00288 $cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
00289 $cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?
00290                                         // (a value larger than 1 results in some information being hidden)
00291 
00292 $cfg['DefaultTabServer']      = 'main.php';
00293                                    // Possible values:
00294                                    // 'main.php' = the welcome page
00295                                    // (recommended for multiuser setups)
00296                                    // 'server_databases.php' = list of databases
00297                                    // 'server_status.php' = runtime information
00298                                    // 'server_variables.php' = MySQL server variables
00299                                    // 'server_privileges.php' = user management
00300                                    // 'server_processlist.php' = process list
00301 $cfg['DefaultTabDatabase']    = 'db_details_structure.php';
00302                                    // Possible values:
00303                                    // 'db_details_structure.php' = tables list
00304                                    // 'db_details.php' = sql form
00305                                    // 'db_search.php' = search query
00306                                    // 'db_operations.php' = operations on database
00307 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php';
00308                                    // Possible values:
00309                                    // 'tbl_properties_structure.php' = fields list
00310                                    // 'tbl_properties.php' = sql form
00311                                    // 'tbl_select.php = select page
00312                                    // 'tbl_change.php = insert row page
00313 
00318 $cfg['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml/xls/htmlexcel/htmlword
00319 $cfg['Export']['compression']               = 'none'; // none/zip/gzip/bzip2
00320 
00321 $cfg['Export']['asfile']                    = FALSE;
00322 $cfg['Export']['charset']                   = '';
00323 $cfg['Export']['onserver']                  = FALSE;
00324 $cfg['Export']['onserver_overwrite']        = FALSE;
00325 $cfg['Export']['remember_file_template']    = TRUE;
00326 $cfg['Export']['file_template_table']       = '__TABLE__';
00327 $cfg['Export']['file_template_database']    = '__DB__';
00328 $cfg['Export']['file_template_server']      = '__SERVER__';
00329 
00330 $cfg['Export']['htmlexcel_columns']         = FALSE;
00331 $cfg['Export']['htmlexcel_null']            = 'NULL';
00332 
00333 $cfg['Export']['htmlword_structure']        = TRUE;
00334 $cfg['Export']['htmlword_data']             = TRUE;
00335 $cfg['Export']['htmlword_columns']          = FALSE;
00336 $cfg['Export']['htmlword_null']             = 'NULL';
00337 
00338 $cfg['Export']['xls_columns']               = FALSE;
00339 $cfg['Export']['xls_null']                  = 'NULL';
00340 
00341 $cfg['Export']['csv_columns']               = FALSE;
00342 $cfg['Export']['csv_null']                  = 'NULL';
00343 $cfg['Export']['csv_separator']             = ';';
00344 $cfg['Export']['csv_enclosed']              = '&quot;';
00345 $cfg['Export']['csv_escaped']               = '\\';
00346 $cfg['Export']['csv_terminated']            = 'AUTO';
00347 $cfg['Export']['excel_columns']             = FALSE;
00348 $cfg['Export']['excel_null']                = 'NULL';
00349 $cfg['Export']['excel_edition']             = 'win'; // win/mac
00350 
00351 $cfg['Export']['latex_structure']           = TRUE;
00352 $cfg['Export']['latex_data']                = TRUE;
00353 $cfg['Export']['latex_columns']             = TRUE;
00354 $cfg['Export']['latex_relation']            = TRUE;
00355 $cfg['Export']['latex_comments']            = TRUE;
00356 $cfg['Export']['latex_mime']                = TRUE;
00357 $cfg['Export']['latex_null']                = '\textit{NULL}';
00358 $cfg['Export']['latex_caption']             = TRUE;
00359 $cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';
00360 $cfg['Export']['latex_structure_label']     = 'tab:__TABLE__-structure';
00361 
00362 $cfg['Export']['sql_structure']             = TRUE;
00363 $cfg['Export']['sql_data']                  = TRUE;
00364 $cfg['Export']['sql_compat']                = 'NONE';
00365 $cfg['Export']['sql_disable_fk']            = FALSE;
00366 $cfg['Export']['sql_use_transaction']       = FALSE;
00367 $cfg['Export']['sql_drop_database']         = FALSE;
00368 $cfg['Export']['sql_drop_table']            = FALSE;
00369 $cfg['Export']['sql_if_not_exists']         = FALSE;
00370 $cfg['Export']['sql_auto_increment']        = TRUE;
00371 $cfg['Export']['sql_backquotes']            = TRUE;
00372 $cfg['Export']['sql_dates']                 = FALSE;
00373 $cfg['Export']['sql_relation']              = FALSE;
00374 $cfg['Export']['sql_columns']               = FALSE;
00375 $cfg['Export']['sql_delayed']               = FALSE;
00376 $cfg['Export']['sql_ignore']                = FALSE;
00377 $cfg['Export']['sql_hex_for_binary']        = TRUE;
00378 $cfg['Export']['sql_type']                  = 'insert'; // insert/update/replace
00379 $cfg['Export']['sql_extended']              = FALSE;
00380 $cfg['Export']['sql_comments']              = FALSE;
00381 $cfg['Export']['sql_mime']                  = FALSE;
00382 $cfg['Export']['sql_header_comment']        = ''; // \n is replaced by new line
00383 
00390 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en';
00391 
00400 $cfg['MySQLManualType'] = 'searchable';
00401 
00402 
00406 $cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
00407 $cfg['PDFDefaultPageSize']  = 'A4';
00408 
00409 
00413 // Default language to use, if not browser-defined or user-defined
00414 $cfg['DefaultLang'] = 'en-iso-8859-1';
00415 
00416 // Force: always use this language - must be defined in
00417 //        libraries/select_lang.lib.php
00418 // $cfg['Lang']     = 'en-iso-8859-1';
00419 
00420 // Default charset to use for recoding of MySQL queries, does not take
00421 // any effect when charsets recoding is switched off by
00422 // $cfg['AllowAnywhereRecoding'] or in language file
00423 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
00424 $cfg['DefaultCharset'] = 'iso-8859-1';
00425 
00426 // Allow charset recoding of MySQL queries, must be also enabled in language
00427 // file to make harder using other language files than unicode.
00428 // Default value is FALSE to avoid problems on servers without the iconv
00429 // extension and where dl() is not supported
00430 $cfg['AllowAnywhereRecoding'] = FALSE;
00431 
00432 // You can select here which functions will be used for charset conversion.
00433 // Possible values are:
00434 //      auto   - automatically use available one (first is tested iconv, then
00435 //               recode)
00436 //      iconv  - use iconv or libiconv functions
00437 //      recode - use recode_string function
00438 $cfg['RecodingEngine'] = 'auto';
00439 
00440 // Specify some parameters for iconv used in charset conversion. See iconv
00441 // documentation for details:
00442 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
00443 $cfg['IconvExtraParams'] = '';
00444 
00445 // Available charsets for MySQL conversion. currently contains all which could
00446 // be found in lang/* files and few more.
00447 // Charsets will be shown in same order as here listed, so if you frequently
00448 // use some of these move them to the top.
00449 $cfg['AvailableCharsets'] = array(
00450     'iso-8859-1',
00451     'iso-8859-2',
00452     'iso-8859-3',
00453     'iso-8859-4',
00454     'iso-8859-5',
00455     'iso-8859-6',
00456     'iso-8859-7',
00457     'iso-8859-8',
00458     'iso-8859-9',
00459     'iso-8859-10',
00460     'iso-8859-11',
00461     'iso-8859-12',
00462     'iso-8859-13',
00463     'iso-8859-14',
00464     'iso-8859-15',
00465     'windows-1250',
00466     'windows-1251',
00467     'windows-1252',
00468     'windows-1256',
00469     'windows-1257',
00470     'koi8-r',
00471     'big5',
00472     'gb2312',
00473     'utf-8',
00474     'utf-7',
00475     'x-user-defined',
00476     'euc-jp',
00477     'ks_c_5601-1987',
00478     'tis-620',
00479     'SHIFT_JIS'
00480 );
00481 
00488 $cfg['LeftPointerEnable']   = TRUE;         // enable the left panel pointer
00489                                             // (used when LeftFrameLight is FALSE)
00490                                             // see also LeftPointerColor
00491                                             // in layout.inc.php
00492 
00493 $cfg['BrowsePointerEnable'] = TRUE;        // enable the browse pointer
00494                                             // see also BrowsePointerColor
00495                                             // in layout.inc.php
00496 
00497 $cfg['BrowseMarkerEnable'] = TRUE;         // enable the browse marker
00498                                             // see also BrowseMarkerColor
00499                                             // in layout.inc.php
00500 
00501 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
00502                                             // (this value will be emphasized (*2) for sql
00503                                             // query textareas and (*1.25) for query window)
00504 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
00505 $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
00506 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
00507 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
00508 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
00509 $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
00510 $cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields
00511 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
00512                                             // (or at the top with vertical browse)
00513 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
00514                                             // (or at the bottom with vertical browse)
00515 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
00516                                             // (horizontal|vertical|horizontalflipped)
00517 $cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
00518                                             // creating columns (tbl_properties)
00519                                             // (horizontal|vertical)
00520 
00521 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
00522                                             // NOTE: CSS only works in IE browsers!
00523 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
00524 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
00525 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
00526 
00527 $cfg['QueryFrame']          = TRUE;         // displays a link or icon in the left frame to open the querybox, and activates the querybox when clicking on [Edit] on the results page.
00528 $cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.
00529                                             // if set to 'false', the target of the querybox is always the right frame.
00530 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
00531 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
00532 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
00533                                             // If FALSE, this utilizes JS-routines to display
00534                                             // query history (lost by window close)
00535 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
00536                                             // (sql|files|history|full)
00537 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
00538                                             // should be kept?
00539 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
00540 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
00541                                             // table rows.
00542 $cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
00543                                             // the PDF page editor. Requires an IE6/Mozilla based browser.
00544 
00545 $cfg['NaturalOrder']        = TRUE;         // Sort table and database in natural order
00546 
00547 
00548 //-----------------------------------------------------------------------------
00549 // custom-setup by mkkeck: 2004-05-04
00550 //    some specials for new icons and scrollings
00551 // FIXME:
00552 // 2004-05-08 rabus: We need to rearrange these variables.
00553 
00554 $cfg['ShowHttpHostTitle']   = TRUE;            // show HttpHost in browsers window title (true|false)?
00555 $cfg['SetHttpHostTitle']    = '';              // if ShowHttpHostTitle=true, please set your host (server)
00556                                              // or an other string, wich should be shown in browsers window title.
00557                                              // If not set (or empty), the PMA will get your real Host-Adress.
00558 
00559 $cfg['ErrorIconic']          = TRUE;    // show some icons for warning, error and information messages (true|false)?
00560 $cfg['MainPageIconic']       = TRUE;    // show icons in list on main page and on menu tabs (true|false)?
00561 $cfg['ReplaceHelpImg']       = TRUE;    // show help button instead of strDocumentation (true|false)?
00562 
00563 // theme manager
00564 $cfg['ThemePath']           = './themes';    // using themes manager please set up here the path to 'themes'
00565                                              // else leave empty
00566 $cfg['ThemeManager']        = TRUE;          // if you want to use selectable themes and if ThemesPath not empty
00567                                              // set it to true, else set it to false (default is false);
00568 $cfg['ThemeDefault']        = 'original';         // set up default theme, if ThemePath not empty
00569                                              // you can set up here an valid path to themes or 'original' for
00570                                              // the original pma-theme
00571 $cfg['ThemePerServer']      = FALSE;         // allow diferent theme for each configured server
00572 
00573 //-----------------------------------------------------------------------------
00574 
00575 
00583 $cfg['DefaultQueryTable']    = 'SELECT * FROM %t WHERE 1';
00584 $cfg['DefaultQueryDatabase'] = '';
00585 
00590 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
00591 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
00592 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
00593 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
00594 $cfg['SQLQuery']['Refresh']   = TRUE;       // Refresh the results page
00595 
00596 
00600 $cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by
00601                                             // phpMyAdmin. For example './upload'. Leave empty for
00602                                             // no upload directory support
00603 $cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on
00604                                             // server. For example './save'. Leave empty for no save
00605                                             // directory support.
00606 $cfg['docSQLDir']             = '';         // Directory for docSQL imports, phpMyAdmin can import
00607                                             // docSQL files from that directory. For example
00608                                             // './docSQL'. Leave empty for no docSQL import support.
00609 $cfg['TempDir']               = '';         // Directory where phpMyAdmin can save temporary files.
00610                                             // This is needed for MS Excel export, see documentation
00611                                             // how to enable that.
00612 
00613 
00617 $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
00618                                             // does autodetection, which is a bit expensive for
00619                                             // php < 4.3.0, but it is the only safe vay how to
00620                                             // determine GD version.
00624 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
00625 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
00626 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
00627 // The graphical settings are now located in themes/themename/layout.inc.php
00628 
00636 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
00637 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
00638 $cfg['SQLValidator']['password'] = '';      // Password for username
00639 
00644 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
00645 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
00646 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
00647                                             // Anything below the threshold is not displayed
00648 
00649 
00653 // Column types;
00654 // varchar, tinyint, text and date are listed first, based on estimated popularity
00655 $cfg['ColumnTypes'] = array(
00656    'VARCHAR',
00657    'TINYINT',
00658    'TEXT',
00659    'DATE',
00660    'SMALLINT',
00661    'MEDIUMINT',
00662    'INT',
00663    'BIGINT',
00664    'FLOAT',
00665    'DOUBLE',
00666    'DECIMAL',
00667    'DATETIME',
00668    'TIMESTAMP',
00669    'TIME',
00670    'YEAR',
00671    'CHAR',
00672    'TINYBLOB',
00673    'TINYTEXT',
00674    'BLOB',
00675    'MEDIUMBLOB',
00676    'MEDIUMTEXT',
00677    'LONGBLOB',
00678    'LONGTEXT',
00679    'ENUM',
00680    'SET',
00681    'BOOL'
00682 );
00683 
00684 // Attributes
00685 // Note: the "ON UPDATE CURRENT_TIMESTAMP" attribute is added dynamically 
00686 // for MySQL >= 4.1.2, in tbl_properties.inc.php
00687 
00688 $cfg['AttributeTypes'] = array(
00689    '',
00690    'BINARY',
00691    'UNSIGNED',
00692    'UNSIGNED ZEROFILL'
00693 );
00694 
00695 // Available functions
00696 if ($cfg['ShowFunctionFields']) {
00697     $cfg['Functions'] = array(
00698        'ASCII',
00699        'CHAR',
00700        'SOUNDEX',
00701        'LCASE',
00702        'UCASE',
00703        'NOW',
00704        'PASSWORD',
00705        'OLD_PASSWORD',
00706        'MD5',
00707        'SHA1',
00708        'ENCRYPT',
00709        'RAND',
00710        'LAST_INSERT_ID',
00711        'COUNT',
00712        'AVG',
00713        'SUM',
00714        'CURDATE',
00715        'CURTIME',
00716        'FROM_DAYS',
00717        'FROM_UNIXTIME',
00718        'PERIOD_ADD',
00719        'PERIOD_DIFF',
00720        'TO_DAYS',
00721        'UNIX_TIMESTAMP',
00722        'USER',
00723        'WEEKDAY',
00724        'CONCAT'
00725     );
00726 
00727     // Which column types will be mapped to which Group?
00728     $cfg['RestrictColumnTypes'] = array(
00729        'VARCHAR'      => 'FUNC_CHAR',
00730        'TINYINT'      => 'FUNC_NUMBER',
00731        'TEXT'         => 'FUNC_CHAR',
00732        'DATE'         => 'FUNC_DATE',
00733        'SMALLINT'     => 'FUNC_NUMBER',
00734        'MEDIUMINT'    => 'FUNC_NUMBER',
00735        'INT'          => 'FUNC_NUMBER',
00736        'BIGINT'       => 'FUNC_NUMBER',
00737        'FLOAT'        => 'FUNC_NUMBER',
00738        'DOUBLE'       => 'FUNC_NUMBER',
00739        'DECIMAL'      => 'FUNC_NUMBER',
00740        'DATETIME'     => 'FUNC_DATE',
00741        'TIMESTAMP'    => 'FUNC_DATE',
00742        'TIME'         => 'FUNC_DATE',
00743        'YEAR'         => 'FUNC_DATE',
00744        'CHAR'         => 'FUNC_CHAR',
00745        'TINYBLOB'     => 'FUNC_CHAR',
00746        'TINYTEXT'     => 'FUNC_CHAR',
00747        'BLOB'         => 'FUNC_CHAR',
00748        'MEDIUMBLOB'   => 'FUNC_CHAR',
00749        'MEDIUMTEXT'   => 'FUNC_CHAR',
00750        'LONGBLOB'     => 'FUNC_CHAR',
00751        'LONGTEXT'     => 'FUNC_CHAR',
00752        'ENUM'         => '',
00753        'SET'          => ''
00754     );
00755 
00756     // Map above defined groups to any function
00757     $cfg['RestrictFunctions'] = array(
00758         'FUNC_CHAR'   => array(
00759             'ASCII',
00760             'CHAR',
00761             'SOUNDEX',
00762             'LCASE',
00763             'UCASE',
00764             'PASSWORD',
00765             'OLD_PASSWORD',
00766             'MD5',
00767             'SHA1',
00768             'ENCRYPT',
00769             'LAST_INSERT_ID',
00770             'USER',
00771             'CONCAT'
00772         ),
00773 
00774         'FUNC_DATE'   => array(
00775             'NOW',
00776             'CURDATE',
00777             'CURTIME',
00778             'FROM_DAYS',
00779             'FROM_UNIXTIME',
00780             'PERIOD_ADD',
00781             'PERIOD_DIFF',
00782             'TO_DAYS',
00783             'UNIX_TIMESTAMP',
00784             'WEEKDAY'
00785         ),
00786 
00787         'FUNC_NUMBER' => array(
00788             'ASCII',
00789             'CHAR',
00790             'MD5',
00791             'SHA1',
00792             'ENCRYPT',
00793             'RAND',
00794             'LAST_INSERT_ID',
00795             'UNIX_TIMESTAMP',
00796             'COUNT',
00797             'AVG',
00798             'SUM'
00799         )
00800     );
00801 
00802     // Default functions for above defined groups
00803     $cfg['DefaultFunctions'] = array(
00804         'FUNC_CHAR'         => '',
00805         'FUNC_DATE'         => '',
00806         'FUNC_NUMBER'       => '',
00807         'first_timestamp'   => 'NOW'
00808     );
00809 
00810 
00811 } // end if
00812 
00813 // Search operators
00814 $cfg['NumOperators'] = array(
00815    '=',
00816    '>',
00817    '>=',
00818    '<',
00819    '<=',
00820    '!=',
00821    'LIKE',
00822    'NOT LIKE'
00823 );
00824 
00825 $cfg['TextOperators'] = array(
00826    'LIKE',
00827    'LIKE %...%',
00828    'NOT LIKE',
00829    '=',
00830    '!=',
00831    'REGEXP',
00832    'NOT REGEXP'
00833 );
00834 
00835 $cfg['EnumOperators'] = array(
00836    '=',
00837    '!='
00838 );
00839 
00840 $cfg['SetOperators'] = array(
00841    'IN',
00842    'NOT IN'
00843 );
00844 
00845 $cfg['NullOperators'] = array(
00846    'IS NULL',
00847    'IS NOT NULL'
00848 );
00849 
00850 $cfg['UnaryOperators'] = array(
00851    'IS NULL'     => 1,
00852    'IS NOT NULL' => 1
00853 );
00854 
00858 set_magic_quotes_runtime(0);
00859 
00860 require('../extModInclude.php');
00861 
00865 $cfg['FileRevision'] = '$Revision: 2.65 $';
00866 ?>
Documentation TYPO3 par Ameos

config.inc.php
