<?php

if (false === $settings_hardcodedPrefix) {
    $schema_version = selectSQL("SELECT `schema_version` FROM `$db_main_prefix" . "system` WHERE name='system' LIMIT 1;");
} else {
    $schema_version = selectSQL("SELECT `schema_version` FROM `$settings_hardcodedPrefix" . "system` WHERE name='system' LIMIT 1;");
}

switch ($schema_version) {
    case '7079':

        //7.26, 7.29, 7.30, 7.31, 7.32, 7.33

        /** --- 7.37 --- */
        querySQL("UPDATE `{$db_main_prefix}node_type` SET `disabled`='0' WHERE `base`='node_content'");
        querySQL("UPDATE `{$db_main_prefix}system` SET `schema_version`='7015' WHERE `name`='node';");

        if (selectSQL("SELECT `schema_version` FROM `{$db_main_prefix}system` WHERE `name`='block'") < 7009) {
            querySQL("UPDATE `{$db_main_prefix}system` SET `schema_version`='7009' WHERE `name`='block'");
            querySQL("ALTER TABLE `{$db_main_prefix}block` MODIFY `title` varchar(255) NOT NULL DEFAULT ''");
        }

        $link = mysqli_connect(DB_MAIN_HOST, DB_MAIN_LOGIN, DB_MAIN_PASSWORD, DB_MAIN_NAME, (int)DB_MAIN_PORT, DB_MAIN_SOCKET);

        if (!$link) {
            echo mysqli_connect_error();
            exit(1);
        }

        mkdir(ROOT_DIR . '/tmp', 0777, true);

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "aggregator%';")) > 0) {
            $aggregator = selectSQL("SELECT `schema_version` FROM `$db_main_prefix" . "system` WHERE name='aggregator' LIMIT 1;");
            if ($aggregator < 7004) {
                querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_item` ADD INDEX `timestamp` (`timestamp`);");
                querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7004' WHERE `name`='aggregator';");}
        }

        break;

    case '7078':

        //7.22, 7.24

        $link = mysqli_connect(DB_MAIN_HOST, DB_MAIN_LOGIN, DB_MAIN_PASSWORD, DB_MAIN_NAME, (int)DB_MAIN_PORT, DB_MAIN_SOCKET);

        if (!$link) {
            echo mysqli_connect_error();
            exit(1);
        }

        mkdir(ROOT_DIR . '/tmp', 0777, true);

        querySQL("ALTER TABLE `$db_main_prefix" . "node` ADD INDEX `language` (`language`);");
        querySQL("ALTER TABLE `$db_main_prefix" . "file_managed` MODIFY `filesize` bigint(20) unsigned NOT NULL DEFAULT '0';");

        $sandbox['max'] = selectSQL("SELECT COUNT(DISTINCT n.nid) FROM $db_main_prefix" . "node n INNER JOIN $db_main_prefix" . "taxonomy_index t ON n.nid = t.nid WHERE n.status = '0';");
        if (!empty($sandbox['max'])) {
            $nids = selectSQL("SELECT DISTINCT n.nid FROM $db_main_prefix" . "node n INNER JOIN $db_main_prefix" . "taxonomy_index t ON n.nid = t.nid WHERE n.status ='0' LIMIT 5000;");
            if (!empty($nids)) {
                for ($i = 0; $i < $sandbox['max']; $i++) {
                    querySQL("DELETE FROM `$db_main_prefix" . "taxonomy_index` WHERE `nid`=$nids[$i];");
                }
            }
        }

        $image_version = selectSQL("SELECT `schema_version` FROM `$db_main_prefix" . "system` WHERE name='image' LIMIT 1;");
        if ($image_version == '7004') {
            querySQL("ALTER TABLE `$db_main_prefix" . "image_styles` ADD `label` varchar(255) NOT NULL DEFAULT '' COMMENT 'The style administrative name.';");
        }

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "aggregator%';")) > 0) {
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_item` ADD INDEX `timestamp` (`timestamp`);");
            querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7004' WHERE `name`='aggregator';");
        }

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "openid%';")) > 0) {
            querySQL("DROP TABLE `$db_main_prefix" . "openid_association`;");
            $openid = file_get_contents(dirname(__FILE__) . '/openid.sql', FILE_TEXT) or die ("Can't read openid.sql file.");
            $openid = replace('#DB_MAIN_PREFIX#', $db_main_prefix, $openid);
            importSQL($openid);
            querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7000' WHERE `name`='openid';");
        }

        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7014' WHERE `name`='node';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7079' WHERE `name`='system';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7011' WHERE `name`='taxonomy';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7005' WHERE `name`='image';");

        querySQL("DELETE FROM `$db_main_prefix" . "variable` WHERE `name`='update_notify_emails';");
        querySQL("DELETE FROM `$db_main_prefix" . "variable` WHERE `name`='clean_url';");

        system('cp -rf ' . dirname(__FILE__) . '/.htaccess_files ' . ROOT_DIR . '/sites/default/files/.htaccess');
        system('cp -rf ' . dirname(__FILE__) . '/.htaccess_files ' . ROOT_DIR . '/tmp/.htaccess');

        break;

    case '7073':

        //7.14

        mkdir(ROOT_DIR . '/tmp', 0777, true);

        if (false !== $settings_hardcodedPrefix) {
            renameSQL($settings_hardcodedPrefix, $db_main_prefix);
            $config = file_get_contents(ROOT_DIR . '/sites/default/settings.php', FILE_TEXT) or die ("Can't open settings.php file.");
            $config = replace("'prefix' => '$settings_hardcodedPrefix'", "'prefix' => '$db_main_prefix'", $config);
            $config = file_put_contents(ROOT_DIR . '/sites/default/settings.php', $config, LOCK_EX) or die ("Can't write settings.php file.");
        }

        querySQL("ALTER TABLE `$db_main_prefix" . "node` ADD INDEX `language` (`language`);");
        querySQL("ALTER TABLE `$db_main_prefix" . "watchdog` ADD INDEX `severity` (`severity`);");
        querySQL("ALTER TABLE `$db_main_prefix" . "file_managed` MODIFY `filesize` bigint(20) unsigned NOT NULL DEFAULT '0';");
        querySQL("ALTER TABLE `$db_main_prefix" . "image_styles` ADD `label` varchar(255) NOT NULL DEFAULT '' COMMENT 'The style administrative name.';");
        querySQL("ALTER TABLE `$db_main_prefix" . "date_formats` DROP KEY `formats`;");
        querySQL("ALTER TABLE `$db_main_prefix" . "date_formats` MODIFY `format` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT 'The date format string.';");
        querySQL("ALTER TABLE `$db_main_prefix" . "file_managed` MODIFY `filename` varchar(255) NOT NULL DEFAULT '' COMMENT 'Name of the file with no path components. This may differ from the basename of the URI if the file is renamed to avoid overwriting an existing file.';");

        $link = mysqli_connect(DB_MAIN_HOST, DB_MAIN_LOGIN, DB_MAIN_PASSWORD, DB_MAIN_NAME, (int)DB_MAIN_PORT, DB_MAIN_SOCKET);

        if (!$link) {
            echo mysqli_connect_error();
            exit(1);
        }

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "aggregator%';")) > 0) {
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_feed` DROP KEY `url`;");
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_feed` MODIFY `url` text NOT NULL COMMENT 'URL to the feed.';");
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_feed` MODIFY `link` text NOT NULL COMMENT 'The parent website of the feed; comes from the <link> element in the feed.';");
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_item` MODIFY `link` text NOT NULL COMMENT 'Link to the feed item.';");
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_item` MODIFY `guid` text NOT NULL COMMENT 'Unique identifier for the feed item.';");
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_feed` ADD INDEX `url` (`url`(255));");
            querySQL("ALTER TABLE `$db_main_prefix" . "aggregator_item` ADD INDEX `timestamp` (`timestamp`);");
            querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7004' WHERE `name`='aggregator';");
        }

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "forum%';")) > 0) {
            querySQL("ALTER TABLE `$db_main_prefix" . "forum_index` ADD INDEX `created` (`created`);");
            querySQL("ALTER TABLE `$db_main_prefix" . "forum_index` ADD INDEX `last_comment_timestamp` (`last_comment_timestamp`);");
            querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7012' WHERE `name`='forum';");
        }

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "languages%';")) > 0) {
            querySQL("ALTER TABLE `$db_main_prefix" . "languages` MODIFY `formula` varchar(255) NOT NULL DEFAULT '' COMMENT 'Plural formula in PHP code to evaluate to get plural indexes.';");
            querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7005' WHERE `name`='locale';");
        }

        if(mysqli_num_rows(mysqli_query($link, "SHOW TABLES LIKE '$db_main_prefix" . "openid%';")) > 0) {
            querySQL("DROP TABLE `$db_main_prefix" . "openid_association`;");
            $openid = file_get_contents(dirname(__FILE__) . '/openid.sql', FILE_TEXT) or die ("Can't read openid.sql file.");
            $openid = replace('#DB_MAIN_PREFIX#', $db_main_prefix, $openid);
            importSQL($openid);
            querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7000' WHERE `name`='openid';");
        }

        $sandbox['max'] = selectSQL("SELECT COUNT(DISTINCT n.nid) FROM $db_main_prefix" . "node n INNER JOIN $db_main_prefix" . "taxonomy_index t ON n.nid = t.nid WHERE n.status = '0';");
        if (!empty($sandbox['max'])) {
            $nids = selectSQL("SELECT DISTINCT n.nid FROM $db_main_prefix" . "node n INNER JOIN $db_main_prefix" . "taxonomy_index t ON n.nid = t.nid WHERE n.status ='0' LIMIT 5000;");
            if (!empty($nids)) {
                for ($i = 0; $i < $sandbox['max']; $i++) {
                    querySQL("DELETE FROM `$db_main_prefix" . "taxonomy_index` WHERE `nid`=$nids[$i];");
                }
            }
        }

        querySQL("INSERT INTO `$db_main_prefix" . "registry` VALUES ('FieldInfo','class','modules/field/field.info.class.inc','field',0);");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7014' WHERE `name`='node';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7079' WHERE `name`='system';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7011' WHERE `name`='taxonomy';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7005' WHERE `name`='image';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7003' WHERE `name`='field';");
        querySQL("UPDATE `$db_main_prefix" . "system` SET `schema_version`='7002' WHERE `name`='dblog';");

        querySQL("DELETE FROM `$db_main_prefix" . "variable` WHERE `name`='update_notify_emails';");
        querySQL("DELETE FROM `$db_main_prefix" . "variable` WHERE `name`='clean_url';");

        system('cp -rf ' . dirname(__FILE__) . '/.htaccess_files ' . ROOT_DIR . '/sites/default/files/.htaccess');
        system('cp -rf ' . dirname(__FILE__) . '/.htaccess_files ' . ROOT_DIR . '/tmp/.htaccess');

        break;
}

$htaccess = file_get_contents(dirname(__FILE__) . '/.htaccess', FILE_TEXT);
if (false === $htaccess) {
    echo "[ERROR]: .htaccess file can't be read.";
    exit(1);
}
$htaccess = replace('#BASE_URL_PATH#', $base_url_path, $htaccess);
$htaccess = file_put_contents(ROOT_DIR . '/.htaccess', $htaccess, LOCK_EX);
if (false === $htaccess) {
    echo "[ERROR]: Can't write .htaccess file.\n";
    exit(1);
}