function db_maintenance_admin_settings in DB Maintenance 5
Same name and namespace in other branches
- 8.2 db_maintenance.admin.inc \db_maintenance_admin_settings()
- 5.2 db_maintenance.module \db_maintenance_admin_settings()
- 6.2 db_maintenance.module \db_maintenance_admin_settings()
- 6 db_maintenance.module \db_maintenance_admin_settings()
- 7.2 db_maintenance.admin.inc \db_maintenance_admin_settings()
- 7 db_maintenance.admin.inc \db_maintenance_admin_settings()
Administration settings
options: log each optimization multi-select list of tables to optimize
Return value
array
1 call to db_maintenance_admin_settings()
1 string reference to 'db_maintenance_admin_settings'
- db_maintenance_menu in ./
db_maintenance.module - Implementation of hook_menu().
File
- ./
db_maintenance.module, line 165 - Optimizes database tables during cron runs.
Code
function db_maintenance_admin_settings() {
global $db_url;
$form['db_maintenance_log'] = array(
'#type' => 'checkbox',
'#title' => 'Log OPTIMIZE queries',
'#default_value' => variable_get('db_maintenance_log', 0),
'#description' => t('If enabled, a watchdog entry will be made each time tables are optimized, containing information which tables were involved.'),
);
$options = array(
3600 => t('Hourly'),
86400 => t('Daily'),
604800 => t('Weekly'),
2592000 => t('Monthly'),
);
$form['db_maintenance_cron_frequency'] = array(
'#type' => 'select',
'#title' => t('Optimize tables'),
'#options' => $options,
'#default_value' => variable_get('db_maintenance_cron_frequency', 86400),
'#description' => t('Select how often database tables should be optimized.') . ' ' . l(t('Optimize now.'), 'db_maintenance/optimize'),
);
// Set the databases array if not already set in $db_url.
if (is_array($db_url)) {
$databases = $db_url;
}
else {
$databases['default'] = $db_url;
}
// Loop through each database and list the possible tables to optimize.
foreach ($databases as $db => $connection) {
$options = _db_maintenance_list_mysql_tables($db);
$form['db_maintenance_table_list_' . $db] = array(
'#type' => 'select',
'#title' => t('Tables in the !db database', array(
'!db' => $db == 'default' ? 'Drupal' : $db,
)),
'#options' => $options,
'#default_value' => variable_get('db_maintenance_table_list_' . $db, ''),
'#description' => t('Selected tables will be optimized during cron runs.'),
'#multiple' => true,
'#attributes' => array(
'size' => count($options),
),
);
}
return system_settings_form($form);
}