#------------------------------------------------------------------------------
# Copyright (C) 2001 Thomax Kaulmann
#
# This program is free software; you can redistribute it and/or modify
# it under the terms of the GNU General Public License as published by
# the Free Software Foundation; either version 2, or (at your option)
# any later version.
#
# This program is distributed in the hope that it will be useful,
# but WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
# GNU General Public License for more details.
#
# You should have received a copy of the GNU General Public License
# along with this program; if not, write to the Free Software
# Foundation, Inc., 675 Mass Ave, Cambridge, MA 02139, USA.

use lib '../oma-bin';
use OMA;

$db = OMA::opendb();

sub genkey {
    local $key;
    local @a;

    $key = time;
    $key = $key << 32;
    @a= unpack("C4",gethostbyname('meta.orang.org'));
    $key |= $a[0] << 24;
    $key |= $a[1] << 16;
    $key |= $a[2] << 8;
    $key |= $a[3];
	$key = $key >> 1;

    return($key);
}

$st = $db->prepare("select * from node order by sid");
$st->execute();
while(@row=$st->fetchrow()) {
	$ids[$i++] = $row[0];
}
$st->finish();

for($i=0;$i<=$#ids;$i++) {
	$old = $ids[$i];
	$new = sprintf("0x%llx",genkey());

print "$old ==> $new\n==================================\n";
	$ex = "update treemap set sid=$new where sid=$old and sid > 1";
	$st=$db->prepare($ex);
	$st->execute();
	print "$ex\n";

	$ex = "update template set node_sid=$new where node_sid=$old and node_sid > 1";
	$st=$db->prepare($ex);
	$st->execute();
	print "$ex\n";

	$ex = "update item set node_sid=$new where node_sid=$old and node_sid > 1";
	$st=$db->prepare($ex);
	$st->execute();
	print "$ex\n";

	$ex = "update node set prev_sid=$new where prev_sid=$old and prev_sid > 1";
	$st=$db->prepare($ex);
	$st->execute();
	print "$ex\n";

	$ex = "update node set sid=$new where sid=$old and sid > 1";
	$st=$db->prepare($ex);
	$st->execute();
	print "$ex\n\n\n";

	sleep(1);
}
