<?php

/**
 * @Project NUKEVIET 4.x
 * @Author VINADES.,JSC <contact@vinades.vn>
 * @Copyright (C) 2014 VINADES.,JSC. All rights reserved
 * @License GNU/GPL version 2 or any later version
 * @Createdate 2-1-2010 22:42
 */

define('NV_ADMIN', true);
define('NV_IS_INSTALL', true);

require_once 'mainfile.php';

$file_config_temp = NV_TEMP_DIR . '/config_' . NV_CHECK_SESSION . '.php';

$dirs = nv_scandir(NV_ROOTDIR . '/includes/language', '/^([a-z]{2})/');

$languageslist = array();

foreach ($dirs as $file) {
    if (is_file(NV_ROOTDIR . '/includes/language/' . $file . '/install.php')) {
        $languageslist[] = $file;
    }
}

if (!in_array(NV_LANG_DATA, $languageslist)) {
    nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . $languageslist[0] . '&step=1');
}

require_once NV_ROOTDIR . '/modules/users/language/' . NV_LANG_DATA . '.php';
require_once NV_ROOTDIR . '/includes/language/' . NV_LANG_DATA . '/global.php';
require_once NV_ROOTDIR . '/includes/language/' . NV_LANG_DATA . '/install.php';
require_once NV_ROOTDIR . '/install/template.php';
require_once NV_ROOTDIR . '/includes/core/admin_functions.php';

if (is_file(NV_ROOTDIR . '/install/default.php')) {
    require_once NV_ROOTDIR . '/install/default.php';
}

if (is_file(NV_ROOTDIR . '/' . $file_config_temp)) {
    require_once NV_ROOTDIR . '/' . $file_config_temp;
}

$array_samples_data = nv_scandir(NV_ROOTDIR . '/install/samples', '/^data\_([a-z0-9]+)\.php$/');

$contents = '';
$step = $nv_Request->get_int('step', 'post,get', 1);

$maxstep = $nv_Request->get_int('maxstep', 'session', 1);

if ($step <= 0 or $step > 8) {
    nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=1');
}

if ($step > $maxstep and $step > 2) {
    $step = $maxstep;
    nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=' . $step);
}

