TYPO3 3.7.0: typo3_src-3.7.0/typo3/ext/phpmyadmin/modsub/phpmyadmin-2.5.6-rc1/config.inc.php Source File

00001 <?php
00002 /* $Id: config.inc.php,v 2.5 2004/01/02 19:31:58 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 
00039 $cfg['PmaAbsoluteUri'] = '';
00040 
00041 
00047 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
00048 
00053 $cfg['PmaNoRelation_DisableWarning']  = FALSE;
00054 
00060 $cfg['blowfish_secret'] = '';
00061 
00065 $i = 0;
00066 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
00067 // You can disable a server config entry by setting host to ''.
00068 $i++;
00069 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname or IP address
00070 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
00071 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
00072 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
00073 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
00074                                                     // (requires PHP >= 4.3.0)
00075 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
00076                                                     // (this user must have read-only
00077 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
00078                                                     // and "mysql/db" tables).
00079                                                     // The controluser is also
00080                                                     // used for all relational
00081                                                     // features (pmadb)
00082 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
00083 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
00084 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
00085                                                     // with 'config' auth_type)
00086 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
00087                                                     // this db is displayed in left frame
00088                                                     // It may also be an array of db-names, where sorting order is relevant.
00089 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
00090 
00091 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
00092                                                     // (see scripts/create_tables.sql)
00093                                                     //   - leave blank for no support
00094                                                     //     DEFAULT: 'phpmyadmin'
00095 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
00096                                                     //   - leave blank for no bookmark support
00097                                                     //     DEFAULT: 'pma_bookmark'
00098 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
00099                                                     //   - leave blank for no relation-links support
00100                                                     //     DEFAULT: 'pma_relation'
00101 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
00102                                                     //   - leave blank for no display fields support
00103                                                     //     DEFAULT: 'pma_table_info'
00104 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
00105                                                     //   - leave blank for no PDF schema support
00106                                                     //     DEFAULT: 'pma_table_coords'
00107 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
00108                                                     //   - leave blank if you don't want to use this
00109                                                     //     DEFAULT: 'pma_pdf_pages'
00110 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
00111                                                     //   - leave blank for no column comments/mime types
00112                                                     //     DEFAULT: 'pma_column_info'
00113 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
00114                                                     //   - leave blank for no SQL query history
00115                                                     //     DEFAULT: 'pma_history'
00116 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your pma_* tables
00117                                                     // are up to date. This prevents compatibility
00118                                                     // checks and thereby increases performance.
00119 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
00120                                      = '';
00121 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
00122                                      = array();
00123 
00124 
00125 $i++;
00126 $cfg['Servers'][$i]['host']            = '';
00127 $cfg['Servers'][$i]['port']            = '';
00128 $cfg['Servers'][$i]['socket']          = '';
00129 $cfg['Servers'][$i]['connect_type']    = 'tcp';
00130 $cfg['Servers'][$i]['compress']        = FALSE;
00131 $cfg['Servers'][$i]['controluser']     = '';
00132 $cfg['Servers'][$i]['controlpass']     = '';
00133 $cfg['Servers'][$i]['auth_type']       = 'config';
00134 $cfg['Servers'][$i]['user']            = 'root';
00135 $cfg['Servers'][$i]['password']        = '';
00136 $cfg['Servers'][$i]['only_db']         = '';
00137 $cfg['Servers'][$i]['verbose']         = '';
00138 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
00139 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'
00140 $cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'
00141 $cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'
00142 $cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'
00143 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'
00144 $cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'
00145 $cfg['Servers'][$i]['history']         = ''; // 'pma_history'
00146 $cfg['Servers'][$i]['verbose_check']   = TRUE;
00147 $cfg['Servers'][$i]['AllowDeny']['order']
00148                                        = '';
00149 $cfg['Servers'][$i]['AllowDeny']['rules']
00150                                        = array();
00151 
00152 $i++;
00153 $cfg['Servers'][$i]['host']            = '';
00154 $cfg['Servers'][$i]['port']            = '';
00155 $cfg['Servers'][$i]['socket']          = '';
00156 $cfg['Servers'][$i]['connect_type']    = 'tcp';
00157 $cfg['Servers'][$i]['compress']        = FALSE;
00158 $cfg['Servers'][$i]['controluser']     = '';
00159 $cfg['Servers'][$i]['controlpass']     = '';
00160 $cfg['Servers'][$i]['auth_type']       = 'config';
00161 $cfg['Servers'][$i]['user']            = 'root';
00162 $cfg['Servers'][$i]['password']        = '';
00163 $cfg['Servers'][$i]['only_db']         = '';
00164 $cfg['Servers'][$i]['verbose']         = '';
00165 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
00166 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'pma_bookmark'
00167 $cfg['Servers'][$i]['relation']        = ''; // 'pma_relation'
00168 $cfg['Servers'][$i]['table_info']      = ''; // 'pma_table_info'
00169 $cfg['Servers'][$i]['table_coords']    = ''; // 'pma_table_coords'
00170 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'pma_pdf_pages'
00171 $cfg['Servers'][$i]['column_info']     = ''; // 'pma_column_info'
00172 $cfg['Servers'][$i]['history']         = ''; // 'pma_history'
00173 $cfg['Servers'][$i]['verbose_check']   = TRUE;
00174 $cfg['Servers'][$i]['AllowDeny']['order']
00175                                        = '';
00176 $cfg['Servers'][$i]['AllowDeny']['rules']
00177                                        = array();
00178 
00179 // If you have more than one server configured, you can set $cfg['ServerDefault']
00180 // to any one of them to autoconnect to that server when phpMyAdmin is started,
00181 // or set it to 0 to be given a list of servers without logging in
00182 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
00183 // set to that server.
00184 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
00185 $cfg['Server']        = '';
00186 unset($cfg['Servers'][0]);
00187 
00188 
00192 $cfg['OBGzip']                  = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto')
00193 $cfg['PersistentConnections']   = FALSE;  // use persistent connections to MySQL database
00194 $cfg['ExecTimeLimit']           = 300;    // maximum execution time in seconds (0 for no limit)
00195 $cfg['SkipLockedTables']        = FALSE;  // mark used tables, make possible to show
00196                                           // locked tables (since MySQL 3.23.30)
00197 $cfg['ShowSQL']                 = TRUE;   // show SQL queries as run
00198 $cfg['AllowUserDropDatabase']   = FALSE;  // show a 'Drop database' link to normal users
00199 $cfg['Confirm']                 = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
00200 $cfg['LoginCookieRecall']       = TRUE;   // recall previous login in cookie auth. mode or not
00201 $cfg['UseDbSearch']             = TRUE;   // whether to enable the "database search" feature
00202                                           // or not
00203 $cfg['IgnoreMultiSubmitErrors'] = FALSE;  // if set to true, PMA continues computing multiple-statement queries
00204                                           // even if one of the queries failed
00205 $cfg['VerboseMultiSubmit']      = TRUE;   // if set to true, PMA will show the affected rows of EACH statement on
00206                                           // multiple-statement queries. See the read_dump.php file for hardcoded
00207                                           // defaults on how many queries a statement may contain!
00208 $cfg['AllowArbitraryServer']    = FALSE;  // allow login to any user entered server in cookie based auth
00209 
00210 // Left frame setup
00211 $cfg['LeftFrameLight']        = TRUE;   // use a select-based menu and display only the
00212                                         // current tables in the left frame.
00213 $cfg['LeftFrameTableSeparator']= '__';  // Which string will be used to generate table prefixes
00214                                         // to split tables into multiple categories
00215 $cfg['LeftFrameTableLevel']   = '1';    // How many sublevels should be displayed when splitting
00216                                         // up tables by the above Separator
00217 $cfg['ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
00218 $cfg['ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
00219 $cfg['ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
00220                                         // table/db names
00221 
00222 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
00223 $cfg['LeftDisplayServers']    = FALSE;  // display server choice at top of left frame
00224 
00225 // In the main frame, at startup...
00226 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
00227                                         // the pages about database details and table
00228                                         // properties
00229 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
00230 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
00231 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
00232 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
00233 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
00234 
00235 // In browse mode...
00236 $cfg['ShowBlob']              = TRUE;  // display blob field contents
00237 $cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
00238 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
00239 $cfg['MaxRows']               = 30;     // maximum number of rows to display
00240 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
00241                                         // values are 'ASC', 'DESC' or 'SMART' -ie
00242                                         // descending order for fields of type
00243                                         // TIME, DATE, DATETIME & TIMESTAMP,
00244                                         // ascending order else-)
00245 
00246 // In edit mode...
00247 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
00248                                         // valid values are:
00249                                         //   FALSE  allow editing
00250                                         //   'blob' allow editing except for BLOB fields
00251                                         //   'all'  disallow editing
00252 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
00253 $cfg['CharEditing']           = 'input';
00254                                         // Which editor should be used for CHAR/VARCHAR fields:
00255                                         //  input - allows limiting of input length
00256                                         //  textarea - allows newlines in fields
00257 
00258 // For the export features...
00259 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
00260 $cfg['GZipDump']              = TRUE;   // compression for
00261 $cfg['BZipDump']              = TRUE;   // dump files
00262 $cfg['CompressOnFly']         = TRUE;   // Will compress gzip/bzip2 exports on
00263                                         // fly without need for much memory.
00264                                         // If you encounter problems with
00265                                         // created gzip/bzip2 files disable
00266                                         // this feature.
00267 
00268 // Tabs display settings
00269 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
00270 $cfg['PropertiesIconic']      = TRUE;   // Use icons instead of text for the table display of a database (TRUE|FALSE|'both')
00271 $cfg['PropertiesNumColumns']  = 1;      // How many columns should be used for table display of a database?
00272                                         // (a value larger than 1 results in some information being hidden)
00273 
00274 $cfg['DefaultTabServer']      = 'main.php';
00275                                    // Possible values:
00276                                    // 'main.php' = the welcome page
00277                                    // (recommended for multiuser setups)
00278                                    // 'server_databases.php' = list of databases
00279                                    // 'server_status.php' = runtime information
00280                                    // 'server_variables.php' = MySQL server variables
00281                                    // 'server_privileges.php' = user management
00282                                    // 'server_processlist.php' = process list
00283 $cfg['DefaultTabDatabase']    = 'db_details_structure.php';
00284                                    // Possible values:
00285                                    // 'db_details_structure.php' = tables list
00286                                    // 'db_details.php' = sql form
00287                                    // 'db_search.php' = search query
00288 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php';
00289                                    // Possible values:
00290                                    // 'tbl_properties_structure.php' = fields list
00291                                    // 'tbl_properties.php' = sql form
00292                                    // 'tbl_select.php = select page
00293                                    // 'tbl_change.php = insert row page
00294 
00299 $cfg['Export']['format']                    = 'sql';  // sql/latex/excel/csv/xml
00300 $cfg['Export']['compression']               = 'none'; // none/zip/gzip/bzip2
00301 
00302 $cfg['Export']['asfile']                    = FALSE;
00303 $cfg['Export']['onserver']                  = FALSE;
00304 $cfg['Export']['onserver_overwrite']        = FALSE;
00305 $cfg['Export']['remember_file_template']    = TRUE;
00306 
00307 $cfg['Export']['csv_columns']               = FALSE;
00308 $cfg['Export']['csv_null']                  = 'NULL';
00309 $cfg['Export']['csv_separator']             = ';';
00310 $cfg['Export']['csv_enclosed']              = '&quot;';
00311 $cfg['Export']['csv_escaped']               = '\\';
00312 $cfg['Export']['csv_terminated']            = 'AUTO';
00313 $cfg['Export']['excel_columns']             = FALSE;
00314 $cfg['Export']['excel_null']                = 'NULL';
00315 $cfg['Export']['excel_edition']             = 'win'; // win/mac
00316 
00317 $cfg['Export']['latex_structure']           = TRUE;
00318 $cfg['Export']['latex_data']                = TRUE;
00319 $cfg['Export']['latex_columns']             = TRUE;
00320 $cfg['Export']['latex_relation']            = TRUE;
00321 $cfg['Export']['latex_comments']            = TRUE;
00322 $cfg['Export']['latex_mime']                = TRUE;
00323 $cfg['Export']['latex_null']                = '\textit{NULL}';
00324 $cfg['Export']['latex_caption']             = TRUE;
00325 $cfg['Export']['latex_data_label']          = 'tab:__TABLE__-data';
00326 $cfg['Export']['latex_structure_label']     = 'tab:__TABLE__-structure';
00327 
00328 $cfg['Export']['sql_structure']             = TRUE;
00329 $cfg['Export']['sql_data']                  = TRUE;
00330 $cfg['Export']['sql_drop_database']         = FALSE;
00331 $cfg['Export']['sql_drop_table']            = FALSE;
00332 $cfg['Export']['sql_auto_increment']        = TRUE;
00333 $cfg['Export']['sql_backquotes']            = TRUE;
00334 $cfg['Export']['sql_dates']                 = FALSE;
00335 $cfg['Export']['sql_relation']              = FALSE;
00336 $cfg['Export']['sql_columns']               = FALSE;
00337 $cfg['Export']['sql_delayed']               = FALSE;
00338 $cfg['Export']['sql_type']                  = 'insert'; // insert/update/replace
00339 $cfg['Export']['sql_extended']              = FALSE;
00340 $cfg['Export']['sql_comments']              = FALSE;
00341 $cfg['Export']['sql_mime']                  = FALSE;
00342 
00349 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
00350 
00359 $cfg['MySQLManualType'] = 'searchable';
00360 
00361 
00365 $cfg['PDFPageSizes']        = array('A3', 'A4', 'A5', 'letter', 'legal');
00366 $cfg['PDFDefaultPageSize']  = 'A4';
00367 
00368 
00372 // Default language to use, if not browser-defined or user-defined
00373 $cfg['DefaultLang'] = 'en-iso-8859-1';
00374 
00375 // Force: always use this language - must be defined in
00376 //        libraries/select_lang.lib.php
00377 // $cfg['Lang']     = 'en-iso-8859-1';
00378 
00379 // Default charset to use for recoding of MySQL queries, does not take
00380 // any effect when charsets recoding is switched off by
00381 // $cfg['AllowAnywhereRecoding'] or in language file
00382 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
00383 $cfg['DefaultCharset'] = 'iso-8859-1';
00384 
00385 // Allow charset recoding of MySQL queries, must be also enabled in language
00386 // file to make harder using other language files than unicode.
00387 // Default value is FALSE to avoid problems on servers without the iconv
00388 // extension and where dl() is not supported
00389 $cfg['AllowAnywhereRecoding'] = FALSE;
00390 
00391 // You can select here which functions will be used for charset conversion.
00392 // Possible values are:
00393 //      auto   - automatically use available one (first is tested iconv, then
00394 //               recode)
00395 //      iconv  - use iconv or libiconv functions
00396 //      recode - use recode_string function
00397 $cfg['RecodingEngine'] = 'auto';
00398 
00399 // Specify some parameters for iconv used in charset conversion. See iconv
00400 // documentation for details:
00401 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
00402 $cfg['IconvExtraParams'] = '';
00403 
00404 // Available charsets for MySQL conversion. currently contains all which could
00405 // be found in lang/* files and few more.
00406 // Charsets will be shown in same order as here listed, so if you frequently
00407 // use some of these move them to the top.
00408 $cfg['AvailableCharsets'] = array(
00409     'iso-8859-1',
00410     'iso-8859-2',
00411     'iso-8859-3',
00412     'iso-8859-4',
00413     'iso-8859-5',
00414     'iso-8859-6',
00415     'iso-8859-7',
00416     'iso-8859-8',
00417     'iso-8859-9',
00418     'iso-8859-10',
00419     'iso-8859-11',
00420     'iso-8859-12',
00421     'iso-8859-13',
00422     'iso-8859-14',
00423     'iso-8859-15',
00424     'windows-1250',
00425     'windows-1251',
00426     'windows-1252',
00427     'windows-1257',
00428     'koi8-r',
00429     'big5',
00430     'gb2312',
00431     'utf-8',
00432     'utf-7',
00433     'x-user-defined',
00434     'euc-jp',
00435     'ks_c_5601-1987',
00436     'tis-620',
00437     'SHIFT_JIS'
00438 );
00439 
00443 $cfg['LeftWidth']           = 150;          // left frame width
00444 $cfg['LeftBgColor']         = '#D0DCE0';    // background color for the left frame
00445 $cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
00446 $cfg['RightBgImage']        = '';           // path to a background image for the right frame
00447                                             // (leave blank for no background image)
00448 $cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
00449                                             // (blank for no pointer)
00450 $cfg['Border']              = 0;            // border width on tables
00451 $cfg['ThBgcolor']           = '#D3DCE3';    // table header row colour
00452 $cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
00453 $cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
00454 $cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
00455                                             // (blank for no pointer)
00456 $cfg['BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
00457                                             // by clicking on it) in browse mode
00458                                             // (blank for no marker)
00459 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
00460                                             // (this value will be emphasized (*2) for sql
00461                                             // query textareas and (*1.25) for query window)
00462 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
00463 $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
00464 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
00465 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
00466 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
00467 $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
00468 $cfg['LimitChars']          = 50;           // Max field data length in browse mode for all non-numeric fields
00469 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
00470                                             // (or at the top with vertical browse)
00471 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
00472                                             // (or at the bottom with vertical browse)
00473 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
00474                                             // (horizontal|vertical|horizontalflipped)
00475 $cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
00476                                             // creating columns (tbl_properties)
00477                                             // (horizontal|vertical)
00478 
00479 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
00480                                             // NOTE: CSS only works in IE browsers!
00481 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
00482 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
00483 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
00484 
00485 $cfg['QueryFrame']          = TRUE;         // displays a new frame where a link to a querybox is always displayed.
00486 $cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.
00487                                             // if set to 'false', the target of the querybox is always the right frame.
00488 $cfg['QueryFrameDebug']     = FALSE;        // display JS debugging link (DEVELOPERS only)
00489 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
00490 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
00491 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
00492                                             // If FALSE, this utilizes JS-routines to display
00493                                             // query history (lost by window close)
00494 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
00495                                             // (sql|files|history|full)
00496 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
00497                                             // should be kept?
00498 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
00499 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
00500                                             // table rows.
00501 $cfg['WYSIWYG-PDF']         = TRUE;         // Utilize DHTML/JS capabilities to allow WYSIWYG editing of
00502                                             // the PDF page editor. Requires an IE6/Mozilla based browser.
00503 
00509 $cfg['DefaultQueryTable']   = 'SELECT * FROM %t WHERE 1';
00510 $cfg['DefaultQueryDatabase']= '';
00511 
00516 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
00517 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
00518 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
00519 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
00520 
00521 
00525 $cfg['UploadDir']             = '';         // Directory for uploaded files that can be executed by
00526                                             // phpMyAdmin. For example './upload'. Leave empty for
00527                                             // no upload directory support
00528 $cfg['SaveDir']               = '';         // Directory where phpMyAdmin can save exported data on
00529                                             // server. For example './save'. Leave empty for no save
00530                                             // directory support.
00531 $cfg['docSQLDir']             = '';         // Directory for docSQL imports, phpMyAdmin can import
00532                                             // docSQL files from that directory. For example
00533                                             // './docSQL'. Leave empty for no docSQL import support.
00534 
00535 
00539 $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
00540                                             // does autodetection, which is a bit expensive for
00541                                             // php < 4.3.0, but it is the only safe vay how to
00542                                             // determine GD version.
00546 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
00547 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
00548 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
00549 $cfg['SQP']['fmtColor']     = array(        // Syntax colouring data
00550     'comment'            => '#808000',
00551     'comment_mysql'      => '',
00552     'comment_ansi'       => '',
00553     'comment_c'          => '',
00554     'digit'              => '',
00555     'digit_hex'          => 'teal',
00556     'digit_integer'      => 'teal',
00557     'digit_float'        => 'aqua',
00558     'punct'              => 'fuchsia',
00559     'alpha'              => '',
00560     'alpha_columnType'   => '#FF9900',
00561     'alpha_columnAttrib' => '#0000FF',
00562     'alpha_reservedWord' => '#990099',
00563     'alpha_functionName' => '#FF0000',
00564     'alpha_identifier'   => 'black',
00565     'alpha_charset'      => '#6495ed',
00566     'alpha_variable'     => '#800000',
00567     'quote'              => '#008000',
00568     'quote_double'       => '',
00569     'quote_single'       => '',
00570     'quote_backtick'     => ''
00571 );
00572 
00573 
00581 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
00582 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
00583 $cfg['SQLValidator']['password'] = '';      // Password for username
00584 
00589 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
00590 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
00591 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
00592                                             // Anything below the threshold is not displayed
00593 
00594 
00598 // Column types;
00599 // varchar, tinyint, text and date are listed first, based on estimated popularity
00600 $cfg['ColumnTypes'] = array(
00601    'VARCHAR',
00602    'TINYINT',
00603    'TEXT',
00604    'DATE',
00605    'SMALLINT',
00606    'MEDIUMINT',
00607    'INT',
00608    'BIGINT',
00609    'FLOAT',
00610    'DOUBLE',
00611    'DECIMAL',
00612    'DATETIME',
00613    'TIMESTAMP',
00614    'TIME',
00615    'YEAR',
00616    'CHAR',
00617    'TINYBLOB',
00618    'TINYTEXT',
00619    'BLOB',
00620    'MEDIUMBLOB',
00621    'MEDIUMTEXT',
00622    'LONGBLOB',
00623    'LONGTEXT',
00624    'ENUM',
00625    'SET'
00626 );
00627 
00628 // Atributes
00629 $cfg['AttributeTypes'] = array(
00630    '',
00631    'BINARY',
00632    'UNSIGNED',
00633    'UNSIGNED ZEROFILL'
00634 );
00635 
00636 // Available functions
00637 if ($cfg['ShowFunctionFields']) {
00638     $cfg['Functions'] = array(
00639        'ASCII',
00640        'CHAR',
00641        'SOUNDEX',
00642        'LCASE',
00643        'UCASE',
00644        'NOW',
00645        'PASSWORD',
00646        'MD5',
00647        'ENCRYPT',
00648        'RAND',
00649        'LAST_INSERT_ID',
00650        'COUNT',
00651        'AVG',
00652        'SUM',
00653        'CURDATE',
00654        'CURTIME',
00655        'FROM_DAYS',
00656        'FROM_UNIXTIME',
00657        'PERIOD_ADD',
00658        'PERIOD_DIFF',
00659        'TO_DAYS',
00660        'UNIX_TIMESTAMP',
00661        'USER',
00662        'WEEKDAY',
00663        'CONCAT'
00664     );
00665 
00666     // Which column types will be mapped to which Group?
00667     $cfg['RestrictColumnTypes'] = array(
00668        'VARCHAR'      => 'FUNC_CHAR',
00669        'TINYINT'      => 'FUNC_NUMBER',
00670        'TEXT'         => 'FUNC_CHAR',
00671        'DATE'         => 'FUNC_DATE',
00672        'SMALLINT'     => 'FUNC_NUMBER',
00673        'MEDIUMINT'    => 'FUNC_NUMBER',
00674        'INT'          => 'FUNC_NUMBER',
00675        'BIGINT'       => 'FUNC_NUMBER',
00676        'FLOAT'        => 'FUNC_NUMBER',
00677        'DOUBLE'       => 'FUNC_NUMBER',
00678        'DECIMAL'      => 'FUNC_NUMBER',
00679        'DATETIME'     => 'FUNC_DATE',
00680        'TIMESTAMP'    => 'FUNC_DATE',
00681        'TIME'         => 'FUNC_DATE',
00682        'YEAR'         => 'FUNC_DATE',
00683        'CHAR'         => 'FUNC_CHAR',
00684        'TINYBLOB'     => 'FUNC_CHAR',
00685        'TINYTEXT'     => 'FUNC_CHAR',
00686        'BLOB'         => 'FUNC_CHAR',
00687        'MEDIUMBLOB'   => 'FUNC_CHAR',
00688        'MEDIUMTEXT'   => 'FUNC_CHAR',
00689        'LONGBLOB'     => 'FUNC_CHAR',
00690        'LONGTEXT'     => 'FUNC_CHAR',
00691        'ENUM'         => '',
00692        'SET'          => ''
00693     );
00694 
00695     // Map above defined groups to any function
00696     $cfg['RestrictFunctions'] = array(
00697         'FUNC_CHAR'   => array(
00698             'ASCII',
00699             'CHAR',
00700             'SOUNDEX',
00701             'LCASE',
00702             'UCASE',
00703             'PASSWORD',
00704             'MD5',
00705             'ENCRYPT',
00706             'LAST_INSERT_ID',
00707             'USER',
00708             'CONCAT'
00709         ),
00710 
00711         'FUNC_DATE'   => array(
00712             'NOW',
00713             'CURDATE',
00714             'CURTIME',
00715             'FROM_DAYS',
00716             'FROM_UNIXTIME',
00717             'PERIOD_ADD',
00718             'PERIOD_DIFF',
00719             'TO_DAYS',
00720             'UNIX_TIMESTAMP',
00721             'WEEKDAY'
00722         ),
00723 
00724         'FUNC_NUMBER' => array(
00725             'ASCII',
00726             'CHAR',
00727             'MD5',
00728             'ENCRYPT',
00729             'RAND',
00730             'LAST_INSERT_ID',
00731             'COUNT',
00732             'AVG',
00733             'SUM'
00734         )
00735     );
00736 
00737     // Default functions for above defined groups
00738     $cfg['DefaultFunctions'] = array(
00739         'FUNC_CHAR'         => '',
00740         'FUNC_DATE'         => '',
00741         'FUNC_NUMBER'       => '',
00742         'first_timestamp'   => 'NOW'
00743     );
00744 
00745 
00746 } // end if
00747 
00748 
00752 set_magic_quotes_runtime(0);
00753 
00754 require('../extModInclude.php');
00755 
00759 $cfg['FileRevision'] = '$Revision: 2.5 $';
00760 ?>
Documentation TYPO3 par Ameos

config.inc.php
