<?
require_once ("../lib/setting.inc.php");

/*
// htmlentities nach utf-8 konvertieren
$db = new Database ();
if ($db->query ("SELECT id, text FROM {prefix}element")) {
	foreach ($db->result as $row) {
		$text = html_entity_decode ($row['text'], ENT_QUOTES, "UTF-8");
		$text = Database::escape ($text);
		$db->query ("UPDATE `{prefix}element` SET text='$text' WHERE id={$row['id']}");
	}
}
exit;
*/


if (Setting::get ("db", "version") == "1.0") {
	echo "Update from DB-version 1.0<br>";
	
	$db = new Database ();
 	$db->query ("CREATE TABLE `{prefix}sequence` (`id` int(11) NOT NULL auto_increment, `sequence` int(11) NOT NULL default '0', PRIMARY KEY (`id`)) DEFAULT CHARSET=utf8");
 	$db->query ("ALTER TABLE `{prefix}group` ADD `sequence_id` INT NOT NULL AFTER `sequence`");
	if (!$db->errors &&  $db->query ("SELECT id, sequence FROM `{prefix}group`")) {
		foreach ($db->result as $row) {
			$db->query ("INSERT INTO {prefix}sequence (sequence) VALUES ({$row['sequence']})");
			$sequence_id = $db->rowid;
			$db->query ("UPDATE `{prefix}group` SET sequence_id=$sequence_id WHERE id={$row['id']}");
		}
	}
	if (!$db->errors) {
		$db->query ("ALTER TABLE `{prefix}group` DROP `sequence`");
		Setting::set ("db", "version", "1.1");
	}
}

if (Setting::get ("db", "version") == "1.1") {
	echo "Update from DB-version 1.1<br>";
	
	$db = new Database ();
 	$db->query ("ALTER TABLE `{prefix}history` CHANGE `is_active` `status` TINYINT( 4 ) NOT NULL DEFAULT '0'");
	if (!$db->errors) {
		Setting::set ("db", "version", "1.2");
	}
}


echo "<br>DB-version is ".Setting::get ("db", "version");
?>