if (file_exists(NV_ROOTDIR . '/' . NV_CONFIG_FILENAME) and $step < 8) {
    nv_redirect_location(NV_BASE_SITEURL . 'index.php');
}
if (empty($sys_info['supports_rewrite'])) {
    if (isset($_COOKIE['supports_rewrite']) and $_COOKIE['supports_rewrite'] == NV_CHECK_SESSION) {
        $sys_info['supports_rewrite'] = 'rewrite_mode_apache';
    }
}
if ($step == 1) {
    if ($step < 2) {
        $nv_Request->set_Session('maxstep', 2);
    }

    $title = $lang_module['select_language'];

    $contents = nv_step_1();
} elseif ($step == 2) {
    // Tu dong nhan dang Remove Path
    if ($nv_Request->isset_request('tetectftp', 'post')) {
        $ftp_server = nv_unhtmlspecialchars($nv_Request->get_title('ftp_server', 'post', '', 1));
        $ftp_port = intval($nv_Request->get_title('ftp_port', 'post', '21', 1));
        $ftp_user_name = nv_unhtmlspecialchars($nv_Request->get_title('ftp_user_name', 'post', '', 1));
        $ftp_user_pass = nv_unhtmlspecialchars($nv_Request->get_title('ftp_user_pass', 'post', '', 1));

        if (!$ftp_server or !$ftp_user_name or !$ftp_user_pass) {
            die('ERROR|' . $lang_module['ftp_error_empty']);
        }

        $ftp = new NukeViet\Ftp\Ftp($ftp_server, $ftp_user_name, $ftp_user_pass, array(
            'timeout' => 10
        ), $ftp_port);

        if (!empty($ftp->error)) {
            $ftp->close();
            die('ERROR|' . (string) $ftp->error);
        } else {
            $list_valid = array(
                NV_ASSETS_DIR,
                'includes',
                'index.php',
                'modules',
                'themes',
                'vendor'
            );

            $ftp_root = $ftp->detectFtpRoot($list_valid, NV_ROOTDIR);

            if ($ftp_root === false) {
                $ftp->close();
                die('ERROR|' . (empty($ftp->error) ? $lang_module['ftp_error_detect_root'] : (string) $ftp->error));
            }

            $ftp->close();
            die('OK|' . $ftp_root);
        }

        $ftp->close();
        die('ERROR|' . $lang_module['ftp_error_detect_root']);
    }

    // Danh sach cac file can kiem tra quyen ghi
    $array_dir = array(
        NV_LOGS_DIR,
        NV_LOGS_DIR . '/data_logs',
        NV_LOGS_DIR . '/dump_backup',
        NV_LOGS_DIR . '/error_logs',
        NV_LOGS_DIR . '/error_logs/errors256',
        NV_LOGS_DIR . '/error_logs/old',
        NV_LOGS_DIR . '/error_logs/tmp',
        NV_LOGS_DIR . '/ip_logs',
        NV_LOGS_DIR . '/ref_logs',
        NV_LOGS_DIR . '/voting_logs',
        NV_CACHEDIR,
        NV_UPLOADS_DIR,
        NV_TEMP_DIR,
        NV_FILES_DIR,
        NV_DATADIR
    );

    // Them vao cac file trong thu muc data va file cau hinh tam
    $array_file_data = nv_scandir(NV_ROOTDIR . '/' . NV_DATADIR, '/^([a-zA-Z0-9\-\_\.]+)\.([a-z0-9]{2,6})$/');
    foreach ($array_file_data as $file_i) {
        $array_dir[] = NV_DATADIR . '/' . $file_i;
    }
    $array_dir[] = $file_config_temp;

    // Them vao file .htaccess va web.config
    if (!empty($sys_info['supports_rewrite'])) {
        if ($sys_info['supports_rewrite'] == 'rewrite_mode_apache') {
            if (!file_exists(NV_ROOTDIR . '/.htaccess')) {
                @file_put_contents(NV_ROOTDIR . '/.htaccess', file_get_contents(NV_ROOTDIR . '/install/default.htaccess.txt'));
            }
            $array_dir[] = '.htaccess';
        } else {
            if (!file_exists(NV_ROOTDIR . '/web.config')) {
                @file_put_contents(NV_ROOTDIR . '/web.config', file_get_contents(NV_ROOTDIR . '/install/default.web.config.txt'));
            }
            $array_dir[] = 'web.config';
        }
    }

    // Cau hinh FTP
    $ftp_check_login = 0;
    $global_config['ftp_server'] = $nv_Request->get_string('ftp_server', 'post', 'localhost');
    $global_config['ftp_port'] = $nv_Request->get_int('ftp_port', 'post', 21);
    $global_config['ftp_user_name'] = $nv_Request->get_string('ftp_user_name', 'post', '');
    $global_config['ftp_user_pass'] = $nv_Request->get_string('ftp_user_pass', 'post', '');
    $global_config['ftp_path'] = $nv_Request->get_string('ftp_path', 'post', '/');

    $array_ftp_data = array(
        'ftp_server' => $global_config['ftp_server'],
        'ftp_port' => $global_config['ftp_port'],
        'ftp_user_name' => $global_config['ftp_user_name'],
        'ftp_user_pass' => $global_config['ftp_user_pass'],
        'ftp_path' => $global_config['ftp_path'],
        'error' => ''
    );

    // CHMOD bang FTP
    $modftp = $nv_Request->get_int('modftp', 'post', 0);
    if ($modftp) {
        if (!empty($global_config['ftp_server']) and !empty($global_config['ftp_user_name']) and !empty($global_config['ftp_user_pass'])) {
            // Set up basic connection
            $conn_id = ftp_connect($global_config['ftp_server'], $global_config['ftp_port'], 10);

            // Login with username and password
            $login_result = ftp_login($conn_id, $global_config['ftp_user_name'], $global_config['ftp_user_pass']);
            if ((!$conn_id) or (!$login_result)) {
                $ftp_check_login = 3;
                $array_ftp_data['error'] = $lang_module['ftp_error_account'];
            } elseif (ftp_chdir($conn_id, $global_config['ftp_path'])) {
                $check_files = array(
                    NV_CACHEDIR,
                    NV_DATADIR,
                    'images',
                    'includes',
                    'index.php',
                    'robots.txt',
                    'js',
                    'language',
                    NV_LOGS_DIR,
                    'modules',
                    'themes',
                    NV_TEMP_DIR
                );

                $list_files = ftp_nlist($conn_id, '.');

                $a = 0;
                foreach ($list_files as $filename) {
                    $filename = basename($filename);
                    if (in_array($filename, $check_files)) {
                        ++$a;
                    }
                }

                if ($a == sizeof($check_files)) {
                    $ftp_check_login = 1;
                    nv_chmod_dir($conn_id, NV_DATADIR, true);
                    nv_chmod_dir($conn_id, NV_TEMP_DIR, true);
                    nv_save_file_config();
                    nv_chmod_dir($conn_id, NV_TEMP_DIR, true);
                } else {
                    $ftp_check_login = 2;
                    $array_ftp_data['error'] = $lang_module['ftp_error_path'];
                }
            } else {
                $ftp_check_login = 2;
                $array_ftp_data['error'] = $lang_module['ftp_error_path'];
            }
            $global_config['ftp_check_login'] = $ftp_check_login;
        }
    }

    // Kiem tra quyen ghi doi voi nhung file tren
    $nextstep = 1;
    $array_dir_check = array();
    foreach ($array_dir as $dir) {
        if ($ftp_check_login == 1) {
            if (!is_dir(NV_ROOTDIR . '/' . $dir) and $dir != $file_config_temp) {
                ftp_mkdir($conn_id, $dir);
            }

            if (!is_writable(NV_ROOTDIR . '/' . $dir)) {
                if (substr($sys_info['os'], 0, 3) != 'WIN') {
                    ftp_chmod($conn_id, 0777, $dir);
                }
            }
        }

        if ($dir == $file_config_temp and !file_exists(NV_ROOTDIR . '/' . $file_config_temp) and is_writable(NV_ROOTDIR . '/' . NV_TEMP_DIR)) {
            file_put_contents(NV_ROOTDIR . '/' . $file_config_temp, '', LOCK_EX);
        }

        if (is_file(NV_ROOTDIR . '/' . $dir)) {
            if (is_writable(NV_ROOTDIR . '/' . $dir)) {
                $array_dir_check[$dir] = $lang_module['dir_writable'];
            } else {
                $array_dir_check[$dir] = $lang_module['dir_not_writable'];
                $nextstep = 0;
            }
        } elseif (is_dir(NV_ROOTDIR . '/' . $dir)) {
            if (is_writable(NV_ROOTDIR . '/' . $dir)) {
                $array_dir_check[$dir] = $lang_module['dir_writable'];
            } else {
                $array_dir_check[$dir] = $lang_module['dir_not_writable'];
                $nextstep = 0;
            }
        } else {
            $array_dir_check[$dir] = $lang_module['dir_noexit'];
            $nextstep = 0;
        }
    }

    if (!nv_save_file_config($db_config, $global_config) and $ftp_check_login == 1) {
        ftp_chmod($conn_id, 0777, $file_config_temp);
    }

    if ($ftp_check_login > 0) {
        ftp_close($conn_id);
    }

    if ($step < 3 and $nextstep == 1) {
        $nv_Request->set_Session('maxstep', 3);
    }

    $title = $lang_module['check_chmod'];
    $contents = nv_step_2($array_dir_check, $array_ftp_data, $nextstep);
} elseif ($step == 3) {
    if ($step < 4) {
        $nv_Request->set_Session('maxstep', 4);
    }
    $title = $lang_module['license'];

    if (file_exists(NV_ROOTDIR . '/install/licenses_' . NV_LANG_DATA . '.html')) {
        $license = file_get_contents(NV_ROOTDIR . '/install/licenses_' . NV_LANG_DATA . '.html');
    } else {
        $license = file_get_contents(NV_ROOTDIR . '/install/licenses.html');
    }

    $contents = nv_step_3($license);
} elseif ($step == 4) {
    $nextstep = 0;
    $title = $lang_module['check_server'];

    $array_resquest = array();
    $array_resquest['pdo_support'] = $lang_module['not_compatible'];
    $array_resquest['class_pdo_support'] = 'highlight_red';
    if (class_exists('PDO', false)) {
        $PDODrivers = PDO::getAvailableDrivers();
        foreach ($PDODrivers as $_driver) {
            if (file_exists(NV_ROOTDIR . '/install/action_' . $_driver . '.php')) {
                $array_resquest['pdo_support'] = $lang_module['compatible'];
                $array_resquest['class_pdo_support'] = 'highlight_green';
                $nextstep = 1;
                break;
            }
        }
    }

    $array_resquest['php_required_min'] = preg_replace('/\.([0-9]+)$/', '', $sys_info['php_required_min']);
    $array_resquest['php_allowed_max'] = preg_replace('/\.([0-9]+)$/', '', $sys_info['php_allowed_max']);
    $array_resquest['php_version'] = $sys_info['php_version'];

    foreach ($nv_resquest_serverext_key as $key) {
        $array_resquest['class_' . $key] = ($sys_info[$key]) ? 'highlight_green' : 'highlight_red';
        $array_resquest[$key] = ($sys_info[$key]) ? $lang_module['compatible'] : $lang_module['not_compatible'];

        if (!$sys_info[$key]) {
            $nextstep = 0;
        }
    }

    if ($step < 5 and $nextstep == 1) {
        $nv_Request->set_Session('maxstep', 5);
    }

    $array_suport = array();
    $array_support['supports_rewrite'] = (empty($sys_info['supports_rewrite'])) ? 0 : 1;
    $array_support['output_buffering'] = (ini_get('output_buffering') == '1' or strtolower(ini_get('output_buffering')) == 'on') ? 0 : 1;
    $array_support['session_auto_start'] = (ini_get('session.auto_start') == '1' or strtolower(ini_get('session.auto_start')) == 'on') ? 0 : 1;
    $array_support['display_errors'] = (ini_get('display_errors') == '1' or strtolower(ini_get('display_errors')) == 'on') ? 0 : 1;
    $array_support['allowed_set_time_limit'] = ($sys_info['allowed_set_time_limit']) ? 1 : 0;
    $array_support['zlib_support'] = ($sys_info['zlib_support']) ? 1 : 0;
    $array_support['zip_support'] = (extension_loaded('zip')) ? 1 : 0;
    $array_support['mbstring_support'] = (extension_loaded('mbstring')) ? 1 : 0;
    $array_support['curl_support'] = (extension_loaded('curl')) ? 1 : 0;
    foreach ($array_support as $_key => $_support) {
        $array_support['class_' . $_key] = ($_support) ? 'highlight_green' : 'highlight_red';
        $array_support[$_key] = ($_support) ? $lang_module['compatible'] : $lang_module['not_compatible'];
    }

    $contents = nv_step_4($array_resquest, $array_support, $nextstep);
} elseif ($step == 5) {
    $nextstep = 0;
    $db_config['error'] = '';
    $db_config['dbtype'] = $nv_Request->get_string('dbtype', 'post', $db_config['dbtype']);
    $db_config['dbhost'] = $nv_Request->get_string('dbhost', 'post', $db_config['dbhost']);
    $db_config['dbname'] = $nv_Request->get_string('dbname', 'post', $db_config['dbname']);
    $db_config['dbuname'] = $nv_Request->get_string('dbuname', 'post', $db_config['dbuname']);
    $db_config['dbpass'] = isset($_POST['dbpass']) ? trim($_POST['dbpass']) : $db_config['dbpass'];
    $db_config['prefix'] = $nv_Request->get_string('prefix', 'post', $db_config['prefix']);
    $db_config['dbport'] = $nv_Request->get_string('dbport', 'post', $db_config['dbport']);
    $db_config['db_detete'] = $nv_Request->get_int('db_detete', 'post', $db_config['dbdetete']);
    $db_config['num_table'] = 0;
    $db_config['create_db'] = 1;

    $PDODrivers = PDO::getAvailableDrivers();

    // Check dbtype
    if ($nv_Request->isset_request('checkdbtype', 'post')) {
        $dbtype = $nv_Request->get_title('checkdbtype', 'post');

        $respon = array(
            'status' => 'error',
            'dbtype' => $dbtype,
            'message' => '',
            'link' => '',
            'files' => array()
        );

        if ($dbtype == 'mysql') {
            // Not check default dbtype
            $respon['status'] = 'success';
        } else {
            if (!in_array($dbtype, $PDODrivers)) {
                $respon['message'] = $lang_module['dbcheck_error_driver'];
            } else {
                $array_check_files = array(
                    'install' => 'install/action_' . $dbtype . '.php',
                    'sys' => 'includes/action_' . $dbtype . '.php'
                );

                include NV_ROOTDIR . '/includes/action_mysql.php';

                $array_module_setup = array_map('trim', explode(',', NV_MODULE_SETUP_DEFAULT));

                foreach ($array_module_setup as $module) {
                    if (file_exists(NV_ROOTDIR . '/modules/' . $module . '/action_mysql.php')) {
                        $array_check_files[] = 'modules/' . $module . '/action_' . $dbtype . '.php';
                    }
                }

                foreach ($array_check_files as $key => $file) {
                    if (file_exists(NV_ROOTDIR . '/' . $file)) {
                        unset($array_check_files[$key]);
                    }
                }

                if (empty($array_check_files)) {
                    $respon['status'] = 'success';
                } else {
                    asort($array_check_files);
                    $respon['files'] = $array_check_files;
                    $respon['link'] = 'https://github.com/nukeviet/nukeviet/wiki/NukeViet-database-types';
                    $respon['message'] = $lang_module['dbcheck_error_files'];
                }
            }
        }

        nv_jsonOutput($respon);
    }

    if (in_array($db_config['dbtype'], $PDODrivers) and !empty($db_config['dbhost']) and preg_match('#[a-z]#ui', $db_config['dbname']) and !empty($db_config['dbuname']) and !empty($db_config['prefix'])) {
        $db_config['dbuname'] = preg_replace(array(
            '/[^a-z0-9]/i',
            '/[\_]+/',
            '/^[\_]+/',
            '/[\_]+$/'
        ), array(
            '_',
            '_',
            '',
            ''
        ), $db_config['dbuname']);
        $db_config['dbname'] = preg_replace(array(
            '/[^a-z0-9]/i',
            '/[\_]+/',
            '/^[\_]+/',
            '/[\_]+$/'
        ), array(
            '_',
            '_',
            '',
            ''
        ), $db_config['dbname']);
        $db_config['prefix'] = preg_replace(array(
            '/[^a-z0-9]/',
            '/[\_]+/',
            '/^[\_]+/',
            '/[\_]+$/'
        ), array(
            '_',
            '_',
            '',
            ''
        ), strtolower($db_config['prefix']));

        if (substr($sys_info['os'], 0, 3) == 'WIN' and $db_config['dbhost'] == 'localhost') {
            $db_config['dbhost'] = '127.0.0.1';
        }

        if ($db_config['dbtype'] == 'mysql') {
            $db_config['dbsystem'] = $db_config['dbname'];
        } elseif ($db_config['dbtype'] == 'oci' and empty($db_config['dbport'])) {
            $db_config['dbport'] = 1521;
            $db_config['dbsystem'] = $db_config['dbuname'];
        }

        // Bat dau phien lam viec cua MySQL
        $db_config['autosetcollation'] = false;
        if (empty($db_config['collation'])) {
            $db_config['collation'] = 'utf8_general_ci';
            $db_config['autosetcollation'] = true;
        }
        $db_config['charset'] = strstr($db_config['collation'], '_', true);

        try {
            $db = $db_slave = new NukeViet\Core\Database($db_config);
            $connect = $db->connect;
        } catch (PDOException $e) {
            $connect = 0;
        }
        if (!$connect) {
            $db_config['error'] = 'Could not connect to data server';
            if ($db_config['dbtype'] == 'mysql') {
                $db_config['dbname'] = '';
                try {
                    $db = $db_slave = new NukeViet\Core\Database($db_config);
                    $connect = $db->connect;
                } catch (PDOException $e) {
                    $connect = 0;
                }
                $db_config['dbname'] = $db_config['dbsystem'];
                if ($connect) {
                    try {
                        $db->query('CREATE DATABASE ' . $db_config['dbname']);
                        $db->exec('USE ' . $db_config['dbname']);

                        $db_config['error'] = '';
                        $connect = 1;
                    } catch (PDOException $e) {
                        trigger_error($e->getMessage());
                    }
                }
            }
        }

        if ($connect and $db_config['dbtype'] == 'mysql') {
            if ($db_config['autosetcollation']) {
                $mysql_server_version = $db->getAttribute(PDO::ATTR_SERVER_VERSION);
                if (version_compare($mysql_server_version, '5.5.3') >= 0 and $db_config['charset'] != 'utf8mb4') {
                    $db_config['charset'] = 'utf8mb4';
                    $db_config['collation'] = 'utf8mb4_unicode_ci';
                } elseif (version_compare($mysql_server_version, '5.5.3') < 0 and $db_config['charset'] != 'utf8') {
                    $db_config['charset'] = 'utf8';
                    $db_config['collation'] = 'utf8_general_ci';
                }
            }

            try {
                $db->exec('ALTER DATABASE ' . $db_config['dbname'] . ' DEFAULT CHARACTER SET ' . $db_config['charset'] . ' COLLATE ' . $db_config['collation']);
            } catch (PDOException $e) {
                trigger_error($e->getMessage());
            }

            $row = $db->query('SELECT @@session.character_set_database AS character_set_database,  @@session.collation_database AS collation_database')->fetch();
            if ($row['character_set_database'] != $db_config['charset'] or $row['collation_database'] != $db_config['collation']) {
                $db_config['error'] = 'Error character set database';
                $connect = 0;
            }
        }

        if ($connect) {
            // Kiểm tra lại kết nối MySQL nếu charset = utf8mb4
            if ($db_config['charset'] == 'utf8mb4') {
                $db = $db_slave = new NukeViet\Core\Database($db_config);
                if (empty($db->connect)) {
                    $db_config['charset'] = 'utf8';
                    $db_config['collation'] = 'utf8_general_ci';
                    $db = $db_slave = new NukeViet\Core\Database($db_config);
                    try {
                        $db->exec('ALTER DATABASE ' . $db_config['dbname'] . ' DEFAULT CHARACTER SET ' . $db_config['charset'] . ' COLLATE ' . $db_config['collation']);
                    } catch (PDOException $e) {
                        trigger_error($e->getMessage());
                    }
                }
            }

            $tables = array();
            if ($sys_info['allowed_set_time_limit']) {
                set_time_limit(0);
            }

            // Cai dat du lieu cho he thong
            $db_config['error'] = '';
            $sql_create_table = array();
            $sql_drop_table = array();

            define('NV_AUTHORS_GLOBALTABLE', $db_config['prefix'] . '_authors');
            define('NV_USERS_GLOBALTABLE', $db_config['prefix'] . '_users');
            define('NV_GROUPS_GLOBALTABLE', $db_config['prefix'] . '_users_groups');
            define('NV_CONFIG_GLOBALTABLE', $db_config['prefix'] . '_config');
            define('NV_LANGUAGE_GLOBALTABLE', $db_config['prefix'] . '_language');
            define('NV_SESSIONS_GLOBALTABLE', $db_config['prefix'] . '_sessions');
            define('NV_COOKIES_GLOBALTABLE', $db_config['prefix'] . '_cookies');
            define('NV_CRONJOBS_GLOBALTABLE', $db_config['prefix'] . '_cronjobs');

            require_once NV_ROOTDIR . '/install/action_' . $db_config['dbtype'] . '.php';

            $num_table = sizeof($sql_drop_table);

            if ($num_table > 0) {
                if ($db_config['db_detete'] == 1) {
                    foreach ($sql_drop_table as $_sql) {
                        try {
                            $db->query($_sql);
                        } catch (PDOException $e) {
                            $nv_Request->set_Session('maxstep', 4);
                            $db_config['error'] = $e->getMessage();
                            trigger_error($e->getMessage());
                            break;
                        }
                    }
                    $num_table = 0;
                } else {
                    $db_config['error'] = $lang_module['db_err_prefix'];
                }
            }

            $db_config['num_table'] = $num_table;

            if ($num_table == 0) {
                nv_save_file_config();
                require_once NV_ROOTDIR . '/install/data.php';

                foreach ($sql_create_table as $_sql) {
                    try {
                        $db->query($_sql);
                    } catch (PDOException $e) {
                        $nv_Request->set_Session('maxstep', 4);
                        $db_config['error'] = $e->getMessage();
                        trigger_error($e->getMessage());
                        break;
                    }
                }

                // Cai dat du lieu cho cac module
                if (empty($db_config['error'])) {
                    define('NV_IS_MODADMIN', true);

                    $module_name = 'modules';
                    $lang_module['modules'] = '';
                    $lang_module['vmodule_add'] = '';
                    $lang_module['autoinstall'] = '';
                    $lang_global['mod_modules'] = '';

                    define('NV_UPLOAD_GLOBALTABLE', $db_config['prefix'] . '_upload');
                    require_once NV_ROOTDIR . '/' . NV_ADMINDIR . '/modules/functions.php';

                    $module_name = '';
                    $modules_exit = nv_scandir(NV_ROOTDIR . '/modules', $global_config['check_module']);

                    // Cai dat du lieu cho ngon ngu
                    require_once NV_ROOTDIR . '/includes/action_' . $db_config['dbtype'] . '.php';

                    $sql_create_table = nv_create_table_sys(NV_LANG_DATA);
                    foreach ($sql_create_table as $_sql) {
                        try {
                            $db->query($_sql);
                        } catch (PDOException $e) {
                            $nv_Request->set_Session('maxstep', 4);
                            $db_config['error'] = $e->getMessage();
                            trigger_error($e->getMessage());
                            break;
                        }
                    }
                    unset($sql_create_table);

                    $filesavedata = NV_LANG_DATA;
                    $lang_data = NV_LANG_DATA;
                    $lang = NV_LANG_DATA;

                    if (!file_exists(NV_ROOTDIR . '/install/data_' . $lang_data . '.php')) {
                        $filesavedata = 'en';
                    }

                    $install_lang = array(); //DO NOT DELETE THIS LINE
                    $menu_rows_lev0 = array(); //DO NOT DELETE THIS LINE
                    $menu_rows_lev1 = array(); //DO NOT DELETE THIS LINE
                    include_once NV_ROOTDIR . '/install/data_' . $filesavedata . '.php';

                    $sql = 'SELECT * FROM ' . $db_config['prefix'] . '_' . NV_LANG_DATA . '_modules ORDER BY weight ASC';
                    $result = $db->query($sql);
                    $modules = $result->fetchAll();

                    foreach ($modules as $key => $row) {
                        $setmodule = $row['title'];

                        if (in_array($row['module_file'], $modules_exit)) {
                            $sm = nv_setup_data_module(NV_LANG_DATA, $setmodule);

                            if ($sm != 'OK_' . $setmodule) {
                                die('error set module: ' . $setmodule);
                            }
                        } else {
                            unset($modules[$key]);
                            $db->query('DELETE FROM ' . $db_config['prefix'] . '_' . NV_LANG_DATA . '_modules WHERE title=' . $db->quote($setmodule));
                        }
                    }

                    // Cai dat du lieu mau he thong
                    try {
                        // Xoa du lieu tai bang nvx_vi_modules
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_" . $lang_data . "_modules WHERE module_file NOT IN ('" . implode("', '", $modules_exit) . "')");

                        // Xoa du lieu tai bang nvx_setup_extensions
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_setup_extensions WHERE basename NOT IN ('" . implode("', '", $modules_exit) . "') AND type='module'");

                        // Xoa du lieu tai bang nvx_vi_blocks_groups
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_" . $lang_data . "_blocks_groups WHERE module!='theme' AND module NOT IN (SELECT title FROM " . $db_config['prefix'] . "_" . $lang_data . "_modules)");

                        // Xoa du lieu tai bang nvx_vi_blocks
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_" . $lang_data . "_blocks_weight WHERE bid NOT IN (SELECT bid FROM " . $db_config['prefix'] . "_" . $lang_data . "_blocks_groups)");

                        // Xoa du lieu tai bang nvx_vi_modthemes
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_" . $lang_data . "_modthemes WHERE func_id in (SELECT func_id FROM " . $db_config['prefix'] . "_" . $lang_data . "_modfuncs WHERE in_module NOT IN (SELECT title FROM " . $db_config['prefix'] . "_" . $lang_data . "_modules))");

                        // Xoa du lieu tai bang nvx_vi_modfuncs
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_" . $lang_data . "_modfuncs WHERE in_module NOT IN (SELECT title FROM " . $db_config['prefix'] . "_" . $lang_data . "_modules)");

                        // Xoa du lieu tai bang nvx_menu
                        $db->query("DELETE FROM " . $db_config['prefix'] . "_" . $lang_data . "_menu_rows WHERE module_name NOT IN (SELECT title FROM " . $db_config['prefix'] . "_" . $lang_data . "_modules)");
                    } catch (PDOException $e) {
                        $nv_Request->set_Session('maxstep', 4);
                        $db_config['error'] = $e->getMessage();
                        trigger_error($e->getMessage());
                    }

                    // Cai dat du lieu mau module
                    include_once NV_ROOTDIR . '/install/data_by_lang.php';
                    try {
                        foreach ($modules as $row) {
                            $module_name = $row['title'];
                            $module_file = $row['module_file'];
                            $module_data = $row['module_data'];
                            $module_upload = $row['module_upload'];

                            if (file_exists(NV_ROOTDIR . '/modules/' . $module_file . '/language/data_' . NV_LANG_DATA . '.php')) {
                                include NV_ROOTDIR . '/modules/' . $module_file . '/language/data_' . NV_LANG_DATA . '.php';
                            } elseif (file_exists(NV_ROOTDIR . '/modules/' . $module_file . '/language/data_en.php')) {
                                include NV_ROOTDIR . '/modules/' . $module_file . '/language/data_en.php';
                            }

                            if (empty($array_data['socialbutton'])) {
                                if ($module_file == 'news') {
                                    $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = '0' WHERE module = '" . $module_name . "' AND config_name = 'socialbutton' AND lang='" . $lang . "'");
                                }
                            }
                        }
                    } catch (PDOException $e) {
                        $db_config['error'] = $e->getMessage();
                        trigger_error($e->getMessage());
                    }

                    if (empty($db_config['error'])) {
                        ++$step;
                        $nv_Request->set_Session('maxstep', $step);

                        nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=' . $step);
                    }
                }
            }
        }
    }

    $title = $lang_module['config_database'];
    $db_config['dbpass'] = nv_htmlspecialchars($db_config['dbpass']);
    $contents = nv_step_5($db_config, $nextstep);
} elseif ($step == 6) {
    $nextstep = 0;
    $error = '';

    define('NV_USERS_GLOBALTABLE', $db_config['prefix'] . '_users');
    $array_data['site_name'] = $nv_Request->get_title('site_name', 'post', $array_data['site_name'], 1);
    $array_data['nv_login'] = nv_substr($nv_Request->get_title('nv_login', 'post', $array_data['nv_login'], 1), 0, $global_config['nv_unickmax']);
    $array_data['nv_email'] = $nv_Request->get_title('nv_email', 'post', $array_data['nv_email']);
    $array_data['nv_password'] = $nv_Request->get_title('nv_password', 'post', $array_data['nv_password']);
    $array_data['re_password'] = $nv_Request->get_title('re_password', 'post', $array_data['re_password']);
    $array_data['lang_multi'] = (int) $nv_Request->get_bool('lang_multi', 'post', $array_data['lang_multi']);

    $check_email = nv_check_valid_email($array_data['nv_email'], true);
    $array_data['nv_email'] = $check_email[1];

    try {
        $array_data['question'] = $nv_Request->get_title('question', 'post', $array_data['question'], 1);
        $array_data['answer_question'] = $nv_Request->get_title('answer_question', 'post', $array_data['answer_question'], 1);

        if (isset($_SERVER['SERVER_ADMIN']) and !empty($_SERVER['SERVER_ADMIN']) and filter_var($_SERVER['SERVER_ADMIN'], FILTER_VALIDATE_EMAIL)) {
            $global_config['site_email'] = $_SERVER['SERVER_ADMIN'];
        } elseif (($php_email = @ini_get("sendmail_from")) != "" and filter_var($php_email, FILTER_VALIDATE_EMAIL)) {
            $global_config['site_email'] = $php_email;
        } elseif (preg_match("/([a-zA-Z0-9])+([a-zA-Z0-9\._-])*@([a-zA-Z0-9_-])+([a-zA-Z0-9\._-]+)+/", ini_get("sendmail_path"), $matches) and filter_var($matches[0], FILTER_VALIDATE_EMAIL)) {
            $global_config['site_email'] = $matches[0];
        } elseif (checkdnsrr($_SERVER['SERVER_NAME'], "MX") || checkdnsrr($_SERVER['SERVER_NAME'], "A")) {
            $global_config['site_email'] = "webmaster@" . $_SERVER['SERVER_NAME'];
        } else {
            $global_config['site_email'] = $array_data['nv_email'];
        }

        if ($nv_Request->isset_request('nv_login,nv_password', 'post')) {
            // Bat dau phien lam viec cua MySQL
            $db = $db_slave = new NukeViet\Core\Database($db_config);
            if (empty($db->connect)) {
                $error = 'Sorry! Could not connect to data server';
            } else {
                $check_login = nv_check_valid_login($array_data['nv_login'], $global_config['nv_unickmax'], $global_config['nv_unickmin']);
                $check_pass = nv_check_valid_pass($array_data['nv_password'], $global_config['nv_upassmax'], $global_config['nv_upassmin']);

                if (empty($array_data['site_name'])) {
                    $error = $lang_module['err_sitename'];
                } elseif (!empty($check_login)) {
                    $error = $check_login;
                } elseif ("'" . $array_data['nv_login'] . "'" != $db->quote($array_data['nv_login'])) {
                    $error = sprintf($lang_module['account_deny_name'], '<strong>' . $array_data['nv_login'] . '</strong>');
                } elseif (!empty($check_email[0])) {
                    $error = $check_email[0];
                } elseif (!empty($check_pass)) {
                    $error = $check_pass;
                } elseif ($array_data['nv_password'] != $array_data['re_password']) {
                    $error = $lang_global['passwordsincorrect'];
                } elseif (empty($array_data['question'])) {
                    $error = $lang_module['your_question_empty'];
                } elseif (empty($array_data['answer_question'])) {
                    $error = $lang_module['answer_empty'];
                } elseif (empty($error)) {
                    $password = $crypt->hash_password($array_data['nv_password'], $global_config['hashprefix']);
                    define('NV_CONFIG_GLOBALTABLE', $db_config['prefix'] . '_config');

                    $userid = 1;
                    $db->query('TRUNCATE TABLE ' . $db_config['prefix'] . '_users');
                    $db->query('TRUNCATE TABLE ' . $db_config['prefix'] . '_authors');

                    $sth = $db->prepare("INSERT INTO " . $db_config['prefix'] . "_users (
                        userid, group_id, username, md5username, password, email, first_name, last_name, gender, photo,
                        birthday, sig,	regdate, question, answer, passlostkey, view_mail, remember, in_groups, active,
                        checknum, last_login, last_ip, last_agent, last_openid, idsite, email_verification_time
                    ) VALUES (
                        " . $userid . ", 1, :username, :md5username, :password, :email, :first_name, '', '', '', 0, '',
                        " . NV_CURRENTTIME . ", :question, :answer_question, '', 0, 1, '1', 1, '', " . NV_CURRENTTIME . ",
                        '', '', '', 0, -3
                    )");
                    $sth->bindParam(':username', $array_data['nv_login'], PDO::PARAM_STR);
                    $sth->bindValue(':md5username', nv_md5safe($array_data['nv_login']), PDO::PARAM_STR);
                    $sth->bindParam(':password', $password, PDO::PARAM_STR);
                    $sth->bindParam(':email', $array_data['nv_email'], PDO::PARAM_STR);
                    $sth->bindParam(':first_name', $array_data['nv_login'], PDO::PARAM_STR);
                    $sth->bindParam(':question', $array_data['question'], PDO::PARAM_STR);
                    $sth->bindParam(':answer_question', $array_data['answer_question'], PDO::PARAM_STR);
                    $ok1 = $sth->execute();

                    $ok2 = $db->exec("INSERT INTO " . $db_config['prefix'] . "_authors (admin_id, editor, lev, files_level, position, addtime, edittime, is_suspend, susp_reason, check_num, last_login, last_ip, last_agent) VALUES(" . $userid . ", 'ckeditor', 1, 'adobe,application,archives,audio,documents,flash,images,real,video|1|1|1', 'Administrator', 0, 0, 0, '', '', 0, '', '')");

                    if ($ok1 and $ok2) {
                        try {
                            $db->query('INSERT INTO ' . $db_config['prefix'] . '_users_info (userid) VALUES (' . $userid . ')');
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_users_groups_users (group_id, userid, is_leader, approved, data, time_requested, time_approved) VALUES(1, " . $userid . ", 1, 1, '0', " . NV_CURRENTTIME . ", " . NV_CURRENTTIME . ")");

                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'site', 'statistics_timezone', " . $db->quote(NV_SITE_TIMEZONE_NAME) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'site', 'site_email', " . $db->quote($global_config['site_email']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'error_set_logs', " . $db->quote($global_config['error_set_logs']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'error_send_email', " . $db->quote($global_config['site_email']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'site_lang', '" . NV_LANG_DATA . "')");

                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'my_domains', " . $db->quote(NV_SERVER_NAME) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'cookie_prefix', " . $db->quote($global_config['cookie_prefix']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'session_prefix', " . $db->quote($global_config['session_prefix']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'site_timezone', " . $db->quote($global_config['site_timezone']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'proxy_blocker', " . $db->quote($global_config['proxy_blocker']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'str_referer_blocker', " . $db->quote($global_config['str_referer_blocker']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'lang_multi', " . $db->quote($global_config['lang_multi']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'lang_geo', " . $db->quote($global_config['lang_geo']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'ftp_server', " . $db->quote($global_config['ftp_server']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'ftp_port', " . $db->quote($global_config['ftp_port']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'ftp_user_name', " . $db->quote($global_config['ftp_user_name']) . ")");

                            $ftp_user_pass = $crypt->encrypt($global_config['ftp_user_pass']);
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'ftp_user_pass', " . $db->quote($ftp_user_pass) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'ftp_path', " . $db->quote($global_config['ftp_path']) . ")");
                            $db->query("INSERT INTO " . NV_CONFIG_GLOBALTABLE . " (lang, module, config_name, config_value) VALUES ('sys', 'global', 'ftp_check_login', " . $db->quote($global_config['ftp_check_login']) . ")");
                            $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = " . $db->quote($array_data['site_name']) . " WHERE module = 'global' AND config_name = 'site_name'");

                            $result = $db->query('SELECT * FROM ' . $db_config['prefix'] . '_authors_module ORDER BY weight ASC');
                            while ($row = $result->fetch()) {
                                $checksum = md5($row['module'] . '#' . $row['act_1'] . '#' . $row['act_2'] . '#' . $row['act_3'] . '#' . $global_config['sitekey']);
                                $db->query("UPDATE " . $db_config['prefix'] . "_authors_module SET checksum = '" . $checksum . "' WHERE mid = " . $row['mid']);
                            }

                            if (!(nv_function_exists('finfo_open') or nv_class_exists('finfo', false) or nv_function_exists('mime_content_type') or (substr($sys_info['os'], 0, 3) != 'WIN' and (nv_function_exists('system') or nv_function_exists('exec'))))) {
                                $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = 'mild' WHERE lang='sys' AND module = 'global' AND config_name = 'upload_checking_mode'");
                            }
                            if (empty($array_data['lang_multi'])) {
                                $global_config['rewrite_optional'] = 1;
                                $global_config['lang_multi'] = 0;
                                $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = '0' WHERE lang='sys' AND module = 'global' AND config_name = 'lang_multi'");
                                $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = '1' WHERE lang='sys' AND module = 'global' AND config_name = 'rewrite_optional'");

                                $result = $db->query("SELECT COUNT(*) FROM " . $db_config['prefix'] . "_" . NV_LANG_DATA . "_modules where title='news'");
                                if ($result->fetchColumn()) {
                                    $global_config['rewrite_op_mod'] = 'news';
                                    $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = 'news' WHERE lang='sys' AND module = 'global' AND config_name = 'rewrite_op_mod'");
                                }
                            }
                        } catch (PDOException $e) {
                            trigger_error($e->getMessage());
                            die($e->getMessage());
                        }

                        nv_save_file_config();

                        $array_config_rewrite = array(
                            'rewrite_enable' => $global_config['rewrite_enable'],
                            'rewrite_optional' => $global_config['rewrite_optional'],
                            'rewrite_endurl' => $global_config['rewrite_endurl'],
                            'rewrite_exturl' => $global_config['rewrite_exturl'],
                            'rewrite_op_mod' => $global_config['rewrite_op_mod'],
                            'ssl_https' => 0
                        );
                        $rewrite = nv_rewrite_change($array_config_rewrite);
                        if (empty($rewrite[0])) {
                            $error .= sprintf($lang_module['file_not_writable'], $rewrite[1]);
                        } elseif (nv_save_file_config_global()) {
                            // Nếu không có dữ liệu mẫu chuyển sang bước 8
                            $step += (empty($array_samples_data) ? 2 : 1);
                            $nv_Request->set_Session('maxstep', $step);

                            nv_save_file_config();

                            if (is_writable(NV_ROOTDIR . '/robots.txt')) {
                                $contents = file_get_contents(NV_ROOTDIR . '/robots.txt');

                                $check_rewrite_file = nv_check_rewrite_file();

                                if ($global_config['rewrite_enable'] and $check_rewrite_file) {
                                    $content_sitemap = 'Sitemap: ' . NV_MY_DOMAIN . NV_BASE_SITEURL . 'sitemap.xml';
                                } else {
                                    $content_sitemap = 'Sitemap: ' . NV_MY_DOMAIN . NV_BASE_SITEURL . 'index.php?' . NV_NAME_VARIABLE . '=SitemapIndex' . $global_config['rewrite_endurl'];
                                }

                                $contents = str_replace('Sitemap: http://yousite.com/?nv=SitemapIndex', $content_sitemap, $contents);

                                file_put_contents(NV_ROOTDIR . '/robots.txt', $contents, LOCK_EX);
                            }

                            define('NV_IS_MODADMIN', true);

                            $module_name = 'upload';
                            $lang_global['mod_upload'] = 'upload';
                            $global_config['upload_logo'] = '';

                            define('NV_UPLOAD_GLOBALTABLE', $db_config['prefix'] . '_upload');
                            define('SYSTEM_UPLOADS_DIR', NV_UPLOADS_DIR);
                            require_once NV_ROOTDIR . '/' . NV_ADMINDIR . '/upload/functions.php';

                            $real_dirlist = array();
                            foreach ($allow_upload_dir as $dir) {
                                $real_dirlist = nv_listUploadDir($dir, $real_dirlist);
                            }
                            foreach ($real_dirlist as $dirname) {
                                try {
                                    $array_dirname[$dirname] = $db->insert_id("INSERT INTO " . NV_UPLOAD_GLOBALTABLE . "_dir (dirname, time, thumb_type, thumb_width, thumb_height, thumb_quality) VALUES ('" . $dirname . "', '0', '0', '0', '0', '0')", "did");
                                } catch (PDOException $e) {
                                    trigger_error($e->getMessage());
                                }
                            }

                            // Data Counter
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('c_time', 'start', 0, 0, 0)");
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('c_time', 'last', 0, 0, 0)");
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('total', 'hits', 0, 0, 0)");

                            $year = date('Y');
                            for ($i = 0; $i < 9; $i++) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('year', '" . $year . "', 0, 0, 0)");
                                ++$year;
                            }

                            $ar_tmp = explode(',', 'Jan,Feb,Mar,Apr,May,Jun,Jul,Aug,Sep,Oct,Nov,Dec');
                            foreach ($ar_tmp as $month) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('month', '" . $month . "', 0, 0, 0)");
                            }

                            for ($i = 1; $i < 32; $i++) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('day', '" . str_pad($i, 2, '0', STR_PAD_LEFT) . "', 0, 0, 0)");
                            }

                            $ar_tmp = explode(',', 'Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday');
                            foreach ($ar_tmp as $dayofweek) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('dayofweek', '" . $dayofweek . "', 0, 0, 0)");
                            }

                            for ($i = 0; $i < 24; $i++) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('hour', '" . str_pad($i, 2, '0', STR_PAD_LEFT) . "', 0, 0, 0)");
                            }

                            $bots = array(
                                'googlebot',
                                'msnbot',
                                'bingbot',
                                'yahooslurp',
                                'w3cvalidator'
                            );
                            foreach ($bots as $_bot) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('bot', " . $db->quote($_bot) . ", 0, 0, 0)");
                            }

                            $tmp_array = array(
                                'opera',
                                'operamini',
                                'webtv',
                                'explorer',
                                'edge',
                                'pocket',
                                'konqueror',
                                'icab',
                                'omniweb',
                                'firebird',
                                'firefox',
                                'iceweasel',
                                'shiretoko',
                                'mozilla',
                                'amaya',
                                'lynx',
                                'safari',
                                'iphone',
                                'ipod',
                                'ipad',
                                'chrome',
                                'cococ',
                                'android',
                                'googlebot',
                                'yahooslurp',
                                'w3cvalidator',
                                'blackberry',
                                'icecat',
                                'nokias60',
                                'nokia',
                                'msn',
                                'msnbot',
                                'bingbot',
                                'netscape',
                                'galeon',
                                'netpositive',
                                'phoenix'
                            );
                            foreach ($tmp_array as $_browser) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('browser', " . $db->quote($_browser) . ", 0, 0, 0)");
                            }

                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('browser', 'Mobile', 0, 0, 0)");
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('browser', 'bots', 0, 0, 0)");
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('browser', 'Unknown', 0, 0, 0)");

                            $tmp_array = array(
                                'unknown',
                                'win',
                                'win10',
                                'win8',
                                'win7',
                                'win2003',
                                'winvista',
                                'wince',
                                'winxp',
                                'win2000',
                                'apple',
                                'linux',
                                'os2',
                                'beos',
                                'iphone',
                                'ipod',
                                'ipad',
                                'blackberry',
                                'nokia',
                                'freebsd',
                                'openbsd',
                                'netbsd',
                                'sunos',
                                'opensolaris',
                                'android',
                                'irix',
                                'palm'
                            );
                            foreach ($tmp_array as $_os) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('os', " . $db->quote($_os) . ", 0, 0, 0)");
                            }

                            foreach ($countries as $_country => $v) {
                                $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('country', " . $db->quote($_country) . ", 0, 0, 0)");
                            }
                            $db->query("INSERT INTO " . $db_config['prefix'] . "_counter VALUES ('country', 'unkown', 0, 0, 0)");

                            nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=' . $step);
                        } else {
                            $error = sprintf($lang_module['file_not_writable'], NV_DATADIR . '/config_global.php');
                        }
                    } else {
                        $error = 'Error add Administrator';
                    }
                }
            }
        }
    } catch (PDOException $e) {
        echo '<pre>';
        print_r($e);
        echo '</pre>';
        die();
    }
    $array_data['error'] = $error;
    $title = $lang_module['website_info'];
    $lang_module['admin_pass_note'] = $lang_global['upass_type_' . $global_config['nv_upass_type']];
    $contents = nv_step_6($array_data, $nextstep);
} elseif ($step == 7) {
    // Nếu không có dữ liệu mẫu chuyển sang bước tiếp theo
    if (empty($array_samples_data)) {
        $maxstep = 8;
        $nv_Request->set_Session('maxstep', $maxstep);
        nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=' . $maxstep);
    }

    if ($nv_Request->isset_request('submit', 'post')) {
        $package = $nv_Request->get_title('package', 'post', '');
        if (!in_array('data_' . $package . '.php', $array_samples_data)) {
            nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=' . $step);
        }
        require NV_ROOTDIR . '/install/samples/data_' . $package . '.php';
        $db = $db_slave = new NukeViet\Core\Database($db_config);
        if (empty($db->connect)) {
            die('Sorry! Could not connect to data server');
        }
        foreach ($sql_create_table as $sql) {
            try {
                $db->query($sql);
            } catch (PDOException $e) {
                trigger_error($e->getMessage());
            }
        }

        define('NV_CONFIG_GLOBALTABLE', $db_config['prefix'] . '_config');
        $db->query("UPDATE " . NV_CONFIG_GLOBALTABLE . " SET config_value = " . $db->quote(NV_SERVER_NAME) . " WHERE lang = 'sys' AND module = 'global' AND config_name = 'my_domains'");

        try {
            nv_save_file_config_global();
            $array_config_rewrite = array(
                'rewrite_enable' => $global_config['rewrite_enable'],
                'rewrite_optional' => $global_config['rewrite_optional'],
                'rewrite_endurl' => $global_config['rewrite_endurl'],
                'rewrite_exturl' => $global_config['rewrite_exturl'],
                'rewrite_op_mod' => $global_config['rewrite_op_mod'],
                'ssl_https' => 0
            );
            $sql = "SELECT config_name, config_value FROM " . NV_CONFIG_GLOBALTABLE . " WHERE lang='sys' AND module='global' AND config_name IN('" . implode("', '", array_keys($array_config_rewrite)) . "')";
            $result = $db->query($sql);
            while ($row = $result->fetch()) {
                $array_config_rewrite[$row['config_name']] = $row['config_value'];
            }
            nv_rewrite_change($array_config_rewrite);
        } catch (PDOException $e) {
            echo '<pre>';
            print_r($e);
            echo '</pre>';
            die();
        }

        $nv_Cache->delAll();
        $maxstep = 8;
        $nv_Request->set_Session('maxstep', $maxstep);
        nv_redirect_location(NV_BASE_SITEURL . 'install/index.php?' . NV_LANG_VARIABLE . '=' . NV_LANG_DATA . '&step=' . $maxstep);
    }

    $title = $lang_module['sample_data'];
    $array_data = array();
    $nextstep = 0;
    $contents = nv_step_7($array_data, $nextstep);
} elseif ($step == 8) {
    $finish = 0;

    if (file_exists(NV_ROOTDIR . '/' . $file_config_temp)) {
        @rename(NV_ROOTDIR . '/' . $file_config_temp, NV_ROOTDIR . '/' . NV_TEMP_DIR . '/' . NV_CONFIG_FILENAME);

        // Write file robots
        if ($global_config['rewrite_enable']) {
            $robots_data = array();
            $robots_other = array();
            $cache_file = NV_ROOTDIR . '/' . NV_DATADIR . '/robots.php';
            if (file_exists($cache_file)) {
                include $cache_file;
                $robots_data = unserialize($cache);
            } else {
                $robots_data['/' . NV_DATADIR . '/'] = 0;
                $robots_data['/includes/'] = 0;
                $robots_data['/install/'] = 0;
                $robots_data['/modules/'] = 0;
                $robots_data['/robots.php'] = 0;
                $robots_data['/web.config'] = 0;
            }
            $robots_other[NV_BASE_SITEURL . 'users/'] = 0;
            $robots_other[NV_BASE_SITEURL . 'statistics/'] = 0;

            $content_config = "<?php\n\n";
            $content_config .= NV_FILEHEAD . "\n\n";
            $content_config .= "if ( ! defined( 'NV_MAINFILE' ) ) die( 'Stop!!!' );\n\n";
            $content_config .= "\$cache = '" . serialize($robots_data) . "';\n\n";
            $content_config .= "\$cache_other = '" . serialize($robots_other) . "';";
            file_put_contents($cache_file, $content_config, LOCK_EX);
        }

        //Resets the contents of the opcode cache
        if (function_exists('opcache_reset')) {
            opcache_reset();
        }
    }

    if (file_exists(NV_ROOTDIR . '/' . NV_TEMP_DIR . '/' . NV_CONFIG_FILENAME)) {
        $ftp_check_login = 0;
        $ftp_server_array = array(
            'ftp_check_login' => 0
        );

        if ($nv_Request->isset_request('ftp_server_array', 'session')) {
            $ftp_server_array = $nv_Request->get_string('ftp_server_array', 'session');
            $ftp_server_array = unserialize($ftp_server_array);
        }

        if (isset($ftp_server_array['ftp_check_login']) and intval($ftp_server_array['ftp_check_login']) == 1) {
            // Set up basic connection
            $conn_id = ftp_connect($ftp_server_array['ftp_server'], $ftp_server_array['ftp_port'], 10);

            // Login with username and password
            $login_result = ftp_login($conn_id, $ftp_server_array['ftp_user_name'], $ftp_server_array['ftp_user_pass']);

            if ((!$conn_id) or (!$login_result)) {
                $ftp_check_login = 3;
            } elseif (ftp_chdir($conn_id, $ftp_server_array['ftp_path'])) {
                $ftp_check_login = 1;
            }
        }

        if ($ftp_check_login == 1) {
            ftp_rename($conn_id, NV_TEMP_DIR . '/' . NV_CONFIG_FILENAME, NV_CONFIG_FILENAME);
            nv_chmod_dir($conn_id, NV_UPLOADS_DIR, true);
            ftp_chmod($conn_id, 0644, NV_CONFIG_FILENAME);
            ftp_close($conn_id);
        } else {
            @rename(NV_ROOTDIR . '/' . NV_TEMP_DIR . '/' . NV_CONFIG_FILENAME, NV_ROOTDIR . '/' . NV_CONFIG_FILENAME);
        }

        //Resets the contents of the opcode cache
        if (function_exists('opcache_reset')) {
            opcache_reset();
        }
    }

    if (file_exists(NV_ROOTDIR . '/' . NV_CONFIG_FILENAME)) {
        $finish = 1;
        $setup_inlocal = false;
        $array_local_private_ip = array(
            '/^\:\:1$/',
            '/^fc00\:\:(.*)$/',
            '/^fd[0-9a-f]{1,2}\:(.*)$/',
            '/^10\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/',
            '/^172\.16\.[0-9]{1,3}\.[0-9]{1,3}$/',
            '/^192\.168\.[0-9]{1,3}\.[0-9]{1,3}$/',
            '/^127\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}$/',
            '/^169\.254\.[0-9]{1,3}\.[0-9]{1,3}$/'
        );
        foreach ($array_local_private_ip as $iprule) {
            if (preg_match($iprule, NV_CLIENT_IP)) {
                $setup_inlocal = true;
                break;
            }
        }
        if ($setup_inlocal) {
            require NV_ROOTDIR . '/' . NV_CONFIG_FILENAME;
            $db = $db_slave = new NukeViet\Core\Database($db_config);
            unset($db_config['dbpass']);
            if (empty($db->connect)) {
                die('Sorry! Could not connect to data server');
            }
            $sth = $db->prepare('INSERT IGNORE INTO ' . $db_config['prefix'] . '_ips (
                type, ip, mask, area, begintime, endtime, notice
            ) VALUES (
                1, :ip, 0, 1, ' . NV_CURRENTTIME . ', 0, \'\'
            )');
            $ip = NV_CLIENT_IP;
            $sth->bindParam(':ip', $ip, PDO::PARAM_STR);
            $sth->execute();
            nv_save_file_ips(1);
        }
    } else {
        $finish = 2;
    }

    $title = $lang_module['done'];
    $contents = nv_step_8($finish);
}

