Seditio Source
Root |
./othercms/b2evolution_7.2.3/inc/cron/jobs/_light_db_maintenance.job.php
<?php
/**
 * This file implements the test Cron controller
 *
 * @author fplanque: Francois PLANQUE
 */
if( !defined('EVO_MAIN_INIT') ) die( 'Please, do not access this page directly.' );

global
$dbm_tables_count;

load_funcs('tools/model/_maintenance.funcs.php');

// Execute query to get results of ANALYZE command
$results = dbm_analyze_tables( 'cron_job', 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' => $result_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 */
?>