lang
[phpmyadmin/crack.git] / config.inc.php3
blob2d78d72b6cafc0e005d01ee3bfbaab7553af90d8
1 <?php
2 /* $Id$ */
3 // vim: expandtab sw=4 ts=4 sts=4:
5 /**
6 * phpMyAdmin Configuration File
8 * All directives are explained in Documentation.html
9 */
12 /**
13 * Sets the php error reporting - Please do not change this line!
15 if (!isset($old_error_reporting)) {
16 error_reporting(E_ALL);
17 @ini_set('display_errors', '1');
21 /**
22 * Your phpMyAdmin url
24 * Complete the variable below with the full url ie
25 * http://www.your_web.net/path_to_your_phpMyAdmin_directory/
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.
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.
36 * If the auto-detection code does work properly, you can set to TRUE the
37 * $cfg['PmaAbsoluteUri_DisableWarning'] variable below.
39 $cfg['PmaAbsoluteUri'] = '';
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.
47 $cfg['PmaAbsoluteUri_DisableWarning'] = FALSE;
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
53 $cfg['PmaNoRelation_DisableWarning'] = FALSE;
56 /**
57 * Server(s) configuration
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
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();
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();
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();
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]);
183 * Other core phpMyAdmin settings
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
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
205 $cfg['LeftDisplayLogo'] = TRUE; // display logo at top of left frame
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)
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-)
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
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
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
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.
275 $cfg['MySQLManualBase'] = 'http://www.mysql.com/doc/en';
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
285 $cfg['MySQLManualType'] = 'searchable';
289 * Language and charset conversion settings
291 // Default language to use, if not browser-defined or user-defined
292 $cfg['DefaultLang'] = 'en-iso-8859-1';
294 // Force: always use this language - must be defined in
295 // libraries/select_lang.lib.php3
296 // $cfg['Lang'] = 'en-iso-8859-1';
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';
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;
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';
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'
354 // Loads language file
355 require('./libraries/select_lang.lib.php3');
359 * Customization & design
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)
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)
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
417 * SQL Query box settings
418 * These are the links display in all of the SQL Query boxes
420 $cfg['SQLQuery']['Edit'] = TRUE; // Edit link to change a query
421 $cfg['SQLQuery']['Explain'] = TRUE; // EXPLAIN on SELECT queries
422 $cfg['SQLQuery']['ShowAsPHP'] = TRUE; // Wrap a query in PHP
423 $cfg['SQLQuery']['Validate'] = FALSE; // Validate a query (see $cfg['SQLValidator'] as well)
427 * web-server upload directory
429 $cfg['UploadDir'] = ''; // for example, './upload/'; you must end it with
430 // a slash, and you leave it empty for no upload
431 // directory
435 * SQL Parser Settings
437 $cfg['SQP']['fmtType'] = 'html'; // Pretty-printing style to use on queries (html, text, none)
438 $cfg['SQP']['fmtInd'] = '1'; // Amount to indent each level (floats ok)
439 $cfg['SQP']['fmtIndUnit'] = 'em'; // Units for indenting each level (CSS Types - {em,px,pt})
440 $cfg['SQP']['fmtColor'] = array( // Syntax colouring data
441 'comment' => '#808000',
442 'comment_mysql' => '',
443 'comment_ansi' => '',
444 'comment_c' => '',
445 'digit' => '',
446 'digit_hex' => 'teal',
447 'digit_integer' => 'teal',
448 'digit_float' => 'aqua',
449 'punct' => 'fuchsia',
450 'alpha' => '',
451 'alpha_columnType' => '#FF9900',
452 'alpha_columnAttrib' => '#0000FF',
453 'alpha_reservedWord' => '#990099',
454 'alpha_functionName' => '#FF0000',
455 'alpha_identifier' => 'black',
456 'alpha_variable' => '#800000',
457 'quote' => '#008000',
458 'quote_double' => '',
459 'quote_single' => '',
460 'quote_backtick' => ''
465 * If you wish to use the SQL Validator service, you should be
466 * aware of the following:
467 * All SQL statements are stored anonymously for statistical purposes.
468 * Mimer SQL Validator, Copyright 2002 Upright Database Technology.
469 * All rights reserved.
471 $cfg['SQLValidator']['use'] = FALSE; // Make the SQL Validator available
472 $cfg['SQLValidator']['username'] = ''; // If you have a custom username, specify it here (defaults to anonymous)
473 $cfg['SQLValidator']['password'] = ''; // Password for username
476 * Developers ONLY!
477 * To use the following, please install the DBG extension from http://dd.cron.ru/dbg/
479 $cfg['DBG']['enable'] = FALSE; // Make the DBG stuff available
480 $cfg['DBG']['profile']['enable'] = FALSE; // Produce profiling results of PHP
481 $cfg['DBG']['profile']['threshold'] = 0.5; // Threshold of long running code to display
482 // Anything below the threshold is not displayed
486 * MySQL settings
488 // Column types;
489 // varchar, tinyint, text and date are listed first, based on estimated popularity
490 $cfg['ColumnTypes'] = array(
491 'VARCHAR',
492 'TINYINT',
493 'TEXT',
494 'DATE',
495 'SMALLINT',
496 'MEDIUMINT',
497 'INT',
498 'BIGINT',
499 'FLOAT',
500 'DOUBLE',
501 'DECIMAL',
502 'DATETIME',
503 'TIMESTAMP',
504 'TIME',
505 'YEAR',
506 'CHAR',
507 'TINYBLOB',
508 'TINYTEXT',
509 'BLOB',
510 'MEDIUMBLOB',
511 'MEDIUMTEXT',
512 'LONGBLOB',
513 'LONGTEXT',
514 'ENUM',
515 'SET'
518 // Atributes
519 $cfg['AttributeTypes'] = array(
521 'BINARY',
522 'UNSIGNED',
523 'UNSIGNED ZEROFILL'
526 // Available functions
527 if ($cfg['ShowFunctionFields']) {
528 $cfg['Functions'] = array(
529 'ASCII',
530 'CHAR',
531 'SOUNDEX',
532 'LCASE',
533 'UCASE',
534 'NOW',
535 'PASSWORD',
536 'MD5',
537 'ENCRYPT',
538 'RAND',
539 'LAST_INSERT_ID',
540 'COUNT',
541 'AVG',
542 'SUM',
543 'CURDATE',
544 'CURTIME',
545 'FROM_DAYS',
546 'FROM_UNIXTIME',
547 'PERIOD_ADD',
548 'PERIOD_DIFF',
549 'TO_DAYS',
550 'UNIX_TIMESTAMP',
551 'USER',
552 'WEEKDAY',
553 'CONCAT'
556 // Which column types will be mapped to which Group?
557 $cfg['RestrictColumnTypes'] = array(
558 'VARCHAR' => 'FUNC_CHAR',
559 'TINYINT' => 'FUNC_NUMBER',
560 'TEXT' => 'FUNC_CHAR',
561 'DATE' => 'FUNC_DATE',
562 'SMALLINT' => 'FUNC_NUMBER',
563 'MEDIUMINT' => 'FUNC_NUMBER',
564 'INT' => 'FUNC_NUMBER',
565 'BIGINT' => 'FUNC_NUMBER',
566 'FLOAT' => 'FUNC_NUMBER',
567 'DOUBLE' => 'FUNC_NUMBER',
568 'DECIMAL' => 'FUNC_NUMBER',
569 'DATETIME' => 'FUNC_DATE',
570 'TIMESTAMP' => 'FUNC_DATE',
571 'TIME' => 'FUNC_DATE',
572 'YEAR' => 'FUNC_DATE',
573 'CHAR' => 'FUNC_CHAR',
574 'TINYBLOB' => 'FUNC_CHAR',
575 'TINYTEXT' => 'FUNC_CHAR',
576 'BLOB' => 'FUNC_CHAR',
577 'MEDIUMBLOB' => 'FUNC_CHAR',
578 'MEDIUMTEXT' => 'FUNC_CHAR',
579 'LONGBLOB' => 'FUNC_CHAR',
580 'LONGTEXT' => 'FUNC_CHAR',
581 'ENUM' => '',
582 'SET' => ''
585 // Map above defined groups to any function
586 $cfg['RestrictFunctions'] = array(
587 'FUNC_CHAR' => array(
588 'ASCII',
589 'CHAR',
590 'SOUNDEX',
591 'LCASE',
592 'UCASE',
593 'PASSWORD',
594 'MD5',
595 'ENCRYPT',
596 'LAST_INSERT_ID',
597 'USER',
598 'CONCAT'
601 'FUNC_DATE' => array(
602 'NOW',
603 'CURDATE',
604 'CURTIME',
605 'FROM_DAYS',
606 'FROM_UNIXTIME',
607 'PERIOD_ADD',
608 'PERIOD_DIFF',
609 'TO_DAYS',
610 'UNIX_TIMESTAMP',
611 'WEEKDAY'
614 'FUNC_NUMBER' => array(
615 'ASCII',
616 'CHAR',
617 'MD5',
618 'ENCRYPT',
619 'RAND',
620 'LAST_INSERT_ID',
621 'COUNT',
622 'AVG',
623 'SUM'
627 } // end if
631 * Unset magic_quotes_runtime - do not change!
633 set_magic_quotes_runtime(0);
636 * File Revision - do not change either!
638 $cfg['FileRevision'] = '$Revision$';