echo nv_site_theme($step, $title, $contents);

function nv_save_file_config()
{
    global $nv_Request, $file_config_temp, $db_config, $global_config, $step;

    if (is_writable(NV_ROOTDIR . '/' . $file_config_temp) or is_writable(NV_ROOTDIR . '/' . NV_TEMP_DIR)) {
        $global_config['cookie_prefix'] = (empty($global_config['cookie_prefix']) or $global_config['cookie_prefix'] == 'nv4') ? 'nv4c_' . nv_genpass(5) : $global_config['cookie_prefix'];
        $global_config['session_prefix'] = (empty($global_config['session_prefix']) or $global_config['session_prefix'] == 'nv4') ? 'nv4s_' . nv_genpass(6) : $global_config['session_prefix'];
        $global_config['site_email'] = (!isset($global_config['site_email'])) ? '' : $global_config['site_email'];

        $db_config['dbhost'] = (!isset($db_config['dbhost'])) ? 'localhost' : $db_config['dbhost'];
        $db_config['dbport'] = (!isset($db_config['dbport'])) ? '' : $db_config['dbport'];
        $db_config['dbname'] = (!isset($db_config['dbname'])) ? '' : $db_config['dbname'];
        $db_config['dbuname'] = (!isset($db_config['dbuname'])) ? '' : $db_config['dbuname'];
        $db_config['dbsystem'] = (isset($db_config['dbsystem'])) ? $db_config['dbsystem'] : $db_config['dbuname'];
        $db_config['dbpass'] = (!isset($db_config['dbpass'])) ? '' : $db_config['dbpass'];
        $db_config['prefix'] = (!isset($db_config['prefix'])) ? 'nv4' : $db_config['prefix'];
        $db_config['charset'] = strstr($db_config['collation'], '_', true);

        $persistent = ($db_config['persistent']) ? 'true' : 'false';

        $content = '';
        $content .= "<?php\n\n";
        $content .= NV_FILEHEAD . "\n\n";
        $content .= "if (!defined('NV_MAINFILE')) {\n";
        $content .= "    die('Stop!!!');\n";
        $content .= "}\n\n";
        $content .= "\$db_config['dbhost'] = '" . $db_config['dbhost'] . "';\n";
        $content .= "\$db_config['dbport'] = '" . $db_config['dbport'] . "';\n";
        $content .= "\$db_config['dbname'] = '" . $db_config['dbname'] . "';\n";
        $content .= "\$db_config['dbsystem'] = '" . $db_config['dbsystem'] . "';\n";
        $content .= "\$db_config['dbuname'] = '" . $db_config['dbuname'] . "';\n";
        $content .= "\$db_config['dbpass'] = '" . str_replace("'", "\'", $db_config['dbpass']) . "';\n";
        $content .= "\$db_config['dbtype'] = '" . $db_config['dbtype'] . "';\n";
        $content .= "\$db_config['collation'] = '" . $db_config['collation'] . "';\n";
        $content .= "\$db_config['charset'] = '" . $db_config['charset'] . "';\n";
        $content .= "\$db_config['persistent'] = " . $persistent . ";\n";
        $content .= "\$db_config['prefix'] = '" . $db_config['prefix'] . "';\n";
        $content .= "\n";
        $content .= "\$global_config['site_domain'] = '';\n";
        $content .= "\$global_config['name_show'] = 0;\n";
        $content .= "\$global_config['idsite'] = 0;\n";
        $content .= "\$global_config['sitekey'] = '" . $global_config['sitekey'] . "';// Do not change sitekey!\n";
        $content .= "\$global_config['hashprefix'] = '" . $global_config['hashprefix'] . "';\n";
        $content .= "\$global_config['cached'] = 'files';\n";
        $content .= "\$global_config['session_handler'] = 'files';\n";
        $content .= "\$global_config['extension_setup'] = 3; // 0: No, 1: Upload, 2: NukeViet Store, 3: Upload + NukeViet Store\n";
        $content .= "// Readmore: https://wiki.nukeviet.vn/nukeviet4:advanced_setting:file_config";

        if ($step < 7) {
            $content .= "\$global_config['cookie_prefix'] = '" . $global_config['cookie_prefix'] . "';\n";
            $content .= "\$global_config['session_prefix'] = '" . $global_config['session_prefix'] . "';\n";

            $global_config['ftp_server'] = (!isset($global_config['ftp_server'])) ? 'localhost' : $global_config['ftp_server'];
            $global_config['ftp_port'] = (!isset($global_config['ftp_port'])) ? 21 : $global_config['ftp_port'];
            $global_config['ftp_user_name'] = (!isset($global_config['ftp_user_name'])) ? '' : $global_config['ftp_user_name'];
            $global_config['ftp_user_pass'] = (!isset($global_config['ftp_user_pass'])) ? '' : $global_config['ftp_user_pass'];
            $global_config['ftp_path'] = (!isset($global_config['ftp_path'])) ? '' : $global_config['ftp_path'];
            $global_config['ftp_check_login'] = (!isset($global_config['ftp_check_login'])) ? 0 : $global_config['ftp_check_login'];

            if ($global_config['ftp_check_login']) {
                $ftp_server_array = array(
                    'ftp_server' => $global_config['ftp_server'],
                    'ftp_port' => $global_config['ftp_port'],
                    'ftp_user_name' => $global_config['ftp_user_name'],
                    'ftp_user_pass' => $global_config['ftp_user_pass'],
                    'ftp_path' => $global_config['ftp_path'],
                    'ftp_check_login' => $global_config['ftp_check_login']
                );

                $nv_Request->set_Session('ftp_server_array', serialize($ftp_server_array));
            }

            $content .= "\n";
            $content .= "\$global_config['ftp_server'] = '" . $global_config['ftp_server'] . "';\n";
            $content .= "\$global_config['ftp_port'] = '" . $global_config['ftp_port'] . "';\n";
            $content .= "\$global_config['ftp_user_name'] = '" . $global_config['ftp_user_name'] . "';\n";
            $content .= "\$global_config['ftp_user_pass'] = '" . $global_config['ftp_user_pass'] . "';\n";
            $content .= "\$global_config['ftp_path'] = '" . $global_config['ftp_path'] . "';\n";
            $content .= "\$global_config['ftp_check_login'] = '" . $global_config['ftp_check_login'] . "';\n";
        }

        file_put_contents(NV_ROOTDIR . '/' . $file_config_temp, trim($content), LOCK_EX);
        //Resets the contents of the opcode cache
        if (function_exists('opcache_reset')) {
            opcache_reset();
        }
        return true;
    } else {
        return false;
    }
}
