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['LeftFrameTableSeparator']= '__';  // Which string will be used to generate table prefixes
 201                                         // to split tables into multiple categories
 202 $cfg['LeftFrameTableLevel']   = '1';    // How many sublevels should be displayed when splitting
 203                                         // up tables by the above Separator
 204 $cfg['ShowTooltip']           = TRUE;   // display table comment as tooltip in left frame
 205 $cfg['ShowTooltipAliasDB']    = FALSE;  // if ShowToolTip is enabled, this defines that table/db comments
 206 $cfg['ShowTooltipAliasTB']    = FALSE;  // are shown (in the left menu and db_details_structure) instead of
 207                                         // table/db names
 208
 209 $cfg['LeftDisplayLogo']       = TRUE;   // display logo at top of left frame
 210
 211 // In the main frame, at startup...
 212 $cfg['ShowStats']             = TRUE;   // allow to display statistics and space usage in
 213                                         // the pages about database details and table
 214                                         // properties
 215 $cfg['ShowMysqlInfo']         = FALSE;  // whether to display the "MySQL runtime
 216 $cfg['ShowMysqlVars']         = FALSE;  // information", "MySQL system variables", "PHP
 217 $cfg['ShowPhpInfo']           = FALSE;  // information" and "change password" links for
 218 $cfg['ShowChgPassword']       = FALSE;  // simple users or not
 219 $cfg['SuggestDBName']         = TRUE;   // suggest a new DB name if possible (false = keep empty)
 220
 221 // In browse mode...
 222 $cfg['ShowBlob']              = FALSE;  // display blob field contents
 223 $cfg['NavigationBarIconic']   = TRUE;   // do not display text inside navigation bar buttons
 224 $cfg['ShowAll']               = FALSE;  // allows to display all the rows
 225 $cfg['MaxRows']               = 30;     // maximum number of rows to display
 226 $cfg['Order']                 = 'ASC';  // default for 'ORDER BY' clause (valid
 227                                         // values are 'ASC', 'DESC' or 'SMART' -ie
 228                                         // descending order for fields of type
 229                                         // TIME, DATE, DATETIME & TIMESTAMP,
 230                                         // ascending order else-)
 231
 232 // In edit mode...
 233 $cfg['ProtectBinary']         = 'blob'; // disallow editing of binary fields
 234                                         // valid values are:
 235                                         //   FALSE  allow editing
 236                                         //   'blob' allow editing except for BLOB fields
 237                                         //   'all'  disallow editing
 238 $cfg['ShowFunctionFields']    = TRUE;   // Display the function fields in edit/insert mode
 239 $cfg['CharEditing']           = 'input';
 240                                         // Which editor should be used for CHAR/VARCHAR fields:
 241                                         //  input - allows limiting of input length
 242                                         //  textarea - allows newlines in fields
 243
 244 // For the export features...
 245 $cfg['ZipDump']               = TRUE;   // Allow the use of zip/gzip/bzip
 246 $cfg['GZipDump']              = TRUE;   // compression for
 247 $cfg['BZipDump']              = TRUE;   // dump files
 248
 249 // Tabs display settings
 250 $cfg['LightTabs']             = FALSE;  // use graphically less intense menu tabs
 251 $cfg['DefaultTabServer']      = 'main.php3';
 252                                    // Possible values:
 253                                    // 'main.php3' = the welcome page
 254                                    // (recommended for multiuser setups)
 255                                    // 'server_databases.php3' = list of databases
 256                                    // 'server_status.php3' = runtime information
 257                                    // 'server_variables.php3' = MySQL server variables
 258                                    // 'server_privileges.php3' = user management
 259                                    // 'server_processlist.php3' = process list
 260 $cfg['DefaultTabDatabase']    = 'db_details_structure.php3';
 261                                    // Possible values:
 262                                    // 'db_details_structure.php3' = tables list
 263                                    // 'db_details.php3' = sql form
 264                                    // 'db_search.php3' = search query
 265 $cfg['DefaultTabTable']       = 'tbl_properties_structure.php3';
 266                                    // Possible values:
 267                                    // 'tbl_properties_structure.php3' = fields list
 268                                    // 'tbl_properties.php3' = sql form
 269                                    // 'tbl_select.php3 = select page
 270                                    // 'tbl_change.php3 = insert row page
 271
 272
 273 /**
 274  * Link to the official MySQL documentation.
 275  * Be sure to include no trailing slash on the path.
 276  * See http://www.mysql.com/documentation/index.html for more information
 277  * about MySQL manuals and their types.
 278  */
 279 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
 280
 281 /**
 282  * Type of MySQL documentation:
 283  *   old        - old style used in phpMyAdmin 2.3.0 and sooner
 284  *   searchable - "Searchable, with user comments"
 285  *   chapters   - "HTML, one page per chapter"
 286  *   big        - "HTML, all on one page"
 287  *   none       - do not show documentation links
 288  */
 289 $cfg['MySQLManualType'] = 'searchable';
 290
 291
 292 /**
 293  * Language and charset conversion settings
 294  */
 295 // Default language to use, if not browser-defined or user-defined
 296 $cfg['DefaultLang'] = 'en-iso-8859-1';
 297
 298 // Force: always use this language - must be defined in
 299 //        libraries/select_lang.lib.php3
 300 // $cfg['Lang']     = 'en-iso-8859-1';
 301
 302 // Default charset to use for recoding of MySQL queries, does not take
 303 // any effect when charsets recoding is switched off by
 304 // $cfg['AllowAnywhereRecoding'] or in language file
 305 // (see $cfg['AvailableCharsets'] to possible choices, you can add your own)
 306 $cfg['DefaultCharset'] = 'iso-8859-1';
 307
 308 // Allow charset recoding of MySQL queries, must be also enabled in language
 309 // file to make harder using other language files than unicode.
 310 // Default value is FALSE to avoid problems on servers without the iconv
 311 // extension and where dl() is not supported
 312 $cfg['AllowAnywhereRecoding'] = FALSE;
 313
 314 // You can select here which functions will be used for charset conversion.
 315 // Possible values are:
 316 //      auto   - automatically use available one (first is tested iconv, then
 317 //               recode)
 318 //      iconv  - use iconv or libiconv functions
 319 //      recode - use recode_string function
 320 $cfg['RecodingEngine'] = 'auto';
 321
 322 // Specify some parameters for iconv used in charset conversion. See iconv
 323 // documentation for details:
 324 // http://www.gnu.org/software/libiconv/documentation/libiconv/iconv_open.3.html
 325 $cfg['IconvExtraParams'] = '//IGNORE';
 326
 327 // Available charsets for MySQL conversion. currently contains all which could
 328 // be found in lang/* files and few more.
 329 // Charsets will be shown in same order as here listed, so if you frequently
 330 // use some of these move them to the top.
 331 $cfg['AvailableCharsets'] = array(
 332     'iso-8859-1',
 333     'iso-8859-2',
 334     'iso-8859-3',
 335     'iso-8859-4',
 336     'iso-8859-5',
 337     'iso-8859-6',
 338     'iso-8859-7',
 339     'iso-8859-8',
 340     'iso-8859-9',
 341     'iso-8859-10',
 342     'iso-8859-11',
 343     'iso-8859-12',
 344     'iso-8859-13',
 345     'iso-8859-14',
 346     'iso-8859-15',
 347     'windows-1250',
 348     'windows-1251',
 349     'windows-1252',
 350     'windows-1257',
 351     'koi8-r',
 352     'big5',
 353     'gb2312',
 354     'utf-8',
 355     'utf-7',
 356     'x-user-defined',
 357     'euc-jp',
 358     'ks_c_5601-1987',
 359     'tis-620',
 360     'SHIFT_JIS'
 361 );
 362
 363 // Loads language file
 364 require('./libraries/select_lang.lib.php3');
 365
 366
 367 /**
 368  * Customization & design
 369  */
 370 $cfg['LeftWidth']           = 150;          // left frame width
 371 $cfg['LeftBgColor']         = '#D0DCE0';    // background color for the left frame
 372 $cfg['RightBgColor']        = '#F5F5F5';    // background color for the right frame
 373 $cfg['RightBgImage']        = '';           // path to a background image for the right frame
 374                                             // (leave blank for no background image)
 375 $cfg['LeftPointerColor']    = '#CCFFCC';    // color of the pointer in left frame
 376                                             // (blank for no pointer)
 377 $cfg['Border']              = 0;            // border width on tables
 378 $cfg['ThBgcolor']           = '#D3DCE3';    // table header row colour
 379 $cfg['BgcolorOne']          = '#CCCCCC';    // table data row colour
 380 $cfg['BgcolorTwo']          = '#DDDDDD';    // table data row colour, alternate
 381 $cfg['BrowsePointerColor']  = '#CCFFCC';    // color of the pointer in browse mode
 382                                             // (blank for no pointer)
 383 $cfg['BrowseMarkerColor']   = '#FFCC99';    // color of the marker (visually marks row
 384                                             // by clicking on it) in browse mode
 385                                             // (blank for no marker)
 386 $cfg['TextareaCols']        = 40;           // textarea size (columns) in edit mode
 387                                             // (this value will be emphasized (*2) for sql
 388                                             // query textareas and (*1.25) for query window)
 389 $cfg['TextareaRows']        = 7;            // textarea size (rows) in edit mode
 390 $cfg['LongtextDoubleTextarea'] = TRUE;      // double size of textarea size for longtext fields
 391 $cfg['TextareaAutoSelect']  = TRUE;         // autoselect when clicking in the textarea of the querybox
 392 $cfg['CharTextareaCols']    = 40;           // textarea size (columns) for CHAR/VARCHAR
 393 $cfg['CharTextareaRows']    = 2;            // textarea size (rows) for CHAR/VARCHAR
 394 $cfg['CtrlArrowsMoving']    = TRUE;         // Enable Ctrl+Arrows moving between fields when editing?
 395 $cfg['LimitChars']          = 50;           // For text and blobs, max field data length in browse mode
 396 $cfg['ModifyDeleteAtLeft']  = TRUE;         // show edit/delete links on left side of browse
 397                                             // (or at the top with vertical browse)
 398 $cfg['ModifyDeleteAtRight'] = FALSE;        // show edit/delete links on right side of browse
 399                                             // (or at the bottom with vertical browse)
 400 $cfg['DefaultDisplay']      = 'horizontal'; // default display direction
 401                                             // (horizontal|vertical|horizontalflipped)
 402 $cfg['DefaultPropDisplay']  = 'horizontal'; // default display direction for altering/
 403                                             // creating columns (tbl_properties)
 404                                             // (horizontal|vertical)
 405
 406 $cfg['HeaderFlipType']      = 'css';        // table-header rotation via faking or css? (css|fake)
 407                                             // NOTE: CSS only works in IE browsers!
 408 $cfg['ShowBrowseComments']  = TRUE;         // shows stored relation-comments in 'browse' mode.
 409 $cfg['ShowPropertyComments']= TRUE;         // shows stored relation-comments in 'table property' mode.
 410 $cfg['RepeatCells']         = 100;          // repeat header names every X cells? (0 = deactivate)
 411
 412 $cfg['QueryFrame']          = TRUE;         // displays a new frame where a link to a querybox is always displayed.
 413 $cfg['QueryFrameJS']        = TRUE;         // whether to use JavaScript functions for opening a new window for SQL commands.
 414                                             // if set to 'false', the target of the querybox is always the right frame.
 415 $cfg['QueryFrameDebug']     = FALSE;        // display JS debugging link (DEVELOPERS only)
 416 $cfg['QueryWindowWidth']    = 550;          // Width of Query window
 417 $cfg['QueryWindowHeight']   = 310;          // Height of Query window
 418 $cfg['QueryHistoryDB']      = FALSE;         // Set to TRUE if you want DB-based query history.
 419                                             // If FALSE, this utilizes JS-routines to display
 420                                             // query history (lost by window close)
 421 $cfg['QueryWindowDefTab']   = 'sql';        // which tab to display in the querywindow on startup
 422                                             // (sql|files|history|full)
 423 $cfg['QueryHistoryMax']     = 25;           // When using DB-based query history, how many entries
 424                                             // should be kept?
 425 $cfg['BrowseMIME']          = TRUE;         // Use MIME-Types (stored in column comments table) for
 426 $cfg['MaxExactCount']       = 20000;        // When approximate count < this, PMA will get exact count for
 427                                             // table rows.
 428
 429 /**
 430  * SQL Query box settings
 431  * These are the links display in all of the SQL Query boxes
 432  */
 433 $cfg['SQLQuery']['Edit']      = TRUE;       // Edit link to change a query
 434 $cfg['SQLQuery']['Explain']   = TRUE;       // EXPLAIN on SELECT queries
 435 $cfg['SQLQuery']['ShowAsPHP'] = TRUE;       // Wrap a query in PHP
 436 $cfg['SQLQuery']['Validate']  = FALSE;      // Validate a query (see $cfg['SQLValidator'] as well)
 437
 438
 439 /**
 440  * web-server upload directory
 441  */
 442 $cfg['UploadDir']             = '';         // for example, './upload/'; you must end it with
 443                                             // a slash, and you leave it empty for no upload
 444                                             // directory
 445 $cfg['SaveDir']               = '';         // for example, './save/'; you must end it with
 446                                             // a slash, and you leave it empty for no save
 447                                             // directory
 448
 449
 450 /**
 451  * Misc. settings
 452  */
 453 $cfg['GD2Available']          = 'auto';     // Is GD >= 2 available? Set to yes/no/auto. 'auto'
 454                                             // does autodetection, which is a bit expensive for
 455                                             // php < 4.3.0, but it is the only safe vay how to
 456                                             // determine GD version.
 457 /**
 458  * SQL Parser Settings
 459  */
 460 $cfg['SQP']['fmtType']      = 'html';       // Pretty-printing style to use on queries (html, text, none)
 461 $cfg['SQP']['fmtInd']       = '1';          // Amount to indent each level (floats ok)
 462 $cfg['SQP']['fmtIndUnit']   = 'em';         // Units for indenting each level (CSS Types - {em,px,pt})
 463 $cfg['SQP']['fmtColor']     = array(        // Syntax colouring data
 464     'comment'            => '#808000',
 465     'comment_mysql'      => '',
 466     'comment_ansi'       => '',
 467     'comment_c'          => '',
 468     'digit'              => '',
 469     'digit_hex'          => 'teal',
 470     'digit_integer'      => 'teal',
 471     'digit_float'        => 'aqua',
 472     'punct'              => 'fuchsia',
 473     'alpha'              => '',
 474     'alpha_columnType'   => '#FF9900',
 475     'alpha_columnAttrib' => '#0000FF',
 476     'alpha_reservedWord' => '#990099',
 477     'alpha_functionName' => '#FF0000',
 478     'alpha_identifier'   => 'black',
 479     'alpha_variable'     => '#800000',
 480     'quote'              => '#008000',
 481     'quote_double'       => '',
 482     'quote_single'       => '',
 483     'quote_backtick'     => ''
 484 );
 485
 486
 487 /**
 488  * If you wish to use the SQL Validator service, you should be
 489  * aware of the following:
 490  * All SQL statements are stored anonymously for statistical purposes.
 491  * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
 492  * All rights reserved.
 493  */
 494 $cfg['SQLValidator']['use']      = FALSE;   // Make the SQL Validator available
 495 $cfg['SQLValidator']['username'] = '';      // If you have a custom username, specify it here (defaults to anonymous)
 496 $cfg['SQLValidator']['password'] = '';      // Password for username
 497
 498 /**
 499  * Developers ONLY!
 500  * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
 501  */
 502 $cfg['DBG']['enable'] = FALSE;              // Make the DBG stuff available
 503 $cfg['DBG']['profile']['enable'] = FALSE;   // Produce profiling results of PHP
 504 $cfg['DBG']['profile']['threshold'] = 0.5;  // Threshold of long running code to display
 505                                             // Anything below the threshold is not displayed
 506
 507
 508 /**
 509  * MySQL settings
 510  */
 511 // Column types;
 512 // varchar, tinyint, text and date are listed first, based on estimated popularity
 513 $cfg['ColumnTypes'] = array(
 514    'VARCHAR',
 515    'TINYINT',
 516    'TEXT',
 517    'DATE',
 518    'SMALLINT',
 519    'MEDIUMINT',
 520    'INT',
 521    'BIGINT',
 522    'FLOAT',
 523    'DOUBLE',
 524    'DECIMAL',
 525    'DATETIME',
 526    'TIMESTAMP',
 527    'TIME',
 528    'YEAR',
 529    'CHAR',
 530    'TINYBLOB',
 531    'TINYTEXT',
 532    'BLOB',
 533    'MEDIUMBLOB',
 534    'MEDIUMTEXT',
 535    'LONGBLOB',
 536    'LONGTEXT',
 537    'ENUM',
 538    'SET'
 539 );
 540
 541 // Atributes
 542 $cfg['AttributeTypes'] = array(
 543    '',
 544    'BINARY',
 545    'UNSIGNED',
 546    'UNSIGNED ZEROFILL'
 547 );
 548
 549 // Available functions
 550 if ($cfg['ShowFunctionFields']) {
 551     $cfg['Functions'] = array(
 552        'ASCII',
 553        'CHAR',
 554        'SOUNDEX',
 555        'LCASE',
 556        'UCASE',
 557        'NOW',
 558        'PASSWORD',
 559        'MD5',
 560        'ENCRYPT',
 561        'RAND',
 562        'LAST_INSERT_ID',
 563        'COUNT',
 564        'AVG',
 565        'SUM',
 566        'CURDATE',
 567        'CURTIME',
 568        'FROM_DAYS',
 569        'FROM_UNIXTIME',
 570        'PERIOD_ADD',
 571        'PERIOD_DIFF',
 572        'TO_DAYS',
 573        'UNIX_TIMESTAMP',
 574        'USER',
 575        'WEEKDAY',
 576        'CONCAT'
 577     );
 578
 579     // Which column types will be mapped to which Group?
 580     $cfg['RestrictColumnTypes'] = array(
 581        'VARCHAR'      => 'FUNC_CHAR',
 582        'TINYINT'      => 'FUNC_NUMBER',
 583        'TEXT'         => 'FUNC_CHAR',
 584        'DATE'         => 'FUNC_DATE',
 585        'SMALLINT'     => 'FUNC_NUMBER',
 586        'MEDIUMINT'    => 'FUNC_NUMBER',
 587        'INT'          => 'FUNC_NUMBER',
 588        'BIGINT'       => 'FUNC_NUMBER',
 589        'FLOAT'        => 'FUNC_NUMBER',
 590        'DOUBLE'       => 'FUNC_NUMBER',
 591        'DECIMAL'      => 'FUNC_NUMBER',
 592        'DATETIME'     => 'FUNC_DATE',
 593        'TIMESTAMP'    => 'FUNC_DATE',
 594        'TIME'         => 'FUNC_DATE',
 595        'YEAR'         => 'FUNC_DATE',
 596        'CHAR'         => 'FUNC_CHAR',
 597        'TINYBLOB'     => 'FUNC_CHAR',
 598        'TINYTEXT'     => 'FUNC_CHAR',
 599        'BLOB'         => 'FUNC_CHAR',
 600        'MEDIUMBLOB'   => 'FUNC_CHAR',
 601        'MEDIUMTEXT'   => 'FUNC_CHAR',
 602        'LONGBLOB'     => 'FUNC_CHAR',
 603        'LONGTEXT'     => 'FUNC_CHAR',
 604        'ENUM'         => '',
 605        'SET'          => ''
 606     );
 607
 608     // Map above defined groups to any function
 609     $cfg['RestrictFunctions'] = array(
 610         'FUNC_CHAR'   => array(
 611             'ASCII',
 612             'CHAR',
 613             'SOUNDEX',
 614             'LCASE',
 615             'UCASE',
 616             'PASSWORD',
 617             'MD5',
 618             'ENCRYPT',
 619             'LAST_INSERT_ID',
 620             'USER',
 621             'CONCAT'
 622         ),
 623
 624         'FUNC_DATE'   => array(
 625             'NOW',
 626             'CURDATE',
 627             'CURTIME',
 628             'FROM_DAYS',
 629             'FROM_UNIXTIME',
 630             'PERIOD_ADD',
 631             'PERIOD_DIFF',
 632             'TO_DAYS',
 633             'UNIX_TIMESTAMP',
 634             'WEEKDAY'
 635         ),
 636
 637         'FUNC_NUMBER' => array(
 638             'ASCII',
 639             'CHAR',
 640             'MD5',
 641             'ENCRYPT',
 642             'RAND',
 643             'LAST_INSERT_ID',
 644             'COUNT',
 645             'AVG',
 646             'SUM'
 647         )
 648     );
 649
 650 } // end if
 651
 652
 653 /**
 654  * Unset magic_quotes_runtime - do not change!
 655  */
 656 set_magic_quotes_runtime(0);
 657
 658 /**
 659  * File Revision - do not change either!
 660  */
 661 $cfg['FileRevision'] = '$Revision$';
 662 ?>