<?php
require("../../includes/global.php");

$sql = "SELECT * FROM " . $dbprefix . "config WHERE config_name = 'versionint'";
$rec = $db->execute($sql);
$version = intval($rec->fields["config_value"]);

// check version
if (!($version == 5)){ die("You are not running version 1.0.4"); }

// make the configuration change
$sql = "UPDATE " . $dbprefix . "config SET config_name = 'virtualpath' WHERE config_name = 'rootpath'";
$db->execute($sql);

// run the update SQL
$sql = "UPDATE " . $dbprefix . "config SET config_value = '1.0.5' WHERE config_name = 'version'";
$db->execute($sql);

$sql = "UPDATE " . $dbprefix . "config SET config_value = 6 WHERE config_name = 'versionint'";
$db->execute($sql);

// and notify user
// Header("Location: from_1.0.3.php");
echo("Finished upgrade to latest version!");
?>