PHP PMA_DBI_getCompatibilities函数代码示例

 /**
  * Sets the import plugin properties.
  * Called in the constructor.
  *
  * @return void
  */
 protected function setProperties()
 {
     $props = 'libraries/properties/';
     include_once "{$props}/plugins/ImportPluginProperties.class.php";
     include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
     include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
     include_once "{$props}/options/items/SelectPropertyItem.class.php";
     include_once "{$props}/options/items/BoolPropertyItem.class.php";
     $importPluginProperties = new ImportPluginProperties();
     $importPluginProperties->setText('SQL');
     $importPluginProperties->setExtension('sql');
     $importPluginProperties->setOptionsText(__('Options'));
     $compats = PMA_DBI_getCompatibilities();
     if (count($compats) > 0) {
         $values = array();
         foreach ($compats as $val) {
             $values[$val] = $val;
         }
         // create the root group that will be the options field for
         // $importPluginProperties
         // this will be shown as "Format specific options"
         $importSpecificOptions = new OptionsPropertyRootGroup();
         $importSpecificOptions->setName("Format Specific Options");
         // general options main group
         $generalOptions = new OptionsPropertyMainGroup();
         $generalOptions->setName("general_opts");
         // create primary items and add them to the group
         $leaf = new SelectPropertyItem();
         $leaf->setName("compatibility");
         $leaf->setText(__('SQL compatibility mode:'));
         $leaf->setValues($values);
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'Server_SQL_mode'));
         $generalOptions->addProperty($leaf);
         $leaf = new BoolPropertyItem();
         $leaf->setName("no_auto_value_on_zero");
         $leaf->setText(__('Do not use <code>AUTO_INCREMENT</code> for zero values'));
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'Server_SQL_mode', 'sqlmode_no_auto_value_on_zero'));
         $generalOptions->addProperty($leaf);
         // add the main group to the root group
         $importSpecificOptions->addProperty($generalOptions);
         // set the options for the import plugin property item
         $importPluginProperties->setOptions($importSpecificOptions);
     }
     $this->properties = $importPluginProperties;
 }

 /**
  * Sets the export SQL properties
  *
  * @return void
  */
 protected function setProperties()
 {
     global $plugin_param;
     $hide_sql = false;
     $hide_structure = false;
     if ($plugin_param['export_type'] == 'table' && !$plugin_param['single_table']) {
         $hide_structure = true;
         $hide_sql = true;
     }
     if (!$hide_sql) {
         $props = 'libraries/properties/';
         include_once "{$props}/plugins/ExportPluginProperties.class.php";
         include_once "{$props}/options/groups/OptionsPropertyRootGroup.class.php";
         include_once "{$props}/options/groups/OptionsPropertyMainGroup.class.php";
         include_once "{$props}/options/groups/OptionsPropertySubgroup.class.php";
         include_once "{$props}/options/items/BoolPropertyItem.class.php";
         include_once "{$props}/options/items/MessageOnlyPropertyItem.class.php";
         include_once "{$props}/options/items/RadioPropertyItem.class.php";
         include_once "{$props}/options/items/SelectPropertyItem.class.php";
         include_once "{$props}/options/items/TextPropertyItem.class.php";
         $exportPluginProperties = new ExportPluginProperties();
         $exportPluginProperties->setText('SQL');
         $exportPluginProperties->setExtension('sql');
         $exportPluginProperties->setMimeType('text/x-sql');
         $exportPluginProperties->setOptionsText(__('Options'));
         // create the root group that will be the options field for
         // $exportPluginProperties
         // this will be shown as "Format specific options"
         $exportSpecificOptions = new OptionsPropertyRootGroup();
         $exportSpecificOptions->setName("Format Specific Options");
         // general options main group
         $generalOptions = new OptionsPropertyMainGroup();
         $generalOptions->setName("general_opts");
         // comments
         $subgroup = new OptionsPropertySubgroup();
         $subgroup->setName("include_comments");
         $leaf = new BoolPropertyItem();
         $leaf->setName('include_comments');
         $leaf->setText(__('Display comments <i>(includes info such as export' . ' timestamp, PHP version, and server version)</i>'));
         $subgroup->setSubgroupHeader($leaf);
         $leaf = new TextPropertyItem();
         $leaf->setName('header_comment');
         $leaf->setText(__('Additional custom header comment (\\n splits lines):'));
         $subgroup->addProperty($leaf);
         $leaf = new BoolPropertyItem();
         $leaf->setName('dates');
         $leaf->setText(__('Include a timestamp of when databases were created, last' . ' updated, and last checked'));
         $subgroup->addProperty($leaf);
         if (!empty($GLOBALS['cfgRelation']['relation'])) {
             $leaf = new BoolPropertyItem();
             $leaf->setName('relation');
             $leaf->setText(__('Display foreign key relationships'));
             $subgroup->addProperty($leaf);
         }
         if (!empty($GLOBALS['cfgRelation']['mimework'])) {
             $leaf = new BoolPropertyItem();
             $leaf->setName('mime');
             $leaf->setText(__('Display MIME types'));
             $subgroup->addProperty($leaf);
         }
         $generalOptions->addProperty($subgroup);
         // enclose in a transaction
         $leaf = new BoolPropertyItem();
         $leaf->setName("use_transaction");
         $leaf->setText(__('Enclose export in a transaction'));
         $leaf->setDoc(array('programs', 'mysqldump', 'option_mysqldump_single-transaction'));
         $generalOptions->addProperty($leaf);
         // disable foreign key checks
         $leaf = new BoolPropertyItem();
         $leaf->setName("disable_fk");
         $leaf->setText(__('Disable foreign key checks'));
         $leaf->setDoc(array('manual_MySQL_Database_Administration', 'server-system-variables', 'sysvar_foreign_key_checks'));
         $generalOptions->addProperty($leaf);
         // compatibility maximization
         $compats = PMA_DBI_getCompatibilities();
         if (count($compats) > 0) {
             $values = array();
             foreach ($compats as $val) {
                 $values[$val] = $val;
             }
             $leaf = new SelectPropertyItem();
             $leaf->setName("compatibility");
             $leaf->setText(__('Database system or older MySQL server to maximize output' . ' compatibility with:'));
             $leaf->setValues($values);
             $leaf->setDoc(array('manual_MySQL_Database_Administration', 'Server_SQL_mode'));
             $generalOptions->addProperty($leaf);
             unset($values);
         }
         // server export options
         if ($plugin_param['export_type'] == 'server') {
             $leaf = new BoolPropertyItem();
             $leaf->setName("drop_database");
             $leaf->setText(sprintf(__('Add %s statement'), '<code>DROP DATABASE</code>'));
             $generalOptions->addProperty($leaf);
         }
//.........这里部分代码省略.........

/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * SQL import plugin for phpMyAdmin
 *
 * @package    PhpMyAdmin-Import
 * @subpackage SQL
 */
if (!defined('PHPMYADMIN')) {
    exit;
}
/**
 *
 */
if (isset($plugin_list)) {
    $plugin_list['sql'] = array('text' => __('SQL'), 'extension' => 'sql', 'options_text' => __('Options'));
    $compats = PMA_DBI_getCompatibilities();
    if (count($compats) > 0) {
        $values = array();
        foreach ($compats as $val) {
            $values[$val] = $val;
        }
        $plugin_list['sql']['options'] = array(array('type' => 'begin_group', 'name' => 'general_opts'), array('type' => 'select', 'name' => 'compatibility', 'text' => __('SQL compatibility mode:'), 'values' => $values, 'doc' => array('manual_MySQL_Database_Administration', 'Server_SQL_mode')), array('type' => 'bool', 'name' => 'no_auto_value_on_zero', 'text' => __('Do not use <code>AUTO_INCREMENT</code> for zero values'), 'doc' => array('manual_MySQL_Database_Administration', 'Server_SQL_mode', 'sqlmode_no_auto_value_on_zero')), array('type' => 'end_group'));
    }
    /* We do not define function when plugin is just queried for information above */
    return;
}
$buffer = '';
// Defaults for parser
$sql = '';
$start_pos = 0;
$i = 0;