config.inc.php3

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 /**
   6  * phpMyAdmin Configuration File
   7  *
   8  * All directives are explained in Documentation.html
   9  */
  10
  11
  12 /**
  13  * Sets the php error reporting - Please do not change this line!
  14  */
  15 if (!isset($old_error_reporting)) {
  16     error_reporting(E_ALL);
  17     @ini_set('display_errors', '1');
  18 }
  19
  20
  21 /**
  22  * Your phpMyAdmin url
  23  *
  24  * Complete the variable below with the full url ie
  25  *    http://www.your_web.net/path_to_your_phpMyAdmin_directory/
  26  *
  27  * It must contain characters that are valid for a URL, and the path is
  28  * case sensitive on some Web servers, for example Unix-based servers.
  29  *
  30  * In most cases you can leave this variable empty, as the correct value
  31  * will be detected automatically. However, we recommend that you do
  32  * test to see that the auto-detection code works in your system. A good
  33  * test is to browse a table, then edit a row and save it.  There will be
  34  * an error message if phpMyAdmin cannot auto-detect the correct value.
  35  *
  36  * If the auto-detection code does work properly, you can set to TRUE the
  37  * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
  38  */
  39 $cfg['PmaAbsoluteUri'] = '';
  40
  41
  42 /**
  43  * Disable the default warning about $cfg['PmaAbsoluteUri'] not being set
  44  * You should use this if and ONLY if the PmaAbsoluteUri auto-detection
  45  * works perfectly.
  46  */
  47 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
  48
  49 /**
  50  * Disable the default warning that is displayed on the DB Details Structure page if
  51  * any of the required Tables for the relationfeatures could not be found
  52  */
  53 $cfg['PmaNoRelation_DisableWarning']  = FALSE;
  54
  55
  56 /**
  57  * Server(s) configuration
  58  */
  59 $i = 0;
  60 // The $cfg['Servers'] array starts with $cfg['Servers'][1].  Do not use $cfg['Servers'][0].
  61 // You can disable a server config entry by setting host to ''.
  62 $i++;
  63 $cfg['Servers'][$i]['host']          = 'localhost'; // MySQL hostname
  64 $cfg['Servers'][$i]['port']          = '';          // MySQL port - leave blank for default port
  65 $cfg['Servers'][$i]['socket']        = '';          // Path to the socket - leave blank for default socket
  66 $cfg['Servers'][$i]['connect_type']  = 'tcp';       // How to connect to MySQL server ('tcp' or 'socket')
  67 $cfg['Servers'][$i]['compress']      = FALSE;       // Use compressed protocol for the MySQL connection
  68                                                     // (requires PHP >= 4.3.0)
  69 $cfg['Servers'][$i]['controluser']   = '';          // MySQL control user settings
  70                                                     // (this user must have read-only
  71 $cfg['Servers'][$i]['controlpass']   = '';          // access to the "mysql/user"
  72                                                     // and "mysql/db" tables)
  73 $cfg['Servers'][$i]['auth_type']     = 'config';    // Authentication method (config, http or cookie based)?
  74 $cfg['Servers'][$i]['user']          = 'root';      // MySQL user
  75 $cfg['Servers'][$i]['password']      = '';          // MySQL password (only needed
  76                                                     // with 'config' auth_type)
  77 $cfg['Servers'][$i]['only_db']       = '';          // If set to a db-name, only
  78                                                     // this db is displayed
  79                                                     // at left frame
  80                                                     // It may also be an array
  81                                                     // of db-names
  82 $cfg['Servers'][$i]['verbose']       = '';          // Verbose name for this host - leave blank to show the hostname
  83
  84 $cfg['Servers'][$i]['pmadb']         = '';          // Database used for Relation, Bookmark and PDF Features
  85                                                     // (see scripts/create_tables.sql)
  86                                                     //   - leave blank for no support
  87                                                     //     DEFAULT: 'phpmyadmin'
  88 $cfg['Servers'][$i]['bookmarktable'] = '';          // Bookmark table
  89                                                     //   - leave blank for no bookmark support
  90                                                     //     DEFAULT: 'PMA_bookmark'
  91 $cfg['Servers'][$i]['relation']      = '';          // table to describe the relation between links (see doc)
  92                                                     //   - leave blank for no relation-links support
  93                                                     //     DEFAULT: 'PMA_relation'
  94 $cfg['Servers'][$i]['table_info']    = '';          // table to describe the display fields
  95                                                     //   - leave blank for no display fields support
  96                                                     //     DEFAULT: 'PMA_table_info'
  97 $cfg['Servers'][$i]['table_coords']  = '';          // table to describe the tables position for the PDF schema
  98                                                     //   - leave blank for no PDF schema support
  99                                                     //     DEFAULT: 'PMA_table_coords'
 100 $cfg['Servers'][$i]['pdf_pages']     = '';          // table to describe pages of relationpdf
 101                                                     //   - leave blank if you don't want to use this
 102                                                     //     DEFAULT: 'PMA_pdf_pages'
 103 $cfg['Servers'][$i]['column_info']   = '';          // table to store column information
 104                                                     //   - leave blank for no column comments/mime types
 105                                                     //     DEFAULT: 'PMA_column_info'
 106 $cfg['Servers'][$i]['history']       = '';          // table to store SQL history
 107                                                     //   - leave blank for no SQL query history
 108                                                     //     DEFAULT: 'PMA_history'
 109 $cfg['Servers'][$i]['verbose_check'] = TRUE;        // set to FALSE if you know that your PMA_* tables
 110                                                     // are up to date. This prevents compatibility
 111                                                     // checks and thereby increases performance.
 112 $cfg['Servers'][$i]['AllowDeny']['order']           // Host authentication order, leave blank to not use
 113                                      = '';
 114 $cfg['Servers'][$i]['AllowDeny']['rules']           // Host authentication rules, leave blank for defaults
 115                                      = array();
 116
 117
 118 $i++;
 119 $cfg['Servers'][$i]['host']            = '';
 120 $cfg['Servers'][$i]['port']            = '';
 121 $cfg['Servers'][$i]['socket']          = '';
 122 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 123 $cfg['Servers'][$i]['compress']        = FALSE;
 124 $cfg['Servers'][$i]['controluser']     = '';
 125 $cfg['Servers'][$i]['controlpass']     = '';
 126 $cfg['Servers'][$i]['auth_type']       = 'config';
 127 $cfg['Servers'][$i]['user']            = 'root';
 128 $cfg['Servers'][$i]['password']        = '';
 129 $cfg['Servers'][$i]['only_db']         = '';
 130 $cfg['Servers'][$i]['verbose']         = '';
 131 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
 132 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'PMA_bookmark'
 133 $cfg['Servers'][$i]['relation']        = ''; // 'PMA_relation'
 134 $cfg['Servers'][$i]['table_info']      = ''; // 'PMA_table_info'
 135 $cfg['Servers'][$i]['table_coords']    = ''; // 'PMA_table_coords'
 136 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'PMA_pdf_page'
 137 $cfg['Servers'][$i]['column_info']     = ''; // 'PMA_column_info'
 138 $cfg['Servers'][$i]['history']         = ''; // 'PMA_history'
 139 $cfg['Servers'][$i]['verbose_check']   = TRUE;
 140 $cfg['Servers'][$i]['AllowDeny']['order']
 141                                        = '';
 142 $cfg['Servers'][$i]['AllowDeny']['rules']
 143                                        = array();
 144
 145 $i++;
 146 $cfg['Servers'][$i]['host']            = '';
 147 $cfg['Servers'][$i]['port']            = '';
 148 $cfg['Servers'][$i]['socket']          = '';
 149 $cfg['Servers'][$i]['connect_type']    = 'tcp';
 150 $cfg['Servers'][$i]['compress']        = FALSE;
 151 $cfg['Servers'][$i]['controluser']     = '';
 152 $cfg['Servers'][$i]['controlpass']     = '';
 153 $cfg['Servers'][$i]['auth_type']       = 'config';
 154 $cfg['Servers'][$i]['user']            = 'root';
 155 $cfg['Servers'][$i]['password']        = '';
 156 $cfg['Servers'][$i]['only_db']         = '';
 157 $cfg['Servers'][$i]['verbose']         = '';
 158 $cfg['Servers'][$i]['pmadb']           = ''; // 'phpmyadmin' - see scripts/create_tables.sql
 159 $cfg['Servers'][$i]['bookmarktable']   = ''; // 'PMA_bookmark'
 160 $cfg['Servers'][$i]['relation']        = ''; // 'PMA_relation'
 161 $cfg['Servers'][$i]['table_info']      = ''; // 'PMA_table_info'
 162 $cfg['Servers'][$i]['table_coords']    = ''; // 'PMA_table_coords'
 163 $cfg['Servers'][$i]['pdf_pages']       = ''; // 'PMA_pdf_page'
 164 $cfg['Servers'][$i]['column_info']     = ''; // 'PMA_column_info'
 165 $cfg['Servers'][$i]['history']         = ''; // 'PMA_history'
 166 $cfg['Servers'][$i]['verbose_check']   = TRUE;
 167 $cfg['Servers'][$i]['AllowDeny']['order']
 168                                        = '';
 169 $cfg['Servers'][$i]['AllowDeny']['rules']
 170                                        = array();
 171
 172 // If you have more than one server configured, you can set $cfg['ServerDefault']
 173 // to any one of them to autoconnect to that server when phpMyAdmin is started,
 174 // or set it to 0 to be given a list of servers without logging in
 175 // If you have only one server configured, $cfg['ServerDefault'] *MUST* be
 176 // set to that server.
 177 $cfg['ServerDefault'] = 1;              // Default server (0 = no default server)
 178 $cfg['Server']        = '';
 179 unset($cfg['Servers'][0]);
 180
 181
 182 /**
 183  * Other core phpMyAdmin settings
 184  */
 185 $cfg['OBGzip']                = TRUE;   // use GZIP output buffering if possible
 186 $cfg['PersistentConnections'] = FALSE;  // use persistent connections to MySQL database
 187 $cfg['ExecTimeLimit']         = 300;    // maximum execution time in seconds (0 for no limit)
 188 $cfg['SkipLockedTables']      = FALSE;  // mark used tables, make possible to show
 189                                         // locked tables (since MySQL 3.23.30)
 190 $cfg['ShowSQL']               = TRUE;   // show SQL queries as run
 191 $cfg['AllowUserDropDatabase'] = FALSE;  // show a 'Drop database' link to normal users
 192 $cfg['Confirm']               = TRUE;   // confirm 'DROP TABLE' & 'DROP DATABASE'
 193 $cfg['LoginCookieRecall']     = TRUE;   // recall previous login in cookie auth. mode or not
 194 $cfg['UseDbSearch']           = TRUE;   // whether to enable the "database search" feature
 195                                         // or not
 196
 197 // Left frame setup
 198 $cfg['LeftFrameLight']        = TRUE;   // use a select-based menu and display only the
 199                                         // current tables in the left frame.
 200 $cfg['ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
 201 $cfg['ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
 202 $cfg['ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
 203                                         // table/db names
 204
 205 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
 206
 207 // In the main frame, at startup...
 208 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 209                                         // the pages about database details and table
 210                                         // properties
 211 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
 212 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
 213 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
 214 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
 215 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 216
 217 // In browse mode...
 218 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 219 $cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
 220 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 221 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 222 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 223                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 224                                         // descending order for fields of type
 225                                         // TIME, DATE, DATETIME & TIMESTAMP,
 226                                         // ascending order else-)
 227
 228 // In edit mode...
 229 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 230                                         // valid values are:
 231                                         //   FALSE  allow editing
 232                                         //   'blob' allow editing except for BLOB fields
 233                                         //   'all'  disallow editing
 234 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 235 $cfg['CharEditing']           = 'input';
 236                                         // Which editor should be used for CHAR/VARCHAR fields:
 237                                         //  input - allows limiting of input length
 238                                         //  textarea - allows newlines in fields
 239
 240 // For the export features...
 241 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 242 $cfg['GZipDump']              = TRUE;   // compression for
 243 $cfg['BZipDump']              = TRUE;   // dump files
 244
 245 // Tabs display settings
 246 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
 247 $cfg['DefaultTabServer']      = 'main.php3';
 248                                    // Possible values:
 249                                    // 'main.php3' = the welcome page
 250                                    // (recommended for multiuser setups)
 251                                    // 'server_databases.php3' = list of databases
 252                                    // 'server_status.php3' = runtime information
 253                                    // 'server_variables.php3' = MySQL server variables
 254                                    // 'server_privileges.php3' = user management
 255                                    // 'server_processlist.php3' = process list
 256 $cfg['DefaultTabDatabase']    = 'db_details_structure.php3';
 257                                    // Possible values:
 258                                    // 'db_details_structure.php3' = tables list
 259                                    // 'db_details.php3' = sql form
 260                                    // 'db_search.php3' = search query
 261 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php3';
 262                                    // Possible values:
 263                                    // 'tbl_properties_structure.php3' = fields list
 264                                    // 'tbl_properties.php3' = sql form
 265                                    // 'tbl_select.php3 = select page
 266                                    // 'tbl_change.php3 = insert row page
 267
 268
 269 /**
 270  * Link to the official MySQL documentation.
 271  * Be sure to include no trailing slash on the path.
 272  * See http://www.mysql.com/documentation/index.html for more information
 273  * about MySQL manuals and their types.
 274  */
 275 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
 276
 277 /**
 278  * Type of MySQL documentation:
 279  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
 280  *   searchable - "Searchable, with user comments"
 281  *   chapters   - "HTML, one page per chapter"
 282  *   big        - "HTML, all on one page"
 283  *   none       - do not show documentation links
 284  */
 285 $cfg['MySQLManualType'] = 'searchable';
 286
 287
 288 /**
 289  * Language and charset conversion settings
 290  */
 291 // Default language to use, if not browser-defined or user-defined
 292 $cfg['DefaultLang'] = 'en-iso-8859-1';
 293
 294 // Force: always use this language - must be defined in
 295 //        libraries/select_lang.lib.php3
 296 // $cfg['Lang']     = 'en-iso-8859-1';
 297
 298 // Default charset to use for recoding of MySQL queries, does not take
 299 // any effect when charsets recoding is switched off by
 300 // $cfg['AllowAnywhereRecoding'] or in language file
 301 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 302 $cfg['DefaultCharset'] = 'iso-8859-1';
 303
 304 // Allow charset recoding of MySQL queries, must be also enabled in language
 305 // file to make harder using other language files than unicode.
 306 // Default value is FALSE to avoid problems on servers without the iconv
 307 // extension and where dl() is not supported
 308 $cfg['AllowAnywhereRecoding'] = FALSE;
 309
 310 // You can select here which functions will be used for charset conversion.
 311 // Possible values are:
 312 //      auto   - automatically use available one (first is tested iconv, then
 313 //               recode)
 314 //      iconv  - use iconv or libiconv functions
 315 //      recode - use recode_string function
 316 $cfg['RecodingEngine'] = 'auto';
 317
 318 // Available charsets for MySQL conversion. currently contains all which could
 319 // be found in lang/* files and few more.
 320 // Charsets will be shown in same order as here listed, so if you frequently
 321 // use some of these move them to the top.
 322 $cfg['AvailableCharsets'] = array(
 323     'iso-8859-1',
 324     'iso-8859-2',
 325     'iso-8859-3',
 326     'iso-8859-4',
 327     'iso-8859-5',
 328     'iso-8859-6',
 329     'iso-8859-7',
 330     'iso-8859-8',
 331     'iso-8859-9',
 332     'iso-8859-10',
 333     'iso-8859-11',
 334     'iso-8859-12',
 335     'iso-8859-13',
 336     'iso-8859-14',
 337     'iso-8859-15',
 338     'windows-1250',
 339     'windows-1251',
 340     'windows-1252',
 341     'windows-1257',
 342     'koi8-r',
 343     'big5',
 344     'gb2312',
 345     'utf-8',
 346     'utf-7',
 347     'x-user-defined',
 348     'euc-jp',
 349     'ks_c_5601-1987',
 350     'tis-620',
 351     'SHIFT_JIS'
 352 );
 353
 354 // Loads language file
 355 require('./libraries/select_lang.lib.php3');
 356
 357
 358 /**
 359  * Customization & design
 360  */
 361 $cfg['LeftWidth']           = 150;          // left frame width
 362 $cfg['LeftBgColor']         = '#D0DCE0';    // background color for the left frame
 363 $cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
 364 $cfg['RightBgImage']        = '';           // path to a background image for the right frame
 365                                             // (leave blank for no background image)
 366 $cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
 367                                             // (blank for no pointer)
 368 $cfg['Border']              = 0;            // border width on tables
 369 $cfg['ThBgcolor']           = '#D3DCE3';    // table header row colour
 370 $cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
 371 $cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
 372 $cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
 373                                             // (blank for no pointer)
 374 $cfg['BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
 375                                             // by clicking on it) in browse mode
 376                                             // (blank for no marker)
 377 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 378                                             // (this value will be emphasized (*2) for sql
 379                                             // query textareas and (*1.25) for query window)
 380 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 381 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
 382 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
 383 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
 384 $cfg['LimitChars']          = 50;           // max field data length in browse mode
 385 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 386                                             // (or at the top with vertical browse)
 387 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 388                                             // (or at the bottom with vertical browse)
 389 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
 390                                             // (horizontal|vertical|horizontalflipped)
 391 $cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
 392                                             // creating columns (tbl_properties)
 393                                             // (horizontal|vertical)
 394
 395 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
 396                                             // NOTE: CSS only works in IE browsers!
 397 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
 398 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
 399 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 400
 401 $cfg['QueryFrame']          = TRUE;         // displays a new frame where a link to a querybox is always displayed.
 402 $cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.
 403                                             // if set to 'false', the target of the querybox is always the right frame.
 404 $cfg['QueryFrameDebug']     = FALSE;        // display JS debugging link (DEVELOPERS only)
 405 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
 406 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
 407 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
 408                                             // If FALSE, this utilizes JS-routines to display
 409                                             // query history (lost by window close)
 410 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
 411                                             // (sql|files|history|full)
 412 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
 413                                             // should be kept?
 414 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
 415 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
 416                                             // table rows.
 417
 418 /**
 419  * SQL Query box settings
 420  * These are the links display in all of the SQL Query boxes
 421  */
 422 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
 423 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
 424 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
 425 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
 426
 427
 428 /**
 429  * web-server upload directory
 430  */
 431 $cfg['UploadDir']             = '';         // for example, './upload/'; you must end it with
 432                                             // a slash, and you leave it empty for no upload
 433                                             // directory
 434
 435
 436 /**
 437  * SQL Parser Settings
 438  */
 439 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
 440 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
 441 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
 442 $cfg['SQP']['fmtColor']     = array(        // Syntax colouring data
 443     'comment'            => '#808000',
 444     'comment_mysql'      => '',
 445     'comment_ansi'       => '',
 446     'comment_c'          => '',
 447     'digit'              => '',
 448     'digit_hex'          => 'teal',
 449     'digit_integer'      => 'teal',
 450     'digit_float'        => 'aqua',
 451     'punct'              => 'fuchsia',
 452     'alpha'              => '',
 453     'alpha_columnType'   => '#FF9900',
 454     'alpha_columnAttrib' => '#0000FF',
 455     'alpha_reservedWord' => '#990099',
 456     'alpha_functionName' => '#FF0000',
 457     'alpha_identifier'   => 'black',
 458     'alpha_variable'     => '#800000',
 459     'quote'              => '#008000',
 460     'quote_double'       => '',
 461     'quote_single'       => '',
 462     'quote_backtick'     => ''
 463 );
 464
 465
 466 /**
 467  * If you wish to use the SQL Validator service, you should be
 468  * aware of the following:
 469  * All SQL statements are stored anonymously for statistical purposes.
 470  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
 471  * All rights reserved.
 472  */
 473 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
 474 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
 475 $cfg['SQLValidator']['password'] = '';      // Password for username
 476
 477 /**
 478  * Developers ONLY!
 479  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 480  */
 481 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
 482 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
 483 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
 484                                             // Anything below the threshold is not displayed
 485
 486
 487 /**
 488  * MySQL settings
 489  */
 490 // Column types;
 491 // varchar, tinyint, text and date are listed first, based on estimated popularity
 492 $cfg['ColumnTypes'] = array(
 493    'VARCHAR',
 494    'TINYINT',
 495    'TEXT',
 496    'DATE',
 497    'SMALLINT',
 498    'MEDIUMINT',
 499    'INT',
 500    'BIGINT',
 501    'FLOAT',
 502    'DOUBLE',
 503    'DECIMAL',
 504    'DATETIME',
 505    'TIMESTAMP',
 506    'TIME',
 507    'YEAR',
 508    'CHAR',
 509    'TINYBLOB',
 510    'TINYTEXT',
 511    'BLOB',
 512    'MEDIUMBLOB',
 513    'MEDIUMTEXT',
 514    'LONGBLOB',
 515    'LONGTEXT',
 516    'ENUM',
 517    'SET'
 518 );
 519
 520 // Atributes
 521 $cfg['AttributeTypes'] = array(
 522    '',
 523    'BINARY',
 524    'UNSIGNED',
 525    'UNSIGNED ZEROFILL'
 526 );
 527
 528 // Available functions
 529 if ($cfg['ShowFunctionFields']) {
 530     $cfg['Functions'] = array(
 531        'ASCII',
 532        'CHAR',
 533        'SOUNDEX',
 534        'LCASE',
 535        'UCASE',
 536        'NOW',
 537        'PASSWORD',
 538        'MD5',
 539        'ENCRYPT',
 540        'RAND',
 541        'LAST_INSERT_ID',
 542        'COUNT',
 543        'AVG',
 544        'SUM',
 545        'CURDATE',
 546        'CURTIME',
 547        'FROM_DAYS',
 548        'FROM_UNIXTIME',
 549        'PERIOD_ADD',
 550        'PERIOD_DIFF',
 551        'TO_DAYS',
 552        'UNIX_TIMESTAMP',
 553        'USER',
 554        'WEEKDAY',
 555        'CONCAT'
 556     );
 557
 558     // Which column types will be mapped to which Group?
 559     $cfg['RestrictColumnTypes'] = array(
 560        'VARCHAR'      => 'FUNC_CHAR',
 561        'TINYINT'      => 'FUNC_NUMBER',
 562        'TEXT'         => 'FUNC_CHAR',
 563        'DATE'         => 'FUNC_DATE',
 564        'SMALLINT'     => 'FUNC_NUMBER',
 565        'MEDIUMINT'    => 'FUNC_NUMBER',
 566        'INT'          => 'FUNC_NUMBER',
 567        'BIGINT'       => 'FUNC_NUMBER',
 568        'FLOAT'        => 'FUNC_NUMBER',
 569        'DOUBLE'       => 'FUNC_NUMBER',
 570        'DECIMAL'      => 'FUNC_NUMBER',
 571        'DATETIME'     => 'FUNC_DATE',
 572        'TIMESTAMP'    => 'FUNC_DATE',
 573        'TIME'         => 'FUNC_DATE',
 574        'YEAR'         => 'FUNC_DATE',
 575        'CHAR'         => 'FUNC_CHAR',
 576        'TINYBLOB'     => 'FUNC_CHAR',
 577        'TINYTEXT'     => 'FUNC_CHAR',
 578        'BLOB'         => 'FUNC_CHAR',
 579        'MEDIUMBLOB'   => 'FUNC_CHAR',
 580        'MEDIUMTEXT'   => 'FUNC_CHAR',
 581        'LONGBLOB'     => 'FUNC_CHAR',
 582        'LONGTEXT'     => 'FUNC_CHAR',
 583        'ENUM'         => '',
 584        'SET'          => ''
 585     );
 586
 587     // Map above defined groups to any function
 588     $cfg['RestrictFunctions'] = array(
 589         'FUNC_CHAR'   => array(
 590             'ASCII',
 591             'CHAR',
 592             'SOUNDEX',
 593             'LCASE',
 594             'UCASE',
 595             'PASSWORD',
 596             'MD5',
 597             'ENCRYPT',
 598             'LAST_INSERT_ID',
 599             'USER',
 600             'CONCAT'
 601         ),
 602
 603         'FUNC_DATE'   => array(
 604             'NOW',
 605             'CURDATE',
 606             'CURTIME',
 607             'FROM_DAYS',
 608             'FROM_UNIXTIME',
 609             'PERIOD_ADD',
 610             'PERIOD_DIFF',
 611             'TO_DAYS',
 612             'UNIX_TIMESTAMP',
 613             'WEEKDAY'
 614         ),
 615
 616         'FUNC_NUMBER' => array(
 617             'ASCII',
 618             'CHAR',
 619             'MD5',
 620             'ENCRYPT',
 621             'RAND',
 622             'LAST_INSERT_ID',
 623             'COUNT',
 624             'AVG',
 625             'SUM'
 626         )
 627     );
 628
 629 } // end if
 630
 631
 632 /**
 633  * Unset magic_quotes_runtime - do not change!
 634  */
 635 set_magic_quotes_runtime(0);
 636
 637 /**
 638  * File Revision - do not change either!
 639  */
 640 $cfg['FileRevision'] = '$Revision$';
 641 ?>