$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 */