<?
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;
*/

// automatisch erstellte unnötige Gruppen löschen
$db = new Database ();
if ($db->query ("SELECT id, name FROM `{prefix}group` WHERE parent_group_id=0")) {
	foreach ($db->result as $row) {
		if (!$db->query ("SELECT id FROM `{prefix}group` WHERE parent_group_id={$row['id']}")) {
			//echo "{$row['id']} {$row['name']}<br>\n";
			$db->query ("DELETE FROM `{prefix}group` WHERE id={$row['id']}");
		}
	}
}


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");
	}
}

if (Setting::get ("db", "version") == "1.2") {
	echo "Update from DB-version 1.2<br>";
	
	$db = new Database ();
	$db->query ("ALTER TABLE `{prefix}group` ADD `link_group_name` varchar(100) NOT NULL AFTER `link_group_id`");
    if (!$db->errors &&  $db->query ("SELECT g1.id, g3.id AS link_id, g2.name AS link_name FROM `{prefix}group` g1, `{prefix}group` g2, `{prefix}group` g3 WHERE g1.link_group_id<0 AND g2.id = -g1.link_group_id AND g3.id = g2.parent_group_id")) {
        foreach ($db->result as $row) {
            $db->query ("UPDATE `{prefix}group` SET link_group_id={$row['link_id']}, link_group_name='{$row['link_name']}' WHERE id={$row['id']}");
        }
    }

	if (!$db->errors) {
		Setting::set ("db", "version", "1.3");
	}
}

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