con); $db_tables = $schema->getTables(); foreach ($db_tables as $t) { if (strpos($t,$core->prefix) === 0) { $core->con->vacuum($t); } } http::redirect($p_url.'&vacuum=1'); } catch (Exception $e) { $core->error->add($e->getMessage()); } } elseif ($action == 'commentscount') { try { $core->countAllComments(); http::redirect($p_url.'&commentscount=1'); } catch (Exception $e) { $core->error->add($e->getMessage()); } } elseif ($action == 'empty_cache') { try { $core->emptyTemplatesCache(); http::redirect($p_url.'&empty_cache=1'); } catch (Exception $e) { $core->error->add($e->getMessage()); } } elseif ($action == 'log') { try { $core->log->delLogs(null,true); http::redirect($p_url.'&delete_logs=1'); } catch (Exception $e) { $core->error->add($e->getMessage()); } } ?> <?php echo __('Maintenance'); ?>

'.__('Maintenance').'

'; ?> '.sprintf(__('Indexing entry %d to %d.'),$start,$start+$limit).'

'; $new_start = $core->indexAllPosts($start,$limit); if ($new_start) { $new_url = $p_url.'&action=index&indexposts=1&start='.$new_start; echo ''. ''; } else { dcPage::message(__('Entries index done.')); echo '

'.__('Back').'

'; } } elseif ($action == 'index' && !empty($_GET['indexcomments'])) { $limit = 1000; echo '

'.sprintf(__('Indexing comment %d to %d.'),$start,$start+$limit).'

'; $new_start = $core->indexAllComments($start,$limit); if ($new_start) { $new_url = $p_url.'&action=index&indexcomments=1&start='.$new_start; echo ''. ''; } else { dcPage::message(__('Comments index done.')); echo '

'.__('Back').'

'; } } else { echo '

'.__('Optimize database room').'

'. '
'. '

'. $core->formNonce(). form::hidden(array('action'),'vacuum'). form::hidden(array('p'),'maintenance').'

'. '
'; echo '

'.__('Counters').'

'. '
'. '

'. $core->formNonce(). form::hidden(array('action'),'commentscount'). form::hidden(array('p'),'maintenance').'

'. '
'; echo '

'.__('Search engine index').' ('.__('This may take a very long time').')

'. '
'. '

'. ' '. form::hidden(array('action'),'index'). form::hidden(array('p'),'maintenance').'

'. '
'; echo '

'.__('Vacuum logs').'

'. '
'. '

'. $core->formNonce(). form::hidden(array('action'),'log'). form::hidden(array('p'),'maintenance').'

'. '
'; echo '

'.__('Empty templates cache directory').'

'. '
'. '

'. $core->formNonce(). form::hidden(array('action'),'empty_cache'). form::hidden(array('p'),'maintenance').'

'. '
'; } dcPage::helpBlock('maintenance'); ?>