/** * Maintenance::optimizetables() * * @return */ public function optimizetables() { CodonModule::checkPermission(MAINTENANCE); echo '<h3>Optimizing Tables...</h3>'; $results = MaintenanceData::optimizeTables(); foreach ($results as $row) { echo "{$row->Table} - {$row->Msg_text}<br />"; } }
* * @author Nabeel Shahzad * @copyright Copyright (c) 2008, Nabeel Shahzad * @link http://www.phpvms.net * @license http://creativecommons.org/licenses/by-nc-sa/3.0/ */ /* This is the maintenance cron file, which can run nightly. You should either point to this file directly in your web-host's control panel Or add an entry into the crontab file. I recommend running this maybe 2-3am, */ define('ADMIN_PANEL', true); include dirname(dirname(__FILE__)) . '/core/codon.config.php'; Auth::$userinfo->pilotid = 0; error_reporting(E_ALL); ini_set('display_errors', 'on'); /* Clear expired sessions */ Auth::clearExpiredSessions(); /* Update any expenses */ FinanceData::updateAllExpenses(); if (Config::Get('PILOT_AUTO_RETIRE') == true) { /* Find any retired pilots and set them to retired */ PilotData::findRetiredPilots(); CronData::set_lastupdate('find_retired_pilots'); } if (Config::Get('CLOSE_BIDS_AFTER_EXPIRE') === false) { SchedulesData::deleteExpiredBids(); CronData::set_lastupdate('check_expired_bids'); } MaintenanceData::optimizeTables(); MainController::Run('Maintenance', 'resetpirepcount'); MainController::Run('Maintenance', 'resethours');
public function optimizetables() { echo '<h3>Optimizing Tables...</h3>'; $results = MaintenanceData::optimizeTables(); foreach ($results as $row) { echo "{$row->Table} - {$row->Msg_text}<br />"; } }