Print
Send Feedback
Fixed Width
Fluid WidthError Buddy
Do you have an error message from your application? Then find the answer with Error Buddy. You can search over 40000 source code files and troubleshooting documents using our beta lucene/nutch search interface or if you prefer, search as normal using google. With LXR technology you can drill right down into the line of source code where it came from with full cross-referencing.
If after searching you didn't get your ideal answer, or you are still unclear what the error means, you can choose to post that question to the community forums following the link included in the search results.
[1.6]001 <?php 002 /* $Id: config.inc.php,v 2.48 2004/12/28 12:48:27 nijel Exp $ */ 003 // vim: expandtab sw=4 ts=4 sts=4: 004 005 /** 006 * phpMyAdmin Configuration File 007 * 008 * All directives are explained in Documentation.html 009 */ 010 011 012 /** 013 * Sets the php error reporting - Please do not change this line! 014 */ 015 if (!isset($old_error_reporting)) { 016 error_reporting(E_ALL); 017 @ini_set('display_errors', '1'); 018 } 019 020 021 /** 022 * Your phpMyAdmin url 023 * 024 * Complete the variable below with the full url ie 025 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ 026 * 027 * It must contain characters that are valid for a URL, and the path is 028 * case sensitive on some Web servers, for example Unix-based servers. 029 * 030 * In most cases you can leave this variable empty, as the correct value 031 * will be detected automatically. However, we recommend that you do 032 * test to see that the auto-detection code works in your system. A good 033 * test is to browse a table, then edit a row and save it. There will be 034 * an error message if phpMyAdmin cannot auto-detect the correct value. 035 * 036 * If the auto-detection code does work properly, you can set to TRUE the 037 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below. 038 */ 039 040 /** 041 * Disabling the use of PmaAbsoluteUri, since the auto detection is working. 042 $cfg['PmaAbsoluteUri'] = ''; 043 */ 044 045 /** 046 * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set 047 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection 048 * works perfectly. 049 */ 050 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; 051 052 /** 053 * Disable the default warning that is displayed on the DB Details Structure page if 054 * any of the required Tables for the relationfeatures could not be found 055 */ 056 $cfg['PmaNoRelation_DisableWarning'] = FALSE; 057 058 /** 059 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If 060 * at least one server configuration uses 'cookie' auth_type, enter here a 061 * passphrase that will be used by blowfish. 062 */ 063 $cfg['blowfish_secret'] = ''; 064 065 /** 066 * Server(s) configuration 067 */ 068 $i = 0; 069 // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. 070 // You can disable a server config entry by setting host to ''. 071 $i++; 072 $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address 073 $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port 074 $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket 075 $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') 076 $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') 077 $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection 078 // (requires PHP >= 4.3.0) 079 $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings 080 // (this user must have read-only 081 $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" 082 // and "mysql/db" tables). 083 // The controluser is also 084 // used for all relational 085 // features (pmadb) 086 $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? 087 $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 088 $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed 089 // with 'config' auth_type) 090 $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only 091 // this db is displayed in left frame 092 // It may also be an array of db-names, where sorting order is relevant. 093 $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname 094 095 $cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features 096 // (see scripts/create_tables.sql) 097 // - leave blank for no support 098 // DEFAULT: 'phpmyadmin' 099 $cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table 100 // - leave blank for no bookmark support 101 // DEFAULT: 'pma_bookmark' 102 $cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) 103 // - leave blank for no relation-links support 104 // DEFAULT: 'pma_relation' 105 $cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields 106 // - leave blank for no display fields support 107 // DEFAULT: 'pma_table_info' 108 $cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema 109 // - leave blank for no PDF schema support 110 // DEFAULT: 'pma_table_coords' 111 $cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf 112 // - leave blank if you don't want to use this 113 // DEFAULT: 'pma_pdf_pages' 114 $cfg['Servers'][$i]['column_info'] = ''; // table to store column information 115 // - leave blank for no column comments/mime types 116 // DEFAULT: 'pma_column_info' 117 $cfg['Servers'][$i]['history'] = ''; // table to store SQL history 118 // - leave blank for no SQL query history 119 // DEFAULT: 'pma_history' 120 $cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables 121 // are up to date. This prevents compatibility 122 // checks and thereby increases performance. 123 $cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login 124 $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use 125 = ''; 126 $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults 127 = array(); 128 129 130 $i++; 131 $cfg['Servers'][$i]['host'] = ''; 132 $cfg['Servers'][$i]['port'] = ''; 133 $cfg['Servers'][$i]['socket'] = ''; 134 $cfg['Servers'][$i]['connect_type'] = 'tcp'; 135 $cfg['Servers'][$i]['extension'] = 'mysql'; 136 $cfg['Servers'][$i]['compress'] = FALSE; 137 $cfg['Servers'][$i]['controluser'] = ''; 138 $cfg['Servers'][$i]['controlpass'] = ''; 139 $cfg['Servers'][$i]['auth_type'] = 'config'; 140 $cfg['Servers'][$i]['user'] = 'root'; 141 $cfg['Servers'][$i]['password'] = ''; 142 $cfg['Servers'][$i]['only_db'] = ''; 143 $cfg['Servers'][$i]['verbose'] = ''; 144 $cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql 145 $cfg['Servers'][$i]['bookmarktable'] = ''; // 'pma_bookmark' 146 $cfg['Servers'][$i]['relation'] = ''; // 'pma_relation' 147 $cfg['Servers'][$i]['table_info'] = ''; // 'pma_table_info' 148 $cfg['Servers'][$i]['table_coords'] = ''; // 'pma_table_coords' 149 $cfg['Servers'][$i]['pdf_pages'] = ''; // 'pma_pdf_pages' 150 $cfg['Servers'][$i]['column_info'] = ''; // 'pma_column_info' 151 $cfg['Servers'][$i]['history'] = ''; // 'pma_history' 152 $cfg['Servers'][$i]['verbose_check'] = TRUE; 153 $cfg['Servers'][$i]['AllowRoot'] = TRUE; 154 $cfg['Servers'][$i]['AllowDeny']['order'] 155 = ''; 156 $cfg['Servers'][$i]['AllowDeny']['rules'] 157 = array(); 158 159 $i++; 160 $cfg['Servers'][$i]['host'] = ''; 161 $cfg['Servers'][$i]['port'] = ''; 162 $cfg['Servers'][$i]['socket'] = ''; 163 $cfg['Servers'][$i]['connect_type'] = 'tcp'; 164 $cfg['Servers'][$i]['extension'] = 'mysql'; 165 $cfg['Servers'][$i]['compress'] = FALSE; 166 $cfg['Servers'][$i]['controluser'] = ''; 167 $cfg['Servers'][$i]['controlpass'] = ''; 168 $cfg['Servers'][$i]['auth_type'] = 'config'; 169 $cfg['Servers'][$i]['user'] = 'root'; 170 $cfg['Servers'][$i]['password'] = ''; 171 $cfg['Servers'][$i]['only_db'] = ''; 172 $cfg['Servers'][$i]['verbose'] = ''; 173 $cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql 174 $cfg['Servers'][$i]['bookmarktable'] = ''; // 'pma_bookmark' 175 $cfg['Servers'][$i]['relation'] = ''; // 'pma_relation' 176 $cfg['Servers'][$i]['table_info'] = ''; // 'pma_table_info' 177 $cfg['Servers'][$i]['table_coords'] = ''; // 'pma_table_coords' 178 $cfg['Servers'][$i]['pdf_pages'] = ''; // 'pma_pdf_pages' 179 $cfg['Servers'][$i]['column_info'] = ''; // 'pma_column_info' 180 $cfg['Servers'][$i]['history'] = ''; // 'pma_history' 181 $cfg['Servers'][$i]['verbose_check'] = TRUE; 182 $cfg['Servers'][$i]['AllowRoot'] = TRUE; 183 184 $cfg['Servers'][$i]['AllowDeny']['order'] 185 = ''; 186 $cfg['Servers'][$i]['AllowDeny']['rules'] 187 = array(); 188 189 // If you have more than one server configured, you can set $cfg['ServerDefault'] 190 // to any one of them to autoconnect to that server when phpMyAdmin is started, 191 // or set it to 0 to be given a list of servers without logging in 192 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be 193 // set to that server. 194 $cfg['ServerDefault'] = 1; // Default server (0 = no default server) 195 $cfg['Server'] = ''; 196 unset($cfg['Servers'][0]); 197 198 199 /** 200 * Other core phpMyAdmin settings 201 */ 202 $cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto') 203 $cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database 204 $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit) 205 $cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show 206 // locked tables (since MySQL 3.23.30) 207 $cfg['ShowSQL'] = TRUE; // show SQL queries as run 208 $cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users 209 $cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE' 210 $cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not 211 $cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds) 212 $cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature 213 // or not 214 $cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries 215 // even if one of the queries failed 216 $cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on 217 // multiple-statement queries. See the read_dump.php file for hardcoded 218 // defaults on how many queries a statement may contain! 219 $cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth 220 221 // Left frame setup 222 $cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the 223 // current tables in the left frame. 224 $cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes 225 // to split/nest tables into multiple categories 226 $cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting 227 // up tables by the above Separator 228 $cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame 229 $cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments 230 $cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of 231 // table/db names. Setting ShowTooltipAliasTB to 'nested' will only 232 // use the Aliases for nested descriptors, not the table itself. 233 234 $cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame 235 $cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame 236 $cfg['DisplayServersList'] = FALSE; // server choice as links 237 238 // In the main frame, at startup... 239 $cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in 240 // the pages about database details and table 241 // properties 242 $cfg['ShowMysqlInfo'] = FALSE; // whether to display the "MySQL runtime 243 $cfg['ShowMysqlVars'] = FALSE; // information", "MySQL system variables", "PHP 244 $cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for 245 $cfg['ShowChgPassword'] = FALSE; // simple users or not 246 $cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty) 247 248 // In browse mode... 249 $cfg['ShowBlob'] = FALSE; // display blob field contents 250 $cfg['NavigationBarIconic'] = TRUE; // do not display text inside navigation bar buttons 251 $cfg['ShowAll'] = FALSE; // allows to display all the rows 252 $cfg['MaxRows'] = 30; // maximum number of rows to display 253 $cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid 254 // values are 'ASC', 'DESC' or 'SMART' -ie 255 // descending order for fields of type 256 // TIME, DATE, DATETIME & TIMESTAMP, 257 // ascending order else-) 258 259 // In edit mode... 260 $cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields 261 // valid values are: 262 // FALSE allow editing 263 // 'blob' allow editing except for BLOB fields 264 // 'all' disallow editing 265 $cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode 266 $cfg['CharEditing'] = 'input'; 267 // Which editor should be used for CHAR/VARCHAR fields: 268 // input - allows limiting of input length 269 // textarea - allows newlines in fields 270 $cfg['InsertRows'] = 2; // How many rows can be inserted at one time 271 272 // For the export features... 273 $cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip 274 $cfg['GZipDump'] = TRUE; // compression for 275 $cfg['BZipDump'] = TRUE; // dump files 276 $cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on 277 // fly without need for much memory. 278 // If you encounter problems with 279 // created gzip/bzip2 files disable 280 // this feature. 281 282 // Tabs display settings 283 $cfg['LightTabs'] = FALSE; // use graphically less intense menu tabs 284 $cfg['PropertiesIconic'] = TRUE; // Use icons instead of text for the table display of a database (TRUE|FALSE|'both') 285 $cfg['PropertiesNumColumns'] = 1; // How many columns should be used for table display of a database? 286 // (a value larger than 1 results in some information being hidden) 287 288 $cfg['DefaultTabServer'] = 'main.php'; 289 // Possible values: 290 // 'main.php' = the welcome page 291 // (recommended for multiuser setups) 292 // 'server_databases.php' = list of databases 293 // 'server_status.php' = runtime information 294 // 'server_variables.php' = MySQL server variables 295 // 'server_privileges.php' = user management 296 // 'server_processlist.php' = process list 297 $cfg['DefaultTabDatabase'] = 'db_details_structure.php'; 298 // Possible values: 299 // 'db_details_structure.php' = tables list 300 // 'db_details.php' = sql form 301 // 'db_search.php' = search query 302 // 'db_operations.php' = operations on database 303 $cfg['DefaultTabTable'] = 'tbl_properties_structure.php'; 304 // Possible values: 305 // 'tbl_properties_structure.php' = fields list 306 // 'tbl_properties.php' = sql form 307 // 'tbl_select.php = select page 308 // 'tbl_change.php = insert row page 309 310 /** 311 * Export defaults 312 */ 313 314 $cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls 315 $cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2 316 317 $cfg['Export']['asfile'] = FALSE; 318 $cfg['Export']['onserver'] = FALSE; 319 $cfg['Export']['onserver_overwrite'] = FALSE; 320 $cfg['Export']['remember_file_template'] = TRUE; 321 322 $cfg['Export']['xls_columns'] = FALSE; 323 $cfg['Export']['xls_null'] = 'NULL'; 324 325 $cfg['Export']['csv_columns'] = FALSE; 326 $cfg['Export']['csv_null'] = 'NULL'; 327 $cfg['Export']['csv_separator'] = ';'; 328 $cfg['Export']['csv_enclosed'] = '"'; 329 $cfg['Export']['csv_escaped'] = '\\'; 330 $cfg['Export']['csv_terminated'] = 'AUTO'; 331 $cfg['Export']['excel_columns'] = FALSE; 332 $cfg['Export']['excel_null'] = 'NULL'; 333 $cfg['Export']['excel_edition'] = 'win'; // win/mac 334 335 $cfg['Export']['latex_structure'] = TRUE; 336 $cfg['Export']['latex_data'] = TRUE; 337 $cfg['Export']['latex_columns'] = TRUE; 338 $cfg['Export']['latex_relation'] = TRUE; 339 $cfg['Export']['latex_comments'] = TRUE; 340 $cfg['Export']['latex_mime'] = TRUE; 341 $cfg['Export']['latex_null'] = '\textit{NULL}'; 342 $cfg['Export']['latex_caption'] = TRUE; 343 $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data'; 344 $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure'; 345 346 $cfg['Export']['sql_structure'] = TRUE; 347 $cfg['Export']['sql_data'] = TRUE; 348 $cfg['Export']['sql_compat'] = 'NONE'; 349 $cfg['Export']['sql_disable_fk'] = FALSE; 350 $cfg['Export']['sql_use_transaction'] = FALSE; 351 $cfg['Export']['sql_drop_database'] = FALSE; 352 $cfg['Export']['sql_drop_table'] = FALSE; 353 $cfg['Export']['sql_if_not_exists'] = FALSE; 354 $cfg['Export']['sql_auto_increment'] = TRUE; 355 $cfg['Export']['sql_backquotes'] = TRUE; 356 $cfg['Export']['sql_dates'] = FALSE; 357 $cfg['Export']['sql_relation'] = FALSE; 358 $cfg['Export']['sql_columns'] = FALSE; 359 $cfg['Export']['sql_delayed'] = FALSE; 360 $cfg['Export']['sql_ignore'] = FALSE; 361 $cfg['Export']['sql_hex_for_binary'] = TRUE; 362 $cfg['Export']['sql_type'] = 'insert'; // insert/update/replace 363 $cfg['Export']['sql_extended'] = FALSE; 364 $cfg['Export']['sql_comments'] = FALSE; 365 $cfg['Export']['sql_mime'] = FALSE; 366 $cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line 367 368 /** 369 * Link to the official MySQL documentation. 370 * Be sure to include no trailing slash on the path. 371 * See http://dev.mysql.com/doc/ for more information 372 * about MySQL manuals and their types. 373 */ 374 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en'; 375 376 /** 377 * Type of MySQL documentation: 378 * old - old style used in phpMyAdmin 2.3.0 and sooner 379 * searchable - "Searchable, with user comments" 380 * chapters - "HTML, one page per chapter" 381 * big - "HTML, all on one page" 382 * none - do not show documentation links 383 */ 384 $cfg['MySQLManualType'] = 'searchable'; 385 386 387 /** 388 * PDF options 389 */ 390 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal'); 391 $cfg['PDFDefaultPageSize'] = 'A4'; 392 393 394 /** 395 * Language and charset conversion settings 396 */ 397 // Default language to use, if not browser-defined or user-defined 398 $cfg['DefaultLang'] = 'en-iso-8859-1'; 399 400 // Force: always use this language - must be defined in 401 // libraries/select_lang.lib.php 402 // $cfg['Lang'] = 'en-iso-8859-1'; 403 404 // Default charset to use for recoding of MySQL queries, does not take 405 // any effect when charsets recoding is switched off by 406 // $cfg['AllowAnywhereRecoding'] or in language file 407 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own) 408 $cfg['DefaultCharset'] = 'iso-8859-1'; 409 410 // Allow charset recoding of MySQL queries, must be also enabled in language 411 // file to make harder using other language files than unicode. 412 // Default value is FALSE to avoid problems on servers without the iconv 413 // extension and where dl() is not supported 414 $cfg['AllowAnywhereRecoding'] = FALSE; 415 416 // You can select here which functions will be used for charset conversion. 417 // Possible values are: 418 // auto - automatically use available one (first is tested iconv, then 419 // recode) 420 // iconv - use iconv or libiconv functions 421 // recode - use recode_string function 422 $cfg['RecodingEngine'] = 'auto'; 423 424 // Specify some parameters for iconv used in charset conversion. See iconv 425 // documentation for details: 426 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html 427 $cfg['IconvExtraParams'] = ''; 428 429 // Available charsets for MySQL conversion. currently contains all which could 430 // be found in lang/* files and few more. 431 // Charsets will be shown in same order as here listed, so if you frequently 432 // use some of these move them to the top. 433 $cfg['AvailableCharsets'] = array( 434 'iso-8859-1', 435 'iso-8859-2', 436 'iso-8859-3', 437 'iso-8859-4', 438 'iso-8859-5', 439 'iso-8859-6', 440 'iso-8859-7', 441 'iso-8859-8', 442 'iso-8859-9', 443 'iso-8859-10', 444 'iso-8859-11', 445 'iso-8859-12', 446 'iso-8859-13', 447 'iso-8859-14', 448 'iso-8859-15', 449 'windows-1250', 450 'windows-1251', 451 'windows-1252', 452 'windows-1256', 453 'windows-1257', 454 'koi8-r', 455 'big5', 456 'gb2312', 457 'utf-8', 458 'utf-7', 459 'x-user-defined', 460 'euc-jp', 461 'ks_c_5601-1987', 462 'tis-620', 463 'SHIFT_JIS' 464 ); 465 466 /** 467 * Customization & design 468 * 469 * The graphical settings are now located in themes/themename/layout.inc.php 470 */ 471 472 $cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer 473 // (used when LeftFrameLight is FALSE) 474 // see also LeftPointerColor 475 // in layout.inc.php 476 477 $cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer 478 // see also BrowsePointerColor 479 // in layout.inc.php 480 481 $cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker 482 // see also BrowseMarkerColor 483 // in layout.inc.php 484 485 $cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode 486 // (this value will be emphasized (*2) for sql 487 // query textareas and (*1.25) for query window) 488 $cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode 489 $cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields 490 $cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox 491 $cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR 492 $cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR 493 $cfg['CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing? 494 $cfg['LimitChars'] = 50; // Max field data length in browse mode for all non-numeric fields 495 $cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse 496 // (or at the top with vertical browse) 497 $cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse 498 // (or at the bottom with vertical browse) 499 $cfg['DefaultDisplay'] = 'horizontal'; // default display direction 500 // (horizontal|vertical|horizontalflipped) 501 $cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/ 502 // creating columns (tbl_properties) 503 // (horizontal|vertical) 504 505 $cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake) 506 // NOTE: CSS only works in IE browsers! 507 $cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode. 508 $cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode. 509 $cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate) 510 511 $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. 512 $cfg['QueryFrameJS'] = TRUE; // whether to use JavaScript functions for opening a new window for SQL commands. 513 // if set to 'false', the target of the querybox is always the right frame. 514 $cfg['QueryWindowWidth'] = 550; // Width of Query window 515 $cfg['QueryWindowHeight'] = 310; // Height of Query window 516 $cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history. 517 // If FALSE, this utilizes JS-routines to display 518 // query history (lost by window close) 519 $cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup 520 // (sql|files|history|full) 521 $cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries 522 // should be kept? 523 $cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for 524 $cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for 525 // table rows. 526 $cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of 527 // the PDF page editor. Requires an IE6/Mozilla based browser. 528 529 $cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order 530 531 532 //----------------------------------------------------------------------------- 533 // custom-setup by mkkeck: 2004-05-04 534 // some specials for new icons and scrollings 535 // FIXME: 536 // 2004-05-08 rabus: We need to rearrange these variables. 537 538 $cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)? 539 $cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server) 540 // or an other string, wich should be shown in browsers window title. 541 // If not set (or empty), the PMA will get your real Host-Adress. 542 543 $cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)? 544 $cfg['MainPageIconic'] = TRUE; // show icons in list on main page, on right panel top menu (server db table) and on menu tabs (true|false)? 545 $cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocumentation (true|false)? 546 547 // theme manager 548 $cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes' 549 // else leave empty 550 $cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not empty 551 // set it to true, else set it to false (default is false); 552 $cfg['ThemeDefault'] = 'original'; // set up default theme, if ThemePath not empty 553 // you can set up here an valid path to themes or 'original' for 554 // the original pma-theme 555 556 //----------------------------------------------------------------------------- 557 558 559 /** 560 * Default queries 561 * %d will be replaced by the database name. 562 * %t will be replaced by the table name. 563 * %f will be replaced by a list of field names. 564 * (%t and %f only applies to DefaultQueryTable) 565 */ 566 $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1'; 567 $cfg['DefaultQueryDatabase'] = ''; 568 569 /** 570 * SQL Query box settings 571 * These are the links display in all of the SQL Query boxes 572 */ 573 $cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query 574 $cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries 575 $cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP 576 $cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well) 577 $cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page 578 579 580 /** 581 * Webserver upload/save/import directories 582 */ 583 $cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by 584 // phpMyAdmin. For example './upload'. Leave empty for 585 // no upload directory support 586 $cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on 587 // server. For example './save'. Leave empty for no save 588 // directory support. 589 $cfg['docSQLDir'] = ''; // Directory for docSQL imports, phpMyAdmin can import 590 // docSQL files from that directory. For example 591 // './docSQL'. Leave empty for no docSQL import support. 592 $cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files. 593 // This is needed for MS Excel export, see documentation 594 // how to enable that. 595 596 597 /** 598 * Misc. settings 599 */ 600 $cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto' 601 // does autodetection, which is a bit expensive for 602 // php < 4.3.0, but it is the only safe vay how to 603 // determine GD version. 604 /** 605 * SQL Parser Settings 606 */ 607 $cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none) 608 $cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok) 609 $cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt}) 610 // The graphical settings are now located in themes/themename/layout.inc.php 611 612 /** 613 * If you wish to use the SQL Validator service, you should be 614 * aware of the following: 615 * All SQL statements are stored anonymously for statistical purposes. 616 * Mimer SQL Validator, Copyright 2002 Upright Database Technology. 617 * All rights reserved. 618 */ 619 $cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available 620 $cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous) 621 $cfg['SQLValidator']['password'] = ''; // Password for username 622 623 /** 624 * Developers ONLY! 625 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/ 626 */ 627 $cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available 628 $cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP 629 $cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display 630 // Anything below the threshold is not displayed 631 632 633 /** 634 * MySQL settings 635 */ 636 // Column types; 637 // varchar, tinyint, text and date are listed first, based on estimated popularity 638 $cfg['ColumnTypes'] = array( 639 'VARCHAR', 640 'TINYINT', 641 'TEXT', 642 'DATE', 643 'SMALLINT', 644 'MEDIUMINT', 645 'INT', 646 'BIGINT', 647 'FLOAT', 648 'DOUBLE', 649 'DECIMAL', 650 'DATETIME', 651 'TIMESTAMP', 652 'TIME', 653 'YEAR', 654 'CHAR', 655 'TINYBLOB', 656 'TINYTEXT', 657 'BLOB', 658 'MEDIUMBLOB', 659 'MEDIUMTEXT', 660 'LONGBLOB', 661 'LONGTEXT', 662 'ENUM', 663 'SET' 664 ); 665 666 // Attributes 667 $cfg['AttributeTypes'] = array( 668 '', 669 'BINARY', 670 'UNSIGNED', 671 'UNSIGNED ZEROFILL' 672 ); 673 674 // Available functions 675 if ($cfg['ShowFunctionFields']) { 676 $cfg['Functions'] = array( 677 'ASCII', 678 'CHAR', 679 'SOUNDEX', 680 'LCASE', 681 'UCASE', 682 'NOW', 683 'PASSWORD', 684 'MD5', 685 'SHA1', 686 'ENCRYPT', 687 'RAND', 688 'LAST_INSERT_ID', 689 'COUNT', 690 'AVG', 691 'SUM', 692 'CURDATE', 693 'CURTIME', 694 'FROM_DAYS', 695 'FROM_UNIXTIME', 696 'PERIOD_ADD', 697 'PERIOD_DIFF', 698 'TO_DAYS', 699 'UNIX_TIMESTAMP', 700 'USER', 701 'WEEKDAY', 702 'CONCAT' 703 ); 704 705 // Which column types will be mapped to which Group? 706 $cfg['RestrictColumnTypes'] = array( 707 'VARCHAR' => 'FUNC_CHAR', 708 'TINYINT' => 'FUNC_NUMBER', 709 'TEXT' => 'FUNC_CHAR', 710 'DATE' => 'FUNC_DATE', 711 'SMALLINT' => 'FUNC_NUMBER', 712 'MEDIUMINT' => 'FUNC_NUMBER', 713 'INT' => 'FUNC_NUMBER', 714 'BIGINT' => 'FUNC_NUMBER', 715 'FLOAT' => 'FUNC_NUMBER', 716 'DOUBLE' => 'FUNC_NUMBER', 717 'DECIMAL' => 'FUNC_NUMBER', 718 'DATETIME' => 'FUNC_DATE', 719 'TIMESTAMP' => 'FUNC_DATE', 720 'TIME' => 'FUNC_DATE', 721 'YEAR' => 'FUNC_DATE', 722 'CHAR' => 'FUNC_CHAR', 723 'TINYBLOB' => 'FUNC_CHAR', 724 'TINYTEXT' => 'FUNC_CHAR', 725 'BLOB' => 'FUNC_CHAR', 726 'MEDIUMBLOB' => 'FUNC_CHAR', 727 'MEDIUMTEXT' => 'FUNC_CHAR', 728 'LONGBLOB' => 'FUNC_CHAR', 729 'LONGTEXT' => 'FUNC_CHAR', 730 'ENUM' => '', 731 'SET' => '' 732 ); 733 734 // Map above defined groups to any function 735 $cfg['RestrictFunctions'] = array( 736 'FUNC_CHAR' => array( 737 'ASCII', 738 'CHAR', 739 'SOUNDEX', 740 'LCASE', 741 'UCASE', 742 'PASSWORD', 743 'MD5', 744 'SHA1', 745 'ENCRYPT', 746 'LAST_INSERT_ID', 747 'USER', 748 'CONCAT' 749 ), 750 751 'FUNC_DATE' => array( 752 'NOW', 753 'CURDATE', 754 'CURTIME', 755 'FROM_DAYS', 756 'FROM_UNIXTIME', 757 'PERIOD_ADD', 758 'PERIOD_DIFF', 759 'TO_DAYS', 760 'UNIX_TIMESTAMP', 761 'WEEKDAY' 762 ), 763 764 'FUNC_NUMBER' => array( 765 'ASCII', 766 'CHAR', 767 'MD5', 768 'SHA1', 769 'ENCRYPT', 770 'RAND', 771 'LAST_INSERT_ID', 772 'UNIX_TIMESTAMP', 773 'COUNT', 774 'AVG', 775 'SUM' 776 ) 777 ); 778 779 // Default functions for above defined groups 780 $cfg['DefaultFunctions'] = array( 781 'FUNC_CHAR' => '', 782 'FUNC_DATE' => '', 783 'FUNC_NUMBER' => '', 784 'first_timestamp' => 'NOW' 785 ); 786 787 788 } // end if 789 790 // Search operators 791 $cfg['NumOperators'] = array( 792 '=', 793 '>', 794 '>=', 795 '<', 796 '<=', 797 '!=', 798 'LIKE', 799 'NOT LIKE' 800 ); 801 802 $cfg['TextOperators'] = array( 803 'LIKE', 804 'LIKE %...%', 805 'NOT LIKE', 806 '=', 807 '!=', 808 'REGEXP', 809 'NOT REGEXP' 810 ); 811 812 $cfg['EnumOperators'] = array( 813 '=', 814 '!=' 815 ); 816 817 $cfg['NullOperators'] = array( 818 'IS NULL', 819 'IS NOT NULL' 820 ); 821 822 $cfg['UnaryOperators'] = array( 823 'IS NULL' => 1, 824 'IS NOT NULL' => 1 825 ); 826 827 /** 828 * Unset magic_quotes_runtime - do not change! 829 */ 830 set_magic_quotes_runtime(0); 831 832 /** 833 * File Revision - do not change either! 834 */ 835 $cfg['FileRevision'] = '$Revision: 2.48 $'; 836 ?> 837 <?php 838 /* $Id: config.inc.php,v 2.48 2004/12/28 12:48:27 nijel Exp $ */ 839 // vim: expandtab sw=4 ts=4 sts=4: 840 841 /** 842 * phpMyAdmin Configuration File 843 * 844 * All directives are explained in Documentation.html 845 */ 846 847 848 /** 849 * Sets the php error reporting - Please do not change this line! 850 */ 851 if (!isset($old_error_reporting)) { 852 error_reporting(E_ALL); 853 @ini_set('display_errors', '1'); 854 } 855 856 857 /** 858 * Your phpMyAdmin url 859 * 860 * Complete the variable below with the full url ie 861 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/ 862 * 863 * It must contain characters that are valid for a URL, and the path is 864 * case sensitive on some Web servers, for example Unix-based servers. 865 * 866 * In most cases you can leave this variable empty, as the correct value 867 * will be detected automatically. However, we recommend that you do 868 * test to see that the auto-detection code works in your system. A good 869 * test is to browse a table, then edit a row and save it. There will be 870 * an error message if phpMyAdmin cannot auto-detect the correct value. 871 * 872 * If the auto-detection code does work properly, you can set to TRUE the 873 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below. 874 */ 875 $cfg['PmaAbsoluteUri'] = ''; 876 877 878 /** 879 * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set 880 * You should use this if and ONLY if the PmaAbsoluteUri auto-detection 881 * works perfectly. 882 */ 883 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE; 884 885 /** 886 * Disable the default warning that is displayed on the DB Details Structure page if 887 * any of the required Tables for the relationfeatures could not be found 888 */ 889 $cfg['PmaNoRelation_DisableWarning'] = FALSE; 890 891 /** 892 * The 'cookie' auth_type uses blowfish algorithm to encrypt the password. If 893 * at least one server configuration uses 'cookie' auth_type, enter here a 894 * passphrase that will be used by blowfish. 895 */ 896 $cfg['blowfish_secret'] = ''; 897 898 /** 899 * Server(s) configuration 900 */ 901 $i = 0; 902 // The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0]. 903 // You can disable a server config entry by setting host to ''. 904 $i++; 905 $cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname or IP address 906 $cfg['Servers'][$i]['port'] = ''; // MySQL port - leave blank for default port 907 $cfg['Servers'][$i]['socket'] = ''; // Path to the socket - leave blank for default socket 908 $cfg['Servers'][$i]['connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket') 909 $cfg['Servers'][$i]['extension'] = 'mysql'; // The php MySQL extension to use ('mysql' or 'mysqli') 910 $cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection 911 // (requires PHP >= 4.3.0) 912 $cfg['Servers'][$i]['controluser'] = ''; // MySQL control user settings 913 // (this user must have read-only 914 $cfg['Servers'][$i]['controlpass'] = ''; // access to the "mysql/user" 915 // and "mysql/db" tables). 916 // The controluser is also 917 // used for all relational 918 // features (pmadb) 919 $cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)? 920 $cfg['Servers'][$i]['user'] = 'root'; // MySQL user 921 $cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed 922 // with 'config' auth_type) 923 $cfg['Servers'][$i]['only_db'] = ''; // If set to a db-name, only 924 // this db is displayed in left frame 925 // It may also be an array of db-names, where sorting order is relevant. 926 $cfg['Servers'][$i]['verbose'] = ''; // Verbose name for this host - leave blank to show the hostname 927 928 $cfg['Servers'][$i]['pmadb'] = ''; // Database used for Relation, Bookmark and PDF Features 929 // (see scripts/create_tables.sql) 930 // - leave blank for no support 931 // DEFAULT: 'phpmyadmin' 932 $cfg['Servers'][$i]['bookmarktable'] = ''; // Bookmark table 933 // - leave blank for no bookmark support 934 // DEFAULT: 'pma_bookmark' 935 $cfg['Servers'][$i]['relation'] = ''; // table to describe the relation between links (see doc) 936 // - leave blank for no relation-links support 937 // DEFAULT: 'pma_relation' 938 $cfg['Servers'][$i]['table_info'] = ''; // table to describe the display fields 939 // - leave blank for no display fields support 940 // DEFAULT: 'pma_table_info' 941 $cfg['Servers'][$i]['table_coords'] = ''; // table to describe the tables position for the PDF schema 942 // - leave blank for no PDF schema support 943 // DEFAULT: 'pma_table_coords' 944 $cfg['Servers'][$i]['pdf_pages'] = ''; // table to describe pages of relationpdf 945 // - leave blank if you don't want to use this 946 // DEFAULT: 'pma_pdf_pages' 947 $cfg['Servers'][$i]['column_info'] = ''; // table to store column information 948 // - leave blank for no column comments/mime types 949 // DEFAULT: 'pma_column_info' 950 $cfg['Servers'][$i]['history'] = ''; // table to store SQL history 951 // - leave blank for no SQL query history 952 // DEFAULT: 'pma_history' 953 $cfg['Servers'][$i]['verbose_check'] = TRUE; // set to FALSE if you know that your pma_* tables 954 // are up to date. This prevents compatibility 955 // checks and thereby increases performance. 956 $cfg['Servers'][$i]['AllowRoot'] = TRUE; // whether to allow root login 957 $cfg['Servers'][$i]['AllowDeny']['order'] // Host authentication order, leave blank to not use 958 = ''; 959 $cfg['Servers'][$i]['AllowDeny']['rules'] // Host authentication rules, leave blank for defaults 960 = array(); 961 962 963 $i++; 964 $cfg['Servers'][$i]['host'] = ''; 965 $cfg['Servers'][$i]['port'] = ''; 966 $cfg['Servers'][$i]['socket'] = ''; 967 $cfg['Servers'][$i]['connect_type'] = 'tcp'; 968 $cfg['Servers'][$i]['extension'] = 'mysql'; 969 $cfg['Servers'][$i]['compress'] = FALSE; 970 $cfg['Servers'][$i]['controluser'] = ''; 971 $cfg['Servers'][$i]['controlpass'] = ''; 972 $cfg['Servers'][$i]['auth_type'] = 'config'; 973 $cfg['Servers'][$i]['user'] = 'root'; 974 $cfg['Servers'][$i]['password'] = ''; 975 $cfg['Servers'][$i]['only_db'] = ''; 976 $cfg['Servers'][$i]['verbose'] = ''; 977 $cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql 978 $cfg['Servers'][$i]['bookmarktable'] = ''; // 'pma_bookmark' 979 $cfg['Servers'][$i]['relation'] = ''; // 'pma_relation' 980 $cfg['Servers'][$i]['table_info'] = ''; // 'pma_table_info' 981 $cfg['Servers'][$i]['table_coords'] = ''; // 'pma_table_coords' 982 $cfg['Servers'][$i]['pdf_pages'] = ''; // 'pma_pdf_pages' 983 $cfg['Servers'][$i]['column_info'] = ''; // 'pma_column_info' 984 $cfg['Servers'][$i]['history'] = ''; // 'pma_history' 985 $cfg['Servers'][$i]['verbose_check'] = TRUE; 986 $cfg['Servers'][$i]['AllowRoot'] = TRUE; 987 $cfg['Servers'][$i]['AllowDeny']['order'] 988 = ''; 989 $cfg['Servers'][$i]['AllowDeny']['rules'] 990 = array(); 991 992 $i++; 993 $cfg['Servers'][$i]['host'] = ''; 994 $cfg['Servers'][$i]['port'] = ''; 995 $cfg['Servers'][$i]['socket'] = ''; 996 $cfg['Servers'][$i]['connect_type'] = 'tcp'; 997 $cfg['Servers'][$i]['extension'] = 'mysql'; 998 $cfg['Servers'][$i]['compress'] = FALSE; 999 $cfg['Servers'][$i]['controluser'] = ''; 1000 $cfg['Servers'][$i]['controlpass'] = ''; 1001 $cfg['Servers'][$i]['auth_type'] = 'config'; 1002 $cfg['Servers'][$i]['user'] = 'root'; 1003 $cfg['Servers'][$i]['password'] = ''; 1004 $cfg['Servers'][$i]['only_db'] = ''; 1005 $cfg['Servers'][$i]['verbose'] = ''; 1006 $cfg['Servers'][$i]['pmadb'] = ''; // 'phpmyadmin' - see scripts/create_tables.sql 1007 $cfg['Servers'][$i]['bookmarktable'] = ''; // 'pma_bookmark' 1008 $cfg['Servers'][$i]['relation'] = ''; // 'pma_relation' 1009 $cfg['Servers'][$i]['table_info'] = ''; // 'pma_table_info' 1010 $cfg['Servers'][$i]['table_coords'] = ''; // 'pma_table_coords' 1011 $cfg['Servers'][$i]['pdf_pages'] = ''; // 'pma_pdf_pages' 1012 $cfg['Servers'][$i]['column_info'] = ''; // 'pma_column_info' 1013 $cfg['Servers'][$i]['history'] = ''; // 'pma_history' 1014 $cfg['Servers'][$i]['verbose_check'] = TRUE; 1015 $cfg['Servers'][$i]['AllowRoot'] = TRUE; 1016 1017 $cfg['Servers'][$i]['AllowDeny']['order'] 1018 = ''; 1019 $cfg['Servers'][$i]['AllowDeny']['rules'] 1020 = array(); 1021 1022 // If you have more than one server configured, you can set $cfg['ServerDefault'] 1023 // to any one of them to autoconnect to that server when phpMyAdmin is started, 1024 // or set it to 0 to be given a list of servers without logging in 1025 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be 1026 // set to that server. 1027 $cfg['ServerDefault'] = 1; // Default server (0 = no default server) 1028 $cfg['Server'] = ''; 1029 unset($cfg['Servers'][0]); 1030 1031 1032 /** 1033 * Other core phpMyAdmin settings 1034 */ 1035 $cfg['OBGzip'] = 'auto'; // use GZIP output buffering if possible (TRUE|FALSE|'auto') 1036 $cfg['PersistentConnections'] = FALSE; // use persistent connections to MySQL database 1037 $cfg['ExecTimeLimit'] = 300; // maximum execution time in seconds (0 for no limit) 1038 $cfg['SkipLockedTables'] = FALSE; // mark used tables, make possible to show 1039 // locked tables (since MySQL 3.23.30) 1040 $cfg['ShowSQL'] = TRUE; // show SQL queries as run 1041 $cfg['AllowUserDropDatabase'] = FALSE; // show a 'Drop database' link to normal users 1042 $cfg['Confirm'] = TRUE; // confirm 'DROP TABLE' & 'DROP DATABASE' 1043 $cfg['LoginCookieRecall'] = TRUE; // recall previous login in cookie auth. mode or not 1044 $cfg['LoginCookieValidity'] = 1800; // validity of cookie login (in seconds) 1045 $cfg['UseDbSearch'] = TRUE; // whether to enable the "database search" feature 1046 // or not 1047 $cfg['IgnoreMultiSubmitErrors'] = FALSE; // if set to true, PMA continues computing multiple-statement queries 1048 // even if one of the queries failed 1049 $cfg['VerboseMultiSubmit'] = TRUE; // if set to true, PMA will show the affected rows of EACH statement on 1050 // multiple-statement queries. See the read_dump.php file for hardcoded 1051 // defaults on how many queries a statement may contain! 1052 $cfg['AllowArbitraryServer'] = FALSE; // allow login to any user entered server in cookie based auth 1053 1054 // Left frame setup 1055 $cfg['LeftFrameLight'] = TRUE; // use a select-based menu and display only the 1056 // current tables in the left frame. 1057 $cfg['LeftFrameTableSeparator']= '__'; // Which string will be used to generate table prefixes 1058 // to split/nest tables into multiple categories 1059 $cfg['LeftFrameTableLevel'] = '1'; // How many sublevels should be displayed when splitting 1060 // up tables by the above Separator 1061 $cfg['ShowTooltip'] = TRUE; // display table comment as tooltip in left frame 1062 $cfg['ShowTooltipAliasDB'] = FALSE; // if ShowToolTip is enabled, this defines that table/db comments 1063 $cfg['ShowTooltipAliasTB'] = FALSE; // are shown (in the left menu and db_details_structure) instead of 1064 // table/db names. Setting ShowTooltipAliasTB to 'nested' will only 1065 // use the Aliases for nested descriptors, not the table itself. 1066 1067 $cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame 1068 $cfg['LeftDisplayServers'] = FALSE; // display server choice at top of left frame 1069 $cfg['DisplayServersList'] = FALSE; // server choice as links 1070 1071 // In the main frame, at startup... 1072 $cfg['ShowStats'] = TRUE; // allow to display statistics and space usage in 1073 // the pages about database details and table 1074 // properties 1075 $cfg['ShowMysqlInfo'] = FALSE; // whether to display the "MySQL runtime 1076 $cfg['ShowMysqlVars'] = FALSE; // information", "MySQL system variables", "PHP 1077 $cfg['ShowPhpInfo'] = FALSE; // information" and "change password" links for 1078 $cfg['ShowChgPassword'] = FALSE; // simple users or not 1079 $cfg['SuggestDBName'] = TRUE; // suggest a new DB name if possible (false = keep empty) 1080 1081 // In browse mode... 1082 $cfg['ShowBlob'] = FALSE; // display blob field contents 1083 $cfg['NavigationBarIconic'] = TRUE; // do not display text inside navigation bar buttons 1084 $cfg['ShowAll'] = FALSE; // allows to display all the rows 1085 $cfg['MaxRows'] = 30; // maximum number of rows to display 1086 $cfg['Order'] = 'ASC'; // default for 'ORDER BY' clause (valid 1087 // values are 'ASC', 'DESC' or 'SMART' -ie 1088 // descending order for fields of type 1089 // TIME, DATE, DATETIME & TIMESTAMP, 1090 // ascending order else-) 1091 1092 // In edit mode... 1093 $cfg['ProtectBinary'] = 'blob'; // disallow editing of binary fields 1094 // valid values are: 1095 // FALSE allow editing 1096 // 'blob' allow editing except for BLOB fields 1097 // 'all' disallow editing 1098 $cfg['ShowFunctionFields'] = TRUE; // Display the function fields in edit/insert mode 1099 $cfg['CharEditing'] = 'input'; 1100 // Which editor should be used for CHAR/VARCHAR fields: 1101 // input - allows limiting of input length 1102 // textarea - allows newlines in fields 1103 $cfg['InsertRows'] = 2; // How many rows can be inserted at one time 1104 1105 // For the export features... 1106 $cfg['ZipDump'] = TRUE; // Allow the use of zip/gzip/bzip 1107 $cfg['GZipDump'] = TRUE; // compression for 1108 $cfg['BZipDump'] = TRUE; // dump files 1109 $cfg['CompressOnFly'] = TRUE; // Will compress gzip/bzip2 exports on 1110 // fly without need for much memory. 1111 // If you encounter problems with 1112 // created gzip/bzip2 files disable 1113 // this feature. 1114 1115 // Tabs display settings 1116 $cfg['LightTabs'] = FALSE; // use graphically less intense menu tabs 1117 $cfg['PropertiesIconic'] = TRUE; // Use icons instead of text for the table display of a database (TRUE|FALSE|'both') 1118 $cfg['PropertiesNumColumns'] = 1; // How many columns should be used for table display of a database? 1119 // (a value larger than 1 results in some information being hidden) 1120 1121 $cfg['DefaultTabServer'] = 'main.php'; 1122 // Possible values: 1123 // 'main.php' = the welcome page 1124 // (recommended for multiuser setups) 1125 // 'server_databases.php' = list of databases 1126 // 'server_status.php' = runtime information 1127 // 'server_variables.php' = MySQL server variables 1128 // 'server_privileges.php' = user management 1129 // 'server_processlist.php' = process list 1130 $cfg['DefaultTabDatabase'] = 'db_details_structure.php'; 1131 // Possible values: 1132 // 'db_details_structure.php' = tables list 1133 // 'db_details.php' = sql form 1134 // 'db_search.php' = search query 1135 // 'db_operations.php' = operations on database 1136 $cfg['DefaultTabTable'] = 'tbl_properties_structure.php'; 1137 // Possible values: 1138 // 'tbl_properties_structure.php' = fields list 1139 // 'tbl_properties.php' = sql form 1140 // 'tbl_select.php = select page 1141 // 'tbl_change.php = insert row page 1142 1143 /** 1144 * Export defaults 1145 */ 1146 1147 $cfg['Export']['format'] = 'sql'; // sql/latex/excel/csv/xml/xls 1148 $cfg['Export']['compression'] = 'none'; // none/zip/gzip/bzip2 1149 1150 $cfg['Export']['asfile'] = FALSE; 1151 $cfg['Export']['onserver'] = FALSE; 1152 $cfg['Export']['onserver_overwrite'] = FALSE; 1153 $cfg['Export']['remember_file_template'] = TRUE; 1154 1155 $cfg['Export']['xls_columns'] = FALSE; 1156 $cfg['Export']['xls_null'] = 'NULL'; 1157 1158 $cfg['Export']['csv_columns'] = FALSE; 1159 $cfg['Export']['csv_null'] = 'NULL'; 1160 $cfg['Export']['csv_separator'] = ';'; 1161 $cfg['Export']['csv_enclosed'] = '"'; 1162 $cfg['Export']['csv_escaped'] = '\\'; 1163 $cfg['Export']['csv_terminated'] = 'AUTO'; 1164 $cfg['Export']['excel_columns'] = FALSE; 1165 $cfg['Export']['excel_null'] = 'NULL'; 1166 $cfg['Export']['excel_edition'] = 'win'; // win/mac 1167 1168 $cfg['Export']['latex_structure'] = TRUE; 1169 $cfg['Export']['latex_data'] = TRUE; 1170 $cfg['Export']['latex_columns'] = TRUE; 1171 $cfg['Export']['latex_relation'] = TRUE; 1172 $cfg['Export']['latex_comments'] = TRUE; 1173 $cfg['Export']['latex_mime'] = TRUE; 1174 $cfg['Export']['latex_null'] = '\textit{NULL}'; 1175 $cfg['Export']['latex_caption'] = TRUE; 1176 $cfg['Export']['latex_data_label'] = 'tab:__TABLE__-data'; 1177 $cfg['Export']['latex_structure_label'] = 'tab:__TABLE__-structure'; 1178 1179 $cfg['Export']['sql_structure'] = TRUE; 1180 $cfg['Export']['sql_data'] = TRUE; 1181 $cfg['Export']['sql_compat'] = 'NONE'; 1182 $cfg['Export']['sql_disable_fk'] = FALSE; 1183 $cfg['Export']['sql_use_transaction'] = FALSE; 1184 $cfg['Export']['sql_drop_database'] = FALSE; 1185 $cfg['Export']['sql_drop_table'] = FALSE; 1186 $cfg['Export']['sql_if_not_exists'] = FALSE; 1187 $cfg['Export']['sql_auto_increment'] = TRUE; 1188 $cfg['Export']['sql_backquotes'] = TRUE; 1189 $cfg['Export']['sql_dates'] = FALSE; 1190 $cfg['Export']['sql_relation'] = FALSE; 1191 $cfg['Export']['sql_columns'] = FALSE; 1192 $cfg['Export']['sql_delayed'] = FALSE; 1193 $cfg['Export']['sql_ignore'] = FALSE; 1194 $cfg['Export']['sql_hex_for_binary'] = TRUE; 1195 $cfg['Export']['sql_type'] = 'insert'; // insert/update/replace 1196 $cfg['Export']['sql_extended'] = FALSE; 1197 $cfg['Export']['sql_comments'] = FALSE; 1198 $cfg['Export']['sql_mime'] = FALSE; 1199 $cfg['Export']['sql_header_comment'] = ''; // \n is replaced by new line 1200 1201 /** 1202 * Link to the official MySQL documentation. 1203 * Be sure to include no trailing slash on the path. 1204 * See http://dev.mysql.com/doc/ for more information 1205 * about MySQL manuals and their types. 1206 */ 1207 $cfg['MySQLManualBase'] = 'http://dev.mysql.com/doc/mysql/en'; 1208 1209 /** 1210 * Type of MySQL documentation: 1211 * old - old style used in phpMyAdmin 2.3.0 and sooner 1212 * searchable - "Searchable, with user comments" 1213 * chapters - "HTML, one page per chapter" 1214 * big - "HTML, all on one page" 1215 * none - do not show documentation links 1216 */ 1217 $cfg['MySQLManualType'] = 'searchable'; 1218 1219 1220 /** 1221 * PDF options 1222 */ 1223 $cfg['PDFPageSizes'] = array('A3', 'A4', 'A5', 'letter', 'legal'); 1224 $cfg['PDFDefaultPageSize'] = 'A4'; 1225 1226 1227 /** 1228 * Language and charset conversion settings 1229 */ 1230 // Default language to use, if not browser-defined or user-defined 1231 $cfg['DefaultLang'] = 'en-iso-8859-1'; 1232 1233 // Force: always use this language - must be defined in 1234 // libraries/select_lang.lib.php 1235 // $cfg['Lang'] = 'en-iso-8859-1'; 1236 1237 // Default charset to use for recoding of MySQL queries, does not take 1238 // any effect when charsets recoding is switched off by 1239 // $cfg['AllowAnywhereRecoding'] or in language file 1240 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own) 1241 $cfg['DefaultCharset'] = 'iso-8859-1'; 1242 1243 // Allow charset recoding of MySQL queries, must be also enabled in language 1244 // file to make harder using other language files than unicode. 1245 // Default value is FALSE to avoid problems on servers without the iconv 1246 // extension and where dl() is not supported 1247 $cfg['AllowAnywhereRecoding'] = FALSE; 1248 1249 // You can select here which functions will be used for charset conversion. 1250 // Possible values are: 1251 // auto - automatically use available one (first is tested iconv, then 1252 // recode) 1253 // iconv - use iconv or libiconv functions 1254 // recode - use recode_string function 1255 $cfg['RecodingEngine'] = 'auto'; 1256 1257 // Specify some parameters for iconv used in charset conversion. See iconv 1258 // documentation for details: 1259 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html 1260 $cfg['IconvExtraParams'] = ''; 1261 1262 // Available charsets for MySQL conversion. currently contains all which could 1263 // be found in lang/* files and few more. 1264 // Charsets will be shown in same order as here listed, so if you frequently 1265 // use some of these move them to the top. 1266 $cfg['AvailableCharsets'] = array( 1267 'iso-8859-1', 1268 'iso-8859-2', 1269 'iso-8859-3', 1270 'iso-8859-4', 1271 'iso-8859-5', 1272 'iso-8859-6', 1273 'iso-8859-7', 1274 'iso-8859-8', 1275 'iso-8859-9', 1276 'iso-8859-10', 1277 'iso-8859-11', 1278 'iso-8859-12', 1279 'iso-8859-13', 1280 'iso-8859-14', 1281 'iso-8859-15', 1282 'windows-1250', 1283 'windows-1251', 1284 'windows-1252', 1285 'windows-1256', 1286 'windows-1257', 1287 'koi8-r', 1288 'big5', 1289 'gb2312', 1290 'utf-8', 1291 'utf-7', 1292 'x-user-defined', 1293 'euc-jp', 1294 'ks_c_5601-1987', 1295 'tis-620', 1296 'SHIFT_JIS' 1297 ); 1298 1299 /** 1300 * Customization & design 1301 * 1302 * The graphical settings are now located in themes/themename/layout.inc.php 1303 */ 1304 1305 $cfg['LeftPointerEnable'] = TRUE; // enable the left panel pointer 1306 // (used when LeftFrameLight is FALSE) 1307 // see also LeftPointerColor 1308 // in layout.inc.php 1309 1310 $cfg['BrowsePointerEnable'] = TRUE; // enable the browse pointer 1311 // see also BrowsePointerColor 1312 // in layout.inc.php 1313 1314 $cfg['BrowseMarkerEnable'] = TRUE; // enable the browse marker 1315 // see also BrowseMarkerColor 1316 // in layout.inc.php 1317 1318 $cfg['TextareaCols'] = 40; // textarea size (columns) in edit mode 1319 // (this value will be emphasized (*2) for sql 1320 // query textareas and (*1.25) for query window) 1321 $cfg['TextareaRows'] = 7; // textarea size (rows) in edit mode 1322 $cfg['LongtextDoubleTextarea'] = TRUE; // double size of textarea size for longtext fields 1323 $cfg['TextareaAutoSelect'] = TRUE; // autoselect when clicking in the textarea of the querybox 1324 $cfg['CharTextareaCols'] = 40; // textarea size (columns) for CHAR/VARCHAR 1325 $cfg['CharTextareaRows'] = 2; // textarea size (rows) for CHAR/VARCHAR 1326 $cfg['CtrlArrowsMoving'] = TRUE; // Enable Ctrl+Arrows moving between fields when editing? 1327 $cfg['LimitChars'] = 50; // Max field data length in browse mode for all non-numeric fields 1328 $cfg['ModifyDeleteAtLeft'] = TRUE; // show edit/delete links on left side of browse 1329 // (or at the top with vertical browse) 1330 $cfg['ModifyDeleteAtRight'] = FALSE; // show edit/delete links on right side of browse 1331 // (or at the bottom with vertical browse) 1332 $cfg['DefaultDisplay'] = 'horizontal'; // default display direction 1333 // (horizontal|vertical|horizontalflipped) 1334 $cfg['DefaultPropDisplay'] = 'horizontal'; // default display direction for altering/ 1335 // creating columns (tbl_properties) 1336 // (horizontal|vertical) 1337 1338 $cfg['HeaderFlipType'] = 'css'; // table-header rotation via faking or css? (css|fake) 1339 // NOTE: CSS only works in IE browsers! 1340 $cfg['ShowBrowseComments'] = TRUE; // shows stored relation-comments in 'browse' mode. 1341 $cfg['ShowPropertyComments']= TRUE; // shows stored relation-comments in 'table property' mode. 1342 $cfg['RepeatCells'] = 100; // repeat header names every X cells? (0 = deactivate) 1343 1344 $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. 1345 $cfg['QueryFrameJS'] = TRUE; // whether to use JavaScript functions for opening a new window for SQL commands. 1346 // if set to 'false', the target of the querybox is always the right frame. 1347 $cfg['QueryWindowWidth'] = 550; // Width of Query window 1348 $cfg['QueryWindowHeight'] = 310; // Height of Query window 1349 $cfg['QueryHistoryDB'] = FALSE; // Set to TRUE if you want DB-based query history. 1350 // If FALSE, this utilizes JS-routines to display 1351 // query history (lost by window close) 1352 $cfg['QueryWindowDefTab'] = 'sql'; // which tab to display in the querywindow on startup 1353 // (sql|files|history|full) 1354 $cfg['QueryHistoryMax'] = 25; // When using DB-based query history, how many entries 1355 // should be kept? 1356 $cfg['BrowseMIME'] = TRUE; // Use MIME-Types (stored in column comments table) for 1357 $cfg['MaxExactCount'] = 20000; // When approximate count < this, PMA will get exact count for 1358 // table rows. 1359 $cfg['WYSIWYG-PDF'] = TRUE; // Utilize DHTML/JS capabilities to allow WYSIWYG editing of 1360 // the PDF page editor. Requires an IE6/Mozilla based browser. 1361 1362 $cfg['NaturalOrder'] = TRUE; // Sort table and database in natural order 1363 1364 1365 //----------------------------------------------------------------------------- 1366 // custom-setup by mkkeck: 2004-05-04 1367 // some specials for new icons and scrollings 1368 // FIXME: 1369 // 2004-05-08 rabus: We need to rearrange these variables. 1370 1371 $cfg['ShowHttpHostTitle'] = TRUE; // show HttpHost in browsers window title (true|false)? 1372 $cfg['SetHttpHostTitle'] = ''; // if ShowHttpHostTitle=true, please set your host (server) 1373 // or an other string, wich should be shown in browsers window title. 1374 // If not set (or empty), the PMA will get your real Host-Adress. 1375 1376 $cfg['ErrorIconic'] = TRUE; // show some icons for warning, error and information messages (true|false)? 1377 $cfg['MainPageIconic'] = TRUE; // show icons in list on main page, on right panel top menu (server db table) and on menu tabs (true|false)? 1378 $cfg['ReplaceHelpImg'] = TRUE; // show help button instead of strDocumentation (true|false)? 1379 1380 // theme manager 1381 $cfg['ThemePath'] = './themes'; // using themes manager please set up here the path to 'themes' 1382 // else leave empty 1383 $cfg['ThemeManager'] = TRUE; // if you want to use selectable themes and if ThemesPath not empty 1384 // set it to true, else set it to false (default is false); 1385 $cfg['ThemeDefault'] = 'original'; // set up default theme, if ThemePath not empty 1386 // you can set up here an valid path to themes or 'original' for 1387 // the original pma-theme 1388 1389 //----------------------------------------------------------------------------- 1390 1391 1392 /** 1393 * Default queries 1394 * %d will be replaced by the database name. 1395 * %t will be replaced by the table name. 1396 * %f will be replaced by a list of field names. 1397 * (%t and %f only applies to DefaultQueryTable) 1398 */ 1399 $cfg['DefaultQueryTable'] = 'SELECT * FROM %t WHERE 1'; 1400 $cfg['DefaultQueryDatabase'] = ''; 1401 1402 /** 1403 * SQL Query box settings 1404 * These are the links display in all of the SQL Query boxes 1405 */ 1406 $cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query 1407 $cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries 1408 $cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP 1409 $cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well) 1410 $cfg['SQLQuery']['Refresh'] = TRUE; // Refresh the results page 1411 1412 1413 /** 1414 * Webserver upload/save/import directories 1415 */ 1416 $cfg['UploadDir'] = ''; // Directory for uploaded files that can be executed by 1417 // phpMyAdmin. For example './upload'. Leave empty for 1418 // no upload directory support 1419 $cfg['SaveDir'] = ''; // Directory where phpMyAdmin can save exported data on 1420 // server. For example './save'. Leave empty for no save 1421 // directory support. 1422 $cfg['docSQLDir'] = ''; // Directory for docSQL imports, phpMyAdmin can import 1423 // docSQL files from that directory. For example 1424 // './docSQL'. Leave empty for no docSQL import support. 1425 $cfg['TempDir'] = ''; // Directory where phpMyAdmin can save temporary files. 1426 // This is needed for MS Excel export, see documentation 1427 // how to enable that. 1428 1429 1430 /** 1431 * Misc. settings 1432 */ 1433 $cfg['GD2Available'] = 'auto'; // Is GD >= 2 available? Set to yes/no/auto. 'auto' 1434 // does autodetection, which is a bit expensive for 1435 // php < 4.3.0, but it is the only safe vay how to 1436 // determine GD version. 1437 /** 1438 * SQL Parser Settings 1439 */ 1440 $cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none) 1441 $cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok) 1442 $cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt}) 1443 // The graphical settings are now located in themes/themename/layout.inc.php 1444 1445 /** 1446 * If you wish to use the SQL Validator service, you should be 1447 * aware of the following: 1448 * All SQL statements are stored anonymously for statistical purposes. 1449 * Mimer SQL Validator, Copyright 2002 Upright Database Technology. 1450 * All rights reserved. 1451 */ 1452 $cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available 1453 $cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous) 1454 $cfg['SQLValidator']['password'] = ''; // Password for username 1455 1456 /** 1457 * Developers ONLY! 1458 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/ 1459 */ 1460 $cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available 1461 $cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP 1462 $cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display 1463 // Anything below the threshold is not displayed 1464 1465 1466 /** 1467 * MySQL settings 1468 */ 1469 // Column types; 1470 // varchar, tinyint, text and date are listed first, based on estimated popularity 1471 $cfg['ColumnTypes'] = array( 1472 'VARCHAR', 1473 'TINYINT', 1474 'TEXT', 1475 'DATE', 1476 'SMALLINT', 1477 'MEDIUMINT', 1478 'INT', 1479 'BIGINT', 1480 'FLOAT', 1481 'DOUBLE', 1482 'DECIMAL', 1483 'DATETIME', 1484 'TIMESTAMP', 1485 'TIME', 1486 'YEAR', 1487 'CHAR', 1488 'TINYBLOB', 1489 'TINYTEXT', 1490 'BLOB', 1491 'MEDIUMBLOB', 1492 'MEDIUMTEXT', 1493 'LONGBLOB', 1494 'LONGTEXT', 1495 'ENUM', 1496 'SET' 1497 ); 1498 1499 // Attributes 1500 $cfg['AttributeTypes'] = array( 1501 '', 1502 'BINARY', 1503 'UNSIGNED', 1504 'UNSIGNED ZEROFILL' 1505 ); 1506 1507 // Available functions 1508 if ($cfg['ShowFunctionFields']) { 1509 $cfg['Functions'] = array( 1510 'ASCII', 1511 'CHAR', 1512 'SOUNDEX', 1513 'LCASE', 1514 'UCASE', 1515 'NOW', 1516 'PASSWORD', 1517 'MD5', 1518 'SHA1', 1519 'ENCRYPT', 1520 'RAND', 1521 'LAST_INSERT_ID', 1522 'COUNT', 1523 'AVG', 1524 'SUM', 1525 'CURDATE', 1526 'CURTIME', 1527 'FROM_DAYS', 1528 'FROM_UNIXTIME', 1529 'PERIOD_ADD', 1530 'PERIOD_DIFF', 1531 'TO_DAYS', 1532 'UNIX_TIMESTAMP', 1533 'USER', 1534 'WEEKDAY', 1535 'CONCAT' 1536 ); 1537 1538 // Which column types will be mapped to which Group? 1539 $cfg['RestrictColumnTypes'] = array( 1540 'VARCHAR' => 'FUNC_CHAR', 1541 'TINYINT' => 'FUNC_NUMBER', 1542 'TEXT' => 'FUNC_CHAR', 1543 'DATE' => 'FUNC_DATE', 1544 'SMALLINT' => 'FUNC_NUMBER', 1545 'MEDIUMINT' => 'FUNC_NUMBER', 1546 'INT' => 'FUNC_NUMBER', 1547 'BIGINT' => 'FUNC_NUMBER', 1548 'FLOAT' => 'FUNC_NUMBER', 1549 'DOUBLE' => 'FUNC_NUMBER', 1550 'DECIMAL' => 'FUNC_NUMBER', 1551 'DATETIME' => 'FUNC_DATE', 1552 'TIMESTAMP' => 'FUNC_DATE', 1553 'TIME' => 'FUNC_DATE', 1554 'YEAR' => 'FUNC_DATE', 1555 'CHAR' => 'FUNC_CHAR', 1556 'TINYBLOB' => 'FUNC_CHAR', 1557 'TINYTEXT' => 'FUNC_CHAR', 1558 'BLOB' => 'FUNC_CHAR', 1559 'MEDIUMBLOB' => 'FUNC_CHAR', 1560 'MEDIUMTEXT' => 'FUNC_CHAR', 1561 'LONGBLOB' => 'FUNC_CHAR', 1562 'LONGTEXT' => 'FUNC_CHAR', 1563 'ENUM' => '', 1564 'SET' => '' 1565 ); 1566 1567 // Map above defined groups to any function 1568 $cfg['RestrictFunctions'] = array( 1569 'FUNC_CHAR' => array( 1570 'ASCII', 1571 'CHAR', 1572 'SOUNDEX', 1573 'LCASE', 1574 'UCASE', 1575 'PASSWORD', 1576 'MD5', 1577 'SHA1', 1578 'ENCRYPT', 1579 'LAST_INSERT_ID', 1580 'USER', 1581 'CONCAT' 1582 ), 1583 1584 'FUNC_DATE' => array( 1585 'NOW', 1586 'CURDATE', 1587 'CURTIME', 1588 'FROM_DAYS', 1589 'FROM_UNIXTIME', 1590 'PERIOD_ADD', 1591 'PERIOD_DIFF', 1592 'TO_DAYS', 1593 'UNIX_TIMESTAMP', 1594 'WEEKDAY' 1595 ), 1596 1597 'FUNC_NUMBER' => array( 1598 'ASCII', 1599 'CHAR', 1600 'MD5', 1601 'SHA1', 1602 'ENCRYPT', 1603 'RAND', 1604 'LAST_INSERT_ID', 1605 'UNIX_TIMESTAMP', 1606 'COUNT', 1607 'AVG', 1608 'SUM' 1609 ) 1610 ); 1611 1612 // Default functions for above defined groups 1613 $cfg['DefaultFunctions'] = array( 1614 'FUNC_CHAR' => '', 1615 'FUNC_DATE' => '', 1616 'FUNC_NUMBER' => '', 1617 'first_timestamp' => 'NOW' 1618 ); 1619 1620 1621 } // end if 1622 1623 // Search operators 1624 $cfg['NumOperators'] = array( 1625 '=', 1626 '>', 1627 '>=', 1628 '<', 1629 '<=', 1630 '!=', 1631 'LIKE', 1632 'NOT LIKE' 1633 ); 1634 1635 $cfg['TextOperators'] = array( 1636 'LIKE', 1637 'LIKE %...%', 1638 'NOT LIKE', 1639 '=', 1640 '!=', 1641 'REGEXP', 1642 'NOT REGEXP' 1643 ); 1644 1645 $cfg['EnumOperators'] = array( 1646 '=', 1647 '!=' 1648 ); 1649 1650 $cfg['NullOperators'] = array( 1651 'IS NULL', 1652 'IS NOT NULL' 1653 ); 1654 1655 $cfg['UnaryOperators'] = array( 1656 'IS NULL' => 1, 1657 'IS NOT NULL' => 1 1658 ); 1659 1660 /** 1661 * Unset magic_quotes_runtime - do not change! 1662 */ 1663 set_magic_quotes_runtime(0); 1664 1665 /** 1666 * File Revision - do not change either! 1667 */ 1668 $cfg['FileRevision'] = '$Revision: 2.48 $'; 1669 ?>
Testing
