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