返回顶部

收藏

Magento 的文件和数据库维护脚本

更多

该脚本用来清除 Magento 无用的日志记录和文件

[PHP]代码

<?php
    $xml = simplexml_load_file('./app/etc/local.xml', NULL, LIBXML_NOCDATA);

    $db['host'] = $xml->global->resources->default_setup->connection->host;
    $db['name'] = $xml->global->resources->default_setup->connection->dbname;
    $db['user'] = $xml->global->resources->default_setup->connection->username;
    $db['pass'] = $xml->global->resources->default_setup->connection->password;
    $db['pref'] = $xml->global->resources->db->table_prefix;

    if($_GET['clean'] == 'log') clean_log_tables();
    if($_GET['clean'] == 'var') clean_var_directory();

    function clean_log_tables() 
    {
        global $db;

        $tables = array(
        'catalogindex_aggregation',
        'catalogindex_aggregation_tag',
        'catalogindex_aggregation_to_tag',
        'dataflow_batch_export',
        'dataflow_batch_import',
        'log_customer',
        'log_quote',
        'log_summary',
        'log_summary_type',
        'log_url',
        'log_url_info',
        'log_visitor',
        'log_visitor_info',
        'log_visitor_online',
        'report_event'
        );

        mysql_connect($db['host'], $db['user'], $db['pass']) or die(mysql_error());
        mysql_select_db($db['name']) or die(mysql_error());

        foreach($tables as $v => $k) {
            mysql_query('TRUNCATE `'.$db['pref'].$k.'`') or die(mysql_error());
        }
    }

    function clean_var_directory() 
    {
        $dirs = array(
        'downloader/pearlib/cache/*',
        'downloader/pearlib/download/*',
        'var/cache/',
        'var/log/',
        'var/report/',
        'var/session/',
        'var/tmp/'
        );

        foreach($dirs as $v => $k) {
            exec('rm -rf '.$k);
        }
    }
    clean_log_tables();
    clean_var_directory();
?>

标签:Magento

收藏

0人收藏

支持

0

反对

0