$block_item_Widget->disp_template_replaced('block_start');
// Turn off the output buffering to do the correct work of the function flush()
@ini_set('output_buffering', 'off');
evo_flush();
switch ($template_action) {
case 'optimize_tables':
// Optimize MyISAM & InnoDB tables
dbm_optimize_tables();
break;
case 'check_tables':
// Check ALL database tables
dbm_check_tables();
break;
case 'analyze_tables':
// Analize ALL database tables
dbm_analyze_tables();
break;
case 'delete_orphan_files':
// delete orphan File objects with no matching file on disk
dbm_delete_orphan_files();
break;
case 'delete_orphan_file_roots':
// delete orphan file roots with no matching Blog or User entry in the database
dbm_delete_orphan_file_roots();
break;
case 'recreate_autogenerated_excerpts':
// Re-create all autogenerated excerpts
dbm_recreate_autogenerated_excerpts();
break;
case 'convert_item_content_separators':
// Convert item content separators to new format
<?php
/**
* This file implements the test Cron controller
*
* @author fplanque: Francois PLANQUE
*
* @version $Id: _light_db_maintenance.job.php 9 2011-10-24 22:32:00Z fplanque $
*/
if (!defined('EVO_MAIN_INIT')) {
die('Please, do not access this page directly.');
}
global $dbm_tables_count;
load_funcs('tools/model/_dbmaintenance.funcs.php');
// Execute query to get results of ANALYZE command
$results = dbm_analyze_tables(false, false);
$simple_keys = array(0, 1, 2, 3);
$failed_results = array();
foreach ($results as $result) {
if ($result->Msg_type != 'status') {
// Add different result types then 'status' to the failed resulsts array, so they can be display on the cron task view
// Convert keys to simple integer values to decrease a size of the data
$failed_results[] = array_combine($simple_keys, (array) $result);
}
}
$result_message = array('message' => sprintf(T_('The command ANALYZE has been executed for all %d tables.'), $dbm_tables_count), 'table_cols' => array(T_('Table'), T_('Operation'), T_('Result'), T_('Message ')), 'table_data' => $failed_results);
return 1;
/* ok */
